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

Line 49: g_payslip_label pay_action_information.action_information1%type;

45: --
46: g_payroll_id NUMBER;
47: g_consolidation_set_id number;
48: g_payment_date DATE;
49: g_payslip_label pay_action_information.action_information1%type;
50: -- +--------------------------------------------------------------------------+
51: -- |-----------------------------< init_globals >-----------------------------|
52: -- +--------------------------------------------------------------------------+
53: --

Line 124: c_action_information_category constant pay_action_information.action_information_category%type := 'EMPLOYEE PAYMENT INFORMATION';

120: --
121: PROCEDURE setup_payment_information(p_arch_assignment_action_id IN NUMBER)
122: IS
123: c_proc CONSTANT VARCHAR2(61) := c_package || 'setup_payment_information';
124: c_action_information_category constant pay_action_information.action_information_category%type := 'EMPLOYEE PAYMENT INFORMATION';
125: l_pay_date_disp pay_action_information.action_information1%type;
126: l_payslip_name pay_action_information.action_information1%type;
127: l_act_info_rec pay_emp_action_arch.act_info_rec;
128: --

Line 125: l_pay_date_disp pay_action_information.action_information1%type;

121: PROCEDURE setup_payment_information(p_arch_assignment_action_id IN NUMBER)
122: IS
123: c_proc CONSTANT VARCHAR2(61) := c_package || 'setup_payment_information';
124: c_action_information_category constant pay_action_information.action_information_category%type := 'EMPLOYEE PAYMENT INFORMATION';
125: l_pay_date_disp pay_action_information.action_information1%type;
126: l_payslip_name pay_action_information.action_information1%type;
127: l_act_info_rec pay_emp_action_arch.act_info_rec;
128: --
129: CURSOR csr_element_set_name(cp_arch_assignment_action_id NUMBER) IS

Line 126: l_payslip_name pay_action_information.action_information1%type;

122: IS
123: c_proc CONSTANT VARCHAR2(61) := c_package || 'setup_payment_information';
124: c_action_information_category constant pay_action_information.action_information_category%type := 'EMPLOYEE PAYMENT INFORMATION';
125: l_pay_date_disp pay_action_information.action_information1%type;
126: l_payslip_name pay_action_information.action_information1%type;
127: l_act_info_rec pay_emp_action_arch.act_info_rec;
128: --
129: CURSOR csr_element_set_name(cp_arch_assignment_action_id NUMBER) IS
130: SELECT pes.element_set_name

Line 196: c_action_information_category constant pay_action_information.action_information_category%type := 'JP ELEMENT INFORMATION';

192: --
193: PROCEDURE setup_element_information(p_arch_assignment_action_id IN NUMBER)
194: IS
195: c_proc CONSTANT VARCHAR2(61) := c_package || 'setup_element_information';
196: c_action_information_category constant pay_action_information.action_information_category%type := 'JP ELEMENT INFORMATION';
197: -- l_exists VARCHAR2(1);
198: -- l_payment_type hr_lookups.lookup_code%type;
199: l_act_info_rec pay_emp_action_arch.act_info_rec;
200: --

Line 342: c_action_information_category constant pay_action_information.action_information_category%type := 'EMPLOYEE NET PAY DISTRIBUTION';

338: -- +--------------------------------------------------------------------------+
339: PROCEDURE setup_net_pay_distribution(p_arch_assignment_action_id IN NUMBER)
340: IS
341: c_proc CONSTANT VARCHAR2(61) := c_package || 'setup_net_pay_distribution';
342: c_action_information_category constant pay_action_information.action_information_category%type := 'EMPLOYEE NET PAY DISTRIBUTION';
343: l_act_info_rec pay_emp_action_arch.act_info_rec;
344: --
345: cursor csr_assact(cp_arch_assignment_action_id number) is
346: select /*+ ORDERED */

Line 464: c_action_information_category constant pay_action_information.action_information_category%type := 'JP YTD AMOUNT';

460: p_run_effective_date IN DATE,
461: p_run_assignment_id IN NUMBER)
462: IS
463: c_proc CONSTANT VARCHAR2(61) := c_package || 'setup_ytd_amount';
464: c_action_information_category constant pay_action_information.action_information_category%type := 'JP YTD AMOUNT';
465: l_allowance_ytd NUMBER;
466: l_taxable_ytd NUMBER;
467: l_si_prem_ytd NUMBER;
468: l_itax_ytd NUMBER;

