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 56: --hr_utility.trace_on(null,'oracle');

52: l_last_year VARCHAR2(4);
53: l_curr_year VARCHAR2(4);
54:
55: BEGIN
56: --hr_utility.trace_on(null,'oracle');
57: /* Get the assignments which have non zero SUI WAGE BASE OVERRIDE AMOUNT */
58: l_curr_year := p_curr_year;
59: hr_utility.trace('l_curr_year '||l_curr_year);
60:

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

55: BEGIN
56: --hr_utility.trace_on(null,'oracle');
57: /* Get the assignments which have non zero SUI WAGE BASE OVERRIDE AMOUNT */
58: l_curr_year := p_curr_year;
59: hr_utility.trace('l_curr_year '||l_curr_year);
60:
61: l_last_year := to_number(l_curr_year) - 1;
62:
63: hr_utility.trace('l_last_year '||l_last_year);

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

59: hr_utility.trace('l_curr_year '||l_curr_year);
60:
61: l_last_year := to_number(l_curr_year) - 1;
62:
63: hr_utility.trace('l_last_year '||l_last_year);
64:
65: l_last_day := to_date('12/31/'||l_last_year,'MM/DD/YYYY');
66: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
67:

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

65: l_last_day := to_date('12/31/'||l_last_year,'MM/DD/YYYY');
66: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
67:
68:
69: hr_utility.trace('l_last_day '||to_char(l_last_day));
70: hr_utility.trace('l_start_day '||to_char(l_start_day));
71:
72: open csr_get_asg(l_start_day , p_business_group);
73:

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

66: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
67:
68:
69: hr_utility.trace('l_last_day '||to_char(l_last_day));
70: hr_utility.trace('l_start_day '||to_char(l_start_day));
71:
72: open csr_get_asg(l_start_day , p_business_group);
73:
74: hr_utility.trace('Updating the state tax records ...');

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

70: hr_utility.trace('l_start_day '||to_char(l_start_day));
71:
72: open csr_get_asg(l_start_day , p_business_group);
73:
74: hr_utility.trace('Updating the state tax records ...');
75:
76: loop
77:
78: fetch csr_get_asg into l_state_rec;

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

78: fetch csr_get_asg into l_state_rec;
79:
80: exit when csr_get_asg%NOTFOUND;
81:
82: hr_utility.trace('Updating Assignment : ' ||
83: to_char(l_state_rec.assignment_id));
84: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
85: hr_utility.trace(to_char(l_state_rec.effective_end_date));
86: hr_utility.trace(to_char( l_state_rec.assignment_id));

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

80: exit when csr_get_asg%NOTFOUND;
81:
82: hr_utility.trace('Updating Assignment : ' ||
83: to_char(l_state_rec.assignment_id));
84: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
85: hr_utility.trace(to_char(l_state_rec.effective_end_date));
86: hr_utility.trace(to_char( l_state_rec.assignment_id));
87: hr_utility.trace(l_state_rec.state_code);
88: hr_utility.trace(l_state_rec.jurisdiction_code);

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

81:
82: hr_utility.trace('Updating Assignment : ' ||
83: to_char(l_state_rec.assignment_id));
84: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
85: hr_utility.trace(to_char(l_state_rec.effective_end_date));
86: hr_utility.trace(to_char( l_state_rec.assignment_id));
87: hr_utility.trace(l_state_rec.state_code);
88: hr_utility.trace(l_state_rec.jurisdiction_code);
89: hr_utility.trace(to_char(l_state_rec.business_group_id));

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

82: hr_utility.trace('Updating Assignment : ' ||
83: to_char(l_state_rec.assignment_id));
84: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
85: hr_utility.trace(to_char(l_state_rec.effective_end_date));
86: hr_utility.trace(to_char( l_state_rec.assignment_id));
87: hr_utility.trace(l_state_rec.state_code);
88: hr_utility.trace(l_state_rec.jurisdiction_code);
89: hr_utility.trace(to_char(l_state_rec.business_group_id));
90: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));

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

83: to_char(l_state_rec.assignment_id));
84: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
85: hr_utility.trace(to_char(l_state_rec.effective_end_date));
86: hr_utility.trace(to_char( l_state_rec.assignment_id));
87: hr_utility.trace(l_state_rec.state_code);
88: hr_utility.trace(l_state_rec.jurisdiction_code);
89: hr_utility.trace(to_char(l_state_rec.business_group_id));
90: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
91: hr_utility.trace( l_state_rec.filing_status_code);

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

84: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
85: hr_utility.trace(to_char(l_state_rec.effective_end_date));
86: hr_utility.trace(to_char( l_state_rec.assignment_id));
87: hr_utility.trace(l_state_rec.state_code);
88: hr_utility.trace(l_state_rec.jurisdiction_code);
89: hr_utility.trace(to_char(l_state_rec.business_group_id));
90: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
91: hr_utility.trace( l_state_rec.filing_status_code);
92: hr_utility.trace(to_char( l_state_rec.remainder_percent));

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

85: hr_utility.trace(to_char(l_state_rec.effective_end_date));
86: hr_utility.trace(to_char( l_state_rec.assignment_id));
87: hr_utility.trace(l_state_rec.state_code);
88: hr_utility.trace(l_state_rec.jurisdiction_code);
89: hr_utility.trace(to_char(l_state_rec.business_group_id));
90: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
91: hr_utility.trace( l_state_rec.filing_status_code);
92: hr_utility.trace(to_char( l_state_rec.remainder_percent));
93: hr_utility.trace(to_char( l_state_rec.secondary_wa));

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

86: hr_utility.trace(to_char( l_state_rec.assignment_id));
87: hr_utility.trace(l_state_rec.state_code);
88: hr_utility.trace(l_state_rec.jurisdiction_code);
89: hr_utility.trace(to_char(l_state_rec.business_group_id));
90: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
91: hr_utility.trace( l_state_rec.filing_status_code);
92: hr_utility.trace(to_char( l_state_rec.remainder_percent));
93: hr_utility.trace(to_char( l_state_rec.secondary_wa));
94: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));

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

87: hr_utility.trace(l_state_rec.state_code);
88: hr_utility.trace(l_state_rec.jurisdiction_code);
89: hr_utility.trace(to_char(l_state_rec.business_group_id));
90: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
91: hr_utility.trace( l_state_rec.filing_status_code);
92: hr_utility.trace(to_char( l_state_rec.remainder_percent));
93: hr_utility.trace(to_char( l_state_rec.secondary_wa));
94: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
95: hr_utility.trace(to_char( l_state_rec.sit_override_amount));

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

88: hr_utility.trace(l_state_rec.jurisdiction_code);
89: hr_utility.trace(to_char(l_state_rec.business_group_id));
90: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
91: hr_utility.trace( l_state_rec.filing_status_code);
92: hr_utility.trace(to_char( l_state_rec.remainder_percent));
93: hr_utility.trace(to_char( l_state_rec.secondary_wa));
94: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
95: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
96: hr_utility.trace(to_char( l_state_rec.sit_override_rate));

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

89: hr_utility.trace(to_char(l_state_rec.business_group_id));
90: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
91: hr_utility.trace( l_state_rec.filing_status_code);
92: hr_utility.trace(to_char( l_state_rec.remainder_percent));
93: hr_utility.trace(to_char( l_state_rec.secondary_wa));
94: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
95: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
96: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
97: hr_utility.trace(to_char( l_state_rec.withholding_allowances));

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

90: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
91: hr_utility.trace( l_state_rec.filing_status_code);
92: hr_utility.trace(to_char( l_state_rec.remainder_percent));
93: hr_utility.trace(to_char( l_state_rec.secondary_wa));
94: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
95: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
96: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
97: hr_utility.trace(to_char( l_state_rec.withholding_allowances));
98:

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

91: hr_utility.trace( l_state_rec.filing_status_code);
92: hr_utility.trace(to_char( l_state_rec.remainder_percent));
93: hr_utility.trace(to_char( l_state_rec.secondary_wa));
94: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
95: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
96: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
97: hr_utility.trace(to_char( l_state_rec.withholding_allowances));
98:
99: /* End date the state tax record as of /12/31/(input year-1) */

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

