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

Line 1095: ,pay_action_information pai

1091: SELECT 'Y'
1092: FROM DUAL
1093: WHERE EXISTS (SELECT /*+ ORDERED */ 1
1094: FROM pay_assignment_actions paa
1095: ,pay_action_information pai
1096: WHERE paa.payroll_action_id = c_pay_act_id
1097: AND pai.action_context_id = paa.assignment_action_id
1098: AND pai.action_context_type = 'AAP'
1099: AND pai.action_information_category = 'NL_WR_NOMINATIVE_REPORT_ADD'

Line 2591: l_ovn pay_action_information.object_version_number%type;

2587: ,p_payroll_type IN VARCHAR2
2588: ,p_seq_no IN VARCHAR2)
2589: IS
2590: -- DECLARE LOCAL VARIABLES
2591: l_ovn pay_action_information.object_version_number%type;
2592: l_action_info_id pay_action_information.action_information_id%type;
2593: l_business_group_id hr_all_organization_units.business_group_id%type;
2594: l_start_date DATE;
2595: l_end_date DATE;

Line 2592: l_action_info_id pay_action_information.action_information_id%type;

2588: ,p_seq_no IN VARCHAR2)
2589: IS
2590: -- DECLARE LOCAL VARIABLES
2591: l_ovn pay_action_information.object_version_number%type;
2592: l_action_info_id pay_action_information.action_information_id%type;
2593: l_business_group_id hr_all_organization_units.business_group_id%type;
2594: l_start_date DATE;
2595: l_end_date DATE;
2596: l_seq_no VARCHAR2(50);

Line 2684: DELETE pay_action_information

2680: BEGIN
2681: --hr_utility.trace_on(null,'NL_WR');
2682: --Fnd_file.put_line(FND_FILE.LOG,' Entering deinit code ');
2683: /*Delete all data archived for the current payroll_action_id - to handle assignment level retry*/
2684: DELETE pay_action_information
2685: WHERE action_context_id = p_actid
2686: AND action_context_type = 'PA';
2687: --
2688: empr_flag := 'N';

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 2752: l_ovn pay_action_information.object_version_number%type;

2748: --------------------------------------------------------------------------------
2749: PROCEDURE archive_deinit_code(p_actid IN NUMBER)
2750: IS
2751: -- DECLARE LOCAL VARIABLES
2752: l_ovn pay_action_information.object_version_number%type;
2753: l_action_info_id pay_action_information.action_information_id%type;
2754: l_business_group_id hr_all_organization_units.business_group_id%type;
2755: l_start_date DATE;
2756: l_end_date DATE;

Line 2753: l_action_info_id pay_action_information.action_information_id%type;

2749: PROCEDURE archive_deinit_code(p_actid IN NUMBER)
2750: IS
2751: -- DECLARE LOCAL VARIABLES
2752: l_ovn pay_action_information.object_version_number%type;
2753: l_action_info_id pay_action_information.action_information_id%type;
2754: l_business_group_id hr_all_organization_units.business_group_id%type;
2755: l_start_date DATE;
2756: l_end_date DATE;
2757: l_seq_no VARCHAR2(50);

Line 2792: ,pay_action_information pai

2788: CURSOR csr_period_dates(c_pact_id NUMBER) IS
2789: SELECT DISTINCT pai.Action_Information2 Start_date
2790: ,pai.action_information3 End_date
2791: FROM pay_assignment_actions paa
2792: ,pay_action_information pai
2793: WHERE paa.payroll_action_id = c_pact_id
2794: AND paa.assignment_action_id = pai.action_context_id
2795: AND pai.action_information_category = 'NL_WR_EMPLOYMENT_INFO'
2796: AND pai.action_information1 IN ('INITIAL','CORRECTION','CORRECT')

Line 2836: ,pay_action_information pai

2832: CURSOR csr_ret_cor_period(c_pact_id NUMBER) IS
2833: SELECT DISTINCT fnd_date.canonical_to_date(pai.Action_Information2) Start_date
2834: ,fnd_date.canonical_to_date(pai.action_information3) End_date
2835: FROM pay_assignment_actions paa
2836: ,pay_action_information pai
2837: WHERE paa.payroll_action_id = c_pact_id
2838: AND paa.assignment_action_id = pai.action_context_id
2839: AND pai.action_information_category = 'NL_WR_EMPLOYMENT_INFO'
2840: AND pai.action_information1 IN ('INITIAL','CORRECTION','CORRECT')

