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_US_YEAR_BEGIN_PROCESS dependencies on HR_UTILITY

Line 77: --hr_utility.trace_on(null,'oracle');

73: l_last_year VARCHAR2(4);
74: l_curr_year VARCHAR2(4);
75:
76: BEGIN
77: --hr_utility.trace_on(null,'oracle');
78: /* Get the assignments which have non zero SUI WAGE BASE OVERRIDE AMOUNT */
79: l_curr_year := p_curr_year;
80: hr_utility.trace('l_curr_year '||l_curr_year);
81:

Line 80: hr_utility.trace('l_curr_year '||l_curr_year);

76: BEGIN
77: --hr_utility.trace_on(null,'oracle');
78: /* Get the assignments which have non zero SUI WAGE BASE OVERRIDE AMOUNT */
79: l_curr_year := p_curr_year;
80: hr_utility.trace('l_curr_year '||l_curr_year);
81:
82: l_last_year := to_number(l_curr_year) - 1;
83:
84: hr_utility.trace('l_last_year '||l_last_year);

Line 84: hr_utility.trace('l_last_year '||l_last_year);

80: hr_utility.trace('l_curr_year '||l_curr_year);
81:
82: l_last_year := to_number(l_curr_year) - 1;
83:
84: hr_utility.trace('l_last_year '||l_last_year);
85:
86: l_last_day := to_date('12/31/'||l_last_year,'MM/DD/YYYY');
87: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
88:

Line 90: hr_utility.trace('l_last_day '||to_char(l_last_day));

86: l_last_day := to_date('12/31/'||l_last_year,'MM/DD/YYYY');
87: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
88:
89:
90: hr_utility.trace('l_last_day '||to_char(l_last_day));
91: hr_utility.trace('l_start_day '||to_char(l_start_day));
92:
93: open csr_get_asg(l_start_day , p_business_group);
94:

Line 91: hr_utility.trace('l_start_day '||to_char(l_start_day));

87: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
88:
89:
90: hr_utility.trace('l_last_day '||to_char(l_last_day));
91: hr_utility.trace('l_start_day '||to_char(l_start_day));
92:
93: open csr_get_asg(l_start_day , p_business_group);
94:
95: hr_utility.trace('Updating the state tax records ...');

Line 95: hr_utility.trace('Updating the state tax records ...');

91: hr_utility.trace('l_start_day '||to_char(l_start_day));
92:
93: open csr_get_asg(l_start_day , p_business_group);
94:
95: hr_utility.trace('Updating the state tax records ...');
96:
97: loop
98:
99: fetch csr_get_asg into l_state_rec;

Line 103: hr_utility.trace('Updating Assignment : ' ||

99: fetch csr_get_asg into l_state_rec;
100:
101: exit when csr_get_asg%NOTFOUND;
102:
103: hr_utility.trace('Updating Assignment : ' ||
104: to_char(l_state_rec.assignment_id));
105: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
106: hr_utility.trace(to_char(l_state_rec.effective_end_date));
107: hr_utility.trace(to_char( l_state_rec.assignment_id));

Line 105: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));

101: exit when csr_get_asg%NOTFOUND;
102:
103: hr_utility.trace('Updating Assignment : ' ||
104: to_char(l_state_rec.assignment_id));
105: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
106: hr_utility.trace(to_char(l_state_rec.effective_end_date));
107: hr_utility.trace(to_char( l_state_rec.assignment_id));
108: hr_utility.trace(l_state_rec.state_code);
109: hr_utility.trace(l_state_rec.jurisdiction_code);

Line 106: hr_utility.trace(to_char(l_state_rec.effective_end_date));

102:
103: hr_utility.trace('Updating Assignment : ' ||
104: to_char(l_state_rec.assignment_id));
105: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
106: hr_utility.trace(to_char(l_state_rec.effective_end_date));
107: hr_utility.trace(to_char( l_state_rec.assignment_id));
108: hr_utility.trace(l_state_rec.state_code);
109: hr_utility.trace(l_state_rec.jurisdiction_code);
110: hr_utility.trace(to_char(l_state_rec.business_group_id));

Line 107: hr_utility.trace(to_char( l_state_rec.assignment_id));

103: hr_utility.trace('Updating Assignment : ' ||
104: to_char(l_state_rec.assignment_id));
105: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
106: hr_utility.trace(to_char(l_state_rec.effective_end_date));
107: hr_utility.trace(to_char( l_state_rec.assignment_id));
108: hr_utility.trace(l_state_rec.state_code);
109: hr_utility.trace(l_state_rec.jurisdiction_code);
110: hr_utility.trace(to_char(l_state_rec.business_group_id));
111: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));

Line 108: hr_utility.trace(l_state_rec.state_code);

104: to_char(l_state_rec.assignment_id));
105: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
106: hr_utility.trace(to_char(l_state_rec.effective_end_date));
107: hr_utility.trace(to_char( l_state_rec.assignment_id));
108: hr_utility.trace(l_state_rec.state_code);
109: hr_utility.trace(l_state_rec.jurisdiction_code);
110: hr_utility.trace(to_char(l_state_rec.business_group_id));
111: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
112: hr_utility.trace( l_state_rec.filing_status_code);

Line 109: hr_utility.trace(l_state_rec.jurisdiction_code);

105: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
106: hr_utility.trace(to_char(l_state_rec.effective_end_date));
107: hr_utility.trace(to_char( l_state_rec.assignment_id));
108: hr_utility.trace(l_state_rec.state_code);
109: hr_utility.trace(l_state_rec.jurisdiction_code);
110: hr_utility.trace(to_char(l_state_rec.business_group_id));
111: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
112: hr_utility.trace( l_state_rec.filing_status_code);
113: hr_utility.trace(to_char( l_state_rec.remainder_percent));

