eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSE_PROJ_ITEM_UNINST_PKG dependencies on CSE_UTIL_PKG

Line 170: l_Transaction_Type_Id := CSE_UTIL_PKG.Get_Txn_Type_ID

166: elsif P_Proj_Item_Uninst_Attr_Rec.party_site_id is not null then
167: l_hz_location_id :=P_Proj_Item_Uninst_Attr_Rec.party_site_id ;
168: l_location_type_code:='HZ_PARTY_SITES';
169: end if;
170: l_Transaction_Type_Id := CSE_UTIL_PKG.Get_Txn_Type_ID
171: ('PROJECT_ITEM_UNINSTALLED',
172: l_App_Short_Name);
173:
174: IF (l_debug = 'Y') THEN

Line 185: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;

181: IF (l_debug = 'Y') THEN
182: CSE_DEBUG_PUB.ADD('Initailizing Query Record for the source item instance - step2');
183: END IF;
184:
185: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;
186: l_Instance_Query_Rec.Inventory_Item_Id:= P_Proj_Item_Uninst_Attr_Rec.Item_Id;
187: l_Instance_Query_Rec.Inventory_Revision:= P_Proj_Item_Uninst_Attr_Rec.Revision;
188: l_Instance_Query_Rec.Lot_Number := P_Proj_Item_Uninst_Attr_Rec.Lot_Number;
189: l_Instance_Query_Rec.Serial_Number:= P_Proj_Item_Uninst_Attr_Rec.Serial_Number;

Line 284: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

280: IF (l_debug = 'Y') THEN
281: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update of serialized item inst- step4');
282: END IF;
283:
284: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
285: l_Instance_Rec.Instance_Id :=l_Source_Instance_Id;
286: l_Instance_Rec.Instance_Usage_Code :=CSE_DATASTRUCTURES_PUB.G_IN_PROCESS;
287: l_Instance_Rec.Location_Type_Code :=CSE_UTIL_PKG.Get_Location_Type_Code('PROJECT');
288: l_Instance_Rec.Location_Id :=CSE_UTIL_PKG.Get_Dflt_Project_Location_Id;

Line 287: l_Instance_Rec.Location_Type_Code :=CSE_UTIL_PKG.Get_Location_Type_Code('PROJECT');

283:
284: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
285: l_Instance_Rec.Instance_Id :=l_Source_Instance_Id;
286: l_Instance_Rec.Instance_Usage_Code :=CSE_DATASTRUCTURES_PUB.G_IN_PROCESS;
287: l_Instance_Rec.Location_Type_Code :=CSE_UTIL_PKG.Get_Location_Type_Code('PROJECT');
288: l_Instance_Rec.Location_Id :=CSE_UTIL_PKG.Get_Dflt_Project_Location_Id;
289: l_Instance_Rec.Install_Location_Type_Code:=Null;
290: l_Instance_Rec.Install_Location_Id :=Null;
291: l_Instance_Rec.object_version_number :=l_S_object_version_number;

Line 288: l_Instance_Rec.Location_Id :=CSE_UTIL_PKG.Get_Dflt_Project_Location_Id;

284: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
285: l_Instance_Rec.Instance_Id :=l_Source_Instance_Id;
286: l_Instance_Rec.Instance_Usage_Code :=CSE_DATASTRUCTURES_PUB.G_IN_PROCESS;
287: l_Instance_Rec.Location_Type_Code :=CSE_UTIL_PKG.Get_Location_Type_Code('PROJECT');
288: l_Instance_Rec.Location_Id :=CSE_UTIL_PKG.Get_Dflt_Project_Location_Id;
289: l_Instance_Rec.Install_Location_Type_Code:=Null;
290: l_Instance_Rec.Install_Location_Id :=Null;
291: l_Instance_Rec.object_version_number :=l_S_object_version_number;
292: l_Instance_Rec.pa_project_id :=l_s_last_pa_project_id;

Line 296: l_Txn_Rec :=CSE_UTIL_PKG.Init_Txn_Rec;

