APPS.PO_DOCUMENT_CANCEL_PVT dependencies on PO_RELEASES

Line 1578: -- Updates the Cancel details on PO Releases if the entity being canceled is

1574: --Name: update_rel_header_cancel
1575:
1576: --Function:
1577: --
1578: -- Updates the Cancel details on PO Releases if the entity being canceled is
1579: -- Release Header
1580: -- Updates the following columns :
1581: --
1582: -- Before Funds Control call

Line 1668: UPDATE po_releases por

1664: IF p_fc_level = c_before_FC THEN
1665:
1666: l_progress := '001' ;
1667:
1668: UPDATE po_releases por
1669: SET por.cancel_flag = 'I' ,
1670: por.cancel_reason = p_cancel_reason,
1671: por.cancelled_by = l_emp_id ,
1672: --Bug 16575765: CANCEL_DATE is always stamped(RELEASE) as sysdate.

Line 1692: UPDATE po_releases por

1688: ELSE
1689:
1690: l_progress := '002' ;
1691:
1692: UPDATE po_releases por
1693: SET por.cancel_flag = 'Y'
1694: WHERE NVL(por.cancel_flag, 'N') = 'I'
1695: AND por.po_release_id = p_entity_id;
1696:

Line 5360: FROM po_releases

5356: SELECT revision_num,
5357: authorization_status
5358: INTO l_orig_revision_num,
5359: l_head_auth_status
5360: FROM po_releases
5361: WHERE PO_RELEASE_ID = p_doc_id;
5362:
5363: ELSE
5364: SELECT revision_num,

Line 5462: UPDATE PO_RELEASES_ALL

5458: l_progress := '005';
5459: -- <>
5460: IF p_document_type = c_doc_type_RELEASE THEN
5461:
5462: UPDATE PO_RELEASES_ALL
5463: SET REVISION_NUM = l_revision_num,
5464: REVISED_DATE = DECODE (
5465: revision_num,
5466: l_revision_num,

Line 5475: PO_DEBUG.debug_var(d_module, l_progress, 'Rows updated in PO Releases', SQL%ROWCOUNT);

5471: LAST_UPDATE_LOGIN = p_login_id
5472: WHERE PO_RELEASE_ID = p_doc_id;
5473:
5474: IF g_debug_stmt THEN
5475: PO_DEBUG.debug_var(d_module, l_progress, 'Rows updated in PO Releases', SQL%ROWCOUNT);
5476: END IF;
5477:
5478: ELSE
5479: UPDATE po_headers