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_SE_RULES dependencies on PAY_SE_RULES

Line 1: package body PAY_SE_RULES as

1: package body PAY_SE_RULES as
2: /* $Header: pyserule.pkb 120.7 2008/07/18 12:02:30 rmurahar noship $ */
3:
4: g_custom_context pay_action_information.action_information_category%type;
5: g_action_ctx_id NUMBER;

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

603: load_xml('CE', NULL, 'SUMMARY OF PAYMENTS', NULL);
604:
605: -- BALANCE DETAILS
606: l_cntr_sql := 1;
607: build_sql(sqlstr, l_cntr_sql, ' Begin FOR csr_balance_info_rec IN pay_SE_rules.csr_balance_info ('||p_assignment_action_id||',''EMEA BALANCE DEFINITION'',''EMEA BALANCES'') LOOP ');
608: build_sql(sqlstr, l_cntr_sql, ' pay_SE_rules.load_xml(''CS'', NULL, ''BALANCE DETAILS'', NULL); ');
609: FOR cntr in 1..30
610: LOOP
611: IF flex_seg_enabled ('EMEA BALANCE DEFINITION', 'ACTION_INFORMATION'||cntr) THEN

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

604:
605: -- BALANCE DETAILS
606: l_cntr_sql := 1;
607: build_sql(sqlstr, l_cntr_sql, ' Begin FOR csr_balance_info_rec IN pay_SE_rules.csr_balance_info ('||p_assignment_action_id||',''EMEA BALANCE DEFINITION'',''EMEA BALANCES'') LOOP ');
608: build_sql(sqlstr, l_cntr_sql, ' pay_SE_rules.load_xml(''CS'', NULL, ''BALANCE DETAILS'', NULL); ');
609: FOR cntr in 1..30
610: LOOP
611: IF flex_seg_enabled ('EMEA BALANCE DEFINITION', 'ACTION_INFORMATION'||cntr) THEN
612: build_sql(sqlstr, l_cntr_sql, ' pay_SE_rules.load_xml(''D'', ''EMEA BALANCE DEFINITION'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.a'||cntr||'); ');

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

608: build_sql(sqlstr, l_cntr_sql, ' pay_SE_rules.load_xml(''CS'', NULL, ''BALANCE DETAILS'', NULL); ');
609: FOR cntr in 1..30
610: LOOP
611: IF flex_seg_enabled ('EMEA BALANCE DEFINITION', 'ACTION_INFORMATION'||cntr) THEN
612: build_sql(sqlstr, l_cntr_sql, ' pay_SE_rules.load_xml(''D'', ''EMEA BALANCE DEFINITION'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.a'||cntr||'); ');
613: END IF;
614: IF flex_seg_enabled ('EMEA BALANCES', 'ACTION_INFORMATION'||cntr) THEN
615: build_sql(sqlstr, l_cntr_sql, ' pay_SE_rules.load_xml(''D'', ''EMEA BALANCES'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.aa'||cntr||'); ');
616: END IF;

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

611: IF flex_seg_enabled ('EMEA BALANCE DEFINITION', 'ACTION_INFORMATION'||cntr) THEN
612: build_sql(sqlstr, l_cntr_sql, ' pay_SE_rules.load_xml(''D'', ''EMEA BALANCE DEFINITION'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.a'||cntr||'); ');
613: END IF;
614: IF flex_seg_enabled ('EMEA BALANCES', 'ACTION_INFORMATION'||cntr) THEN
615: build_sql(sqlstr, l_cntr_sql, ' pay_SE_rules.load_xml(''D'', ''EMEA BALANCES'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.aa'||cntr||'); ');
616: END IF;
617: END LOOP;
618: build_sql(sqlstr, l_cntr_sql, ' pay_SE_rules.load_xml(''CE'', NULL, ''BALANCE DETAILS'', NULL); ');
619: build_sql(sqlstr, l_cntr_sql, ' END LOOP; End; ');

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

614: IF flex_seg_enabled ('EMEA BALANCES', 'ACTION_INFORMATION'||cntr) THEN
615: build_sql(sqlstr, l_cntr_sql, ' pay_SE_rules.load_xml(''D'', ''EMEA BALANCES'', ''ACTION_INFORMATION'||cntr||''', csr_balance_info_rec.aa'||cntr||'); ');
616: END IF;
617: END LOOP;
618: build_sql(sqlstr, l_cntr_sql, ' pay_SE_rules.load_xml(''CE'', NULL, ''BALANCE DETAILS'', NULL); ');
619: build_sql(sqlstr, l_cntr_sql, ' END LOOP; End; ');
620: --
621: csr := DBMS_SQL.OPEN_CURSOR;
622: DBMS_SQL.PARSE(csr

Line 741: END PAY_SE_RULES;

737: p_local_unit_id := NULL;
738:
739: END get_main_local_unit_id;
740:
741: END PAY_SE_RULES;