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_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_IE_LEGISLATIVE_ARCHIVE

Line 1: PACKAGE BODY pay_ie_legislative_archive AS

1: PACKAGE BODY pay_ie_legislative_archive AS
2: /* $Header: pyieparc.pkb 120.15.12010000.4 2008/08/22 11:11:18 rsahai ship $ */
3:
4: TYPE balance_rec IS RECORD (
5: balance_type_id NUMBER,

Line 51: g_package CONSTANT VARCHAR2(30) := 'pay_ie_legislative_archive.';

47: g_std_cut_off_id NUMBER;
48: g_tax_unit_id NUMBER;
49: g_prsi_week_id NUMBER;
50:
51: g_package CONSTANT VARCHAR2(30) := 'pay_ie_legislative_archive.';
52:
53: g_balance_context CONSTANT VARCHAR2(30) := 'IE_BALANCES';
54: g_element_context CONSTANT VARCHAR2(30) := 'IE_ELEMENTS';
55:

Line 838: pay_ie_legislative_archive.get_parameters (

834: INTO g_archive_effective_date;
835:
836: CLOSE csr_archive_effective_date;
837:
838: pay_ie_legislative_archive.get_parameters (
839: p_payroll_action_id => p_payroll_action_id
840: , p_token_name => 'PAYROLL'
841: , p_token_value => l_payroll_id);
842:

Line 843: pay_ie_legislative_archive.get_parameters (

839: p_payroll_action_id => p_payroll_action_id
840: , p_token_name => 'PAYROLL'
841: , p_token_value => l_payroll_id);
842:
843: pay_ie_legislative_archive.get_parameters (
844: p_payroll_action_id => p_payroll_action_id
845: , p_token_name => 'CONSOLIDATION'
846: , p_token_value => l_consolidation_set);
847:

Line 848: pay_ie_legislative_archive.get_parameters (

844: p_payroll_action_id => p_payroll_action_id
845: , p_token_name => 'CONSOLIDATION'
846: , p_token_value => l_consolidation_set);
847:
848: pay_ie_legislative_archive.get_parameters (
849: p_payroll_action_id => p_payroll_action_id
850: , p_token_name => 'ASSIGNMENT_SET'
851: , p_token_value => l_assignment_set_id);
852:

Line 853: pay_ie_legislative_archive.get_parameters (

849: p_payroll_action_id => p_payroll_action_id
850: , p_token_name => 'ASSIGNMENT_SET'
851: , p_token_value => l_assignment_set_id);
852:
853: pay_ie_legislative_archive.get_parameters (
854: p_payroll_action_id => p_payroll_action_id
855: , p_token_name => 'START_DATE'
856: , p_token_value => l_start_date);
857:

Line 858: pay_ie_legislative_archive.get_parameters (

854: p_payroll_action_id => p_payroll_action_id
855: , p_token_name => 'START_DATE'
856: , p_token_value => l_start_date);
857:
858: pay_ie_legislative_archive.get_parameters (
859: p_payroll_action_id => p_payroll_action_id
860: , p_token_name => 'END_DATE'
861: , p_token_value => l_end_date);
862:

Line 863: pay_ie_legislative_archive.get_parameters (

859: p_payroll_action_id => p_payroll_action_id
860: , p_token_name => 'END_DATE'
861: , p_token_value => l_end_date);
862:
863: pay_ie_legislative_archive.get_parameters (
864: p_payroll_action_id => p_payroll_action_id
865: , p_token_name => 'BG_ID'
866: , p_token_value => l_bg_id);
867:

Line 975: pay_ie_legislative_archive.get_eit_definitions (

971: g_max_user_balance_index := 0;
972:
973: hr_utility.set_location('get_eit_definitions - balances',20);
974:
975: pay_ie_legislative_archive.get_eit_definitions (
976: p_pactid => p_payroll_action_id
977: , p_business_group_id => l_bg_id
978: , p_payroll_pact => NULL
979: , p_effective_date => l_canonical_start_date

Line 985: pay_ie_legislative_archive.get_eit_definitions (

981: , p_archive => 'N');
982:
983: hr_utility.set_location('get_eit_definitions - elements',20);
984:
985: pay_ie_legislative_archive.get_eit_definitions (
986: p_pactid => p_payroll_action_id
987: , p_business_group_id => l_bg_id
988: , p_payroll_pact => NULL
989: , p_effective_date => l_canonical_start_date

Line 998: pay_ie_legislative_archive.setup_standard_balance_table;

994: , p_payroll_action_id);
995:
996: -- setup statutory balances pl/sql table
997:
998: pay_ie_legislative_archive.setup_standard_balance_table;
999:
1000: hr_utility.set_location('Leaving ' || l_proc,20);
1001: --
1002:

Line 1864: pay_ie_legislative_archive.get_parameters (

1860:
1861: --hr_utility.trace_on(null,'IEPS');
1862: hr_utility.set_location('Entering ' || l_proc,10);
1863:
1864: pay_ie_legislative_archive.get_parameters (
1865: p_payroll_action_id => pactid
1866: , p_token_name => 'PAYROLL'
1867: , p_token_value => l_payroll_id);
1868:

Line 1869: pay_ie_legislative_archive.get_parameters (

1865: p_payroll_action_id => pactid
1866: , p_token_name => 'PAYROLL'
1867: , p_token_value => l_payroll_id);
1868:
1869: pay_ie_legislative_archive.get_parameters (
1870: p_payroll_action_id => pactid
1871: , p_token_name => 'CONSOLIDATION'
1872: , p_token_value => l_consolidation_set);
1873:

Line 1874: pay_ie_legislative_archive.get_parameters (

1870: p_payroll_action_id => pactid
1871: , p_token_name => 'CONSOLIDATION'
1872: , p_token_value => l_consolidation_set);
1873:
1874: pay_ie_legislative_archive.get_parameters (
1875: p_payroll_action_id => pactid
1876: , p_token_name => 'ASSIGNMENT_SET'
1877: , p_token_value => l_assignment_set_id);
1878:

Line 1879: pay_ie_legislative_archive.get_parameters (

1875: p_payroll_action_id => pactid
1876: , p_token_name => 'ASSIGNMENT_SET'
1877: , p_token_value => l_assignment_set_id);
1878:
1879: pay_ie_legislative_archive.get_parameters (
1880: p_payroll_action_id => pactid
1881: , p_token_name => 'START_DATE'
1882: , p_token_value => l_start_date);
1883:

Line 1884: pay_ie_legislative_archive.get_parameters (

1880: p_payroll_action_id => pactid
1881: , p_token_name => 'START_DATE'
1882: , p_token_value => l_start_date);
1883:
1884: pay_ie_legislative_archive.get_parameters (
1885: p_payroll_action_id => pactid
1886: , p_token_name => 'END_DATE'
1887: , p_token_value => l_end_date);
1888:

Line 1889: pay_ie_legislative_archive.get_parameters (

1885: p_payroll_action_id => pactid
1886: , p_token_name => 'END_DATE'
1887: , p_token_value => l_end_date);
1888:
1889: pay_ie_legislative_archive.get_parameters (
1890: p_payroll_action_id => pactid
1891: , p_token_name => 'BG_ID'
1892: , p_token_value => l_bg_id);
1893:

Line 1940: pay_ie_legislative_archive.get_eit_definitions (

1936:
1937:
1938: g_max_user_balance_index := 0;
1939:
1940: pay_ie_legislative_archive.get_eit_definitions (
1941: p_pactid => pactid
1942: , p_business_group_id => l_bg_id
1943: , p_payroll_pact => NULL
1944: , p_effective_date => l_canonical_start_date

Line 1948: pay_ie_legislative_archive.get_eit_definitions (

1944: , p_effective_date => l_canonical_start_date
1945: , p_eit_context => g_balance_context
1946: , p_archive => 'Y');
1947:
1948: pay_ie_legislative_archive.get_eit_definitions (
1949: p_pactid => pactid
1950: , p_business_group_id => l_bg_id
1951: , p_payroll_pact => NULL
1952: , p_effective_date => l_canonical_start_date

Line 1956: pay_ie_legislative_archive.setup_element_definitions (

1952: , p_effective_date => l_canonical_start_date
1953: , p_eit_context => g_element_context
1954: , p_archive => 'Y');
1955:
1956: pay_ie_legislative_archive.setup_element_definitions (
1957: p_pactid => pactid
1958: , p_payroll_pact => NULL
1959: , p_business_group_id => l_bg_id
1960: , p_effective_date => l_canonical_start_date);

Line 2265: pay_ie_legislative_archive.get_parameters (

2261: BEGIN
2262:
2263: hr_utility.set_location('Entering ' || l_proc,10);
2264:
2265: pay_ie_legislative_archive.get_parameters (
2266: p_payroll_action_id => pactid
2267: , p_token_name => 'PAYROLL'
2268: , p_token_value => l_payroll_id);
2269:

Line 2270: pay_ie_legislative_archive.get_parameters (

2266: p_payroll_action_id => pactid
2267: , p_token_name => 'PAYROLL'
2268: , p_token_value => l_payroll_id);
2269:
2270: pay_ie_legislative_archive.get_parameters (
2271: p_payroll_action_id => pactid
2272: , p_token_name => 'CONSOLIDATION'
2273: , p_token_value => l_consolidation_set);
2274:

Line 2275: pay_ie_legislative_archive.get_parameters (

2271: p_payroll_action_id => pactid
2272: , p_token_name => 'CONSOLIDATION'
2273: , p_token_value => l_consolidation_set);
2274:
2275: pay_ie_legislative_archive.get_parameters (
2276: p_payroll_action_id => pactid
2277: , p_token_name => 'START_DATE'
2278: , p_token_value => l_start_date);
2279:

Line 2280: pay_ie_legislative_archive.get_parameters (

2276: p_payroll_action_id => pactid
2277: , p_token_name => 'START_DATE'
2278: , p_token_value => l_start_date);
2279:
2280: pay_ie_legislative_archive.get_parameters (
2281: p_payroll_action_id => pactid
2282: , p_token_name => 'END_DATE'
2283: , p_token_value => l_end_date);
2284:

Line 2589: pay_ie_legislative_archive.archive_employee_details (

2585: IF l_record_count = 0
2586:
2587: THEN
2588:
2589: pay_ie_legislative_archive.archive_employee_details (
2590: p_assactid => p_assactid
2591: , p_assignment_id => csr_rec.assignment_id
2592: , p_curr_pymt_ass_act_id => csr_rec.pre_assignment_action_id -- prepayment assignment_action_id
2593: , p_date_earned => csr_rec.date_earned -- payroll date_earned

Line 2650: pay_ie_legislative_archive.archive_employee_details(

2646: IF l_record_count = 0
2647:
2648: THEN
2649:
2650: pay_ie_legislative_archive.archive_employee_details(
2651: p_assactid => l_action_context_id
2652: , p_assignment_id => csr_rec.assignment_id
2653: , p_curr_pymt_ass_act_id => csr_rec.pre_assignment_action_id -- prepayment assignment_action_id
2654: , p_date_earned => csr_rec.date_earned -- payroll date_earned

Line 2660: pay_ie_legislative_archive.archive_ie_employee_details (

2656: , p_curr_pymt_eff_date => csr_rec.pre_effective_date -- prepayment effective_date
2657: , p_time_period_id => csr_rec.time_period_id -- payroll time_period_id
2658: , p_record_count => l_record_count);
2659:
2660: pay_ie_legislative_archive.archive_ie_employee_details (
2661: p_assactid => l_action_context_id
2662: , p_assignment_id => csr_rec.assignment_id
2663: , p_curr_pymt_ass_act_id => csr_child_rec.child_assignment_action_id
2664: , p_effective_date => csr_rec.effective_date);

Line 2669: pay_ie_legislative_archive.get_element_info (

2665:
2666:
2667: END IF;
2668:
2669: pay_ie_legislative_archive.get_element_info (
2670: p_action_context_id => l_action_context_id
2671: , p_assignment_id => csr_rec.assignment_id
2672: , p_child_assignment_action => csr_child_rec.child_assignment_action_id
2673: , p_effective_date => csr_rec.effective_date

Line 2717: pay_ie_legislative_archive.archive_ie_employee_details (

2713: IF l_child_count = 0
2714:
2715: THEN
2716:
2717: pay_ie_legislative_archive.archive_ie_employee_details (
2718: p_assactid => l_action_context_id
2719: , p_assignment_id => csr_rec.assignment_id
2720: , p_curr_pymt_ass_act_id => csr_child_rec.child_assignment_action_id
2721: , p_effective_date => csr_rec.effective_date

Line 2726: pay_ie_legislative_archive.get_element_info (

2722: , p_ppsn_override => l_ppsn_override); --6633719
2723:
2724: END IF;
2725:
2726: pay_ie_legislative_archive.get_element_info (
2727: p_action_context_id => l_action_context_id
2728: , p_assignment_id => csr_rec.assignment_id
2729: , p_child_assignment_action => csr_child_rec.child_assignment_action_id
2730: , p_effective_date => csr_rec.effective_date

Line 2754: pay_ie_legislative_archive.process_balance (

2750: FOR l_index IN 1 .. g_max_user_balance_index
2751:
2752: LOOP
2753:
2754: pay_ie_legislative_archive.process_balance (
2755: p_action_context_id => l_action_context_id
2756: , p_assignment_id => csr_rec.assignment_id
2757: , p_source_id => csr_child_rec.child_assignment_action_id
2758: , p_effective_date => csr_rec.effective_date

Line 2789: pay_ie_legislative_archive.process_balance (

2785: hr_utility.set_location('AssignmentID = ' || csr_rec.assignment_id,70);
2786: hr_utility.set_location('suffix = '||g_statutory_balance_table(l_index).database_item_suffix,70);
2787: hr_utility.set_location('Balance Name = '||g_statutory_balance_table(l_index).balance_name,70);
2788:
2789: pay_ie_legislative_archive.process_balance (
2790: p_action_context_id => l_action_context_id
2791: , p_assignment_id => csr_rec.assignment_id
2792: , p_source_id => csr_child_rec.child_assignment_action_id
2793: , p_effective_date => csr_rec.effective_date

Line 2991: pay_ie_legislative_archive.get_parameters (

2987: CLOSE csr_check_archived;
2988:
2989: IF l_archived = 0 THEN
2990:
2991: pay_ie_legislative_archive.get_parameters (
2992: p_payroll_action_id => p_payroll_action_id
2993: , p_token_name => 'PAYROLL'
2994: , p_token_value => l_payroll_id);
2995:

Line 2996: pay_ie_legislative_archive.get_parameters (

2992: p_payroll_action_id => p_payroll_action_id
2993: , p_token_name => 'PAYROLL'
2994: , p_token_value => l_payroll_id);
2995:
2996: pay_ie_legislative_archive.get_parameters (
2997: p_payroll_action_id => p_payroll_action_id
2998: , p_token_name => 'CONSOLIDATION'
2999: , p_token_value => l_consolidation_set);
3000:

Line 3001: pay_ie_legislative_archive.get_parameters (

2997: p_payroll_action_id => p_payroll_action_id
2998: , p_token_name => 'CONSOLIDATION'
2999: , p_token_value => l_consolidation_set);
3000:
3001: pay_ie_legislative_archive.get_parameters (
3002: p_payroll_action_id => p_payroll_action_id
3003: , p_token_name => 'ASSIGNMENT_SET'
3004: , p_token_value => l_assignment_set_id);
3005:

Line 3006: pay_ie_legislative_archive.get_parameters (

3002: p_payroll_action_id => p_payroll_action_id
3003: , p_token_name => 'ASSIGNMENT_SET'
3004: , p_token_value => l_assignment_set_id);
3005:
3006: pay_ie_legislative_archive.get_parameters (
3007: p_payroll_action_id => p_payroll_action_id
3008: , p_token_name => 'START_DATE'
3009: , p_token_value => l_start_date);
3010:

Line 3011: pay_ie_legislative_archive.get_parameters (

3007: p_payroll_action_id => p_payroll_action_id
3008: , p_token_name => 'START_DATE'
3009: , p_token_value => l_start_date);
3010:
3011: pay_ie_legislative_archive.get_parameters (
3012: p_payroll_action_id => p_payroll_action_id
3013: , p_token_name => 'END_DATE'
3014: , p_token_value => l_end_date);
3015:

Line 3016: pay_ie_legislative_archive.get_parameters (

3012: p_payroll_action_id => p_payroll_action_id
3013: , p_token_name => 'END_DATE'
3014: , p_token_value => l_end_date);
3015:
3016: pay_ie_legislative_archive.get_parameters (
3017: p_payroll_action_id => p_payroll_action_id
3018: , p_token_name => 'BG_ID'
3019: , p_token_value => l_bg_id);
3020:

Line 3067: pay_ie_legislative_archive.get_eit_definitions (

3063:
3064:
3065: g_max_user_balance_index := 0;
3066:
3067: pay_ie_legislative_archive.get_eit_definitions (
3068: p_pactid => p_payroll_action_id
3069: , p_business_group_id => l_bg_id
3070: , p_payroll_pact => NULL
3071: , p_effective_date => l_canonical_start_date

Line 3075: pay_ie_legislative_archive.get_eit_definitions (

3071: , p_effective_date => l_canonical_start_date
3072: , p_eit_context => g_balance_context
3073: , p_archive => 'Y');
3074:
3075: pay_ie_legislative_archive.get_eit_definitions (
3076: p_pactid => p_payroll_action_id
3077: , p_business_group_id => l_bg_id
3078: , p_payroll_pact => NULL
3079: , p_effective_date => l_canonical_start_date

Line 3083: pay_ie_legislative_archive.setup_element_definitions (

3079: , p_effective_date => l_canonical_start_date
3080: , p_eit_context => g_element_context
3081: , p_archive => 'Y');
3082:
3083: pay_ie_legislative_archive.setup_element_definitions (
3084: p_pactid => p_payroll_action_id
3085: , p_payroll_pact => NULL
3086: , p_business_group_id => l_bg_id
3087: , p_effective_date => l_canonical_start_date);