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_EXCEPTION_ALERT dependencies on DBMS_LOCK

Line 1029: dbms_lock.sleep(1);

1025:
1026: -- **********************************************************
1027: -- make the Ad Hoc role to hold both the APPROVERS and shadow
1028:
1029: dbms_lock.sleep(1);
1030:
1031: if zpb_wf_ntf.has_Shadow(thisApproverID) = 'Y' then
1032: rolename := zpb_wf_ntf.MakeRoleName(InstanceID, TaskID, thisApproverID);
1033: select distinct display_name

Line 1645: dbms_lock.sleep(1);

1641: end if;
1642:
1643: -- FOR EACH OWNER start a explanation required process
1644: for v_recipient in c_recipient loop
1645: dbms_lock.sleep(1);
1646: thisRecipient := v_recipient.value;
1647: -- create NEWItemKey for FYI workflow
1648: NEWItemKey := rtrim(substr(ACName, 1, 50), ' ') || '-' || to_char(InstanceID) || '-' || to_char(taskID) || '-' || thisRecipient || '-' || workflowprocess;
1649:

Line 2272: dbms_lock.sleep(1);

2268: avalue => l_newURL);
2269:
2270: -- **********************************************************
2271: -- make the Ad Hoc role to hold both the dataowner and shadow
2272: dbms_lock.sleep(1);
2273: if zpb_wf_ntf.has_Shadow(thisOwnerID) = 'Y' then
2274: rolename := zpb_wf_ntf.MakeRoleName(InstanceID, TaskID, thisOwnerID);
2275: select distinct display_name
2276: into NewDispName