eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CN_EXT dependencies on PAY_CN_EXT

Line 1: PACKAGE BODY pay_cn_ext AS

1: PACKAGE BODY pay_cn_ext AS
2: /* $Header: pycnext.pkb 120.0.12010000.2 2008/08/06 07:02:52 ubhat ship $ */
3:
4: ----------------------------------------------------------------------------
5: -- --

Line 46: l_proc_name := 'pay_cn_ext.initialize_globals';

42: l_request_id NUMBER ;
43: --
44: BEGIN
45: --
46: l_proc_name := 'pay_cn_ext.initialize_globals';
47:
48: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
49:
50: l_request_id := fnd_global.conc_request_id;

Line 129: l_proc_name := 'pay_cn_ext.delete_globals';

125: l_request_id NUMBER ;
126: --
127: BEGIN
128: --
129: l_proc_name := 'pay_cn_ext.delete_globals';
130:
131: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
132:
133: l_request_id := fnd_global.conc_request_id;

Line 251: l_proc_name := 'pay_cn_ext.get_globals';

247:
248: --
249: BEGIN
250: --
251: l_proc_name := 'pay_cn_ext.get_globals';
252:
253: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
254:
255: l_request_id := fnd_global.conc_request_id;

Line 341: l_proc_name := 'pay_cn_ext.get_element_name';

337:
338: --
339: BEGIN
340: --
341: l_proc_name := 'pay_cn_ext.get_element_name';
342:
343: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
344:
345: -- Set l_element_name depending on the value of l_phf_si_type

Line 496: l_proc_name := 'pay_cn_ext.cb_extract_process';

492: --
493: --
494: BEGIN
495: --
496: l_proc_name := 'pay_cn_ext.cb_extract_process';
497:
498: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
499:
500: hr_utility.set_location('China : Before csr_extract_def_id ', 20);

Line 715: l_proc_name := 'pay_cn_ext.ca_extract_process';

711:
712: --
713: BEGIN
714: --
715: l_proc_name := 'pay_cn_ext.ca_extract_process';
716:
717: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
718:
719: hr_utility.set_location('China : Before csr_extract_def_id ', 20);

Line 867: l_proc_name := 'pay_cn_ext.em_extract_process';

863:
864: --
865: BEGIN
866: --
867: l_proc_name := 'pay_cn_ext.em_extract_process';
868:
869: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
870:
871: hr_utility.set_location('China : Before csr_extract_def_id ', 20);

Line 1030: l_proc_name := 'pay_cn_ext.cb_criteria_profile';

1026: --
1027: BEGIN
1028: --
1029: l_expat_indicator := 'Y';
1030: l_proc_name := 'pay_cn_ext.cb_criteria_profile';
1031: l_return_value := 'N';
1032:
1033: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
1034:

Line 1100: l_cont_area := pay_cn_ext.get_override_sic_code(l_element_name,p_assignment_id,p_date_earned);

1096: -- 3411840, Check the assignment's Override Contribution area is same as the concurrent parameter
1097: l_element_name := get_element_name(l_phf_si_type);
1098: hr_utility.set_location('China : l_element_name ->'|| l_element_name, 60);
1099:
1100: l_cont_area := pay_cn_ext.get_override_sic_code(l_element_name,p_assignment_id,p_date_earned);
1101: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 60);
1102:
1103: IF l_cont_area IS NULL THEN
1104: -- Check the assignment's Contribution area is same as the concurrent parameter

Line 1133: l_value := pay_cn_ext.get_element_entry(p_assignment_id, p_business_group_id,l_start_date,l_phf_si_type);

1129: --
1130: -- Bug 3415164
1131: -- Using Start Date as Effective Date
1132: --
1133: l_value := pay_cn_ext.get_element_entry(p_assignment_id, p_business_group_id,l_start_date,l_phf_si_type);
1134:
1135: -- If element entry for the given PHF/SI Type does not exist for the assignment
1136: -- then the assignment is not eligible
1137: IF l_value = 'N' THEN

Line 1153: l_value := pay_cn_ext.get_assignment_action(p_assignment_id, p_business_group_id,l_mod_start_date,l_mod_end_date);

1149:
1150: hr_utility.set_location('China : PREV_MONTH, l_mod_start_date '|| l_mod_start_date , 90);
1151: hr_utility.set_location('China : PREV_MONTH, l_mod_end_date '|| l_mod_end_date , 90);
1152:
1153: l_value := pay_cn_ext.get_assignment_action(p_assignment_id, p_business_group_id,l_mod_start_date,l_mod_end_date);
1154: IF l_value = 'N' THEN
1155: hr_utility.set_location('China : Assignment Actions not found ', 90);
1156: RETURN l_return_value;
1157: END IF;

Line 1262: l_proc_name := 'pay_cn_ext.ca_criteria_profile';

1258: BEGIN
1259: --
1260: l_expat_indicator := 'Y';
1261: l_return_value := 'N';
1262: l_proc_name := 'pay_cn_ext.ca_criteria_profile';
1263:
1264: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
1265:
1266: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 20);

Line 1333: l_cont_area := pay_cn_ext.get_override_sic_code(l_element_name,p_assignment_id,p_date_earned);

1329: l_element_name := get_element_name(l_phf_si_type);
1330:
1331: hr_utility.set_location('China : l_element_name ->'|| l_element_name , 90);
1332:
1333: l_cont_area := pay_cn_ext.get_override_sic_code(l_element_name,p_assignment_id,p_date_earned);
1334:
1335: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 90);
1336:
1337: IF l_cont_area IS NULL THEN

