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

Line 149: l_Transaction_Type_Id := CSE_UTIL_PKG.Get_Txn_Type_ID

145: l_hz_location_id :=P_Proj_Item_Inst_Attr_Rec.party_site_id ;
146: l_location_type_code:='HZ_PARTY_SITES';
147: end if;
148:
149: l_Transaction_Type_Id := CSE_UTIL_PKG.Get_Txn_Type_ID
150: ('PROJECT_ITEM_INSTALLED',
151: l_App_Short_Name);
152:
153: -- If the option is set turn on the debug log.

Line 170: -- CSE_UTIL_PKG.Get_Hz_Location(

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

Line 182: CSE_DEBUG_PUB.ADD('before cse_util_pkg.check_depreciable');

178: -- END IF;
179:
180: --check whether the the item is depreciable
181: IF (l_debug = 'Y') THEN
182: CSE_DEBUG_PUB.ADD('before cse_util_pkg.check_depreciable');
183: END IF;
184: cse_util_pkg.check_depreciable(
185: p_inventory_item_id => P_Proj_Item_Inst_Attr_Rec.Item_Id,
186: p_depreciable =>l_depreciable);

Line 184: cse_util_pkg.check_depreciable(

180: --check whether the the item is depreciable
181: IF (l_debug = 'Y') THEN
182: CSE_DEBUG_PUB.ADD('before cse_util_pkg.check_depreciable');
183: END IF;
184: cse_util_pkg.check_depreciable(
185: p_inventory_item_id => P_Proj_Item_Inst_Attr_Rec.Item_Id,
186: p_depreciable =>l_depreciable);
187: IF l_depreciable='Y' THEN
188: IF (l_debug = 'Y') THEN

Line 205: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;

201: IF (l_debug = 'Y') THEN
202: CSE_DEBUG_PUB.ADD('Initailizing Query Record for the source item instance - step2');
203: END IF;
204:
205: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;
206: l_Instance_Query_Rec.Inventory_Item_Id := P_Proj_Item_Inst_Attr_Rec.Item_Id;
207: l_Instance_Query_Rec.Inventory_Revision:= P_Proj_Item_Inst_Attr_Rec.Revision;
208: l_Instance_Query_Rec.Lot_Number := P_Proj_Item_Inst_Attr_Rec.Lot_Number;
209: l_Instance_Query_Rec.Serial_Number:= P_Proj_Item_Inst_Attr_Rec.Serial_Number;

Line 306: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

302: IF (l_debug = 'Y') THEN
303: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update of serialized item inst- step4');
304: END IF;
305:
306: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
307: l_Instance_Rec.Instance_Id := l_Source_Instance_Id;
308: l_Instance_Rec.Instance_Usage_Code := CSE_DATASTRUCTURES_PUB.G_INSTALLED;
309: l_Instance_Rec.Install_Location_Type_Code:=l_Location_Type_Code;
310: l_Instance_Rec.Install_Location_Id :=l_Hz_Location_Id;

Line 318: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

314: l_Instance_Rec.pa_project_task_id :=null;
315: l_Instance_Rec.last_pa_project_id :=l_s_project_id;
316: l_Instance_Rec.last_pa_task_id :=l_s_task_id;
317: l_Instance_Rec.object_version_number :=l_S_object_version_number;
318: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
319: l_Txn_Rec.Transaction_Date := l_sysdate;
320: l_Txn_Rec.Source_transaction_date :=P_Proj_Item_Inst_Attr_Rec.Transaction_Date;
321: l_Txn_Rec.Transaction_Type_Id :=l_Transaction_Type_Id;
322: l_Txn_Rec.Source_Group_Ref:= P_Proj_Item_Inst_Attr_Rec.Work_Order_Number;

Line 386: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;

382: IF (l_debug = 'Y') THEN
383: CSE_DEBUG_PUB.ADD('Initailizing Query Record for the destination instance - step5.1');
384: END IF;
385:
386: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;
387: l_Instance_Query_Rec.Inventory_Item_Id := P_Proj_Item_Inst_Attr_Rec.Item_Id;
388: l_Instance_Query_Rec.Inventory_Revision:= P_Proj_Item_Inst_Attr_Rec.Revision;
389: l_Instance_Query_Rec.Lot_Number := P_Proj_Item_Inst_Attr_Rec.Lot_Number;
390: l_Instance_Query_Rec.Serial_Number:= P_Proj_Item_Inst_Attr_Rec.Serial_Number;

Line 438: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

434: IF (l_debug = 'Y') THEN
435: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update of source qty - step5.3');
436: END IF;
437:
438: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
439: l_Instance_Rec.Instance_Id := l_Source_instance_id;
440: l_Instance_Rec.Quantity := (l_Source_Quantity -
441: P_Proj_Item_Inst_Attr_Rec.Quantity);
442: l_Instance_Rec.Active_End_Date :=Null;

Line 445: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

441: P_Proj_Item_Inst_Attr_Rec.Quantity);
442: l_Instance_Rec.Active_End_Date :=Null;
443: l_Instance_Rec.Object_version_number :=l_S_object_version_number;
444: l_Party_tbl.delete;
445: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
446: l_Txn_Rec.Transaction_Date := l_sysdate;
447: l_Txn_Rec.Transaction_Type_Id := l_Transaction_Type_Id;
448: l_Txn_Rec.Source_Transaction_Date := P_Proj_Item_Inst_Attr_Rec.Transaction_Date;
449: l_Txn_Rec.Source_Group_Ref:= P_Proj_Item_Inst_Attr_Rec.Work_Order_Number;

Line 502: cse_util_pkg.get_destination_instance(

498: l_upd_txn_rec := l_txn_rec;
499:
500: IF(l_Instance_Header_Tbl_Out.COUNT>0) THEN
501:
502: cse_util_pkg.get_destination_instance(
503: P_Dest_Instance_tbl => l_Instance_Header_Tbl_Out,
504: X_Instance_Rec => l_Dest_Instance_Rec,
505: X_Return_Status => l_Return_Status,
506: X_Error_Message => l_Error_Message);

Line 524: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

520: IF (l_debug = 'Y') THEN
521: CSE_DEBUG_PUB.ADD('Initailizing instance Record for update Of dest inst - step5.1');
522: END IF;
523:
524: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
525: l_Instance_Rec.Instance_Id := l_Dest_Instance_Rec.Instance_Id;
526: l_Instance_Rec.Quantity := (P_Proj_Item_Inst_Attr_Rec.Quantity +
527: l_Dest_Instance_Rec.Quantity );
528: l_Instance_Rec.Active_End_Date := Null;

Line 540: l_Txn_Rec :=CSE_UTIL_PKG.Init_Txn_Rec;

536: THEN
537: l_Instance_Rec.instance_status_id :=l_s_status_id;
538: END IF;
539: END LOOP;
540: l_Txn_Rec :=CSE_UTIL_PKG.Init_Txn_Rec;
541: l_Txn_Rec.Transaction_Date :=l_sysdate;
542: l_Txn_Rec.Source_Transaction_Date :=P_Proj_Item_Inst_Attr_Rec.Transaction_Date;
543: l_Txn_Rec.Transaction_Type_Id :=L_Transaction_Type_Id;
544: l_Txn_Rec.Source_Group_Ref :=P_Proj_Item_Inst_Attr_Rec.Work_Order_Number;

Line 617: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Create_Rec;

613: IF (l_debug = 'Y') THEN
614: CSE_DEBUG_PUB.ADD('Initailizing instance Record for the creation Of dest inst - step5.1');
615: END IF;
616:
617: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Create_Rec;
618: l_Instance_Rec.Inventory_Item_id := P_Proj_Item_Inst_Attr_Rec.Item_id;
619: l_Instance_Rec.Inventory_Revision := P_Proj_Item_Inst_Attr_Rec.Revision;
620: l_Instance_Rec.Inv_Master_Organization_Id := l_s_Inv_Master_Organization_Id;
621: l_Instance_Rec.vld_organization_id := l_s_last_vld_organization_id;

Line 638: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;

634: l_Instance_Rec.Location_Type_Code := l_Location_Type_Code;
635: l_Instance_Rec.Location_Id := l_Hz_Location_Id;
636: l_Instance_Rec.Last_Pa_Project_Id :=P_Proj_Item_Inst_Attr_Rec.Project_Id;
637: l_Instance_Rec.Last_Pa_Task_Id := P_Proj_Item_Inst_Attr_Rec.Task_Id;
638: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;
639: l_party_tbl:= CSE_UTIL_PKG.Init_party_tbl;
640: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
641: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
642: l_org_assignments_tbl:= CSE_UTIL_PKG.Init_org_assignments_tbl;

Line 639: l_party_tbl:= CSE_UTIL_PKG.Init_party_tbl;

635: l_Instance_Rec.Location_Id := l_Hz_Location_Id;
636: l_Instance_Rec.Last_Pa_Project_Id :=P_Proj_Item_Inst_Attr_Rec.Project_Id;
637: l_Instance_Rec.Last_Pa_Task_Id := P_Proj_Item_Inst_Attr_Rec.Task_Id;
638: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;
639: l_party_tbl:= CSE_UTIL_PKG.Init_party_tbl;
640: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
641: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
642: l_org_assignments_tbl:= CSE_UTIL_PKG.Init_org_assignments_tbl;
643: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;

Line 640: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;

636: l_Instance_Rec.Last_Pa_Project_Id :=P_Proj_Item_Inst_Attr_Rec.Project_Id;
637: l_Instance_Rec.Last_Pa_Task_Id := P_Proj_Item_Inst_Attr_Rec.Task_Id;
638: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;
639: l_party_tbl:= CSE_UTIL_PKG.Init_party_tbl;
640: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
641: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
642: l_org_assignments_tbl:= CSE_UTIL_PKG.Init_org_assignments_tbl;
643: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;
644: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

Line 641: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;

637: l_Instance_Rec.Last_Pa_Task_Id := P_Proj_Item_Inst_Attr_Rec.Task_Id;
638: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;
639: l_party_tbl:= CSE_UTIL_PKG.Init_party_tbl;
640: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
641: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
642: l_org_assignments_tbl:= CSE_UTIL_PKG.Init_org_assignments_tbl;
643: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;
644: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
645: l_Txn_Rec.Transaction_Date := l_sysdate;

Line 642: l_org_assignments_tbl:= CSE_UTIL_PKG.Init_org_assignments_tbl;

638: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;
639: l_party_tbl:= CSE_UTIL_PKG.Init_party_tbl;
640: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
641: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
642: l_org_assignments_tbl:= CSE_UTIL_PKG.Init_org_assignments_tbl;
643: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;
644: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
645: l_Txn_Rec.Transaction_Date := l_sysdate;
646: l_Txn_Rec.Source_Transaction_Date := P_Proj_Item_Inst_Attr_Rec.Transaction_Date;

Line 643: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;

639: l_party_tbl:= CSE_UTIL_PKG.Init_party_tbl;
640: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
641: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
642: l_org_assignments_tbl:= CSE_UTIL_PKG.Init_org_assignments_tbl;
643: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;
644: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
645: l_Txn_Rec.Transaction_Date := l_sysdate;
646: l_Txn_Rec.Source_Transaction_Date := P_Proj_Item_Inst_Attr_Rec.Transaction_Date;
647: l_Txn_Rec.Transaction_Type_Id := l_transaction_type_id;

Line 644: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

640: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;
641: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;
642: l_org_assignments_tbl:= CSE_UTIL_PKG.Init_org_assignments_tbl;
643: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;
644: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;
645: l_Txn_Rec.Transaction_Date := l_sysdate;
646: l_Txn_Rec.Source_Transaction_Date := P_Proj_Item_Inst_Attr_Rec.Transaction_Date;
647: l_Txn_Rec.Transaction_Type_Id := l_transaction_type_id;
648: l_Txn_Rec.Source_Group_Ref:= P_Proj_Item_Inst_Attr_Rec.Work_Order_Number;