[Home] [Help]
191: l_Instance_Query_Rec.Lot_Number := P_In_Service_Attr_Rec.Lot_Number;
192: l_Instance_Query_Rec.Serial_Number := P_In_Service_Attr_Rec.Serial_Number;
193: l_Instance_Query_Rec.Location_Id := l_Hz_Location_Id;
194: l_Instance_Query_Rec.Location_Type_Code:= l_Location_Type_Code;
195: l_Instance_Query_Rec.Instance_Usage_Code :=CSE_DATASTRUCTURES_PUB.G_OUT_OF_SERVICE;
196: l_Active_Instance_Only := FND_API.G_TRUE; --Added for bug 7423694, base bug 7233717
197:
198: IF (l_debug = 'Y') THEN
199: CSE_DEBUG_PUB.ADD(l_Api_Name||' Before CSI_Item_Instance_Pub.Get_Item_Instance');
296: END IF;
297:
298: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
299: l_Instance_Rec.Instance_Id :=l_Source_Instance_Id;
300: l_Instance_Rec.Instance_Usage_Code:= CSE_DATASTRUCTURES_PUB.G_IN_SERVICE;
301: l_Instance_Rec.Object_version_number:=l_s_object_version_number;
302: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
303: l_Txn_Rec.Transaction_Date := l_sysdate;
304: l_Txn_Rec.Source_Transaction_Date:= p_In_Service_Attr_Rec.Transaction_Date;
305: l_Txn_Rec.Transaction_Type_Id := l_transaction_type_id;
306: l_Txn_Rec.Source_Group_Ref := P_In_Service_Attr_Rec.Work_Order_Number;
307: l_Txn_Rec.Transaction_Quantity := P_In_Service_Attr_Rec.Quantity;
308: l_Txn_Rec.Transacted_By := P_In_Service_Attr_Rec.Transacted_By;
309: l_Txn_Rec.Transaction_Status_Code:= CSE_DATASTRUCTURES_PUB.G_PENDING;
310: l_Txn_Rec.Message_Id := P_In_Service_Attr_Rec.Message_Id;
311:
312: IF NOT t_transaction_id = -1 THEN
313: l_txn_rec.transaction_id := t_transaction_id;
369: l_Instance_Query_Rec.Lot_Number := P_In_Service_Attr_Rec.Lot_Number;
370: l_Instance_Query_Rec.Serial_Number := P_In_Service_Attr_Rec.Serial_Number;
371: l_Instance_Query_Rec.Location_Id := l_Hz_Location_Id;
372: l_Instance_Query_Rec.Location_Type_Code:= l_Location_Type_Code;
373: l_Instance_Query_Rec.Instance_Usage_Code:=CSE_DATASTRUCTURES_PUB.G_IN_SERVICE;
374: l_Active_Instance_Only := FND_API.G_FALSE;
375:
376: IF (l_debug = 'Y') THEN
377: CSE_DEBUG_PUB.ADD('Before querying for the existence of destination record');
427: l_Txn_Rec.Source_Transaction_Date := P_In_Service_Attr_Rec.Transaction_Date;
428: l_Txn_Rec.Source_Group_Ref := P_In_Service_Attr_Rec.Work_Order_Number;
429: l_Txn_Rec.Transaction_Quantity := P_In_Service_Attr_Rec.Quantity;
430: l_Txn_Rec.Transacted_By := P_In_Service_Attr_Rec.Transacted_By;
431: l_Txn_Rec.Transaction_Status_Code := CSE_DATASTRUCTURES_PUB.G_PENDING;
432: l_Txn_Rec.Transaction_Action_Code := Null;
433: l_Txn_Rec.Message_Id := P_In_Service_Attr_Rec.Message_Id;
434:
435: IF NOT t_transaction_id = -1 THEN
531: END IF;
532:
533: l_Txn_Rec.Transaction_Quantity := P_In_Service_Attr_Rec.Quantity;
534: l_Txn_Rec.Transacted_By := P_In_Service_Attr_Rec.Transacted_By;
535: l_Txn_Rec.Transaction_Status_Code:= CSE_DATASTRUCTURES_PUB.G_PENDING;
536: l_Txn_Rec.Message_Id := P_In_Service_Attr_Rec.Message_Id;
537: l_Txn_Rec.Object_Version_Number :=l_D_Object_version_number;
538: l_txn_rec.transaction_action_code :=NULL;
539:
608: l_Instance_Rec.Merchant_View_Flag := 'Y';
609: l_Instance_Rec.Lot_Number := P_In_Service_Attr_Rec.Lot_Number;
610: l_Instance_Rec.Quantity := P_In_Service_Attr_Rec.Quantity;
611: l_Instance_Rec.Unit_Of_measure := l_Source_Unit_Of_Measure;
612: l_Instance_Rec.Instance_Usage_Code:= CSE_DATASTRUCTURES_PUB.G_IN_SERVICE;
613: l_Instance_Rec.instance_status_id := l_s_status_id;
614: l_Instance_Rec.Location_Type_Code := l_Location_Type_Code;
615: l_Instance_Rec.Location_Id := l_Hz_Location_Id;
616: l_Instance_Rec.Install_Location_Type_Code := l_s_Install_Location_Type_Code;
635: END IF;
636:
637: l_Txn_Rec.Transaction_Quantity := P_In_Service_Attr_Rec.Quantity;
638: l_Txn_Rec.Transacted_By := P_In_Service_Attr_Rec.Transacted_By;
639: l_Txn_Rec.Transaction_Status_Code := CSE_DATASTRUCTURES_PUB.G_PENDING;
640: l_Txn_Rec.Message_Id := P_In_Service_Attr_Rec.Message_Id;
641:
642: IF (l_debug = 'Y') THEN
643: CSE_DEBUG_PUB.ADD('Before creation of destination instanace');