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_NO_RULES dependencies on PAY_NO_RULES

Line 1: package body PAY_NO_RULES as

1: package body PAY_NO_RULES as
2: /* $Header: pynorule.pkb 120.18.12020000.2 2012/11/22 06:19:07 smeduri ship $ */
3: -----------------------------------------------------------------------------
4: -- GET_MAIN_TAX_UNIT_ID fetches the Legal Employer Id of the Local Unit
5: -- of the Assignment Id

Line 88: hr_utility.set_location('pay_no_rules.get_source_text_context',1);

84: BEGIN
85: --
86: l_tax_municipality := null;
87: --
88: hr_utility.set_location('pay_no_rules.get_source_text_context',1);
89: --
90: OPEN csr_get_tax_municipality(p_asg_act_id);
91: FETCH csr_get_tax_municipality INTO l_tax_municipality;
92: CLOSE csr_get_tax_municipality;

Line 96: hr_utility.set_location('pay_no_rules.get_source_text_context='|| p_source_text,2);

92: CLOSE csr_get_tax_municipality;
93: --
94: p_source_text := NVL(l_tax_municipality,' ');
95: --
96: hr_utility.set_location('pay_no_rules.get_source_text_context='|| p_source_text,2);
97: --
98: END get_source_text_context;
99: */
100:

Line 376: hr_utility.set_location('pay_no_rules.get_source_context',1);

372: BEGIN
373: --
374: l_local_unit:= null;
375: --
376: hr_utility.set_location('pay_no_rules.get_source_context',1);
377: --
378: OPEN csr_get_local_unit(p_asg_act_id);
379: FETCH csr_get_local_unit INTO l_local_unit;
380: CLOSE csr_get_local_unit;

Line 384: hr_utility.set_location('pay_no_rules.get_source_context='|| p_source_id,2);

380: CLOSE csr_get_local_unit;
381: --
382: p_source_id := NVL(l_local_unit,' ');
383: --
384: hr_utility.set_location('pay_no_rules.get_source_context='|| p_source_id,2);
385: --
386: END get_source_context;
387: --
388: */

Line 416: hr_utility.set_location('pay_no_rules.get_main_local_unit_id',1);

412: BEGIN
413: --
414: l_local_unit:= null;
415: --
416: hr_utility.set_location('pay_no_rules.get_main_local_unit_id',1);
417: --
418: OPEN csr_get_local_unit(p_assignment_id);
419: FETCH csr_get_local_unit INTO l_local_unit;
420: CLOSE csr_get_local_unit;

Line 424: hr_utility.set_location('pay_no_rules.get_main_local_unit_id='|| p_local_unit_id,2);

