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

Line 67: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);

63: lv_procedure_name VARCHAR2(100);
64:
65: BEGIN
66: lv_procedure_name := '.insert_retro_comp_usages';
67: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
68:
69: select pay_retro_component_usages_s.nextval
70: into ln_retro_component_usage_id
71: from dual;

Line 88: hr_utility.trace('p_retro_comp_usage_id= ' || p_retro_comp_usage_id);

84: AND creator_id = p_creator_id
85: AND creator_type = 'ET'); /* 7138282 */
86:
87: p_retro_comp_usage_id := ln_retro_component_usage_id;
88: hr_utility.trace('p_retro_comp_usage_id= ' || p_retro_comp_usage_id);
89: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
90:
91: exception
92: when others then

Line 89: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);

85: AND creator_type = 'ET'); /* 7138282 */
86:
87: p_retro_comp_usage_id := ln_retro_component_usage_id;
88: hr_utility.trace('p_retro_comp_usage_id= ' || p_retro_comp_usage_id);
89: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
90:
91: exception
92: when others then
93: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

Line 93: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

89: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
90:
91: exception
92: when others then
93: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
94: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
95: raise;
96: END insert_retro_comp_usages;
97:

Line 94: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

90:
91: exception
92: when others then
93: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
94: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
95: raise;
96: END insert_retro_comp_usages;
97:
98:

Line 111: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);

107: lv_procedure_name VARCHAR2(100);
108:
109: BEGIN
110: lv_procedure_name := '.insert_element_span_usages';
111: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
112:
113: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
114: -- hr_utility.trace('p_legcd ='|| p_legislation_code);
115: hr_utility.trace('p_time_span_id ='|| p_time_span_id);

Line 113: hr_utility.trace('p_business_group_id ='|| p_business_group_id);

109: BEGIN
110: lv_procedure_name := '.insert_element_span_usages';
111: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
112:
113: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
114: -- hr_utility.trace('p_legcd ='|| p_legislation_code);
115: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
116: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
117: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);

Line 114: -- hr_utility.trace('p_legcd ='|| p_legislation_code);

110: lv_procedure_name := '.insert_element_span_usages';
111: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
112:
113: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
114: -- hr_utility.trace('p_legcd ='|| p_legislation_code);
115: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
116: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
117: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);
118:

Line 115: hr_utility.trace('p_time_span_id ='|| p_time_span_id);

111: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
112:
113: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
114: -- hr_utility.trace('p_legcd ='|| p_legislation_code);
115: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
116: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
117: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);
118:
119: insert into pay_element_span_usages

Line 116: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);

112:
113: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
114: -- hr_utility.trace('p_legcd ='|| p_legislation_code);
115: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
116: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
117: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);
118:
119: insert into pay_element_span_usages
120: (element_span_usage_id, business_group_id, time_span_id,

Line 117: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);

113: hr_utility.trace('p_business_group_id ='|| p_business_group_id);
114: -- hr_utility.trace('p_legcd ='|| p_legislation_code);
115: hr_utility.trace('p_time_span_id ='|| p_time_span_id);
116: hr_utility.trace('p_retro_comp_usage_id ='|| p_retro_comp_usage_id);
117: hr_utility.trace('p_retro_element_type_id ='|| p_retro_element_type_id);
118:
119: insert into pay_element_span_usages
120: (element_span_usage_id, business_group_id, time_span_id,
121: retro_component_usage_id, retro_element_type_id,

Line 134: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);

130: AND pesu.legislation_code IS NULL
131: AND pesu.time_span_id = p_time_span_id
132: AND retro_component_usage_id = p_retro_comp_usage_id); /* 7138282 */
133:
134: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
135:
136: exception
137: when others then
138: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

Line 138: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

134: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
135:
136: exception
137: when others then
138: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
139: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
140: raise;
141: END insert_element_span_usages;
142:

Line 139: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

135:
136: exception
137: when others then
138: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
139: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
140: raise;
141: END insert_element_span_usages;
142:
143:

Line 223: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);

219:
220: BEGIN
221:
222: lv_procedure_name := '.qualify_element';
223: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
224: lv_qualified := 'N';
225: lv_legislation_code := null;
226: ln_business_group_id := null;
227: ln_classification_id := null;

Line 271: hr_utility.trace('Element Set ID ' || ln_element_set_id);

267: if c_element_set%notfound then
268: exit;
269: end if;
270:
271: hr_utility.trace('Element Set ID ' || ln_element_set_id);
272: open c_element_check(ln_element_set_id);
273: fetch c_element_check into ln_element_used;
274: if c_element_check%found then
275: lv_qualified := 'Y';

