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 218: ln_upgrade_patch pay_patch_status.patch_name%TYPE;

214:
215: leg_param pay_payroll_actions.legislative_parameters%type;
216: l_year varchar2(4);
217:
218: ln_upgrade_patch pay_patch_status.patch_name%TYPE;
219: --
220: begin
221:
222: hr_utility.trace('reached range_cursor');

Line 264: l_patch_name pay_patch_status.patch_name%TYPE;

260: l_year varchar2(4);
261: l_geo_phase_id number;
262: l_mode Pay_Payroll_actions.legislative_parameters%type;
263:
264: l_patch_name pay_patch_status.patch_name%TYPE;
265:
266:
267:
268:

Line 339: from pay_patch_status

335:
336: cursor c_get_phase_id (p_patch_name varchar2)
337: is
338: select ID
339: from pay_patch_status
340: where patch_name = p_patch_name
341: and status in ('P','E');
342:
343: Cursor c_geo_check (p_patch_name in varchar2) is

Line 344: select phase, status from pay_patch_status

340: where patch_name = p_patch_name
341: and status in ('P','E');
342:
343: Cursor c_geo_check (p_patch_name in varchar2) is
344: select phase, status from pay_patch_status
345: where patch_name like p_patch_name || '%'
346: and legislation_code = 'US';
347:
348: l_assignment_id number;

Line 393: pay_patch_status table.

