APPS.PO_MASS_CLOSE_PO_PVT dependencies on PO_DOCUMENT_TYPES

Line 59: l_doc_subtype po_document_types.document_subtype%TYPE;

55: l_po_num po_headers.clm_document_number%TYPE;
56: l_rel_num po_releases.release_num%TYPE;
57: l_doc_id po_headers.po_header_id%TYPE;
58: l_type_code po_headers.type_lookup_code%TYPE;
59: l_doc_subtype po_document_types.document_subtype%TYPE;
60: l_release_id po_releases.po_release_id%TYPE;
61: l_doc_type po_document_types.type_name%TYPE;
62: l_org_id NUMBER;
63: result BOOLEAN;

Line 61: l_doc_type po_document_types.type_name%TYPE;

57: l_doc_id po_headers.po_header_id%TYPE;
58: l_type_code po_headers.type_lookup_code%TYPE;
59: l_doc_subtype po_document_types.document_subtype%TYPE;
60: l_release_id po_releases.po_release_id%TYPE;
61: l_doc_type po_document_types.type_name%TYPE;
62: l_org_id NUMBER;
63: result BOOLEAN;
64: l_return_code VARCHAR2(100);
65: l_commit_count NUMBER;

Line 171: po_document_types_vl pdt,

167: pdt.document_type_code,
168: pdt.document_subtype,
169: pdt.type_name
170: FROM po_headers poh,
171: po_document_types_vl pdt,
172: po_distributions pod,
173: po_line_locations pll
174: WHERE poh.type_lookup_code = pdt.document_subtype
175: AND poh.po_header_id = pod.po_header_id

Line 196: po_document_types_vl pdt

192: pdt.document_type_code,
193: pdt.document_subtype,
194: pdt.type_name
195: FROM po_headers poh,
196: po_document_types_vl pdt
197: WHERE poh.type_lookup_code = pdt.document_subtype
198: AND Nvl(pdt.document_type_code,''PA'') = ''PA''
199: AND Nvl(poh.authorization_status, ''INCOMPLETE'')
200: IN (''APPROVED'',''REQUIRES REAPPROVAL'')

Line 211: po_document_types_vl pdt,

207: pdt.document_type_code,
208: pdt.document_subtype,
209: pdt.type_name
210: FROM po_headers poh,
211: po_document_types_vl pdt,
212: po_distributions pod,
213: po_line_locations pll
214: WHERE poh.type_lookup_code = pdt.document_subtype
215: AND poh.po_header_id = pod.po_header_id

Line 234: po_document_types_vl pdt

230: poh.po_header_id,
231: pdt.document_type_code,
232: pdt.document_subtype,
233: pdt.type_name FROM po_headers poh,
234: po_document_types_vl pdt
235: WHERE poh.type_lookup_code = pdt.document_subtype
236: AND Nvl(pdt.document_type_code,''PA'') = ''PA''
237: AND Nvl(poh.authorization_status, ''INCOMPLETE'')
238: IN (''APPROVED'',''REQUIRES REAPPROVAL'')

Line 505: po_document_types_vl pdt

501: pdt.document_subtype,
502: pdt.type_name
503: FROM po_releases por,
504: po_headers poh,
505: po_document_types_vl pdt
506: WHERE por.po_header_id = poh.po_header_id
507: AND pdt.document_type_code = ''RELEASE''
508: AND pdt.document_subtype = por.release_type
509: AND Nvl(por.authorization_status,''INCOMPLETE'')