Line 2892: FROM pay_action_information pai_p

2888: ,pai_p.action_information6 Description
2889: ,substr(pai_p.action_information7,1,30) E_Name
2890: ,substr(pai_p.action_information8,1,30) E_Number
2891: ,pai_p.action_context_type cxt
2892: FROM pay_action_information pai_p
2893: WHERE pai_p.action_context_id = p_payroll_action_id
2894: AND pai_p.action_information_category = 'NL_WR_EXCEPTION_REPORT'
2895: AND pai_p.action_context_type = 'PA'
2896: ORDER BY pai_p.action_information8 asc;

Line 2906: ,pay_action_information pai_p

2902: ,substr(pai_p.action_information7,1,30) E_Name
2903: ,substr(pai_p.action_information8,1,30) E_Number
2904: ,pai_p.action_context_type cxt
2905: FROM pay_assignment_actions paa
2906: ,pay_action_information pai_p
2907: WHERE paa.payroll_action_id = p_payroll_action_id
2908: AND pai_p.action_context_id = paa.assignment_action_id
2909: AND pai_p.action_information_category = 'NL_WR_EXCEPTION_REPORT'
2910: AND pai_p.action_context_type = 'AAP'

Line 2935: FROM pay_action_information pai

2931: --
2932: CURSOR csr_employer_info(c_category VARCHAR2
2933: ,c_pactid NUMBER) IS
2934: SELECT pai.*
2935: FROM pay_action_information pai
2936: WHERE pai.action_context_type = 'PA'
2937: AND pai.action_context_id = c_pactid
2938: AND pai.action_information_category = c_category;
2939: --

Line 2947: FROM pay_action_information pai

2943: SELECT action_information7
2944: ,action_information8
2945: ,sum(fnd_number.canonical_to_number(action_information9)) action_information9
2946: ,sum(fnd_number.canonical_to_number(action_information10))action_information10
2947: FROM pay_action_information pai
2948: ,pay_payroll_actions ppa
2949: WHERE ppa.report_type = 'NL_WAGES_REP_ARCHIVE'
2950: AND ppa.report_qualifier = 'NL'
2951: AND ppa.action_type = 'X'

Line 3042: DELETE pay_action_information

3038: BEGIN
3039: --hr_utility.trace_on(null,'NL_WR');
3040: --Fnd_file.put_line(FND_FILE.LOG,' Entering deinit code ');
3041: /*Delete all data archived for the current payroll_action_id - to handle assignment level retry*/
3042: DELETE pay_action_information
3043: WHERE action_context_id = p_actid
3044: AND action_context_type = 'PA';
3045: --
3046: empr_flag := 'N';

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 4763: l_ovn pay_action_information.object_version_number%type;

4759: nvl(addr.date_to,fnd_date.canonical_to_date('4712/12/31'))
4760: ORDER BY 1 DESC;
4761: --
4762: l_addr csr_get_emp_address%ROWTYPE;
4763: l_ovn pay_action_information.object_version_number%type;
4764: l_action_info_id pay_action_information.action_information_id%type;
4765: l_address_flag VARCHAR2(1) := 'N';
4766: l_address_type VARCHAR2(30);
4767: --

Line 4764: l_action_info_id pay_action_information.action_information_id%type;

4760: ORDER BY 1 DESC;
4761: --
4762: l_addr csr_get_emp_address%ROWTYPE;
4763: l_ovn pay_action_information.object_version_number%type;
4764: l_action_info_id pay_action_information.action_information_id%type;
4765: l_address_flag VARCHAR2(1) := 'N';
4766: l_address_type VARCHAR2(30);
4767: --
4768: BEGIN

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 5011: l_action_info_id pay_action_information.action_information_id%TYPE;

5007: AND org_information6 IS NOT NULL
5008: AND org_information_context= 'NL_UWV';*/
5009: --AND rownum < 6;
5010: --
5011: l_action_info_id pay_action_information.action_information_id%TYPE;
5012: l_ovn pay_action_information.object_version_number%type;
5013: l_srg_flag VARCHAR2(1);
5014: l_srg_flag_52 VARCHAR2(1);
5015: l_start_date DATE;