389: hr_utility.trace('c_geo_check not found chunk = 1');
390: /*
391: If both conditions above are true, there is a geocode update
392: underway and a row for this process needs to be added to the
393: pay_patch_status table.
394: */
395: hr_utility.trace('inserting into pay_patch_status ');
396: insert into pay_patch_status
397: (ID,

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

391: If both conditions above are true, there is a geocode update
392: underway and a row for this process needs to be added to the
393: pay_patch_status table.
394: */
395: hr_utility.trace('inserting into pay_patch_status ');
396: insert into pay_patch_status
397: (ID,
398: PATCH_NUMBER,
399: PATCH_NAME,

Line 396: insert into pay_patch_status

392: underway and a row for this process needs to be added to the
393: pay_patch_status table.
394: */
395: hr_utility.trace('inserting into pay_patch_status ');
396: insert into pay_patch_status
397: (ID,
398: PATCH_NUMBER,
399: PATCH_NAME,
400: PHASE,

Line 410: (PAY_PATCH_STATUS_S.nextval,

406: LEGISLATION_CODE,
407: APPLICATION_RELEASE,
408: PREREQ_PATCH_NAME)
409: values
410: (PAY_PATCH_STATUS_S.nextval,
411: '1111111',
412: l_patch_name, --p_patch_name,
413: 'START',
414: null,

Line 596: from pay_patch_status

592:
593: cursor c_get_phase_id (p_patch_name varchar2)
594: is
595: select ID
596: from pay_patch_status
597: where patch_name = p_patch_name
598: and status in ('P','E');
599:
600: l_payroll_action_id number;

Line 608: l_patch_name pay_patch_status.patch_name%type;

604: l_geo_phase_id number;
605: l_year varchar2(4);
606: l_mode varchar2(7);
607: leg_param pay_payroll_actions.legislative_parameters%type;
608: l_patch_name pay_patch_status.patch_name%type;
609:
610: BEGIN
611:
612: hr_utility.set_location ('pay_us_geo_update.action_code', 1);

Line 663: from pay_patch_status

659: --
660: --
661: Cursor c_get_params is
662: select patch_name, patch_number
663: from pay_patch_status
664: where description = 'CURRENT GEOCODE PATCH';
665:
666: Cursor c_geo_check (p_patch_name in varchar2,
667: p_patch_number in number ) is

Line 668: select id from pay_patch_status

664: where description = 'CURRENT GEOCODE PATCH';
665:
666: Cursor c_geo_check (p_patch_name in varchar2,
667: p_patch_number in number ) is
668: select id from pay_patch_status
669: where patch_name = p_patch_name
670: and patch_number = p_patch_number
671: and legislation_code = 'US';
672:

Line 698: ln_upgrade_patch pay_patch_status.patch_name%TYPE;

694: ln_patch_id number;
695: lc_error varchar2(10);
696: lc_status varchar2(1);
697: --
698: ln_upgrade_patch pay_patch_status.patch_name%TYPE;
699: ln_upgrade_patch_id pay_patch_status.id%TYPE;
700: leg_param pay_payroll_actions.legislative_parameters%type;
701: l_year varchar2(4);
702: l_mode pay_payroll_actions.legislative_parameters%type;

Line 699: ln_upgrade_patch_id pay_patch_status.id%TYPE;

695: lc_error varchar2(10);
696: lc_status varchar2(1);
697: --
698: ln_upgrade_patch pay_patch_status.patch_name%TYPE;
699: ln_upgrade_patch_id pay_patch_status.id%TYPE;
700: leg_param pay_payroll_actions.legislative_parameters%type;
701: l_year varchar2(4);
702: l_mode pay_payroll_actions.legislative_parameters%type;
703: l_geo_phase_id number;

Line 705: l_patch_name pay_patch_status.patch_name%TYPE;

701: l_year varchar2(4);
702: l_mode pay_payroll_actions.legislative_parameters%type;
703: l_geo_phase_id number;
704:
705: l_patch_name pay_patch_status.patch_name%TYPE;
706:
707: l_req_id number;
708: copies_buffer varchar2(80) := null;
709: print_buffer varchar2(80) := null;

Line 769: update pay_patch_status

765: open c_geo_upd(ln_patch_id, 'P');
766: fetch c_geo_upd into lc_error;
767: if c_geo_upd%found then
768: fnd_file.put_line(fnd_file.log, 'c_geo_upd%found');
769: update pay_patch_status
770: set status = 'E'
771: where id = ln_patch_id;
772:
773: else

Line 775: update pay_patch_status

771: where id = ln_patch_id;
772:
773: else
774: fnd_file.put_line(fnd_file.log, 'c_geo_upd%notfound');
775: update pay_patch_status
776: set status = 'C',
777: phase = null,
778: process_type = null,
779: description = null

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

2835: -- Set the global phase id for the geo update
2836:
2837: g_geo_phase_id := p_geo_phase_id;
2838:
2839: hr_utility.trace('The pay patch status id for this upgrade is: '||to_char(g_geo_phase_id));
2840:
2841: -- Set the global mode for the upgrade
2842:
2843: g_mode := p_mode;

Line 4860: FROM pay_patch_status

4856: l_chk_last_api varchar2(2);
4857:
4858: CURSOR pay_patch_id(p_patch_name VARCHAR2) IS
4859: SELECT ID
4860: FROM pay_patch_status
4861: WHERE patch_name = p_patch_name;
4862:
4863: l_id number;
4864:

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

4916: FETCH chk_last_api INTO l_chk_last_api;
4917:
4918: hr_utility.set_location('pay_us_geo_upd_pkg.upgrade_geo_api',45);
4919:
4920: IF chk_last_api%NOTFOUND THEN /* Everything is complete we can update pay_patch_status to complete */
4921:
4922: hr_utility.set_location('pay_us_geo_upd_pkg.upgrade_geo_api',50);
4923:
4924: UPDATE pay_patch_status

Line 4924: UPDATE pay_patch_status

4920: IF chk_last_api%NOTFOUND THEN /* Everything is complete we can update pay_patch_status to complete */
4921:
4922: hr_utility.set_location('pay_us_geo_upd_pkg.upgrade_geo_api',50);
4923:
4924: UPDATE pay_patch_status
4925: SET status = 'C', phase = null
4926: WHERE id = l_id;
4927: hr_utility.set_location('before commit ',4);
4928: