APPS.PQP_PRORATION_WRAPPER dependencies on PAY_DB_PAY_SETUP

Line 518: l_ele_id := pay_db_pay_setup.create_element(

514:
515: IF (l_count = 0) THEN
516: hr_utility.trace('If condition ... Creating Element');
517:
518: l_ele_id := pay_db_pay_setup.create_element(
519: p_element_name => l_modified_base_ele || ' sal ele'
520: ,p_description => 'Element to prorate the salary'
521: ,p_reporting_name => SUBSTR(sal_rep_name, 1, 80)
522: ,p_classification_name => 'Earnings'

Line 551: l_ipv_as := pay_db_pay_setup.create_input_value(

547: END LOOP;
548:
549: IF (l_ipv_as IS NULL) THEN
550: hr_utility.trace('If condition ... Creating Input Value');
551: l_ipv_as := pay_db_pay_setup.create_input_value(
552: p_element_name => l_modified_base_ele || ' sal ele'
553: ,p_name => 'Amount'
554: ,p_uom_code => 'M'
555: ,p_mandatory_flag => 'X'

Line 582: l_ele_id_scot := pay_db_pay_setup.create_element(

578:
579: IF (l_count = 0) THEN
580: hr_utility.trace('If condition ... create element');
581:
582: l_ele_id_scot := pay_db_pay_setup.create_element(
583: p_element_name => l_modified_base_ele || ' sal ele1'
584: ,p_description => 'Element to prorate the salary'
585: ,p_reporting_name => SUBSTR(sal_rep_name, 1, 80)
586: ,p_classification_name => 'Earnings'

Line 613: l_ipv_as := pay_db_pay_setup.create_input_value(

609: END LOOP;
610:
611: IF (l_ipv_as IS NULL) THEN
612: hr_utility.trace('If condition ... create input value');
613: l_ipv_as := pay_db_pay_setup.create_input_value(
614: p_element_name => l_modified_base_ele || ' sal ele1'
615: ,p_name => 'Amount'
616: ,p_uom_code => 'M'
617: ,p_mandatory_flag => 'X'

Line 990: l_ele_id := pay_db_pay_setup.create_element(

986:
987: IF (l_count = 0) THEN
988: hr_utility.trace('If condition ... creating elements');
989:
990: l_ele_id := pay_db_pay_setup.create_element(
991: p_element_name => l_modified_base_ele || ' grade ele'
992: ,p_description => 'Element to prorate the Grades'
993: ,p_reporting_name => grade_rep_name
994: ,p_classification_name => 'Earnings'

Line 1042: pay_db_pay_setup.set_session_date(trunc(sysdate));

1038: l_count := cetei.count;
1039: END LOOP;
1040: IF (l_count = 0 ) THEN
1041: hr_utility.trace('If condition ...creating element extra info');
1042: pay_db_pay_setup.set_session_date(trunc(sysdate));
1043: l_etei_id := NULL;
1044: l_etei_ovn := NULL;
1045: pay_element_extra_info_api.create_element_extra_info
1046: ( p_element_type_id => l_ele_id

Line 1063: pay_db_pay_setup.set_session_date(trunc(sysdate));

1059: -- 'No' Service History
1060: );
1061: ELSE
1062: hr_utility.trace('Else condition..updating element extra info');
1063: pay_db_pay_setup.set_session_date(trunc(sysdate));
1064: l_etei_id := NULL;
1065: l_etei_ovn := NULL;
1066: FOR cetei1 IN c_element_extra_info_id(l_ele_id)
1067: LOOP

Line 1362: l_ele_id := pay_db_pay_setup.create_element(

1358:
1359: IF (l_count = 0) THEN
1360: hr_utility.trace('If condition ...creating element');
1361:
1362: l_ele_id := pay_db_pay_setup.create_element(
1363: p_element_name => l_modified_base_ele || ' payscale ele'
1364: ,p_description => 'Element to prorate the Pay Scale'
1365: ,p_reporting_name => ps_rep_name
1366: ,p_classification_name => 'Earnings'

Line 1422: pay_db_pay_setup.set_session_date(trunc(sysdate));

1418: IF (l_count = 0) THEN
1419: hr_utility.trace('If condition ...creating element extra info');
1420: l_etei_id := NULL;
1421: l_etei_ovn := NULL;
1422: pay_db_pay_setup.set_session_date(trunc(sysdate));
1423: pay_element_extra_info_api.create_element_extra_info
1424: ( p_element_type_id => l_ele_id
1425: ,p_information_type => 'PQP_UK_ELEMENT_ATTRIBUTION'
1426: ,p_eei_information_category => 'PQP_UK_ELEMENT_ATTRIBUTION'

Line 1442: pay_db_pay_setup.set_session_date(trunc(sysdate));

1438: );
1439: hr_utility.trace('The extra info id is '|| TO_CHAR(l_etei_id));
1440: ELSE
1441: hr_utility.trace('Else condition..updating element extra info');
1442: pay_db_pay_setup.set_session_date(trunc(sysdate));
1443: l_etei_id := NULL;
1444: l_etei_ovn := NULL;
1445: FOR cetei1 IN c_element_extra_info_id(l_ele_id)
1446: LOOP

Line 2000: l_ele_id := pay_db_pay_setup.create_element(

1996: END LOOP;
1997:
1998: hr_utility.trace('Creating element ' );
1999:
2000: l_ele_id := pay_db_pay_setup.create_element(
2001: p_element_name => LTRIM(RTRIM(p_ele_name))
2002: ,p_description => p_ele_desc
2003: ,p_reporting_name => p_ele_repname
2004: ,p_classification_name => l_primary_class_name

Line 2033: l_ipv_as := pay_db_pay_setup.create_input_value(

2029: IF (l_ipv_as IS NULL) THEN
2030:
2031: hr_utility.trace('If condition ... Creating input value ');
2032:
2033: l_ipv_as := pay_db_pay_setup.create_input_value(
2034: p_element_name => p_ele_name
2035: ,p_name => 'Amount'
2036: ,p_uom_code => 'M'
2037: ,p_mandatory_flag => 'X'

Line 2067: pay_db_pay_setup.set_session_date(trunc(sysdate));

2063: IF (l_count = 0) THEN
2064:
2065: hr_utility.trace('If condition ... Creating element extra info' );
2066:
2067: pay_db_pay_setup.set_session_date(trunc(sysdate));
2068: pay_element_extra_info_api.create_element_extra_info
2069: ( p_element_type_id => l_ele_id
2070: ,p_information_type => 'PQP_UK_ELEMENT_ATTRIBUTION'
2071: ,p_eei_information_category => 'PQP_UK_ELEMENT_ATTRIBUTION'

Line 2086: pay_db_pay_setup.set_session_date(trunc(sysdate));

2082: -- 'No' Service History */
2083: );
2084: ELSE
2085: hr_utility.trace('Else condition..updating element extra info');
2086: pay_db_pay_setup.set_session_date(trunc(sysdate));
2087: l_etei_id := NULL;
2088: l_etei_ovn := NULL;
2089: FOR cetei1 IN c_element_extra_info_id(l_ele_id)
2090: LOOP

Line 2163: l_ipv_as := pay_db_pay_setup.create_input_value(

2159: LOOP
2160: l_formula_id := cfi.formula_id;
2161: END LOOP;
2162: hr_utility.trace('Creating input value');
2163: l_ipv_as := pay_db_pay_setup.create_input_value(
2164: p_element_name => LTRIM(RTRIM(p_ele_name_ipv))
2165: ,p_name => SUBSTR(LTRIM(RTRIM(p_ipvalue_name)),
2166: 1, 80)
2167: ,p_uom_code => p_ipvalue_uom