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 341: c_action_information_category constant pay_action_information.action_information_category%type := 'EMPLOYEE NET PAY DISTRIBUTION';

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

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

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

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

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

Line 658: FROM pay_action_information pai

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

Line 671: pay_action_information_api.delete_action_information(

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

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

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

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

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

Line 1001: -- Upload global variable lrr_act_tab into PAY_ACTION_INFORMATION

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

Line 1022: from pay_action_information

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