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

Line 164: l_Transaction_Type_Id := CSE_UTIL_PKG.Get_Txn_Type_ID

160: CSE_DEBUG_PUB.ADD('**** ITEM MOVED TRANSACTION ******');
161: CSE_DEBUG_PUB.ADD('-----------------------------------------------');
162: END IF;
163:
164: l_Transaction_Type_Id := CSE_UTIL_PKG.Get_Txn_Type_ID
165: ('ITEM_MOVE',
166: l_App_Short_Name);
167: -- populate party_site_id and network_location_id
168: If (P_Item_Move_Attr_Rec.From_Network_Location_id is not null) then

Line 195: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;

191: IF (l_debug = 'Y') THEN
192: CSE_DEBUG_PUB.ADD('Initailizing Query Record for the source item instance - step2');
193: END IF;
194:
195: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;
196: l_Instance_Query_Rec.Inventory_Item_Id := P_Item_Move_Attr_Rec.Item_Id;
197: l_Instance_Query_Rec.Inventory_Revision:= P_Item_Move_Attr_Rec.Revision;
198: l_Instance_Query_Rec.Lot_Number := P_Item_Move_Attr_Rec.Lot_Number;
199: l_Instance_Query_Rec.Serial_Number := P_Item_Move_Attr_Rec.Serial_Number;

Line 295: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

291: IF (l_debug = 'Y') THEN
292: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update of serialized item inst- step4');
293: END IF;
294:
295: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
296: l_Instance_Rec.Instance_Id :=l_Source_Instance_Id;
297: l_Instance_Rec.Location_Id :=l_To_Hz_Location_Id;
298: l_Instance_Rec.Location_Type_Code:=l_to_Location_Type_Code;
299: l_Instance_Rec.object_version_number :=l_S_object_version_number;

Line 300: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

296: l_Instance_Rec.Instance_Id :=l_Source_Instance_Id;
297: l_Instance_Rec.Location_Id :=l_To_Hz_Location_Id;
298: l_Instance_Rec.Location_Type_Code:=l_to_Location_Type_Code;
299: l_Instance_Rec.object_version_number :=l_S_object_version_number;
300: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
301: l_Txn_Rec.Transaction_Date :=l_sysdate;
302: l_Txn_Rec.Source_Transaction_Date:=P_Item_Move_Attr_Rec.Transaction_Date;
303: l_Txn_Rec.Transaction_Type_Id := l_transaction_type_id;
304: l_Txn_Rec.Source_Group_Ref := P_Item_Move_Attr_Rec.Work_Order_Number;

Line 365: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;

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

Line 416: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

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

Line 423: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

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

Line 480: cse_util_pkg.Get_Destination_Instance(

476: END IF;
477:
478: IF(l_Instance_Header_Tbl_Out.COUNT>0) THEN
479:
480: cse_util_pkg.Get_Destination_Instance(
481: P_Dest_Instance_tbl => l_Instance_Header_Tbl_Out,
482: X_Instance_Rec => l_Dest_Instance_Rec,
483: X_Return_Status => l_Return_Status,
484: X_Error_Message => l_Error_Message);

Line 500: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

496: IF (l_debug = 'Y') THEN
497: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update Of dest inst - step5.1');
498: END IF;
499:
500: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
501: l_Instance_Rec.Instance_Id := l_Dest_Instance_Rec.Instance_Id;
502: l_Instance_Rec.Quantity := (P_Item_Move_Attr_Rec.Quantity +
503: l_Dest_Instance_Rec.Quantity );
504: l_Instance_Rec.Active_End_Date := Null;

Line 515: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

511: THEN
512: l_Instance_Rec.instance_status_id :=l_s_status_id;
513: END IF;
514: END LOOP;
515: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
516: l_Txn_Rec.Transaction_Date :=l_sysdate;
517: l_Txn_Rec.Source_Transaction_Date:=P_Item_Move_Attr_Rec.Transaction_Date;
518: l_Txn_Rec.Transaction_Type_Id := l_transaction_type_id;
519: l_Txn_Rec.Source_Group_Ref := P_Item_Move_Attr_Rec.Work_Order_Number;

Line 586: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Create_Rec;

582: IF (l_debug = 'Y') THEN
583: CSE_DEBUG_PUB.ADD('Initailizing instance Record for the creation Of dest inst - step5.1');
584: END IF;
585:
586: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Create_Rec;
587: l_Instance_Rec.Inventory_Item_id := P_Item_Move_Attr_Rec.Item_id;
588: l_Instance_Rec.Inventory_Revision:= P_Item_Move_Attr_Rec.Revision;
589: l_Instance_Rec.Inv_Master_Organization_Id := l_s_Inv_Master_Organization_Id;
590: l_Instance_Rec.vld_organization_id := l_s_last_vld_organization_id;

Line 605: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;

601: l_Instance_Rec.Location_Type_Code := l_to_Location_Type_Code;
602: l_Instance_Rec.Location_Id := l_To_Hz_Location_Id;
603: l_Instance_Rec.Install_Location_Type_Code := l_s_Install_Location_Type_Code;
604: l_Instance_Rec.Install_Location_Id := l_s_Install_Location_Id;
605: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;
606: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;
607: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
608: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
609: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;

Line 606: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;

602: l_Instance_Rec.Location_Id := l_To_Hz_Location_Id;
603: l_Instance_Rec.Install_Location_Type_Code := l_s_Install_Location_Type_Code;
604: l_Instance_Rec.Install_Location_Id := l_s_Install_Location_Id;
605: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;
606: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;
607: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
608: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
609: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;
610: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;

Line 607: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;

603: l_Instance_Rec.Install_Location_Type_Code := l_s_Install_Location_Type_Code;
604: l_Instance_Rec.Install_Location_Id := l_s_Install_Location_Id;
605: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;
606: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;
607: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
608: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
609: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;
610: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;
611: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

Line 608: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;

604: l_Instance_Rec.Install_Location_Id := l_s_Install_Location_Id;
605: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;
606: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;
607: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
608: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
609: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;
610: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;
611: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
612: l_Txn_Rec.Transaction_Date :=l_sysdate;

Line 609: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;

605: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;
606: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;
607: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
608: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
609: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;
610: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;
611: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
612: l_Txn_Rec.Transaction_Date :=l_sysdate;
613: l_Txn_Rec.Source_Transaction_Date:=P_Item_Move_Attr_Rec.Transaction_Date;

Line 610: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;

606: l_party_tbl := CSE_UTIL_PKG.Init_party_tbl;
607: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
608: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
609: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;
610: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;
611: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
612: l_Txn_Rec.Transaction_Date :=l_sysdate;
613: l_Txn_Rec.Source_Transaction_Date:=P_Item_Move_Attr_Rec.Transaction_Date;
614: l_Txn_Rec.Transaction_Type_Id := l_Transaction_type_id;

Line 611: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

607: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
608: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
609: l_org_assignments_tbl := CSE_UTIL_PKG.Init_org_assignments_tbl;
610: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;
611: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
612: l_Txn_Rec.Transaction_Date :=l_sysdate;
613: l_Txn_Rec.Source_Transaction_Date:=P_Item_Move_Attr_Rec.Transaction_Date;
614: l_Txn_Rec.Transaction_Type_Id := l_Transaction_type_id;
615: l_Txn_Rec.Source_Group_Ref := P_Item_Move_Attr_Rec.Work_Order_Number;