APPS.PO_DOCUMENT_UPDATE_PVT dependencies on PO_RELEASES

Line 28: g_po_release_id PO_RELEASES.po_release_id%TYPE;

24: g_document_id PO_HEADERS.po_header_id%TYPE;
25: g_document_type PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE;
26: g_document_subtype PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE;
27: g_po_header_id PO_HEADERS.po_header_id%TYPE;
28: g_po_release_id PO_RELEASES.po_release_id%TYPE;
29:
30: g_archive_mode PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE;
31: g_pcard_id PO_HEADERS.pcard_id%TYPE;
32: g_revision_num PO_HEADERS.revision_num%TYPE;

Line 646: FROM po_releases POR, po_headers POH

642: g_pcard_id,
643: l_currency_code,
644: g_agent_id,
645: g_approved_date
646: FROM po_releases POR, po_headers POH
647: WHERE POR.po_release_id = g_po_release_id
648: AND POR.po_header_id = POH.po_header_id; -- JOIN
649:
650: g_document_type := 'RELEASE';

Line 745: FROM po_releases

741: ELSIF (g_po_release_id IS NOT NULL) THEN -- Release
742: BEGIN
743: SELECT 1
744: INTO l_dummy
745: FROM po_releases
746: WHERE po_release_id = g_po_release_id;
747: EXCEPTION
748: WHEN NO_DATA_FOUND THEN -- Error: po_release_id is invalid.
749: add_error (

Line 753: p_table_name => 'PO_RELEASES_ALL',

749: add_error (
750: p_api_errors => g_api_errors,
751: x_return_status => x_return_status,
752: p_message_name => 'PO_INVALID_DOC_IDS',
753: p_table_name => 'PO_RELEASES_ALL',
754: p_column_name => 'PO_RELEASE_ID',
755: p_entity_type => G_ENTITY_TYPE_CHANGES
756: );
757: RETURN; -- Do not continue with the remaining checks.

Line 6669: -- Updates PO_HEADERS_ALL, PO_RELEASES_ALL, PO_LINES_ALL,

6665: -- Applies the requested and derived changes to the database tables.
6666: --Pre-reqs:
6667: -- None.
6668: --Modifies:
6669: -- Updates PO_HEADERS_ALL, PO_RELEASES_ALL, PO_LINES_ALL,
6670: -- PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS_ALL with the changes.
6671: --Locks:
6672: -- None.
6673: --End of Comments

Line 7032: -- SQL What: Update PO_RELEASES with the last_update WHO values.

7028: END IF; -- sschinch 09/08/04 INVCONV
7029:
7030: ELSE -- release
7031:
7032: -- SQL What: Update PO_RELEASES with the last_update WHO values.
7033: -- If authorization status is Approved, change it to Requires Reapproval.
7034: -- If the approved flag is Y, change it to R.
7035: -- If this is a new revision, update the revised date to SYSDATE.
7036: IF g_sec_qty_grade_only_chge_doc = 'N' THEN -- sschinch 09.08.04 INVCONV

Line 7037: UPDATE po_releases

7033: -- If authorization status is Approved, change it to Requires Reapproval.
7034: -- If the approved flag is Y, change it to R.
7035: -- If this is a new revision, update the revised date to SYSDATE.
7036: IF g_sec_qty_grade_only_chge_doc = 'N' THEN -- sschinch 09.08.04 INVCONV
7037: UPDATE po_releases
7038: SET last_update_date = sysdate,
7039: last_updated_by = g_user_id,
7040: authorization_status =
7041: decode(authorization_status,

Line 8017: -- 'RELEASE': PO_RELEASES_ALL.po_release_id

8013: --IN:
8014: --p_document_id
8015: -- This value for this parameter depends on the p_document_type:
8016: -- 'PO' or 'PA': PO_HEADERS_ALL.po_header_id
8017: -- 'RELEASE': PO_RELEASES_ALL.po_release_id
8018: --p_document_type
8019: -- 'PO', 'PA', 'RELEASE'
8020: --p_document_subtype
8021: -- The value for this parameter depends on the p_document_type:

Line 8023: -- 'RELEASE': PO_RELEASES_ALL.release_type

8019: -- 'PO', 'PA', 'RELEASE'
8020: --p_document_subtype
8021: -- The value for this parameter depends on the p_document_type:
8022: -- 'PO' or 'PA': PO_HEADERS_ALL.type_lookup_code
8023: -- 'RELEASE': PO_RELEASES_ALL.release_type
8024: --p_preparer_id
8025: -- EMPLOYEE_ID of the buyer whose approval authority should be used in the
8026: -- approval workflow; if NULL, use the buyer on the document.
8027: --p_approval_background_flag