DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_HOLD dependencies on PO_RELEASES

Line 118: UPDATE po_releases por

114: THEN
115:
116: d_progress := 80;
117:
118: UPDATE po_releases por
119: SET por.frozen_flag = DECODE(p_action_ctl_rec.action,
120: PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE, 'Y',
121: PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE, 'N')
122: , por.last_update_date = SYSDATE

Line 343: UPDATE po_releases por

339: THEN
340:
341: d_progress := 90;
342:
343: UPDATE po_releases por
344: SET por.hold_flag = DECODE(p_action_ctl_rec.action,
345: PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD, 'Y',
346: PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD, 'N')
347: , por.approved_flag = DECODE(p_action_ctl_rec.action,