Line 110: hr_utility.trace(to_char(l_state_rec.business_group_id));

106: hr_utility.trace(to_char(l_state_rec.effective_end_date));
107: hr_utility.trace(to_char( l_state_rec.assignment_id));
108: hr_utility.trace(l_state_rec.state_code);
109: hr_utility.trace(l_state_rec.jurisdiction_code);
110: hr_utility.trace(to_char(l_state_rec.business_group_id));
111: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
112: hr_utility.trace( l_state_rec.filing_status_code);
113: hr_utility.trace(to_char( l_state_rec.remainder_percent));
114: hr_utility.trace(to_char( l_state_rec.secondary_wa));

Line 111: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));

107: hr_utility.trace(to_char( l_state_rec.assignment_id));
108: hr_utility.trace(l_state_rec.state_code);
109: hr_utility.trace(l_state_rec.jurisdiction_code);
110: hr_utility.trace(to_char(l_state_rec.business_group_id));
111: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
112: hr_utility.trace( l_state_rec.filing_status_code);
113: hr_utility.trace(to_char( l_state_rec.remainder_percent));
114: hr_utility.trace(to_char( l_state_rec.secondary_wa));
115: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));

Line 112: hr_utility.trace( l_state_rec.filing_status_code);

108: hr_utility.trace(l_state_rec.state_code);
109: hr_utility.trace(l_state_rec.jurisdiction_code);
110: hr_utility.trace(to_char(l_state_rec.business_group_id));
111: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
112: hr_utility.trace( l_state_rec.filing_status_code);
113: hr_utility.trace(to_char( l_state_rec.remainder_percent));
114: hr_utility.trace(to_char( l_state_rec.secondary_wa));
115: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
116: hr_utility.trace(to_char( l_state_rec.sit_override_amount));

Line 113: hr_utility.trace(to_char( l_state_rec.remainder_percent));

109: hr_utility.trace(l_state_rec.jurisdiction_code);
110: hr_utility.trace(to_char(l_state_rec.business_group_id));
111: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
112: hr_utility.trace( l_state_rec.filing_status_code);
113: hr_utility.trace(to_char( l_state_rec.remainder_percent));
114: hr_utility.trace(to_char( l_state_rec.secondary_wa));
115: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
116: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
117: hr_utility.trace(to_char( l_state_rec.sit_override_rate));

Line 114: hr_utility.trace(to_char( l_state_rec.secondary_wa));

110: hr_utility.trace(to_char(l_state_rec.business_group_id));
111: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
112: hr_utility.trace( l_state_rec.filing_status_code);
113: hr_utility.trace(to_char( l_state_rec.remainder_percent));
114: hr_utility.trace(to_char( l_state_rec.secondary_wa));
115: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
116: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
117: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
118: hr_utility.trace(to_char( l_state_rec.withholding_allowances));

Line 115: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));

111: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
112: hr_utility.trace( l_state_rec.filing_status_code);
113: hr_utility.trace(to_char( l_state_rec.remainder_percent));
114: hr_utility.trace(to_char( l_state_rec.secondary_wa));
115: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
116: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
117: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
118: hr_utility.trace(to_char( l_state_rec.withholding_allowances));
119:

Line 116: hr_utility.trace(to_char( l_state_rec.sit_override_amount));

112: hr_utility.trace( l_state_rec.filing_status_code);
113: hr_utility.trace(to_char( l_state_rec.remainder_percent));
114: hr_utility.trace(to_char( l_state_rec.secondary_wa));
115: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
116: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
117: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
118: hr_utility.trace(to_char( l_state_rec.withholding_allowances));
119:
120: /* End date the state tax record as of /12/31/(input year-1) */

Line 117: hr_utility.trace(to_char( l_state_rec.sit_override_rate));

113: hr_utility.trace(to_char( l_state_rec.remainder_percent));
114: hr_utility.trace(to_char( l_state_rec.secondary_wa));
115: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
116: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
117: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
118: hr_utility.trace(to_char( l_state_rec.withholding_allowances));
119:
120: /* End date the state tax record as of /12/31/(input year-1) */
121:

Line 118: hr_utility.trace(to_char( l_state_rec.withholding_allowances));

114: hr_utility.trace(to_char( l_state_rec.secondary_wa));
115: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
116: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
117: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
118: hr_utility.trace(to_char( l_state_rec.withholding_allowances));
119:
120: /* End date the state tax record as of /12/31/(input year-1) */
121:
122:

Line 132: hr_utility.trace('Inserting Assignment : ' ||to_char(l_state_rec.assignment_id));

128: and effective_end_date = l_state_rec.effective_end_date
129: and sui_wage_base_override_amount is not null;
130:
131: /* Null out the SUI WAGE BASE OVERRIDE AMOUNT as of 01/01/1999 */
132: hr_utility.trace('Inserting Assignment : ' ||to_char(l_state_rec.assignment_id));
133:
134: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
135:
136: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));

Line 134: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));

130:
131: /* Null out the SUI WAGE BASE OVERRIDE AMOUNT as of 01/01/1999 */
132: hr_utility.trace('Inserting Assignment : ' ||to_char(l_state_rec.assignment_id));
133:
134: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
135:
136: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));
137:
138: /*We need to reset INDIANA EIC Also */

Line 136: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));

