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.HRDYNDBI dependencies on PAY_PATCH_STATUS

Line 703: insert into PAY_PATCH_STATUS(id,

699: IS
700: PRAGMA AUTONOMOUS_TRANSACTION;
701: BEGIN
702:
703: insert into PAY_PATCH_STATUS(id,
704: patch_number,
705: patch_name,
706: process_type,
707: applied_date)

Line 709: pay_patch_status_s.nextval,

705: patch_name,
706: process_type,
707: applied_date)
708: values (
709: pay_patch_status_s.nextval,
710: to_char(p_worker_id),
711: 'HRRBDEIB INTERNAL PROC S' || to_char(p_stage),
712: p_leg_code,
713: sysdate);

Line 723: insert into PAY_PATCH_STATUS(id,

719: IS
720: PRAGMA AUTONOMOUS_TRANSACTION;
721: BEGIN
722:
723: insert into PAY_PATCH_STATUS(id,
724: patch_number,
725: patch_name,
726: process_type,
727: applied_date)

Line 729: pay_patch_status_s.nextval,

725: patch_name,
726: process_type,
727: applied_date)
728: values (
729: pay_patch_status_s.nextval,
730: to_char(p_worker_id),
731: 'HRRBDEIB INTERNAL PROC ERR' || to_char(p_worker_id),
732: p_leg_code,
733: sysdate);

Line 5161: from pay_patch_status

