APPS.PO_MASS_UPDATE_PO_PVT dependencies on STANDARD

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

35:
36: -- IN : p_update_person Person needs to be updated(Buyer/Approver/Deliver_To).
37: -- p_old_personid Id of the old person.
38: -- p_new_personid Id of the new person.
39: -- p_document_type Type of the document(STANDARD,BLANKET.CONTRACT,PLANNED).
40: -- p_document_no_from Document number from.
41: -- p_document_no_to Document number to.
42: -- p_date_from Date from.
43: -- p_date_to Date to.

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

316:
317: -- IN : p_update_person Person needs to be updated(Buyer/Approver/Deliver_To).
318: -- p_old_personid Id of the old person.
319: -- p_new_personid Id of the new person.
320: -- p_document_type Type of the document(STANDARD,BLANKET.CONTRACT,PLANNED).
321: -- p_document_no_from Document number from.
322: -- p_document_no_to Document number to.
323: -- p_date_from Date from.
324: -- p_date_to Date to.

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

619: END IF;
620:
621: stmt_po := stmt_po || ' ORDER BY POH.segment1';
622:
623: IF (p_document_type IS NULL OR p_document_type IN ('STANDARD','BLANKET','PLANNED','CONTRACT','ALL')) THEN --
624:
625: OPEN c_po for stmt_po;
626:
627: LOOP

Line 766: ELSIF (p_document_type = 'STANDARD') THEN

762: IF (p_document_type IN ('BLANKET', 'CONTRACT')) THEN
763:
764: l_contracts_document_type := 'PA_'||p_document_type;
765:
766: ELSIF (p_document_type = 'STANDARD') THEN
767:
768: l_contracts_document_type := 'PO_'||p_document_type;
769:
770: END IF;

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

1182:
1183: -- IN : p_update_person Person needs to be updated(Buyer/Approver/Deliver_To).
1184: -- p_old_personid Id of the old person.
1185: -- p_new_personid Id of the new person.
1186: -- p_document_type Type of the document(STANDARD,BLANKET.CONTRACT,PLANNED).
1187: -- p_document_no_from Document number from.
1188: -- p_document_no_to Document number to.
1189: -- p_date_from Date from.
1190: -- p_date_to Date to.

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

1471: END IF;
1472:
1473: stmt_po := stmt_po || ' ORDER BY POH.segment1';
1474:
1475: IF (p_document_type IS NULL OR p_document_type IN ('STANDARD','BLANKET','PLANNED','CONTRACT','ALL')) THEN --
1476:
1477: OPEN c_po_approver for stmt_po;
1478: LOOP
1479:

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

1797:
1798: -- IN : p_update_person Person needs to be updated(Buyer/Approver/Deliver_To).
1799: -- p_old_personid Id of the old person.
1800: -- p_new_personid Id of the new person.
1801: -- p_document_type Type of the document(STANDARD,BLANKET.CONTRACT,PLANNED).
1802: -- p_document_no_from Document number from.
1803: -- p_document_no_to Document number to.
1804: -- p_date_from Date from.
1805: -- p_date_to Date to.

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

2075: END IF;
2076:
2077: stmt_po := stmt_po || ' ORDER BY POH.segment1';
2078:
2079: IF (p_document_type IS NULL OR p_document_type IN ('STANDARD','BLANKET','PLANNED','CONTRACT','ALL')) THEN --
2080:
2081: OPEN c_po for stmt_po;
2082:
2083: LOOP

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

2420: -- IN : p_update_person Person needs to be updated(Buyer/Approver/Deliver_To).
2421: -- p_old_buyer_name Buyer name of the old person.
2422: -- p_new_buyer_name Buyer name of the new person.
2423: -- p_org_name Operating unit name.
2424: -- p_document_type Type of the document(STANDARD,BLANKET.CONTRACT,PLANNED).
2425: -- p_document_no_from Document number from.
2426: -- p_document_no_to Document number to.
2427: -- p_date_from Date from.
2428: -- p_date_to Date to.