DBA Data[Home] [Help]

APPS.PQP_GB_GAP_BEN_FORMULAS dependencies on STANDARD

Line 1157: '_OSP_STANDARD_RATES_CALCULATION_METHOD_VALUE_RULE'

1153: l_formula_name:= -- VARCHAR2(80)
1154: SUBSTRB(l_base_name||
1155: -- 1 2 3 4 5
1156: --12345678901234567890123456789012345678901234567890
1157: '_OSP_STANDARD_RATES_CALCULATION_METHOD_VALUE_RULE'
1158: --||l_uniquestamp
1159: ,1,80);
1160: debug(l_proc_name,62);
1161: l_formula_type:= -- VARCHAR2(80)

Line 1164: 'Sample OSP rule for a benefits standard rate to calculate length of'||

1160: debug(l_proc_name,62);
1161: l_formula_type:= -- VARCHAR2(80)
1162: 'Rate Value Calculation';
1163: l_description:= -- VARCHAR2(240)
1164: 'Sample OSP rule for a benefits standard rate to calculate length of'||
1165: ' service.';
1166:
1167: debug(l_proc_name,65);
1168: l_text:='

Line 1171: Formula Name: PQP_GB_BEN_OSP_STANDARD_RATES_CALCULATION_METHOD_VALUE_RULE

1167: debug(l_proc_name,65);
1168: l_text:='
1169: /*==============================================================================
1170: $Header: pqpgbofm.pkb 120.1 2005/10/04 08:31:03 rrazdan noship $
1171: Formula Name: PQP_GB_BEN_OSP_STANDARD_RATES_CALCULATION_METHOD_VALUE_RULE
1172: Formula Type: Rate Value Calculation
1173: Description : Sample OSP rule for a benefits standard rate to calculate length
1174: of service.
1175:

Line 1173: Description : Sample OSP rule for a benefits standard rate to calculate length

1169: /*==============================================================================
1170: $Header: pqpgbofm.pkb 120.1 2005/10/04 08:31:03 rrazdan noship $
1171: Formula Name: PQP_GB_BEN_OSP_STANDARD_RATES_CALCULATION_METHOD_VALUE_RULE
1172: Formula Type: Rate Value Calculation
1173: Description : Sample OSP rule for a benefits standard rate to calculate length
1174: of service.
1175:
1176: DISCLAIMER :
1177: In future releases of HRMS programs, Oracle Corporation may change or

Line 1200: Initialise standard default values.

1196: DEFAULT FOR BEN_ABS_DATE_START IS ''1951/01/01 00:00:00''(date)
1197: DEFAULT FOR EMP_HIRE_DATE IS ''1951/01/01 00:00:00''(date)
1198:
1199: /*
1200: Initialise standard default values.
1201: */
1202: l_null = RPAD(''X'',0,''Y'')
1203: l_default = ''_DEFAULT_''
1204: l_default_date = ''1951/01/01 00:00:00''(date)

Line 1321: '_OSP_STANDARD_RATES_GENERAL_EXTRA_INPUT_RULE'

1317: l_formula_name:= -- VARCHAR2(80)
1318: SUBSTRB(l_base_name||
1319: -- 1 2 3 4 5
1320: --12345678901234567890123456789012345678901234567890
1321: '_OSP_STANDARD_RATES_GENERAL_EXTRA_INPUT_RULE'
1322: --||l_uniquestamp
1323: ,1,80);
1324: debug(l_proc_name,72);
1325: l_formula_type:= -- VARCHAR2(80)

Line 1328: 'Sample OSP rule for a benefits standard rate to feed extra input'||

1324: debug(l_proc_name,72);
1325: l_formula_type:= -- VARCHAR2(80)
1326: 'Extra Input'; -- to change with new formula type ??BEN??
1327: l_description:= -- VARCHAR2(240)
1328: 'Sample OSP rule for a benefits standard rate to feed extra input'||
1329: ' values to an element entry.';
1330:
1331: debug(l_proc_name,75);
1332: l_text:='

Line 1335: Formula Name: PQP_GB_BEN_OSP_STANDARD_RATES_GENERAL_EXTRA_INPUT_RULE