Line 1366: l_value := pay_cn_ext.get_element_entry(p_assignment_id, p_business_group_id,l_end_date,l_phf_si_type);

1362: -- in concurrent request
1363: -- Bug 3415164
1364: -- Using End Date as effective date
1365: --
1366: l_value := pay_cn_ext.get_element_entry(p_assignment_id, p_business_group_id,l_end_date,l_phf_si_type);
1367:
1368: -- If element entry for the given PHF/SI Type does not exist for the assignment
1369: -- then the assignment is not eligible
1370: IF l_value = 'N' THEN

Line 1378: l_value := pay_cn_ext.get_assignment_action(p_assignment_id, p_business_group_id,l_start_date,l_end_date);

1374: --
1375: END IF;
1376:
1377: -- Bug 3411273, Check whether assignment action ids exist
1378: l_value := pay_cn_ext.get_assignment_action(p_assignment_id, p_business_group_id,l_start_date,l_end_date);
1379: IF l_value = 'N' THEN
1380: hr_utility.set_location('China : Assignment Actions not found ', 80);
1381: RETURN l_return_value;
1382: END IF;

Line 1564: l_proc_name := 'pay_cn_ext.em_criteria_profile';

1560:
1561: --
1562: BEGIN
1563: --
1564: l_proc_name := 'pay_cn_ext.em_criteria_profile';
1565: l_expat_indicator := 'Y';
1566: l_return_value := 'N';
1567:
1568: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);

Line 1636: l_cont_area := pay_cn_ext.get_override_sic_code(l_element_name,p_assignment_id,p_date_earned);

1632: -- 3411840, Check the assignment's Override Contribution area is same as the concurrent parameter
1633: l_element_name := get_element_name(l_phf_si_type);
1634: hr_utility.set_location('China : l_element_name ->'|| l_element_name, 60);
1635:
1636: l_cont_area := pay_cn_ext.get_override_sic_code(l_element_name,p_assignment_id,p_date_earned);
1637: hr_utility.set_location('China : l_cont_area ->'|| l_cont_area, 60);
1638:
1639: IF l_cont_area IS NULL THEN
1640: -- Check the assignment's Contribution area is same as the concurrent parameter

Line 1666: l_value := pay_cn_ext.get_element_entry(p_assignment_id, p_business_group_id,l_end_date,l_phf_si_type);

1662:
1663: -- Check whether the element entries exist for the PHF/SI type given
1664: -- in concurrent request
1665: --
1666: l_value := pay_cn_ext.get_element_entry(p_assignment_id, p_business_group_id,l_end_date,l_phf_si_type);
1667:
1668: -- If element entry for the given PHF/SI Type does not exist for the assignment
1669: -- then the assignment is not eligible
1670: IF l_value = 'N' THEN

Line 1943: l_proc_name := 'pay_cn_ext.get_employer_info';

1939: -- Bug 3886228 Changes end
1940: --
1941: BEGIN
1942: --
1943: l_proc_name := 'pay_cn_ext.get_employer_info';
1944: l_return_value:= NULL;
1945:
1946: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
1947: hr_utility.set_location('China : Info Type-> '||p_info_type, 10);

Line 2358: l_proc_name := 'pay_cn_ext.get_employee_info';

2354: -- Bug 3886228 Changes end
2355: --
2356: BEGIN
2357: --
2358: l_proc_name := 'pay_cn_ext.get_employee_info';
2359: l_return_value := NULL;
2360:
2361: hr_utility.set_location('China : Entering -> '||l_proc_name, 10);
2362: hr_utility.set_location('China : Assignment ID -> '||p_assignment_id, 10);

Line 2658: l_proc_name := 'pay_cn_ext.get_balance_value';

2654:
2655: --
2656: BEGIN
2657: --
2658: l_proc_name := 'pay_cn_ext.get_balance_value';
2659: l_bal_value :=0;
2660:
2661: hr_utility.set_location('China Entering -> ' || l_proc_name , 10);
2662: hr_utility.set_location('China p_assignment_id -> ' || p_assignment_id , 10);

Line 2880: l_proc_name := 'pay_cn_ext.get_element_entry';

2876:
2877: --
2878: BEGIN
2879: --
2880: l_proc_name := 'pay_cn_ext.get_element_entry';
2881: l_return_value := 'N';
2882:
2883: hr_utility.set_location('China : Entering -> ' || l_proc_name , 10);
2884: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 10);

Line 2997: l_proc_name := 'pay_cn_ext.get_override_sic_code';

2993:
2994: --
2995: BEGIN
2996: --
2997: l_proc_name := 'pay_cn_ext.get_override_sic_code';
2998:
2999: hr_utility.set_location('China : Entering -> ' || l_proc_name , 10);
3000: hr_utility.set_location('China : p_element_name -> ' || p_element_name , 10);
3001: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 10);

Line 3094: l_proc_name := 'pay_cn_ext.get_assignment_action';

3090: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
3091:
3092: BEGIN
3093:
3094: l_proc_name := 'pay_cn_ext.get_assignment_action';
3095: l_return_value := 'N';
3096:
3097: hr_utility.set_location('China : Entering -> ' || l_proc_name , 10);
3098: hr_utility.set_location('China : p_assignment_id -> ' || p_assignment_id , 10);

Line 3133: END pay_cn_ext;

3129: END get_assignment_action;
3130:
3131:
3132: --
3133: END pay_cn_ext;