132: hr_utility.trace('Inserting Assignment : ' ||to_char(l_state_rec.assignment_id));
133:
134: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
135:
136: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));
137:
138: /*We need to reset INDIANA EIC Also */
139: /* IF (l_state_rec.sta_information_category <> 'IN' AND l_state_rec.state_code <> '15') THEN
140: l_ind_eic := l_state_rec.sta_information1;

Line 331: hr_utility.trace('Updated Assignment : ' ||

327: l_state_rec.sta_information28,
328: l_state_rec.sta_information29,
329: l_state_rec.sta_information30) ;
330:
331: hr_utility.trace('Updated Assignment : ' ||
332: to_char(l_state_rec.assignment_id));
333: commit;
334: end loop;
335: close csr_get_asg;

Line 363: --hr_utility.trace_on(null,'oracle');

359: l_last_year VARCHAR2(4);
360: l_curr_year VARCHAR2(4);
361:
362: BEGIN
363: --hr_utility.trace_on(null,'oracle');
364: /* Get the assignments which have non zero SUI WAGE BASE OVERRIDE AMOUNT */
365: l_curr_year := p_curr_year;
366: hr_utility.trace('l_curr_year '||l_curr_year);
367:

Line 366: hr_utility.trace('l_curr_year '||l_curr_year);

362: BEGIN
363: --hr_utility.trace_on(null,'oracle');
364: /* Get the assignments which have non zero SUI WAGE BASE OVERRIDE AMOUNT */
365: l_curr_year := p_curr_year;
366: hr_utility.trace('l_curr_year '||l_curr_year);
367:
368: l_last_year := to_number(l_curr_year) - 1;
369:
370: hr_utility.trace('l_last_year '||l_last_year);

Line 370: hr_utility.trace('l_last_year '||l_last_year);

366: hr_utility.trace('l_curr_year '||l_curr_year);
367:
368: l_last_year := to_number(l_curr_year) - 1;
369:
370: hr_utility.trace('l_last_year '||l_last_year);
371:
372: l_last_day := to_date('12/31/'||l_last_year,'MM/DD/YYYY');
373: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
374:

Line 376: hr_utility.trace('l_last_day '||to_char(l_last_day));

372: l_last_day := to_date('12/31/'||l_last_year,'MM/DD/YYYY');
373: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
374:
375:
376: hr_utility.trace('l_last_day '||to_char(l_last_day));
377: hr_utility.trace('l_start_day '||to_char(l_start_day));
378:
379: open csr_get_asg(l_start_day , p_business_group);
380:

Line 377: hr_utility.trace('l_start_day '||to_char(l_start_day));

373: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
374:
375:
376: hr_utility.trace('l_last_day '||to_char(l_last_day));
377: hr_utility.trace('l_start_day '||to_char(l_start_day));
378:
379: open csr_get_asg(l_start_day , p_business_group);
380:
381: hr_utility.trace('Updating the state tax records ...');

Line 381: hr_utility.trace('Updating the state tax records ...');

377: hr_utility.trace('l_start_day '||to_char(l_start_day));
378:
379: open csr_get_asg(l_start_day , p_business_group);
380:
381: hr_utility.trace('Updating the state tax records ...');
382:
383: loop
384:
385: fetch csr_get_asg into l_state_rec;

Line 389: hr_utility.trace('Updating Assignment : ' ||

385: fetch csr_get_asg into l_state_rec;
386:
387: exit when csr_get_asg%NOTFOUND;
388:
389: hr_utility.trace('Updating Assignment : ' ||
390: to_char(l_state_rec.assignment_id));
391: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
392: hr_utility.trace(to_char(l_state_rec.effective_end_date));
393: hr_utility.trace(to_char( l_state_rec.assignment_id));

Line 391: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));

387: exit when csr_get_asg%NOTFOUND;
388:
389: hr_utility.trace('Updating Assignment : ' ||
390: to_char(l_state_rec.assignment_id));
391: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
392: hr_utility.trace(to_char(l_state_rec.effective_end_date));
393: hr_utility.trace(to_char( l_state_rec.assignment_id));
394: hr_utility.trace(l_state_rec.state_code);
395: hr_utility.trace(l_state_rec.jurisdiction_code);

Line 392: hr_utility.trace(to_char(l_state_rec.effective_end_date));

388:
389: hr_utility.trace('Updating Assignment : ' ||
390: to_char(l_state_rec.assignment_id));
391: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
392: hr_utility.trace(to_char(l_state_rec.effective_end_date));
393: hr_utility.trace(to_char( l_state_rec.assignment_id));
394: hr_utility.trace(l_state_rec.state_code);
395: hr_utility.trace(l_state_rec.jurisdiction_code);
396: hr_utility.trace(to_char(l_state_rec.business_group_id));

Line 393: hr_utility.trace(to_char( l_state_rec.assignment_id));

389: hr_utility.trace('Updating Assignment : ' ||
390: to_char(l_state_rec.assignment_id));
391: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
392: hr_utility.trace(to_char(l_state_rec.effective_end_date));
393: hr_utility.trace(to_char( l_state_rec.assignment_id));
394: hr_utility.trace(l_state_rec.state_code);
395: hr_utility.trace(l_state_rec.jurisdiction_code);
396: hr_utility.trace(to_char(l_state_rec.business_group_id));
397: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));

Line 394: hr_utility.trace(l_state_rec.state_code);

390: to_char(l_state_rec.assignment_id));
391: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
392: hr_utility.trace(to_char(l_state_rec.effective_end_date));
393: hr_utility.trace(to_char( l_state_rec.assignment_id));
394: hr_utility.trace(l_state_rec.state_code);
395: hr_utility.trace(l_state_rec.jurisdiction_code);
396: hr_utility.trace(to_char(l_state_rec.business_group_id));
397: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
398: hr_utility.trace( l_state_rec.filing_status_code);

Line 395: hr_utility.trace(l_state_rec.jurisdiction_code);

391: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
392: hr_utility.trace(to_char(l_state_rec.effective_end_date));
393: hr_utility.trace(to_char( l_state_rec.assignment_id));
394: hr_utility.trace(l_state_rec.state_code);
395: hr_utility.trace(l_state_rec.jurisdiction_code);
396: hr_utility.trace(to_char(l_state_rec.business_group_id));
397: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
398: hr_utility.trace( l_state_rec.filing_status_code);
399: hr_utility.trace(to_char( l_state_rec.remainder_percent));

