APPS.PO_HEADERS_SV4 dependencies on PO_DOCUMENT_TYPES

Line 59: FROM po_document_types

55: x_progress := '010';
56:
57: SELECT type_name, document_subtype
58: INTO X_def_doc_type_name, X_def_type_lookup_code
59: FROM po_document_types
60: WHERE document_type_code = X_doc_type_code and
61: document_subtype = X_doc_subtype;
62:
63: EXCEPTION

Line 117: RETURN PO_DOCUMENT_TYPES_ALL.type_name%TYPE

113: FUNCTION get_type_name
114: (
115: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
116: )
117: RETURN PO_DOCUMENT_TYPES_ALL.type_name%TYPE
118: IS
119: x_type_name PO_DOCUMENT_TYPES_ALL.type_name%TYPE;
120:
121: l_org_id PO_HEADERS_ALL.org_id%TYPE;

Line 119: x_type_name PO_DOCUMENT_TYPES_ALL.type_name%TYPE;

115: p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
116: )
117: RETURN PO_DOCUMENT_TYPES_ALL.type_name%TYPE
118: IS
119: x_type_name PO_DOCUMENT_TYPES_ALL.type_name%TYPE;
120:
121: l_org_id PO_HEADERS_ALL.org_id%TYPE;
122: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
123: l_quote_type_lookup_code PO_HEADERS_ALL.quote_type_lookup_code%TYPE;

Line 125: l_document_type_code PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;

121: l_org_id PO_HEADERS_ALL.org_id%TYPE;
122: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
123: l_quote_type_lookup_code PO_HEADERS_ALL.quote_type_lookup_code%TYPE;
124:
125: l_document_type_code PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
126: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
127:
128: BEGIN
129:

Line 126: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;

122: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
123: l_quote_type_lookup_code PO_HEADERS_ALL.quote_type_lookup_code%TYPE;
124:
125: l_document_type_code PO_DOCUMENT_TYPES_ALL.document_type_code%TYPE;
126: l_document_subtype PO_DOCUMENT_TYPES_ALL.document_subtype%TYPE;
127:
128: BEGIN
129:
130: SELECT type_lookup_code,

Line 140: -- sets PO_DOCUMENT_TYPES_ALL.document_type_code & .document_subtype

136: FROM po_headers_all
137: WHERE po_header_id = p_po_header_id;
138:
139: -- based on PO_HEADERS_ALL.type_lookup_code & .quote_type_lookup_code,
140: -- sets PO_DOCUMENT_TYPES_ALL.document_type_code & .document_subtype
141: --
142: IF ( l_type_lookup_code = 'BLANKET' ) THEN -- Blanket Agreement
143: l_document_type_code := 'PA';
144: l_document_subtype := l_type_lookup_code;

Line 166: FROM po_document_types_all

162: END IF;
163:
164: SELECT type_name
165: INTO x_type_name
166: FROM po_document_types_all
167: WHERE document_type_code = l_document_type_code
168: AND document_subtype = l_document_subtype
169: AND org_id = l_org_id;
170:

Line 307: FROM po_document_types

303: X_progress := '010';
304:
305: SELECT nvl(can_preparer_approve_flag,'N')
306: INTO X_can_preparer_approve_flag
307: FROM po_document_types
308: WHERE document_type_code = X_document_type
309: AND document_subtype = X_document_subtype;
310:
311: exception