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 1477: po_releases por

1473: Begin
1474: Select 'Y'
1475: into l_accepted_flag
1476: from po_acceptances_v pav,
1477: po_releases por
1478: where por.po_release_id=p_doc_id
1479: and por.po_release_id=pav.po_release_id
1480: and pav.revision_num= por.revision_num
1481: and pav.accepted_flag='Y';

Line 1497: FROM PO_RELEASES POR,

1493: INTO x_different
1494: from sys.dual
1495: where exists(
1496: select null
1497: FROM PO_RELEASES POR,
1498: PO_RELEASES_ARCHIVE PORA
1499: WHERE POR.po_release_id = p_doc_id
1500: AND POR.po_release_id = PORA.po_release_id
1501: AND PORA.latest_external_flag (+) = 'Y'

Line 1498: PO_RELEASES_ARCHIVE PORA

1494: from sys.dual
1495: where exists(
1496: select null
1497: FROM PO_RELEASES POR,
1498: PO_RELEASES_ARCHIVE PORA
1499: WHERE POR.po_release_id = p_doc_id
1500: AND POR.po_release_id = PORA.po_release_id
1501: AND PORA.latest_external_flag (+) = 'Y'
1502: AND (

Line 1847: from po_releases_archive

1843: l_progress := '055';
1844: BEGIN
1845: select 'Y'
1846: into l_Archive_Record_Exists
1847: from po_releases_archive
1848: where po_release_id = p_doc_id and rownum = 1;
1849: EXCEPTION
1850: WHEN NO_DATA_FOUND THEN
1851: l_Archive_Record_Exists := 'N';