1331: debug(l_proc_name,75);
1332: l_text:='
1333: /*==============================================================================
1334: $Header: pqpgbofm.pkb 120.1 2005/10/04 08:31:03 rrazdan noship $
1335: Formula Name: PQP_GB_BEN_OSP_STANDARD_RATES_GENERAL_EXTRA_INPUT_RULE
1336: Formula Type: Rate Value Calculation
1337: Description : Sample OSP rule for a benefits standard rate to feed extra input
1338: values to an element entry.
1339:

Line 1337: Description : Sample OSP rule for a benefits standard rate to feed extra input

1333: /*==============================================================================
1334: $Header: pqpgbofm.pkb 120.1 2005/10/04 08:31:03 rrazdan noship $
1335: Formula Name: PQP_GB_BEN_OSP_STANDARD_RATES_GENERAL_EXTRA_INPUT_RULE
1336: Formula Type: Rate Value Calculation
1337: Description : Sample OSP rule for a benefits standard rate to feed extra input
1338: values to an element entry.
1339:
1340: DISCLAIMER :
1341: In future releases of HRMS programs, Oracle Corporation may change or

Line 1479: Initialise standard default values.

1475: */
1476:
1477:
1478: /*
1479: Initialise standard default values.
1480: */
1481: l_null = RPAD(''X'',0,''Y'')
1482: l_default = ''_DEFAULT_''
1483: l_default_date = ''1951/01/01 00:00:00''(date)

Line 1547: which the asscoiated standard rate feeds.

1543:
1544: NOTE
1545: SUBPRIORITY - is a reserved return value name for this formula type.
1546: This value is used the populate the Subpriority field of the element entry,
1547: which the asscoiated standard rate feeds.
1548:
1549: Element entry subpriority is used to control the processing order of entries
1550: of element types with multiple entries allowed.
1551:

Line 1828: '_OMP_STANDARD_RATES_CALCULATION_METHOD_VALUE_RULE'

1824: l_formula_name:= -- VARCHAR2(80)
1825: SUBSTRB(l_base_name||
1826: -- 1 2 3 4 5
1827: --12345678901234567890123456789012345678901234567890
1828: '_OMP_STANDARD_RATES_CALCULATION_METHOD_VALUE_RULE'
1829: --||l_uniquestamp
1830: ,1,80);
1831: debug(l_proc_name,92);
1832: l_formula_type:= -- VARCHAR2(80)

Line 1835: 'Sample OMP rule for a benefits standard rate to calculate length of'||

1831: debug(l_proc_name,92);
1832: l_formula_type:= -- VARCHAR2(80)
1833: 'Rate Value Calculation';
1834: l_description:= -- VARCHAR2(240)
1835: 'Sample OMP rule for a benefits standard rate to calculate length of'||
1836: ' service.';
1837: debug(l_proc_name,95);
1838: l_text:='
1839: /*==============================================================================

Line 1841: Formula Name: PQP_GB_BEN_OMP_STANDARD_RATES_CALCULATION_METHOD_VALUE_RULE

1837: debug(l_proc_name,95);
1838: l_text:='
1839: /*==============================================================================
1840: $Header: pqpgbofm.pkb 120.1 2005/10/04 08:31:03 rrazdan noship $
1841: Formula Name: PQP_GB_BEN_OMP_STANDARD_RATES_CALCULATION_METHOD_VALUE_RULE
1842: Formula Type: Rate Value Calculation
1843: Description : Sample OMP rule for a benefits standard rate to calculate length
1844: of service.
1845:

Line 1843: Description : Sample OMP rule for a benefits standard rate to calculate length

1839: /*==============================================================================
1840: $Header: pqpgbofm.pkb 120.1 2005/10/04 08:31:03 rrazdan noship $
1841: Formula Name: PQP_GB_BEN_OMP_STANDARD_RATES_CALCULATION_METHOD_VALUE_RULE
1842: Formula Type: Rate Value Calculation
1843: Description : Sample OMP rule for a benefits standard rate to calculate length
1844: of service.
1845:
1846: DISCLAIMER :
1847: In future releases of HRMS programs, Oracle Corporation may change or

Line 1870: Initialise standard default values.

1866: DEFAULT FOR BEN_ABS_DATE_START IS ''1951/01/01 00:00:00''(date)
1867: DEFAULT FOR EMP_HIRE_DATE IS ''1951/01/01 00:00:00''(date)
1868:
1869: /*
1870: Initialise standard default values.
1871: */
1872: l_null = RPAD(''X'',0,''Y'')
1873: l_default = ''_DEFAULT_''
1874: l_default_date = ''1951/01/01 00:00:00''(date)