Line 396: hr_utility.trace(to_char(l_state_rec.business_group_id));

392: hr_utility.trace(to_char(l_state_rec.effective_end_date));
393: hr_utility.trace(to_char( l_state_rec.assignment_id));
394: hr_utility.trace(l_state_rec.state_code);
395: hr_utility.trace(l_state_rec.jurisdiction_code);
396: hr_utility.trace(to_char(l_state_rec.business_group_id));
397: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
398: hr_utility.trace( l_state_rec.filing_status_code);
399: hr_utility.trace(to_char( l_state_rec.remainder_percent));
400: hr_utility.trace(to_char( l_state_rec.secondary_wa));

Line 397: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));

393: hr_utility.trace(to_char( l_state_rec.assignment_id));
394: hr_utility.trace(l_state_rec.state_code);
395: hr_utility.trace(l_state_rec.jurisdiction_code);
396: hr_utility.trace(to_char(l_state_rec.business_group_id));
397: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
398: hr_utility.trace( l_state_rec.filing_status_code);
399: hr_utility.trace(to_char( l_state_rec.remainder_percent));
400: hr_utility.trace(to_char( l_state_rec.secondary_wa));
401: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));

Line 398: hr_utility.trace( l_state_rec.filing_status_code);

394: hr_utility.trace(l_state_rec.state_code);
395: hr_utility.trace(l_state_rec.jurisdiction_code);
396: hr_utility.trace(to_char(l_state_rec.business_group_id));
397: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
398: hr_utility.trace( l_state_rec.filing_status_code);
399: hr_utility.trace(to_char( l_state_rec.remainder_percent));
400: hr_utility.trace(to_char( l_state_rec.secondary_wa));
401: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
402: hr_utility.trace(to_char( l_state_rec.sit_override_amount));

Line 399: hr_utility.trace(to_char( l_state_rec.remainder_percent));

395: hr_utility.trace(l_state_rec.jurisdiction_code);
396: hr_utility.trace(to_char(l_state_rec.business_group_id));
397: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
398: hr_utility.trace( l_state_rec.filing_status_code);
399: hr_utility.trace(to_char( l_state_rec.remainder_percent));
400: hr_utility.trace(to_char( l_state_rec.secondary_wa));
401: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
402: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
403: hr_utility.trace(to_char( l_state_rec.sit_override_rate));

Line 400: hr_utility.trace(to_char( l_state_rec.secondary_wa));

396: hr_utility.trace(to_char(l_state_rec.business_group_id));
397: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
398: hr_utility.trace( l_state_rec.filing_status_code);
399: hr_utility.trace(to_char( l_state_rec.remainder_percent));
400: hr_utility.trace(to_char( l_state_rec.secondary_wa));
401: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
402: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
403: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
404: hr_utility.trace(to_char( l_state_rec.withholding_allowances));

Line 401: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));

397: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
398: hr_utility.trace( l_state_rec.filing_status_code);
399: hr_utility.trace(to_char( l_state_rec.remainder_percent));
400: hr_utility.trace(to_char( l_state_rec.secondary_wa));
401: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
402: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
403: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
404: hr_utility.trace(to_char( l_state_rec.withholding_allowances));
405:

Line 402: hr_utility.trace(to_char( l_state_rec.sit_override_amount));

398: hr_utility.trace( l_state_rec.filing_status_code);
399: hr_utility.trace(to_char( l_state_rec.remainder_percent));
400: hr_utility.trace(to_char( l_state_rec.secondary_wa));
401: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
402: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
403: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
404: hr_utility.trace(to_char( l_state_rec.withholding_allowances));
405:
406: /* End date the state tax record as of /12/31/(input year-1) */

Line 403: hr_utility.trace(to_char( l_state_rec.sit_override_rate));

399: hr_utility.trace(to_char( l_state_rec.remainder_percent));
400: hr_utility.trace(to_char( l_state_rec.secondary_wa));
401: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
402: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
403: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
404: hr_utility.trace(to_char( l_state_rec.withholding_allowances));
405:
406: /* End date the state tax record as of /12/31/(input year-1) */
407:

Line 404: hr_utility.trace(to_char( l_state_rec.withholding_allowances));

400: hr_utility.trace(to_char( l_state_rec.secondary_wa));
401: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
402: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
403: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
404: hr_utility.trace(to_char( l_state_rec.withholding_allowances));
405:
406: /* End date the state tax record as of /12/31/(input year-1) */
407:
408:

Line 418: hr_utility.trace('Inserting Assignment : ' ||to_char(l_state_rec.assignment_id));

414: and effective_end_date = l_state_rec.effective_end_date
415: and sta_information1 is not null;
416:
417: /* Null out the Indiana EIC as of 01/01/1999 */
418: hr_utility.trace('Inserting Assignment : ' ||to_char(l_state_rec.assignment_id));
419:
420: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
421:
422: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));

Line 420: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));

416:
417: /* Null out the Indiana EIC as of 01/01/1999 */
418: hr_utility.trace('Inserting Assignment : ' ||to_char(l_state_rec.assignment_id));
419:
420: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
421:
422: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));
423:
424: insert into PAY_US_EMP_STATE_TAX_RULES_F

Line 422: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));

