DBA Data[Home] [Help]

APPS.BOM_RTG_GLOBALS dependencies on FND_GLOBAL

Line 38: BOM_Rtg_Globals.Set_user_id( p_user_id => FND_GLOBAL.user_id);

34: , x_return_status IN OUT NOCOPY VARCHAR2
35: )
36: IS
37: BEGIN
38: BOM_Rtg_Globals.Set_user_id( p_user_id => FND_GLOBAL.user_id);
39: BOM_Rtg_Globals.Set_login_id( p_login_id => FND_GLOBAL.login_id);
40: BOM_Rtg_Globals.Set_prog_id( p_prog_id => FND_GLOBAL.conc_program_id);
41: BOM_Rtg_Globals.Set_prog_appid( p_prog_appid => FND_GLOBAL.prog_appl_id);
42: BOM_Rtg_Globals.Set_request_id( p_request_id => FND_GLOBAL.conc_request_id);

Line 39: BOM_Rtg_Globals.Set_login_id( p_login_id => FND_GLOBAL.login_id);

35: )
36: IS
37: BEGIN
38: BOM_Rtg_Globals.Set_user_id( p_user_id => FND_GLOBAL.user_id);
39: BOM_Rtg_Globals.Set_login_id( p_login_id => FND_GLOBAL.login_id);
40: BOM_Rtg_Globals.Set_prog_id( p_prog_id => FND_GLOBAL.conc_program_id);
41: BOM_Rtg_Globals.Set_prog_appid( p_prog_appid => FND_GLOBAL.prog_appl_id);
42: BOM_Rtg_Globals.Set_request_id( p_request_id => FND_GLOBAL.conc_request_id);
43:

Line 40: BOM_Rtg_Globals.Set_prog_id( p_prog_id => FND_GLOBAL.conc_program_id);

36: IS
37: BEGIN
38: BOM_Rtg_Globals.Set_user_id( p_user_id => FND_GLOBAL.user_id);
39: BOM_Rtg_Globals.Set_login_id( p_login_id => FND_GLOBAL.login_id);
40: BOM_Rtg_Globals.Set_prog_id( p_prog_id => FND_GLOBAL.conc_program_id);
41: BOM_Rtg_Globals.Set_prog_appid( p_prog_appid => FND_GLOBAL.prog_appl_id);
42: BOM_Rtg_Globals.Set_request_id( p_request_id => FND_GLOBAL.conc_request_id);
43:
44: END Init_System_Info_Rec;

Line 41: BOM_Rtg_Globals.Set_prog_appid( p_prog_appid => FND_GLOBAL.prog_appl_id);

37: BEGIN
38: BOM_Rtg_Globals.Set_user_id( p_user_id => FND_GLOBAL.user_id);
39: BOM_Rtg_Globals.Set_login_id( p_login_id => FND_GLOBAL.login_id);
40: BOM_Rtg_Globals.Set_prog_id( p_prog_id => FND_GLOBAL.conc_program_id);
41: BOM_Rtg_Globals.Set_prog_appid( p_prog_appid => FND_GLOBAL.prog_appl_id);
42: BOM_Rtg_Globals.Set_request_id( p_request_id => FND_GLOBAL.conc_request_id);
43:
44: END Init_System_Info_Rec;
45:

Line 42: BOM_Rtg_Globals.Set_request_id( p_request_id => FND_GLOBAL.conc_request_id);

38: BOM_Rtg_Globals.Set_user_id( p_user_id => FND_GLOBAL.user_id);
39: BOM_Rtg_Globals.Set_login_id( p_login_id => FND_GLOBAL.login_id);
40: BOM_Rtg_Globals.Set_prog_id( p_prog_id => FND_GLOBAL.conc_program_id);
41: BOM_Rtg_Globals.Set_prog_appid( p_prog_appid => FND_GLOBAL.prog_appl_id);
42: BOM_Rtg_Globals.Set_request_id( p_request_id => FND_GLOBAL.conc_request_id);
43:
44: END Init_System_Info_Rec;
45:
46: /****************************************************************************

Line 146: last_updated_by = FND_GLOBAL.USER_ID,

142: SET approval_status_type = 1,
143: approval_request_date = null,
144: approval_date = null,
145: last_update_date = SYSDATE,
146: last_updated_by = FND_GLOBAL.USER_ID,
147: last_update_login = FND_GLOBAL.LOGIN_ID
148: WHERE organization_id = p_organization_id
149: AND change_notice = p_change_notice;
150:

Line 147: last_update_login = FND_GLOBAL.LOGIN_ID

143: approval_request_date = null,
144: approval_date = null,
145: last_update_date = SYSDATE,
146: last_updated_by = FND_GLOBAL.USER_ID,
147: last_update_login = FND_GLOBAL.LOGIN_ID
148: WHERE organization_id = p_organization_id
149: AND change_notice = p_change_notice;
150:
151: -- Set all "Scheduled" revised items to "Open"

Line 156: last_updated_by = FND_GLOBAL.USER_ID,

152:
153: UPDATE eng_revised_items
154: SET status_type = 1,
155: last_update_date = SYSDATE,
156: last_updated_by = FND_GLOBAL.USER_ID,
157: last_update_login = FND_GLOBAL.LOGIN_ID
158: WHERE organization_id = p_organization_id
159: AND change_notice = p_change_notice
160: AND status_type = 4;

Line 157: last_update_login = FND_GLOBAL.LOGIN_ID

153: UPDATE eng_revised_items
154: SET status_type = 1,
155: last_update_date = SYSDATE,
156: last_updated_by = FND_GLOBAL.USER_ID,
157: last_update_login = FND_GLOBAL.LOGIN_ID
158: WHERE organization_id = p_organization_id
159: AND change_notice = p_change_notice
160: AND status_type = 4;
161: