DBA Data[Home] [Help]

APPS.CSE_PROJ_ITEM_INST_PKG dependencies on CSE_DATASTRUCTURES_PUB

Line 191: l_Transaction_Status_Code :=CSE_DATASTRUCTURES_PUB.G_PENDING;

187: IF l_depreciable='Y' THEN
188: IF (l_debug = 'Y') THEN
189: CSE_DEBUG_PUB.ADD('item is depreciable');
190: END IF;
191: l_Transaction_Status_Code :=CSE_DATASTRUCTURES_PUB.G_PENDING;
192: ELSE
193: IF (l_debug = 'Y') THEN
194: CSE_DEBUG_PUB.ADD('item is not depreciable');
195: END IF;

Line 196: l_Transaction_Status_Code :=CSE_DATASTRUCTURES_PUB.G_COMPLETE;

192: ELSE
193: IF (l_debug = 'Y') THEN
194: CSE_DEBUG_PUB.ADD('item is not depreciable');
195: END IF;
196: l_Transaction_Status_Code :=CSE_DATASTRUCTURES_PUB.G_COMPLETE;
197: END IF;
198:
199: --Step 2, Query for the existence of the source record
200:

Line 212: l_Instance_Query_Rec.Instance_Usage_Code:= CSE_DATASTRUCTURES_PUB.G_IN_PROCESS;

208: l_Instance_Query_Rec.Lot_Number := P_Proj_Item_Inst_Attr_Rec.Lot_Number;
209: l_Instance_Query_Rec.Serial_Number:= P_Proj_Item_Inst_Attr_Rec.Serial_Number;
210: l_Instance_Query_Rec.Pa_Project_Id:= P_Proj_Item_Inst_Attr_Rec.project_id;
211: l_Instance_Query_Rec.Pa_Project_Task_Id:= P_Proj_Item_Inst_Attr_Rec.Task_Id;
212: l_Instance_Query_Rec.Instance_Usage_Code:= CSE_DATASTRUCTURES_PUB.G_IN_PROCESS;
213:
214: IF (l_debug = 'Y') THEN
215: CSE_DEBUG_PUB.ADD(l_Api_Name||' Before CSI_Item_Instance_Pub.Get_Item_Instance');
216: END IF;

Line 308: l_Instance_Rec.Instance_Usage_Code := CSE_DATASTRUCTURES_PUB.G_INSTALLED;

304: END IF;
305:
306: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
307: l_Instance_Rec.Instance_Id := l_Source_Instance_Id;
308: l_Instance_Rec.Instance_Usage_Code := CSE_DATASTRUCTURES_PUB.G_INSTALLED;
309: l_Instance_Rec.Install_Location_Type_Code:=l_Location_Type_Code;
310: l_Instance_Rec.Install_Location_Id :=l_Hz_Location_Id;
311: l_Instance_Rec.Location_Type_Code :=l_Location_Type_Code;
312: l_Instance_Rec.Location_Id :=l_Hz_Location_Id;

Line 395: l_Instance_Query_Rec.Instance_Usage_Code:=CSE_DATASTRUCTURES_PUB.G_INSTALLED;

391: l_Instance_Query_Rec.last_Pa_Project_Id:= P_Proj_Item_Inst_Attr_Rec.project_id;
392: l_Instance_Query_Rec.last_pa_Task_Id := P_Proj_Item_Inst_Attr_Rec.Task_Id;
393: l_Instance_Query_Rec.Location_Id := l_Hz_Location_Id;
394: l_Instance_Query_Rec.Location_Type_Code:= l_Location_Type_Code;
395: l_Instance_Query_Rec.Instance_Usage_Code:=CSE_DATASTRUCTURES_PUB.G_INSTALLED;
396:
397: l_Active_Instance_Only := FND_API.G_FALSE;
398:
399: IF (l_debug = 'Y') THEN

Line 630: l_Instance_Rec.Instance_Usage_Code := CSE_DATASTRUCTURES_PUB.G_INSTALLED;

626: l_Instance_Rec.Merchant_View_Flag := 'Y';
627: l_Instance_Rec.Lot_Number := P_Proj_Item_Inst_Attr_Rec.Lot_Number;
628: l_Instance_Rec.Quantity := P_Proj_Item_Inst_Attr_Rec.Quantity;
629: l_Instance_Rec.Unit_Of_measure := l_Source_Unit_Of_Measure;
630: l_Instance_Rec.Instance_Usage_Code := CSE_DATASTRUCTURES_PUB.G_INSTALLED;
631: l_Instance_Rec.instance_status_id := l_s_status_id ;
632: l_Instance_Rec.Install_Location_Type_Code := l_Location_Type_Code;
633: l_Instance_Rec.Install_Location_Id := l_Hz_Location_Id;
634: l_Instance_Rec.Location_Type_Code := l_Location_Type_Code;