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_P45_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 383: pay_action_information_api.create_action_information (

379: hr_utility.set_location('p_effective_date = '||p_effective_date,20);
380: hr_utility.set_location('defined_balance_id = '||g_statutory_balance_table(l_index).defined_balance_id,20);
381: hr_utility.set_location('balance_name = '||g_statutory_balance_table(l_index).balance_name,20);
382:
383: pay_action_information_api.create_action_information (
384: p_action_information_id => l_action_info_id
385: , p_action_context_id => p_pactid
386: , p_action_context_type => 'PA'
387: , p_object_version_number => l_ovn

Line 411: pay_action_information_api.create_action_information (

407: hr_utility.set_location('p_effective_date = '||p_effective_date,20);
408: hr_utility.set_location('defined_balance_id = '||g_statutory_balance_table(l_index).defined_balance_id,20);
409: hr_utility.set_location('balance_name = '||g_statutory_balance_table(l_index).balance_name,20);
410:
411: pay_action_information_api.create_action_information (
412: p_action_information_id => l_action_info_id
413: , p_action_context_id => p_pactid
414: , p_action_context_type => 'PA'
415: , p_object_version_number => l_ovn

Line 982: from pay_action_information act_inf

978:
979: -- Fetch Commencement date when no previous p45 produced.
980: CURSOR comm_date_first IS
981: select act_inf.action_information11
982: from pay_action_information act_inf
983: where act_inf.action_context_id = p_assactid
984: and act_inf.action_information_category = 'EMPLOYEE DETAILS'
985: and act_inf.action_context_type = 'AAP';
986:

Line 990: from pay_action_information act_inf

986:
987: -- Fetch Commencement date when p45 is produced previously.
988: CURSOR comm_date_last_p45 IS
989: select act_inf.action_information30
990: from pay_action_information act_inf
991: where act_inf.action_context_id = p_last_p45_act
992: and act_inf.action_information_category = 'IE EMPLOYEE DETAILS'
993: and act_inf.action_context_type = 'AAP';
994:

Line 1484: pay_action_information_api.create_action_information (

1480:
1481:
1482: -- end bug 5383808
1483: hr_utility.set_location('Archiving IE EMPLOYEE DETAILS',50);
1484: pay_action_information_api.create_action_information (
1485: p_action_information_id => l_action_info_id
1486: , p_action_context_id => p_assactid
1487: , p_action_context_type => 'AAP'
1488: , p_object_version_number => l_ovn

Line 1714: FROM pay_action_information pai

1710:
1711: -- get balance from EMEA balances
1712: cursor get_prev_ins_bal is
1713: SELECT to_number(pai.action_information4) balance_value
1714: FROM pay_action_information pai
1715: WHERE pai.action_context_id = p_last_p45_action
1716: AND pai.action_information_category = 'EMEA BALANCES'
1717: AND pai.action_information1 = p_defined_bal_id;
1718:

Line 2356: pay_action_information_api.create_action_information (

2352:
2353: IF l_balance_value <> 0
2354: THEN
2355: hr_utility.set_location('Archiving EMEA BALANCES',20);
2356: pay_action_information_api.create_action_information (
2357: p_action_information_id => l_action_info_id
2358: , p_action_context_id => p_action_context_id
2359: , p_action_context_type => 'AAP'
2360: , p_object_version_number => l_ovn

Line 2406: FROM pay_action_information pai

2402: where defined_balance_id = p_defined_bal_id;
2403:
2404: CURSOR csr_get_curr_val(p_action_context_id NUMBER,p_def_bal_id NUMBER) IS
2405: SELECT to_number(pai.action_information4) balance_value
2406: FROM pay_action_information pai
2407: WHERE pai.action_context_id = p_action_context_id
2408: AND pai.action_information_category = 'EMEA BALANCES'
2409: AND pai.action_information1 = p_def_bal_id;
2410:

Line 2414: pay_action_information pai,

2410:
2411: -- cursor to fetch source_id from the last p45 action
2412: CURSOR get_last_source_id is
2413: select source_id from
2414: pay_action_information pai,
2415: pay_assignment_actions paa
2416: where paa.assignment_action_id = p_last_p45_action
2417: and paa.assignment_action_id = pai.action_context_id
2418: and pai.action_information_category='EMEA BALANCES';

Line 2594: pay_action_information_api.create_action_information (

2590: END IF;
2591: IF l_balance_value <> 0
2592: THEN
2593: hr_utility.set_location('Archiving EMEA BALANCES',20);
2594: pay_action_information_api.create_action_information (
2595: p_action_information_id => l_action_info_id
2596: , p_action_context_id => p_action_context_id
2597: , p_action_context_type => 'AAP'
2598: , p_object_version_number => l_ovn

Line 2682: pay_action_information act_inf

2678: from pay_assignment_actions paa_run,
2679: pay_action_interlocks pai,
2680: pay_assignment_actions paa,
2681: pay_payroll_actions ppa,
2682: pay_action_information act_inf
2683: where ppa.payroll_action_id = paa.payroll_action_id
2684: and ppa.report_type = 'P45'
2685: and ppa.report_qualifier = 'IE'
2686: and ppa.action_type = 'X'

Line 2917: from pay_action_information pai,

2913: and result_value not in ('IE_CUMULATIVE', 'C','IE_EXEMPTION');
2914: /*
2915: cursor cur_supp_run is
2916: select count(*)
2917: from pay_action_information pai,
2918: pay_assignment_Actions paa
2919: where paa.assignment_action_id = pai.action_context_id
2920: and pai.action_context_type = 'AAP'
2921: and pai.action_information_category = 'IE P45 INFORMATION'

Line 2937: pay_action_information act_inf

2933: from pay_assignment_actions paa_run,
2934: pay_action_interlocks pai,
2935: pay_assignment_actions paa,
2936: pay_payroll_actions ppa,
2937: pay_action_information act_inf
2938: where ppa.payroll_action_id = paa.payroll_action_id
2939: and ppa.report_type = 'P45'
2940: and ppa.report_qualifier = 'IE'
2941: and ppa.action_type = 'X'

Line 3174: pay_action_information_api.create_action_information (

3170: fetch cur_next_of_kin_details into cur_next_of_kin_details_rec;
3171: close cur_next_of_kin_details;
3172: --
3173: -- archive the details
3174: pay_action_information_api.create_action_information (
3175: p_action_information_id => l_action_info_id
3176: , p_action_context_id => p_action_context_id
3177: , p_action_context_type => 'AAP'
3178: , p_object_version_number => l_ovn

Line 3217: FROM pay_action_information pai

3213: CURSOR csr_check_archived(p_pact_id NUMBER) IS
3214: SELECT 1
3215: FROM DUAL
3216: WHERE EXISTS (SELECT NULL
3217: FROM pay_action_information pai
3218: WHERE pai.action_context_id = p_pact_id
3219: AND pai.action_context_type = 'PA'
3220: AND rownum = 1
3221: );

Line 3336: FROM pay_action_information pai

3332: AND cp_effective_date between paf.effective_start_date
3333: AND paf.effective_end_date
3334: AND NOT EXISTS (
3335: SELECT NULL
3336: FROM pay_action_information pai
3337: WHERE pai.action_context_id = cp_payroll_action_id
3338: AND pai.action_context_type = 'PA'
3339: AND pai.action_information_category = 'ADDRESS DETAILS'
3340: AND pai.action_information1 = paf.organization_id

Line 3425: pay_action_information_api.create_action_information (

3421: else
3422: */
3423: FOR tax_info_rec IN csr_get_org_tax_address (g_paye_ref) LOOP
3424: --
3425: pay_action_information_api.create_action_information (
3426: p_action_information_id => l_action_info_id
3427: , p_action_context_id => p_payroll_action_id
3428: , p_action_context_type => 'PA'
3429: , p_object_version_number => l_ovn

Line 3466: pay_action_information_api.create_action_information (

3462: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
3463: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
3464: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
3465: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
3466: pay_action_information_api.create_action_information (
3467: p_action_information_id => l_action_info_id
3468: , p_action_context_id => p_payroll_action_id
3469: , p_action_context_type => 'PA'
3470: , p_object_version_number => l_ovn

Line 3999: pay_action_information pai_p45,

3995: ) IS
3996: SELECT max(lpad(paa_src.action_sequence,15,'0')|| paa_src.assignment_action_id)
3997: FROM pay_payroll_actions ppa_p45,
3998: pay_assignment_actions p45_src,
3999: pay_action_information pai_p45,
4000: pay_assignment_actions paa_src
4001: WHERE ppa_p45.action_type = 'X'
4002: AND ppa_p45.report_type = 'P45'
4003: AND ppa_p45.report_qualifier = 'IE'

Line 4022: pay_action_information pai

4018: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
4019: paa.assignment_action_id),16))
4020: FROM pay_payroll_actions ppa,
4021: pay_assignment_actions paa,
4022: pay_action_information pai
4023: WHERE paa.assignment_action_id = pai.action_context_id
4024: AND pai.action_information_category = 'IE P45 INFORMATION'
4025: AND pai.action_context_type = 'AAP'
4026: AND paa.tax_unit_id = g_paye_ref

Line 4464: FROM pay_action_information pai1

4460: CURSOR csr_get_def_bal(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
4461: ,p_balance_name pay_balance_types.balance_name%TYPE
4462: ,c_ppsn_flag varchar2) IS
4463: SELECT pai1.action_information2
4464: FROM pay_action_information pai1
4465: WHERE pai1.action_context_type = 'PA'
4466: AND pai1.action_information_category = 'EMEA BALANCE DEFINITION'
4467: AND substr(pai1.action_information4, 1,50) = p_balance_name
4468: AND pai1.action_context_id = p_payroll_action_id

Line 4474: ,p_def_bal_id pay_action_information.action_information1%TYPE) IS

4470: -- and ((nvl(pai1.action_information7,'N')='N') or (pai1.action_information7='Y'))
4471: and ((nvl(pai1.action_information7,'N')='N' and c_ppsn_flag='N') or (nvl(pai1.action_information7,'N')='Y' and c_ppsn_flag='Y') ) ;
4472:
4473: CURSOR csr_get_arc_bal_value(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
4474: ,p_def_bal_id pay_action_information.action_information1%TYPE) IS
4475: SELECT to_number(pai2.action_information4) balance_value
4476: FROM pay_action_information pai2
4477: WHERE pai2.action_context_id = p_assignment_action_id
4478: AND pai2.action_information_category = 'EMEA BALANCES'

Line 4476: FROM pay_action_information pai2

4472:
4473: CURSOR csr_get_arc_bal_value(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
4474: ,p_def_bal_id pay_action_information.action_information1%TYPE) IS
4475: SELECT to_number(pai2.action_information4) balance_value
4476: FROM pay_action_information pai2
4477: WHERE pai2.action_context_id = p_assignment_action_id
4478: AND pai2.action_information_category = 'EMEA BALANCES'
4479: AND pai2.action_context_type = 'AAP'
4480: AND pai2.action_information1 = p_def_bal_id;

Line 4495: l_def_bal_id pay_action_information.action_information1%TYPE := NULL;

4491: l_ppsn_override per_assignment_extra_info.aei_information1%type;
4492: l_ppsn_override_flag varchar2(2);
4493:
4494: l_bal_value number:=null;
4495: l_def_bal_id pay_action_information.action_information1%TYPE := NULL;
4496:
4497: BEGIN
4498:
4499: --hr_utility.trace_on(null,'P45XML');

Line 4584: FROM pay_action_information pai_ed

4580: ,(round(to_number(emp_supp.lump_sum),2)*100) supp_lumpsum
4581: ,(round(to_number(emp_supp.total_prsi),2)*100) supp_totalprsi
4582: ,(round(to_number(emp_supp.total_employee_prsi),2)*100) supp_employeeprsi
4583: ,emp_supp.insurable_weeks supp_totalweeks
4584: FROM pay_action_information pai_ed
4585: ,pay_action_information pai_iep45
4586: ,pay_action_information pai_ieed
4587: ,pay_action_information pai_epif
4588: ,pay_assignment_actions paa

Line 4585: ,pay_action_information pai_iep45

4581: ,(round(to_number(emp_supp.total_prsi),2)*100) supp_totalprsi
4582: ,(round(to_number(emp_supp.total_employee_prsi),2)*100) supp_employeeprsi
4583: ,emp_supp.insurable_weeks supp_totalweeks
4584: FROM pay_action_information pai_ed
4585: ,pay_action_information pai_iep45
4586: ,pay_action_information pai_ieed
4587: ,pay_action_information pai_epif
4588: ,pay_assignment_actions paa
4589: ,pay_action_interlocks pai_arc

Line 4586: ,pay_action_information pai_ieed

4582: ,(round(to_number(emp_supp.total_employee_prsi),2)*100) supp_employeeprsi
4583: ,emp_supp.insurable_weeks supp_totalweeks
4584: FROM pay_action_information pai_ed
4585: ,pay_action_information pai_iep45
4586: ,pay_action_information pai_ieed
4587: ,pay_action_information pai_epif
4588: ,pay_assignment_actions paa
4589: ,pay_action_interlocks pai_arc
4590: ,pay_assignment_actions paa_payroll

Line 4587: ,pay_action_information pai_epif

4583: ,emp_supp.insurable_weeks supp_totalweeks
4584: FROM pay_action_information pai_ed
4585: ,pay_action_information pai_iep45
4586: ,pay_action_information pai_ieed
4587: ,pay_action_information pai_epif
4588: ,pay_assignment_actions paa
4589: ,pay_action_interlocks pai_arc
4590: ,pay_assignment_actions paa_payroll
4591: ,per_time_periods ptp

Line 4636: FROM pay_action_information pai_ed

4632: ,pai_iep45.action_information4 emergency_tax,
4633: to_date(substr(pai_iep45.action_information7, 1,30),'DD/MM/RRRR') date_paid --Bug 3991416
4634: ,pai_iep45.action_information8 person_id -- 7291676
4635: ,pai_iep45.action_information9 main_p45_date_paid -- 7291676
4636: FROM pay_action_information pai_ed
4637: ,pay_action_information pai_iep45
4638: ,pay_assignment_actions paa
4639: ,per_time_periods ptp
4640: WHERE paa.payroll_action_id = c_p45_arch_id

Line 4637: ,pay_action_information pai_iep45

4633: to_date(substr(pai_iep45.action_information7, 1,30),'DD/MM/RRRR') date_paid --Bug 3991416
4634: ,pai_iep45.action_information8 person_id -- 7291676
4635: ,pai_iep45.action_information9 main_p45_date_paid -- 7291676
4636: FROM pay_action_information pai_ed
4637: ,pay_action_information pai_iep45
4638: ,pay_assignment_actions paa
4639: ,per_time_periods ptp
4640: WHERE paa.payroll_action_id = c_p45_arch_id
4641: AND paa.assignment_action_id = pai_iep45.action_context_id

Line 4656: ,pay_action_information pai_epif

4652: SELECT pai_epif.action_information6 employer_number
4653: FROM pay_assignment_actions paa
4654: ,pay_action_interlocks pai_arc
4655: ,pay_assignment_actions paa_payroll
4656: ,pay_action_information pai_epif
4657: WHERE paa.assignment_action_id = p_assignment_action_id
4658: AND paa.assignment_action_id = pai_arc.locking_action_id
4659: AND paa_payroll.assignment_action_id = pai_arc.locked_action_id
4660: AND paa.payroll_action_id = pai_epif.action_context_ID

Line 4671: FROM pay_action_information pai_ieed

4667: ,(round(to_number(substr(nvl(pai_ieed.action_information27,'0'), 1,30)),2)*100) cutoff
4668: ,substr(pai_ieed.action_information22, 1,30) prsi_class
4669: ,(round(to_number(substr(nvl(pai_ieed.action_information20,'0'), 1,30)),2)*100) usccutoff1 -- BUG 13359530
4670: ,(round(to_number(substr(nvl(pai_ieed.action_information19,'0'), 1,30)),2)*100) usccutoff2
4671: FROM pay_action_information pai_ieed
4672: WHERE pai_ieed.action_context_ID = p_assignment_action_id
4673: AND pai_ieed.action_context_type = 'AAP'
4674: AND pai_ieed.action_information_category = 'IE EMPLOYEE DETAILS';
4675: cur_p45_ie_emp_details_rec cur_p45_ie_emp_details%ROWTYPE;

Line 4774: FROM pay_action_information pai

4770: ,substr(pai.action_information7,1,30) employer_tax_addr3
4771: ,substr(pai.action_information26,1,30) employer_tax_contact
4772: ,substr(pai.action_information27,1,12) employer_tax_ref_phone
4773: ,substr(pai.action_information28,1,30) employer_tax_rep_name
4774: FROM pay_action_information pai
4775: WHERE pai.action_context_id = c_payroll_action_id
4776: AND pai.action_context_type = 'PA'
4777: AND pai.action_information_category = 'ADDRESS DETAILS'
4778: AND pai.action_information14 = 'IE Employer Tax Address';