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 171: l_Transaction_Type_Id := CSE_UTIL_PKG.Get_Txn_Type_ID

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

Line 186: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;

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

Line 285: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

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

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

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

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

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

Line 297: l_Txn_Rec :=CSE_UTIL_PKG.Init_Txn_Rec;

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

Line 359: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;

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

Line 411: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

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

Line 418: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

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

Line 474: cse_util_pkg.Get_Destination_Instance(

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

Line 494: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

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

Line 510: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

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