DBA Data[Home] [Help]

APPS.PAY_JP_ITAX_ARCHIVE_PKG dependencies on PAY_ACTION_INFORMATION

Line 292: procedure create_action_information(p_action_information_rec in out nocopy pay_action_information%rowtype)

288: -- +------------------------------------------------------------------------------------------------+
289: -- |< create_action_information >-------------------------------------------------------------------|
290: -- |Private procedure.------------------------------------------------------------------------------|
291: -- +------------------------------------------------------------------------------------------------+
292: procedure create_action_information(p_action_information_rec in out nocopy pay_action_information%rowtype)
293: is
294: l_id number;
295: l_ovn number;
296: begin

Line 297: pay_action_information_api.create_action_information(

293: is
294: l_id number;
295: l_ovn number;
296: begin
297: pay_action_information_api.create_action_information(
298: P_VALIDATE => false,
299: P_ACTION_CONTEXT_ID => p_action_information_rec.ACTION_CONTEXT_ID,
300: P_ACTION_CONTEXT_TYPE => p_action_information_rec.ACTION_CONTEXT_TYPE,
301: P_ACTION_INFORMATION_CATEGORY => p_action_information_rec.ACTION_INFORMATION_CATEGORY,

Line 373: l_person_rec pay_action_information%rowtype;

369: l_wtm_system_desc_kanji varchar2(32767);
370: l_wtm_system_desc_kana varchar2(32767);
371: l_varchar2_tbl hr_jp_standard_pkg.t_varchar2_tbl;
372: --
373: l_person_rec pay_action_information%rowtype;
374: l_arch_rec pay_action_information%rowtype;
375: l_tax_rec pay_action_information%rowtype;
376: l_other_rec pay_action_information%rowtype;
377: l_other2_rec pay_action_information%rowtype;

Line 374: l_arch_rec pay_action_information%rowtype;

370: l_wtm_system_desc_kana varchar2(32767);
371: l_varchar2_tbl hr_jp_standard_pkg.t_varchar2_tbl;
372: --
373: l_person_rec pay_action_information%rowtype;
374: l_arch_rec pay_action_information%rowtype;
375: l_tax_rec pay_action_information%rowtype;
376: l_other_rec pay_action_information%rowtype;
377: l_other2_rec pay_action_information%rowtype;
378: l_housing_rec pay_action_information%rowtype;

Line 375: l_tax_rec pay_action_information%rowtype;

371: l_varchar2_tbl hr_jp_standard_pkg.t_varchar2_tbl;
372: --
373: l_person_rec pay_action_information%rowtype;
374: l_arch_rec pay_action_information%rowtype;
375: l_tax_rec pay_action_information%rowtype;
376: l_other_rec pay_action_information%rowtype;
377: l_other2_rec pay_action_information%rowtype;
378: l_housing_rec pay_action_information%rowtype;
379: l_dep_rec pay_action_information%rowtype;

Line 376: l_other_rec pay_action_information%rowtype;

372: --
373: l_person_rec pay_action_information%rowtype;
374: l_arch_rec pay_action_information%rowtype;
375: l_tax_rec pay_action_information%rowtype;
376: l_other_rec pay_action_information%rowtype;
377: l_other2_rec pay_action_information%rowtype;
378: l_housing_rec pay_action_information%rowtype;
379: l_dep_rec pay_action_information%rowtype;
380: l_tax_rec1 pay_action_information%rowtype;

Line 377: l_other2_rec pay_action_information%rowtype;

373: l_person_rec pay_action_information%rowtype;
374: l_arch_rec pay_action_information%rowtype;
375: l_tax_rec pay_action_information%rowtype;
376: l_other_rec pay_action_information%rowtype;
377: l_other2_rec pay_action_information%rowtype;
378: l_housing_rec pay_action_information%rowtype;
379: l_dep_rec pay_action_information%rowtype;
380: l_tax_rec1 pay_action_information%rowtype;
381: --

Line 378: l_housing_rec pay_action_information%rowtype;

374: l_arch_rec pay_action_information%rowtype;
375: l_tax_rec pay_action_information%rowtype;
376: l_other_rec pay_action_information%rowtype;
377: l_other2_rec pay_action_information%rowtype;
378: l_housing_rec pay_action_information%rowtype;
379: l_dep_rec pay_action_information%rowtype;
380: l_tax_rec1 pay_action_information%rowtype;
381: --
382: cursor csr_wic(cp_assignment_id number)

Line 379: l_dep_rec pay_action_information%rowtype;

375: l_tax_rec pay_action_information%rowtype;
376: l_other_rec pay_action_information%rowtype;
377: l_other2_rec pay_action_information%rowtype;
378: l_housing_rec pay_action_information%rowtype;
379: l_dep_rec pay_action_information%rowtype;
380: l_tax_rec1 pay_action_information%rowtype;
381: --
382: cursor csr_wic(cp_assignment_id number)
383: is

Line 380: l_tax_rec1 pay_action_information%rowtype;

376: l_other_rec pay_action_information%rowtype;
377: l_other2_rec pay_action_information%rowtype;
378: l_housing_rec pay_action_information%rowtype;
379: l_dep_rec pay_action_information%rowtype;
380: l_tax_rec1 pay_action_information%rowtype;
381: --
382: cursor csr_wic(cp_assignment_id number)
383: is
384: select wic.assignment_action_id,

Line 649: from pay_action_information

645: -- If not, rollback the assignment action itself.
646: --
647: if l_count > 0 then
648: delete
649: from pay_action_information
650: where action_context_type = 'AAP'
651: and action_context_id = p_action_context_id
652: and effective_date = p_effective_date;
653: else

Line 1217: l_pact_rec pay_action_information%rowtype;

1213: PROCEDURE DEINITIALIZATION_CODE(p_payroll_action_id IN NUMBER)
1214: IS
1215: c_proc CONSTANT VARCHAR2(61) := c_package || 'DEINITIALIZATION_CODE';
1216: l_dummy varchar2(1);
1217: l_pact_rec pay_action_information%rowtype;
1218: --
1219: cursor csr_pa_exists is
1220: select 'Y'
1221: from dual

Line 1224: from pay_action_information

1220: select 'Y'
1221: from dual
1222: where exists(
1223: select null
1224: from pay_action_information
1225: where action_context_id = p_payroll_action_id
1226: and action_context_type = 'PA');
1227: --
1228: cursor csr_assacts is

Line 1235: from pay_action_information pai

1231: where paa.payroll_action_id = p_payroll_action_id
1232: and paa.action_status = 'C'
1233: and not exists(
1234: select null
1235: from pay_action_information pai
1236: where pai.action_context_id = paa.assignment_action_id
1237: and pai.action_context_type = 'AAP');
1238: BEGIN
1239: hr_utility.set_location('Entering: ' || c_proc, 10);

Line 1266: -- Delete completed assignment actions without PAY_ACTION_INFORMATION.

1262: --
1263: create_action_information(l_pact_rec);
1264: end if;
1265: --
1266: -- Delete completed assignment actions without PAY_ACTION_INFORMATION.
1267: --
1268: for l_rec in csr_assacts loop
1269: py_rollback_pkg.rollback_ass_action(l_rec.assignment_action_id);
1270: end loop;