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

Line 239: lv_action_category pay_action_information.action_information_category%TYPE;

235: lv_procedure_name VARCHAR2(50);
236: lv_error_message VARCHAR2(200);
237: ln_step NUMBER;
238:
239: lv_action_category pay_action_information.action_information_category%TYPE;
240: lv_last_name per_all_people_f.last_name%TYPE;
241: lv_first_name per_all_people_f.first_name%TYPE;
242: lv_middle_name per_all_people_f.middle_names%TYPE;
243: lv_prefix per_all_people_f.pre_name_adjunct%TYPE;

Line 312: /* api call to insert the data into pay_action_information table with

308: := lv_work_at_home;
309:
310: ln_step := 3;
311:
312: /* api call to insert the data into pay_action_information table with
313: information category as 'IP EMPLOYEE ADDITIONAL DETAILS' */
314:
315: hr_utility.set_location(gv_package || lv_procedure_name, 30);
316: IF pay_emp_action_arch.lrr_act_tab.count > 0 THEN

Line 411: lv_action_category pay_action_information.action_information_category%TYPE;

407: lv_procedure_name VARCHAR2(100);
408: lv_error_message VARCHAR2(200);
409:
410: ln_step NUMBER;
411: lv_action_category pay_action_information.action_information_category%TYPE;
412: lv_balance_name pay_balance_types.balance_name%TYPE;
413: BEGIN
414:
415: lv_procedure_name := '.populate_elements';

Line 782: lv_action_info_category pay_action_information.action_information_category%TYPE;

778: ln_payments_amount NUMBER;
779: ln_ytd_hours NUMBER;
780: ln_ytd_days NUMBER;
781: ln_ytd_amount NUMBER(17,2);
782: lv_action_info_category pay_action_information.action_information_category%TYPE;
783: ln_element_type_id NUMBER;
784: ln_processing_priority NUMBER;
785:
786: ln_index NUMBER ;

Line 1063: FROM pay_action_information

1059: action_information9 ytd_amount,
1060: action_information10 reporting_name,
1061: effective_date effective_date,
1062: action_information12 ytd_hours
1063: FROM pay_action_information
1064: WHERE action_information_category IN ('IP EARNINGS', 'IP DEDUCTIONS')
1065: AND action_context_id = cp_xfr_action_id;
1066:
1067:

Line 1131: lv_action_info_category pay_action_information.action_information_category%TYPE;

1127: ln_processing_priority NUMBER;
1128:
1129: ln_index NUMBER := 0;
1130: lv_is_element_archived VARCHAR2(1);
1131: lv_action_info_category pay_action_information.action_information_category%TYPE;
1132: lv_procedure_name VARCHAR2(100);
1133: lv_error_message VARCHAR2(200);
1134: ln_step NUMBER;
1135: ln_assignment_id NUMBER;

Line 1136: lv_act_info_category pay_action_information.action_information_category%TYPE;

1132: lv_procedure_name VARCHAR2(100);
1133: lv_error_message VARCHAR2(200);
1134: ln_step NUMBER;
1135: ln_assignment_id NUMBER;
1136: lv_act_info_category pay_action_information.action_information_category%TYPE;
1137: ln_last_per_xfr_action_id NUMBER;
1138: cn_last_xfr_action_id NUMBER;
1139: lv_balance_name pay_balance_types.balance_name%TYPE;
1140:

Line 1957: pay_action_information_api.create_action_information