92: hr_utility.trace(to_char( l_state_rec.remainder_percent));
93: hr_utility.trace(to_char( l_state_rec.secondary_wa));
94: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
95: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
96: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
97: hr_utility.trace(to_char( l_state_rec.withholding_allowances));
98:
99: /* End date the state tax record as of /12/31/(input year-1) */
100:

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

93: hr_utility.trace(to_char( l_state_rec.secondary_wa));
94: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
95: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
96: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
97: hr_utility.trace(to_char( l_state_rec.withholding_allowances));
98:
99: /* End date the state tax record as of /12/31/(input year-1) */
100:
101:

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

107: and effective_end_date = l_state_rec.effective_end_date
108: and sui_wage_base_override_amount is not null;
109:
110: /* Null out the SUI WAGE BASE OVERRIDE AMOUNT as of 01/01/1999 */
111: hr_utility.trace('Inserting Assignment : ' ||to_char(l_state_rec.assignment_id));
112:
113: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
114:
115: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));

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

109:
110: /* Null out the SUI WAGE BASE OVERRIDE AMOUNT as of 01/01/1999 */
111: hr_utility.trace('Inserting Assignment : ' ||to_char(l_state_rec.assignment_id));
112:
113: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
114:
115: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));
116:
117: /*We need to reset INDIANA EIC Also */

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

111: hr_utility.trace('Inserting Assignment : ' ||to_char(l_state_rec.assignment_id));
112:
113: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
114:
115: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));
116:
117: /*We need to reset INDIANA EIC Also */
118: /* IF (l_state_rec.sta_information_category <> 'IN' AND l_state_rec.state_code <> '15') THEN
119: l_ind_eic := l_state_rec.sta_information1;

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

172: null,
173: l_state_rec.supp_tax_override_rate,
174: l_state_rec.object_version_number) ;
175:
176: hr_utility.trace('Updated Assignment : ' ||
177: to_char(l_state_rec.assignment_id));
178: commit;
179: end loop;
180: close csr_get_asg;

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

204: l_last_year VARCHAR2(4);
205: l_curr_year VARCHAR2(4);
206:
207: BEGIN
208: --hr_utility.trace_on(null,'oracle');
209: /* Get the assignments which have non zero SUI WAGE BASE OVERRIDE AMOUNT */
210: l_curr_year := p_curr_year;
211: hr_utility.trace('l_curr_year '||l_curr_year);
212:

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

207: BEGIN
208: --hr_utility.trace_on(null,'oracle');
209: /* Get the assignments which have non zero SUI WAGE BASE OVERRIDE AMOUNT */
210: l_curr_year := p_curr_year;
211: hr_utility.trace('l_curr_year '||l_curr_year);
212:
213: l_last_year := to_number(l_curr_year) - 1;
214:
215: hr_utility.trace('l_last_year '||l_last_year);

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

211: hr_utility.trace('l_curr_year '||l_curr_year);
212:
213: l_last_year := to_number(l_curr_year) - 1;
214:
215: hr_utility.trace('l_last_year '||l_last_year);
216:
217: l_last_day := to_date('12/31/'||l_last_year,'MM/DD/YYYY');
218: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
219:

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

217: l_last_day := to_date('12/31/'||l_last_year,'MM/DD/YYYY');
218: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
219:
220:
221: hr_utility.trace('l_last_day '||to_char(l_last_day));
222: hr_utility.trace('l_start_day '||to_char(l_start_day));
223:
224: open csr_get_asg(l_start_day , p_business_group);
225:

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

218: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
219:
220:
221: hr_utility.trace('l_last_day '||to_char(l_last_day));
222: hr_utility.trace('l_start_day '||to_char(l_start_day));
223:
224: open csr_get_asg(l_start_day , p_business_group);
225:
226: hr_utility.trace('Updating the state tax records ...');

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

222: hr_utility.trace('l_start_day '||to_char(l_start_day));
223:
224: open csr_get_asg(l_start_day , p_business_group);
225:
226: hr_utility.trace('Updating the state tax records ...');
227:
228: loop
229:
230: fetch csr_get_asg into l_state_rec;

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

230: fetch csr_get_asg into l_state_rec;
231:
232: exit when csr_get_asg%NOTFOUND;
233:
234: hr_utility.trace('Updating Assignment : ' ||
235: to_char(l_state_rec.assignment_id));
236: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
237: hr_utility.trace(to_char(l_state_rec.effective_end_date));
238: hr_utility.trace(to_char( l_state_rec.assignment_id));

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

