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.3.12000000.8 2007/06/21 15:03:52 pdavidra noship $ */
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 370: hr_utility.set_location('pay_no_rules.get_source_context',1);

366: BEGIN
367: --
368: l_local_unit:= null;
369: --
370: hr_utility.set_location('pay_no_rules.get_source_context',1);
371: --
372: OPEN csr_get_local_unit(p_asg_act_id);
373: FETCH csr_get_local_unit INTO l_local_unit;
374: CLOSE csr_get_local_unit;

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

374: CLOSE csr_get_local_unit;
375: --
376: p_source_id := NVL(l_local_unit,' ');
377: --
378: hr_utility.set_location('pay_no_rules.get_source_context='|| p_source_id,2);
379: --
380: END get_source_context;
381: --
382: */

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

406: BEGIN
407: --
408: l_local_unit:= null;
409: --
410: hr_utility.set_location('pay_no_rules.get_main_local_unit_id',1);
411: --
412: OPEN csr_get_local_unit(p_assignment_id);
413: FETCH csr_get_local_unit INTO l_local_unit;
414: CLOSE csr_get_local_unit;

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

414: CLOSE csr_get_local_unit;
415: --
416: p_local_unit_id := NVL(l_local_unit,0);
417: --
418: hr_utility.set_location('pay_no_rules.get_main_local_unit_id='|| p_local_unit_id,2);
419: --
420: END get_main_local_unit_id;
421: ------------------------------------------------------------------------------------------
422: PROCEDURE get_default_jurisdiction(p_asg_act_id NUMBER,

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

566: BEGIN
567: --
568: l_tax_municipality := null;
569: --
570: hr_utility.set_location('pay_no_rules.get_default_jurisdiction',1);
571: --
572: -- BUG fix 4474253, commenting old cursor call
573: /*
574: OPEN csr_get_tax_municipality(p_asg_act_id);

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

615: --
616: p_jurisdiction := NVL(l_tax_municipality,' ');
617:
618: --
619: hr_utility.set_location('pay_no_rules.get_default_jurisdiction='|| p_jurisdiction,2);
620: --
621: END get_default_jurisdiction;
622: --
623: --------------------------------------------------------------------------------

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

978:
979: BEGIN
980:
981: --hr_utility.trace_on(null,'no_payslip');
982: hr_utility.trace('Entering Pay_NO_RULES.add_custom_xml');
983: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
984: hr_utility.trace('p_action_information_category '|| p_action_information_category);
985: hr_utility.trace('p_document_type '|| p_document_type);
986:

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

1299: --
1300: l_cntr_sql := 1;
1301:
1302: -- new
1303: build_sql(sqlstr, l_cntr_sql, ' Begin FOR run_types_rec IN pay_no_rules.csr_run_types ('||p_assignment_action_id||') LOOP ');
1304: 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 ');
1305: -- end new
1306: -- 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 ');
1307: 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 1304: 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 ');

1300: l_cntr_sql := 1;
1301:
1302: -- new
1303: build_sql(sqlstr, l_cntr_sql, ' Begin FOR run_types_rec IN pay_no_rules.csr_run_types ('||p_assignment_action_id||') LOOP ');
1304: 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 ');
1305: -- end new
1306: -- 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 ');
1307: 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); ');
1308: FOR cntr in 1..30 LOOP

Line 1306: -- 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 ');

1302: -- new
1303: build_sql(sqlstr, l_cntr_sql, ' Begin FOR run_types_rec IN pay_no_rules.csr_run_types ('||p_assignment_action_id||') LOOP ');
1304: 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 ');
1305: -- end new
1306: -- 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 ');
1307: 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); ');
1308: FOR cntr in 1..30 LOOP
1309:
1310: IF pay_no_rules.flex_seg_enabled ('EMEA BALANCE DEFINITION', 'ACTION_INFORMATION'||cntr) THEN

Line 1307: 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); ');

1303: build_sql(sqlstr, l_cntr_sql, ' Begin FOR run_types_rec IN pay_no_rules.csr_run_types ('||p_assignment_action_id||') LOOP ');
1304: 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 ');
1305: -- end new
1306: -- 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 ');
1307: 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); ');
1308: FOR cntr in 1..30 LOOP
1309:
1310: IF pay_no_rules.flex_seg_enabled ('EMEA BALANCE DEFINITION', 'ACTION_INFORMATION'||cntr) THEN
1311: 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 1310: IF pay_no_rules.flex_seg_enabled ('EMEA BALANCE DEFINITION', 'ACTION_INFORMATION'||cntr) THEN

1306: -- 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 ');
1307: 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); ');
1308: FOR cntr in 1..30 LOOP
1309:
1310: IF pay_no_rules.flex_seg_enabled ('EMEA BALANCE DEFINITION', 'ACTION_INFORMATION'||cntr) THEN
1311: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1312: pay_no_rules.load_xml(''D'', ''EMEA BALANCE DEFINITION'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.a'||cntr||'); ');
1313: END IF;
1314:

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

1308: FOR cntr in 1..30 LOOP
1309:
1310: IF pay_no_rules.flex_seg_enabled ('EMEA BALANCE DEFINITION', 'ACTION_INFORMATION'||cntr) THEN
1311: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1312: pay_no_rules.load_xml(''D'', ''EMEA BALANCE DEFINITION'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.a'||cntr||'); ');
1313: END IF;
1314:
1315: IF pay_no_rules.flex_seg_enabled ('EMEA BALANCES', 'ACTION_INFORMATION'||cntr) THEN
1316: 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 1315: IF pay_no_rules.flex_seg_enabled ('EMEA BALANCES', 'ACTION_INFORMATION'||cntr) THEN

1311: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1312: pay_no_rules.load_xml(''D'', ''EMEA BALANCE DEFINITION'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.a'||cntr||'); ');
1313: END IF;
1314:
1315: IF pay_no_rules.flex_seg_enabled ('EMEA BALANCES', 'ACTION_INFORMATION'||cntr) THEN
1316: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1317: pay_no_rules.load_xml(''D'', ''EMEA BALANCES'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.aa'||cntr||'); ');
1318: END IF;
1319:

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

1313: END IF;
1314:
1315: IF pay_no_rules.flex_seg_enabled ('EMEA BALANCES', 'ACTION_INFORMATION'||cntr) THEN
1316: build_sql(sqlstr, l_cntr_sql, ' pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1317: pay_no_rules.load_xml(''D'', ''EMEA BALANCES'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.aa'||cntr||'); ');
1318: END IF;
1319:
1320: END LOOP;
1321: 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 1321: 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); ');

1317: pay_no_rules.load_xml(''D'', ''EMEA BALANCES'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.aa'||cntr||'); ');
1318: END IF;
1319:
1320: END LOOP;
1321: 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); ');
1322: -- new
1323: build_sql(sqlstr, l_cntr_sql, ' END LOOP; ');
1324: -- end new
1325: build_sql(sqlstr, l_cntr_sql, ' END LOOP; End; ');

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

1361:
1362: l_source_text VARCHAR2(150);
1363: BEGIN
1364:
1365: hr_utility.set_location('in pay_no_rules',10);
1366:
1367: IF pay_no_ssb_codes.g_next_ssb_code IS NULL THEN
1368: OPEN csr_ssb_codes;
1369: FETCH csr_ssb_codes INTO l_source_text;

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

1435:
1436: --
1437: l_tax_municipality := null;
1438: --
1439: hr_utility.set_location('pay_no_rules.get_source_text2_context',1);
1440: --
1441:
1442: OPEN csr_get_prim_asg_id(p_asg_act_id) ;
1443: FETCH csr_get_prim_asg_id INTO prim_asg_id , pay_act_id ;

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

1450: --
1451: p_source_text2 := NVL(l_tax_municipality,' ');
1452:
1453: --
1454: hr_utility.set_location('pay_no_rules.get_source_text2_context='|| p_source_text2,2);
1455:
1456: EXCEPTION
1457: WHEN others THEN
1458: NULL;

Line 1538: END PAY_NO_RULES;

1534: return 'LAST_NAME'; -- Last Name of person
1535: --
1536: END get_payslip_sort_order3;
1537:
1538: END PAY_NO_RULES;