Line 276: hr_utility.trace('UPGRADE Element ' || lv_element_name ||

272: open c_element_check(ln_element_set_id);
273: fetch c_element_check into ln_element_used;
274: if c_element_check%found then
275: lv_qualified := 'Y';
276: hr_utility.trace('UPGRADE Element ' || lv_element_name ||
277: '(' || p_object_id || ')');
278: exit;
279: else
280: lv_qualified := 'N';

Line 281: hr_utility.trace('Element ' || lv_element_name ||

277: '(' || p_object_id || ')');
278: exit;
279: else
280: lv_qualified := 'N';
281: hr_utility.trace('Element ' || lv_element_name ||
282: '(' || p_object_id || ') does not need to be upgraded');
283: end if;
284: close c_element_check;
285: end loop;

Line 289: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);

285: end loop;
286: close c_element_set;
287:
288: p_qualified := lv_qualified;
289: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
290:
291: exception
292: when others then
293: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

Line 293: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

289: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
290:
291: exception
292: when others then
293: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
294: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
295: raise;
296: END qualify_element;
297:

Line 294: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

290:
291: exception
292: when others then
293: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
294: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
295: raise;
296: END qualify_element;
297:
298:

Line 380: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);

376:
377: ltt_business_group numeric_data_table;
378: BEGIN
379: lv_procedure_name := '.upgrade_element';
380: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
381:
382: hr_utility.set_location(gv_package_name || lv_procedure_name, 30);
383: open c_element_dtl(p_element_type_id);
384: fetch c_element_dtl into ln_ele_business_group_id, ln_legislation_code,

Line 382: hr_utility.set_location(gv_package_name || lv_procedure_name, 30);

378: BEGIN
379: lv_procedure_name := '.upgrade_element';
380: hr_utility.trace('Entering ' || gv_package_name || lv_procedure_name);
381:
382: hr_utility.set_location(gv_package_name || lv_procedure_name, 30);
383: open c_element_dtl(p_element_type_id);
384: fetch c_element_dtl into ln_ele_business_group_id, ln_legislation_code,
385: ln_classification_id, ln_retro_element_type_id,
386: lv_element_name;

Line 388: hr_utility.trace('p_element_type_id ='|| p_element_type_id);

384: fetch c_element_dtl into ln_ele_business_group_id, ln_legislation_code,
385: ln_classification_id, ln_retro_element_type_id,
386: lv_element_name;
387: close c_element_dtl;
388: hr_utility.trace('p_element_type_id ='|| p_element_type_id);
389: hr_utility.trace('lv_element_name ='|| lv_element_name);
390: hr_utility.trace('ln_legislation_code ='|| ln_legislation_code);
391: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
392: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);

Line 389: hr_utility.trace('lv_element_name ='|| lv_element_name);

385: ln_classification_id, ln_retro_element_type_id,
386: lv_element_name;
387: close c_element_dtl;
388: hr_utility.trace('p_element_type_id ='|| p_element_type_id);
389: hr_utility.trace('lv_element_name ='|| lv_element_name);
390: hr_utility.trace('ln_legislation_code ='|| ln_legislation_code);
391: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
392: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
393:

Line 390: hr_utility.trace('ln_legislation_code ='|| ln_legislation_code);

386: lv_element_name;
387: close c_element_dtl;
388: hr_utility.trace('p_element_type_id ='|| p_element_type_id);
389: hr_utility.trace('lv_element_name ='|| lv_element_name);
390: hr_utility.trace('ln_legislation_code ='|| ln_legislation_code);
391: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
392: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
393:
394: if ln_legislation_code is null and

Line 391: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);

387: close c_element_dtl;
388: hr_utility.trace('p_element_type_id ='|| p_element_type_id);
389: hr_utility.trace('lv_element_name ='|| lv_element_name);
390: hr_utility.trace('ln_legislation_code ='|| ln_legislation_code);
391: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
392: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
393:
394: if ln_legislation_code is null and
395: ln_ele_business_group_id is not null then

Line 392: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);

388: hr_utility.trace('p_element_type_id ='|| p_element_type_id);
389: hr_utility.trace('lv_element_name ='|| lv_element_name);
390: hr_utility.trace('ln_legislation_code ='|| ln_legislation_code);
391: hr_utility.trace('ln_ele_business_group_id ='|| ln_ele_business_group_id);
392: hr_utility.trace('ln_retro_element_type_id ='|| ln_retro_element_type_id);
393:
394: if ln_legislation_code is null and
395: ln_ele_business_group_id is not null then
396: open c_legislation_code(ln_ele_business_group_id);

Line 402: hr_utility.trace('lv_legislation_code ='|| lv_legislation_code);

398: close c_legislation_code;
399: else
400: lv_legislation_code := ln_legislation_code;
401: end if;
402: hr_utility.trace('lv_legislation_code ='|| lv_legislation_code);
403:
404: if gn_retro_component_id is null then
405: hr_utility.trace('getting gn_retro_component_id ='|| gn_retro_component_id);
406: hr_utility.set_location(gv_package_name || lv_procedure_name, 20);

