DBA Data[Home] [Help]

APPS.PAY_CA_T4_MAG dependencies on PAY_CA_T4_MAG

Line 1: PACKAGE BODY pay_ca_t4_mag AS

1: PACKAGE BODY pay_ca_t4_mag AS
2: /* $Header: pycat4mg.pkb 120.2.12010000.4 2008/09/21 09:45:07 sapalani ship $ */
3:
4: /*
5: Name : get_report_parameters

Line 34: ('pay_ca_t4_mag.get_report_parameters', 10);

30: ) IS
31: BEGIN
32: /* hr_utility.trace_on('Y','T4MAG'); */
33: hr_utility.set_location
34: ('pay_ca_t4_mag.get_report_parameters', 10);
35:
36: SELECT ppa.start_date,
37: ppa.effective_date,
38: ppa.business_group_id,

Line 50: ('pay_ca_t4_mag.get_report_parameters', 20);

46: FROM pay_payroll_actions ppa
47: WHERE payroll_action_id = p_pactid;
48:
49: hr_utility.set_location
50: ('pay_ca_t4_mag.get_report_parameters', 20);
51:
52: END get_report_parameters;
53:
54:

Line 80: hr_utility.set_location( 'pay_ca_t4_mag.range_cursor', 10);

76: l_legislative_parameters VARCHAR2(200);
77:
78: BEGIN
79:
80: hr_utility.set_location( 'pay_ca_t4_mag.range_cursor', 10);
81:
82: get_report_parameters(
83: p_pactid,
84: p_year_start,

Line 91: hr_utility.set_location( 'pay_ca_t4_mag.range_cursor', 20);

87: p_business_group_id,
88: l_legislative_parameters
89: );
90:
91: hr_utility.set_location( 'pay_ca_t4_mag.range_cursor', 20);
92:
93: p_sqlstr := 'select distinct to_number(fai1.value)
94: from ff_archive_items fai1,
95: ff_database_items fdi1,

Line 108: and fai2.value = pay_ca_t4_mag.get_parameter(''REPORTING_YEAR'',ppa1.legislative_parameters)

104: and ppa.report_type = ''T4''
105: and ppa.payroll_action_id = paa.payroll_action_id
106: and fdi2.user_name = ''CAEOY_TAXATION_YEAR''
107: and fai2.user_entity_id = fdi2.user_entity_id
108: and fai2.value = pay_ca_t4_mag.get_parameter(''REPORTING_YEAR'',ppa1.legislative_parameters)
109: and paa.payroll_action_id= fai2.context1
110: and paa.action_status = ''C''
111: and paa.assignment_action_id = fai1.context1
112: and fai1.user_entity_id = fdi1.user_entity_id

Line 116: hr_utility.set_location( 'pay_ca_t4_mag.range_cursor',

112: and fai1.user_entity_id = fdi1.user_entity_id
113: and fdi1.user_name = ''CAEOY_PERSON_ID''
114: order by to_number(fai1.value)' ;
115:
116: hr_utility.set_location( 'pay_ca_t4_mag.range_cursor',
117: 30);
118:
119: END range_cursor;
120:

Line 173: and to_number(hoi.org_information11) = pay_ca_t4_mag.get_parameter('TRANSMITTER_GRE',ppa1.legislative_parameters)

169: hr_organization_information hoi1,
170: hr_organization_information hoi
171: where hoi.organization_id = paa.tax_unit_id
172: and hoi.org_information_context = 'Canada Employer Identification'
173: and to_number(hoi.org_information11) = pay_ca_t4_mag.get_parameter('TRANSMITTER_GRE',ppa1.legislative_parameters)
174: and hoi1.org_information_context = 'Fed Magnetic Reporting'
175: and hoi.org_information5 = 'T4/RL1'
176: and hoi1.organization_id = to_number(hoi.org_information11)
177: )

Line 212: hr_utility.set_location( 'pay_ca_t4_mag.create_assignement_act',10);

208: BEGIN
209:
210: /* Get the report parameters. These define the report being run.*/
211:
212: hr_utility.set_location( 'pay_ca_t4_mag.create_assignement_act',10);
213:
214: get_report_parameters(
215: p_pactid,
216: l_year_start,

Line 228: l_validate_gre := pay_ca_t4_mag.validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));

224:
225: l_trans_gre := pay_ca_t4a_mag.get_parameter('TRANSMITTER_GRE',
226: l_legislative_parameters);
227: hr_utility.trace('l_trans_gre ='||l_trans_gre);
228: l_validate_gre := pay_ca_t4_mag.validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
229: hr_utility.set_location( 'pay_ca_t4_mag.create_assignement_act',20);
230:
231: IF l_report_type = 'PYT4MAG' THEN
232: OPEN c_all_asg;

Line 229: hr_utility.set_location( 'pay_ca_t4_mag.create_assignement_act',20);

225: l_trans_gre := pay_ca_t4a_mag.get_parameter('TRANSMITTER_GRE',
226: l_legislative_parameters);
227: hr_utility.trace('l_trans_gre ='||l_trans_gre);
228: l_validate_gre := pay_ca_t4_mag.validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
229: hr_utility.set_location( 'pay_ca_t4_mag.create_assignement_act',20);
230:
231: IF l_report_type = 'PYT4MAG' THEN
232: OPEN c_all_asg;
233: LOOP

Line 241: 'pay_ca_t4_mag.create_assignement_act', 30);

237: l_effective_end_date,
238: l_assignment_action_id;
239:
240: hr_utility.set_location(
241: 'pay_ca_t4_mag.create_assignement_act', 30);
242:
243: EXIT WHEN c_all_asg%NOTFOUND;
244:
245:

Line 256: 'pay_ca_t4_mag.create_assignement_act', 40);

252: hr_utility.trace('Effective End Date : '||
253: to_char(l_effective_end_date));
254:
255: hr_utility.set_location(
256: 'pay_ca_t4_mag.create_assignement_act', 40);
257:
258: SELECT pay_assignment_actions_s.nextval
259: INTO lockingactid
260: FROM dual;

Line 263: 'pay_ca_t4_mag.create_assignement_act', 50);

259: INTO lockingactid
260: FROM dual;
261:
262: hr_utility.set_location(
263: 'pay_ca_t4_mag.create_assignement_act', 50);
264:
265: hr_nonrun_asact.insact(lockingactid, l_assignment_id, p_pactid,p_chunk, l_tax_unit_id);
266:
267: hr_utility.set_location(

Line 268: 'pay_ca_t4_mag.create_assignement_act', 60);

264:
265: hr_nonrun_asact.insact(lockingactid, l_assignment_id, p_pactid,p_chunk, l_tax_unit_id);
266:
267: hr_utility.set_location(
268: 'pay_ca_t4_mag.create_assignement_act', 60);
269:
270: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
271:
272: hr_utility.set_location(

Line 273: 'pay_ca_t4_mag.create_assignement_act', 70);

269:
270: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
271:
272: hr_utility.set_location(
273: 'pay_ca_t4_mag.create_assignement_act', 70);
274:
275: hr_utility.trace('Interlock Created - ');
276: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
277: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));

Line 1003: END pay_ca_t4_mag;

999: end if;
1000: end loop;
1001: RETURN '0';
1002: END validate_gre_data;
1003: END pay_ca_t4_mag;