APPS.PO_DOCUMENT_UPDATE_PVT dependencies on PO_DOCUMENT_TYPES

Line 25: g_document_type PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE;

21: g_api_errors PO_API_ERRORS_REC_TYPE;
22: g_update_source VARCHAR2(100);
23:
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:

Line 26: g_document_subtype PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE;

22: g_update_source VARCHAR2(100);
23:
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;

Line 30: g_archive_mode PO_DOCUMENT_TYPES.archive_external_revision_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;
33: g_min_accountable_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
34: g_precision FND_CURRENCIES.precision%TYPE;

Line 688: FROM po_document_types

684:
685: -- Retrieve the archive mode, which is needed for the validations.
686: SELECT archive_external_revision_code
687: INTO g_archive_mode
688: FROM po_document_types
689: WHERE document_type_code = g_document_type
690: AND document_subtype = g_document_subtype;
691:
692:

Line 8190: p_document_type IN PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE,

8186: p_api_version IN NUMBER,
8187: p_init_msg_list IN VARCHAR2,
8188: x_return_status OUT NOCOPY VARCHAR2,
8189: p_document_id IN NUMBER,
8190: p_document_type IN PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE,
8191: p_document_subtype IN PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE,
8192: p_preparer_id IN NUMBER,
8193: p_approval_background_flag IN VARCHAR2,
8194: p_mass_update_releases IN VARCHAR2,

Line 8191: p_document_subtype IN PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE,

8187: p_init_msg_list IN VARCHAR2,
8188: x_return_status OUT NOCOPY VARCHAR2,
8189: p_document_id IN NUMBER,
8190: p_document_type IN PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE,
8191: p_document_subtype IN PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE,
8192: p_preparer_id IN NUMBER,
8193: p_approval_background_flag IN VARCHAR2,
8194: p_mass_update_releases IN VARCHAR2,
8195: p_retroactive_price_change IN VARCHAR2