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_WAGE_REPORT_PKG dependencies on PAY_ACTION_INFORMATION_API

Line 2711: pay_action_information_api.create_action_information

2707: l_tax_details.tax_reg_num := NVL(l_tax_ref_no,l_tax_details.tax_reg_num);
2708: --
2709: --Archiving Employee Data NL_WR_EMPLOYER_INFO
2710: --Fnd_file.put_line(FND_FILE.LOG,' Archiving NL_WR_EMPLOYER_INFO deinit code ');
2711: pay_action_information_api.create_action_information
2712: (
2713: p_action_information_id => l_action_info_id
2714: , p_action_context_id => p_actid
2715: , p_action_context_type => 'PA'

Line 3108: pay_action_information_api.create_action_information

3104: --
3105: --
3106: --
3107: IF l_empr_contact.sender_id IS NULL THEN
3108: pay_action_information_api.create_action_information
3109: (
3110: p_action_information_id => l_action_info_id
3111: , p_action_context_id => p_actid
3112: , p_action_context_type => 'PA'

Line 3128: pay_action_information_api.create_action_information

3124: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3125: END IF;
3126: --
3127: IF l_empr_contact.contact_name IS NULL THEN
3128: pay_action_information_api.create_action_information
3129: (
3130: p_action_information_id => l_action_info_id
3131: , p_action_context_id => p_actid
3132: , p_action_context_type => 'PA'

Line 3148: pay_action_information_api.create_action_information

3144: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3145: END IF;
3146: --
3147: IF l_empr_contact.contact_num IS NULL THEN
3148: pay_action_information_api.create_action_information
3149: (
3150: p_action_information_id => l_action_info_id
3151: , p_action_context_id => p_actid
3152: , p_action_context_type => 'PA'

Line 3168: pay_action_information_api.create_action_information

3164: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3165: END IF;
3166: --
3167: IF l_tax_details.tax_reg_num IS NULL THEN
3168: pay_action_information_api.create_action_information
3169: (
3170: p_action_information_id => l_action_info_id
3171: , p_action_context_id => p_actid
3172: , p_action_context_type => 'PA'

Line 3189: pay_action_information_api.create_action_information

3185: END IF;
3186: --
3187: IF hr_ni_chk_pkg.chk_nat_id_format(l_tax_details.tax_reg_num,'DDDDDDDDDADD') <> upper(l_tax_details.tax_reg_num) OR
3188: substr(l_tax_details.tax_reg_num,10,1) <> 'L' THEN
3189: pay_action_information_api.create_action_information
3190: (
3191: p_action_information_id => l_action_info_id
3192: , p_action_context_id => p_actid
3193: , p_action_context_type => 'PA'

Line 3209: pay_action_information_api.create_action_information

3205: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3206: END IF;
3207: --
3208: IF l_tax_details.tax_rep_name IS NULL THEN
3209: pay_action_information_api.create_action_information
3210: (
3211: p_action_information_id => l_action_info_id
3212: , p_action_context_id => p_actid
3213: , p_action_context_type => 'PA'

Line 3230: pay_action_information_api.create_action_information

3226: END IF;
3227: --
3228: --Archiving Employee Data NL_WR_EMPLOYER_INFO
3229: --Fnd_file.put_line(FND_FILE.LOG,' Archiving NL_WR_EMPLOYER_INFO deinit code ');
3230: pay_action_information_api.create_action_information
3231: (
3232: p_action_information_id => l_action_info_id
3233: , p_action_context_id => p_actid
3234: , p_action_context_type => 'PA'

Line 3287: pay_action_information_api.create_action_information

3283: l_sip_sector := NVL(l_sip_sector,l_get_sect_risk_grp.sector);
3284: l_risk_grp := NVL(l_risk_grp,l_get_sect_risk_grp.risk_group);
3285: IF l_sip_sector <> l_get_sect_risk_grp.sector OR l_risk_grp <> l_get_sect_risk_grp.risk_group THEN
3286: --Fnd_file.put_line(FND_FILE.LOG,' Archiving Sector Risk Group Information');
3287: pay_action_information_api.create_action_information
3288: ( p_action_information_id => l_action_info_id
3289: , p_action_context_id => p_actid
3290: , p_action_context_type => 'PA'
3291: , p_object_version_number => l_ovn

Line 3330: pay_action_information_api.create_action_information

3326: --
3327: END LOOP;
3328: IF l_sip_sector IS NOT NULL OR l_risk_grp IS NOT NULL THEN
3329: --Fnd_file.put_line(FND_FILE.LOG,' Archiving Sector Risk Group Information');
3330: pay_action_information_api.create_action_information
3331: ( p_action_information_id => l_action_info_id
3332: , p_action_context_id => p_actid
3333: , p_action_context_type => 'PA'
3334: , p_object_version_number => l_ovn

Line 3371: pay_action_information_api.create_action_information

3367: IF collXMLTable(i).Mandatory = 'Y' or collXMLTable(i).TagValue <> 0 THEN
3368: IF collXMLTable(i).TagName = 'TotTeBet' THEN
3369: l_val := l_emp_total;
3370: END IF;
3371: pay_action_information_api.create_action_information
3372: ( p_action_information_id => l_action_info_id
3373: , p_action_context_id => p_actid
3374: , p_action_context_type => 'PA'
3375: , p_object_version_number => l_ovn

Line 3396: pay_action_information_api.create_action_information

3392: END LOOP;
3393: --
3394: IF g_public_org_flag = 'N' THEN
3395: IF l_sector_flag = 'N' THEN
3396: pay_action_information_api.create_action_information
3397: (
3398: p_action_information_id => l_action_info_id
3399: , p_action_context_id => p_actid
3400: , p_action_context_type => 'PA'

Line 3414: pay_action_information_api.create_action_information

3410: , p_action_information6 => 'Mandatory check on Sector'
3411: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
3412: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3413: --
3414: pay_action_information_api.create_action_information
3415: (
3416: p_action_information_id => l_action_info_id
3417: , p_action_context_id => p_actid
3418: , p_action_context_type => 'PA'

Line 3434: pay_action_information_api.create_action_information

3430: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3431: END IF;
3432: --
3433: IF l_awf <> 'N' AND l_c_base_mon_fd_z = 'Y' THEN
3434: pay_action_information_api.create_action_information
3435: (
3436: p_action_information_id => l_action_info_id
3437: , p_action_context_id => p_actid
3438: , p_action_context_type => 'PA'

Line 3454: pay_action_information_api.create_action_information

3450: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3451: END IF;
3452: --
3453: IF l_awf = 'N' AND l_c_base_mon_fd_z <> 'Y' THEN
3454: pay_action_information_api.create_action_information
3455: (
3456: p_action_information_id => l_action_info_id
3457: , p_action_context_id => p_actid
3458: , p_action_context_type => 'PA'

Line 3531: pay_action_information_api.create_action_information

3527: --
3528: END IF;
3529: l_emp_total := l_emp_total + l_corr_bal;
3530: --Fnd_file.put_line(FND_FILE.LOG,'Archiving NL_WR_COLLECTIVE_REPORT - CORR_BALANCE ');
3531: pay_action_information_api.create_action_information
3532: ( p_action_information_id => l_action_info_id
3533: , p_action_context_id => p_actid
3534: , p_action_context_type => 'PA'
3535: , p_object_version_number => l_ovn

Line 3551: pay_action_information_api.create_action_information

3547: , p_action_information6 => fnd_number.number_to_canonical(ROUND(l_corr_bal)));
3548: END LOOP;
3549: -- Employer general total
3550: --Fnd_file.put_line(FND_FILE.LOG,'Archiving NL_WR_COLLECTIVE_REPORT - TOTAL ');
3551: pay_action_information_api.create_action_information
3552: (p_action_information_id => l_action_info_id
3553: ,p_action_context_id => p_actid
3554: ,p_action_context_type => 'PA'
3555: ,p_object_version_number => l_ovn

Line 3600: pay_action_information_api.create_action_information

3596: l_sip_sector := NVL(l_sip_sector,l_get_sect_risk_grp.sector);
3597: l_risk_grp := NVL(l_risk_grp,l_get_sect_risk_grp.risk_group);
3598: IF l_sip_sector <> l_get_sect_risk_grp.sector OR l_risk_grp <> l_get_sect_risk_grp.risk_group THEN
3599: --Fnd_file.put_line(FND_FILE.LOG,'Archiving NL_WR_SWMF_SECTOR_RISK_GROUP -- CORRECTION');
3600: pay_action_information_api.create_action_information
3601: (
3602: p_action_information_id => l_action_info_id
3603: , p_action_context_id => p_actid
3604: , p_action_context_type => 'PA'

Line 3646: pay_action_information_api.create_action_information

3642: --l_emp_total := l_emp_total + l_con_mon_fd;
3643: --
3644: END LOOP;
3645: IF l_sip_sector IS NOT NULL OR l_risk_grp IS NOT NULL THEN
3646: pay_action_information_api.create_action_information
3647: (
3648: p_action_information_id => l_action_info_id
3649: , p_action_context_id => p_actid
3650: , p_action_context_type => 'PA'

Line 3684: pay_action_information_api.create_action_information

3680: --##--Fnd_file.put_line(FND_FILE.LOG,'#########'||'CORRECTION '||collXMLTable(i).TagName||' '||collXMLTable(i).TagValue||' '||collXMLTable(i).Mandatory);
3681: IF collXMLTable(i).TagName = 'TotTeBet' THEN
3682: l_val := l_emp_total;
3683: END IF;
3684: pay_action_information_api.create_action_information
3685: (
3686: p_action_information_id => l_action_info_id
3687: , p_action_context_id => p_actid
3688: , p_action_context_type => 'PA'

Line 3710: pay_action_information_api.create_action_information

3706: END LOOP;
3707: --
3708: IF g_public_org_flag = 'N' THEN
3709: IF l_sector_flag = 'N' THEN
3710: pay_action_information_api.create_action_information
3711: (
3712: p_action_information_id => l_action_info_id
3713: , p_action_context_id => p_actid
3714: , p_action_context_type => 'PA'

Line 3728: pay_action_information_api.create_action_information

3724: , p_action_information6 => 'Mandatory check on Sector'
3725: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
3726: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3727: --
3728: pay_action_information_api.create_action_information
3729: (
3730: p_action_information_id => l_action_info_id
3731: , p_action_context_id => p_actid
3732: , p_action_context_type => 'PA'

Line 3748: pay_action_information_api.create_action_information

3744: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3745: END IF;
3746: --
3747: IF l_awf <> 'N' AND l_c_base_mon_fd_z = 'Y' THEN
3748: pay_action_information_api.create_action_information
3749: (
3750: p_action_information_id => l_action_info_id
3751: , p_action_context_id => p_actid
3752: , p_action_context_type => 'PA'

Line 3768: pay_action_information_api.create_action_information

3764: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
3765: END IF;
3766: --
3767: IF l_awf = 'N' AND l_c_base_mon_fd_z <> 'Y' THEN
3768: pay_action_information_api.create_action_information
3769: (
3770: p_action_information_id => l_action_info_id
3771: , p_action_context_id => p_actid
3772: , p_action_context_type => 'PA'

Line 3808: pay_action_information_api.create_action_information

3804: --
3805: OPEN csr_employer_info('NL_WR_EMPLOYER_INFO',csr_get_pactid_rec.payroll_action_id);
3806: FETCH csr_employer_info INTO csr_employer_info_rec;
3807: --
3808: pay_action_information_api.create_action_information
3809: (
3810: p_action_information_id => l_action_info_id
3811: , p_action_context_id => p_actid
3812: , p_action_context_type => 'PA'

Line 3836: pay_action_information_api.create_action_information

3832: --
3833: CLOSE csr_employer_info;
3834: --
3835: FOR csr_exception_info_rec IN csr_employer_info('NL_WR_EXCEPTION_REPORT',csr_get_pactid_rec.payroll_action_id) LOOP
3836: pay_action_information_api.create_action_information
3837: (
3838: p_action_information_id => l_action_info_id
3839: , p_action_context_id => p_actid
3840: , p_action_context_type => 'PA'

Line 4166: pay_action_information_api.create_action_information

4162: l_risk_group := csr_swmf_info_rec.action_information8;
4163: l_c_base_mon_fd := csr_swmf_info_rec.action_information9;
4164: l_con_mon_fd := csr_swmf_info_rec.action_information10;
4165: --
4166: pay_action_information_api.create_action_information
4167: (p_action_information_id => l_action_info_id
4168: ,p_action_context_id => p_actid
4169: ,p_action_context_type => 'PA'
4170: ,p_object_version_number => l_ovn

Line 4189: pay_action_information_api.create_action_information

4185: END LOOP;
4186: --
4187: FOR i IN collXMLTable.FIRST..collXMLTable.LAST LOOP
4188: IF collXMLTable(i).Mandatory = 'Y' or collXMLTable(i).TagValue <> 0 THEN
4189: pay_action_information_api.create_action_information
4190: ( p_action_information_id => l_action_info_id
4191: , p_action_context_id => p_actid
4192: , p_action_context_type => 'PA'
4193: , p_object_version_number => l_ovn

Line 4209: pay_action_information_api.create_action_information

4205: , p_action_information6 => fnd_number.number_to_canonical(ROUND(collXMLTable(i).TagValue)));
4206: END IF;
4207: END LOOP;
4208: --
4209: pay_action_information_api.create_action_information
4210: (p_action_information_id => l_action_info_id
4211: ,p_action_context_id => p_actid
4212: ,p_action_context_type => 'PA'
4213: ,p_object_version_number => l_ovn

Line 4784: pay_action_information_api.create_action_information

4780: IF p_type IN ('INITIAL','CORRECTION') THEN
4781: --
4782: IF (l_addr.style = 'NL' AND l_addr.street_name IS NULL) OR
4783: (l_addr.style <> 'NL' AND l_addr.address_line1 IS NULL)THEN
4784: pay_action_information_api.create_action_information
4785: (
4786: p_action_information_id => l_action_info_id
4787: , p_action_context_id => p_assactid
4788: , p_action_context_type => 'AAP'

Line 4804: pay_action_information_api.create_action_information

4800: , p_action_information8 => p_assignment_number);
4801: END IF;
4802: --
4803: IF l_addr.town_or_city IS NULL THEN
4804: pay_action_information_api.create_action_information
4805: (
4806: p_action_information_id => l_action_info_id
4807: , p_action_context_id => p_assactid
4808: , p_action_context_type => 'AAP'

Line 4824: pay_action_information_api.create_action_information

4820: , p_action_information8 => p_assignment_number);
4821: END IF;
4822: --
4823: IF l_addr.postal_code IS NULL AND l_addr.style = 'NL' THEN
4824: pay_action_information_api.create_action_information
4825: (
4826: p_action_information_id => l_action_info_id
4827: , p_action_context_id => p_assactid
4828: , p_action_context_type => 'AAP'

Line 4844: pay_action_information_api.create_action_information

4840: , p_action_information8 => p_assignment_number);
4841: END IF;
4842: --
4843: IF l_addr.country IS NULL THEN
4844: pay_action_information_api.create_action_information
4845: (
4846: p_action_information_id => l_action_info_id
4847: , p_action_context_id => p_assactid
4848: , p_action_context_type => 'AAP'

Line 4873: pay_action_information_api.create_action_information

4869: IF hr_ni_chk_pkg.chk_nat_id_format(l_addr.postal_code,'DDDD AA') = upper(l_addr.postal_code) OR
4870: hr_ni_chk_pkg.chk_nat_id_format(l_addr.postal_code,'DDDDAA') = upper(l_addr.postal_code) THEN
4871: NULL;
4872: ELSE
4873: pay_action_information_api.create_action_information
4874: (
4875: p_action_information_id => l_action_info_id
4876: , p_action_context_id => p_assactid
4877: , p_action_context_type => 'AAP'

Line 4894: pay_action_information_api.create_action_information (

4890: END IF;
4891: --
4892: END IF;
4893: --#
4894: pay_action_information_api.create_action_information (
4895: p_action_information_id => l_action_info_id
4896: ,p_action_context_id => p_assactid
4897: ,p_action_context_type => 'AAP'
4898: ,p_object_version_number => l_ovn

Line 4918: pay_action_information_api.create_action_information (

4914: ,p_action_information26 => p_type
4915: ,p_action_information27 => p_m_act_info_id); -- add ADD_INFORMATION13 and ADD_INFORMATION14
4916: ELSE
4917: IF l_addr.country <> 'NL' THEN
4918: pay_action_information_api.create_action_information (
4919: p_action_information_id => l_action_info_id
4920: ,p_action_context_id => p_assactid
4921: ,p_action_context_type => 'AAP'
4922: ,p_object_version_number => l_ovn

Line 4946: pay_action_information_api.create_action_information

4942: END IF;
4943: CLOSE csr_get_emp_address;
4944: --#
4945: IF l_address_flag = 'N' AND p_type IN ('INITIAL','CORRECTION') THEN
4946: pay_action_information_api.create_action_information
4947: (
4948: p_action_information_id => l_action_info_id
4949: , p_action_context_id => p_assactid
4950: , p_action_context_type => 'AAP'

Line 5052: pay_action_information_api.create_action_information (

5048: l_rec.start_date >= NVL(l_end_date,l_rec.start_date)THEN
5049: l_end_date := l_rec.end_date;
5050: END IF;*/
5051: --
5052: pay_action_information_api.create_action_information (
5053: p_action_information_id => l_action_info_id
5054: , p_action_context_id => p_actid
5055: , p_action_context_type => 'AAP'
5056: , p_object_version_number => l_ovn

Line 5086: pay_action_information_api.create_action_information (

5082: END LOOP;
5083: /*OPEN csr_get_emp_risk_grp(p_assignment_id);
5084: FETCH csr_get_emp_risk_grp INTO l_sector_rec;
5085: IF csr_get_emp_risk_grp%found THEN
5086: pay_action_information_api.create_action_information (
5087: p_action_information_id => l_action_info_id
5088: , p_action_context_id => p_actid
5089: , p_action_context_type => 'AAP'
5090: , p_object_version_number => l_ovn

Line 5285: pay_action_information_api.create_action_information

5281: l_action_info_id pay_action_information.action_information_id%type;
5282: --
5283: BEGIN
5284: IF p_nom_bal_value(14).balance_value <> 0 AND p_nom_bal_value(16).balance_value <> 0 THEN
5285: pay_action_information_api.create_action_information
5286: (
5287: p_action_information_id => l_action_info_id
5288: , p_action_context_id => p_assactid
5289: , p_action_context_type => 'AAP'

Line 5305: pay_action_information_api.create_action_information

5301: , p_action_information8 => p_assignment_id);
5302: END IF;
5303: --
5304: IF p_nom_bal_value(14).balance_value <> 0 AND p_nom_bal_value(15).balance_value = 0 THEN
5305: pay_action_information_api.create_action_information
5306: (
5307: p_action_information_id => l_action_info_id
5308: , p_action_context_id => p_assactid
5309: , p_action_context_type => 'AAP'

Line 5325: pay_action_information_api.create_action_information

5321: , p_action_information8 => p_assignment_id);
5322: END IF;
5323: --
5324: IF p_nom_bal_value(14).balance_value = 0 AND p_nom_bal_value(15).balance_value <> 0 THEN
5325: pay_action_information_api.create_action_information
5326: (
5327: p_action_information_id => l_action_info_id
5328: , p_action_context_id => p_assactid
5329: , p_action_context_type => 'AAP'

Line 5375: pay_action_information_api.create_action_information (

5371: --p_nom_bal_value(30).balance_value := NULL; --ENh# 6968464
5372: p_nom_bal_value(31).balance_value := NULL;
5373: END IF;
5374: --
5375: pay_action_information_api.create_action_information (
5376: p_action_information_id => l_action_info_id
5377: , p_action_context_id => p_assactid
5378: , p_action_context_type => 'AAP'
5379: , p_object_version_number => l_ovn

Line 5412: pay_action_information_api.create_action_information (

5408: , p_action_information27 => fnd_number.number_to_canonical(p_nom_bal_value(23).balance_value) -- 'AMOUNT_SEE_DISCONT_DAYS'
5409: , p_action_information28 => fnd_number.number_to_canonical(p_nom_bal_value(24).balance_value) -- 'WWB-ALL_ALIMONY'
5410: , p_action_information29 => fnd_number.number_to_canonical(p_nom_bal_value(25).balance_value)); -- 'DIRECTLY_PAID_ALIMONY');
5411: --
5412: pay_action_information_api.create_action_information (
5413: p_action_information_id => l_action_info_id
5414: , p_action_context_id => p_assactid
5415: , p_action_context_type => 'AAP'
5416: , p_object_version_number => l_ovn

Line 6815: pay_action_information_api.create_action_information (

6811: END IF;
6812: --Fnd_file.put_line(FND_FILE.LOG,' l_type :'||l_type);
6813: --Fnd_file.put_line(FND_FILE.LOG,' g_effective_date :'||fnd_date.date_to_canonical(g_effective_date));
6814: --
6815: pay_action_information_api.create_action_information (
6816: p_action_information_id => l_master_action_info_id
6817: ,p_action_context_id => p_assactid
6818: ,p_action_context_type => 'AAP'
6819: ,p_object_version_number => l_ovn

Line 6866: pay_action_information_api.create_action_information (

6862: IF l_emp_rec.change_reason NOT IN ('NL1','NL2','NL3','NL4','NL5') THEN
6863: l_emp_rec.change_reason := NULL;
6864: END IF;
6865: --
6866: pay_action_information_api.create_action_information (
6867: p_action_information_id => l_master_action_info_id
6868: ,p_action_context_id => p_assactid
6869: ,p_action_context_type => 'AAP'
6870: ,p_object_version_number => l_ovn

Line 6970: pay_action_information_api.create_action_information (

6966: FETCH csr_get_element_det INTO l_company_car_use;
6967: CLOSE csr_get_element_det;
6968: --
6969: --Fnd_file.put_line(FND_FILE.LOG,' Creating NL_WR_INCOME_PERIOD Infor Record for Type : INITIAL');
6970: pay_action_information_api.create_action_information (
6971: p_action_information_id => l_action_info_id
6972: , p_action_context_id => p_assactid
6973: , p_action_context_type => 'AAP'
6974: , p_object_version_number => l_ovn

Line 7310: pay_action_information_api.create_action_information (

7306: END IF;
7307: --
7308: IF l_archive_emp_info <> 'N' THEN
7309: --Fnd_file.put_line(FND_FILE.LOG,' Creating NL_WR_EMPLOYMENT_INFO INfor Record for Type :'||l_type||' Date :'||l_period_start_date);
7310: pay_action_information_api.create_action_information (
7311: p_action_information_id => l_master_action_info_id
7312: ,p_action_context_id => p_assactid
7313: ,p_action_context_type => 'AAP'
7314: ,p_object_version_number => l_ovn

Line 7383: pay_action_information_api.create_action_information

7379: ,p_payroll_type);
7380: --#
7381: IF l_srg_flag = 'N' AND (l_wao_insured = 'Y' OR l_ww_insured = 'Y' OR l_zw_insured = 'Y') THEN
7382: --
7383: pay_action_information_api.create_action_information
7384: (
7385: p_action_information_id => l_action_info_id
7386: , p_action_context_id => p_assactid
7387: , p_action_context_type => 'AAP'

Line 7446: pay_action_information_api.create_action_information

7442: --IF l_rec_changes(i).column_name <> 'CHANGE_REASON' OR
7443: -- l_rec_changes(i).column_name IS NOT NULL THEN
7444: --#
7445: IF l_zvw_defaulted = 'Y' THEN
7446: pay_action_information_api.create_action_information
7447: (
7448: p_action_information_id => l_action_info_id
7449: , p_action_context_id => p_assactid
7450: , p_action_context_type => 'AAP'

Line 7466: pay_action_information_api.create_action_information

7462: , p_action_information8 => l_emp_rec.assignment_number);
7463: END IF;
7464: --
7465: IF l_income_code IN (11,12,13,14,15,18) AND l_labour_rel_code IS NULL THEN
7466: pay_action_information_api.create_action_information
7467: (
7468: p_action_information_id => l_action_info_id
7469: , p_action_context_id => p_assactid
7470: , p_action_context_type => 'AAP'

Line 7486: pay_action_information_api.create_action_information

7482: , p_action_information8 => l_emp_rec.assignment_number);
7483: END IF;
7484: --
7485: IF l_income_code IN (11,12,13,14,15,18) AND l_assignment_catg IS NULL THEN
7486: pay_action_information_api.create_action_information
7487: (
7488: p_action_information_id => l_action_info_id
7489: , p_action_context_id => p_assactid
7490: , p_action_context_type => 'AAP'

Line 7506: pay_action_information_api.create_action_information

7502: , p_action_information8 => l_emp_rec.assignment_number);
7503: END IF;
7504: --
7505: IF l_income_code IN (11,12,13,14,15,18) AND l_work_pattern IS NULL AND g_effective_date < TO_DATE('01012007','DDMMYYYY') THEN
7506: pay_action_information_api.create_action_information
7507: (
7508: p_action_information_id => l_action_info_id
7509: , p_action_context_id => p_assactid
7510: , p_action_context_type => 'AAP'

Line 7526: pay_action_information_api.create_action_information

7522: , p_action_information8 => l_emp_rec.assignment_number);
7523: END IF;
7524: --
7525: IF l_srg_flag = 'Z' AND l_FZ_Code IS NULL THEN
7526: pay_action_information_api.create_action_information
7527: (
7528: p_action_information_id => l_action_info_id
7529: , p_action_context_id => p_assactid
7530: , p_action_context_type => 'AAP'

Line 7546: pay_action_information_api.create_action_information

7542: , p_action_information8 => l_emp_rec.assignment_number);
7543: END IF;
7544: --
7545: IF l_company_car_use = 4 AND g_effective_date > to_date('01012007','ddmmyyyy') THEN
7546: pay_action_information_api.create_action_information
7547: (
7548: p_action_information_id => l_action_info_id
7549: , p_action_context_id => p_assactid
7550: , p_action_context_type => 'AAP'

Line 7566: pay_action_information_api.create_action_information (

7562: , p_action_information8 => l_emp_rec.assignment_number);
7563: END IF;
7564: --#
7565: --Fnd_file.put_line(FND_FILE.LOG,' Creating NL_WR_INCOME_PERIOD INfor Record for Type :'||l_type||GREATEST(l_rec_changes(i).effective_date,l_ass_start_date));
7566: pay_action_information_api.create_action_information (
7567: p_action_information_id => l_action_info_id
7568: , p_action_context_id => p_assactid
7569: , p_action_context_type => 'AAP'
7570: , p_object_version_number => l_ovn

Line 7619: pay_action_information_api.create_action_information (

7615: l_emp_end_date := l_ass_end_date;
7616: END IF;
7617: --
7618: IF l_initial_flag <> 'Y' THEN
7619: pay_action_information_api.create_action_information (
7620: p_action_information_id => l_master_action_info_id
7621: ,p_action_context_id => p_assactid
7622: ,p_action_context_type => 'AAP'
7623: ,p_object_version_number => l_ovn

Line 7676: pay_action_information_api.create_action_information

7672: ,p_payroll_type);
7673: --#
7674: IF l_srg_flag = 'N' AND (l_wao_insured = 'Y' OR l_ww_insured = 'Y' OR l_zw_insured = 'Y') THEN
7675: --
7676: pay_action_information_api.create_action_information
7677: (
7678: p_action_information_id => l_action_info_id
7679: , p_action_context_id => p_assactid
7680: , p_action_context_type => 'AAP'

Line 7698: pay_action_information_api.create_action_information

7694: END IF;
7695: --#
7696: --#
7697: IF l_zvw_defaulted = 'Y' THEN
7698: pay_action_information_api.create_action_information
7699: (
7700: p_action_information_id => l_action_info_id
7701: , p_action_context_id => p_assactid
7702: , p_action_context_type => 'AAP'

Line 7718: pay_action_information_api.create_action_information

7714: , p_action_information8 => l_emp_rec.assignment_number);
7715: END IF;
7716: --
7717: IF l_income_code IN (11,12,13,14,15,18) AND l_labour_rel_code IS NULL THEN
7718: pay_action_information_api.create_action_information
7719: (
7720: p_action_information_id => l_action_info_id
7721: , p_action_context_id => p_assactid
7722: , p_action_context_type => 'AAP'

Line 7738: pay_action_information_api.create_action_information

7734: , p_action_information8 => l_emp_rec.assignment_number);
7735: END IF;
7736: --
7737: IF l_income_code IN (11,12,13,14,15,18) AND l_assignment_catg IS NULL THEN
7738: pay_action_information_api.create_action_information
7739: (
7740: p_action_information_id => l_action_info_id
7741: , p_action_context_id => p_assactid
7742: , p_action_context_type => 'AAP'

Line 7758: pay_action_information_api.create_action_information

7754: , p_action_information8 => l_emp_rec.assignment_number);
7755: END IF;
7756: --
7757: IF l_income_code IN (11,12,13,14,15,18) AND l_work_pattern IS NULL AND g_effective_date < TO_DATE('01012007','DDMMYYYY') THEN
7758: pay_action_information_api.create_action_information
7759: (
7760: p_action_information_id => l_action_info_id
7761: , p_action_context_id => p_assactid
7762: , p_action_context_type => 'AAP'

Line 7778: pay_action_information_api.create_action_information

7774: , p_action_information8 => l_emp_rec.assignment_number);
7775: END IF;
7776: --
7777: IF l_srg_flag = 'Z' AND l_FZ_Code IS NULL THEN
7778: pay_action_information_api.create_action_information
7779: (
7780: p_action_information_id => l_action_info_id
7781: , p_action_context_id => p_assactid
7782: , p_action_context_type => 'AAP'

Line 7798: pay_action_information_api.create_action_information

7794: , p_action_information8 => l_emp_rec.assignment_number);
7795: END IF;
7796: --
7797: IF l_company_car_use = 4 AND g_effective_date > to_date('01012007','ddmmyyyy') THEN
7798: pay_action_information_api.create_action_information
7799: (
7800: p_action_information_id => l_action_info_id
7801: , p_action_context_id => p_assactid
7802: , p_action_context_type => 'AAP'

Line 7820: pay_action_information_api.create_action_information (

7816: --#
7817: IF l_initial_flag <> 'Y' THEN
7818: --archive Income period information
7819: --Fnd_file.put_line(FND_FILE.LOG,' Archiving NL_WR_INCOME_PERIOD Record for Type :'||l_type);
7820: pay_action_information_api.create_action_information (
7821: p_action_information_id => l_action_info_id
7822: , p_action_context_id => p_assactid
7823: , p_action_context_type => 'AAP'
7824: , p_object_version_number => l_ovn

Line 8027: pay_action_information_api.create_action_information (

8023: --
8024: l_empt_action_info_id := csr_action_info_rec.action_information_id;
8025: l_action_context_id := csr_action_info_rec.action_context_id;
8026: --
8027: pay_action_information_api.create_action_information (
8028: p_action_information_id => l_master_action_info_id
8029: ,p_action_context_id => p_assactid
8030: ,p_action_context_type => 'AAP'
8031: ,p_object_version_number => l_ovn

Line 8058: pay_action_information_api.create_action_information

8054: ,p_action_information17 => csr_action_info_rec.action_information17
8055: ,p_action_information18 => csr_action_info_rec.action_information18);
8056: --
8057: FOR csr_exception_info_rec IN csr_exception_info('NL_WR_EXCEPTION_REPORT',csr_action_info_rec.action_context_id) LOOP
8058: pay_action_information_api.create_action_information
8059: (
8060: p_action_information_id => l_action_info_id
8061: , p_action_context_id => p_assactid
8062: , p_action_context_type => 'AAP'

Line 8088: pay_action_information_api.create_action_information (

8084: FETCH csr_get_income_start_date INTO l_date;
8085: CLOSE csr_get_income_start_date;
8086: --Fnd_file.put_line(FND_FILE.LOG,'~~## IN NL_WR_INCOME_PERIOD');
8087: --Fnd_file.put_line(FND_FILE.LOG,'~~## l_empt_action_info_id '||l_empt_action_info_id);
8088: pay_action_information_api.create_action_information (
8089: p_action_information_id => l_action_info_id
8090: ,p_action_context_id => p_assactid
8091: ,p_action_context_type => 'AAP'
8092: ,p_object_version_number => l_ovn

Line 8135: pay_action_information_api.create_action_information (

8131: OPEN csr_get_sector_start_date(p_assactid,p_assignment_id,csr_srg_info_rec.action_information7,csr_srg_info_rec.action_information8);
8132: FETCH csr_get_sector_start_date INTO l_date;
8133: CLOSE csr_get_sector_start_date;
8134: --Fnd_file.put_line(FND_FILE.LOG,'~~## IN NL_WR_SWMF_SECTOR_RISK_GROUP');
8135: pay_action_information_api.create_action_information (
8136: p_action_information_id => l_action_info_id
8137: ,p_action_context_id => p_assactid
8138: ,p_action_context_type => 'AAP'
8139: ,p_object_version_number => l_ovn

Line 8160: pay_action_information_api.create_action_information (

8156: --
8157: FOR csr_address_info_rec IN csr_address_info('ADDRESS DETAILS','INITIAL',l_empt_action_info_id,l_action_context_id) LOOP
8158: --
8159: --Fnd_file.put_line(FND_FILE.LOG,'~~## IN ADD Det');
8160: pay_action_information_api.create_action_information (
8161: p_action_information_id => l_action_info_id
8162: ,p_action_context_id => p_assactid
8163: ,p_action_context_type => 'AAP'
8164: ,p_object_version_number => l_ovn

Line 8190: pay_action_information_api.create_action_information (

8186: --
8187: FOR csr_nominative_info_rec IN csr_nominative_info('NL_WR_NOMINATIVE_REPORT','INITIAL',p_assactid) LOOP
8188: --
8189: --Fnd_file.put_line(FND_FILE.LOG,'~~## IN NL_WR_NOMINATIVE_REPORT');
8190: pay_action_information_api.create_action_information (
8191: p_action_information_id => l_action_info_id
8192: ,p_action_context_id => p_assactid
8193: ,p_action_context_type => 'AAP'
8194: ,p_object_version_number => l_ovn

Line 8236: pay_action_information_api.create_action_information (

8232: --
8233: FOR csr_nominative_info_rec IN csr_nominative_info('NL_WR_NOMINATIVE_REPORT_ADD','INITIAL',p_assactid) LOOP
8234: --
8235: --Fnd_file.put_line(FND_FILE.LOG,'~~## IN NL_WR_NOMINATIVE_REPORT');
8236: pay_action_information_api.create_action_information (
8237: p_action_information_id => l_action_info_id
8238: ,p_action_context_id => p_assactid
8239: ,p_action_context_type => 'AAP'
8240: ,p_object_version_number => l_ovn

Line 8694: pay_action_information_api.create_action_information (

8690: FETCH csr_get_shared_types INTO l_bg,l_nationality;
8691: CLOSE csr_get_shared_types;
8692: --
8693: l_type := 'INITIAL';
8694: pay_action_information_api.create_action_information (
8695: p_action_information_id => l_master_action_info_id
8696: ,p_action_context_id => p_assactid
8697: ,p_action_context_type => 'AAP'
8698: ,p_object_version_number => l_ovn

Line 8815: pay_action_information_api.create_action_information (

8811: CLOSE csr_get_cao_code;
8812: --Fnd_file.put_line(FND_FILE.LOG,' Collective Agreement id not null get from collective agreement table. :'||l_cao_code);
8813: END IF;*/
8814:
8815: pay_action_information_api.create_action_information (
8816: p_action_information_id => l_action_info_id
8817: , p_action_context_id => p_assactid
8818: , p_action_context_type => 'AAP'
8819: , p_object_version_number => l_ovn