Line 5012: l_ovn pay_action_information.object_version_number%type;

5008: AND org_information_context= 'NL_UWV';*/
5009: --AND rownum < 6;
5010: --
5011: l_action_info_id pay_action_information.action_information_id%TYPE;
5012: l_ovn pay_action_information.object_version_number%type;
5013: l_srg_flag VARCHAR2(1);
5014: l_srg_flag_52 VARCHAR2(1);
5015: l_start_date DATE;
5016: l_end_date DATE;

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 5280: l_ovn pay_action_information.object_version_number%type;

5276: ,p_corr_used VARCHAR2
5277: ,p_payroll_type VARCHAR2
5278: ,p_nom_bal_value IN OUT NOCOPY Bal_Value) IS
5279: --
5280: l_ovn pay_action_information.object_version_number%type;
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

Line 5281: l_action_info_id pay_action_information.action_information_id%type;

5277: ,p_payroll_type VARCHAR2
5278: ,p_nom_bal_value IN OUT NOCOPY Bal_Value) IS
5279: --
5280: l_ovn pay_action_information.object_version_number%type;
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

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 6285: l_master_action_info_id pay_action_information.action_information_id%type;

6281: l_assignment_catg_old per_shared_types.INFORMATION1%type;
6282: l_emp_rec csr_get_emp_data%rowtype;
6283: l_rec_changes Rec_Changes;
6284: l_rec_changes_init Rec_Changes;
6285: l_master_action_info_id pay_action_information.action_information_id%type;
6286: l_action_info_id pay_action_information.action_information_id%TYPE;
6287: l_period_start_date DATE;
6288: l_period_end_date DATE;
6289: l_rec_start_date DATE;

Line 6286: l_action_info_id pay_action_information.action_information_id%TYPE;

6282: l_emp_rec csr_get_emp_data%rowtype;
6283: l_rec_changes Rec_Changes;
6284: l_rec_changes_init Rec_Changes;
6285: l_master_action_info_id pay_action_information.action_information_id%type;
6286: l_action_info_id pay_action_information.action_information_id%TYPE;
6287: l_period_start_date DATE;
6288: l_period_end_date DATE;
6289: l_rec_start_date DATE;
6290: l_emp_end_date DATE;

Line 6323: l_ovn pay_action_information.object_version_number%type;

6319: l_archive_emp_info VARCHAR2(1);
6320: p_date DATE;
6321: l_retro VARCHAR2(10);
6322: l_type VARCHAR2(10);
6323: l_ovn pay_action_information.object_version_number%type;
6324: l_cao_code per_collective_agreements.CAG_INFORMATION1%type;
6325: l_old_cao_code per_collective_agreements.CAG_INFORMATION1%type;
6326: l_bal_value Bal_Value;
6327: l_nom_bal_value Bal_Value;

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 7908: ,pay_action_information pai

7904: ,c_type VARCHAR2
7905: ,c_assignment_id NUMBER) IS
7906: SELECT pai.*
7907: FROM pay_action_interlocks pal
7908: ,pay_action_information pai
7909: WHERE pal.locking_action_id = p_assactid
7910: AND pal.locked_action_id = pai.action_context_id
7911: AND pai.action_context_type = 'AAP'
7912: AND pai.action_information_category = c_category

Line 7921: ,pay_action_information pai

7917: CURSOR csr_get_income_start_date(c_assactid NUMBER
7918: ,c_assignment_id NUMBER) IS
7919: SELECT MIN(fnd_date.canonical_to_date(action_information5))
7920: FROM pay_action_interlocks pal
7921: ,pay_action_information pai
7922: WHERE pal.locking_action_id = c_assactid
7923: AND pal.locked_action_id = pai.action_context_id
7924: AND pai.action_context_type = 'AAP'
7925: AND pai.action_information_category = 'NL_WR_INCOME_PERIOD'

Line 7935: ,pay_action_information pai

7931: ,c_sector VARCHAR2
7932: ,c_risk_grp VARCHAR2) IS
7933: SELECT MIN(fnd_date.canonical_to_date(action_information5))
7934: FROM pay_action_interlocks pal
7935: ,pay_action_information pai
7936: WHERE pal.locking_action_id = c_assactid
7937: AND pal.locked_action_id = pai.action_context_id
7938: AND pai.action_context_type = 'AAP'
7939: AND pai.action_information_category = 'NL_WR_SWMF_SECTOR_RISK_GROUP'