292: l_Instance_Rec.pa_project_id :=l_s_last_pa_project_id;
293: l_Instance_Rec.pa_project_task_id :=l_s_last_pa_task_id;
294: l_Instance_Rec.last_pa_project_id :=null;
295: l_Instance_Rec.last_pa_task_id :=null;
296: l_Txn_Rec :=CSE_UTIL_PKG.Init_Txn_Rec;
297: l_Txn_Rec.Transaction_Date :=l_sysdate;
298: l_Txn_Rec.Source_Transaction_Date :=P_Proj_Item_Uninst_Attr_Rec.Transaction_Date;
299: l_Txn_Rec.Transaction_Type_Id :=l_Transaction_Type_Id;
300: l_Txn_Rec.Source_Group_Ref := P_Proj_Item_Uninst_Attr_Rec.Work_Order_Number;

Line 358: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;

354: IF (l_debug = 'Y') THEN
355: CSE_DEBUG_PUB.ADD('Initailizing Query Record for the destination instance - step5.1');
356: END IF;
357:
358: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;
359: l_Instance_Query_Rec.Inventory_Item_Id:= P_Proj_Item_Uninst_Attr_Rec.Item_Id;
360: l_Instance_Query_Rec.Inventory_Revision:= P_Proj_Item_Uninst_Attr_Rec.Revision;
361: l_Instance_Query_Rec.Lot_Number := P_Proj_Item_Uninst_Attr_Rec.Lot_Number;
362: l_Instance_Query_Rec.Serial_Number:= P_Proj_Item_Uninst_Attr_Rec.Serial_Number;

Line 410: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

406: IF (l_debug = 'Y') THEN
407: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update of source qty - step5.3');
408: END IF;
409:
410: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
411: l_Instance_Rec.Instance_Id := l_Source_instance_id;
412: l_Instance_Rec.Quantity := (l_Source_Quantity -
413: P_Proj_Item_Uninst_Attr_Rec.Quantity);
414: l_Instance_Rec.Active_End_Date :=Null;

Line 417: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

413: P_Proj_Item_Uninst_Attr_Rec.Quantity);
414: l_Instance_Rec.Active_End_Date :=Null;
415: l_Instance_Rec.Object_version_number :=l_S_object_version_number;
416: l_Party_tbl.delete;
417: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
418: l_Txn_Rec.Transaction_Date := l_sysdate;
419: l_Txn_Rec.Transaction_Type_Id := l_Transaction_Type_Id;
420: l_Txn_Rec.Source_Transaction_Date := P_Proj_Item_Uninst_Attr_Rec.Transaction_Date;
421: l_Txn_Rec.Source_Group_Ref := P_Proj_Item_Uninst_Attr_Rec.Work_Order_Number;

Line 473: cse_util_pkg.Get_Destination_Instance(

469: END IF;
470:
471: IF(l_Instance_Header_Tbl_Out.COUNT>0) THEN
472:
473: cse_util_pkg.Get_Destination_Instance(
474: P_Dest_Instance_tbl => l_Instance_Header_Tbl_Out,
475: X_Instance_Rec => l_Dest_Instance_Rec,
476: X_Return_Status => l_Return_Status,
477: X_Error_Message => l_Error_Message);

Line 493: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

489: IF (l_debug = 'Y') THEN
490: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update Of dest inst - step5.1');
491: END IF;
492:
493: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
494: l_Instance_Rec.Instance_Id := l_Dest_Instance_Rec.Instance_Id;
495: l_Instance_Rec.Quantity := (P_Proj_Item_Uninst_Attr_Rec.Quantity +
496: l_Dest_Instance_Rec.Quantity );
497: l_Instance_Rec.Active_End_Date := Null;

Line 509: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

505: THEN
506: l_Instance_Rec.instance_status_id :=l_s_status_id;
507: END IF;
508: END LOOP;
509: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
510: l_Txn_Rec.Transaction_Date := l_sysdate;
511: l_Txn_Rec.Source_Transaction_Date:= P_Proj_Item_Uninst_Attr_Rec.Transaction_Date;
512: l_Txn_Rec.Transaction_Type_Id := L_Transaction_Type_Id;
513: l_Txn_Rec.Source_Group_Ref := P_Proj_Item_Uninst_Attr_Rec.Work_Order_Number;