1953: END IF;
1954: ln_step := 4;
1955: hr_utility.set_location(gv_package || lv_procedure_name, 40);
1956:
1957: pay_action_information_api.create_action_information
1958: (
1959: p_action_information_id => l_action_info_id
1960: ,p_action_context_id => p_xfr_action_id
1961: ,p_action_context_type => 'AAP'

Line 3329: -- insert rows in pay_action_information table

3325: END IF;
3326:
3327: hr_utility.set_location(gv_package || lv_procedure_name, 30);
3328:
3329: -- insert rows in pay_action_information table
3330: IF pay_emp_action_arch.ltr_ppa_arch.count > 0 THEN
3331: pay_emp_action_arch.insert_rows_thro_api_process(
3332: p_action_context_id => p_payroll_action_id
3333: ,p_action_context_type => 'PA'

Line 3423: pay_action_information_api.create_action_information

3419: l_end_date := fnd_date.date_to_canonical(csr_rec.end_date);
3420:
3421: l_ovn := 1;
3422:
3423: pay_action_information_api.create_action_information
3424: (
3425: p_action_information_id => l_action_info_id
3426: ,p_action_context_id => p_arch_act_id
3427: ,p_action_context_type => 'AAP'

Line 3497: FROM pay_action_information pai

3493: 'Tax Deductions',
3494: ACTION_INFORMATION1) ELEMENT_TYPE,
3495: sum(nvl(ACTION_INFORMATION8,0)) RUN,
3496: sum(nvl(ACTION_INFORMATION9,0)) YTD
3497: FROM pay_action_information pai
3498: WHERE pai.ACTION_CONTEXT_ID = p_arch_act_id
3499: AND pai.ACTION_INFORMATION_CATEGORY IN ('IP DEDUCTIONS','IP EARNINGS')
3500: GROUP BY
3501: pai.ACTION_INFORMATION_CATEGORY,

Line 3530: lv_gross_earnings_run pay_action_information.ACTION_INFORMATION1%TYPE;

3526: l_ovn NUMBER;
3527: l_action_info_id NUMBER;
3528: l_message VARCHAR2(255);
3529: --
3530: lv_gross_earnings_run pay_action_information.ACTION_INFORMATION1%TYPE;
3531: lv_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;
3532: lv_pre_tax_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;
3533: lv_tax_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;
3534: lv_net_pay_run pay_action_information.ACTION_INFORMATION1%TYPE;

Line 3531: lv_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;

3527: l_action_info_id NUMBER;
3528: l_message VARCHAR2(255);
3529: --
3530: lv_gross_earnings_run pay_action_information.ACTION_INFORMATION1%TYPE;
3531: lv_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;
3532: lv_pre_tax_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;
3533: lv_tax_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;
3534: lv_net_pay_run pay_action_information.ACTION_INFORMATION1%TYPE;
3535:

Line 3532: lv_pre_tax_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;

3528: l_message VARCHAR2(255);
3529: --
3530: lv_gross_earnings_run pay_action_information.ACTION_INFORMATION1%TYPE;
3531: lv_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;
3532: lv_pre_tax_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;
3533: lv_tax_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;
3534: lv_net_pay_run pay_action_information.ACTION_INFORMATION1%TYPE;
3535:
3536: lv_gross_earnings_ytd pay_action_information.ACTION_INFORMATION1%TYPE;

Line 3533: lv_tax_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;

3529: --
3530: lv_gross_earnings_run pay_action_information.ACTION_INFORMATION1%TYPE;
3531: lv_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;
3532: lv_pre_tax_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;
3533: lv_tax_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;
3534: lv_net_pay_run pay_action_information.ACTION_INFORMATION1%TYPE;
3535:
3536: lv_gross_earnings_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3537: lv_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;

Line 3534: lv_net_pay_run pay_action_information.ACTION_INFORMATION1%TYPE;

3530: lv_gross_earnings_run pay_action_information.ACTION_INFORMATION1%TYPE;
3531: lv_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;
3532: lv_pre_tax_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;
3533: lv_tax_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;
3534: lv_net_pay_run pay_action_information.ACTION_INFORMATION1%TYPE;
3535:
3536: lv_gross_earnings_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3537: lv_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3538: lv_pre_tax_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;

Line 3536: lv_gross_earnings_ytd pay_action_information.ACTION_INFORMATION1%TYPE;

3532: lv_pre_tax_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;
3533: lv_tax_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;
3534: lv_net_pay_run pay_action_information.ACTION_INFORMATION1%TYPE;
3535:
3536: lv_gross_earnings_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3537: lv_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3538: lv_pre_tax_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3539: lv_tax_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3540: lv_net_pay_ytd pay_action_information.ACTION_INFORMATION1%TYPE;

Line 3537: lv_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;

3533: lv_tax_deductions_run pay_action_information.ACTION_INFORMATION1%TYPE;
3534: lv_net_pay_run pay_action_information.ACTION_INFORMATION1%TYPE;
3535:
3536: lv_gross_earnings_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3537: lv_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3538: lv_pre_tax_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3539: lv_tax_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3540: lv_net_pay_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3541:

Line 3538: lv_pre_tax_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;

3534: lv_net_pay_run pay_action_information.ACTION_INFORMATION1%TYPE;
3535:
3536: lv_gross_earnings_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3537: lv_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3538: lv_pre_tax_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3539: lv_tax_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3540: lv_net_pay_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3541:
3542: lv_action_info_category pay_action_information.ACTION_INFORMATION_CATEGORY%TYPE;

Line 3539: lv_tax_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;

3535:
3536: lv_gross_earnings_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3537: lv_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3538: lv_pre_tax_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3539: lv_tax_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3540: lv_net_pay_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3541:
3542: lv_action_info_category pay_action_information.ACTION_INFORMATION_CATEGORY%TYPE;
3543: lv_element_type pay_action_information.ACTION_INFORMATION1%TYPE;

Line 3540: lv_net_pay_ytd pay_action_information.ACTION_INFORMATION1%TYPE;

3536: lv_gross_earnings_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3537: lv_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3538: lv_pre_tax_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3539: lv_tax_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3540: lv_net_pay_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3541:
3542: lv_action_info_category pay_action_information.ACTION_INFORMATION_CATEGORY%TYPE;
3543: lv_element_type pay_action_information.ACTION_INFORMATION1%TYPE;
3544: lv_run_amount pay_action_information.ACTION_INFORMATION1%TYPE;

Line 3542: lv_action_info_category pay_action_information.ACTION_INFORMATION_CATEGORY%TYPE;

3538: lv_pre_tax_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3539: lv_tax_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3540: lv_net_pay_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3541:
3542: lv_action_info_category pay_action_information.ACTION_INFORMATION_CATEGORY%TYPE;
3543: lv_element_type pay_action_information.ACTION_INFORMATION1%TYPE;
3544: lv_run_amount pay_action_information.ACTION_INFORMATION1%TYPE;
3545: lv_ytd_amount pay_action_information.ACTION_INFORMATION1%TYPE;
3546:

Line 3543: lv_element_type pay_action_information.ACTION_INFORMATION1%TYPE;

3539: lv_tax_deductions_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3540: lv_net_pay_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3541:
3542: lv_action_info_category pay_action_information.ACTION_INFORMATION_CATEGORY%TYPE;
3543: lv_element_type pay_action_information.ACTION_INFORMATION1%TYPE;
3544: lv_run_amount pay_action_information.ACTION_INFORMATION1%TYPE;
3545: lv_ytd_amount pay_action_information.ACTION_INFORMATION1%TYPE;
3546:
3547: --

Line 3544: lv_run_amount pay_action_information.ACTION_INFORMATION1%TYPE;

3540: lv_net_pay_ytd pay_action_information.ACTION_INFORMATION1%TYPE;
3541:
3542: lv_action_info_category pay_action_information.ACTION_INFORMATION_CATEGORY%TYPE;
3543: lv_element_type pay_action_information.ACTION_INFORMATION1%TYPE;
3544: lv_run_amount pay_action_information.ACTION_INFORMATION1%TYPE;
3545: lv_ytd_amount pay_action_information.ACTION_INFORMATION1%TYPE;
3546:
3547: --
3548: BEGIN

Line 3545: lv_ytd_amount pay_action_information.ACTION_INFORMATION1%TYPE;

3541:
3542: lv_action_info_category pay_action_information.ACTION_INFORMATION_CATEGORY%TYPE;
3543: lv_element_type pay_action_information.ACTION_INFORMATION1%TYPE;
3544: lv_run_amount pay_action_information.ACTION_INFORMATION1%TYPE;
3545: lv_ytd_amount pay_action_information.ACTION_INFORMATION1%TYPE;
3546:
3547: --
3548: BEGIN
3549: --

Line 3596: pay_action_information_api.create_action_information

3592: END IF;
3593:
3594: l_ovn := 1;
3595: hr_utility.set_location(l_procedure_name, 50);
3596: pay_action_information_api.create_action_information
3597: (
3598: p_action_information_id => l_action_info_id
3599: ,p_action_context_id => p_arch_act_id
3600: ,p_action_context_type => 'AAP'

Line 3615: pay_action_information_api.create_action_information

3611: );
3612: hr_utility.set_location(l_procedure_name, 60);
3613: IF gv_is_tax_unit_enabled = 'Y' THEN
3614: hr_utility.set_location(l_procedure_name, 70);
3615: pay_action_information_api.create_action_information
3616: (
3617: p_action_information_id => l_action_info_id
3618: ,p_action_context_id => p_arch_act_id
3619: ,p_action_context_type => 'AAP'

Line 4119: archived into a PL-SQL table. The API for the PAY_ACTION_INFORMATION

4115: process. This procedure traces back from the Archiver assignment
4116: action back to the individual run assignment actions. These run
4117: assignment action Ids will then be used to call a process_actions
4118: procedure. This procedure will actually load all the data to be
4119: archived into a PL-SQL table. The API for the PAY_ACTION_INFORMATION
4120: table will finally be called to insert the data from the PL-SQL
4121: table onto the actual table.
4122: *******************************************************************************/
4123: PROCEDURE archive_code(p_xfr_action_id IN NUMBER

Line 4176: FROM pay_action_information

4172: AND paa.assignment_action_id = cp_prepayment_action_id;
4173:
4174: CURSOR c_check_pay_action( cp_payroll_action_id IN NUMBER) IS
4175: SELECT count(*)
4176: FROM pay_action_information
4177: WHERE action_context_id = cp_payroll_action_id
4178: AND action_context_type = 'PA';
4179:
4180: CURSOR c_payment_info(cp_prepay_action_id NUMBER) IS