eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IE_EHECS_REPORT_PKG dependencies on PAY_ACTION_INFORMATION

Line 852: pay_action_information_api.create_action_information

848: END IF;
849:
850: hr_utility.set_location('Before entering record for IE_EHECS_HEADER ', 380);
851:
852: pay_action_information_api.create_action_information
853: ( p_action_information_id => l_action_info_id
854: ,p_action_context_id => pactid
855: ,p_action_context_type => 'PA'
856: ,p_object_version_number => l_ovn

Line 2122: FROM pay_action_information

2118: action_information23 declarant_phone,
2119: action_information24 declarant_email,
2120: action_information25 declare_date,
2121: action_information26 declarant_position
2122: FROM pay_action_information
2123: WHERE action_context_id = c_pact_id
2124: AND action_context_type = 'PA'
2125: AND action_information_category ='IE_EHECS_HEADER';
2126:

Line 2451: FROM pay_action_information

2447: NVL(action_information27,0) l_vac_ot,
2448: NVL(action_information28,0) l_min_paid_mg,
2449: NVL(action_information29,0) l_min_paid_cl,
2450: NVL(action_information30,0) l_min_paid_ot
2451: FROM pay_action_information
2452: WHERE action_context_id = c_pact_id
2453: AND action_context_type = 'PA'
2454: AND action_information_category ='IE_EHECS_PART1';
2455:

Line 2481: FROM pay_action_information

2477: ROUND(NVL(action_information18,0)) l_irr_bonus_pt_ot,
2478: ROUND(NVL(action_information19,0)) l_tot_wg_app_mg,
2479: ROUND(NVL(action_information20,0)) l_tot_wg_app_cl,
2480: ROUND(NVL(action_information21,0)) l_tot_wg_app_ot
2481: FROM pay_action_information
2482: WHERE action_context_id = c_pact_id
2483: AND action_context_type = 'PA'
2484: AND action_information_category ='IE_EHECS_PART2';
2485:

Line 2506: FROM pay_action_information

2502: ROUND(NVL(action_information15,0)) l_contracted_hrs_paid_app_ot,
2503: ROUND(NVL(action_information16,0)) l_ot_hrs_paid_app_mg,
2504: ROUND(NVL(action_information17,0)) l_ot_hrs_paid_app_cl,
2505: ROUND(NVL(action_information18,0)) l_ot_hrs_paid_app_ot
2506: FROM pay_action_information
2507: WHERE action_context_id = c_pact_id
2508: AND action_context_type = 'PA'
2509: AND action_information_category ='IE_EHECS_PART3';
2510:

Line 2540: FROM pay_action_information

2536: ROUND(NVL(action_information24,0)) l_other_leave_pt_ot,
2537: ROUND(NVL(action_information25,0)) l_all_paid_leave_app_mg,
2538: ROUND(NVL(action_information26,0)) l_all_paid_leave_app_cl,
2539: ROUND(NVL(action_information27,0)) l_all_paid_leave_app_ot
2540: FROM pay_action_information
2541: WHERE action_context_id = c_pact_id
2542: AND action_context_type = 'PA'
2543: AND action_information_category ='IE_EHECS_PART4';
2544:

Line 2562: FROM pay_action_information

2558: ROUND(NVL(action_information12,0)) l_other_paid_ot,
2559: ROUND(NVL(action_information13,0)) l_ssc_contributions_app_mg,
2560: ROUND(NVL(action_information14,0)) l_ssc_contributions_app_cl,
2561: ROUND(NVL(action_information15,0)) l_ssc_contributions_app_ot
2562: FROM pay_action_information
2563: WHERE action_context_id = c_pact_id
2564: AND action_context_type = 'PA'
2565: AND action_information_category ='IE_EHECS_PART7';
2566:

Line 2584: FROM pay_action_information

2580: ROUND(NVL(action_information12,0)) l_staff_housing_ot,
2581: ROUND(NVL(action_information13,0)) l_other_benefits_mg,
2582: ROUND(NVL(action_information14,0)) l_other_benefits_cl,
2583: ROUND(NVL(action_information15,0)) l_other_benefits_ot
2584: FROM pay_action_information
2585: WHERE action_context_id = c_pact_id
2586: AND action_context_type = 'PA'
2587: AND action_information_category ='IE_EHECS_PART8';
2588:

Line 2603: FROM pay_action_information

2599: ROUND(NVL(action_information9,0)) l_refunds,
2600: action_information10 l_comment_line1,
2601: action_information11 l_comment_line2,
2602: action_information12 l_comment_line3
2603: FROM pay_action_information
2604: WHERE action_context_id = c_pact_id
2605: AND action_context_type = 'PA'
2606: AND action_information_category ='IE_EHECS_ALL_OTHER';
2607:

Line 3376: pay_action_information_api.create_action_information

3372:
3373: hr_utility.set_location('l_payroll_action_id. '||TO_CHAR(l_payroll_action_id),3180);
3374: hr_utility.set_location('Before Inserting IE_EHECS_PART1 ',3190);
3375:
3376: pay_action_information_api.create_action_information
3377: ( p_action_information_id => l_action_info_id
3378: ,p_action_context_id => l_payroll_action_id
3379: ,p_action_context_type => 'PA'
3380: ,p_object_version_number => l_ovn

Line 3434: pay_action_information_api.create_action_information

3430: + NVL(l_tab_get_override_totals('P').l_sum_irrb_at,NVL(l_tab_get_totals('P').irrb_at_mg_cl_ot,0));
3431:
3432: hr_utility.set_location('Before Inserting IE_EHECS_PART2 ',3210);
3433:
3434: pay_action_information_api.create_action_information
3435: ( p_action_information_id => l_action_info_id
3436: ,p_action_context_id => l_payroll_action_id
3437: ,p_action_context_type => 'PA'
3438: ,p_object_version_number => l_ovn

Line 3468: pay_action_information_api.create_action_information

3464: );
3465:
3466: hr_utility.set_location('After Inserting IE_EHECS_PART2 ',3220);
3467:
3468: pay_action_information_api.create_action_information
3469: ( p_action_information_id => l_action_info_id
3470: ,p_action_context_id => l_payroll_action_id
3471: ,p_action_context_type => 'PA'
3472: ,p_object_version_number => l_ovn

Line 3531: pay_action_information_api.create_action_information

3527:
3528: hr_utility.set_location(' l_tab_get_totals:M.al_pt_mg_cl_ot ' || l_tab_get_totals('M').al_pt_mg_cl_ot,3230);
3529: hr_utility.set_location(' l_tab_get_totals:C.al_pt_mg_cl_ot ' || l_tab_get_totals('C').al_pt_mg_cl_ot,3230);
3530: hr_utility.set_location(' l_tab_get_totals:Pal_pt_mg_cl_ot ' || l_tab_get_totals('P').al_pt_mg_cl_ot,3230);
3531: pay_action_information_api.create_action_information
3532: ( p_action_information_id => l_action_info_id
3533: ,p_action_context_id => l_payroll_action_id
3534: ,p_action_context_type => 'PA'
3535: ,p_object_version_number => l_ovn

Line 3588: pay_action_information_api.create_action_information

3584: + NVL(l_tab_get_override_totals('P').l_sum_otsoc_at,NVL(l_tab_get_totals('P').otsoc_at_mg_cl_ot,0));
3585:
3586: hr_utility.set_location('Before Inserting IE_EHECS_PART7 ',3260);
3587:
3588: pay_action_information_api.create_action_information
3589: ( p_action_information_id => l_action_info_id
3590: ,p_action_context_id => l_payroll_action_id
3591: ,p_action_context_type => 'PA'
3592: ,p_object_version_number => l_ovn

Line 3616: pay_action_information_api.create_action_information

3612: );
3613:
3614: hr_utility.set_location('After Inserting IE_EHECS_PART7 ',3270);
3615:
3616: pay_action_information_api.create_action_information
3617: ( p_action_information_id => l_action_info_id
3618: ,p_action_context_id => l_payroll_action_id
3619: ,p_action_context_type => 'PA'
3620: ,p_object_version_number => l_ovn

Line 3644: pay_action_information_api.create_action_information

3640: );
3641:
3642: hr_utility.set_location('After Inserting IE_EHECS_PART8 ',3270);
3643:
3644: pay_action_information_api.create_action_information
3645: ( p_action_information_id => l_action_info_id
3646: ,p_action_context_id => l_payroll_action_id
3647: ,p_action_context_type => 'PA'
3648: ,p_object_version_number => l_ovn