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

Line 82: hr_utility.set_location(l_proc, 10);

78:
79: begin
80:
81: l_proc := gv_package_name||'range_cursor';
82: hr_utility.set_location(l_proc, 10);
83:
84: hr_utility.trace('PACTID = '||to_char(pactid));
85: select ppa.legislative_parameters
86: into lv_legislative_param

Line 84: hr_utility.trace('PACTID = '||to_char(pactid));

80:
81: l_proc := gv_package_name||'range_cursor';
82: hr_utility.set_location(l_proc, 10);
83:
84: hr_utility.trace('PACTID = '||to_char(pactid));
85: select ppa.legislative_parameters
86: into lv_legislative_param
87: from pay_payroll_actions ppa
88: where payroll_action_id = pactid;

Line 105: hr_utility.set_location(l_proc, 20);

101: and PAA.tax_unit_id=hoi.organization_id
102: )';
103:
104: end if;
105: hr_utility.set_location(l_proc, 20);
106: hr_utility.trace(sqlstr);
107:
108: exception when others then
109: hr_utility.set_location(l_proc, 30);

Line 106: hr_utility.trace(sqlstr);

102: )';
103:
104: end if;
105: hr_utility.set_location(l_proc, 20);
106: hr_utility.trace(sqlstr);
107:
108: exception when others then
109: hr_utility.set_location(l_proc, 30);
110: end range_cursor;

Line 109: hr_utility.set_location(l_proc, 30);

105: hr_utility.set_location(l_proc, 20);
106: hr_utility.trace(sqlstr);
107:
108: exception when others then
109: hr_utility.set_location(l_proc, 30);
110: end range_cursor;
111: ---------------------------------- action_creation -----------------------------------
112: PROCEDURE action_creation(pactid IN NUMBER,
113: stperson IN NUMBER,

Line 129: hr_utility.set_location(l_proc, 10);

125: l_pre_organization_id VARCHAR2(50);
126:
127: BEGIN
128: l_proc := gv_package_name||'action_creation';
129: hr_utility.set_location(l_proc, 10);
130: hr_utility.trace('PACTID = '||to_char(pactid));
131: SELECT effective_date,
132: pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters),
133: pay_core_utils.get_parameter('TRANSFER_PRE',legislative_parameters),

Line 130: hr_utility.trace('PACTID = '||to_char(pactid));

126:
127: BEGIN
128: l_proc := gv_package_name||'action_creation';
129: hr_utility.set_location(l_proc, 10);
130: hr_utility.trace('PACTID = '||to_char(pactid));
131: SELECT effective_date,
132: pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters),
133: pay_core_utils.get_parameter('TRANSFER_PRE',legislative_parameters),
134: pay_core_utils.get_parameter('REPORT_TYPE',legislative_parameters)

Line 143: hr_utility.trace('year start new '|| to_char(ld_year_start,'dd-mm-yyyy'));

139: FROM pay_payroll_actions
140: WHERE payroll_action_id = pactid;
141:
142: ld_year_start := trunc(ld_effective_date, 'Y');
143: hr_utility.trace('year start new '|| to_char(ld_year_start,'dd-mm-yyyy'));
144:
145: ld_year_end := add_months(trunc(ld_effective_date, 'Y'),12) -1;
146: hr_utility.trace('year end '|| to_char(ld_year_end,'dd-mm-yyyy'));
147:

Line 146: hr_utility.trace('year end '|| to_char(ld_year_end,'dd-mm-yyyy'));

142: ld_year_start := trunc(ld_effective_date, 'Y');
143: hr_utility.trace('year start new '|| to_char(ld_year_start,'dd-mm-yyyy'));
144:
145: ld_year_end := add_months(trunc(ld_effective_date, 'Y'),12) -1;
146: hr_utility.trace('year end '|| to_char(ld_year_end,'dd-mm-yyyy'));
147:
148: if (ln_tax_unit_id is not null) then
149: sqlstr := 'AND PAA.tax_unit_id = '||to_number(ln_tax_unit_id);
150: elsif (l_pre_organization_id is not null) then

Line 192: hr_utility.set_location(l_proc, 20);

188: and fc.context_name = ''JURISDICTION_CODE''
189: and pac.context_value = ''QC'') ';
190: end if;
191: */
192: hr_utility.set_location(l_proc, 20);
193: hr_utility.trace(sqlstr);
194:
195: EXCEPTION WHEN OTHERS THEN
196: hr_utility.set_location(l_proc, 30);

