eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_SUPPLY dependencies on PO_SUPPLY

Line 1: PACKAGE BODY PO_SUPPLY AS

1: PACKAGE BODY PO_SUPPLY AS
2: /* $Header: RCVRCSUB.pls 120.11.12010000.2 2008/09/01 09:49:28 sdpaul ship $ */
3:
4:
5:

Line 76: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.po_req_supply';

72: l_return_status VARCHAR2(1);
73: l_action VARCHAR2(200);
74: --
75:
76: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.po_req_supply';
77: d_progress NUMBER;
78: l_doc_id NUMBER;
79:
80: l_return_value BOOLEAN;

Line 166: ELSIF (p_action = 'Approve_PO_Supply') THEN

162: p_lineid => p_lineid
163: , p_receipt_date => p_receipt_date
164: );
165:
166: ELSIF (p_action = 'Approve_PO_Supply') THEN
167:
168: d_progress := 110;
169: l_return_value := approve_po_supply(p_docid => p_docid);
170:

Line 169: l_return_value := approve_po_supply(p_docid => p_docid);

165:
166: ELSIF (p_action = 'Approve_PO_Supply') THEN
167:
168: d_progress := 110;
169: l_return_value := approve_po_supply(p_docid => p_docid);
170:
171: ELSIF (p_action = 'Approve_Blanket_Release_Supply') THEN
172:
173: d_progress := 120;

Line 181: ELSIF (p_action = 'Create_PO_Supply') THEN

177:
178: d_progress := 130;
179: l_return_value := approve_planned_supply(p_docid => p_docid);
180:
181: ELSIF (p_action = 'Create_PO_Supply') THEN
182:
183: d_progress := 140;
184: l_return_value := create_po_supply(
185: p_entity_id => p_docid

Line 184: l_return_value := create_po_supply(

180:
181: ELSIF (p_action = 'Create_PO_Supply') THEN
182:
183: d_progress := 140;
184: l_return_value := create_po_supply(
185: p_entity_id => p_docid
186: , p_entity_type => 'PO'
187: );
188:

Line 192: l_return_value := create_po_supply(

188:
189: ELSIF (p_action = 'Create_Release_Supply') THEN
190:
191: d_progress := 150;
192: l_return_value := create_po_supply(
193: p_entity_id => p_docid
194: , p_entity_type => 'RELEASE'
195: );
196:

Line 200: l_return_value := create_po_supply(

196:
197: ELSIF (p_action = 'Create_PO_Line_Supply') THEN
198:
199: d_progress := 160;
200: l_return_value := create_po_supply(
201: p_entity_id => p_lineid
202: , p_entity_type => 'PO LINE'
203: );
204:

Line 208: l_return_value := create_po_supply(

204:
205: ELSIF (p_action = 'Create_PO_Shipment_Supply') THEN
206:
207: d_progress := 170;
208: l_return_value := create_po_supply(
209: p_entity_id => p_shipid
210: , p_entity_type => 'PO SHIPMENT'
211: );
212:

Line 216: l_return_value := create_po_supply(

212:
213: ELSIF (p_action = 'Create_Release_Shipment_Supply') THEN
214:
215: d_progress := 180;
216: l_return_value := create_po_supply(
217: p_entity_id => p_shipid
218: , p_entity_type => 'RELEASE SHIPMENT'
219: );
220:

Line 221: ELSIF (p_action = 'Remove_PO_Supply') THEN

217: p_entity_id => p_shipid
218: , p_entity_type => 'RELEASE SHIPMENT'
219: );
220:
221: ELSIF (p_action = 'Remove_PO_Supply') THEN
222:
223: d_progress := 190;
224: l_return_value := delete_supply(
225: p_entity_id => p_docid

Line 262: ELSIF (p_action = 'Cancel_PO_Supply') THEN

258: , p_entity_type => 'RELEASE SHIPMENT'
259: , p_shipid => p_shipid
260: );
261:
262: ELSIF (p_action = 'Cancel_PO_Supply') THEN
263:
264: d_progress := 240;
265: l_return_value := cancel_supply(
266: p_entity_id => p_docid

Line 410: ELSIF p_action NOT IN ( 'Remove_PO_Supply'

406: );
407:
408: --Bug5060175 END
409:
410: ELSIF p_action NOT IN ( 'Remove_PO_Supply'
411: ,'Remove_PO_Line_Supply'
412: ,'Remove_PO_Shipment_Supply'
413: ) THEN
414:

Line 486: FUNCTION approve_po_supply(p_docid IN NUMBER) RETURN BOOLEAN IS

482: /* */
483: /* ----------------------------------------------------------------------- */
484:
485:
486: FUNCTION approve_po_supply(p_docid IN NUMBER) RETURN BOOLEAN IS
487:
488: l_auth_status po_headers.authorization_status%TYPE;
489:
490: -- : This cursor was incorrectly accessing

Line 501: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.approve_po_supply';

497: SELECT poh.authorization_status
498: FROM po_headers_all poh
499: WHERE poh.po_header_id = header_id;
500:
501: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.approve_po_supply';
502: d_progress NUMBER;
503:
504: l_return_value BOOLEAN := FALSE;
505:

Line 523: -- Create PO Supply if the PO has been Approved

519: d_progress := 20;
520:
521: BEGIN
522:
523: -- Create PO Supply if the PO has been Approved
524:
525: IF (l_auth_status = 'APPROVED') THEN
526:
527: d_progress := 30;

Line 529: l_return_value := create_po_supply(

525: IF (l_auth_status = 'APPROVED') THEN
526:
527: d_progress := 30;
528:
529: l_return_value := create_po_supply(
530: p_entity_id => p_docid
531: , p_entity_type => 'PO'
532: );
533:

Line 537: PO_LOG.stmt(d_module, d_progress, 'create_po_supply not successful');

533:
534: IF (NOT l_return_value) THEN
535:
536: IF (PO_LOG.d_stmt) THEN
537: PO_LOG.stmt(d_module, d_progress, 'create_po_supply not successful');
538: END IF;
539:
540: RAISE PO_CORE_S.g_early_return_exc;
541: END IF;

Line 597: END approve_po_supply;

593: END IF;
594:
595: return(FALSE);
596:
597: END approve_po_supply;
598:
599:
600:
601: /* ----------------------------------------------------------------------- */

Line 621: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.approve_blanket_supply';

617: SELECT por.authorization_status
618: FROM po_releases_all por
619: WHERE por.po_release_id = release_id;
620:
621: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.approve_blanket_supply';
622: d_progress NUMBER;
623:
624: l_return_value BOOLEAN := FALSE;
625:

Line 649: l_return_value := create_po_supply(

645: IF (l_auth_status = 'APPROVED') THEN
646:
647: d_progress := 30;
648:
649: l_return_value := create_po_supply(
650: p_entity_id => p_docid
651: , p_entity_type => 'RELEASE'
652: );
653:

Line 657: PO_LOG.stmt(d_module, d_progress, 'create_po_supply not successful');

653:
654: IF (NOT l_return_value) THEN
655:
656: IF (PO_LOG.d_stmt) THEN
657: PO_LOG.stmt(d_module, d_progress, 'create_po_supply not successful');
658: END IF;
659:
660: RAISE PO_CORE_S.g_early_return_exc;
661: END IF;

Line 741: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.approve_planned_supply';

737: SELECT por.authorization_status, por.po_header_id
738: FROM po_releases_all por
739: WHERE por.po_release_id = release_id;
740:
741: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.approve_planned_supply';
742: d_progress NUMBER;
743:
744: l_return_value BOOLEAN := FALSE;
745:

Line 770: l_return_value := create_po_supply(

766: IF (l_auth_status = 'APPROVED') THEN
767:
768: d_progress := 30;
769:
770: l_return_value := create_po_supply(
771: p_entity_id => p_docid
772: , p_entity_type => 'RELEASE'
773: );
774:

Line 778: PO_LOG.stmt(d_module, d_progress, 'create_po_supply not successful');

774:
775: IF (NOT l_return_value) THEN
776:
777: IF (PO_LOG.d_stmt) THEN
778: PO_LOG.stmt(d_module, d_progress, 'create_po_supply not successful');
779: END IF;
780:
781: RAISE PO_CORE_S.g_early_return_exc;
782: END IF;

Line 788: -- Remove Planned PO Supply

784:
785: d_progress := 40;
786:
787:
788: -- Remove Planned PO Supply
789:
790: -- : Pro*C and existing code
791: -- conflicted in how planned PO supply was removed. The
792: -- Pro*C version was used. Calling create_supply will

Line 791: -- conflicted in how planned PO supply was removed. The

787:
788: -- Remove Planned PO Supply
789:
790: -- : Pro*C and existing code
791: -- conflicted in how planned PO supply was removed. The
792: -- Pro*C version was used. Calling create_supply will
793: -- do the necessary subtractions.
794:
795: l_return_value := create_po_supply(

Line 795: l_return_value := create_po_supply(

791: -- conflicted in how planned PO supply was removed. The
792: -- Pro*C version was used. Calling create_supply will
793: -- do the necessary subtractions.
794:
795: l_return_value := create_po_supply(
796: p_entity_id => l_po_header_id
797: , p_entity_type => 'PO'
798: );
799:

Line 803: PO_LOG.stmt(d_module, d_progress, 'create_po_supply not successful');

799:
800: IF (NOT l_return_value) THEN
801:
802: IF (PO_LOG.d_stmt) THEN
803: PO_LOG.stmt(d_module, d_progress, 'create_po_supply not successful');
804: END IF;
805:
806: RAISE PO_CORE_S.g_early_return_exc;
807: END IF;

Line 848: /* Create PO Supply */

844:
845:
846: /* ----------------------------------------------------------------------- */
847: /* */
848: /* Create PO Supply */
849: /* */
850: /* Insert new PO Supply into mtl_supply for Standard or Planned PO */
851: /* Approval, Blanket or Planned Release Approval, Standard or Planned */
852: /* PO Line Approval, Standard or Planned PO Shipment Approval, Blanket */

Line 850: /* Insert new PO Supply into mtl_supply for Standard or Planned PO */

846: /* ----------------------------------------------------------------------- */
847: /* */
848: /* Create PO Supply */
849: /* */
850: /* Insert new PO Supply into mtl_supply for Standard or Planned PO */
851: /* Approval, Blanket or Planned Release Approval, Standard or Planned */
852: /* PO Line Approval, Standard or Planned PO Shipment Approval, Blanket */
853: /* or Planned Release Shipment */
854: /* */

Line 855: /* New PO Supply is inserted based on Entity Type */

851: /* Approval, Blanket or Planned Release Approval, Standard or Planned */
852: /* PO Line Approval, Standard or Planned PO Shipment Approval, Blanket */
853: /* or Planned Release Shipment */
854: /* */
855: /* New PO Supply is inserted based on Entity Type */
856: /* */
857: /* Entity Type Action */
858: /* ----------- --------------------------------------------- */
859: /* PO New PO Supply for Standard or Planned PO */

Line 859: /* PO New PO Supply for Standard or Planned PO */

855: /* New PO Supply is inserted based on Entity Type */
856: /* */
857: /* Entity Type Action */
858: /* ----------- --------------------------------------------- */
859: /* PO New PO Supply for Standard or Planned PO */
860: /* Approval */
861: /* */
862: /* RELEASE New PO Supply for Blanket or Planned Release */
863: /* Approval */

Line 862: /* RELEASE New PO Supply for Blanket or Planned Release */

858: /* ----------- --------------------------------------------- */
859: /* PO New PO Supply for Standard or Planned PO */
860: /* Approval */
861: /* */
862: /* RELEASE New PO Supply for Blanket or Planned Release */
863: /* Approval */
864: /* */
865: /* PO LINE New PO Supply for Standard or Planned PO Line */
866: /* Approval */

Line 865: /* PO LINE New PO Supply for Standard or Planned PO Line */

861: /* */
862: /* RELEASE New PO Supply for Blanket or Planned Release */
863: /* Approval */
864: /* */
865: /* PO LINE New PO Supply for Standard or Planned PO Line */
866: /* Approval */
867: /* */
868: /* PO SHIPMENT New PO Supply for Standard or Planned PO */
869: /* Shipment Approval */

Line 868: /* PO SHIPMENT New PO Supply for Standard or Planned PO */

864: /* */
865: /* PO LINE New PO Supply for Standard or Planned PO Line */
866: /* Approval */
867: /* */
868: /* PO SHIPMENT New PO Supply for Standard or Planned PO */
869: /* Shipment Approval */
870: /* */
871: /* RELEASE New PO Supply for Blanket or Planned Release */
872: /* SHIPMENT Shipment */

Line 871: /* RELEASE New PO Supply for Blanket or Planned Release */

867: /* */
868: /* PO SHIPMENT New PO Supply for Standard or Planned PO */
869: /* Shipment Approval */
870: /* */
871: /* RELEASE New PO Supply for Blanket or Planned Release */
872: /* SHIPMENT Shipment */
873: /* */
874: /* ----------------------------------------------------------------------- */
875:

Line 876: -- : create_po_supply had conflicting logic in PO_SUPPLY

872: /* SHIPMENT Shipment */
873: /* */
874: /* ----------------------------------------------------------------------- */
875:
876: -- : create_po_supply had conflicting logic in PO_SUPPLY
877: -- vs. the Pro*C code. The latter is more accurate, so the method has been changed
878: -- to reflect the logic in Pro*C wherever there is a conflict.
879:
880: FUNCTION create_po_supply(

Line 880: FUNCTION create_po_supply(

876: -- : create_po_supply had conflicting logic in PO_SUPPLY
877: -- vs. the Pro*C code. The latter is more accurate, so the method has been changed
878: -- to reflect the logic in Pro*C wherever there is a conflict.
879:
880: FUNCTION create_po_supply(
881: p_entity_id IN NUMBER
882: , p_entity_type IN VARCHAR2
883: ) RETURN BOOLEAN
884: IS

Line 916: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.create_po_supply';

912: GROUP BY to_org_primary_uom, nvl(item_id, -1);
913:
914: l_prev_line_loc_id NUMBER := -9999;
915:
916: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.create_po_supply';
917: d_progress NUMBER;
918:
919: l_return_value BOOLEAN := FALSE;
920:

Line 1155: -- Create PO Supply

1151: PO_LOG.stmt(d_module, d_progress, 'l_supply_qty_in_pouom', l_supply_qty_in_pouom);
1152: PO_LOG.stmt(d_module, d_progress, 'l_out_poqty', l_out_poqty);
1153: END IF;
1154:
1155: -- Create PO Supply
1156: /*Bug 4537860:Hit the _all tables instead of the striped views.*/
1157:
1158: INSERT INTO mtl_supply(supply_type_code,
1159: supply_source_id,

Line 1276: END create_po_supply;

1272: END IF;
1273:
1274: return(FALSE);
1275:
1276: END create_po_supply;
1277:
1278:
1279: /* ----------------------------------------------------------------------- */
1280: /* */

Line 1283: /* New PO Supply is inserted based on Entity Type */

1279: /* ----------------------------------------------------------------------- */
1280: /* */
1281: /* Delete Supply for PO Header or PO Release */
1282: /* */
1283: /* New PO Supply is inserted based on Entity Type */
1284: /* */
1285: /* Entity Type Action */
1286: /* ----------- ----------------------------------------- */
1287: /* PO Remove PO Supply for PO Header */

Line 1287: /* PO Remove PO Supply for PO Header */

1283: /* New PO Supply is inserted based on Entity Type */
1284: /* */
1285: /* Entity Type Action */
1286: /* ----------- ----------------------------------------- */
1287: /* PO Remove PO Supply for PO Header */
1288: /* */
1289: /* RELEASE Remove PO Supply for PO Release */
1290: /* */
1291: /* PO LINE Remove PO Supply for PO Line */

Line 1289: /* RELEASE Remove PO Supply for PO Release */

1285: /* Entity Type Action */
1286: /* ----------- ----------------------------------------- */
1287: /* PO Remove PO Supply for PO Header */
1288: /* */
1289: /* RELEASE Remove PO Supply for PO Release */
1290: /* */
1291: /* PO LINE Remove PO Supply for PO Line */
1292: /* */
1293: /* PO SHIPMENT Remove PO Supply for PO Shipment */

Line 1291: /* PO LINE Remove PO Supply for PO Line */

1287: /* PO Remove PO Supply for PO Header */
1288: /* */
1289: /* RELEASE Remove PO Supply for PO Release */
1290: /* */
1291: /* PO LINE Remove PO Supply for PO Line */
1292: /* */
1293: /* PO SHIPMENT Remove PO Supply for PO Shipment */
1294: /* */
1295: /* RELEASE SHIPMENT Remove PO Supply for Release Shipment */

Line 1293: /* PO SHIPMENT Remove PO Supply for PO Shipment */

1289: /* RELEASE Remove PO Supply for PO Release */
1290: /* */
1291: /* PO LINE Remove PO Supply for PO Line */
1292: /* */
1293: /* PO SHIPMENT Remove PO Supply for PO Shipment */
1294: /* */
1295: /* RELEASE SHIPMENT Remove PO Supply for Release Shipment */
1296: /* */
1297: /* ----------------------------------------------------------------------- */

Line 1295: /* RELEASE SHIPMENT Remove PO Supply for Release Shipment */

1291: /* PO LINE Remove PO Supply for PO Line */
1292: /* */
1293: /* PO SHIPMENT Remove PO Supply for PO Shipment */
1294: /* */
1295: /* RELEASE SHIPMENT Remove PO Supply for Release Shipment */
1296: /* */
1297: /* ----------------------------------------------------------------------- */
1298:
1299:

Line 1306: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.delete_supply';

1302: , p_entity_type IN VARCHAR2
1303: ) RETURN BOOLEAN
1304: IS
1305:
1306: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.delete_supply';
1307: d_progress NUMBER;
1308:
1309: BEGIN
1310:

Line 1379: /* PO Supply is Updated based on the Entity Type */

1375: /* */
1376: /* Update Supply Quantity to 0 for PO Line, PO Shipment or Release */
1377: /* Shipment */
1378: /* */
1379: /* PO Supply is Updated based on the Entity Type */
1380: /* */
1381: /* Entity Type Action */
1382: /* ----------- --------------------------------------------- */
1383: /* PO LINE Update Supply Quantity for PO Line */

Line 1400: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.update_supply';

1396: , p_shipid IN NUMBER DEFAULT 0
1397: ) RETURN BOOLEAN
1398: IS
1399:
1400: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.update_supply';
1401: d_progress NUMBER;
1402:
1403: BEGIN
1404:

Line 1472: /* PO Supply is Cancelled based on Entity Type */

1468: /* ----------------------------------------------------------------------- */
1469: /* */
1470: /* Cancel Supply for PO Header, Line or Shipment */
1471: /* */
1472: /* PO Supply is Cancelled based on Entity Type */
1473: /* */
1474: /* Entity Type Action */
1475: /* ----------- --------------------------------------- */
1476: /* PO Cancel PO Supply for PO Header */

Line 1476: /* PO Cancel PO Supply for PO Header */

1472: /* PO Supply is Cancelled based on Entity Type */
1473: /* */
1474: /* Entity Type Action */
1475: /* ----------- --------------------------------------- */
1476: /* PO Cancel PO Supply for PO Header */
1477: /* */
1478: /* PO LINE Cancel PO Supply for PO Line */
1479: /* */
1480: /* PO SHIPMENT Cancel PO Supply for PO Shipment */

Line 1478: /* PO LINE Cancel PO Supply for PO Line */

1474: /* Entity Type Action */
1475: /* ----------- --------------------------------------- */
1476: /* PO Cancel PO Supply for PO Header */
1477: /* */
1478: /* PO LINE Cancel PO Supply for PO Line */
1479: /* */
1480: /* PO SHIPMENT Cancel PO Supply for PO Shipment */
1481: /* */
1482: /* RELEASE Cancel PO Supply for PO Release */

Line 1480: /* PO SHIPMENT Cancel PO Supply for PO Shipment */

1476: /* PO Cancel PO Supply for PO Header */
1477: /* */
1478: /* PO LINE Cancel PO Supply for PO Line */
1479: /* */
1480: /* PO SHIPMENT Cancel PO Supply for PO Shipment */
1481: /* */
1482: /* RELEASE Cancel PO Supply for PO Release */
1483: /* */
1484: /* RELEASE SHIPMENT Cancel PO Supply for Release Shipment */

Line 1482: /* RELEASE Cancel PO Supply for PO Release */

1478: /* PO LINE Cancel PO Supply for PO Line */
1479: /* */
1480: /* PO SHIPMENT Cancel PO Supply for PO Shipment */
1481: /* */
1482: /* RELEASE Cancel PO Supply for PO Release */
1483: /* */
1484: /* RELEASE SHIPMENT Cancel PO Supply for Release Shipment */
1485: /* */
1486: /* ----------------------------------------------------------------------- */

Line 1484: /* RELEASE SHIPMENT Cancel PO Supply for Release Shipment */

1480: /* PO SHIPMENT Cancel PO Supply for PO Shipment */
1481: /* */
1482: /* RELEASE Cancel PO Supply for PO Release */
1483: /* */
1484: /* RELEASE SHIPMENT Cancel PO Supply for Release Shipment */
1485: /* */
1486: /* ----------------------------------------------------------------------- */
1487:
1488: FUNCTION cancel_supply(

Line 1495: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.cancel_supply';

1491: , p_shipid IN NUMBER
1492: ) RETURN BOOLEAN
1493: IS
1494:
1495: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.cancel_supply';
1496: d_progress NUMBER;
1497:
1498: l_return_value BOOLEAN := FALSE;
1499:

Line 1512: -- the existing PO Supply

1508:
1509: d_progress := 10;
1510:
1511: -- Requisition Line Supply is created in Cancel PO Routine. We just remove
1512: -- the existing PO Supply
1513:
1514: IF (p_entity_type = 'PO') THEN
1515:
1516: l_return_value := delete_supply(

Line 1611: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.cancel_planned';

1607: SELECT por.po_header_id
1608: FROM po_releases_all por
1609: WHERE por.po_release_id = release_id;
1610:
1611: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.cancel_planned';
1612: d_progress NUMBER;
1613:
1614: l_return_value BOOLEAN := FALSE;
1615:

Line 1630: -- Remove Planned PO Supply

1626: d_progress := 10;
1627:
1628: BEGIN
1629:
1630: -- Remove Planned PO Supply
1631:
1632: IF (p_entity_type = 'RELEASE') THEN
1633:
1634: d_progress := 20;

Line 1654: -- Add to existing Planned PO Supply

1650: IF (p_recreate_flag) THEN
1651:
1652: d_progress := 30;
1653:
1654: -- Add to existing Planned PO Supply
1655:
1656: l_return_value := update_planned_po(
1657: p_docid => p_entity_id
1658: , p_entity_type => 'ADD PLANNED'

Line 1670: -- Insert Planned PO Supply if it does not exist

1666:
1667: RAISE PO_CORE_S.g_early_return_exc;
1668: END IF;
1669:
1670: -- Insert Planned PO Supply if it does not exist
1671:
1672: IF (NOT l_supply_flag) THEN
1673:
1674: d_progress := 40;

Line 1695: l_return_value := create_po_supply(

1691: CLOSE rel;
1692:
1693: d_progress := 60;
1694:
1695: l_return_value := create_po_supply(
1696: p_entity_id => p_entity_id
1697: , p_entity_type => 'PO'
1698: );
1699:

Line 1727: -- Add to existing Planned PO Supply

1723: IF (p_recreate_flag) THEN
1724:
1725: d_progress := 80;
1726:
1727: -- Add to existing Planned PO Supply
1728:
1729: l_return_value := update_planned_po(
1730: p_docid => p_entity_id
1731: , p_shipid => p_shipid

Line 1745: -- Insert Planned PO Supply if it does not exist

1741: RAISE PO_CORE_S.g_early_return_exc;
1742: END IF;
1743:
1744:
1745: -- Insert Planned PO Supply if it does not exist
1746:
1747: IF (NOT l_supply_flag) THEN
1748:
1749: d_progress := 90;

Line 1751: l_return_value := create_po_supply(

1747: IF (NOT l_supply_flag) THEN
1748:
1749: d_progress := 90;
1750:
1751: l_return_value := create_po_supply(
1752: p_entity_id => p_shipid
1753: , p_entity_type => 'PO SHIPMENT'
1754: );
1755:

Line 1854: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.maintain_mtl_supply';

1850: FROM mtl_system_items
1851: WHERE inventory_item_id = item_id
1852: AND organization_id = to_org;
1853:
1854: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.maintain_mtl_supply';
1855: d_progress NUMBER;
1856:
1857: BEGIN
1858:

Line 1997: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.approve_req';

1993: WHERE requisition_header_id = header_id;
1994:
1995: l_auth_status po_requisition_headers.authorization_status%TYPE;
1996:
1997: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.approve_req';
1998: d_progress NUMBER;
1999:
2000: l_return_value BOOLEAN := FALSE;
2001:

Line 2064: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.remove_req';

2060: , p_entity_type IN VARCHAR2
2061: ) RETURN BOOLEAN
2062: IS
2063:
2064: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.remove_req';
2065: d_progress NUMBER;
2066:
2067: BEGIN
2068:

Line 2131: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.remove_req_vend_lines';

2127:
2128:
2129: FUNCTION remove_req_vend_lines(p_docid IN NUMBER) RETURN BOOLEAN IS
2130:
2131: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.remove_req_vend_lines';
2132: d_progress NUMBER;
2133:
2134: BEGIN
2135:

Line 2195: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.create_req';

2191: , p_entity_type IN VARCHAR2
2192: ) RETURN BOOLEAN
2193: IS
2194:
2195: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.create_req';
2196: d_progress NUMBER;
2197:
2198: l_return_value BOOLEAN := FALSE;
2199:

Line 2412: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.explode';

2408: /* ----------------------------------------------------------------------- */
2409:
2410: FUNCTION explode(p_lineid IN NUMBER) RETURN BOOLEAN IS
2411:
2412: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.explode';
2413: d_progress NUMBER;
2414:
2415: l_return_value BOOLEAN := FALSE;
2416:

Line 2558: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.update_req_line_qty';

2554: , p_qty IN NUMBER
2555: ) RETURN BOOLEAN
2556: IS
2557:
2558: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.update_req_line_qty';
2559: d_progress NUMBER;
2560:
2561: BEGIN
2562:

Line 2613: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.update_req_line_date';

2609: , p_receipt_date IN DATE
2610: ) RETURN BOOLEAN
2611: IS
2612:
2613: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.update_req_line_date';
2614: d_progress NUMBER;
2615:
2616: BEGIN
2617:

Line 2684: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.update_planned_po';

2680: , p_supply_flag IN OUT NOCOPY BOOLEAN
2681: ) RETURN BOOLEAN
2682: IS
2683:
2684: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.update_planned_po';
2685: d_progress NUMBER;
2686:
2687: l_ppo_dist_id_tbl po_tbl_number;
2688: l_ppo_dist_qty_tbl po_tbl_number;

Line 2811: END PO_SUPPLY;

2807: END get_debug;
2808:
2809:
2810:
2811: END PO_SUPPLY;
2812: