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);
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:
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;
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:
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: /****************************************************************************
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:
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"
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;
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: