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_GEO_UPD_PKG dependencies on PAY_PATCH_STATUS

Line 58: ln_upgrade_patch pay_patch_status.patch_name%TYPE;

54:
55: leg_param pay_payroll_actions.legislative_parameters%type;
56: l_year varchar2(4);
57:
58: ln_upgrade_patch pay_patch_status.patch_name%TYPE;
59: --
60: begin
61:
62: hr_utility.trace('reached range_cursor');

Line 104: l_patch_name pay_patch_status.patch_name%TYPE;

100: l_year varchar2(4);
101: l_geo_phase_id number;
102: l_mode Pay_Payroll_actions.legislative_parameters%type;
103:
104: l_patch_name pay_patch_status.patch_name%TYPE;
105:
106:
107:
108:

Line 177: from pay_patch_status

173:
174: cursor c_get_phase_id (p_patch_name varchar2)
175: is
176: select ID
177: from pay_patch_status
178: where patch_name = p_patch_name
179: and status in ('P','E');
180:
181: Cursor c_geo_check (p_patch_name in varchar2) is

Line 182: select phase, status from pay_patch_status

178: where patch_name = p_patch_name
179: and status in ('P','E');
180:
181: Cursor c_geo_check (p_patch_name in varchar2) is
182: select phase, status from pay_patch_status
183: where patch_name like p_patch_name || '%'
184: and legislation_code = 'US';
185:
186: l_assignment_id number;

Line 227: pay_patch_status table.

