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 706: insert into PAY_PATCH_STATUS(id,

702: IS
703: PRAGMA AUTONOMOUS_TRANSACTION;
704: BEGIN
705:
706: insert into PAY_PATCH_STATUS(id,
707: patch_number,
708: patch_name,
709: process_type,
710: applied_date)

Line 712: pay_patch_status_s.nextval,

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

Line 726: insert into PAY_PATCH_STATUS(id,

722: IS
723: PRAGMA AUTONOMOUS_TRANSACTION;
724: BEGIN
725:
726: insert into PAY_PATCH_STATUS(id,
727: patch_number,
728: patch_name,
729: process_type,
730: applied_date)

Line 732: pay_patch_status_s.nextval,

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

Line 5164: from pay_patch_status

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

Line 5228: from pay_patch_status

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

Line 5237: from pay_patch_status

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

Line 5279: from pay_patch_status

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

Line 5288: from pay_patch_status

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

Line 5327: from pay_patch_status

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

Line 5336: from pay_patch_status

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

Line 5389: from pay_patch_status

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

Line 5398: from pay_patch_status

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

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

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

Line 5575: from pay_patch_status

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

Line 5656: from pay_patch_status

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

Line 5665: from pay_patch_status

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

Line 5704: from pay_patch_status

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

Line 5713: from pay_patch_status

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

Line 5752: from pay_patch_status

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

Line 5761: from pay_patch_status

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

Line 5818: from pay_patch_status

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

Line 5827: from pay_patch_status

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

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

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

Line 8015: delete pay_patch_status

8011: --
8012: -- First set global to say we are disabling triggers.
8013: g_triggers_altered := TRUE;
8014: --
8015: delete pay_patch_status
8016: where patch_name like 'HRRBDEIB%';
8017: --
8018: commit;
8019: --

Line 8042: delete pay_patch_status

8038: disable_refbal_trig;
8039: --
8040: hrdyndbi.refresh_element_types(0, 1);
8041: --
8042: delete pay_patch_status
8043: where patch_name like 'HRRBDEIB%';
8044: --
8045: enable_refbal_trig;
8046: --