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

Line 279: FROM pay_action_information pai

275: CURSOR csr_prev_basis_amt (c_assignment_id IN NUMBER
276: ,c_effective_date IN DATE
277: ,c_pension_type IN VARCHAR2) IS
278: SELECT fnd_number.canonical_to_number(pai.action_information7) contr_base
279: FROM pay_action_information pai
280: WHERE pai.action_information_category = 'NL_ABP_PENSION_INFO'
281: AND pai.action_context_type = 'AAP'
282: AND pai.assignment_id = c_assignment_id
283: AND pai.action_information1 = c_pension_type

Line 294: FROM pay_action_information pai

290: CURSOR csr_get_prev_hire_info(c_asg_id IN NUMBER
291: ,c_effective_date IN DATE)
292: IS
293: SELECT 1
294: FROM pay_action_information pai
295: WHERE pai.assignment_id = c_asg_id
296: AND pai.action_information_category = 'NL_ABP_ASG_INFO'
297: AND pai.action_context_type = 'AAP'
298: AND c_effective_date = fnd_date.canonical_to_date(pai.action_information3);

Line 312: pay_action_information_api.create_action_information

308:
309: l_ovnum number;
310: l_action_infor_id number;
311: BEGIN
312: pay_action_information_api.create_action_information
313: (p_action_information_id => l_action_infor_id
314: , p_action_context_id => p_action_context_id
315: , p_action_context_type => 'PA'
316: , p_object_version_number => l_ovnum

Line 1891: FROM pay_action_information pai

1887: ,c_effective_date IN DATE
1888: ,c_pension_type IN VARCHAR2
1889: ,c_pension_type_variant IN VARCHAR2) IS
1890: SELECT fnd_number.canonical_to_number(pai.action_information8) contr_amt
1891: FROM pay_action_information pai
1892: WHERE pai.action_information_category = 'NL_ABP_PENSION_INFO'
1893: AND pai.action_context_type = 'AAP'
1894: AND pai.assignment_id = c_assignment_id
1895: AND pai.action_information1 = c_pension_type

Line 2827: FROM pay_action_information pai