232: exit when csr_get_asg%NOTFOUND;
233:
234: hr_utility.trace('Updating Assignment : ' ||
235: to_char(l_state_rec.assignment_id));
236: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
237: hr_utility.trace(to_char(l_state_rec.effective_end_date));
238: hr_utility.trace(to_char( l_state_rec.assignment_id));
239: hr_utility.trace(l_state_rec.state_code);
240: hr_utility.trace(l_state_rec.jurisdiction_code);

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

233:
234: hr_utility.trace('Updating Assignment : ' ||
235: to_char(l_state_rec.assignment_id));
236: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
237: hr_utility.trace(to_char(l_state_rec.effective_end_date));
238: hr_utility.trace(to_char( l_state_rec.assignment_id));
239: hr_utility.trace(l_state_rec.state_code);
240: hr_utility.trace(l_state_rec.jurisdiction_code);
241: hr_utility.trace(to_char(l_state_rec.business_group_id));

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

234: hr_utility.trace('Updating Assignment : ' ||
235: to_char(l_state_rec.assignment_id));
236: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
237: hr_utility.trace(to_char(l_state_rec.effective_end_date));
238: hr_utility.trace(to_char( l_state_rec.assignment_id));
239: hr_utility.trace(l_state_rec.state_code);
240: hr_utility.trace(l_state_rec.jurisdiction_code);
241: hr_utility.trace(to_char(l_state_rec.business_group_id));
242: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));

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

235: to_char(l_state_rec.assignment_id));
236: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
237: hr_utility.trace(to_char(l_state_rec.effective_end_date));
238: hr_utility.trace(to_char( l_state_rec.assignment_id));
239: hr_utility.trace(l_state_rec.state_code);
240: hr_utility.trace(l_state_rec.jurisdiction_code);
241: hr_utility.trace(to_char(l_state_rec.business_group_id));
242: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
243: hr_utility.trace( l_state_rec.filing_status_code);

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

236: hr_utility.trace(to_char(l_state_rec.emp_state_tax_rule_id));
237: hr_utility.trace(to_char(l_state_rec.effective_end_date));
238: hr_utility.trace(to_char( l_state_rec.assignment_id));
239: hr_utility.trace(l_state_rec.state_code);
240: hr_utility.trace(l_state_rec.jurisdiction_code);
241: hr_utility.trace(to_char(l_state_rec.business_group_id));
242: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
243: hr_utility.trace( l_state_rec.filing_status_code);
244: hr_utility.trace(to_char( l_state_rec.remainder_percent));

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

237: hr_utility.trace(to_char(l_state_rec.effective_end_date));
238: hr_utility.trace(to_char( l_state_rec.assignment_id));
239: hr_utility.trace(l_state_rec.state_code);
240: hr_utility.trace(l_state_rec.jurisdiction_code);
241: hr_utility.trace(to_char(l_state_rec.business_group_id));
242: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
243: hr_utility.trace( l_state_rec.filing_status_code);
244: hr_utility.trace(to_char( l_state_rec.remainder_percent));
245: hr_utility.trace(to_char( l_state_rec.secondary_wa));

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

238: hr_utility.trace(to_char( l_state_rec.assignment_id));
239: hr_utility.trace(l_state_rec.state_code);
240: hr_utility.trace(l_state_rec.jurisdiction_code);
241: hr_utility.trace(to_char(l_state_rec.business_group_id));
242: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
243: hr_utility.trace( l_state_rec.filing_status_code);
244: hr_utility.trace(to_char( l_state_rec.remainder_percent));
245: hr_utility.trace(to_char( l_state_rec.secondary_wa));
246: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));

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

239: hr_utility.trace(l_state_rec.state_code);
240: hr_utility.trace(l_state_rec.jurisdiction_code);
241: hr_utility.trace(to_char(l_state_rec.business_group_id));
242: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
243: hr_utility.trace( l_state_rec.filing_status_code);
244: hr_utility.trace(to_char( l_state_rec.remainder_percent));
245: hr_utility.trace(to_char( l_state_rec.secondary_wa));
246: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
247: hr_utility.trace(to_char( l_state_rec.sit_override_amount));

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