Line 7948: FROM pay_action_information pai

7944: --
7945: CURSOR csr_exception_info(c_category VARCHAR2
7946: ,c_assactid NUMBER) IS
7947: SELECT pai.*
7948: FROM pay_action_information pai
7949: WHERE pai.action_context_id = c_assactid
7950: AND pai.action_context_type = 'AAP'
7951: AND pai.action_information_category = c_category;
7952: --

Line 7957: FROM pay_action_information pai

7953: CURSOR csr_ip_srg_info(c_category VARCHAR2
7954: ,c_type VARCHAR2
7955: ,c_actinfid NUMBER) IS
7956: SELECT pai.*
7957: FROM pay_action_information pai
7958: WHERE pai.action_context_type = 'AAP'
7959: AND pai.action_information2 = fnd_number.number_to_canonical(c_actinfid)
7960: AND pai.action_information_category = c_category
7961: AND pai.action_information1 = c_type ;

Line 7968: FROM pay_action_information pai

7964: ,c_type VARCHAR2
7965: ,c_actinfid NUMBER
7966: ,c_action_context_id NUMBER) IS
7967: SELECT pai.*
7968: FROM pay_action_information pai
7969: WHERE pai.action_context_type = 'AAP'
7970: AND pai.action_information27 = fnd_number.number_to_canonical(c_actinfid)
7971: AND pai.action_context_id = c_action_context_id
7972: AND pai.action_information_category = c_category

Line 8004: ,pay_action_information pai

8000: ,sum(fnd_number.canonical_to_number(pai.action_information27)) sum27
8001: ,sum(fnd_number.canonical_to_number(pai.action_information28)) sum28
8002: ,sum(fnd_number.canonical_to_number(pai.action_information29)) sum29
8003: from pay_action_interlocks pal
8004: ,pay_action_information pai
8005: where pal.locking_action_id = c_assactid
8006: AND pal.locked_action_id = pai.action_context_id
8007: AND pai.action_context_type = 'AAP'
8008: AND pai.action_information_category = c_category

Line 8011: l_ovn pay_action_information.object_version_number%TYPE;

8007: AND pai.action_context_type = 'AAP'
8008: AND pai.action_information_category = c_category
8009: AND pai.action_information1 = c_type ;
8010: --
8011: l_ovn pay_action_information.object_version_number%TYPE;
8012: l_action_info_id pay_action_information.action_information_id%TYPE;
8013: l_master_action_info_id pay_action_information.action_information_id%TYPE;
8014: l_empt_action_info_id pay_action_information.action_information_id%TYPE;
8015: l_action_context_id pay_action_information.action_context_id%TYPE;

Line 8012: l_action_info_id pay_action_information.action_information_id%TYPE;

8008: AND pai.action_information_category = c_category
8009: AND pai.action_information1 = c_type ;
8010: --
8011: l_ovn pay_action_information.object_version_number%TYPE;
8012: l_action_info_id pay_action_information.action_information_id%TYPE;
8013: l_master_action_info_id pay_action_information.action_information_id%TYPE;
8014: l_empt_action_info_id pay_action_information.action_information_id%TYPE;
8015: l_action_context_id pay_action_information.action_context_id%TYPE;
8016: l_date DATE;

Line 8013: l_master_action_info_id pay_action_information.action_information_id%TYPE;

8009: AND pai.action_information1 = c_type ;
8010: --
8011: l_ovn pay_action_information.object_version_number%TYPE;
8012: l_action_info_id pay_action_information.action_information_id%TYPE;
8013: l_master_action_info_id pay_action_information.action_information_id%TYPE;
8014: l_empt_action_info_id pay_action_information.action_information_id%TYPE;
8015: l_action_context_id pay_action_information.action_context_id%TYPE;
8016: l_date DATE;
8017: --

Line 8014: l_empt_action_info_id pay_action_information.action_information_id%TYPE;

8010: --
8011: l_ovn pay_action_information.object_version_number%TYPE;
8012: l_action_info_id pay_action_information.action_information_id%TYPE;
8013: l_master_action_info_id pay_action_information.action_information_id%TYPE;
8014: l_empt_action_info_id pay_action_information.action_information_id%TYPE;
8015: l_action_context_id pay_action_information.action_context_id%TYPE;
8016: l_date DATE;
8017: --
8018: BEGIN

