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

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

Line 172: -- CSE_UTIL_PKG.Get_Hz_Location(

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

Line 188: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;

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

Line 298: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

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

Line 302: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

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

Line 366: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;

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

Line 417: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

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

Line 424: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

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

Line 486: cse_util_pkg.Get_Destination_Instance(

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

Line 505: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

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

Line 520: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

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

Line 598: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Create_Rec;

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

Line 618: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;

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

Line 619: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;

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

Line 620: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;

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

Line 621: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;

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

Line 622: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;

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

Line 623: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;

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

Line 624: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

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