420: CLOSE csr_get_local_unit;
421: --
422: p_local_unit_id := NVL(l_local_unit,0);
423: --
424: hr_utility.set_location('pay_no_rules.get_main_local_unit_id='|| p_local_unit_id,2);
425: --
426: END get_main_local_unit_id;
427: ------------------------------------------------------------------------------------------
428: PROCEDURE get_default_jurisdiction(p_asg_act_id NUMBER,

Line 576: hr_utility.set_location('pay_no_rules.get_default_jurisdiction',1);

572: BEGIN
573: --
574: l_tax_municipality := null;
575: --
576: hr_utility.set_location('pay_no_rules.get_default_jurisdiction',1);
577: --
578: -- BUG fix 4474253, commenting old cursor call
579: /*
580: OPEN csr_get_tax_municipality(p_asg_act_id);

Line 625: hr_utility.set_location('pay_no_rules.get_default_jurisdiction='|| p_jurisdiction,2);

621: --
622: p_jurisdiction := NVL(l_tax_municipality,' ');
623:
624: --
625: hr_utility.set_location('pay_no_rules.get_default_jurisdiction='|| p_jurisdiction,2);
626: --
627: END get_default_jurisdiction;
628: --
629: --------------------------------------------------------------------------------

Line 995: hr_utility.trace('Entering Pay_NO_RULES.add_custom_xml');

991:
992: BEGIN
993:
994: --hr_utility.trace_on(null,'no_payslip');
995: hr_utility.trace('Entering Pay_NO_RULES.add_custom_xml');
996: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
997: hr_utility.trace('p_action_information_category '|| p_action_information_category);
998: hr_utility.trace('p_document_type '|| p_document_type);
999:

Line 1316: build_sql(sqlstr, l_cntr_sql, ' Begin FOR run_types_rec IN pay_no_rules.csr_run_types ('||p_assignment_action_id||') LOOP ');

1312: --
1313: l_cntr_sql := 1;
1314:
1315: -- new
1316: build_sql(sqlstr, l_cntr_sql, ' Begin FOR run_types_rec IN pay_no_rules.csr_run_types ('||p_assignment_action_id||') LOOP ');
1317: build_sql(sqlstr, l_cntr_sql, ' FOR csr_balance_info_rec IN pay_no_rules.csr_balance_info (run_types_rec.assignment_action_id,''EMEA BALANCE DEFINITION'',''EMEA BALANCES'') LOOP ');
1318: -- end new
1319: -- build_sql(sqlstr, l_cntr_sql, ' Begin FOR csr_balance_info_rec IN pay_no_rules.csr_balance_info ('||p_assignment_action_id||',''EMEA BALANCE DEFINITION'',''EMEA BALANCES'') LOOP ');
1320: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) := pay_no_rules.load_xml(''CS'', NULL, ''BALANCE DETAILS'', NULL); ');

Line 1317: build_sql(sqlstr, l_cntr_sql, ' FOR csr_balance_info_rec IN pay_no_rules.csr_balance_info (run_types_rec.assignment_action_id,''EMEA BALANCE DEFINITION'',''EMEA BALANCES'') LOOP ');

1313: l_cntr_sql := 1;
1314:
1315: -- new
1316: build_sql(sqlstr, l_cntr_sql, ' Begin FOR run_types_rec IN pay_no_rules.csr_run_types ('||p_assignment_action_id||') LOOP ');
1317: build_sql(sqlstr, l_cntr_sql, ' FOR csr_balance_info_rec IN pay_no_rules.csr_balance_info (run_types_rec.assignment_action_id,''EMEA BALANCE DEFINITION'',''EMEA BALANCES'') LOOP ');
1318: -- end new
1319: -- build_sql(sqlstr, l_cntr_sql, ' Begin FOR csr_balance_info_rec IN pay_no_rules.csr_balance_info ('||p_assignment_action_id||',''EMEA BALANCE DEFINITION'',''EMEA BALANCES'') LOOP ');
1320: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) := pay_no_rules.load_xml(''CS'', NULL, ''BALANCE DETAILS'', NULL); ');
1321: FOR cntr in 1..30 LOOP

Line 1319: -- build_sql(sqlstr, l_cntr_sql, ' Begin FOR csr_balance_info_rec IN pay_no_rules.csr_balance_info ('||p_assignment_action_id||',''EMEA BALANCE DEFINITION'',''EMEA BALANCES'') LOOP ');

1315: -- new
1316: build_sql(sqlstr, l_cntr_sql, ' Begin FOR run_types_rec IN pay_no_rules.csr_run_types ('||p_assignment_action_id||') LOOP ');
1317: build_sql(sqlstr, l_cntr_sql, ' FOR csr_balance_info_rec IN pay_no_rules.csr_balance_info (run_types_rec.assignment_action_id,''EMEA BALANCE DEFINITION'',''EMEA BALANCES'') LOOP ');
1318: -- end new
1319: -- build_sql(sqlstr, l_cntr_sql, ' Begin FOR csr_balance_info_rec IN pay_no_rules.csr_balance_info ('||p_assignment_action_id||',''EMEA BALANCE DEFINITION'',''EMEA BALANCES'') LOOP ');
1320: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) := pay_no_rules.load_xml(''CS'', NULL, ''BALANCE DETAILS'', NULL); ');
1321: FOR cntr in 1..30 LOOP
1322:
1323: IF pay_no_rules.flex_seg_enabled ('EMEA BALANCE DEFINITION', 'ACTION_INFORMATION'||cntr) THEN

Line 1320: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) := pay_no_rules.load_xml(''CS'', NULL, ''BALANCE DETAILS'', NULL); ');

1316: build_sql(sqlstr, l_cntr_sql, ' Begin FOR run_types_rec IN pay_no_rules.csr_run_types ('||p_assignment_action_id||') LOOP ');
1317: build_sql(sqlstr, l_cntr_sql, ' FOR csr_balance_info_rec IN pay_no_rules.csr_balance_info (run_types_rec.assignment_action_id,''EMEA BALANCE DEFINITION'',''EMEA BALANCES'') LOOP ');
1318: -- end new
1319: -- build_sql(sqlstr, l_cntr_sql, ' Begin FOR csr_balance_info_rec IN pay_no_rules.csr_balance_info ('||p_assignment_action_id||',''EMEA BALANCE DEFINITION'',''EMEA BALANCES'') LOOP ');
1320: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) := pay_no_rules.load_xml(''CS'', NULL, ''BALANCE DETAILS'', NULL); ');
1321: FOR cntr in 1..30 LOOP
1322:
1323: IF pay_no_rules.flex_seg_enabled ('EMEA BALANCE DEFINITION', 'ACTION_INFORMATION'||cntr) THEN
1324: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=

Line 1323: IF pay_no_rules.flex_seg_enabled ('EMEA BALANCE DEFINITION', 'ACTION_INFORMATION'||cntr) THEN

1319: -- build_sql(sqlstr, l_cntr_sql, ' Begin FOR csr_balance_info_rec IN pay_no_rules.csr_balance_info ('||p_assignment_action_id||',''EMEA BALANCE DEFINITION'',''EMEA BALANCES'') LOOP ');
1320: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) := pay_no_rules.load_xml(''CS'', NULL, ''BALANCE DETAILS'', NULL); ');
1321: FOR cntr in 1..30 LOOP
1322:
1323: IF pay_no_rules.flex_seg_enabled ('EMEA BALANCE DEFINITION', 'ACTION_INFORMATION'||cntr) THEN
1324: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1325: pay_no_rules.load_xml(''D'', ''EMEA BALANCE DEFINITION'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.a'||cntr||'); ');
1326: END IF;
1327:

Line 1325: pay_no_rules.load_xml(''D'', ''EMEA BALANCE DEFINITION'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.a'||cntr||'); ');

1321: FOR cntr in 1..30 LOOP
1322:
1323: IF pay_no_rules.flex_seg_enabled ('EMEA BALANCE DEFINITION', 'ACTION_INFORMATION'||cntr) THEN
1324: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1325: pay_no_rules.load_xml(''D'', ''EMEA BALANCE DEFINITION'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.a'||cntr||'); ');
1326: END IF;
1327:
1328: IF pay_no_rules.flex_seg_enabled ('EMEA BALANCES', 'ACTION_INFORMATION'||cntr) THEN
1329: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=

Line 1328: IF pay_no_rules.flex_seg_enabled ('EMEA BALANCES', 'ACTION_INFORMATION'||cntr) THEN

1324: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1325: pay_no_rules.load_xml(''D'', ''EMEA BALANCE DEFINITION'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.a'||cntr||'); ');
1326: END IF;
1327:
1328: IF pay_no_rules.flex_seg_enabled ('EMEA BALANCES', 'ACTION_INFORMATION'||cntr) THEN
1329: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1330: pay_no_rules.load_xml(''D'', ''EMEA BALANCES'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.aa'||cntr||'); ');
1331: END IF;
1332:

Line 1330: pay_no_rules.load_xml(''D'', ''EMEA BALANCES'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.aa'||cntr||'); ');

1326: END IF;
1327:
1328: IF pay_no_rules.flex_seg_enabled ('EMEA BALANCES', 'ACTION_INFORMATION'||cntr) THEN
1329: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1330: pay_no_rules.load_xml(''D'', ''EMEA BALANCES'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.aa'||cntr||'); ');
1331: END IF;
1332:
1333: END LOOP;
1334: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) := pay_no_rules.load_xml(''CE'', NULL, ''BALANCE DETAILS'', NULL); ');

Line 1334: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) := pay_no_rules.load_xml(''CE'', NULL, ''BALANCE DETAILS'', NULL); ');

1330: pay_no_rules.load_xml(''D'', ''EMEA BALANCES'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.aa'||cntr||'); ');
1331: END IF;
1332:
1333: END LOOP;
1334: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) := pay_no_rules.load_xml(''CE'', NULL, ''BALANCE DETAILS'', NULL); ');
1335: -- new
1336: build_sql(sqlstr, l_cntr_sql, ' END LOOP; ');
1337: -- end new
1338: build_sql(sqlstr, l_cntr_sql, ' END LOOP; End; ');

Line 1378: hr_utility.set_location('in pay_no_rules',10);

1374:
1375: l_source_text VARCHAR2(150);
1376: BEGIN
1377:
1378: hr_utility.set_location('in pay_no_rules',10);
1379:
1380: IF pay_no_ssb_codes.g_next_ssb_code IS NULL THEN
1381: OPEN csr_ssb_codes;
1382: FETCH csr_ssb_codes INTO l_source_text;

Line 1452: hr_utility.set_location('pay_no_rules.get_source_text2_context',1);

1448:
1449: --
1450: l_tax_municipality := null;
1451: --
1452: hr_utility.set_location('pay_no_rules.get_source_text2_context',1);
1453: --
1454:
1455: OPEN csr_get_prim_asg_id(p_asg_act_id) ;
1456: FETCH csr_get_prim_asg_id INTO prim_asg_id , pay_act_id ;

Line 1467: hr_utility.set_location('pay_no_rules.get_source_text2_context='|| p_source_text2,2);

1463: --
1464: p_source_text2 := NVL(l_tax_municipality,' ');
1465:
1466: --
1467: hr_utility.set_location('pay_no_rules.get_source_text2_context='|| p_source_text2,2);
1468:
1469: EXCEPTION
1470: WHEN others THEN
1471: NULL;

Line 1551: END PAY_NO_RULES;

1547: return 'LAST_NAME'; -- Last Name of person
1548: --
1549: END get_payslip_sort_order3;
1550:
1551: END PAY_NO_RULES;