Line 519: c_action_information_category constant pay_action_information.action_information_category%type := 'JP ELEMENT INFORMATION';

515: IS
516: c_proc CONSTANT VARCHAR2(61) := c_package || 'setup_eit_element';
517: c_org_information_type constant hr_org_information_types.org_information_type%type := 'Organization:Payslip Info';
518: c_bg_information_type constant hr_org_information_types.org_information_type%type := 'Business Group:Payslip Info';
519: c_action_information_category constant pay_action_information.action_information_category%type := 'JP ELEMENT INFORMATION';
520: c_payment_type constant hr_lookups.lookup_code%type := 'F';
521: l_exists VARCHAR2(1);
522: l_organization_id number;
523: l_org_information_context hr_organization_information.org_information_context%type;

Line 659: FROM pay_action_information pai

655: --
656: CURSOR csr_emp_other_info_bal(cp_arch_assignment_action_id NUMBER) IS
657: SELECT pai.action_information_id,
658: pai.object_version_number
659: FROM pay_action_information pai
660: WHERE pai.action_context_id = cp_arch_assignment_action_id
661: AND pai.action_context_type = 'AAP'
662: AND pai.action_information_category = 'EMPLOYEE OTHER INFORMATION'
663: AND pai.action_information2 = 'BALANCE';

Line 672: pay_action_information_api.delete_action_information(

668: -- because balances archived are based on prepay assact, not run assact,
669: -- which means only balances with "_PAYMENTS" dimensions are archived.
670: --
671: FOR l_emp_other_info_bal_rec IN csr_emp_other_info_bal(p_arch_assignment_action_id) LOOP
672: pay_action_information_api.delete_action_information(
673: p_action_information_id => l_emp_other_info_bal_rec.action_information_id,
674: p_object_version_number => l_emp_other_info_bal_rec.object_version_number);
675: END LOOP;
676: --

Line 962: p_assactid => p_assignment_action_id, -- pay_action_information.action_context_id

958: -- This is not supported by US procedure now.
959: --
960: pay_emp_action_arch.get_personal_information(
961: p_payroll_action_id => g_arch_payroll_action_id, -- archive pact (not used)
962: p_assactid => p_assignment_action_id, -- pay_action_information.action_context_id
963: p_assignment_id => l_arch_assignment_id, -- Used to archive assignment info
964: p_curr_pymt_ass_act_id => null, -- N/A (used for net pay)
965: p_curr_eff_date => l_run_effective_date, -- Used to archive assignment info
966: p_date_earned => l_run_effective_date, -- Used to employee info (only required for US previously)

Line 967: p_curr_pymt_eff_date => l_run_effective_date, -- pay_action_information.effective_date

963: p_assignment_id => l_arch_assignment_id, -- Used to archive assignment info
964: p_curr_pymt_ass_act_id => null, -- N/A (used for net pay)
965: p_curr_eff_date => l_run_effective_date, -- Used to archive assignment info
966: p_date_earned => l_run_effective_date, -- Used to employee info (only required for US previously)
967: p_curr_pymt_eff_date => l_run_effective_date, -- pay_action_information.effective_date
968: p_tax_unit_id => null, -- N/A (Not used by JP)
969: p_time_period_id => l_time_period_id, -- run Time Period Id
970: p_ppp_source_action_id => null, -- netpay distribution (for Separate Payment)
971: p_ytd_balcall_aaid => l_run_assignment_action_id); -- Used to archive balance. PAYMENTS dimension is not supported in JP.

Line 1002: -- Upload global variable lrr_act_tab into PAY_ACTION_INFORMATION

998: setup_eit_element(
999: p_arch_assignment_action_id => p_assignment_action_id,
1000: p_organization_id => l_organization_id);
1001: --
1002: -- Upload global variable lrr_act_tab into PAY_ACTION_INFORMATION
1003: --
1004: pay_emp_action_arch.insert_rows_thro_api_process(
1005: p_action_context_id => p_assignment_action_id,
1006: p_action_context_type => 'AAP',

Line 1023: from pay_action_information

1019: select 'Y'
1020: from dual
1021: where exists(
1022: select null
1023: from pay_action_information
1024: where action_context_id = p_payroll_action_id
1025: and action_context_type = 'PA');
1026: BEGIN
1027: --