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

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

Line 184: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;

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

Line 287: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

283: IF (l_debug = 'Y') THEN
284: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update of serialized item inst- step4');
285: END IF;
286:
287: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
288: l_Instance_Rec.Instance_Id :=l_Source_Instance_Id;
289: l_Instance_Rec.Instance_Usage_code:=CSE_DATASTRUCTURES_PUB.G_OUT_OF_SERVICE;
290: l_Instance_Rec.object_version_number:=l_s_object_version_number;
291: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

Line 291: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

287: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
288: l_Instance_Rec.Instance_Id :=l_Source_Instance_Id;
289: l_Instance_Rec.Instance_Usage_code:=CSE_DATASTRUCTURES_PUB.G_OUT_OF_SERVICE;
290: l_Instance_Rec.object_version_number:=l_s_object_version_number;
291: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
292: l_Txn_Rec.Transaction_Date := l_sysdate;
293: l_Txn_Rec.Source_Transaction_Date:= P_Out_Of_Service_Attr_Rec.Transaction_Date;
294: l_Txn_Rec.Transaction_Type_Id := l_Transaction_Type_Id;
295: l_Txn_Rec.Source_Group_Ref:= P_Out_Of_Service_Attr_Rec.Work_Order_Number;

Line 356: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;

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

Line 408: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

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

Line 415: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

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

Line 472: cse_util_pkg.Get_Destination_Instance(

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

Line 491: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

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

Line 507: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

503: THEN
504: l_Instance_Rec.instance_status_id :=l_s_status_id;
505: END IF;
506: END LOOP;
507: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
508: l_Txn_Rec.Transaction_Date := l_sysdate;
509: l_Txn_Rec.Source_Transaction_Date:= P_Out_Of_Service_Attr_Rec.Transaction_Date;
510: l_Txn_Rec.Transaction_Type_Id := l_transaction_type_id;
511: l_Txn_Rec.Source_Group_Ref := P_Out_Of_Service_Attr_Rec.Work_Order_Number;

Line 575: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Create_Rec;

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

Line 594: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;

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

Line 595: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;

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

Line 596: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;

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

Line 597: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;

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

Line 598: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;

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

Line 599: l_asset_assignment_tbl:= CSE_UTIL_PKG.Init_asset_assignment_tbl;

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

Line 600: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

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