DBA Data[Home] [Help]

APPS.CSE_PROJ_ITEM_INST_PKG dependencies on CSE_DATASTRUCTURES_PUB

Line 190: l_Transaction_Status_Code :=CSE_DATASTRUCTURES_PUB.G_PENDING;

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

Line 195: l_Transaction_Status_Code :=CSE_DATASTRUCTURES_PUB.G_COMPLETE;

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

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

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

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

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

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

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

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

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