DBA Data[Home] [Help]

APPS.PAY_CA_T4A_MAG dependencies on PAY_CA_T4A_MAG

Line 1: PACKAGE BODY pay_ca_t4a_mag AS

1: PACKAGE BODY pay_ca_t4a_mag AS
2: /* $Header: pycat4am.pkb 120.9 2011/01/27 11:46:12 sneelapa ship $ */
3:
4: -----------------------------------------------------------------------------
5: -- Name : get_report_parameters

Line 33: ('pay_ca_t4a_mag.get_report_parameters', 10);

29: p_legislative_parameters OUT NOCOPY VARCHAR2
30: ) IS
31: BEGIN
32: hr_utility.set_location
33: ('pay_ca_t4a_mag.get_report_parameters', 10);
34:
35: SELECT ppa.start_date,
36: ppa.effective_date,
37: ppa.business_group_id,

Line 48: ('pay_ca_t4a_mag.get_report_parameters', 20);

44: p_legislative_parameters
45: FROM pay_payroll_actions ppa
46: WHERE payroll_action_id = p_pactid;
47: hr_utility.set_location
48: ('pay_ca_t4a_mag.get_report_parameters', 20);
49:
50: END get_report_parameters;
51:
52: /* Added to fix performance bug */

Line 104: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 10);

100: l_tax_year VARCHAR2(10);
101:
102: BEGIN
103:
104: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 10);
105:
106: get_report_parameters(
107: p_pactid,
108: p_year_start,

Line 117: l_tax_year := pay_ca_t4a_mag.get_parameter('REPORTING_YEAR',

113: );
114:
115: l_tax_year_ue_id := get_user_entity_id('CAEOY_TAXATION_YEAR');
116: l_person_id_ue_id := get_user_entity_id('CAEOY_PERSON_ID');
117: l_tax_year := pay_ca_t4a_mag.get_parameter('REPORTING_YEAR',
118: l_legislative_parameters);
119:
120: hr_utility.trace('l_tax_year ='||l_tax_year);
121: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 20);

Line 121: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 20);

117: l_tax_year := pay_ca_t4a_mag.get_parameter('REPORTING_YEAR',
118: l_legislative_parameters);
119:
120: hr_utility.trace('l_tax_year ='||l_tax_year);
121: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 20);
122:
123: /* Removed the join from 'Where clause' that checks
124: whether GRE has the 'Fed Magnetic Reporting' information or not */
125:

Line 150: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 30);

146: ' and fai1.context1 = paa.assignment_action_id
147: and fai1.user_entity_id = '||l_person_id_ue_id||
148: ' order by to_number(fai1.value)';
149:
150: hr_utility.set_location( 'pay_ca_t4a_mag.range_cursor', 30);
151:
152: END range_cursor;
153:
154: --

Line 243: hr_utility.set_location( 'pay_ca_t4a_mag.create_assignement_act',10);

239: BEGIN
240:
241: -- Get the report parameters. These define the report being run.
242:
243: hr_utility.set_location( 'pay_ca_t4a_mag.create_assignement_act',10);
244:
245: get_report_parameters(
246: p_pactid,
247: l_year_start,

Line 254: l_trans_gre := pay_ca_t4a_mag.get_parameter('TRANSMITTER_GRE',

250: l_business_group_id,
251: l_legislative_parameters
252: );
253: --hr_utility.trace_on(null,'T4MAG');
254: l_trans_gre := pay_ca_t4a_mag.get_parameter('TRANSMITTER_GRE',
255: l_legislative_parameters);
256: hr_utility.trace('l_trans_gre ='||l_trans_gre);
257: l_validate_gre := pay_ca_t4a_mag.validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
258:

Line 257: l_validate_gre := pay_ca_t4a_mag.validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));

253: --hr_utility.trace_on(null,'T4MAG');
254: l_trans_gre := pay_ca_t4a_mag.get_parameter('TRANSMITTER_GRE',
255: l_legislative_parameters);
256: hr_utility.trace('l_trans_gre ='||l_trans_gre);
257: l_validate_gre := pay_ca_t4a_mag.validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
258:
259: hr_utility.set_location( 'pay_ca_t4a_mag.create_assignement_act',20);
260:
261: if l_validate_gre = '1' then

Line 259: hr_utility.set_location( 'pay_ca_t4a_mag.create_assignement_act',20);

255: l_legislative_parameters);
256: hr_utility.trace('l_trans_gre ='||l_trans_gre);
257: l_validate_gre := pay_ca_t4a_mag.validate_gre_data(l_trans_gre, to_char(l_year_end,'YYYY'));
258:
259: hr_utility.set_location( 'pay_ca_t4a_mag.create_assignement_act',20);
260:
261: if l_validate_gre = '1' then
262: hr_utility.raise_error;
263: end if;

Line 273: hr_utility.set_location('pay_ca_t4a_mag.create_assignement_act', 30);

269: l_assignment_id,
270: l_tax_unit_id,
271: l_effective_end_date,
272: l_assignment_action_id;
273: hr_utility.set_location('pay_ca_t4a_mag.create_assignement_act', 30);
274: EXIT WHEN c_all_asg%NOTFOUND;
275:
276:
277: --Create the assignment action for the record

Line 288: 'pay_ca_t4a_mag.create_assignement_act', 40);

284: hr_utility.trace('Effective End Date : '||
285: to_char(l_effective_end_date));
286:
287: hr_utility.set_location(
288: 'pay_ca_t4a_mag.create_assignement_act', 40);
289:
290: SELECT pay_assignment_actions_s.nextval
291: INTO lockingactid
292: FROM dual;

Line 294: 'pay_ca_t4a_mag.create_assignement_act', 50);

290: SELECT pay_assignment_actions_s.nextval
291: INTO lockingactid
292: FROM dual;
293: hr_utility.set_location(
294: 'pay_ca_t4a_mag.create_assignement_act', 50);
295:
296: hr_nonrun_asact.insact(lockingactid, l_assignment_id,
297: p_pactid,p_chunk, l_tax_unit_id);
298:

Line 300: 'pay_ca_t4a_mag.create_assignement_act', 60);

296: hr_nonrun_asact.insact(lockingactid, l_assignment_id,
297: p_pactid,p_chunk, l_tax_unit_id);
298:
299: hr_utility.set_location(
300: 'pay_ca_t4a_mag.create_assignement_act', 60);
301:
302: hr_nonrun_asact.insint(lockingactid,
303: l_assignment_action_id);
304:

Line 306: 'pay_ca_t4a_mag.create_assignement_act', 70);

302: hr_nonrun_asact.insint(lockingactid,
303: l_assignment_action_id);
304:
305: hr_utility.set_location(
306: 'pay_ca_t4a_mag.create_assignement_act', 70);
307:
308: hr_utility.trace('Interlock Created - ');
309: hr_utility.trace('Locking Action : '||
310: to_char(lockingactid));

Line 1295: END pay_ca_t4a_mag;

1291: fetch cur_archive into l_return;
1292: close cur_archive;
1293: RETURN (l_return);
1294: END ;
1295: END pay_ca_t4a_mag;