Line 2168: '_OMP_STANDARD_RATES_GENERAL_EXTRA_INPUT_RULE'

2164: l_formula_name:= -- VARCHAR2(80)
2165: SUBSTRB(l_base_name||
2166: -- 1 2 3 4 5
2167: --12345678901234567890123456789012345678901234567890
2168: '_OMP_STANDARD_RATES_GENERAL_EXTRA_INPUT_RULE'
2169: --||l_uniquestamp
2170: ,1,80);
2171:
2172: debug(l_proc_name,102);

Line 2176: 'Sample OMP rule for a benefits standard rate to feed extra input'||

2172: debug(l_proc_name,102);
2173: l_formula_type:= -- VARCHAR2(80)
2174: 'Extra Input'; -- to change with new formula type ??BEN?? -- done
2175: l_description:= -- VARCHAR2(240)
2176: 'Sample OMP rule for a benefits standard rate to feed extra input'||
2177: ' values to an element entry.';
2178:
2179: debug(l_proc_name,105);
2180: l_text:='

Line 2183: Formula Name: PQP_GB_BEN_OMP_STANDARD_RATES_GENERAL_EXTRA_INPUT_RULE

2179: debug(l_proc_name,105);
2180: l_text:='
2181: /*==============================================================================
2182: $Header: pqpgbofm.pkb 120.1 2005/10/04 08:31:03 rrazdan noship $
2183: Formula Name: PQP_GB_BEN_OMP_STANDARD_RATES_GENERAL_EXTRA_INPUT_RULE
2184: Formula Type: Rate Value Calculation
2185: Description : Sample OMP rule for a benefits standard rate to feed extra input
2186: values to an element entry.
2187:

Line 2185: Description : Sample OMP rule for a benefits standard rate to feed extra input

2181: /*==============================================================================
2182: $Header: pqpgbofm.pkb 120.1 2005/10/04 08:31:03 rrazdan noship $
2183: Formula Name: PQP_GB_BEN_OMP_STANDARD_RATES_GENERAL_EXTRA_INPUT_RULE
2184: Formula Type: Rate Value Calculation
2185: Description : Sample OMP rule for a benefits standard rate to feed extra input
2186: values to an element entry.
2187:
2188: DISCLAIMER :
2189: In future releases of HRMS programs, Oracle Corporation may change or

Line 2327: Initialise standard default values.

2323: ,BEN_ABS_IV_ABS_INFORMATION7(TEXT)
2324: */
2325:
2326: /*
2327: Initialise standard default values.
2328: */
2329: l_null = RPAD(''X'',0,''Y'')
2330: l_default = ''_DEFAULT_''
2331: l_default_date = ''1951/01/01 00:00:00''(date)

Line 2419: which the asscoiated standard rate feeds.

2415:
2416: NOTE
2417: SUBPRIORITY - is a reserved return value name for this formula type.
2418: This value is used the populate the Subpriority field of the element entry,
2419: which the asscoiated standard rate feeds.
2420:
2421: Element entry subpriority is used to control the processing order of
2422: entries of element types with multiple entries allowed.
2423:

Line 2589: 'STANDARD_RATES_CALCULATION_METHOD_VALUE_RULE';

2585:
2586: debug(l_proc_name,40);
2587:
2588: l_formula_name := l_formula_name_prefix||
2589: 'STANDARD_RATES_CALCULATION_METHOD_VALUE_RULE';
2590: debug(l_formula_name);
2591:
2592: FOR l_formula IN csr_get_formula_id(p_business_group_id,l_formula_name)
2593: LOOP

Line 2606: 'STANDARD_RATES_GENERAL_EXTRA_INPUT_RULE';

2602:
2603: debug(l_proc_name,50);
2604:
2605: l_formula_name := l_formula_name_prefix||
2606: 'STANDARD_RATES_GENERAL_EXTRA_INPUT_RULE';
2607: debug(l_formula_name);
2608:
2609: FOR l_formula IN csr_get_formula_id(p_business_group_id,l_formula_name)
2610: LOOP