DBA Data[Home] [Help]

APPS.CSE_OUT_OF_SERVICE_PKG dependencies on CSE_DATASTRUCTURES_PUB

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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