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 821: ELSIF (p_document_type = 'STANDARD') THEN

817: IF (p_document_type IN ('BLANKET', 'CONTRACT')) THEN
818:
819: l_contracts_document_type := 'PA_'||p_document_type;
820:
821: ELSIF (p_document_type = 'STANDARD') THEN
822:
823: l_contracts_document_type := 'PO_'||p_document_type;
824:
825: END IF;

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

1255:
1256: -- IN : p_update_person Person needs to be updated(Buyer/Approver/Deliver_To).
1257: -- p_old_personid Id of the old person.
1258: -- p_new_personid Id of the new person.
1259: -- p_document_type Type of the document(STANDARD,BLANKET.CONTRACT,PLANNED).
1260: -- p_document_no_from Document number from.
1261: -- p_document_no_to Document number to.
1262: -- p_date_from Date from.
1263: -- p_date_to Date to.

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

1544: END IF;
1545:
1546: stmt_po := stmt_po || ' ORDER BY POH.segment1';
1547:
1548: IF (p_document_type IS NULL OR p_document_type IN ('STANDARD','BLANKET','PLANNED','CONTRACT','ALL')) THEN --
1549:
1550: OPEN c_po_approver for stmt_po;
1551: LOOP
1552:

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

1870:
1871: -- IN : p_update_person Person needs to be updated(Buyer/Approver/Deliver_To).
1872: -- p_old_personid Id of the old person.
1873: -- p_new_personid Id of the new person.
1874: -- p_document_type Type of the document(STANDARD,BLANKET.CONTRACT,PLANNED).
1875: -- p_document_no_from Document number from.
1876: -- p_document_no_to Document number to.
1877: -- p_date_from Date from.
1878: -- p_date_to Date to.

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

2148: END IF;
2149:
2150: stmt_po := stmt_po || ' ORDER BY POH.segment1';
2151:
2152: IF (p_document_type IS NULL OR p_document_type IN ('STANDARD','BLANKET','PLANNED','CONTRACT','ALL')) THEN --
2153:
2154: OPEN c_po for stmt_po;
2155:
2156: LOOP

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

2493: -- IN : p_update_person Person needs to be updated(Buyer/Approver/Deliver_To).
2494: -- p_old_buyer_name Buyer name of the old person.
2495: -- p_new_buyer_name Buyer name of the new person.
2496: -- p_org_name Operating unit name.
2497: -- p_document_type Type of the document(STANDARD,BLANKET.CONTRACT,PLANNED).
2498: -- p_document_no_from Document number from.
2499: -- p_document_no_to Document number to.
2500: -- p_date_from Date from.
2501: -- p_date_to Date to.