418: hr_utility.trace('Inserting Assignment : ' ||to_char(l_state_rec.assignment_id));
419:
420: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
421:
422: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));
423:
424: insert into PAY_US_EMP_STATE_TAX_RULES_F
425: (
426: EMP_STATE_TAX_RULE_ID,

Line 612: hr_utility.trace('Updated Assignment : ' ||

608: l_state_rec.STA_INFORMATION28 ,
609: l_state_rec.STA_INFORMATION29 ,
610: l_state_rec.STA_INFORMATION30 ) ;
611:
612: hr_utility.trace('Updated Assignment : ' ||
613: to_char(l_state_rec.assignment_id));
614: commit;
615: end loop;
616: close csr_get_asg;

Line 644: --hr_utility.trace_on(null,'oracle');

640: l_last_year VARCHAR2(4);
641: l_curr_year VARCHAR2(4);
642:
643: BEGIN
644: --hr_utility.trace_on(null,'oracle');
645: /* Get the assignments which have State EIC as not null */
646: l_curr_year := p_curr_year;
647: hr_utility.trace('l_curr_year '||l_curr_year);
648:

Line 647: hr_utility.trace('l_curr_year '||l_curr_year);

643: BEGIN
644: --hr_utility.trace_on(null,'oracle');
645: /* Get the assignments which have State EIC as not null */
646: l_curr_year := p_curr_year;
647: hr_utility.trace('l_curr_year '||l_curr_year);
648:
649: l_last_year := to_number(l_curr_year) - 1;
650:
651: hr_utility.trace('l_last_year '||l_last_year);

Line 651: hr_utility.trace('l_last_year '||l_last_year);

647: hr_utility.trace('l_curr_year '||l_curr_year);
648:
649: l_last_year := to_number(l_curr_year) - 1;
650:
651: hr_utility.trace('l_last_year '||l_last_year);
652:
653: l_last_day := to_date('12/31/'||l_last_year,'MM/DD/YYYY');
654: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
655:

Line 657: hr_utility.trace('l_last_day '||to_char(l_last_day));

653: l_last_day := to_date('12/31/'||l_last_year,'MM/DD/YYYY');
654: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
655:
656:
657: hr_utility.trace('l_last_day '||to_char(l_last_day));
658: hr_utility.trace('l_start_day '||to_char(l_start_day));
659:
660: open csr_get_asg(l_start_day , p_business_group);
661:

Line 658: hr_utility.trace('l_start_day '||to_char(l_start_day));

654: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
655:
656:
657: hr_utility.trace('l_last_day '||to_char(l_last_day));
658: hr_utility.trace('l_start_day '||to_char(l_start_day));
659:
660: open csr_get_asg(l_start_day , p_business_group);
661:
662: hr_utility.trace('Updating the state tax records ...');

Line 662: hr_utility.trace('Updating the state tax records ...');

658: hr_utility.trace('l_start_day '||to_char(l_start_day));
659:
660: open csr_get_asg(l_start_day , p_business_group);
661:
662: hr_utility.trace('Updating the state tax records ...');
663:
664: loop
665:
666: fetch csr_get_asg into l_state_rec;

Line 670: hr_utility.trace('Updating Assignment : ' ||

666: fetch csr_get_asg into l_state_rec;
667:
668: exit when csr_get_asg%NOTFOUND;
669:
670: hr_utility.trace('Updating Assignment : ' ||
671: to_char(l_state_rec.assignment_id));
672: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
673: hr_utility.trace(to_char(l_state_rec.effective_end_date));
674: hr_utility.trace(to_char( l_state_rec.assignment_id));

Line 672: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));

668: exit when csr_get_asg%NOTFOUND;
669:
670: hr_utility.trace('Updating Assignment : ' ||
671: to_char(l_state_rec.assignment_id));
672: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
673: hr_utility.trace(to_char(l_state_rec.effective_end_date));
674: hr_utility.trace(to_char( l_state_rec.assignment_id));
675: hr_utility.trace(l_state_rec.state_code);
676: hr_utility.trace(l_state_rec.jurisdiction_code);

Line 673: hr_utility.trace(to_char(l_state_rec.effective_end_date));

669:
670: hr_utility.trace('Updating Assignment : ' ||
671: to_char(l_state_rec.assignment_id));
672: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
673: hr_utility.trace(to_char(l_state_rec.effective_end_date));
674: hr_utility.trace(to_char( l_state_rec.assignment_id));
675: hr_utility.trace(l_state_rec.state_code);
676: hr_utility.trace(l_state_rec.jurisdiction_code);
677: hr_utility.trace(to_char(l_state_rec.business_group_id));

Line 674: hr_utility.trace(to_char( l_state_rec.assignment_id));

670: hr_utility.trace('Updating Assignment : ' ||
671: to_char(l_state_rec.assignment_id));
672: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
673: hr_utility.trace(to_char(l_state_rec.effective_end_date));
674: hr_utility.trace(to_char( l_state_rec.assignment_id));
675: hr_utility.trace(l_state_rec.state_code);
676: hr_utility.trace(l_state_rec.jurisdiction_code);
677: hr_utility.trace(to_char(l_state_rec.business_group_id));
678: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));

Line 675: hr_utility.trace(l_state_rec.state_code);

671: to_char(l_state_rec.assignment_id));
672: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
673: hr_utility.trace(to_char(l_state_rec.effective_end_date));
674: hr_utility.trace(to_char( l_state_rec.assignment_id));
675: hr_utility.trace(l_state_rec.state_code);
676: hr_utility.trace(l_state_rec.jurisdiction_code);
677: hr_utility.trace(to_char(l_state_rec.business_group_id));
678: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
679: hr_utility.trace( l_state_rec.filing_status_code);

Line 676: hr_utility.trace(l_state_rec.jurisdiction_code);

672: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
673: hr_utility.trace(to_char(l_state_rec.effective_end_date));
674: hr_utility.trace(to_char( l_state_rec.assignment_id));
675: hr_utility.trace(l_state_rec.state_code);
676: hr_utility.trace(l_state_rec.jurisdiction_code);
677: hr_utility.trace(to_char(l_state_rec.business_group_id));
678: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
679: hr_utility.trace( l_state_rec.filing_status_code);
680: hr_utility.trace(to_char( l_state_rec.remainder_percent));

