DBA Data[Home] [Help]

APPS.CSE_OUT_OF_SERVICE_PKG dependencies on CSE_DATASTRUCTURES_PUB

Line 191: l_Instance_Query_Rec.Instance_Usage_Code:=CSE_DATASTRUCTURES_PUB.G_IN_SERVICE;

187: l_Instance_Query_Rec.Lot_Number := P_Out_Of_Service_Attr_Rec.Lot_Number;
188: l_Instance_Query_Rec.Serial_Number:= P_Out_Of_Service_Attr_Rec.Serial_Number;
189: l_Instance_Query_Rec.Location_Id := l_Hz_Location_Id;
190: l_Instance_Query_Rec.Location_Type_Code:= l_Location_Type_Code;
191: l_Instance_Query_Rec.Instance_Usage_Code:=CSE_DATASTRUCTURES_PUB.G_IN_SERVICE;
192:
193: IF (l_debug = 'Y') THEN
194: CSE_DEBUG_PUB.ADD(l_Api_Name||' Before CSI_Item_Instance_Pub.Get_Item_Instance');
195: END IF;

Line 289: l_Instance_Rec.Instance_Usage_code:=CSE_DATASTRUCTURES_PUB.G_OUT_OF_SERVICE;

285: END IF;
286:
287: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
288: l_Instance_Rec.Instance_Id :=l_Source_Instance_Id;
289: l_Instance_Rec.Instance_Usage_code:=CSE_DATASTRUCTURES_PUB.G_OUT_OF_SERVICE;
290: l_Instance_Rec.object_version_number:=l_s_object_version_number;
291: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
292: l_Txn_Rec.Transaction_Date := l_sysdate;
293: l_Txn_Rec.Source_Transaction_Date:= P_Out_Of_Service_Attr_Rec.Transaction_Date;

Line 298: l_Txn_Rec.Transaction_Status_Code:= CSE_DATASTRUCTURES_PUB.G_PENDING;

294: l_Txn_Rec.Transaction_Type_Id := l_Transaction_Type_Id;
295: l_Txn_Rec.Source_Group_Ref:= P_Out_Of_Service_Attr_Rec.Work_Order_Number;
296: l_Txn_Rec.Transaction_Quantity := P_Out_Of_Service_Attr_Rec.Quantity;
297: l_Txn_Rec.Transacted_By := P_Out_Of_Service_Attr_Rec.Transacted_By;
298: l_Txn_Rec.Transaction_Status_Code:= CSE_DATASTRUCTURES_PUB.G_PENDING;
299: l_Txn_Rec.Message_Id := P_Out_Of_Service_Attr_Rec.Message_Id;
300:
301: IF NOT t_transaction_id = -1 THEN
302: l_txn_rec.transaction_id := t_transaction_id;

Line 363: l_Instance_Query_Rec.Instance_Usage_Code:=CSE_DATASTRUCTURES_PUB.G_OUT_OF_SERVICE;

359: l_Instance_Query_Rec.Lot_Number := P_Out_Of_Service_Attr_Rec.Lot_Number;
360: l_Instance_Query_Rec.Serial_Number:= P_Out_Of_Service_Attr_Rec.Serial_Number;
361: l_Instance_Query_Rec.Location_Id := l_Hz_Location_Id;
362: l_Instance_Query_Rec.Location_Type_Code:= l_Location_Type_Code;
363: l_Instance_Query_Rec.Instance_Usage_Code:=CSE_DATASTRUCTURES_PUB.G_OUT_OF_SERVICE;
364: l_Active_Instance_Only:= FND_API.G_FALSE;
365:
366: IF (l_debug = 'Y') THEN
367: CSE_DEBUG_PUB.ADD('Before querying for the existence of destination record');

Line 422: l_Txn_Rec.Transaction_Status_Code := CSE_DATASTRUCTURES_PUB.G_PENDING;

418: l_Txn_Rec.Source_Transaction_Date:= P_Out_Of_Service_Attr_Rec.Transaction_Date;
419: l_Txn_Rec.Source_Group_Ref:= P_Out_Of_Service_Attr_Rec.Work_Order_Number;
420: l_Txn_Rec.Transaction_Quantity:= P_Out_Of_Service_Attr_Rec.Quantity;
421: l_Txn_Rec.Transacted_By := P_Out_Of_Service_Attr_Rec.Transacted_By;
422: l_Txn_Rec.Transaction_Status_Code := CSE_DATASTRUCTURES_PUB.G_PENDING;
423: l_Txn_Rec.Transaction_Action_Code := Null;
424: l_Txn_Rec.Message_Id := P_Out_Of_Service_Attr_Rec.Message_Id;
425:
426: IF NOT t_transaction_id = -1 THEN

Line 514: l_Txn_Rec.Transaction_Status_Code:= CSE_DATASTRUCTURES_PUB.G_PENDING;

510: l_Txn_Rec.Transaction_Type_Id := l_transaction_type_id;
511: l_Txn_Rec.Source_Group_Ref := P_Out_Of_Service_Attr_Rec.Work_Order_Number;
512: l_Txn_Rec.Transaction_Quantity := P_Out_Of_Service_Attr_Rec.Quantity;
513: l_Txn_Rec.Transacted_By := P_Out_Of_Service_Attr_Rec.Transacted_By;
514: l_Txn_Rec.Transaction_Status_Code:= CSE_DATASTRUCTURES_PUB.G_PENDING;
515: l_Txn_Rec.Message_Id := P_Out_Of_Service_Attr_Rec.Message_Id;
516:
517: IF NOT t_transaction_id = -1 THEN
518: l_txn_rec.transaction_id := t_transaction_id;

Line 587: l_Instance_Rec.Instance_Usage_Code := CSE_DATASTRUCTURES_PUB.G_OUT_OF_SERVICE;

583: l_Instance_Rec.Merchant_View_Flag := 'Y';
584: l_Instance_Rec.Lot_Number := P_Out_Of_Service_Attr_Rec.Lot_Number;
585: l_Instance_Rec.Quantity := P_Out_Of_Service_Attr_Rec.Quantity;
586: l_Instance_Rec.Unit_Of_measure := l_Source_Unit_Of_Measure;
587: l_Instance_Rec.Instance_Usage_Code := CSE_DATASTRUCTURES_PUB.G_OUT_OF_SERVICE;
588: l_Instance_Rec.instance_status_id := l_s_status_id;
589: l_Instance_Rec.Location_Type_Code := l_Location_Type_Code;
590: l_Instance_Rec.Location_Id := l_Hz_Location_Id;
591: l_Instance_Rec.Install_Location_Type_Code := l_s_Install_Location_Type_Code;

Line 608: l_Txn_Rec.Transaction_Status_Code := CSE_DATASTRUCTURES_PUB.G_PENDING;

604: l_Txn_Rec.Source_Group_Ref := P_Out_Of_Service_Attr_Rec.Work_Order_Number;
605: l_Txn_Rec.source_dist_ref_id2 :=l_upd_txn_rec.transaction_id;
606: l_Txn_Rec.Transaction_Quantity := P_Out_Of_Service_Attr_Rec.Quantity;
607: l_Txn_Rec.Transacted_By := P_Out_Of_Service_Attr_Rec.Transacted_By;
608: l_Txn_Rec.Transaction_Status_Code := CSE_DATASTRUCTURES_PUB.G_PENDING;
609: l_Txn_Rec.Message_Id := P_Out_Of_Service_Attr_Rec.Message_Id;
610:
611: IF NOT t_transaction_id = -1 THEN
612: l_txn_rec.transaction_id := t_transaction_id;