[Home] [Help]
61: -- This opens the cursor for PO and returns the cursor.
62: --========================================================================
63:
64: PROCEDURE Get_PO_Transactions
65: ( po_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.poCurTyp
66: , p_movement_transaction IN
67: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
68: , p_start_date IN DATE
69: , p_end_date IN DATE
63:
64: PROCEDURE Get_PO_Transactions
65: ( po_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.poCurTyp
66: , p_movement_transaction IN
67: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
68: , p_start_date IN DATE
69: , p_end_date IN DATE
70: , x_return_status OUT NOCOPY VARCHAR2
71: )
181: -- COMMENT : Get drop ship so line
182: --========================================================================
183: PROCEDURE Get_Dropship_SO_Line
184: (x_movement_transaction IN OUT NOCOPY
185: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
186: , x_drop_ship_source_id OUT NOCOPY NUMBER
187: , x_destination_org_id OUT NOCOPY NUMBER
188: )
189: IS
342: --========================================================================
343:
344: PROCEDURE Get_PO_Details
345: ( p_stat_typ_transaction IN
346: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
347: , x_movement_transaction IN OUT NOCOPY
348: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
349: , x_return_status OUT NOCOPY VARCHAR2
350: )
344: PROCEDURE Get_PO_Details
345: ( p_stat_typ_transaction IN
346: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
347: , x_movement_transaction IN OUT NOCOPY
348: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
349: , x_return_status OUT NOCOPY VARCHAR2
350: )
351: IS
352: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
348: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
349: , x_return_status OUT NOCOPY VARCHAR2
350: )
351: IS
352: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
353: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
354: l_rtv_code VARCHAR2(2);
355: l_rtv_eu_code VARCHAR2(3);
356: l_arrival_code VARCHAR2(3);
349: , x_return_status OUT NOCOPY VARCHAR2
350: )
351: IS
352: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
353: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
354: l_rtv_code VARCHAR2(2);
355: l_rtv_eu_code VARCHAR2(3);
356: l_arrival_code VARCHAR2(3);
357: l_arrival_eu_code VARCHAR2(3);
701: --========================================================================
702:
703: PROCEDURE Get_DropShipment_Details
704: ( p_stat_typ_transaction IN
705: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
706: , x_movement_transaction IN OUT NOCOPY
707: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
708: , x_return_status OUT NOCOPY VARCHAR2
709: )
703: PROCEDURE Get_DropShipment_Details
704: ( p_stat_typ_transaction IN
705: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
706: , x_movement_transaction IN OUT NOCOPY
707: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
708: , x_return_status OUT NOCOPY VARCHAR2
709: )
710: IS
711: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
707: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
708: , x_return_status OUT NOCOPY VARCHAR2
709: )
710: IS
711: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
712: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
713: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
714: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_DropShipment_Details';
715:
708: , x_return_status OUT NOCOPY VARCHAR2
709: )
710: IS
711: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
712: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
713: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
714: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_DropShipment_Details';
715:
716: CURSOR l_drpshp_so_om IS
709: )
710: IS
711: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
712: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
713: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
714: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_DropShipment_Details';
715:
716: CURSOR l_drpshp_so_om IS
717: SELECT
870: --========================================================================
871:
872: PROCEDURE Update_PO_Transactions
873: ( p_movement_transaction IN
874: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
875: , p_mvt_stat_status IN RCV_TRANSACTIONS.mvt_stat_status%TYPE /*Bug 7165989 */
876: , x_return_status OUT NOCOPY VARCHAR2
877: )
878: IS
875: , p_mvt_stat_status IN RCV_TRANSACTIONS.mvt_stat_status%TYPE /*Bug 7165989 */
876: , x_return_status OUT NOCOPY VARCHAR2
877: )
878: IS
879: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
880: l_procedure_name CONSTANT VARCHAR2(30) := 'Update_PO_Transactions';
881: BEGIN
882: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
883: THEN
936: -- This opens the cursor for RTV and returns the cursor.
937: --========================================================================
938:
939: PROCEDURE Get_RTV_Transactions
940: ( rtv_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.rtvCurTyp
941: , p_parent_id IN NUMBER
942: , x_return_status OUT NOCOPY VARCHAR2
943: )
944: IS
994: --=========================================================================
995:
996: PROCEDURE Get_Blanket_Info
997: ( x_movement_transaction IN OUT NOCOPY
998: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
999: )
1000: IS
1001: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1002: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Blanket_Info';
997: ( x_movement_transaction IN OUT NOCOPY
998: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
999: )
1000: IS
1001: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1002: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Blanket_Info';
1003:
1004: CURSOR l_bpo
1005: IS
1063: -- This opens the cursor for RMA and returns the cursor.
1064: --========================================================================
1065:
1066: PROCEDURE Get_RMA_Transactions
1067: ( rma_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.poCurTyp
1068: , p_movement_transaction IN
1069: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1070: , p_start_date IN DATE
1071: , p_end_date IN DATE
1065:
1066: PROCEDURE Get_RMA_Transactions
1067: ( rma_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.poCurTyp
1068: , p_movement_transaction IN
1069: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1070: , p_start_date IN DATE
1071: , p_end_date IN DATE
1072: , x_return_status OUT NOCOPY VARCHAR2
1073: )
1235: --========================================================================
1236:
1237: PROCEDURE Get_RMA_Details
1238: ( p_stat_typ_transaction IN
1239: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
1240: , x_movement_transaction IN OUT NOCOPY
1241: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1242: , x_return_status OUT NOCOPY VARCHAR2
1243: )
1237: PROCEDURE Get_RMA_Details
1238: ( p_stat_typ_transaction IN
1239: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
1240: , x_movement_transaction IN OUT NOCOPY
1241: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1242: , x_return_status OUT NOCOPY VARCHAR2
1243: )
1244: IS
1245: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
1241: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1242: , x_return_status OUT NOCOPY VARCHAR2
1243: )
1244: IS
1245: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
1246: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1247: l_order_uom OE_ORDER_LINES_ALL.Pricing_Quantity_Uom%TYPE;
1248: l_uom_conv_rate NUMBER;
1249: l_unit_price NUMBER;
1242: , x_return_status OUT NOCOPY VARCHAR2
1243: )
1244: IS
1245: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
1246: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1247: l_order_uom OE_ORDER_LINES_ALL.Pricing_Quantity_Uom%TYPE;
1248: l_uom_conv_rate NUMBER;
1249: l_unit_price NUMBER;
1250: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_RMA_Details';
1461: -- transaction id
1462: --========================================================================
1463: PROCEDURE Get_Parent_Mvt
1464: ( p_movement_transaction IN
1465: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1466: , p_rcv_transaction_id IN NUMBER
1467: , x_movement_id OUT NOCOPY NUMBER
1468: , x_movement_status OUT NOCOPY VARCHAR2
1469: , x_source_type OUT NOCOPY VARCHAR2
1510: -- This opens the cursor for IO arrival and returns the cursor.
1511: --========================================================================
1512:
1513: PROCEDURE Get_IO_Arrival_Txn
1514: ( io_arrival_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.poCurTyp
1515: , p_movement_transaction IN
1516: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1517: , p_start_date IN DATE
1518: , p_end_date IN DATE
1512:
1513: PROCEDURE Get_IO_Arrival_Txn
1514: ( io_arrival_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.poCurTyp
1515: , p_movement_transaction IN
1516: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1517: , p_start_date IN DATE
1518: , p_end_date IN DATE
1519: , x_return_status OUT NOCOPY VARCHAR2
1520: )
1611: --========================================================================
1612:
1613: PROCEDURE Get_IO_Arrival_Details
1614: ( x_movement_transaction IN OUT NOCOPY
1615: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1616: , x_return_status OUT NOCOPY VARCHAR2
1617: )
1618: IS
1619: l_unit_of_measure rcv_transactions.unit_of_measure%TYPE;