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.PO_SIGNATURE_PVT dependencies on WF_PROCESS_ACTIVITIES

Line 2706: l_activity_name WF_PROCESS_ACTIVITIES.activity_name%TYPE;

2702: PROCEDURE Complete_Block_Activities(p_itemkey IN VARCHAR2,
2703: p_status IN VARCHAR2,
2704: x_result OUT NOCOPY VARCHAR2)
2705: IS
2706: l_activity_name WF_PROCESS_ACTIVITIES.activity_name%TYPE;
2707: BEGIN
2708: BEGIN
2709: -- SQL What:Selects the Block Activity that is in the NOTIFIED state in the PO Approval workflow
2710: -- SQL Why :To find out the name of the Block activity that needs to be completed

Line 2713: FROM WF_PROCESS_ACTIVITIES WPA,

2709: -- SQL What:Selects the Block Activity that is in the NOTIFIED state in the PO Approval workflow
2710: -- SQL Why :To find out the name of the Block activity that needs to be completed
2711: SELECT WPA.activity_name
2712: INTO l_activity_name
2713: FROM WF_PROCESS_ACTIVITIES WPA,
2714: WF_ITEM_ACTIVITY_STATUSES WIA
2715: WHERE WIA.item_type = 'POAPPRV'
2716: AND WIA.item_key = p_itemkey
2717: AND WIA.process_activity = WPA.INSTANCE_ID