Line 8015: l_action_context_id pay_action_information.action_context_id%TYPE;

8011: l_ovn pay_action_information.object_version_number%TYPE;
8012: l_action_info_id pay_action_information.action_information_id%TYPE;
8013: l_master_action_info_id pay_action_information.action_information_id%TYPE;
8014: l_empt_action_info_id pay_action_information.action_information_id%TYPE;
8015: l_action_context_id pay_action_information.action_context_id%TYPE;
8016: l_date DATE;
8017: --
8018: BEGIN
8019: --

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 8572: l_master_action_info_id pay_action_information.action_information_id%type;

8568: l_assignment_catg_old per_shared_types.INFORMATION1%type;
8569: l_emp_rec csr_get_emp_data%rowtype;
8570: l_rec_changes Rec_Changes;
8571: l_rec_changes_init Rec_Changes;
8572: l_master_action_info_id pay_action_information.action_information_id%type;
8573: l_action_info_id pay_action_information.action_information_id%TYPE;
8574: l_period_start_date DATE;
8575: l_period_end_date DATE;
8576: l_rec_start_date DATE;

Line 8573: l_action_info_id pay_action_information.action_information_id%TYPE;

8569: l_emp_rec csr_get_emp_data%rowtype;
8570: l_rec_changes Rec_Changes;
8571: l_rec_changes_init Rec_Changes;
8572: l_master_action_info_id pay_action_information.action_information_id%type;
8573: l_action_info_id pay_action_information.action_information_id%TYPE;
8574: l_period_start_date DATE;
8575: l_period_end_date DATE;
8576: l_rec_start_date DATE;
8577: l_emp_end_date DATE;

Line 8603: l_ovn pay_action_information.object_version_number%type;

8599: l_chk VARCHAR2(2);
8600: p_date DATE;
8601: l_retro VARCHAR2(10);
8602: l_type VARCHAR2(10);
8603: l_ovn pay_action_information.object_version_number%type;
8604: l_cao_code per_collective_agreements.CAG_INFORMATION1%type;
8605: l_old_cao_code per_collective_agreements.CAG_INFORMATION1%type;
8606: l_bal_value Bal_Value;
8607: l_nom_bal_value Bal_Value;

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

Line 8965: FROM pay_action_information pai

8961: IS
8962: --
8963: CURSOR csr_get_org_name (c_payroll_action_id NUMBER) IS
8964: SELECT action_information9
8965: FROM pay_action_information pai
8966: WHERE action_context_id = c_payroll_action_id
8967: AND action_context_type = 'PA'
8968: AND action_information_category = 'NL_WR_EMPLOYER_INFO';
8969: --

Line 8974: FROM pay_action_information pai

8970: CURSOR csr_chk_exception (c_payroll_action_id NUMBER) IS
8971: SELECT 'EXCEPTION'
8972: FROM DUAL
8973: WHERE EXISTS (SELECT 1
8974: FROM pay_action_information pai
8975: WHERE action_context_id = c_payroll_action_id
8976: AND action_information_category = 'NL_WR_EXCEPTION_REPORT')
8977: OR EXISTS (SELECT 1
8978: FROM pay_assignment_actions paa

Line 8979: ,pay_action_information pai

8975: WHERE action_context_id = c_payroll_action_id
8976: AND action_information_category = 'NL_WR_EXCEPTION_REPORT')
8977: OR EXISTS (SELECT 1
8978: FROM pay_assignment_actions paa
8979: ,pay_action_information pai
8980: WHERE paa.payroll_action_id = c_payroll_action_id
8981: AND pai.action_context_id = paa.assignment_action_id
8982: AND pai.action_information_category = 'NL_WR_EXCEPTION_REPORT');
8983: --

Line 8991: l_tax_rep_name PAY_ACTION_INFORMATION.ACTION_INFORMATION7%TYPE;

8987: l_tax_unit_id NUMBER;
8988: l_payroll_type VARCHAR2(10);
8989: l_seq_no VARCHAR2(15);
8990: l_return_string VARCHAR2(1000);
8991: l_tax_rep_name PAY_ACTION_INFORMATION.ACTION_INFORMATION7%TYPE;
8992: l_exception VARCHAR2(20);
8993: --
8994: BEGIN
8995: --