Line 193: hr_utility.trace(sqlstr);

189: and pac.context_value = ''QC'') ';
190: end if;
191: */
192: hr_utility.set_location(l_proc, 20);
193: hr_utility.trace(sqlstr);
194:
195: EXCEPTION WHEN OTHERS THEN
196: hr_utility.set_location(l_proc, 30);
197: END action_creation;

Line 196: hr_utility.set_location(l_proc, 30);

192: hr_utility.set_location(l_proc, 20);
193: hr_utility.trace(sqlstr);
194:
195: EXCEPTION WHEN OTHERS THEN
196: hr_utility.set_location(l_proc, 30);
197: END action_creation;
198:
199: PROCEDURE archive_code (pactid IN NUMBER,
200: sqlstr OUT NOCOPY VARCHAR2) IS

Line 216: hr_utility.set_location(l_proc, 10);

212: -- fix for bug 7518875 ends here.
213:
214: BEGIN
215: l_proc := gv_package_name||'archive_code';
216: hr_utility.set_location(l_proc, 10);
217:
218: hr_utility.trace('PACTID = '||to_char(pactid));
219: select ppa.legislative_parameters
220: into lv_legislative_param

Line 218: hr_utility.trace('PACTID = '||to_char(pactid));

214: BEGIN
215: l_proc := gv_package_name||'archive_code';
216: hr_utility.set_location(l_proc, 10);
217:
218: hr_utility.trace('PACTID = '||to_char(pactid));
219: select ppa.legislative_parameters
220: into lv_legislative_param
221: from pay_payroll_actions ppa
222: where payroll_action_id = pactid;

Line 236: hr_utility.trace('year start new '|| to_char(ld_year_start,'dd-mm-yyyy'));

232: FROM pay_payroll_actions
233: WHERE payroll_action_id = pactid;
234:
235: ld_year_start := trunc(ld_effective_date, 'Y');
236: hr_utility.trace('year start new '|| to_char(ld_year_start,'dd-mm-yyyy'));
237:
238: ld_year_end := add_months(trunc(ld_effective_date, 'Y'),12) -1;
239: hr_utility.trace('year end '|| to_char(ld_year_end,'dd-mm-yyyy'));
240:

Line 239: hr_utility.trace('year end '|| to_char(ld_year_end,'dd-mm-yyyy'));

235: ld_year_start := trunc(ld_effective_date, 'Y');
236: hr_utility.trace('year start new '|| to_char(ld_year_start,'dd-mm-yyyy'));
237:
238: ld_year_end := add_months(trunc(ld_effective_date, 'Y'),12) -1;
239: hr_utility.trace('year end '|| to_char(ld_year_end,'dd-mm-yyyy'));
240:
241: -- fix for bug 7518875 ends here.
242:
243: if (l_gre_id is not null) then

Line 273: hr_utility.set_location(l_proc, 20);

269: end if;
270:
271: -- fix for bug 7518875 ends here.
272:
273: hr_utility.set_location(l_proc, 20);
274: hr_utility.trace(sqlstr);
275:
276: EXCEPTION WHEN OTHERS THEN
277: hr_utility.set_location(l_proc, 30);

Line 274: hr_utility.trace(sqlstr);

270:
271: -- fix for bug 7518875 ends here.
272:
273: hr_utility.set_location(l_proc, 20);
274: hr_utility.trace(sqlstr);
275:
276: EXCEPTION WHEN OTHERS THEN
277: hr_utility.set_location(l_proc, 30);
278: END archive_code;

Line 277: hr_utility.set_location(l_proc, 30);

273: hr_utility.set_location(l_proc, 20);
274: hr_utility.trace(sqlstr);
275:
276: EXCEPTION WHEN OTHERS THEN
277: hr_utility.set_location(l_proc, 30);
278: END archive_code;
279:
280: --begin
281: --hr_utility.trace_on(null,'YREND_YEMA');

Line 281: --hr_utility.trace_on(null,'YREND_YEMA');

277: hr_utility.set_location(l_proc, 30);
278: END archive_code;
279:
280: --begin
281: --hr_utility.trace_on(null,'YREND_YEMA');
282:
283: END PAY_CA_ARCHIVE_RULES;