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

Line 165: l_Transaction_Type_Id := CSE_UTIL_PKG.Get_Txn_Type_ID

161: elsif P_In_Service_Attr_Rec.party_site_id is not null then
162: l_hz_location_id :=P_In_Service_Attr_Rec.party_site_id ;
163: l_location_type_code:='HZ_PARTY_SITES';
164: end if;
165: l_Transaction_Type_Id := CSE_UTIL_PKG.Get_Txn_Type_ID
166: ('IN_SERVICE',
167: l_App_Short_Name);
168:
169: --Step 1, Get Hz Location id

Line 173: -- CSE_UTIL_PKG.Get_Hz_Location(

169: --Step 1, Get Hz Location id
170:
171: -- CSE_DEBUG_PUB.ADD('Calling get_hz_location');
172:
173: -- CSE_UTIL_PKG.Get_Hz_Location(
174: -- P_Network_Location_Code => l_Network_Location_Code,
175: -- X_Hz_Location_Id => l_Hz_Location_Id,
176: -- X_Return_Status => l_Return_Status,
177: -- X_Error_Message => l_Error_Message);

Line 189: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;

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

Line 299: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

295: IF (l_debug = 'Y') THEN
296: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update of serialized item inst- step4');
297: END IF;
298:
299: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
300: l_Instance_Rec.Instance_Id :=l_Source_Instance_Id;
301: l_Instance_Rec.Instance_Usage_Code:= CSE_DATASTRUCTURES_PUB.G_IN_SERVICE;
302: l_Instance_Rec.Object_version_number:=l_s_object_version_number;
303: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

Line 303: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

299: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
300: l_Instance_Rec.Instance_Id :=l_Source_Instance_Id;
301: l_Instance_Rec.Instance_Usage_Code:= CSE_DATASTRUCTURES_PUB.G_IN_SERVICE;
302: l_Instance_Rec.Object_version_number:=l_s_object_version_number;
303: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
304: l_Txn_Rec.Transaction_Date := l_sysdate;
305: l_Txn_Rec.Source_Transaction_Date:= p_In_Service_Attr_Rec.Transaction_Date;
306: l_Txn_Rec.Transaction_Type_Id := l_transaction_type_id;
307: l_Txn_Rec.Source_Group_Ref := P_In_Service_Attr_Rec.Work_Order_Number;

Line 367: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;

363: IF (l_debug = 'Y') THEN
364: CSE_DEBUG_PUB.ADD('NON Serialized Initailizing Query Record for the destination instance - step5.1');
365: END IF;
366:
367: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;
368: l_Instance_Query_Rec.Inventory_Item_Id := P_In_Service_Attr_Rec.Item_Id;
369: l_Instance_Query_Rec.Inventory_Revision:= P_In_Service_Attr_Rec.Revision;
370: l_Instance_Query_Rec.Lot_Number := P_In_Service_Attr_Rec.Lot_Number;
371: l_Instance_Query_Rec.Serial_Number := P_In_Service_Attr_Rec.Serial_Number;

Line 418: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

414: IF (l_debug = 'Y') THEN
415: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update of source qty - step5.3');
416: END IF;
417:
418: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
419: l_Instance_Rec.Instance_Id := l_Source_instance_id;
420: l_Instance_Rec.Quantity := (l_Source_Quantity -
421: P_In_Service_Attr_Rec.Quantity);
422: l_Instance_Rec.Active_End_Date :=Null;

Line 425: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

421: P_In_Service_Attr_Rec.Quantity);
422: l_Instance_Rec.Active_End_Date :=Null;
423: l_Instance_Rec.Object_version_number :=l_S_object_version_number;
424: l_Party_tbl.delete;
425: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
426: l_Txn_Rec.Transaction_Date := l_sysdate;
427: l_Txn_Rec.Transaction_Type_Id := l_Transaction_Type_Id;
428: l_Txn_Rec.Source_Transaction_Date := P_In_Service_Attr_Rec.Transaction_Date;
429: l_Txn_Rec.Source_Group_Ref := P_In_Service_Attr_Rec.Work_Order_Number;

