Concurrent Program Parameters Default Type and Default Value

Concurrent Program Parameters Window Details:

Concurrent program can have parameter values which can be entered by the user at run time. All the parameters to be passed to a concurrent program need to be defined with the concurrent program.
Concurrent Program Parameters window contains the following fields:

1) Sequence
Enter sequence numbers that specify the order in which your program receives parameter values from the concurrent manager.

2) Parameter
Specify Name of the Parameter.

3) Description
Description of the Parameter.

4) Enabled
When checked, parameter is enabled. Disabled parameters do not display at request submission time

5) Validation

(i)  Value Set
Each Parameter should have a value set. It can be user defined value set or one of the standard values set available in Oracle Apps.

 (ii) Description
this is defaulted when Value Set is selected

6) Required:- When this is checked, the parameter is mandatory and must be entered during program submission.

7) Display:- When this check-box is checked, the parameter will be displayed during program submission.

8) Display Size: - Size of the Display field.

9) Prompt: - Prompt for the parameter that will appear for parameter name when running the concurrent program.

10) Token: - Name of the token. This is used when registering Oracle Report
as a concurrent program. The name of this field is same as the token defined in the report.

Concurrent Program Parameters Default Type and Default Value Details:
 When it is required to default value of the parameter, the fields default type and default values can be selected. The possible values of default type field are:

1) Profile
When Profile is selected in Default type; the profile option name should be entered in the default value field. Use the profile option name.
For example, for getting operating unit (profile ‘MO: Operating Unit’), we can enter ORG_ID in the default value field.

2) SQL Statement
When SQL Statement is selected in Default type, any SQL statement can be written in the default value field.
SQL statement must return exactly one row and one column in all cases.

3) Current Date
When Current Date is selected in Default Type, then default value will be non-enterable. The current date will be automatically defaulted when running the program.
The default value is the current date in the format DD-MON-YY or DD-MON-YYYY,
depending on the length of the segment.
Maximum              Date

Size                        Format

9                             DD-MON-YY

11                           DD-MON-YYYY

4) Segment
the default value is the value entered in a prior segment of the same parameter window.
5) Constant

When Constant is selected in Default Type, any constant value can be entered in Default value field.

6) Current Time         the default value is the current time or the current date and time, depending on the length of the segment.
Maximum       Time
Size                  Format
5                      HH24:MI
8                      HH24:MI:SS
15                    DD-MON-YY HH24:MI
17                    DD-MON-YYYY HH24:MI
18                    DD-MON-YY HH24:MI:SS
20                    DD-MON-YYYY HH24:MI:SS

Function to display Amount in Word

function XXSPELLNUMBER( p_number in number )
  return varchar2
  as
    v_to_words varchar2(20000);
  begin
SELECT  initcap(decode(sign(((trunc(p_number)) - mod(trunc(p_number),10000000)) / 10000000),
                -1, ' ',
                 0,' ',
   to_char(to_date(lpad(substr(to_char(((trunc(p_number)) - mod(trunc(p_number),10000000)) /10000000),1,4),4,'0'),'yyyy'),'YEAR') || ' CRORE ') ||
         decode(((mod(trunc(p_number), 10000000) - mod(trunc(p_number),100000)) / 100000),
                 0, '',
   to_char(to_date(lpad(substr(to_char((mod(trunc(p_number),10000000) -
  mod(trunc(p_number),100000)) /100000),1,2),4,'0'),'yyyy'),
                 'YEAR') || ' LAKH ') ||
         decode(((mod(trunc(p_number), 100000) - mod(trunc(p_number),1000)) / 1000),
                 0, '', to_char(to_date(lpad(substr(to_char((mod(trunc(p_number),100000) - mod(trunc(p_number),1000)) /
1000),1,2),4,'0'),'yyyy'),'YEAR') || ' THOUSAND ') ||
         decode(((mod(trunc(p_number), 1000) - mod(trunc(p_number),100)) /100),
                 0, '', to_char(to_date(lpad(substr(to_char
               ((mod(trunc(p_number),1000) - mod(trunc(p_number),100)) /100),1,1),4,'0'),'yyyy'),
                 'YEAR') || ' HUNDRED ') ||
         decode(((mod(trunc(p_number), 100) - mod(trunc(p_number),1)) / 1),
                 0, '', to_char(to_date(lpad(substr(to_char
               ((mod(trunc(p_number),100) - mod(trunc(p_number),1)) /1),1,2),4,'0'),'yyyy'),
                 'YEAR')) ||
    decode((p_number * 100 - trunc(p_number) * 100),0,' ',', AND PAISE '||
               to_char(to_date(lpad(substr(to_char(p_number * 100 -trunc(p_number) * 100),1,2),4,'0'),'yyyy'),'YEAR')
               )) || ' only ' final
 INTO v_to_words
 FROM dual;
 return (v_to_words);
 end;