5157: g_debug_cnt := 0;
5158:
5159: select count(*)
5160: into g_debug_cnt
5161: from pay_patch_status
5162: where patch_name = 'HRGLOBAL_DEBUG2';
5163:
5164: hrrbdeib_trace_on;
5165: hr_utility.trace('entering rebuild_ele_input_bal all' ||

Line 5225: from pay_patch_status

5221: loop
5222:
5223: select count(*)
5224: into worker_err
5225: from pay_patch_status
5226: where patch_name like 'HRRBDEIB INTERNAL PROC ERR%';
5227:
5228: if worker_err > 0 then
5229: raise_application_error(-20106, 'A hrrbdeib worker has failed, terminating all workers.');

Line 5234: from pay_patch_status

5230: end if;
5231:
5232: select count(*)
5233: into workers_complete
5234: from pay_patch_status
5235: where patch_name = 'HRRBDEIB INTERNAL PROC S1'
5236: and process_type = 'ZZ';
5237:
5238: exit when workers_complete = p_maxworkers;

Line 5276: from pay_patch_status

5272: loop
5273:
5274: select count(*)
5275: into worker_err
5276: from pay_patch_status
5277: where patch_name like 'HRRBDEIB INTERNAL PROC ERR%';
5278:
5279: if worker_err > 0 then
5280: raise_application_error(-20106, 'A hrrbdeib worker has failed, terminating all workers.');

Line 5285: from pay_patch_status

5281: end if;
5282:
5283: select count(*)
5284: into workers_complete
5285: from pay_patch_status
5286: where patch_name = 'HRRBDEIB INTERNAL PROC S2'
5287: and process_type = 'ZZ';
5288:
5289: exit when workers_complete = p_maxworkers;

Line 5324: from pay_patch_status

5320: loop
5321:
5322: select count(*)
5323: into worker_err
5324: from pay_patch_status
5325: where patch_name like 'HRRBDEIB INTERNAL PROC ERR%';
5326:
5327: if worker_err > 0 then
5328: raise_application_error(-20106, 'A hrrbdeib worker has failed, terminating all workers.');

Line 5333: from pay_patch_status

5329: end if;
5330:
5331: select count(*)
5332: into workers_complete
5333: from pay_patch_status
5334: where patch_name = 'HRRBDEIB INTERNAL PROC S3'
5335: and process_type = 'ZZ';
5336:
5337: exit when workers_complete = p_maxworkers;

Line 5386: from pay_patch_status

5382: loop
5383:
5384: select count(*)
5385: into worker_err
5386: from pay_patch_status
5387: where patch_name like 'HRRBDEIB INTERNAL PROC ERR%';
5388:
5389: if worker_err > 0 then
5390: raise_application_error(-20106, 'A hrrbdeib worker has failed, terminating all workers.');

Line 5395: from pay_patch_status

5391: end if;
5392:
5393: select count(*)
5394: into workers_complete
5395: from pay_patch_status
5396: where patch_name = 'HRRBDEIB INTERNAL PROC S4'
5397: and process_type = 'ZZ';
5398:
5399: exit when workers_complete = p_maxworkers;

Line 5407: -- tracking pay_patch_status rows so that the next leg loop of hrrbdeib

5403: end loop;
5404: --
5405: -- Important. In order not to hang when we have selected more than
5406: -- 1 non Core legislation for install, we must of course delete the
5407: -- tracking pay_patch_status rows so that the next leg loop of hrrbdeib
5408: -- starts afresh. We take care of this now by not trashing history and
5409: -- tag a legislation code to the pps rows
5410: --
5411: if (p_commit = 'Y') then

Line 5572: from pay_patch_status

5568: g_debug_cnt := 0;
5569:
5570: select count(*)
5571: into g_debug_cnt
5572: from pay_patch_status
5573: where patch_name = 'HRGLOBAL_DEBUG2';
5574:
5575: hrrbdeib_trace_on;
5576: hr_utility.trace('entering rebuild_ele_input_bal ' || p_leg_code ||

Line 5653: from pay_patch_status

5649: loop
5650:
5651: select count(*)
5652: into worker_err
5653: from pay_patch_status
5654: where patch_name like 'HRRBDEIB INTERNAL PROC ERR%';
5655:
5656: if worker_err > 0 then
5657: raise_application_error(-20106, 'A hrrbdeib worker has failed, terminating all workers.');

Line 5662: from pay_patch_status

5658: end if;
5659:
5660: select count(*)
5661: into workers_complete
5662: from pay_patch_status
5663: where patch_name = 'HRRBDEIB INTERNAL PROC S1'
5664: and process_type = p_leg_code;
5665:
5666: exit when workers_complete = p_maxworkers;

Line 5701: from pay_patch_status

5697: loop
5698:
5699: select count(*)
5700: into worker_err
5701: from pay_patch_status
5702: where patch_name like 'HRRBDEIB INTERNAL PROC ERR%';
5703:
5704: if worker_err > 0 then
5705: raise_application_error(-20106, 'A hrrbdeib worker has failed, terminating all workers.');

Line 5710: from pay_patch_status

5706: end if;
5707:
5708: select count(*)
5709: into workers_complete
5710: from pay_patch_status
5711: where patch_name = 'HRRBDEIB INTERNAL PROC S2'
5712: and process_type = p_leg_code;
5713:
5714: exit when workers_complete = p_maxworkers;

Line 5749: from pay_patch_status

5745: loop
5746:
5747: select count(*)
5748: into worker_err
5749: from pay_patch_status
5750: where patch_name like 'HRRBDEIB INTERNAL PROC ERR%';
5751:
5752: if worker_err > 0 then
5753: raise_application_error(-20106, 'A hrrbdeib worker has failed, terminating all workers.');

Line 5758: from pay_patch_status

5754: end if;
5755:
5756: select count(*)
5757: into workers_complete
5758: from pay_patch_status
5759: where patch_name = 'HRRBDEIB INTERNAL PROC S3'
5760: and process_type = p_leg_code;
5761:
5762: exit when workers_complete = p_maxworkers;

Line 5815: from pay_patch_status

5811: loop
5812:
5813: select count(*)
5814: into worker_err
5815: from pay_patch_status
5816: where patch_name like 'HRRBDEIB INTERNAL PROC ERR%';
5817:
5818: if worker_err > 0 then
5819: raise_application_error(-20106, 'A hrrbdeib worker has failed, terminating all workers.');

Line 5824: from pay_patch_status

5820: end if;
5821:
5822: select count(*)
5823: into workers_complete
5824: from pay_patch_status
5825: where patch_name = 'HRRBDEIB INTERNAL PROC S4'
5826: and process_type = p_leg_code;
5827:
5828: exit when workers_complete = p_maxworkers;

Line 5836: -- tracking pay_patch_status rows so that the next leg loop of hrrbdeib

5832: end loop;
5833: --
5834: -- Important. In order not to hang when we have selected more than
5835: -- 1 non Core legislation for install, we must of course delete the
5836: -- tracking pay_patch_status rows so that the next leg loop of hrrbdeib
5837: -- starts afresh. We take care of this now by not trashing history and
5838: -- tag a legislation code to the pps rows
5839: --
5840: if (p_commit = 'Y') then

Line 7938: delete pay_patch_status

7934: --
7935: -- First set global to say we are disabling triggers.
7936: g_triggers_altered := TRUE;
7937: --
7938: delete pay_patch_status
7939: where patch_name like 'HRRBDEIB%';
7940: --
7941: commit;
7942: --

Line 7965: delete pay_patch_status

7961: disable_refbal_trig;
7962: --
7963: hrdyndbi.refresh_element_types(0, 1);
7964: --
7965: delete pay_patch_status
7966: where patch_name like 'HRRBDEIB%';
7967: --
7968: enable_refbal_trig;
7969: --