223: hr_utility.trace('c_geo_check not found chunk = 1');
224: /*
225: If both conditions above are true, there is a geocode update
226: underway and a row for this process needs to be added to the
227: pay_patch_status table.
228: */
229: hr_utility.trace('inserting into pay_patch_status ');
230: insert into pay_patch_status
231: (ID,

Line 229: hr_utility.trace('inserting into pay_patch_status ');

225: If both conditions above are true, there is a geocode update
226: underway and a row for this process needs to be added to the
227: pay_patch_status table.
228: */
229: hr_utility.trace('inserting into pay_patch_status ');
230: insert into pay_patch_status
231: (ID,
232: PATCH_NUMBER,
233: PATCH_NAME,

Line 230: insert into pay_patch_status

226: underway and a row for this process needs to be added to the
227: pay_patch_status table.
228: */
229: hr_utility.trace('inserting into pay_patch_status ');
230: insert into pay_patch_status
231: (ID,
232: PATCH_NUMBER,
233: PATCH_NAME,
234: PHASE,

Line 244: (PAY_PATCH_STATUS_S.nextval,

240: LEGISLATION_CODE,
241: APPLICATION_RELEASE,
242: PREREQ_PATCH_NAME)
243: values
244: (PAY_PATCH_STATUS_S.nextval,
245: '1111111',
246: l_patch_name, --p_patch_name,
247: 'START',
248: null,

Line 397: from pay_patch_status

393:
394: cursor c_get_phase_id (p_patch_name varchar2)
395: is
396: select ID
397: from pay_patch_status
398: where patch_name = p_patch_name
399: and status in ('P','E');
400:
401: l_payroll_action_id number;

Line 409: l_patch_name pay_patch_status.patch_name%type;

405: l_geo_phase_id number;
406: l_year varchar2(4);
407: l_mode varchar2(7);
408: leg_param pay_payroll_actions.legislative_parameters%type;
409: l_patch_name pay_patch_status.patch_name%type;
410:
411: BEGIN
412:
413: hr_utility.set_location ('pay_us_geo_update.action_code', 1);

Line 464: from pay_patch_status

460: --
461: --
462: Cursor c_get_params is
463: select patch_name, patch_number
464: from pay_patch_status
465: where description = 'CURRENT GEOCODE PATCH';
466:
467: Cursor c_geo_check (p_patch_name in varchar2,
468: p_patch_number in number ) is

Line 469: select id from pay_patch_status

465: where description = 'CURRENT GEOCODE PATCH';
466:
467: Cursor c_geo_check (p_patch_name in varchar2,
468: p_patch_number in number ) is
469: select id from pay_patch_status
470: where patch_name = p_patch_name
471: and patch_number = p_patch_number
472: and legislation_code = 'US';
473:

Line 499: ln_upgrade_patch pay_patch_status.patch_name%TYPE;

495: ln_patch_id number;
496: lc_error varchar2(10);
497: lc_status varchar2(1);
498: --
499: ln_upgrade_patch pay_patch_status.patch_name%TYPE;
500: ln_upgrade_patch_id pay_patch_status.id%TYPE;
501: leg_param pay_payroll_actions.legislative_parameters%type;
502: l_year varchar2(4);
503: l_mode pay_payroll_actions.legislative_parameters%type;

Line 500: ln_upgrade_patch_id pay_patch_status.id%TYPE;

496: lc_error varchar2(10);
497: lc_status varchar2(1);
498: --
499: ln_upgrade_patch pay_patch_status.patch_name%TYPE;
500: ln_upgrade_patch_id pay_patch_status.id%TYPE;
501: leg_param pay_payroll_actions.legislative_parameters%type;
502: l_year varchar2(4);
503: l_mode pay_payroll_actions.legislative_parameters%type;
504: l_geo_phase_id number;

Line 506: l_patch_name pay_patch_status.patch_name%TYPE;

502: l_year varchar2(4);
503: l_mode pay_payroll_actions.legislative_parameters%type;
504: l_geo_phase_id number;
505:
506: l_patch_name pay_patch_status.patch_name%TYPE;
507:
508: l_req_id number;
509: copies_buffer varchar2(80) := null;
510: print_buffer varchar2(80) := null;

Line 567: update pay_patch_status

563: open c_geo_upd(ln_patch_id, 'P');
564: fetch c_geo_upd into lc_error;
565: if c_geo_upd%found then
566:
567: update pay_patch_status
568: set status = 'E'
569: where id = ln_patch_id;
570:
571: else

Line 573: update pay_patch_status

569: where id = ln_patch_id;
570:
571: else
572:
573: update pay_patch_status
574: set status = 'C',
575: phase = null,
576: process_type = null,
577: description = null

Line 2546: hr_utility.trace('The pay patch status id for this upgrade is: '||to_char(g_geo_phase_id));

2542: -- Set the global phase id for the geo update
2543:
2544: g_geo_phase_id := p_geo_phase_id;
2545:
2546: hr_utility.trace('The pay patch status id for this upgrade is: '||to_char(g_geo_phase_id));
2547:
2548: -- Set the global mode for the upgrade
2549:
2550: g_mode := p_mode;

Line 3588: FROM pay_patch_status

3584: l_chk_last_api varchar2(2);
3585:
3586: CURSOR pay_patch_id(p_patch_name VARCHAR2) IS
3587: SELECT ID
3588: FROM pay_patch_status
3589: WHERE patch_name = p_patch_name;
3590:
3591: l_id number;
3592:

Line 3648: IF chk_last_api%NOTFOUND THEN /* Everything is complete we can update pay_patch_status to complete */

3644: FETCH chk_last_api INTO l_chk_last_api;
3645:
3646: hr_utility.set_location('pay_us_geo_upd_pkg.upgrade_geo_api',45);
3647:
3648: IF chk_last_api%NOTFOUND THEN /* Everything is complete we can update pay_patch_status to complete */
3649:
3650: hr_utility.set_location('pay_us_geo_upd_pkg.upgrade_geo_api',50);
3651:
3652: UPDATE pay_patch_status

Line 3652: UPDATE pay_patch_status

3648: IF chk_last_api%NOTFOUND THEN /* Everything is complete we can update pay_patch_status to complete */
3649:
3650: hr_utility.set_location('pay_us_geo_upd_pkg.upgrade_geo_api',50);
3651:
3652: UPDATE pay_patch_status
3653: SET status = 'C', phase = null
3654: WHERE id = l_id;
3655: hr_utility.set_location('before commit ',4);
3656: