DBA Data[Home] [Help]

APPS.WIP_OSP dependencies on PO_CHANGES_REC_TYPE

Line 1666: l_po_changes PO_CHANGES_REC_TYPE;

1662: l_returnStatus VARCHAR2(1);
1663: l_errMsg VARCHAR2(240);
1664: l_msgCount NUMBER;
1665: l_msgData VARCHAR2(2000);
1666: l_po_changes PO_CHANGES_REC_TYPE;
1667: l_errors_rec PO_API_ERRORS_REC_TYPE;
1668: l_req_changes PO_REQ_CHANGES_REC_TYPE;
1669:
1670: BEGIN

Line 1711: l_po_changes := PO_CHANGES_REC_TYPE.create_object(

1707: -- Call PO API to update NBD. This API will notify supplier after
1708: -- the PO get approved. Supplier will then change promise date
1709: -- through iSupplier or communicate the change to buyer if they can
1710: -- accommodate the new change
1711: l_po_changes := PO_CHANGES_REC_TYPE.create_object(
1712: p_po_header_id => p_po_header_id,
1713: p_po_release_id => p_po_release_id);
1714:
1715: l_po_changes.shipment_changes.add_change(

Line 2158: TYPE pochanges_tbl IS TABLE OF PO_CHANGES_REC_TYPE INDEX BY BINARY_INTEGER;

2154: l_debugMsg VARCHAR2(240);
2155: l_msgCount NUMBER;
2156: l_msgData VARCHAR2(2000);
2157: indx NUMBER:=0;
2158: TYPE pochanges_tbl IS TABLE OF PO_CHANGES_REC_TYPE INDEX BY BINARY_INTEGER;
2159: l_pochanges_tab pochanges_tbl; --Added for bug#14782614 to store the different POs
2160: l_po_changes PO_CHANGES_REC_TYPE;
2161: l_errors_rec PO_API_ERRORS_REC_TYPE;
2162: l_req_changes PO_REQ_CHANGES_REC_TYPE;

Line 2160: l_po_changes PO_CHANGES_REC_TYPE;

2156: l_msgData VARCHAR2(2000);
2157: indx NUMBER:=0;
2158: TYPE pochanges_tbl IS TABLE OF PO_CHANGES_REC_TYPE INDEX BY BINARY_INTEGER;
2159: l_pochanges_tab pochanges_tbl; --Added for bug#14782614 to store the different POs
2160: l_po_changes PO_CHANGES_REC_TYPE;
2161: l_errors_rec PO_API_ERRORS_REC_TYPE;
2162: l_req_changes PO_REQ_CHANGES_REC_TYPE;
2163: l_po_creation_time NUMBER;
2164: BEGIN

Line 2249: and if statement around PO_CHANGES_REC_TYPE call */

2245: -- Call an API to update QUANTITY at the distribution level.
2246: -- This API will recalculate the shipment and line quantity
2247: -- automatically.
2248: /* Added for FP bug 10383628 - added l_update_po assign stmt
2249: and if statement around PO_CHANGES_REC_TYPE call */
2250: if l_po_changes is NULL OR l_po_changes.po_header_id<>l_update_po_qty.po_header_id then
2251: l_po_changes := PO_CHANGES_REC_TYPE.create_object(
2252: p_po_header_id => l_update_po_qty.po_header_id,
2253: p_po_release_id => l_update_po_qty.po_release_id);

Line 2251: l_po_changes := PO_CHANGES_REC_TYPE.create_object(

2247: -- automatically.
2248: /* Added for FP bug 10383628 - added l_update_po assign stmt
2249: and if statement around PO_CHANGES_REC_TYPE call */
2250: if l_po_changes is NULL OR l_po_changes.po_header_id<>l_update_po_qty.po_header_id then
2251: l_po_changes := PO_CHANGES_REC_TYPE.create_object(
2252: p_po_header_id => l_update_po_qty.po_header_id,
2253: p_po_release_id => l_update_po_qty.po_release_id);
2254: indx:=indx+1;
2255: end if;