240: hr_utility.trace(l_state_rec.jurisdiction_code);
241: hr_utility.trace(to_char(l_state_rec.business_group_id));
242: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
243: hr_utility.trace( l_state_rec.filing_status_code);
244: hr_utility.trace(to_char( l_state_rec.remainder_percent));
245: hr_utility.trace(to_char( l_state_rec.secondary_wa));
246: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
247: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
248: hr_utility.trace(to_char( l_state_rec.sit_override_rate));

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

241: hr_utility.trace(to_char(l_state_rec.business_group_id));
242: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
243: hr_utility.trace( l_state_rec.filing_status_code);
244: hr_utility.trace(to_char( l_state_rec.remainder_percent));
245: hr_utility.trace(to_char( l_state_rec.secondary_wa));
246: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
247: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
248: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
249: hr_utility.trace(to_char( l_state_rec.withholding_allowances));

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

242: hr_utility.trace(to_char( l_state_rec.additional_wa_amount));
243: hr_utility.trace( l_state_rec.filing_status_code);
244: hr_utility.trace(to_char( l_state_rec.remainder_percent));
245: hr_utility.trace(to_char( l_state_rec.secondary_wa));
246: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
247: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
248: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
249: hr_utility.trace(to_char( l_state_rec.withholding_allowances));
250:

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

243: hr_utility.trace( l_state_rec.filing_status_code);
244: hr_utility.trace(to_char( l_state_rec.remainder_percent));
245: hr_utility.trace(to_char( l_state_rec.secondary_wa));
246: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
247: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
248: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
249: hr_utility.trace(to_char( l_state_rec.withholding_allowances));
250:
251: /* End date the state tax record as of /12/31/(input year-1) */

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

244: hr_utility.trace(to_char( l_state_rec.remainder_percent));
245: hr_utility.trace(to_char( l_state_rec.secondary_wa));
246: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
247: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
248: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
249: hr_utility.trace(to_char( l_state_rec.withholding_allowances));
250:
251: /* End date the state tax record as of /12/31/(input year-1) */
252:

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

245: hr_utility.trace(to_char( l_state_rec.secondary_wa));
246: hr_utility.trace(to_char( l_state_rec.sit_additional_tax));
247: hr_utility.trace(to_char( l_state_rec.sit_override_amount));
248: hr_utility.trace(to_char( l_state_rec.sit_override_rate));
249: hr_utility.trace(to_char( l_state_rec.withholding_allowances));
250:
251: /* End date the state tax record as of /12/31/(input year-1) */
252:
253:

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

259: and effective_end_date = l_state_rec.effective_end_date
260: and sta_information1 is not null;
261:
262: /* Null out the Indiana EIC as of 01/01/1999 */
263: hr_utility.trace('Inserting Assignment : ' ||to_char(l_state_rec.assignment_id));
264:
265: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
266:
267: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));

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

261:
262: /* Null out the Indiana EIC as of 01/01/1999 */
263: hr_utility.trace('Inserting Assignment : ' ||to_char(l_state_rec.assignment_id));
264:
265: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
266:
267: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));
268:
269: insert into PAY_US_EMP_STATE_TAX_RULES_F

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

263: hr_utility.trace('Inserting Assignment : ' ||to_char(l_state_rec.assignment_id));
264:
265: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
266:
267: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_state_rec.effective_end_date));
268:
269: insert into PAY_US_EMP_STATE_TAX_RULES_F
270: (
271: EMP_STATE_TAX_RULE_ID,

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

453: l_state_rec.STA_INFORMATION28 ,
454: l_state_rec.STA_INFORMATION29 ,
455: l_state_rec.STA_INFORMATION30 ) ;
456:
457: hr_utility.trace('Updated Assignment : ' ||
458: to_char(l_state_rec.assignment_id));
459: commit;
460: end loop;
461: close csr_get_asg;

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

488: l_last_year VARCHAR2(4);
489: l_curr_year VARCHAR2(4);
490:
491: BEGIN
492: --hr_utility.trace_on(null,'oracle');
493: /* Get the assignments which have PA head Tax Exemption */
494: l_curr_year := p_curr_year;
495: hr_utility.trace('l_curr_year '||l_curr_year);
496:

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