2823: SELECT *
2824: FROM (
2825: SELECT pai.action_information1 start_date
2826: , least (fnd_number.canonical_to_number (paei.aei_information5), 1) * 100 vop
2827: FROM pay_action_information pai
2828: , per_assignment_extra_info paei
2829: WHERE paei.information_type = 'NL_ABP_PAR_INFO'
2830: AND paei.aei_information_category = 'NL_ABP_PAR_INFO'
2831: AND paei.assignment_id = pai.assignment_id

Line 2840: FROM pay_action_information pai

2836: AND pai.action_information3 <> 'WNE'
2837: UNION
2838: SELECT pai.action_information1 start_date
2839: , NULL vop
2840: FROM pay_action_information pai
2841: WHERE pai.action_context_id = c_ass_act_id
2842: AND pai.action_information_category = 'NL_ABP_PAY_PERIOD_INFO'
2843: AND pai.assignment_id = c_assignment_id
2844: AND action_information3 = 'WNE'

Line 3117: FROM pay_action_information pai

3113: --=========================================================================
3114: --Assignment already withdrawn
3115: CURSOR csr_prev_withdrawn(c_asg_id IN NUMBER) IS
3116: SELECT 1
3117: FROM pay_action_information pai
3118: WHERE pai.action_information_category = 'NL_ABP_COMP_WITHDRAWAL_INFO'
3119: AND pai.action_context_type = 'AAP'
3120: AND pai.assignment_id = c_asg_id;
3121: --=========================================================================

Line 3128: FROM pay_action_information pai1

3124: CURSOR csr_get_prev_asg_info(c_asg_id IN NUMBER)
3125: IS
3126: SELECT distinct fnd_date.canonical_to_date(pai1.action_information7) start_date
3127: ,fnd_date.canonical_to_date(pai1.action_information4) term_date
3128: FROM pay_action_information pai1
3129: WHERE pai1.assignment_id = c_asg_id
3130: AND pai1.action_information_category = 'NL_ABP_ASG_INFO'
3131: AND pai1.action_context_type = 'AAP'
3132: --AND pai1.action_information4 IS NOT NULL

Line 3142: FROM pay_action_information pai1

3138: CURSOR csr_get_prev_asg_info2(c_asg_id IN NUMBER)
3139: IS
3140: SELECT distinct fnd_date.canonical_to_date(pai1.action_information7) start_date
3141: ,fnd_date.canonical_to_date(pai1.action_information4) term_date
3142: FROM pay_action_information pai1
3143: WHERE pai1.assignment_id = c_asg_id
3144: AND pai1.action_information_category = 'NL_ABP_ASG_INFO'
3145: AND pai1.action_context_type = 'AAP'
3146: AND pai1.action_information4 IS NOT NULL

Line 3154: FROM pay_action_information pai

3150: CURSOR csr_get_prev_asg_info3(c_asg_id IN NUMBER)
3151: IS
3152: SELECT DISTINCT fnd_date.canonical_to_date (pai.action_information7) start_date
3153: , fnd_date.canonical_to_date (pai.action_information4) term_date
3154: FROM pay_action_information pai
3155: WHERE pai.assignment_id = c_asg_id
3156: AND pai.action_information_category = 'NL_ABP_ASG_INFO'
3157: AND pai.action_context_type = 'AAP'
3158: AND pai.action_information4 IS NOT NULL

Line 3162: FROM pay_action_information pai1

3158: AND pai.action_information4 IS NOT NULL
3159: AND NOT EXISTS
3160: (
3161: SELECT 1
3162: FROM pay_action_information pai1
3163: WHERE pai.assignment_id = pai1.assignment_id
3164: AND fnd_date.canonical_to_date (pai1.action_information3) = fnd_date.canonical_to_date (pai.action_information3)
3165: AND pai1.action_information_category = 'NL_ABP_ASG_INFO'
3166: AND pai1.action_context_type = 'AAP'

Line 3490: pay_action_information_api.create_action_information

3486: l_kop_report := 'N';
3487: fnd_message.set_name('PER','HR_NL_373556_DEFAULTED');
3488: fnd_message.set_token('VALUE','WNE');
3489: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','PARTICIPATION_KIND'));
3490: pay_action_information_api.create_action_information
3491: (
3492: p_action_information_id => l_action_info_id
3493: , p_action_context_id => l_child_aa_id
3494: , p_action_context_type => 'AAP'

Line 3512: pay_action_information_api.create_action_information

3508: l_kop_invalid := 'N';
3509: fnd_message.set_name('PER','HR_374602_INVALID_VALUE');
3510: fnd_message.set_token('VALUE',l_part_details.kop);
3511: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','PARTICIPATION_KIND'));
3512: pay_action_information_api.create_action_information
3513: (
3514: p_action_information_id => l_action_info_id
3515: , p_action_context_id => l_child_aa_id
3516: , p_action_context_type => 'AAP'

Line 3570: pay_action_information_api.create_action_information

3566: END IF;
3567:
3568: IF l_wne_start_date IS NOT NULL AND l_wne_end_date IS NOT NULL AND l_wne_start_date < l_end_date THEN
3569: hr_utility.trace('1.Archiving Pay Period Details-WNE');
3570: pay_action_information_api.create_action_information
3571: (
3572: p_action_information_id => l_action_info_id
3573: , p_action_context_id => l_child_aa_id
3574: , p_action_context_type => 'AAP'

Line 3594: pay_action_information_api.create_action_information

3590: l_kop_report := 'N';
3591: fnd_message.set_name('PER','HR_NL_373556_DEFAULTED');
3592: fnd_message.set_token('VALUE','WNE');
3593: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','PARTICIPATION_KIND'));
3594: pay_action_information_api.create_action_information
3595: (
3596: p_action_information_id => l_action_info_id
3597: , p_action_context_id => l_child_aa_id
3598: , p_action_context_type => 'AAP'

Line 3629: pay_action_information_api.create_action_information

3625: END IF;
3626: END IF;
3627:
3628: hr_utility.trace('1.Archiving Pay Period Details-!WNE');
3629: pay_action_information_api.create_action_information
3630: (
3631: p_action_information_id => l_action_info_id
3632: , p_action_context_id => l_child_aa_id
3633: , p_action_context_type => 'AAP'

Line 3658: pay_action_information_api.create_action_information

3654: l_kop_report := 'N';
3655: fnd_message.set_name('PER','HR_NL_373556_DEFAULTED');
3656: fnd_message.set_token('VALUE','WNE');
3657: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','PARTICIPATION_KIND'));
3658: pay_action_information_api.create_action_information
3659: (
3660: p_action_information_id => l_action_info_id
3661: , p_action_context_id => l_child_aa_id
3662: , p_action_context_type => 'AAP'

Line 3688: pay_action_information_api.create_action_information

3684: ELSE
3685: l_wne_end_date := NULL;
3686: END IF;
3687: hr_utility.trace('2.Archiving Pay Period Details- WNE');
3688: pay_action_information_api.create_action_information
3689: (
3690: p_action_information_id => l_action_info_id
3691: , p_action_context_id => l_child_aa_id
3692: , p_action_context_type => 'AAP'

Line 3736: pay_action_information_api.create_action_information

3732: ELSE
3733: l_pension_st_date := l_all_contr_amt_values(i).date_earned;
3734: END IF;
3735:
3736: pay_action_information_api.create_action_information
3737: (
3738: p_action_information_id => l_action_info_id
3739: , p_action_context_id => l_child_aa_id
3740: , p_action_context_type => 'AAP'

Line 3769: pay_action_information_api.create_action_information

3765: ,c_start_date => p_start_date
3766: ,c_end_date => p_end_date) LOOP
3767: hr_utility.trace('X====NL_ABP_WITHDRAWAL_INFO=======================X: '||p_person_id);
3768: hr_utility.trace('lv_wth_old_start: '||rec_wth_old_start.date_earned);
3769: pay_action_information_api.create_action_information
3770: (
3771: p_action_information_id => l_action_info_id
3772: , p_action_context_id => l_child_aa_id
3773: , p_action_context_type => 'AAP'

Line 3921: pay_action_information_api.create_action_information

3917: --
3918: IF l_person_info.init = '' OR l_person_info.init IS NULL THEN
3919: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');
3920: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','INITIALS'));
3921: pay_action_information_api.create_action_information
3922: (
3923: p_action_information_id => l_action_info_id
3924: , p_action_context_id => l_child_aa_id
3925: , p_action_context_type => 'AAP'

Line 3943: pay_action_information_api.create_action_information

3939: fnd_message.set_name('PER','HR_374602_INVALID_VALUE');
3940: fnd_message.set_token('VALUE',l_person_info.init);
3941: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','INITIALS'));
3942: l_person_info.init := substr(l_person_info.init, 1, 6);
3943: pay_action_information_api.create_action_information
3944: (
3945: p_action_information_id => l_action_info_id
3946: , p_action_context_id => l_child_aa_id
3947: , p_action_context_type => 'AAP'

Line 3965: pay_action_information_api.create_action_information

3961: --
3962: IF l_person_info.employee_number IS NULL THEN
3963: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');
3964: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','EMPLOYEE_NUMBER'));
3965: pay_action_information_api.create_action_information
3966: (
3967: p_action_information_id => l_action_info_id
3968: , p_action_context_id => l_child_aa_id
3969: , p_action_context_type => 'AAP'

Line 3987: pay_action_information_api.create_action_information

3983: fnd_message.set_name('PER','HR_374602_INVALID_VALUE');
3984: fnd_message.set_token('VALUE',l_person_info.employee_number);
3985: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','EMPLOYEE_NUMBER'));
3986: l_person_info.employee_number := substr(l_person_info.employee_number,-15); --fetch last fifteen digits
3987: pay_action_information_api.create_action_information
3988: (
3989: p_action_information_id => l_action_info_id
3990: , p_action_context_id => l_child_aa_id
3991: , p_action_context_type => 'AAP'

Line 4013: pay_action_information_api.create_action_information

4009: fnd_message.set_name('PER','HR_NL_373556_DEFAULTED');
4010: fnd_message.set_token('VALUE','000000000');
4011: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','BSN'));
4012: l_person_info.sofi_number := '000000000';
4013: pay_action_information_api.create_action_information
4014: (
4015: p_action_information_id => l_action_info_id
4016: , p_action_context_id => l_child_aa_id
4017: , p_action_context_type => 'AAP'

Line 4035: pay_action_information_api.create_action_information

4031: fnd_message.set_name('PER','HR_374602_INVALID_VALUE');
4032: fnd_message.set_token('VALUE',l_person_info.sofi_number);
4033: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','BSN'));
4034: l_person_info.sofi_number := substr(l_person_info.sofi_number, 1, 9);
4035: pay_action_information_api.create_action_information
4036: (
4037: p_action_information_id => l_action_info_id
4038: , p_action_context_id => l_child_aa_id
4039: , p_action_context_type => 'AAP'

Line 4084: pay_action_information_api.create_action_information

4080: hr_utility.trace('Prev Period Start Date ' ||l_prev_asg_info.start_date);
4081: hr_utility.trace('Prev Termination Date ' ||l_prev_asg_info.term_date);
4082: hr_utility.trace('End Date ' ||l_asg_end_date);
4083:
4084: pay_action_information_api.create_action_information
4085: (
4086: p_action_information_id => l_action_info_id
4087: , p_action_context_id => l_child_aa_id
4088: , p_action_context_type => 'AAP'

Line 4157: pay_action_information_api.create_action_information

4153: ||l_kind_emp);*/
4154:
4155: hr_utility.trace('Archiving Assignment Info : ');
4156:
4157: pay_action_information_api.create_action_information
4158: (
4159: p_action_information_id => l_action_info_id
4160: , p_action_context_id => l_child_aa_id
4161: , p_action_context_type => 'AAP'

Line 4238: pay_action_information_api.create_action_information

4234: l_iso := l_person_addr.iso;
4235: END IF;
4236:
4237: IF l_street IS NULL THEN
4238: pay_action_information_api.create_action_information
4239: (
4240: p_action_information_id => l_action_info_id
4241: , p_action_context_id => l_child_aa_id
4242: , p_action_context_type => 'AAP'

Line 4261: pay_action_information_api.create_action_information

4257: /* --15859347
4258: IF l_house_number IS NULL THEN
4259: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');
4260: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','HOUSE_NUMBER'));
4261: pay_action_information_api.create_action_information
4262: (
4263: p_action_information_id => l_action_info_id
4264: , p_action_context_id => l_child_aa_id
4265: , p_action_context_type => 'AAP'

Line 4282: pay_action_information_api.create_action_information

4278: END IF;
4279: */ --15859347
4280: --
4281: IF l_city IS NULL THEN
4282: pay_action_information_api.create_action_information
4283: (
4284: p_action_information_id => l_action_info_id
4285: , p_action_context_id => l_child_aa_id
4286: , p_action_context_type => 'AAP'

Line 4306: pay_action_information_api.create_action_information

4302: fnd_message.set_name('PER','HR_NL_373556_DEFAULTED');
4303: fnd_message.set_token('VALUE','0000AA');
4304: fnd_message.set_token('FIELD',hr_general.decode_lookup('NL_FORM_LABELS','POSTAL_CODE'));
4305: l_postal_code := '0000AA';
4306: pay_action_information_api.create_action_information
4307: (
4308: p_action_information_id => l_action_info_id
4309: , p_action_context_id => l_child_aa_id
4310: , p_action_context_type => 'AAP'

Line 4328: pay_action_information_api.create_action_information

4324: --
4325: IF l_person_addr.style = 'NL_GLB' AND l_iso IS NULL THEN
4326: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');
4327: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','ISO_CODE'));
4328: pay_action_information_api.create_action_information
4329: (
4330: p_action_information_id => l_action_info_id
4331: , p_action_context_id => l_child_aa_id
4332: , p_action_context_type => 'AAP'

Line 4353: pay_action_information_api.create_action_information

4349:
4350: IF l_nationality IS NULL THEN
4351: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');
4352: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','NATIONALITY'));
4353: pay_action_information_api.create_action_information
4354: (
4355: p_action_information_id => l_action_info_id
4356: , p_action_context_id => l_child_aa_id
4357: , p_action_context_type => 'AAP'

Line 4379: pay_action_information_api.create_action_information

4375: CLOSE csr_prin_obj;
4376:
4377: hr_utility.trace('Archiving Person Data : ');
4378:
4379: pay_action_information_api.create_action_information
4380: (
4381: p_action_information_id => l_action_info_id
4382: , p_action_context_id => l_child_aa_id
4383: , p_action_context_type => 'AAP'

Line 4496: pay_action_information_api.create_action_information

4492: hr_utility.trace('months_between(l_wth_prd_start_date,l_asg_start_date) : '||months_between(l_wth_prd_start_date,l_asg_start_date));
4493: IF l_pay_period_det_cnt = months_between(trunc(l_wth_prd_start_date,'MM'),trunc(l_asg_start_date,'MM')) THEN
4494: l_code_withdrawal := 'ja';
4495: END IF;
4496: pay_action_information_api.create_action_information
4497: (
4498: p_action_information_id => l_action_info_id
4499: , p_action_context_id => l_child_aa_id
4500: , p_action_context_type => 'AAP'

Line 4597: FROM pay_action_information pai_p

4593: ,fnd_date.date_to_displaydate(fnd_date.canonical_to_date(pai_p.action_information5)) Dt
4594: ,pai_p.action_information6 Description
4595: ,substr(pai_p.action_information7,1,30) E_Name
4596: ,pai_p.action_context_type cxt
4597: FROM pay_action_information pai_p
4598: WHERE pai_p.action_context_id = p_payroll_action_id
4599: AND pai_p.action_information_category = 'NL_ABP_EXCEPTION_REPORT'
4600: AND pai_p.action_context_type = 'PA';
4601: --=========================================================================

Line 4610: ,pay_action_information pai_p

4606: ,substr(pai_p.action_information7,1,45) E_Name
4607: ,substr(pai_p.action_information8,1,30) E_Number
4608: ,pai_p.action_context_type cxt
4609: FROM pay_assignment_actions paa
4610: ,pay_action_information pai_p
4611: WHERE paa.payroll_action_id = p_payroll_action_id
4612: AND pai_p.action_context_id = paa.assignment_action_id
4613: AND pai_p.action_information_category = 'NL_ABP_EXCEPTION_REPORT'
4614: AND pai_p.action_context_type = 'AAP'

Line 4624: FROM pay_action_information pai_p

4620: ,fnd_date.date_to_displaydate (fnd_date.canonical_to_date (pai_p.action_information5)) dt
4621: ,pai_p.action_information6 description
4622: ,substr (pai_p.action_information7, 1, 30) e_name
4623: ,pai_p.action_context_type cxt
4624: FROM pay_action_information pai_p
4625: WHERE pai_p.action_context_id = p_payroll_action_id
4626: AND pai_p.action_information_category = 'NL_ABP_TECH_EXCEPTION_REPORT';
4627: --=========================================================================
4628:

Line 4681: pay_action_information_api.create_action_information

4677: IF csr_get_sender_details%FOUND THEN
4678: IF l_sender_details.reg_num_sender IS NULL THEN
4679: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');
4680: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','ABP_SENDER'));
4681: pay_action_information_api.create_action_information
4682: (
4683: p_action_information_id => l_action_info_id
4684: , p_action_context_id => p_payroll_action_id
4685: , p_action_context_type => 'PA'

Line 4701: pay_action_information_api.create_action_information

4697: END IF;
4698: IF l_sender_details.prod_test IS NULL THEN
4699: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');
4700: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','TEST_FLAG'));
4701: pay_action_information_api.create_action_information
4702: (
4703: p_action_information_id => l_action_info_id
4704: , p_action_context_id => p_payroll_action_id
4705: , p_action_context_type => 'PA'

Line 4721: pay_action_information_api.create_action_information

4717: END IF;
4718: ELSE
4719: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');
4720: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','ABP_SENDER'));
4721: pay_action_information_api.create_action_information
4722: (
4723: p_action_information_id => l_action_info_id
4724: , p_action_context_id => p_payroll_action_id
4725: , p_action_context_type => 'PA'

Line 4740: pay_action_information_api.create_action_information

4736: , p_action_information7 => substr(l_er_name,1,200));
4737:
4738: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');
4739: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','TEST_FLAG'));
4740: pay_action_information_api.create_action_information
4741: (
4742: p_action_information_id => l_action_info_id
4743: , p_action_context_id => p_payroll_action_id
4744: , p_action_context_type => 'PA'

Line 4763: pay_action_information_api.create_action_information

4759: OPEN csr_app_version;
4760: FETCH csr_app_version into l_get_app_ver;
4761: CLOSE csr_app_version;
4762:
4763: pay_action_information_api.create_action_information
4764: (
4765: p_action_information_id => l_action_info_id
4766: , p_action_context_id => p_payroll_action_id
4767: , p_action_context_type => 'PA'

Line 4833: pay_action_information_api.create_action_information

4829: END LOOP;
4830: END IF;
4831:
4832: IF l_er_num IS NULL THEN
4833: pay_action_information_api.create_action_information
4834: (
4835: p_action_information_id => l_action_info_id
4836: , p_action_context_id => p_payroll_action_id
4837: , p_action_context_type => 'PA'

Line 4855: pay_action_information_api.create_action_information

4851:
4852: IF l_freq IS NULL THEN
4853: fnd_message.set_name('PER','HR_6001_ALL_MANDATORY_FIELD');
4854: fnd_message.set_token('MISSING_FIELD',hr_general.decode_lookup('NL_FORM_LABELS','FREQUENCY'));
4855: pay_action_information_api.create_action_information
4856: (
4857: p_action_information_id => l_action_info_id
4858: , p_action_context_id => p_payroll_action_id
4859: , p_action_context_type => 'PA'

Line 4874: pay_action_information_api.create_action_information

4870: , p_action_information7 => substr(l_er_name,1,200)
4871: , p_action_information8 => substr(l_er_num,1,12));
4872: END IF;
4873:
4874: pay_action_information_api.create_action_information
4875: (
4876: p_action_information_id => l_action_info_id
4877: , p_action_context_id => p_payroll_action_id
4878: , p_action_context_type => 'PA'