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.ZPB_WF dependencies on DBMS_LOCK

Line 984: dbms_lock.sleep(seconds);

980: where t.item_type = 'ZPBSCHED' AND t.ACTIVITY_STATUS IN ('DEFERRED', 'NOTIFIED'));
981:
982: if itemsToProcess > 0 then
983: -- giving it a few second to propigate to AQ tables.
984: dbms_lock.sleep(seconds);
985: wf_engine.Background(itemtype);
986: else
987: dbms_lock.sleep(seconds);
988:

Line 987: dbms_lock.sleep(seconds);

983: -- giving it a few second to propigate to AQ tables.
984: dbms_lock.sleep(seconds);
985: wf_engine.Background(itemtype);
986: else
987: dbms_lock.sleep(seconds);
988:
989: -- One last look before exit
990: select count(*)
991: into itemsToProcess

Line 1049: dbms_lock.sleep(seconds);

1045: where t.item_type = 'EPBCYCLE' AND t.ACTIVITY_STATUS IN ('DEFERRED', 'NOTIFIED'));
1046:
1047: if itemsToProcess > 0 then
1048: -- giving it a few second to propigate to AQ tables.
1049: dbms_lock.sleep(seconds);
1050: wf_engine.Background(TGT_ITEMTYPE);
1051: else
1052: dbms_lock.sleep(seconds);
1053: -- One last look before exit

Line 1052: dbms_lock.sleep(seconds);

1048: -- giving it a few second to propigate to AQ tables.
1049: dbms_lock.sleep(seconds);
1050: wf_engine.Background(TGT_ITEMTYPE);
1051: else
1052: dbms_lock.sleep(seconds);
1053: -- One last look before exit
1054: select count(*)
1055: into itemsToProcess
1056: from wf_items_v v

Line 3278: dbms_lock.sleep(15);

3274: Itemkey => ItemKey,
3275: aname => 'RESULT',
3276: avalue => ACIDlist);
3277: zpb_wf.ACStart(thisACID, 'N', 'Y');
3278: dbms_lock.sleep(15);
3279: resultout :='COMPLETE:PROCEED';
3280: else
3281: -- 0 length remaining OR NULL
3282: resultout :='COMPLETE:NO_EVENTS';