DBA Data[Home] [Help]

APPS.PAY_DK_ARCHIVE_EHOL dependencies on PAY_ACTION_INFORMATION

Line 497: FROM pay_action_information

493:
494:
495: SELECT count(*)
496: INTO l_count
497: FROM pay_action_information
498: WHERE action_information_category = 'EMEA REPORT DETAILS'
499: AND action_information1 IN ('PYDKEHOLCA' , 'PYDKEHOLCA_ANN', 'PYDKEHOLCA_MIA')
500: AND action_context_id = p_payroll_action_id;
501:

Line 589: pay_action_information_api.create_action_information (

585: END IF;
586: */
587: --14078879
588:
589: pay_action_information_api.create_action_information (
590: p_action_information_id => l_action_info_id
591: ,p_action_context_id => p_payroll_action_id
592: ,p_action_context_type => 'PA'
593: ,p_object_version_number => l_ovn

Line 2202: pay_action_information_api.create_action_information (

2198: --14078879
2199:
2200: IF (l_use_holiday_card ='Y' AND l_uhc_payroll ='Y') AND l_usr_tbl_exist_400 = 'N' THEN
2201:
2202: pay_action_information_api.create_action_information (
2203: p_action_information_id => l_action_info_id
2204: ,p_action_context_id => p_assignment_action_id
2205: ,p_action_context_type => 'AAP'
2206: ,p_object_version_number => l_ovn

Line 2478: pay_action_information_api.create_action_information (

2474: IF l_hourly_salaried='H' THEN
2475:
2476: --IF l_tot_no_holidays_hr <> 0 OR l_holiday_pay_hr <> 0 THEN
2477: --YEAR1
2478: pay_action_information_api.create_action_information (
2479: p_action_information_id => l_action_info_id
2480: ,p_action_context_id => p_assignment_action_id
2481: ,p_action_context_type => 'AAP'
2482: ,p_object_version_number => l_ovn

Line 2533: pay_action_information_api.create_action_information (

2529: END IF;
2530:
2531: fnd_file.put_line(fnd_file.log,'2-l_hol_pay_percentage:'||l_hol_pay_percentage);
2532:
2533: pay_action_information_api.create_action_information (
2534: p_action_information_id => l_action_info_id
2535: ,p_action_context_id => p_assignment_action_id
2536: ,p_action_context_type => 'AAP'
2537: ,p_object_version_number => l_ovn

Line 2589: pay_action_information_api.create_action_information (

2585:
2586: IF l_hourly_salaried='S' /* AND l_holiday_pay_1 <> 0 */ THEN
2587: --fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15-1');
2588: --YEAR1
2589: pay_action_information_api.create_action_information (
2590: p_action_information_id => l_action_info_id
2591: ,p_action_context_id => p_assignment_action_id
2592: ,p_action_context_type => 'AAP'
2593: ,p_object_version_number => l_ovn

Line 2644: pay_action_information_api.create_action_information (

2640: END IF;
2641:
2642: fnd_file.put_line(fnd_file.log,'4-l_hol_pay_percentage:'||l_hol_pay_percentage);
2643:
2644: pay_action_information_api.create_action_information (
2645: p_action_information_id => l_action_info_id
2646: ,p_action_context_id => p_assignment_action_id
2647: ,p_action_context_type => 'AAP'
2648: ,p_object_version_number => l_ovn

Line 2691: pay_action_information_api.create_action_information (

2687:
2688: IF l_hourly_salaried='S' /* AND l_holiday_pay_2 <> 0 */ THEN
2689: --fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15-3');
2690: --YEAR2
2691: pay_action_information_api.create_action_information (
2692: p_action_information_id => l_action_info_id
2693: ,p_action_context_id => p_assignment_action_id
2694: ,p_action_context_type => 'AAP'
2695: ,p_object_version_number => l_ovn

Line 2754: pay_action_information_api.create_action_information (

2750: , to_date('31-12-'||l_nxt_entit_yr,'dd-mm-rrrr')
2751: );
2752: fnd_file.put_line(fnd_file.log,'l_Holidayable_amount_2:'||l_Holidayable_amount_2);
2753:
2754: pay_action_information_api.create_action_information (
2755: p_action_information_id => l_action_info_id
2756: ,p_action_context_id => p_assignment_action_id
2757: ,p_action_context_type => 'AAP'
2758: ,p_object_version_number => l_ovn

Line 2801: pay_action_information_api.create_action_information (

2797:
2798: IF l_hourly_salaried='S' /* AND l_holiday_pay_3 <> 0 */ THEN
2799: --fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15-2');
2800: --YEAR3
2801: pay_action_information_api.create_action_information (
2802: p_action_information_id => l_action_info_id
2803: ,p_action_context_id => p_assignment_action_id
2804: ,p_action_context_type => 'AAP'
2805: ,p_object_version_number => l_ovn

Line 2864: pay_action_information_api.create_action_information (

2860: , to_date('31-12-'||l_curr_entit_yr,'dd-mm-rrrr')
2861: );
2862: fnd_file.put_line(fnd_file.log,'l_Holidayable_amount_3:'||l_Holidayable_amount_3);
2863:
2864: pay_action_information_api.create_action_information (
2865: p_action_information_id => l_action_info_id
2866: ,p_action_context_id => p_assignment_action_id
2867: ,p_action_context_type => 'AAP'
2868: ,p_object_version_number => l_ovn

Line 2965: pay_action_information_api.create_action_information (

2961: l_hrly_hol_days_hr := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Days','_ASG_HOLIDAY_YTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
2962: fnd_file.put_line(fnd_file.log,'l_hrly_hol_days_hr:'||l_hrly_hol_days_hr);
2963: */
2964: --
2965: pay_action_information_api.create_action_information (
2966: p_action_information_id => l_action_info_id
2967: ,p_action_context_id => p_assignment_action_id
2968: ,p_action_context_type => 'AAP'
2969: ,p_object_version_number => l_ovn

Line 3021: pay_action_information_api.create_action_information (

3017: END IF;
3018:
3019: fnd_file.put_line(fnd_file.log,'Y-l_hol_pay_percentage:'||l_hol_pay_percentage);
3020:
3021: pay_action_information_api.create_action_information (
3022: p_action_information_id => l_action_info_id
3023: ,p_action_context_id => p_assignment_action_id
3024: ,p_action_context_type => 'AAP'
3025: ,p_object_version_number => l_ovn

Line 3096: pay_action_information_api.create_action_information (

3092: l_hol_acc_amt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Holiday Accrual Amount','_ASG_PTD'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3093: fnd_file.put_line(fnd_file.log,'l_hol_acc_amt:'||l_hol_acc_amt);
3094:
3095: --Accrual Reporting (Indberetningstype: Optjening)
3096: pay_action_information_api.create_action_information (
3097: p_action_information_id => l_action_info_id
3098: ,p_action_context_id => p_assignment_action_id
3099: ,p_action_context_type => 'AAP'
3100: ,p_object_version_number => l_ovn

Line 3173: pay_action_information_api.create_action_information (

3169: l_accr_yr := to_char(l_start_date,'RRRR') - 1;
3170: END IF;
3171:
3172: --Holidays Paid Reporting (Indberetningstype: Nedskrivning)
3173: pay_action_information_api.create_action_information (
3174: p_action_information_id => l_action_info_id
3175: ,p_action_context_id => p_assignment_action_id
3176: ,p_action_context_type => 'AAP'
3177: ,p_object_version_number => l_ovn

Line 3271: PAY_ACTION_INFORMATION

3267:
3268: CURSOR cur_emea_report_info(p_payroll_action_id IN NUMBER, p_report_type VARCHAR2) IS
3269: SELECT *
3270: FROM
3271: PAY_ACTION_INFORMATION
3272: WHERE
3273: ACTION_CONTEXT_ID = p_payroll_action_id
3274: AND ACTION_CONTEXT_TYPE = 'PA'
3275: AND ACTION_INFORMATION_CATEGORY = 'EMEA REPORT INFORMATION'

Line 3284: PAY_ACTION_INFORMATION PAI

3280: CURSOR cur_all_payrolls(p_payroll_action_id IN NUMBER, p_report_type VARCHAR2) IS
3281: SELECT distinct PAI.ACTION_INFORMATION30 Payroll_id
3282: FROM
3283: PAY_ASSIGNMENT_ACTIONS PAA,
3284: PAY_ACTION_INFORMATION PAI
3285: WHERE
3286: PAA.PAYROLL_ACTION_ID = p_payroll_action_id
3287: AND PAI.ACTION_CONTEXT_ID = PAA.ASSIGNMENT_ACTION_ID
3288: AND PAI.ACTION_CONTEXT_TYPE = 'AAP'

Line 3293: CURSOR cur_emp_dtls(p_payroll_action_id NUMBER, p_payroll_id PAY_ACTION_INFORMATION.ACTION_INFORMATION30%TYPE

3289: AND PAI.ACTION_INFORMATION_CATEGORY = 'EMEA REPORT INFORMATION'
3290: AND PAI.ACTION_INFORMATION1 = p_report_type --'PYDKEHOLCA'
3291: AND PAI.ACTION_INFORMATION3 = 'DK EMPLOYEE DETAILS';
3292:
3293: CURSOR cur_emp_dtls(p_payroll_action_id NUMBER, p_payroll_id PAY_ACTION_INFORMATION.ACTION_INFORMATION30%TYPE
3294: ,p_report_type VARCHAR2)
3295: IS
3296: SELECT PAI.*
3297: FROM

Line 3299: PAY_ACTION_INFORMATION PAI

3295: IS
3296: SELECT PAI.*
3297: FROM
3298: PAY_ASSIGNMENT_ACTIONS PAA,
3299: PAY_ACTION_INFORMATION PAI
3300: WHERE
3301: PAA.PAYROLL_ACTION_ID = p_payroll_action_id
3302: AND PAI.ACTION_CONTEXT_ID = PAA.ASSIGNMENT_ACTION_ID
3303: AND PAI.ACTION_CONTEXT_TYPE = 'AAP'

Line 3311: p_payroll_id PAY_ACTION_INFORMATION.ACTION_INFORMATION30%TYPE,

3307: AND PAI.ACTION_INFORMATION30 = p_payroll_id
3308: ORDER BY PAI.ACTION_INFORMATION4, PAI.ACTION_INFORMATION5;
3309:
3310: CURSOR cur_dk_hcard_info(p_payroll_action_id NUMBER,
3311: p_payroll_id PAY_ACTION_INFORMATION.ACTION_INFORMATION30%TYPE,
3312: p_person_id PAY_ACTION_INFORMATION.ACTION_INFORMATION4%TYPE,
3313: p_asg_id PAY_ACTION_INFORMATION.ACTION_INFORMATION5%TYPE,
3314: p_hcard_info VARCHAR2,
3315: p_report_type VARCHAR2) IS

Line 3312: p_person_id PAY_ACTION_INFORMATION.ACTION_INFORMATION4%TYPE,

3308: ORDER BY PAI.ACTION_INFORMATION4, PAI.ACTION_INFORMATION5;
3309:
3310: CURSOR cur_dk_hcard_info(p_payroll_action_id NUMBER,
3311: p_payroll_id PAY_ACTION_INFORMATION.ACTION_INFORMATION30%TYPE,
3312: p_person_id PAY_ACTION_INFORMATION.ACTION_INFORMATION4%TYPE,
3313: p_asg_id PAY_ACTION_INFORMATION.ACTION_INFORMATION5%TYPE,
3314: p_hcard_info VARCHAR2,
3315: p_report_type VARCHAR2) IS
3316: SELECT PAI.*

Line 3313: p_asg_id PAY_ACTION_INFORMATION.ACTION_INFORMATION5%TYPE,

3309:
3310: CURSOR cur_dk_hcard_info(p_payroll_action_id NUMBER,
3311: p_payroll_id PAY_ACTION_INFORMATION.ACTION_INFORMATION30%TYPE,
3312: p_person_id PAY_ACTION_INFORMATION.ACTION_INFORMATION4%TYPE,
3313: p_asg_id PAY_ACTION_INFORMATION.ACTION_INFORMATION5%TYPE,
3314: p_hcard_info VARCHAR2,
3315: p_report_type VARCHAR2) IS
3316: SELECT PAI.*
3317: FROM

Line 3319: PAY_ACTION_INFORMATION PAI

3315: p_report_type VARCHAR2) IS
3316: SELECT PAI.*
3317: FROM
3318: PAY_ASSIGNMENT_ACTIONS PAA,
3319: PAY_ACTION_INFORMATION PAI
3320: WHERE
3321: PAA.PAYROLL_ACTION_ID = p_payroll_action_id
3322: AND PAI.ACTION_CONTEXT_ID = PAA.ASSIGNMENT_ACTION_ID
3323: AND PAI.ACTION_CONTEXT_TYPE = 'AAP'

Line 3333: p_payroll_id PAY_ACTION_INFORMATION.ACTION_INFORMATION30%TYPE,

3329: AND PAI.ACTION_INFORMATION5 = p_asg_id
3330: ORDER BY ACTION_INFORMATION6 DESC;
3331:
3332: CURSOR cur_dk_hcard_info_add(p_payroll_action_id NUMBER,
3333: p_payroll_id PAY_ACTION_INFORMATION.ACTION_INFORMATION30%TYPE,
3334: p_person_id PAY_ACTION_INFORMATION.ACTION_INFORMATION4%TYPE,
3335: p_asg_id PAY_ACTION_INFORMATION.ACTION_INFORMATION5%TYPE,
3336: p_hcard_info VARCHAR2,
3337: p_year PAY_ACTION_INFORMATION.ACTION_INFORMATION6%TYPE,

Line 3334: p_person_id PAY_ACTION_INFORMATION.ACTION_INFORMATION4%TYPE,

3330: ORDER BY ACTION_INFORMATION6 DESC;
3331:
3332: CURSOR cur_dk_hcard_info_add(p_payroll_action_id NUMBER,
3333: p_payroll_id PAY_ACTION_INFORMATION.ACTION_INFORMATION30%TYPE,
3334: p_person_id PAY_ACTION_INFORMATION.ACTION_INFORMATION4%TYPE,
3335: p_asg_id PAY_ACTION_INFORMATION.ACTION_INFORMATION5%TYPE,
3336: p_hcard_info VARCHAR2,
3337: p_year PAY_ACTION_INFORMATION.ACTION_INFORMATION6%TYPE,
3338: p_report_type VARCHAR2) IS

Line 3335: p_asg_id PAY_ACTION_INFORMATION.ACTION_INFORMATION5%TYPE,

3331:
3332: CURSOR cur_dk_hcard_info_add(p_payroll_action_id NUMBER,
3333: p_payroll_id PAY_ACTION_INFORMATION.ACTION_INFORMATION30%TYPE,
3334: p_person_id PAY_ACTION_INFORMATION.ACTION_INFORMATION4%TYPE,
3335: p_asg_id PAY_ACTION_INFORMATION.ACTION_INFORMATION5%TYPE,
3336: p_hcard_info VARCHAR2,
3337: p_year PAY_ACTION_INFORMATION.ACTION_INFORMATION6%TYPE,
3338: p_report_type VARCHAR2) IS
3339: SELECT PAI.*

Line 3337: p_year PAY_ACTION_INFORMATION.ACTION_INFORMATION6%TYPE,

3333: p_payroll_id PAY_ACTION_INFORMATION.ACTION_INFORMATION30%TYPE,
3334: p_person_id PAY_ACTION_INFORMATION.ACTION_INFORMATION4%TYPE,
3335: p_asg_id PAY_ACTION_INFORMATION.ACTION_INFORMATION5%TYPE,
3336: p_hcard_info VARCHAR2,
3337: p_year PAY_ACTION_INFORMATION.ACTION_INFORMATION6%TYPE,
3338: p_report_type VARCHAR2) IS
3339: SELECT PAI.*
3340: FROM
3341: PAY_ASSIGNMENT_ACTIONS PAA,

Line 3342: PAY_ACTION_INFORMATION PAI

3338: p_report_type VARCHAR2) IS
3339: SELECT PAI.*
3340: FROM
3341: PAY_ASSIGNMENT_ACTIONS PAA,
3342: PAY_ACTION_INFORMATION PAI
3343: WHERE
3344: PAA.PAYROLL_ACTION_ID = p_payroll_action_id
3345: AND PAI.ACTION_CONTEXT_ID = PAA.ASSIGNMENT_ACTION_ID
3346: AND PAI.ACTION_CONTEXT_TYPE = 'AAP'

Line 3364: PAY_ACTION_INFORMATION

3360: ACTION_INFORMATION27 period_from, --14078879
3361: ACTION_INFORMATION28 period_to, --14078879
3362: ACTION_INFORMATION30 payroll_id
3363: FROM
3364: PAY_ACTION_INFORMATION
3365: WHERE
3366: ACTION_INFORMATION1 = 'PYDKEHOLCA_MIA'
3367: AND ACTION_INFORMATION2 = p_payroll_action_id
3368: AND ACTION_INFORMATION3 = 'DK EMPLOYEE DETAILS'

Line 3374: CURSOR cur_emp_dtls_mia(p_payroll_action_id NUMBER, p_payroll_id PAY_ACTION_INFORMATION.ACTION_INFORMATION30%TYPE

3370: AND ACTION_INFORMATION4 IS NOT NULL --14078879
3371: AND ACTION_INFORMATION5 IS NOT NULL --14078879
3372: GROUP BY ACTION_INFORMATION30, ACTION_INFORMATION29, ACTION_INFORMATION28, ACTION_INFORMATION27;
3373:
3374: CURSOR cur_emp_dtls_mia(p_payroll_action_id NUMBER, p_payroll_id PAY_ACTION_INFORMATION.ACTION_INFORMATION30%TYPE
3375: ,p_period_id PAY_ACTION_INFORMATION.ACTION_INFORMATION29%TYPE)
3376: IS
3377: SELECT PAI.*
3378: FROM

Line 3375: ,p_period_id PAY_ACTION_INFORMATION.ACTION_INFORMATION29%TYPE)

3371: AND ACTION_INFORMATION5 IS NOT NULL --14078879
3372: GROUP BY ACTION_INFORMATION30, ACTION_INFORMATION29, ACTION_INFORMATION28, ACTION_INFORMATION27;
3373:
3374: CURSOR cur_emp_dtls_mia(p_payroll_action_id NUMBER, p_payroll_id PAY_ACTION_INFORMATION.ACTION_INFORMATION30%TYPE
3375: ,p_period_id PAY_ACTION_INFORMATION.ACTION_INFORMATION29%TYPE)
3376: IS
3377: SELECT PAI.*
3378: FROM
3379: PAY_ASSIGNMENT_ACTIONS PAA,

Line 3380: PAY_ACTION_INFORMATION PAI

3376: IS
3377: SELECT PAI.*
3378: FROM
3379: PAY_ASSIGNMENT_ACTIONS PAA,
3380: PAY_ACTION_INFORMATION PAI
3381: WHERE
3382: PAA.PAYROLL_ACTION_ID = p_payroll_action_id
3383: AND PAI.ACTION_CONTEXT_ID = PAA.ASSIGNMENT_ACTION_ID
3384: AND PAI.ACTION_CONTEXT_TYPE = 'AAP'

Line 3395: p_payroll_id PAY_ACTION_INFORMATION.ACTION_INFORMATION30%TYPE,

3391: AND PAI.ACTION_INFORMATION5 IS NOT NULL --14078879
3392: ORDER BY PAI.ACTION_INFORMATION4, PAI.ACTION_INFORMATION5;
3393:
3394: CURSOR cur_dk_hcard_accr_pmnt(p_payroll_action_id NUMBER,
3395: p_payroll_id PAY_ACTION_INFORMATION.ACTION_INFORMATION30%TYPE,
3396: p_person_id PAY_ACTION_INFORMATION.ACTION_INFORMATION4%TYPE,
3397: p_asg_id PAY_ACTION_INFORMATION.ACTION_INFORMATION5%TYPE,
3398: p_period_id PAY_ACTION_INFORMATION.ACTION_INFORMATION28%TYPE,
3399: p_hcard_info PAY_ACTION_INFORMATION.ACTION_INFORMATION3%TYPE) IS

Line 3396: p_person_id PAY_ACTION_INFORMATION.ACTION_INFORMATION4%TYPE,

3392: ORDER BY PAI.ACTION_INFORMATION4, PAI.ACTION_INFORMATION5;
3393:
3394: CURSOR cur_dk_hcard_accr_pmnt(p_payroll_action_id NUMBER,
3395: p_payroll_id PAY_ACTION_INFORMATION.ACTION_INFORMATION30%TYPE,
3396: p_person_id PAY_ACTION_INFORMATION.ACTION_INFORMATION4%TYPE,
3397: p_asg_id PAY_ACTION_INFORMATION.ACTION_INFORMATION5%TYPE,
3398: p_period_id PAY_ACTION_INFORMATION.ACTION_INFORMATION28%TYPE,
3399: p_hcard_info PAY_ACTION_INFORMATION.ACTION_INFORMATION3%TYPE) IS
3400: SELECT PAI.*

Line 3397: p_asg_id PAY_ACTION_INFORMATION.ACTION_INFORMATION5%TYPE,

3393:
3394: CURSOR cur_dk_hcard_accr_pmnt(p_payroll_action_id NUMBER,
3395: p_payroll_id PAY_ACTION_INFORMATION.ACTION_INFORMATION30%TYPE,
3396: p_person_id PAY_ACTION_INFORMATION.ACTION_INFORMATION4%TYPE,
3397: p_asg_id PAY_ACTION_INFORMATION.ACTION_INFORMATION5%TYPE,
3398: p_period_id PAY_ACTION_INFORMATION.ACTION_INFORMATION28%TYPE,
3399: p_hcard_info PAY_ACTION_INFORMATION.ACTION_INFORMATION3%TYPE) IS
3400: SELECT PAI.*
3401: FROM

Line 3398: p_period_id PAY_ACTION_INFORMATION.ACTION_INFORMATION28%TYPE,

3394: CURSOR cur_dk_hcard_accr_pmnt(p_payroll_action_id NUMBER,
3395: p_payroll_id PAY_ACTION_INFORMATION.ACTION_INFORMATION30%TYPE,
3396: p_person_id PAY_ACTION_INFORMATION.ACTION_INFORMATION4%TYPE,
3397: p_asg_id PAY_ACTION_INFORMATION.ACTION_INFORMATION5%TYPE,
3398: p_period_id PAY_ACTION_INFORMATION.ACTION_INFORMATION28%TYPE,
3399: p_hcard_info PAY_ACTION_INFORMATION.ACTION_INFORMATION3%TYPE) IS
3400: SELECT PAI.*
3401: FROM
3402: PAY_ASSIGNMENT_ACTIONS PAA,

Line 3399: p_hcard_info PAY_ACTION_INFORMATION.ACTION_INFORMATION3%TYPE) IS

3395: p_payroll_id PAY_ACTION_INFORMATION.ACTION_INFORMATION30%TYPE,
3396: p_person_id PAY_ACTION_INFORMATION.ACTION_INFORMATION4%TYPE,
3397: p_asg_id PAY_ACTION_INFORMATION.ACTION_INFORMATION5%TYPE,
3398: p_period_id PAY_ACTION_INFORMATION.ACTION_INFORMATION28%TYPE,
3399: p_hcard_info PAY_ACTION_INFORMATION.ACTION_INFORMATION3%TYPE) IS
3400: SELECT PAI.*
3401: FROM
3402: PAY_ASSIGNMENT_ACTIONS PAA,
3403: PAY_ACTION_INFORMATION PAI

Line 3403: PAY_ACTION_INFORMATION PAI

3399: p_hcard_info PAY_ACTION_INFORMATION.ACTION_INFORMATION3%TYPE) IS
3400: SELECT PAI.*
3401: FROM
3402: PAY_ASSIGNMENT_ACTIONS PAA,
3403: PAY_ACTION_INFORMATION PAI
3404: WHERE
3405: PAA.PAYROLL_ACTION_ID = p_payroll_action_id
3406: AND PAI.ACTION_CONTEXT_ID = PAA.ASSIGNMENT_ACTION_ID
3407: AND PAI.ACTION_CONTEXT_TYPE = 'AAP'