DBA Data[Home] [Help]

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 675: FROM po_document_types

671:
672: -- Retrieve the archive mode, which is needed for the validations.
673: SELECT archive_external_revision_code
674: INTO g_archive_mode
675: FROM po_document_types
676: WHERE document_type_code = g_document_type
677: AND document_subtype = g_document_subtype;
678:
679: EXCEPTION

Line 8055: p_document_type IN PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE,

8051: p_api_version IN NUMBER,
8052: p_init_msg_list IN VARCHAR2,
8053: x_return_status OUT NOCOPY VARCHAR2,
8054: p_document_id IN NUMBER,
8055: p_document_type IN PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE,
8056: p_document_subtype IN PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE,
8057: p_preparer_id IN NUMBER,
8058: p_approval_background_flag IN VARCHAR2,
8059: p_mass_update_releases IN VARCHAR2,

Line 8056: p_document_subtype IN PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE,

8052: p_init_msg_list IN VARCHAR2,
8053: x_return_status OUT NOCOPY VARCHAR2,
8054: p_document_id IN NUMBER,
8055: p_document_type IN PO_DOCUMENT_TYPES_ALL_B.document_type_code%TYPE,
8056: p_document_subtype IN PO_DOCUMENT_TYPES_ALL_B.document_subtype%TYPE,
8057: p_preparer_id IN NUMBER,
8058: p_approval_background_flag IN VARCHAR2,
8059: p_mass_update_releases IN VARCHAR2,
8060: p_retroactive_price_change IN VARCHAR2