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_OUT_OF_SERVICE_PKG dependencies on CSE_UTIL_PKG

Line 175: l_Transaction_Type_Id := CSE_UTIL_PKG.Get_Txn_Type_ID

171: l_hz_location_id :=P_Out_Of_Service_Attr_Rec.party_site_id ;
172: l_location_type_code:='HZ_PARTY_SITES';
173: end if;
174:
175: l_Transaction_Type_Id := CSE_UTIL_PKG.Get_Txn_Type_ID
176: ('OUT_OF_SERVICE',
177: l_App_Short_Name);
178:
179: --Step 2, Query for the existence of the source record

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_Out_Of_Service_Attr_Rec.Item_Id;
187: l_Instance_Query_Rec.Inventory_Revision:= P_Out_Of_Service_Attr_Rec.Revision;
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;

Line 288: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

284: IF (l_debug = 'Y') THEN
285: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update of serialized item inst- step4');
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;

Line 292: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

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;
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;

Line 357: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;

353: IF (l_debug = 'Y') THEN
354: CSE_DEBUG_PUB.ADD('Initailizing Query Record for the destination instance - step5.1');
355: END IF;
356:
357: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;
358: l_Instance_Query_Rec.Inventory_Item_Id := P_Out_Of_Service_Attr_Rec.Item_Id;
359: l_Instance_Query_Rec.Inventory_Revision:= P_Out_Of_Service_Attr_Rec.Revision;
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;

Line 409: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

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

Line 416: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

412: P_Out_Of_Service_Attr_Rec.Quantity);
413: l_Instance_Rec.Active_End_Date :=Null;
414: l_Instance_Rec.Object_version_number :=l_S_object_version_number;
415: l_Party_tbl.delete;
416: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
417: l_Txn_Rec.Transaction_Date := l_sysdate;
418: l_Txn_Rec.Transaction_Type_Id := l_Transaction_Type_Id;
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;

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 492: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

488: l_D_object_version_number:=l_Dest_Instance_Rec.object_version_number;
489:
490: -- CSE_DEBUG_PUB.ADD('Initailizing instance Record for update Of dest inst - step5.1');
491:
492: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
493: l_Instance_Rec.Instance_Id := l_Dest_Instance_Rec.Instance_Id;
494: l_Instance_Rec.Quantity := (P_Out_Of_Service_Attr_Rec.Quantity +
495: l_Dest_Instance_Rec.Quantity );
496: l_Instance_Rec.Active_End_Date := Null;

Line 508: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

504: THEN
505: l_Instance_Rec.instance_status_id :=l_s_status_id;
506: END IF;
507: END LOOP;
508: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
509: l_Txn_Rec.Transaction_Date := l_sysdate;
510: l_Txn_Rec.Source_Transaction_Date:= P_Out_Of_Service_Attr_Rec.Transaction_Date;
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;

Line 576: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Create_Rec;

572: IF (l_debug = 'Y') THEN
573: CSE_DEBUG_PUB.ADD('Initailizing instance Record for the creation Of dest inst - step5.1');
574: END IF;
575:
576: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Create_Rec;
577: l_Instance_Rec.Inventory_Item_id := P_Out_Of_Service_Attr_Rec.Item_id;
578: l_Instance_Rec.Inventory_Revision := P_Out_Of_Service_Attr_Rec.Revision;
579: l_Instance_Rec.Inv_Master_Organization_Id := l_s_Inv_Master_Organization_Id;
580: l_Instance_Rec.Vld_organization_id := l_s_last_vld_organization_id ;

Line 595: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;

591: l_Instance_Rec.Location_Id := l_Hz_Location_Id;
592: l_Instance_Rec.Install_Location_Type_Code := l_s_Install_Location_Type_Code;
593: l_Instance_Rec.Install_Location_Id := l_s_Install_Location_Id;
594: l_Instance_Rec.object_version_number := l_object_version_number;
595: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;
596: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;
597: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
598: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
599: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;

Line 596: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;

592: l_Instance_Rec.Install_Location_Type_Code := l_s_Install_Location_Type_Code;
593: l_Instance_Rec.Install_Location_Id := l_s_Install_Location_Id;
594: l_Instance_Rec.object_version_number := l_object_version_number;
595: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;
596: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;
597: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
598: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
599: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;
600: l_asset_assignment_tbl:= CSE_UTIL_PKG.Init_asset_assignment_tbl;

Line 597: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;

593: l_Instance_Rec.Install_Location_Id := l_s_Install_Location_Id;
594: l_Instance_Rec.object_version_number := l_object_version_number;
595: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;
596: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;
597: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
598: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
599: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;
600: l_asset_assignment_tbl:= CSE_UTIL_PKG.Init_asset_assignment_tbl;
601: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

Line 598: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;

594: l_Instance_Rec.object_version_number := l_object_version_number;
595: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;
596: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;
597: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
598: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
599: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;
600: l_asset_assignment_tbl:= CSE_UTIL_PKG.Init_asset_assignment_tbl;
601: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
602: l_Txn_Rec.Transaction_Date :=l_sysdate;

Line 599: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;

595: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;
596: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;
597: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
598: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
599: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;
600: l_asset_assignment_tbl:= CSE_UTIL_PKG.Init_asset_assignment_tbl;
601: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
602: l_Txn_Rec.Transaction_Date :=l_sysdate;
603: l_Txn_Rec.Source_Transaction_Date :=P_Out_Of_Service_Attr_Rec.Transaction_Date;

Line 600: l_asset_assignment_tbl:= CSE_UTIL_PKG.Init_asset_assignment_tbl;

596: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;
597: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
598: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
599: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;
600: l_asset_assignment_tbl:= CSE_UTIL_PKG.Init_asset_assignment_tbl;
601: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
602: l_Txn_Rec.Transaction_Date :=l_sysdate;
603: l_Txn_Rec.Source_Transaction_Date :=P_Out_Of_Service_Attr_Rec.Transaction_Date;
604: l_Txn_Rec.Transaction_Type_Id :=l_transaction_type_id;

Line 601: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

597: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
598: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
599: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;
600: l_asset_assignment_tbl:= CSE_UTIL_PKG.Init_asset_assignment_tbl;
601: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
602: l_Txn_Rec.Transaction_Date :=l_sysdate;
603: l_Txn_Rec.Source_Transaction_Date :=P_Out_Of_Service_Attr_Rec.Transaction_Date;
604: l_Txn_Rec.Transaction_Type_Id :=l_transaction_type_id;
605: l_Txn_Rec.Source_Group_Ref := P_Out_Of_Service_Attr_Rec.Work_Order_Number;