Line 405: hr_utility.trace('getting gn_retro_component_id ='|| gn_retro_component_id);

401: end if;
402: hr_utility.trace('lv_legislation_code ='|| lv_legislation_code);
403:
404: if gn_retro_component_id is null then
405: hr_utility.trace('getting gn_retro_component_id ='|| gn_retro_component_id);
406: hr_utility.set_location(gv_package_name || lv_procedure_name, 20);
407: open c_retro_info(lv_legislation_code);
408: fetch c_retro_info into gn_retro_component_id
409: ,gn_time_span_id;

Line 406: hr_utility.set_location(gv_package_name || lv_procedure_name, 20);

402: hr_utility.trace('lv_legislation_code ='|| lv_legislation_code);
403:
404: if gn_retro_component_id is null then
405: hr_utility.trace('getting gn_retro_component_id ='|| gn_retro_component_id);
406: hr_utility.set_location(gv_package_name || lv_procedure_name, 20);
407: open c_retro_info(lv_legislation_code);
408: fetch c_retro_info into gn_retro_component_id
409: ,gn_time_span_id;
410: close c_retro_info;

Line 412: hr_utility.trace('gn_retro_component_id ='|| gn_retro_component_id);

408: fetch c_retro_info into gn_retro_component_id
409: ,gn_time_span_id;
410: close c_retro_info;
411: end if;
412: hr_utility.trace('gn_retro_component_id ='|| gn_retro_component_id);
413: hr_utility.trace('gn_time_span_id ='|| gn_time_span_id);
414:
415: hr_utility.set_location(gv_package_name || lv_procedure_name, 40);
416:

Line 413: hr_utility.trace('gn_time_span_id ='|| gn_time_span_id);

409: ,gn_time_span_id;
410: close c_retro_info;
411: end if;
412: hr_utility.trace('gn_retro_component_id ='|| gn_retro_component_id);
413: hr_utility.trace('gn_time_span_id ='|| gn_time_span_id);
414:
415: hr_utility.set_location(gv_package_name || lv_procedure_name, 40);
416:
417: if ln_legislation_code is not null and

Line 415: hr_utility.set_location(gv_package_name || lv_procedure_name, 40);

411: end if;
412: hr_utility.trace('gn_retro_component_id ='|| gn_retro_component_id);
413: hr_utility.trace('gn_time_span_id ='|| gn_time_span_id);
414:
415: hr_utility.set_location(gv_package_name || lv_procedure_name, 40);
416:
417: if ln_legislation_code is not null and
418: ln_ele_business_group_id is null then
419:

Line 420: hr_utility.trace('Seeded Element');

416:
417: if ln_legislation_code is not null and
418: ln_ele_business_group_id is null then
419:
420: hr_utility.trace('Seeded Element');
421: hr_utility.set_location(gv_package_name || lv_procedure_name, 60);
422: insert_retro_comp_usages
423: (p_business_group_id => null
424: ,p_legislation_code => ln_legislation_code

Line 421: hr_utility.set_location(gv_package_name || lv_procedure_name, 60);

417: if ln_legislation_code is not null and
418: ln_ele_business_group_id is null then
419:
420: hr_utility.trace('Seeded Element');
421: hr_utility.set_location(gv_package_name || lv_procedure_name, 60);
422: insert_retro_comp_usages
423: (p_business_group_id => null
424: ,p_legislation_code => ln_legislation_code
425: ,p_retro_component_id => gn_retro_component_id

Line 429: hr_utility.set_location(gv_package_name || lv_procedure_name, 70);

425: ,p_retro_component_id => gn_retro_component_id
426: ,p_creator_id => p_element_type_id
427: ,p_retro_comp_usage_id => ln_retro_comp_usage_id);
428:
429: hr_utility.set_location(gv_package_name || lv_procedure_name, 70);
430: open c_element_set(p_element_type_id, ln_classification_id,ln_legislation_code);
431: loop
432: fetch c_element_set into ln_element_set_id;
433: if c_element_set%notfound then

Line 434: hr_utility.set_location(gv_package_name || lv_procedure_name, 99999);

430: open c_element_set(p_element_type_id, ln_classification_id,ln_legislation_code);
431: loop
432: fetch c_element_set into ln_element_set_id;
433: if c_element_set%notfound then
434: hr_utility.set_location(gv_package_name || lv_procedure_name, 99999);
435: exit;
436: end if;
437:
438: open c_get_business_group(ln_element_set_id,ln_legislation_code);

Line 442: hr_utility.set_location(gv_package_name || lv_procedure_name, 8888);

438: open c_get_business_group(ln_element_set_id,ln_legislation_code);
439: loop
440: fetch c_get_business_group into ln_business_group_id;
441: if c_get_business_group%notfound then
442: hr_utility.set_location(gv_package_name || lv_procedure_name, 8888);
443: exit;
444: end if;
445:
446: -- ln_count := ltt_business_group.count;

Line 449: hr_utility.trace('ln_business_group_id ='|| ln_business_group_id);

445:
446: -- ln_count := ltt_business_group.count;
447: -- ltt_business_group(ln_count) := ln_business_group_id;
448:
449: hr_utility.trace('ln_business_group_id ='|| ln_business_group_id);
450: hr_utility.set_location(gv_package_name || lv_procedure_name, 80);
451:
452: insert_element_span_usages
453: (p_business_group_id => ln_business_group_id

Line 450: hr_utility.set_location(gv_package_name || lv_procedure_name, 80);

446: -- ln_count := ltt_business_group.count;
447: -- ltt_business_group(ln_count) := ln_business_group_id;
448:
449: hr_utility.trace('ln_business_group_id ='|| ln_business_group_id);
450: hr_utility.set_location(gv_package_name || lv_procedure_name, 80);
451:
452: insert_element_span_usages
453: (p_business_group_id => ln_business_group_id
454: ,p_retro_element_type_id => ln_retro_element_type_id

Line 459: hr_utility.set_location(gv_package_name || lv_procedure_name, 90);

455: ,p_legislation_code => ln_legislation_code
456: ,p_time_span_id => gn_time_span_id
457: ,p_retro_comp_usage_id => ln_retro_comp_usage_id);
458:
459: hr_utility.set_location(gv_package_name || lv_procedure_name, 90);
460: end loop;
461: close c_get_business_group;
462: end loop;
463: close c_element_set;

Line 465: hr_utility.set_location(gv_package_name || lv_procedure_name, 100);

461: close c_get_business_group;
462: end loop;
463: close c_element_set;
464: end if;
465: hr_utility.set_location(gv_package_name || lv_procedure_name, 100);
466:
467: if ln_legislation_code is null and
468: ln_ele_business_group_id is not null then
469:

Line 470: hr_utility.trace('Custom Element');

466:
467: if ln_legislation_code is null and
468: ln_ele_business_group_id is not null then
469:
470: hr_utility.trace('Custom Element');
471: hr_utility.set_location(gv_package_name || lv_procedure_name, 110);
472: insert_retro_comp_usages
473: (p_business_group_id => ln_ele_business_group_id
474: ,p_legislation_code => null

Line 471: hr_utility.set_location(gv_package_name || lv_procedure_name, 110);

467: if ln_legislation_code is null and
468: ln_ele_business_group_id is not null then
469:
470: hr_utility.trace('Custom Element');
471: hr_utility.set_location(gv_package_name || lv_procedure_name, 110);
472: insert_retro_comp_usages
473: (p_business_group_id => ln_ele_business_group_id
474: ,p_legislation_code => null
475: ,p_retro_component_id => gn_retro_component_id

Line 478: hr_utility.set_location(gv_package_name || lv_procedure_name, 120);

474: ,p_legislation_code => null
475: ,p_retro_component_id => gn_retro_component_id
476: ,p_creator_id => p_element_type_id
477: ,p_retro_comp_usage_id => ln_retro_comp_usage_id);
478: hr_utility.set_location(gv_package_name || lv_procedure_name, 120);
479: insert_element_span_usages
480: (p_business_group_id => ln_ele_business_group_id
481: ,p_retro_element_type_id => ln_retro_element_type_id
482: ,p_legislation_code => null

Line 487: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);

483: ,p_time_span_id => gn_time_span_id
484: ,p_retro_comp_usage_id => ln_retro_comp_usage_id);
485: end if;
486:
487: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
488: exception
489: when others then
490: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
491: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

Line 490: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);

486:
487: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
488: exception
489: when others then
490: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
491: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
492: raise;
493: END upgrade_element;
494:

Line 491: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));

487: hr_utility.trace('Leaving ' || gv_package_name || lv_procedure_name);
488: exception
489: when others then
490: hr_utility.set_location(gv_package_name || lv_procedure_name, 200);
491: hr_utility.trace('ERROR:' || sqlcode ||'-'|| substr(sqlerrm,1,80));
492: raise;
493: END upgrade_element;
494:
495: BEGIN

Line 496: -- hr_utility.trace_on(null, 'US_RETRO_UPG');

492: raise;
493: END upgrade_element;
494:
495: BEGIN
496: -- hr_utility.trace_on(null, 'US_RETRO_UPG');
497: gv_package_name := 'pay_us_retro_upgrade';
498:
499: END pay_us_retro_upgrade;