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 659: FROM po_releases POR, po_headers POH

655: g_pcard_id,
656: l_currency_code,
657: g_agent_id,
658: g_approved_date
659: FROM po_releases POR, po_headers POH
660: WHERE POR.po_release_id = g_po_release_id
661: AND POR.po_header_id = POH.po_header_id; -- JOIN
662:
663: g_document_type := 'RELEASE';

Line 759: FROM po_releases

755: ELSIF (g_po_release_id IS NOT NULL) THEN -- Release
756: BEGIN
757: SELECT 1
758: INTO l_dummy
759: FROM po_releases
760: WHERE po_release_id = g_po_release_id;
761: EXCEPTION
762: WHEN NO_DATA_FOUND THEN -- Error: po_release_id is invalid.
763: add_error (

Line 767: p_table_name => 'PO_RELEASES_ALL',

763: add_error (
764: p_api_errors => g_api_errors,
765: x_return_status => x_return_status,
766: p_message_name => 'PO_INVALID_DOC_IDS',
767: p_table_name => 'PO_RELEASES_ALL',
768: p_column_name => 'PO_RELEASE_ID',
769: p_entity_type => G_ENTITY_TYPE_CHANGES
770: );
771: RETURN; -- Do not continue with the remaining checks.

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

6721: -- Applies the requested and derived changes to the database tables.
6722: --Pre-reqs:
6723: -- None.
6724: --Modifies:
6725: -- Updates PO_HEADERS_ALL, PO_RELEASES_ALL, PO_LINES_ALL,
6726: -- PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS_ALL with the changes.
6727: --Locks:
6728: -- None.
6729: --End of Comments

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

7140: END IF; -- sschinch 09/08/04 INVCONV
7141:
7142: ELSE -- release
7143:
7144: -- SQL What: Update PO_RELEASES with the last_update WHO values.
7145: -- If authorization status is Approved, change it to Requires Reapproval.
7146: -- If the approved flag is Y, change it to R.
7147: -- If this is a new revision, update the revised date to SYSDATE.
7148: IF g_sec_qty_grade_only_chge_doc = 'N' THEN -- sschinch 09.08.04 INVCONV

Line 7149: UPDATE po_releases_all

7145: -- If authorization status is Approved, change it to Requires Reapproval.
7146: -- If the approved flag is Y, change it to R.
7147: -- If this is a new revision, update the revised date to SYSDATE.
7148: IF g_sec_qty_grade_only_chge_doc = 'N' THEN -- sschinch 09.08.04 INVCONV
7149: UPDATE po_releases_all
7150: SET last_update_date = sysdate,
7151: last_updated_by = g_user_id,
7152: authorization_status =
7153: decode(authorization_status,

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

8148: --IN:
8149: --p_document_id
8150: -- This value for this parameter depends on the p_document_type:
8151: -- 'PO' or 'PA': PO_HEADERS_ALL.po_header_id
8152: -- 'RELEASE': PO_RELEASES_ALL.po_release_id
8153: --p_document_type
8154: -- 'PO', 'PA', 'RELEASE'
8155: --p_document_subtype
8156: -- The value for this parameter depends on the p_document_type:

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

8154: -- 'PO', 'PA', 'RELEASE'
8155: --p_document_subtype
8156: -- The value for this parameter depends on the p_document_type:
8157: -- 'PO' or 'PA': PO_HEADERS_ALL.type_lookup_code
8158: -- 'RELEASE': PO_RELEASES_ALL.release_type
8159: --p_preparer_id
8160: -- EMPLOYEE_ID of the buyer whose approval authority should be used in the
8161: -- approval workflow; if NULL, use the buyer on the document.
8162: --p_approval_background_flag