491: BEGIN
492: --hr_utility.trace_on(null,'oracle');
493: /* Get the assignments which have PA head Tax Exemption */
494: l_curr_year := p_curr_year;
495: hr_utility.trace('l_curr_year '||l_curr_year);
496:
497: l_last_year := to_number(l_curr_year) - 1;
498:
499: hr_utility.trace('l_last_year '||l_last_year);

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

495: hr_utility.trace('l_curr_year '||l_curr_year);
496:
497: l_last_year := to_number(l_curr_year) - 1;
498:
499: hr_utility.trace('l_last_year '||l_last_year);
500:
501: l_last_day := to_date('12/31/'||l_last_year,'MM/DD/YYYY');
502: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
503:

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

501: l_last_day := to_date('12/31/'||l_last_year,'MM/DD/YYYY');
502: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
503:
504:
505: hr_utility.trace('l_last_day '||to_char(l_last_day));
506: hr_utility.trace('l_start_day '||to_char(l_start_day));
507:
508: open csr_get_asg(l_start_day , p_business_group);
509:

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

502: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
503:
504:
505: hr_utility.trace('l_last_day '||to_char(l_last_day));
506: hr_utility.trace('l_start_day '||to_char(l_start_day));
507:
508: open csr_get_asg(l_start_day , p_business_group);
509:
510: hr_utility.trace('Updating the city tax records ...');

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

506: hr_utility.trace('l_start_day '||to_char(l_start_day));
507:
508: open csr_get_asg(l_start_day , p_business_group);
509:
510: hr_utility.trace('Updating the city tax records ...');
511:
512: loop
513:
514: fetch csr_get_asg into l_city_rec;

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

526: and effective_end_date = l_city_rec.effective_end_date
527: and ht_exempt is not null;
528:
529: /* Null out the PA Head Tax exemption as of 01/01/1999 */
530: hr_utility.trace('Inserting Assignment : ' ||to_char(l_city_rec.assignment_id));
531:
532: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
533:
534: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_city_rec.effective_end_date));

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

528:
529: /* Null out the PA Head Tax exemption as of 01/01/1999 */
530: hr_utility.trace('Inserting Assignment : ' ||to_char(l_city_rec.assignment_id));
531:
532: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
533:
534: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_city_rec.effective_end_date));
535:
536:

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

530: hr_utility.trace('Inserting Assignment : ' ||to_char(l_city_rec.assignment_id));
531:
532: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
533:
534: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_city_rec.effective_end_date));
535:
536:
537:
538: insert into PAY_US_EMP_CITY_TAX_RULES_F

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

716: l_city_rec.CTY_INFORMATION30
717: );
718:
719:
720: hr_utility.trace('Updated Assignment : ' ||
721: to_char(l_city_rec.assignment_id));
722: commit;
723: end loop;
724: close csr_get_asg;

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

748: l_last_year VARCHAR2(4);
749: l_curr_year VARCHAR2(4);
750:
751: BEGIN
752: --hr_utility.trace_on(null,'oracle');
753: /* Get the assignments which have Fed EIC */
754: l_curr_year := p_curr_year;
755: hr_utility.trace('l_curr_year '||l_curr_year);
756:

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

751: BEGIN
752: --hr_utility.trace_on(null,'oracle');
753: /* Get the assignments which have Fed EIC */
754: l_curr_year := p_curr_year;
755: hr_utility.trace('l_curr_year '||l_curr_year);
756:
757: l_last_year := to_number(l_curr_year) - 1;
758:
759: hr_utility.trace('l_last_year '||l_last_year);

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

755: hr_utility.trace('l_curr_year '||l_curr_year);
756:
757: l_last_year := to_number(l_curr_year) - 1;
758:
759: hr_utility.trace('l_last_year '||l_last_year);
760:
761: l_last_day := to_date('12/31/'||l_last_year,'MM/DD/YYYY');
762: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
763:

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

