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_FI_RULES dependencies on PAY_FI_RULES

Line 1: package body PAY_FI_RULES as

1: package body PAY_FI_RULES as
2: /* $Header: pyfirule.pkb 120.12.12000000.2 2007/02/14 06:13:45 dbehera noship $ */
3:
4: -----------------------------------------------------------------------------
5: -- GET_MAIN_TAX_UNIT_ID fetches the Legal Employer Id of the Local Unit

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

869: load_xml('CE', NULL, 'SUMMARY OF PAYMENTS', NULL);
870:
871: -- BALANCE DETAILS
872: l_cntr_sql := 1;
873: build_sql(sqlstr, l_cntr_sql, ' Begin FOR csr_balance_info_rec IN pay_fi_rules.csr_balance_info ('||p_assignment_action_id||',''EMEA BALANCE DEFINITION'',''EMEA BALANCES'') LOOP ');
874: build_sql(sqlstr, l_cntr_sql, ' pay_fi_rules.load_xml(''CS'', NULL, ''BALANCE DETAILS'', NULL); ');
875: FOR cntr in 1..30
876: LOOP
877: IF flex_seg_enabled ('EMEA BALANCE DEFINITION', 'ACTION_INFORMATION'||cntr) THEN

Line 874: build_sql(sqlstr, l_cntr_sql, ' pay_fi_rules.load_xml(''CS'', NULL, ''BALANCE DETAILS'', NULL); ');

870:
871: -- BALANCE DETAILS
872: l_cntr_sql := 1;
873: build_sql(sqlstr, l_cntr_sql, ' Begin FOR csr_balance_info_rec IN pay_fi_rules.csr_balance_info ('||p_assignment_action_id||',''EMEA BALANCE DEFINITION'',''EMEA BALANCES'') LOOP ');
874: build_sql(sqlstr, l_cntr_sql, ' pay_fi_rules.load_xml(''CS'', NULL, ''BALANCE DETAILS'', NULL); ');
875: FOR cntr in 1..30
876: LOOP
877: IF flex_seg_enabled ('EMEA BALANCE DEFINITION', 'ACTION_INFORMATION'||cntr) THEN
878: build_sql(sqlstr, l_cntr_sql, ' pay_fi_rules.load_xml(''D'', ''EMEA BALANCE DEFINITION'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.a'||cntr||'); ');

Line 878: build_sql(sqlstr, l_cntr_sql, ' pay_fi_rules.load_xml(''D'', ''EMEA BALANCE DEFINITION'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.a'||cntr||'); ');

874: build_sql(sqlstr, l_cntr_sql, ' pay_fi_rules.load_xml(''CS'', NULL, ''BALANCE DETAILS'', NULL); ');
875: FOR cntr in 1..30
876: LOOP
877: IF flex_seg_enabled ('EMEA BALANCE DEFINITION', 'ACTION_INFORMATION'||cntr) THEN
878: build_sql(sqlstr, l_cntr_sql, ' pay_fi_rules.load_xml(''D'', ''EMEA BALANCE DEFINITION'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.a'||cntr||'); ');
879: END IF;
880: IF flex_seg_enabled ('EMEA BALANCES', 'ACTION_INFORMATION'||cntr) THEN
881: build_sql(sqlstr, l_cntr_sql, ' pay_fi_rules.load_xml(''D'', ''EMEA BALANCES'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.aa'||cntr||'); ');
882: END IF;

Line 881: build_sql(sqlstr, l_cntr_sql, ' pay_fi_rules.load_xml(''D'', ''EMEA BALANCES'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.aa'||cntr||'); ');

877: IF flex_seg_enabled ('EMEA BALANCE DEFINITION', 'ACTION_INFORMATION'||cntr) THEN
878: build_sql(sqlstr, l_cntr_sql, ' pay_fi_rules.load_xml(''D'', ''EMEA BALANCE DEFINITION'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.a'||cntr||'); ');
879: END IF;
880: IF flex_seg_enabled ('EMEA BALANCES', 'ACTION_INFORMATION'||cntr) THEN
881: build_sql(sqlstr, l_cntr_sql, ' pay_fi_rules.load_xml(''D'', ''EMEA BALANCES'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.aa'||cntr||'); ');
882: END IF;
883: END LOOP;
884: build_sql(sqlstr, l_cntr_sql, ' pay_fi_rules.load_xml(''CE'', NULL, ''BALANCE DETAILS'', NULL); ');
885: build_sql(sqlstr, l_cntr_sql, ' END LOOP; End; ');

Line 884: build_sql(sqlstr, l_cntr_sql, ' pay_fi_rules.load_xml(''CE'', NULL, ''BALANCE DETAILS'', NULL); ');

880: IF flex_seg_enabled ('EMEA BALANCES', 'ACTION_INFORMATION'||cntr) THEN
881: build_sql(sqlstr, l_cntr_sql, ' pay_fi_rules.load_xml(''D'', ''EMEA BALANCES'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.aa'||cntr||'); ');
882: END IF;
883: END LOOP;
884: build_sql(sqlstr, l_cntr_sql, ' pay_fi_rules.load_xml(''CE'', NULL, ''BALANCE DETAILS'', NULL); ');
885: build_sql(sqlstr, l_cntr_sql, ' END LOOP; End; ');
886: --
887: csr := DBMS_SQL.OPEN_CURSOR;
888: DBMS_SQL.PARSE(csr

Line 904: END PAY_FI_RULES;

900: END IF;
901:
902: END;
903:
904: END PAY_FI_RULES;