Line 677: hr_utility.trace(to_char(l_state_rec.business_group_id));

673: hr_utility.trace(to_char(l_state_rec.effective_end_date));
674: hr_utility.trace(to_char( l_state_rec.assignment_id));
675: hr_utility.trace(l_state_rec.state_code);
676: hr_utility.trace(l_state_rec.jurisdiction_code);
677: hr_utility.trace(to_char(l_state_rec.business_group_id));
678: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
679: hr_utility.trace( l_state_rec.filing_status_code);
680: hr_utility.trace(to_char( l_state_rec.remainder_percent));
681: hr_utility.trace(to_char( l_state_rec.secondary_wa));

Line 678: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));

674: hr_utility.trace(to_char( l_state_rec.assignment_id));
675: hr_utility.trace(l_state_rec.state_code);
676: hr_utility.trace(l_state_rec.jurisdiction_code);
677: hr_utility.trace(to_char(l_state_rec.business_group_id));
678: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
679: hr_utility.trace( l_state_rec.filing_status_code);
680: hr_utility.trace(to_char( l_state_rec.remainder_percent));
681: hr_utility.trace(to_char( l_state_rec.secondary_wa));
682: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));

Line 679: hr_utility.trace( l_state_rec.filing_status_code);

675: hr_utility.trace(l_state_rec.state_code);
676: hr_utility.trace(l_state_rec.jurisdiction_code);
677: hr_utility.trace(to_char(l_state_rec.business_group_id));
678: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
679: hr_utility.trace( l_state_rec.filing_status_code);
680: hr_utility.trace(to_char( l_state_rec.remainder_percent));
681: hr_utility.trace(to_char( l_state_rec.secondary_wa));
682: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
683: hr_utility.trace(to_char( l_state_rec.sit_override_amount));

Line 680: hr_utility.trace(to_char( l_state_rec.remainder_percent));

676: hr_utility.trace(l_state_rec.jurisdiction_code);
677: hr_utility.trace(to_char(l_state_rec.business_group_id));
678: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
679: hr_utility.trace( l_state_rec.filing_status_code);
680: hr_utility.trace(to_char( l_state_rec.remainder_percent));
681: hr_utility.trace(to_char( l_state_rec.secondary_wa));
682: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
683: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
684: hr_utility.trace(to_char( l_state_rec.sit_override_rate));

Line 681: hr_utility.trace(to_char( l_state_rec.secondary_wa));

677: hr_utility.trace(to_char(l_state_rec.business_group_id));
678: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
679: hr_utility.trace( l_state_rec.filing_status_code);
680: hr_utility.trace(to_char( l_state_rec.remainder_percent));
681: hr_utility.trace(to_char( l_state_rec.secondary_wa));
682: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
683: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
684: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
685: hr_utility.trace(to_char( l_state_rec.withholding_allowances));

Line 682: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));

678: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
679: hr_utility.trace( l_state_rec.filing_status_code);
680: hr_utility.trace(to_char( l_state_rec.remainder_percent));
681: hr_utility.trace(to_char( l_state_rec.secondary_wa));
682: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
683: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
684: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
685: hr_utility.trace(to_char( l_state_rec.withholding_allowances));
686:

Line 683: hr_utility.trace(to_char( l_state_rec.sit_override_amount));

679: hr_utility.trace( l_state_rec.filing_status_code);
680: hr_utility.trace(to_char( l_state_rec.remainder_percent));
681: hr_utility.trace(to_char( l_state_rec.secondary_wa));
682: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
683: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
684: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
685: hr_utility.trace(to_char( l_state_rec.withholding_allowances));
686:
687: /* End date the state tax record as of /12/31/(input year-1) */

Line 684: hr_utility.trace(to_char( l_state_rec.sit_override_rate));

680: hr_utility.trace(to_char( l_state_rec.remainder_percent));
681: hr_utility.trace(to_char( l_state_rec.secondary_wa));
682: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
683: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
684: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
685: hr_utility.trace(to_char( l_state_rec.withholding_allowances));
686:
687: /* End date the state tax record as of /12/31/(input year-1) */
688:

Line 685: hr_utility.trace(to_char( l_state_rec.withholding_allowances));

681: hr_utility.trace(to_char( l_state_rec.secondary_wa));
682: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
683: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
684: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
685: hr_utility.trace(to_char( l_state_rec.withholding_allowances));
686:
687: /* End date the state tax record as of /12/31/(input year-1) */
688:
689:

Line 699: hr_utility.trace('Inserting Assignment : ' ||to_char(l_state_rec.assignment_id));

695: and effective_end_date = l_state_rec.effective_end_date
696: and sta_information1 is not null;
697:
698: /* Null out the Wisconsin EIC as of 01/01/1999 */
699: hr_utility.trace('Inserting Assignment : ' ||to_char(l_state_rec.assignment_id));
700:
701: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
702:
703: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));

Line 701: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));

697:
698: /* Null out the Wisconsin EIC as of 01/01/1999 */
699: hr_utility.trace('Inserting Assignment : ' ||to_char(l_state_rec.assignment_id));
700:
701: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
702:
703: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));
704:
705: insert into PAY_US_EMP_STATE_TAX_RULES_F

Line 703: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));

