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.BOM_BOM_REVISION_UTIL dependencies on FND_GLOBAL

Line 34: l_user_id NUMBER := FND_GLOBAL.User_Id;

30: )
31: IS
32: l_language_code VARCHAR2(3);
33: l_revision_id NUMBER;
34: l_user_id NUMBER := FND_GLOBAL.User_Id;
35: l_login_id NUMBER := FND_GLOBAL.Login_Id;
36: BEGIN
37: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
38: INSERT INTO MTL_ITEM_REVISIONS_B(

Line 35: l_login_id NUMBER := FND_GLOBAL.Login_Id;

31: IS
32: l_language_code VARCHAR2(3);
33: l_revision_id NUMBER;
34: l_user_id NUMBER := FND_GLOBAL.User_Id;
35: l_login_id NUMBER := FND_GLOBAL.Login_Id;
36: BEGIN
37: --bug:3254815 Update request id, prog id, prog appl id and prog update date.
38: INSERT INTO MTL_ITEM_REVISIONS_B(
39: inventory_item_id,

Line 107: Fnd_Global.Conc_Request_Id,

103: p_bom_revision_rec.Attribute15,
104: --p_bom_revision_rec.Description
105: mtl_item_revisions_b_s.NEXTVAL,
106: 1,
107: Fnd_Global.Conc_Request_Id,
108: Fnd_Global.Conc_Program_Id,
109: Fnd_Global.Prog_Appl_Id,
110: SYSDATE
111: ) RETURNING revision_id INTO l_revision_id;

Line 108: Fnd_Global.Conc_Program_Id,

104: --p_bom_revision_rec.Description
105: mtl_item_revisions_b_s.NEXTVAL,
106: 1,
107: Fnd_Global.Conc_Request_Id,
108: Fnd_Global.Conc_Program_Id,
109: Fnd_Global.Prog_Appl_Id,
110: SYSDATE
111: ) RETURNING revision_id INTO l_revision_id;
112:

Line 109: Fnd_Global.Prog_Appl_Id,

105: mtl_item_revisions_b_s.NEXTVAL,
106: 1,
107: Fnd_Global.Conc_Request_Id,
108: Fnd_Global.Conc_Program_Id,
109: Fnd_Global.Prog_Appl_Id,
110: SYSDATE
111: ) RETURNING revision_id INTO l_revision_id;
112:
113: SELECT userenv('LANG') INTO l_language_code FROM dual;

Line 181: l_user_id NUMBER := FND_GLOBAL.User_Id;

177: )
178: IS
179: l_language_code VARCHAR2(3);
180: l_revision_id NUMBER;
181: l_user_id NUMBER := FND_GLOBAL.User_Id;
182: l_login_id NUMBER := FND_GLOBAL.Login_Id;
183: BEGIN
184: UPDATE Mtl_Item_Revisions_b
185: SET --description = p_bom_revision_rec.Description,

Line 182: l_login_id NUMBER := FND_GLOBAL.Login_Id;

178: IS
179: l_language_code VARCHAR2(3);
180: l_revision_id NUMBER;
181: l_user_id NUMBER := FND_GLOBAL.User_Id;
182: l_login_id NUMBER := FND_GLOBAL.Login_Id;
183: BEGIN
184: UPDATE Mtl_Item_Revisions_b
185: SET --description = p_bom_revision_rec.Description,
186: effectivity_date = NVL(p_bom_revision_rec.start_effective_date,sysdate),--bug:4242412 Replace NULL effectivity date by SYSDATE

Line 209: request_id = Fnd_Global.Conc_Request_Id,

205: Attribute13 = p_bom_revision_rec.Attribute13,
206: Attribute14 = p_bom_revision_rec.Attribute14,
207: Attribute15 = p_bom_revision_rec.Attribute15,
208: object_version_number = object_version_number + 1,
209: request_id = Fnd_Global.Conc_Request_Id,
210: program_id = Fnd_Global.Conc_Program_Id,
211: program_application_id = Fnd_Global.Prog_Appl_Id,
212: program_update_date = SYSDATE
213: WHERE revision = p_bom_revision_rec.revision

Line 210: program_id = Fnd_Global.Conc_Program_Id,

206: Attribute14 = p_bom_revision_rec.Attribute14,
207: Attribute15 = p_bom_revision_rec.Attribute15,
208: object_version_number = object_version_number + 1,
209: request_id = Fnd_Global.Conc_Request_Id,
210: program_id = Fnd_Global.Conc_Program_Id,
211: program_application_id = Fnd_Global.Prog_Appl_Id,
212: program_update_date = SYSDATE
213: WHERE revision = p_bom_revision_rec.revision
214: AND inventory_item_id = p_bom_rev_unexp_rec.assembly_item_id

Line 211: program_application_id = Fnd_Global.Prog_Appl_Id,

207: Attribute15 = p_bom_revision_rec.Attribute15,
208: object_version_number = object_version_number + 1,
209: request_id = Fnd_Global.Conc_Request_Id,
210: program_id = Fnd_Global.Conc_Program_Id,
211: program_application_id = Fnd_Global.Prog_Appl_Id,
212: program_update_date = SYSDATE
213: WHERE revision = p_bom_revision_rec.revision
214: AND inventory_item_id = p_bom_rev_unexp_rec.assembly_item_id
215: AND organization_id = p_bom_rev_unexp_rec.organization_id