Line 487: cse_util_pkg.Get_Destination_Instance(

483: IF (l_debug = 'Y') THEN
484: CSE_DEBUG_PUB.ADD('Before util.get_destination_instance');
485: END IF;
486:
487: cse_util_pkg.Get_Destination_Instance(
488: P_Dest_Instance_tbl => l_Instance_Header_Tbl_Out,
489: X_Instance_Rec => l_Dest_Instance_Rec,
490: X_Return_Status => l_Return_Status,
491: X_Error_Message => l_Error_Message);

Line 506: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

502: IF (l_debug = 'Y') THEN
503: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update Of dest inst - step5.1');
504: END IF;
505:
506: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
507: l_Instance_Rec.Instance_Id := l_Dest_Instance_Rec.Instance_Id;
508: l_Instance_Rec.Quantity := (P_In_Service_Attr_Rec.Quantity +
509: l_Dest_Instance_Rec.Quantity );
510: l_Instance_Rec.Active_End_Date := Null;

Line 521: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

517: THEN
518: l_Instance_Rec.instance_status_id :=l_s_status_id;
519: END IF;
520: END LOOP;
521: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
522: l_Txn_Rec.Transaction_Date := l_sysdate;
523: l_Txn_Rec.Source_Transaction_Date:= P_In_Service_Attr_Rec.Transaction_Date;
524: l_Txn_Rec.Transaction_Type_Id := l_Transaction_Type_Id;
525: l_Txn_Rec.Source_Group_Ref := P_In_Service_Attr_Rec.Work_Order_Number;

Line 599: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Create_Rec;

595: IF (l_debug = 'Y') THEN
596: CSE_DEBUG_PUB.ADD('Initailizing instance Record for the creation Of dest inst - step5.1');
597: END IF;
598:
599: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Create_Rec;
600: l_Instance_Rec.Inventory_Item_id := P_In_Service_Attr_Rec.Item_id;
601: l_Instance_Rec.Inventory_Revision := P_In_Service_Attr_Rec.Revision;
602: l_Instance_Rec.object_version_number :=l_object_version_number;
603: l_Instance_Rec.Inv_Master_Organization_Id := l_s_Inv_Master_Organization_Id;

Line 619: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;

615: l_Instance_Rec.Location_Type_Code := l_Location_Type_Code;
616: l_Instance_Rec.Location_Id := l_Hz_Location_Id;
617: l_Instance_Rec.Install_Location_Type_Code := l_s_Install_Location_Type_Code;
618: l_Instance_Rec.Install_Location_Id := l_s_Install_Location_Id;
619: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;
620: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;
621: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
622: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
623: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;

Line 620: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;

616: l_Instance_Rec.Location_Id := l_Hz_Location_Id;
617: l_Instance_Rec.Install_Location_Type_Code := l_s_Install_Location_Type_Code;
618: l_Instance_Rec.Install_Location_Id := l_s_Install_Location_Id;
619: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;
620: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;
621: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
622: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
623: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;
624: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;

Line 621: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;

617: l_Instance_Rec.Install_Location_Type_Code := l_s_Install_Location_Type_Code;
618: l_Instance_Rec.Install_Location_Id := l_s_Install_Location_Id;
619: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;
620: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;
621: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
622: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
623: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;
624: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;
625: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

Line 622: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;

618: l_Instance_Rec.Install_Location_Id := l_s_Install_Location_Id;
619: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;
620: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;
621: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
622: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
623: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;
624: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;
625: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
626: l_Txn_Rec.Transaction_Date := l_sysdate;

Line 623: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;

619: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;
620: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;
621: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
622: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
623: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;
624: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;
625: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
626: l_Txn_Rec.Transaction_Date := l_sysdate;
627: l_Txn_Rec.Source_Transaction_Date := P_In_Service_Attr_Rec.Transaction_Date;

Line 624: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;

620: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;
621: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
622: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
623: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;
624: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;
625: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
626: l_Txn_Rec.Transaction_Date := l_sysdate;
627: l_Txn_Rec.Source_Transaction_Date := P_In_Service_Attr_Rec.Transaction_Date;
628: l_Txn_Rec.Transaction_Type_Id := l_transaction_type_id;

Line 625: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

621: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
622: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
623: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;
624: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;
625: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
626: l_Txn_Rec.Transaction_Date := l_sysdate;
627: l_Txn_Rec.Source_Transaction_Date := P_In_Service_Attr_Rec.Transaction_Date;
628: l_Txn_Rec.Transaction_Type_Id := l_transaction_type_id;
629: l_Txn_Rec.Source_Group_Ref := P_In_Service_Attr_Rec.Work_Order_Number;