699: hr_utility.trace('Inserting Assignment : ' ||to_char(l_state_rec.assignment_id));
700:
701: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
702:
703: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));
704:
705: insert into PAY_US_EMP_STATE_TAX_RULES_F
706: (
707: EMP_STATE_TAX_RULE_ID,

Line 893: hr_utility.trace('Updated Assignment : ' ||

889: l_state_rec.STA_INFORMATION28 ,
890: l_state_rec.STA_INFORMATION29 ,
891: l_state_rec.STA_INFORMATION30 ) ;
892:
893: hr_utility.trace('Updated Assignment : ' ||
894: to_char(l_state_rec.assignment_id));
895: commit;
896: end loop;
897: close csr_get_asg;

Line 928: --hr_utility.trace_on(null,'oracle');

924: l_last_year VARCHAR2(4);
925: l_curr_year VARCHAR2(4);
926:
927: BEGIN
928: --hr_utility.trace_on(null,'oracle');
929: /* Get the assignments which have PA head Tax Exemption */
930: l_curr_year := p_curr_year;
931: hr_utility.trace('l_curr_year '||l_curr_year);
932:

Line 931: hr_utility.trace('l_curr_year '||l_curr_year);

927: BEGIN
928: --hr_utility.trace_on(null,'oracle');
929: /* Get the assignments which have PA head Tax Exemption */
930: l_curr_year := p_curr_year;
931: hr_utility.trace('l_curr_year '||l_curr_year);
932:
933: l_last_year := to_number(l_curr_year) - 1;
934:
935: hr_utility.trace('l_last_year '||l_last_year);

Line 935: hr_utility.trace('l_last_year '||l_last_year);

931: hr_utility.trace('l_curr_year '||l_curr_year);
932:
933: l_last_year := to_number(l_curr_year) - 1;
934:
935: hr_utility.trace('l_last_year '||l_last_year);
936:
937: l_last_day := to_date('12/31/'||l_last_year,'MM/DD/YYYY');
938: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
939:

Line 941: hr_utility.trace('l_last_day '||to_char(l_last_day));

937: l_last_day := to_date('12/31/'||l_last_year,'MM/DD/YYYY');
938: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
939:
940:
941: hr_utility.trace('l_last_day '||to_char(l_last_day));
942: hr_utility.trace('l_start_day '||to_char(l_start_day));
943:
944: open csr_get_asg(l_start_day , p_business_group);
945:

Line 942: hr_utility.trace('l_start_day '||to_char(l_start_day));

938: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
939:
940:
941: hr_utility.trace('l_last_day '||to_char(l_last_day));
942: hr_utility.trace('l_start_day '||to_char(l_start_day));
943:
944: open csr_get_asg(l_start_day , p_business_group);
945:
946: hr_utility.trace('Updating the city tax records ...');

Line 946: hr_utility.trace('Updating the city tax records ...');

942: hr_utility.trace('l_start_day '||to_char(l_start_day));
943:
944: open csr_get_asg(l_start_day , p_business_group);
945:
946: hr_utility.trace('Updating the city tax records ...');
947:
948: loop
949:
950: fetch csr_get_asg into l_city_rec;

Line 966: hr_utility.trace('Inserting Assignment : ' ||to_char(l_city_rec.assignment_id));

962: and effective_end_date = l_city_rec.effective_end_date
963: and ht_exempt is not null;
964:
965: /* Null out the PA Head Tax exemption as of 01/01/1999 */
966: hr_utility.trace('Inserting Assignment : ' ||to_char(l_city_rec.assignment_id));
967:
968: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
969:
970: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_city_rec.effective_end_date));

Line 968: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));

964:
965: /* Null out the PA Head Tax exemption as of 01/01/1999 */
966: hr_utility.trace('Inserting Assignment : ' ||to_char(l_city_rec.assignment_id));
967:
968: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
969:
970: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_city_rec.effective_end_date));
971:
972:

Line 970: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_city_rec.effective_end_date));

966: hr_utility.trace('Inserting Assignment : ' ||to_char(l_city_rec.assignment_id));
967:
968: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
969:
970: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_city_rec.effective_end_date));
971:
972:
973:
974: insert into PAY_US_EMP_CITY_TAX_RULES_F

Line 1156: hr_utility.trace('Updated Assignment : ' ||

1152: l_city_rec.CTY_INFORMATION30
1153: );
1154:
1155:
1156: hr_utility.trace('Updated Assignment : ' ||
1157: to_char(l_city_rec.assignment_id));
1158: commit;
1159: end loop;
1160: close csr_get_asg;

Line 1188: --hr_utility.trace_on(null,'oracle');

1184: l_last_year VARCHAR2(4);
1185: l_curr_year VARCHAR2(4);
1186:
1187: BEGIN
1188: --hr_utility.trace_on(null,'oracle');
1189: /* Get the assignments which have Fed EIC */
1190: l_curr_year := p_curr_year;
1191: hr_utility.trace('l_curr_year '||l_curr_year);
1192:

Line 1191: hr_utility.trace('l_curr_year '||l_curr_year);

1187: BEGIN
1188: --hr_utility.trace_on(null,'oracle');
1189: /* Get the assignments which have Fed EIC */
1190: l_curr_year := p_curr_year;
1191: hr_utility.trace('l_curr_year '||l_curr_year);
1192:
1193: l_last_year := to_number(l_curr_year) - 1;
1194:
1195: hr_utility.trace('l_last_year '||l_last_year);

Line 1195: hr_utility.trace('l_last_year '||l_last_year);

1191: hr_utility.trace('l_curr_year '||l_curr_year);
1192:
1193: l_last_year := to_number(l_curr_year) - 1;
1194:
1195: hr_utility.trace('l_last_year '||l_last_year);
1196:
1197: l_last_day := to_date('12/31/'||l_last_year,'MM/DD/YYYY');
1198: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
1199:

Line 1201: hr_utility.trace('l_last_day '||to_char(l_last_day));

1197: l_last_day := to_date('12/31/'||l_last_year,'MM/DD/YYYY');
1198: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
1199:
1200:
1201: hr_utility.trace('l_last_day '||to_char(l_last_day));
1202: hr_utility.trace('l_start_day '||to_char(l_start_day));
1203:
1204: open csr_get_asg(l_start_day , p_business_group);
1205:

