44: -- This opens the cursor for SO and returns the cursor.
45: --========================================================================
46:
47: PROCEDURE Get_SO_Transactions
48: ( so_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.soCurTyp
49: , p_movement_transaction IN
50: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
51: , p_start_date IN DATE
52: , p_end_date IN DATE
46:
47: PROCEDURE Get_SO_Transactions
48: ( so_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.soCurTyp
49: , p_movement_transaction IN
50: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
51: , p_start_date IN DATE
52: , p_end_date IN DATE
53: , x_return_status OUT NOCOPY VARCHAR2
54: )
237: -- will be picked by the regular Get_SO_Transaction
238: --========================================================================
239:
240: PROCEDURE Get_Triangulation_Txns
241: ( sot_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.soCurTyp
242: , p_movement_transaction IN
243: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
244: , p_start_date IN DATE
245: , p_end_date IN DATE
239:
240: PROCEDURE Get_Triangulation_Txns
241: ( sot_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.soCurTyp
242: , p_movement_transaction IN
243: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
244: , p_start_date IN DATE
245: , p_end_date IN DATE
246: , x_return_status OUT NOCOPY VARCHAR2
247: )
345: -- COMMENT :
346: --========================================================================
347:
348: PROCEDURE Get_TwoLeOneCntry_Txns
349: ( sot_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.soCurTyp
350: , p_movement_transaction IN
351: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
352: , p_start_date IN DATE
353: , p_end_date IN DATE
347:
348: PROCEDURE Get_TwoLeOneCntry_Txns
349: ( sot_crsr IN OUT NOCOPY INV_MGD_MVT_DATA_STR.soCurTyp
350: , p_movement_transaction IN
351: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
352: , p_start_date IN DATE
353: , p_end_date IN DATE
354: , x_return_status OUT NOCOPY VARCHAR2
355: )
376: --========================================================================
377:
378: PROCEDURE Get_SO_Details
379: ( x_movement_transaction IN OUT NOCOPY
380: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
381: , x_return_status OUT NOCOPY VARCHAR2
382: )
383:
384: IS
381: , x_return_status OUT NOCOPY VARCHAR2
382: )
383:
384: IS
385: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
386: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
387: l_qty_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
388: l_currency_code OE_ORDER_HEADERS_ALL.Transactional_Curr_Code%TYPE;
389: l_error_code NUMBER;
723: --========================================================================
724: PROCEDURE Get_KIT_SO_Details
725: ( p_link_to_line_id IN VARCHAR2
726: , x_movement_transaction IN OUT NOCOPY
727: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
728: )
729: IS
730: l_unit_selling_price OE_ORDER_LINES_ALL.Unit_Selling_Price%TYPE;
731: l_order_uom OE_ORDER_LINES_ALL.order_Quantity_Uom%TYPE;
835: --========================================================================
836:
837: PROCEDURE Get_IO_Details
838: ( x_movement_transaction IN OUT NOCOPY
839: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
840: , x_return_status OUT NOCOPY VARCHAR2
841: )
842:
843: IS
949: --========================================================================
950:
951: PROCEDURE Update_SO_Transactions
952: ( p_movement_transaction IN
953: INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
954: , p_status IN VARCHAR2
955: , x_return_status OUT NOCOPY VARCHAR2
956: )
957: IS
954: , p_status IN VARCHAR2
955: , x_return_status OUT NOCOPY VARCHAR2
956: )
957: IS
958: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
959: l_mvt_stat_status wsh_delivery_details.mvt_stat_status%TYPE;
960: l_procedure_name CONSTANT VARCHAR2(30) := 'Update_SO_Transactions';
961: BEGIN
962: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1054: , p_status IN VARCHAR2
1055: , x_return_status OUT NOCOPY VARCHAR2
1056: )
1057: IS
1058: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1059: l_mvt_stat_status wsh_delivery_details.mvt_stat_status%TYPE;
1060: l_procedure_name CONSTANT VARCHAR2(30) := 'Update_KIT_SO_Transactions';
1061: BEGIN
1062: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)