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 162: IF p_document_type IN ('STANDARD','PLANNED') THEN

158: END;
159:
160: --
161:
162: IF p_document_type IN ('STANDARD','PLANNED') THEN
163:
164: stmt_po := 'SELECT poh.segment1 PO_Number,
165: poh.po_header_id,
166: pdt.document_type_code,

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

311: END IF;
312:
313: stmt_po := stmt_po || ' ORDER BY PO_Number';
314:
315: IF (p_document_type IS NULL OR p_document_type IN ('STANDARD','BLANKET','PLANNED','CONTRACT','ALL')) THEN --
316:
317: OPEN close_po for stmt_po;
318:
319: LOOP

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

668:
669: -- Parameters :
670:
671: -- IN : p_org_name Operating unit name.
672: -- p_document_type Type of the document(STANDARD,BLANKET.CONTRACT,PLANNED).
673: -- p_document_no_from Document number from.
674: -- p_document_no_to Document number to.
675: -- p_date_from Date from.
676: -- p_date_to Date to.