Line 1202: hr_utility.trace('l_start_day '||to_char(l_start_day));

1198: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
1199:
1200:
1201: hr_utility.trace('l_last_day '||to_char(l_last_day));
1202: hr_utility.trace('l_start_day '||to_char(l_start_day));
1203:
1204: open csr_get_asg(l_start_day , p_business_group);
1205:
1206: hr_utility.trace('Updating the fed tax records ...');

Line 1206: hr_utility.trace('Updating the fed tax records ...');

1202: hr_utility.trace('l_start_day '||to_char(l_start_day));
1203:
1204: open csr_get_asg(l_start_day , p_business_group);
1205:
1206: hr_utility.trace('Updating the fed tax records ...');
1207:
1208: loop
1209:
1210: fetch csr_get_asg into l_fed_rec;

Line 1225: hr_utility.trace('Inserting Assignment : ' ||to_char(l_fed_rec.assignment_id));

1221: and effective_end_date = l_fed_rec.effective_end_date
1222: and eic_filing_status_code <> 0;
1223:
1224: /* Null out the FED EIC of 01/01/1999 */
1225: hr_utility.trace('Inserting Assignment : ' ||to_char(l_fed_rec.assignment_id));
1226:
1227: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
1228:
1229: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_fed_rec.effective_end_date));

Line 1227: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));

1223:
1224: /* Null out the FED EIC of 01/01/1999 */
1225: hr_utility.trace('Inserting Assignment : ' ||to_char(l_fed_rec.assignment_id));
1226:
1227: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
1228:
1229: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_fed_rec.effective_end_date));
1230:
1231:

Line 1229: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_fed_rec.effective_end_date));

1225: hr_utility.trace('Inserting Assignment : ' ||to_char(l_fed_rec.assignment_id));
1226:
1227: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
1228:
1229: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_fed_rec.effective_end_date));
1230:
1231:
1232:
1233: /* Insert Stmt for FED Tax Rules will come here */

Line 1424: hr_utility.trace('Updated Assignment : ' ||

1420: l_fed_rec.FED_INFORMATION30
1421: );
1422:
1423:
1424: hr_utility.trace('Updated Assignment : ' ||
1425: to_char(l_fed_rec.assignment_id));
1426: commit;
1427: end loop;
1428: close csr_get_asg;

Line 1490: --hr_utility.trace_on(null,'ORACLE');

1486: )
1487: IS
1488:
1489: BEGIN
1490: --hr_utility.trace_on(null,'ORACLE');
1491: hr_utility.trace(p_business_group||p_curr_year||p_clr_ind_add_ovr||p_clr_ind_eic||p_clr_sui_wb_ovr||p_clr_pa_head_tax||p_clr_fed_eic_filing_status);
1492:
1493:
1494: /* Clear the Indiana Override Adderess/Location */

Line 1491: hr_utility.trace(p_business_group||p_curr_year||p_clr_ind_add_ovr||p_clr_ind_eic||p_clr_sui_wb_ovr||p_clr_pa_head_tax||p_clr_fed_eic_filing_status);

1487: IS
1488:
1489: BEGIN
1490: --hr_utility.trace_on(null,'ORACLE');
1491: hr_utility.trace(p_business_group||p_curr_year||p_clr_ind_add_ovr||p_clr_ind_eic||p_clr_sui_wb_ovr||p_clr_pa_head_tax||p_clr_fed_eic_filing_status);
1492:
1493:
1494: /* Clear the Indiana Override Adderess/Location */
1495: IF p_clr_ind_add_ovr = 'Y' THEN

Line 1502: hr_utility.trace('Procedure ind_eic_ovr');

1498: /* End Indiana Override Address /Location */
1499:
1500: /* Clear Indiana EIC */
1501: IF p_clr_ind_eic = 'Y' THEN
1502: hr_utility.trace('Procedure ind_eic_ovr');
1503: ind_eic_ovr(p_business_group,p_curr_year);
1504: END IF;
1505: /* End Indiana EIC */
1506:

Line 1511: hr_utility.trace('Procedure wis_eic_ovr');

1507: /*Added for Bug8985595 to allow the clearing of Wisconsin EIC through Year Begin Process */
1508:
1509: /* Clear Wisconsin EIC */
1510: IF p_clr_wis_eic = 'Y' THEN
1511: hr_utility.trace('Procedure wis_eic_ovr');
1512: wis_eic_ovr(p_business_group,p_curr_year);
1513: END IF;
1514: /* End Wisconsin EIC */
1515:

Line 1520: hr_utility.trace('Procedure sui_wb_ovr');

1516: /*Bug8985595 ends*/
1517:
1518: /* Clear SUI Wage Base Override */
1519: IF p_clr_sui_wb_ovr = 'Y' THEN
1520: hr_utility.trace('Procedure sui_wb_ovr');
1521: sui_wb_ovr(p_business_group,p_curr_year);
1522: END IF;
1523: /* End SUI Wage Base Override */
1524:

Line 1528: hr_utility.trace('Procedure pa_head_tx_ovr');

1524:
1525:
1526: /*Clear PA Head tax exempt */
1527: IF p_clr_pa_head_tax ='Y' THEN
1528: hr_utility.trace('Procedure pa_head_tx_ovr');
1529: pa_head_tx_ovr(p_business_group,p_curr_year);
1530: END IF;
1531: /* End PS head tax exempt */
1532:

Line 1536: hr_utility.trace('Procedure fed_eic_filing_status_ovr');

1532:
1533:
1534: /* Clear Federal EIC Filing status */
1535: IF p_clr_fed_eic_filing_status = 'Y' THEN
1536: hr_utility.trace('Procedure fed_eic_filing_status_ovr');
1537: fed_eic_filing_status_ovr(p_business_group,p_curr_year);
1538: END IF;
1539: /* End EIC filing status*/
1540: