[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: )
187: -- COMMENT : Get drop ship so line
188: --========================================================================
189: PROCEDURE Get_Dropship_SO_Line
190: (x_movement_transaction IN OUT NOCOPY
191: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
192: , x_drop_ship_source_id OUT NOCOPY NUMBER
193: , x_destination_org_id OUT NOCOPY NUMBER
194: )
195: IS
348: --========================================================================
349:
350: PROCEDURE Get_PO_Details
351: ( p_stat_typ_transaction IN
352: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
353: , x_movement_transaction IN OUT NOCOPY
354: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
355: , x_return_status OUT NOCOPY VARCHAR2
356: )
350: PROCEDURE Get_PO_Details
351: ( p_stat_typ_transaction IN
352: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
353: , x_movement_transaction IN OUT NOCOPY
354: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
355: , x_return_status OUT NOCOPY VARCHAR2
356: )
357: IS
358: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
354: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
355: , x_return_status OUT NOCOPY VARCHAR2
356: )
357: IS
358: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
359: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
360: l_rtv_code VARCHAR2(2);
361: l_rtv_eu_code VARCHAR2(3);
362: l_arrival_code VARCHAR2(3);
355: , x_return_status OUT NOCOPY VARCHAR2
356: )
357: IS
358: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
359: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
360: l_rtv_code VARCHAR2(2);
361: l_rtv_eu_code VARCHAR2(3);
362: l_arrival_code VARCHAR2(3);
363: l_arrival_eu_code VARCHAR2(3);
735: --========================================================================
736:
737: PROCEDURE Get_DropShipment_Details
738: ( p_stat_typ_transaction IN
739: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
740: , x_movement_transaction IN OUT NOCOPY
741: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
742: , x_return_status OUT NOCOPY VARCHAR2
743: )
737: PROCEDURE Get_DropShipment_Details
738: ( p_stat_typ_transaction IN
739: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
740: , x_movement_transaction IN OUT NOCOPY
741: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
742: , x_return_status OUT NOCOPY VARCHAR2
743: )
744: IS
745: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
741: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
742: , x_return_status OUT NOCOPY VARCHAR2
743: )
744: IS
745: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
746: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
747: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
748: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_DropShipment_Details';
749:
742: , x_return_status OUT NOCOPY VARCHAR2
743: )
744: IS
745: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
746: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
747: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
748: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_DropShipment_Details';
749:
750: CURSOR l_drpshp_so_om IS
743: )
744: IS
745: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
746: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
747: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
748: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_DropShipment_Details';
749:
750: CURSOR l_drpshp_so_om IS
751: SELECT
949: --========================================================================
950:
951: PROCEDURE Update_PO_Transactions
952: ( p_movement_transaction IN
953: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
954: , p_mvt_stat_status IN RCV_TRANSACTIONS.mvt_stat_status%TYPE /*Bug 7165989 */
955: , x_return_status OUT NOCOPY VARCHAR2
956: )
957: IS
954: , p_mvt_stat_status IN RCV_TRANSACTIONS.mvt_stat_status%TYPE /*Bug 7165989 */
955: , x_return_status OUT NOCOPY VARCHAR2
956: )
957: IS
958: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
959: l_procedure_name CONSTANT VARCHAR2(30) := 'Update_PO_Transactions';
960: BEGIN
961: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
962: THEN
1015: -- This opens the cursor for RTV and returns the cursor.
1016: --========================================================================
1017:
1018: PROCEDURE Get_RTV_Transactions
1019: ( rtv_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.rtvCurTyp
1020: , p_parent_id IN NUMBER
1021: , x_return_status OUT NOCOPY VARCHAR2
1022: )
1023: IS
1073: --=========================================================================
1074:
1075: PROCEDURE Get_Blanket_Info
1076: ( x_movement_transaction IN OUT NOCOPY
1077: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1078: )
1079: IS
1080: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1081: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Blanket_Info';
1076: ( x_movement_transaction IN OUT NOCOPY
1077: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1078: )
1079: IS
1080: l_movement_transaction INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type;
1081: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Blanket_Info';
1082:
1083: CURSOR l_bpo
1084: IS
1142: -- This opens the cursor for RMA and returns the cursor.
1143: --========================================================================
1144:
1145: PROCEDURE Get_RMA_Transactions
1146: ( rma_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.poCurTyp
1147: , p_movement_transaction IN
1148: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1149: , p_start_date IN DATE
1150: , p_end_date IN DATE
1144:
1145: PROCEDURE Get_RMA_Transactions
1146: ( rma_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.poCurTyp
1147: , p_movement_transaction IN
1148: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1149: , p_start_date IN DATE
1150: , p_end_date IN DATE
1151: , x_return_status OUT NOCOPY VARCHAR2
1152: )
1324: --========================================================================
1325:
1326: PROCEDURE Get_RMA_Details
1327: ( p_stat_typ_transaction IN
1328: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
1329: , x_movement_transaction IN OUT NOCOPY
1330: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1331: , x_return_status OUT NOCOPY VARCHAR2
1332: )
1326: PROCEDURE Get_RMA_Details
1327: ( p_stat_typ_transaction IN
1328: INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type
1329: , x_movement_transaction IN OUT NOCOPY
1330: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1331: , x_return_status OUT NOCOPY VARCHAR2
1332: )
1333: IS
1334: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
1330: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1331: , x_return_status OUT NOCOPY VARCHAR2
1332: )
1333: IS
1334: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
1335: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1336: l_order_uom OE_ORDER_LINES_ALL.Pricing_Quantity_Uom%TYPE;
1337: l_uom_conv_rate NUMBER;
1338: l_unit_price NUMBER;
1331: , x_return_status OUT NOCOPY VARCHAR2
1332: )
1333: IS
1334: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
1335: l_stat_typ_transaction INV_MGD_MVT_DATA_STR.Movement_Stat_Usages_Rec_Type;
1336: l_order_uom OE_ORDER_LINES_ALL.Pricing_Quantity_Uom%TYPE;
1337: l_uom_conv_rate NUMBER;
1338: l_unit_price NUMBER;
1339: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_RMA_Details';
1616: -- transaction id
1617: --========================================================================
1618: PROCEDURE Get_Parent_Mvt
1619: ( p_movement_transaction IN
1620: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1621: , p_rcv_transaction_id IN NUMBER
1622: , x_movement_id OUT NOCOPY NUMBER
1623: , x_movement_status OUT NOCOPY VARCHAR2
1624: , x_source_type OUT NOCOPY VARCHAR2
1665: -- This opens the cursor for IO arrival and returns the cursor.
1666: --========================================================================
1667:
1668: PROCEDURE Get_IO_Arrival_Txn
1669: ( io_arrival_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.poCurTyp
1670: , p_movement_transaction IN
1671: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1672: , p_start_date IN DATE
1673: , p_end_date IN DATE
1667:
1668: PROCEDURE Get_IO_Arrival_Txn
1669: ( io_arrival_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.poCurTyp
1670: , p_movement_transaction IN
1671: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1672: , p_start_date IN DATE
1673: , p_end_date IN DATE
1674: , x_return_status OUT NOCOPY VARCHAR2
1675: )
1770: --========================================================================
1771:
1772: PROCEDURE Get_IO_Arrival_Details
1773: ( x_movement_transaction IN OUT NOCOPY
1774: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
1775: , x_return_status OUT NOCOPY VARCHAR2
1776: )
1777: IS
1778: l_unit_of_measure rcv_transactions.unit_of_measure%TYPE;