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 166: l_user_id NUMBER := FND_GLOBAL.User_Id;

162: )
163: IS
164: l_language_code VARCHAR2(3);
165: l_revision_id NUMBER;
166: l_user_id NUMBER := FND_GLOBAL.User_Id;
167: l_login_id NUMBER := FND_GLOBAL.Login_Id;
168: BEGIN
169: UPDATE Mtl_Item_Revisions_b
170: SET --description = p_bom_revision_rec.Description,

Line 167: l_login_id NUMBER := FND_GLOBAL.Login_Id;

163: IS
164: l_language_code VARCHAR2(3);
165: l_revision_id NUMBER;
166: l_user_id NUMBER := FND_GLOBAL.User_Id;
167: l_login_id NUMBER := FND_GLOBAL.Login_Id;
168: BEGIN
169: UPDATE Mtl_Item_Revisions_b
170: SET --description = p_bom_revision_rec.Description,
171: effectivity_date = NVL(p_bom_revision_rec.start_effective_date,sysdate),--bug:4242412 Replace NULL effectivity date by SYSDATE

Line 194: request_id = Fnd_Global.Conc_Request_Id,

190: Attribute13 = p_bom_revision_rec.Attribute13,
191: Attribute14 = p_bom_revision_rec.Attribute14,
192: Attribute15 = p_bom_revision_rec.Attribute15,
193: object_version_number = object_version_number + 1,
194: request_id = Fnd_Global.Conc_Request_Id,
195: program_id = Fnd_Global.Conc_Program_Id,
196: program_application_id = Fnd_Global.Prog_Appl_Id,
197: program_update_date = SYSDATE
198: WHERE revision = p_bom_revision_rec.revision

Line 195: program_id = Fnd_Global.Conc_Program_Id,

191: Attribute14 = p_bom_revision_rec.Attribute14,
192: Attribute15 = p_bom_revision_rec.Attribute15,
193: object_version_number = object_version_number + 1,
194: request_id = Fnd_Global.Conc_Request_Id,
195: program_id = Fnd_Global.Conc_Program_Id,
196: program_application_id = Fnd_Global.Prog_Appl_Id,
197: program_update_date = SYSDATE
198: WHERE revision = p_bom_revision_rec.revision
199: AND inventory_item_id = p_bom_rev_unexp_rec.assembly_item_id

Line 196: program_application_id = Fnd_Global.Prog_Appl_Id,

192: Attribute15 = p_bom_revision_rec.Attribute15,
193: object_version_number = object_version_number + 1,
194: request_id = Fnd_Global.Conc_Request_Id,
195: program_id = Fnd_Global.Conc_Program_Id,
196: program_application_id = Fnd_Global.Prog_Appl_Id,
197: program_update_date = SYSDATE
198: WHERE revision = p_bom_revision_rec.revision
199: AND inventory_item_id = p_bom_rev_unexp_rec.assembly_item_id
200: AND organization_id = p_bom_rev_unexp_rec.organization_id