DBA Data[Home] [Help]

APPS.PO_MASS_CLOSE_PO_PVT dependencies on STANDARD

Line 23: -- IN : p_document_type Type of the document(STANDARD,BLANKET.CONTRACT,PLANNED).

19: -- Function : Calls the procedure po_actions.close_po to close the PO's and releases.
20:
21: -- Parameters :
22:
23: -- IN : p_document_type Type of the document(STANDARD,BLANKET.CONTRACT,PLANNED).
24: -- p_document_no_from Document number from.
25: -- p_document_no_to Document number to.
26: -- p_date_from Date from.
27: -- p_date_to Date to.

Line 164: IF p_document_type IN ('STANDARD','PLANNED') THEN

160:
161: --
162:
163: --Bug 14004642, clean up conditions
164: IF p_document_type IN ('STANDARD','PLANNED') THEN
165: stmt_po := 'SELECT poh.segment1 PO_Number,
166: poh.po_header_id,
167: pdt.document_type_code,
168: pdt.document_subtype,

Line 378: IF (p_document_type IS NULL OR p_document_type IN ('STANDARD','BLANKET','PLANNED','CONTRACT','ALL')) THEN --

374: END IF;
375:
376: stmt_po := stmt_po || ' ORDER BY PO_Number';
377:
378: IF (p_document_type IS NULL OR p_document_type IN ('STANDARD','BLANKET','PLANNED','CONTRACT','ALL')) THEN --
379:
380: OPEN close_po for stmt_po;
381:
382: LOOP

Line 752: -- p_document_type Type of the document(STANDARD,BLANKET.CONTRACT,PLANNED).

748:
749: -- Parameters :
750:
751: -- IN : p_org_name Operating unit name.
752: -- p_document_type Type of the document(STANDARD,BLANKET.CONTRACT,PLANNED).
753: -- p_document_no_from Document number from.
754: -- p_document_no_to Document number to.
755: -- p_date_from Date from.
756: -- p_date_to Date to.