[Home] [Help]
198: l_Instance_Query_Rec.Lot_Number := P_Item_Move_Attr_Rec.Lot_Number;
199: l_Instance_Query_Rec.Serial_Number := P_Item_Move_Attr_Rec.Serial_Number;
200: l_Instance_Query_Rec.Location_Id := l_From_Hz_Location_Id;
201: l_Instance_Query_Rec.Location_Type_Code:= l_from_Location_Type_Code;
202: l_Instance_Query_Rec.Instance_Usage_Code:=CSE_DATASTRUCTURES_PUB.G_OUT_OF_SERVICE;
203: l_Active_Instance_Only := FND_API.G_TRUE; --Added for bug 7423694, base bug 7233717
204:
205: IF (l_debug = 'Y') THEN
206: CSE_DEBUG_PUB.ADD(l_Api_Name||' Before CSI_Item_Instance_Pub.Get_Item_Instance');
303: l_Txn_Rec.Transaction_Type_Id := l_transaction_type_id;
304: l_Txn_Rec.Source_Group_Ref := P_Item_Move_Attr_Rec.Work_Order_Number;
305: l_Txn_Rec.Transaction_Quantity := P_Item_Move_Attr_Rec.Quantity;
306: l_Txn_Rec.Transacted_By := P_Item_Move_Attr_Rec.Transacted_By;
307: l_Txn_Rec.Transaction_Status_Code:= CSE_DATASTRUCTURES_PUB.G_PENDING;
308: l_Txn_Rec.Message_Id := P_Item_Move_Attr_Rec.Message_Id;
309:
310: IF NOT t_transaction_id = -1 THEN
311: l_txn_rec.transaction_id := t_transaction_id;
368: l_Instance_Query_Rec.Lot_Number := P_Item_Move_Attr_Rec.Lot_Number;
369: l_Instance_Query_Rec.Serial_Number := P_Item_Move_Attr_Rec.Serial_Number;
370: l_Instance_Query_Rec.Location_Id := l_To_Hz_Location_Id;
371: l_Instance_Query_Rec.Location_Type_Code:= l_to_Location_Type_Code;
372: l_Instance_Query_Rec.Instance_Usage_Code:=CSE_DATASTRUCTURES_PUB.G_OUT_OF_SERVICE;
373: l_Active_Instance_Only := FND_API.G_FALSE;
374:
375: IF (l_debug = 'Y') THEN
376: CSE_DEBUG_PUB.ADD('Before querying for the existence of destination record');
426: l_Txn_Rec.Source_Transaction_Date := P_Item_Move_Attr_Rec.Transaction_Date;
427: l_Txn_Rec.Source_Group_Ref := P_Item_Move_Attr_Rec.Work_Order_Number;
428: l_Txn_Rec.Transaction_Quantity := P_Item_Move_Attr_Rec.Quantity;
429: l_Txn_Rec.Transacted_By := P_Item_Move_Attr_Rec.Transacted_By;
430: l_Txn_Rec.Transaction_Status_Code := CSE_DATASTRUCTURES_PUB.G_PENDING;
431: l_Txn_Rec.Transaction_Action_Code := Null;
432: l_Txn_Rec.Message_Id := P_Item_Move_Attr_Rec.Message_Id;
433:
434: IF NOT t_transaction_id = -1 THEN
519: l_Txn_Rec.Source_Group_Ref := P_Item_Move_Attr_Rec.Work_Order_Number;
520: l_Txn_Rec.source_dist_ref_id2 :=l_upd_txn_rec.transaction_id;
521: l_Txn_Rec.Transaction_Quantity := P_Item_Move_Attr_Rec.Quantity;
522: l_Txn_Rec.Transacted_By := P_Item_Move_Attr_Rec.Transacted_By;
523: l_Txn_Rec.Transaction_Status_Code:= CSE_DATASTRUCTURES_PUB.G_PENDING;
524: l_Txn_Rec.Message_Id := P_Item_Move_Attr_Rec.Message_Id;
525:
526: IF NOT t_transaction_id = -1 THEN
527: l_txn_rec.transaction_id := t_transaction_id;
595: l_Instance_Rec.Merchant_View_Flag := 'Y';
596: l_Instance_Rec.Lot_Number := P_Item_Move_Attr_Rec.Lot_Number;
597: l_Instance_Rec.Quantity := P_Item_Move_Attr_Rec.Quantity;
598: l_Instance_Rec.Unit_Of_measure := l_Source_Unit_Of_Measure;
599: l_Instance_Rec.Instance_Usage_Code := CSE_DATASTRUCTURES_PUB.G_OUT_OF_SERVICE;
600: l_Instance_Rec.instance_status_id := l_s_status_id;
601: l_Instance_Rec.Location_Type_Code := l_to_Location_Type_Code;
602: l_Instance_Rec.Location_Id := l_To_Hz_Location_Id;
603: l_Instance_Rec.Install_Location_Type_Code := l_s_Install_Location_Type_Code;
614: l_Txn_Rec.Transaction_Type_Id := l_Transaction_type_id;
615: l_Txn_Rec.Source_Group_Ref := P_Item_Move_Attr_Rec.Work_Order_Number;
616: l_Txn_Rec.Transaction_Quantity := P_Item_Move_Attr_Rec.Quantity;
617: l_Txn_Rec.Transacted_By := P_Item_Move_Attr_Rec.Transacted_By;
618: l_Txn_Rec.Transaction_Status_Code := CSE_DATASTRUCTURES_PUB.G_PENDING;
619: l_Txn_Rec.Message_Id := P_Item_Move_Attr_Rec.Message_Id;
620:
621: IF NOT t_transaction_id = -1 THEN
622: l_txn_rec.transaction_id := t_transaction_id;