761: l_last_day := to_date('12/31/'||l_last_year,'MM/DD/YYYY');
762: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
763:
764:
765: hr_utility.trace('l_last_day '||to_char(l_last_day));
766: hr_utility.trace('l_start_day '||to_char(l_start_day));
767:
768: open csr_get_asg(l_start_day , p_business_group);
769:

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

762: l_start_day := to_date('01/01/'||l_curr_year,'MM/DD/YYYY');
763:
764:
765: hr_utility.trace('l_last_day '||to_char(l_last_day));
766: hr_utility.trace('l_start_day '||to_char(l_start_day));
767:
768: open csr_get_asg(l_start_day , p_business_group);
769:
770: hr_utility.trace('Updating the fed tax records ...');

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

766: hr_utility.trace('l_start_day '||to_char(l_start_day));
767:
768: open csr_get_asg(l_start_day , p_business_group);
769:
770: hr_utility.trace('Updating the fed tax records ...');
771:
772: loop
773:
774: fetch csr_get_asg into l_fed_rec;

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

785: and effective_end_date = l_fed_rec.effective_end_date
786: and eic_filing_status_code <> 0;
787:
788: /* Null out the FED EIC of 01/01/1999 */
789: hr_utility.trace('Inserting Assignment : ' ||to_char(l_fed_rec.assignment_id));
790:
791: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
792:
793: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_fed_rec.effective_end_date));

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

787:
788: /* Null out the FED EIC of 01/01/1999 */
789: hr_utility.trace('Inserting Assignment : ' ||to_char(l_fed_rec.assignment_id));
790:
791: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
792:
793: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_fed_rec.effective_end_date));
794:
795:

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

789: hr_utility.trace('Inserting Assignment : ' ||to_char(l_fed_rec.assignment_id));
790:
791: hr_utility.trace('Inserting Assignment Start Date : ' ||to_char(l_start_day));
792:
793: hr_utility.trace('Inserting Assignment End Date : ' ||to_char(l_fed_rec.effective_end_date));
794:
795:
796:
797: /* Insert Stmt for FED Tax Rules will come here */

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

984: l_fed_rec.FED_INFORMATION30
985: );
986:
987:
988: hr_utility.trace('Updated Assignment : ' ||
989: to_char(l_fed_rec.assignment_id));
990: commit;
991: end loop;
992: close csr_get_asg;

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

1006: )
1007: IS
1008:
1009: BEGIN
1010: --hr_utility.trace_on(null,'ORACLE');
1011: 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);
1012:
1013:
1014: /* Clear the Indiana Override Adderess/Location */

Line 1011: 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);

1007: IS
1008:
1009: BEGIN
1010: --hr_utility.trace_on(null,'ORACLE');
1011: 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);
1012:
1013:
1014: /* Clear the Indiana Override Adderess/Location */
1015: IF p_clr_ind_add_ovr = 'Y' THEN

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

1018: /* End Indiana Override Address /Location */
1019:
1020: /* Clear Indiana EIC */
1021: IF p_clr_ind_eic = 'Y' THEN
1022: hr_utility.trace('Procedure ind_eic_ovr');
1023: ind_eic_ovr(p_business_group,p_curr_year);
1024: END IF;
1025: /* End Indiana EIC */
1026:

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

1026:
1027:
1028: /* Clear SUI Wage Base Override */
1029: IF p_clr_sui_wb_ovr = 'Y' THEN
1030: hr_utility.trace('Procedure sui_wb_ovr');
1031: sui_wb_ovr(p_business_group,p_curr_year);
1032: END IF;
1033: /* End SUI Wage Base Override */
1034:

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

1034:
1035:
1036: /*Clear PA Head tax exempt */
1037: IF p_clr_pa_head_tax ='Y' THEN
1038: hr_utility.trace('Procedure pa_head_tx_ovr');
1039: pa_head_tx_ovr(p_business_group,p_curr_year);
1040: END IF;
1041: /* End PS head tax exempt */
1042:

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

1042:
1043:
1044: /* Clear Federal EIC Filing status */
1045: IF p_clr_fed_eic_filing_status = 'Y' THEN
1046: hr_utility.trace('Procedure fed_eic_filing_status_ovr');
1047: fed_eic_filing_status_ovr(p_business_group,p_curr_year);
1048: END IF;
1049: /* End EIC filing status*/
1050: