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

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

Line 169: -- CSE_UTIL_PKG.Get_Hz_Location(

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

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

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

Line 183: cse_util_pkg.check_depreciable(

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

Line 204: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;

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

Line 305: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

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

Line 317: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

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

Line 385: l_Instance_Query_Rec := CSE_UTIL_PKG.Init_Instance_Query_Rec;

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

Line 437: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

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

Line 444: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

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

Line 501: cse_util_pkg.get_destination_instance(

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

Line 523: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

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

Line 539: l_Txn_Rec :=CSE_UTIL_PKG.Init_Txn_Rec;

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

Line 616: l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Create_Rec;

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

Line 637: l_ext_attrib_values_tbl := CSE_UTIL_PKG.Init_ext_attrib_values_tbl;

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

Line 638: l_party_tbl:= CSE_UTIL_PKG.Init_party_tbl;

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

Line 639: l_account_tbl := CSE_UTIL_PKG.Init_account_tbl;

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

Line 640: l_pricing_attrib_tbl := CSE_UTIL_PKG.Init_pricing_attribs_tbl;

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

Line 641: l_org_assignments_tbl:= CSE_UTIL_PKG.Init_org_assignments_tbl;

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

Line 642: l_asset_assignment_tbl := CSE_UTIL_PKG.Init_asset_assignment_tbl;

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

Line 643: l_Txn_Rec := CSE_UTIL_PKG.Init_Txn_Rec;

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