APPS.PO_LINES_SV dependencies on PO_DOCUMENT_TYPES

Line 22: l_type_name po_document_types.type_name%type; --Bug 3453216;

18: x_progress VARCHAR2(3) := '';
19: X_allow_delete VARCHAR2(1) := '';
20: X_po_line_num NUMBER := '';
21: X_po_header_id NUMBER := '';
22: l_type_name po_document_types.type_name%type; --Bug 3453216;
23: BEGIN
24: x_progress := '010';
25: --
26: -- If the calling source is HTML then we need not do the validations as we

Line 76: from po_document_types

72: Begin
73: IF X_type_lookup_code IN ('STANDARD','PLANNED') THEN
74: select type_name
75: into l_type_name
76: from po_document_types
77: where document_type_code = 'PO'
78: and document_subtype=X_type_lookup_code;
79: ELSIF X_type_lookup_code='BLANKET' THEN
80: select type_name

Line 82: from po_document_types

78: and document_subtype=X_type_lookup_code;
79: ELSIF X_type_lookup_code='BLANKET' THEN
80: select type_name
81: into l_type_name
82: from po_document_types
83: where document_type_code = 'PA'
84: and document_subtype='BLANKET';
85: END IF;
86: Exception when others THEN