APPS.PO_DOCUMENT_REVISION_GRP dependencies on PO_RELEASES

Line 148: update po_releases

144: set submit_date = NULL
145: where po_header_id = p_doc_id;
146:
147: elsif ((p_doc_type = 'RELEASE')) THEN
148: update po_releases
149: set submit_date = NULL
150: where po_release_id = p_doc_id;
151: end if;
152: --

Line 633: FROM PO_RELEASES POR,

629:
630: l_progress := '000';
631: SELECT POR.revision_num, nvl(PORA.revision_num, -1)
632: INTO l_revision_num, l_archived_number
633: FROM PO_RELEASES POR,
634: PO_RELEASES_ARCHIVE PORA
635: WHERE POR.po_release_id = p_doc_id
636: AND POR.po_release_id = PORA.po_release_id (+)
637: AND PORA.latest_external_flag (+) = 'Y';

Line 634: PO_RELEASES_ARCHIVE PORA

630: l_progress := '000';
631: SELECT POR.revision_num, nvl(PORA.revision_num, -1)
632: INTO l_revision_num, l_archived_number
633: FROM PO_RELEASES POR,
634: PO_RELEASES_ARCHIVE PORA
635: WHERE POR.po_release_id = p_doc_id
636: AND POR.po_release_id = PORA.po_release_id (+)
637: AND PORA.latest_external_flag (+) = 'Y';
638:

Line 1526: po_releases por

1522: Begin
1523: Select pav.accepted_flag
1524: into l_accepted_flag
1525: from po_acceptances_v pav,
1526: po_releases por
1527: where por.po_release_id=p_doc_id
1528: and por.po_release_id=pav.po_release_id
1529: and pav.revision_num= por.revision_num
1530: and por.acceptance_required_flag='N'

Line 1548: FROM PO_RELEASES POR,

1544: INTO x_different
1545: from sys.dual
1546: where exists(
1547: select null
1548: FROM PO_RELEASES POR,
1549: PO_RELEASES_ARCHIVE PORA
1550: WHERE POR.po_release_id = p_doc_id
1551: AND POR.po_release_id = PORA.po_release_id
1552: AND PORA.latest_external_flag (+) = 'Y'

Line 1549: PO_RELEASES_ARCHIVE PORA

1545: from sys.dual
1546: where exists(
1547: select null
1548: FROM PO_RELEASES POR,
1549: PO_RELEASES_ARCHIVE PORA
1550: WHERE POR.po_release_id = p_doc_id
1551: AND POR.po_release_id = PORA.po_release_id
1552: AND PORA.latest_external_flag (+) = 'Y'
1553: AND (

Line 1909: from po_releases_archive

1905: l_progress := '055';
1906: BEGIN
1907: select 'Y'
1908: into l_Archive_Record_Exists
1909: from po_releases_archive
1910: where po_release_id = p_doc_id and rownum = 1;
1911: EXCEPTION
1912: WHEN NO_DATA_FOUND THEN
1913: l_Archive_Record_Exists := 'N';

Line 2133: FROM po_releases_all

2129: SELECT NVL(fsp.purch_encumbrance_flag, 'N')
2130: INTO l_po_encumbrance_flag
2131: FROM financials_system_params_all fsp
2132: WHERE org_id = (SELECT org_id
2133: FROM po_releases_all
2134: WHERE po_release_id = p_doc_id
2135: AND p_doc_type = PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE
2136: UNION ALL
2137: SELECT org_id