APPS.PAY_SG_CPFLINE dependencies on PAY_PAYROLL_ACTIONS

Line 12: report_type pay_payroll_actions.report_type%TYPE,

8: ----------------------------------------------------------------------
9: -- Record with payroll action details populated in Initialization_code
10: ----------------------------------------------------------------------
11: type t_pact IS RECORD(
12: report_type pay_payroll_actions.report_type%TYPE,
13: report_qualifier pay_payroll_actions.report_qualifier%TYPE,
14: report_category pay_payroll_actions.report_category%TYPE,
15: business_group_id number,
16: effective_date date,

Line 13: report_qualifier pay_payroll_actions.report_qualifier%TYPE,

9: -- Record with payroll action details populated in Initialization_code
10: ----------------------------------------------------------------------
11: type t_pact IS RECORD(
12: report_type pay_payroll_actions.report_type%TYPE,
13: report_qualifier pay_payroll_actions.report_qualifier%TYPE,
14: report_category pay_payroll_actions.report_category%TYPE,
15: business_group_id number,
16: effective_date date,
17: month_date varchar2(11),

Line 14: report_category pay_payroll_actions.report_category%TYPE,

10: ----------------------------------------------------------------------
11: type t_pact IS RECORD(
12: report_type pay_payroll_actions.report_type%TYPE,
13: report_qualifier pay_payroll_actions.report_qualifier%TYPE,
14: report_category pay_payroll_actions.report_category%TYPE,
15: business_group_id number,
16: effective_date date,
17: month_date varchar2(11),
18: legal_entity_id number ,

Line 60: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

56: -- the archive process knows what code to execute for each step of
57: -- the archive.
58: --------------------------------------------------------------------
59: procedure range_code
60: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
61: p_sql out nocopy varchar2)
62: is
63: c_range_cursor constant varchar2(3000) :=
64: ' select distinct pap.person_id

Line 65: from pay_payroll_actions ppa,

61: p_sql out nocopy varchar2)
62: is
63: c_range_cursor constant varchar2(3000) :=
64: ' select distinct pap.person_id
65: from pay_payroll_actions ppa,
66: per_people_f pap
67: where ppa.payroll_action_id = :payroll_action_id
68: and pap.business_group_id = ppa.business_group_id
69: order by pap.person_id ' ;

Line 77: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

73: ------------------------------------------------------------
74: -- Assignment Action Code
75: ------------------------------------------------------------
76: procedure assignment_action_code
77: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
78: p_start_person_id in per_all_people_f.person_id%type,
79: p_end_person_id in per_all_people_f.person_id%type,
80: p_chunk in number )
81: is

Line 92: from pay_payroll_actions xppa,

88: ------------------------------------------------------------------------
89: cursor c_assact
90: is
91: select distinct paa.assignment_id
92: from pay_payroll_actions xppa,
93: pay_payroll_actions rppa,
94: pay_assignment_actions rpac,
95: per_assignments_f paa,
96: per_assignment_extra_info aei1,

Line 93: pay_payroll_actions rppa,

89: cursor c_assact
90: is
91: select distinct paa.assignment_id
92: from pay_payroll_actions xppa,
93: pay_payroll_actions rppa,
94: pay_assignment_actions rpac,
95: per_assignments_f paa,
96: per_assignment_extra_info aei1,
97: per_assignment_extra_info aei2,

Line 179: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )

175: ------------------------------------------------------------
176: -- Assignment Action Code
177: ------------------------------------------------------------
178: procedure initialization_code
179: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
180: is
181:
182: begin
183: l_package := ' pay_sg_cpfline.';

Line 203: from pay_payroll_actions ppa

199: replace(pay_core_utils.get_parameter('CSN',ppa.legislative_parameters),'#',' ') csn,
200: to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)||'01','YYYYMMDD'),
201: last_day(to_date(pay_core_utils.get_parameter('MONTH',ppa.legislative_parameters)|| '01','YYYYMMDD'))
202: into g_pact
203: from pay_payroll_actions ppa
204: where ppa.payroll_action_id = p_payroll_action_id;
205: end if ;
206: --
207: if g_debug then

Line 226: l_payroll_id pay_payroll_actions.payroll_action_id%type ;

222: p_effective_date in date)
223: is
224: --
225: l_assignment_id per_all_assignments_f.assignment_id%type;
226: l_payroll_id pay_payroll_actions.payroll_action_id%type ;
227: --------------------------
228: -- Tables for pay_balance_pkg
229: --------------------------
230: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

Line 266: pay_payroll_actions rppa,

262: fnd_date.date_to_canonical(paa.effective_start_date),
263: nvl(aei1.aei_information1,hoi.org_information10),
264: aei2.aei_information1
265: from pay_assignment_actions pac,
266: pay_payroll_actions rppa,
267: pay_assignment_actions rpac,
268: per_assignments_f paa,
269: per_assignment_extra_info aei1,
270: per_assignment_extra_info aei2,

Line 507: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )

503: -- table based on parameter value
504: -- Bug: 3619297 - Added check on action_context_type
505: ---------------------------------
506: procedure deinit_code
507: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
508: is
509: retain_archive_flag char(1) ;
510: begin
511: retain_archive_flag := 'N' ;

Line 514: from pay_payroll_actions ppa

510: begin
511: retain_archive_flag := 'N' ;
512: select pay_core_utils.get_parameter('RETAIN_ARCHIVE_DATA',ppa.legislative_parameters)
513: into retain_archive_flag
514: from pay_payroll_actions ppa
515: where ppa.payroll_action_id = p_payroll_action_id ;
516: --
517: if retain_archive_flag = 'N' then
518: delete from pay_action_information