In a recent project the instruction was to validate a telephone input field. Simple enough you might think in peoplecode?

The answer is actually yes, but searching for a reference code I quickly discovered this has not been done a lot in peoplecode. So I decide to share a solution code snippets in contrast to Javascript en Java validation of which I have a relative experience.

 

The code snippet in the image uses a regex (Regular Expressions) used in both Javascript en Java to do sophisticated pattern matching, which can often be helpful in form validation. Which can be used to check whether a phone number or an email address entered into a form field is syntactically correct.

Code: http://blog.stevenlevithan.com/archives/validate-phone-number

 

 

 

 

 

 

 

 

 

The regex imports the regex Java class and uses it in the same way as Javascript.

Code: http://www.mkyong.com/java/how-do-validate-phone-number-in-java-regular-expression/

 

 

To replicate the above Javascript and Java phone validation code in peoplecode, the checks below was built into the phone field of the Component.

Note: The format below took account of not so standard numbers like 09000-000 etc. So it still depends on you to determine the required format and adjust the code accordingly.

 

 

1. Login to the database using Toad, and create a job as follows

 

2. Specify first Execution and subsequent executions as follows and type the SQL in “What to execute text box”

 

3. Following is the PL/SQL for job scheduler to execute the SQL command once on the first of each month

 

4. Following is the SQL which was scheduled

 

 

 

 

 

5. Complete code

DECLARE

X NUMBER;

BEGIN

SYS.DBMS_JOB.SUBMIT

(

job => X

,what => ‘delete from table_name

where date_column <= to_date(”” 01-01-2009 ””,””dd-mm-yyyy””);’

,next_date => to_date(’09/09/2009 00:14:10′,’mm/dd/yyyy hh24:mi:ss’)

,interval => ‘TRUNC(LAST_DAY(SYSDATE)) + 1′

,no_parse => FALSE

);

:JobNumber := to_char(X);

END;

Although there is much information available online about Oracle products, it’s shattered all over the internet and Google will help you only to a certain point.
So we’ve put together a list of some fine resources for your daily PeopleSoft, E-Business Suite and Siebel needs.
This ‘ultimate collection’ is the first one a series of three and it’s loaded with every PeopleSoft link you may ever need!