APPS.IEU_WORK_SOURCE_PVT dependencies on FND_GLOBAL

Line 76: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

72: x_return_status := fnd_api.g_ret_sts_success;
73: FND_MSG_PUB.initialize;
74: x_msg_data := '';
75: select to_char(sysdate, 'yyyy/mm/dd') into l_temp_date from dual;
76: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
77: -- for update description and dis function for not active case,
78: -- do not check ws object code
79: -- check ws object code only when deactive -> active
80: if (r_mode = 'update' ) then

Line 92: -- p_ws_not_valid_flag||', p_ws_id is '|| p_ws_id||' user_id is '|| fnd_global.user_id ||

88: validateObj(x_return_status, x_msg_count, x_msg_data, p_ws_name,p_ws_code, p_ws_parent_id, p_ws_child_id, r_mode);
89: end if;
90: IF (x_return_status = 'S') then
91: --x_msg_data := x_msg_data || 'validate is ok, dis function is '||p_ws_dis_func||', not_valid_flag is '||
92: -- p_ws_not_valid_flag||', p_ws_id is '|| p_ws_id||' user_id is '|| fnd_global.user_id ||
93: -- ' login id is '|| fnd_global.login_id || ', profile id is '||p_ws_profile_id||',profile is '||
94: -- p_ws_profile||' p_sqlValidation is '||p_sqlValidation;
95:
96: IF (r_mode = 'update') then

Line 93: -- ' login id is '|| fnd_global.login_id || ', profile id is '||p_ws_profile_id||',profile is '||

89: end if;
90: IF (x_return_status = 'S') then
91: --x_msg_data := x_msg_data || 'validate is ok, dis function is '||p_ws_dis_func||', not_valid_flag is '||
92: -- p_ws_not_valid_flag||', p_ws_id is '|| p_ws_id||' user_id is '|| fnd_global.user_id ||
93: -- ' login id is '|| fnd_global.login_id || ', profile id is '||p_ws_profile_id||',profile is '||
94: -- p_ws_profile||' p_sqlValidation is '||p_sqlValidation;
95:
96: IF (r_mode = 'update') then
97: IEU_UWQM_WORK_SOURCES_PKG.update_row(

Line 134: USING l_deactive_time,fnd_global.user_id,fnd_global.login_id,sysdate, p_ws_profile_id;

130: ' , last_update_login = :3 '||
131: ', last_update_date = :4 '||
132: ' where profile_option_name = :5 ';
133: EXECUTE IMMEDIATE sql_stmt
134: USING l_deactive_time,fnd_global.user_id,fnd_global.login_id,sysdate, p_ws_profile_id;
135: ELSE IF (l_ws_not_valid_flag = 'Y' and p_ws_not_valid_flag = 'N') then
136: sql_stmt := 'update FND_PROFILE_OPTIONS ' ||
137: ' set end_date_active= :1 '||
138: ' , last_updated_by = :2 '||

Line 143: USING l_end,fnd_global.user_id,fnd_global.login_id,sysdate, p_ws_profile_id;

139: ' , last_update_login = :3 '||
140: ', last_update_date = :4 '||
141: ' where profile_option_name = :5 ';
142: EXECUTE IMMEDIATE sql_stmt
143: USING l_end,fnd_global.user_id,fnd_global.login_id,sysdate, p_ws_profile_id;
144: END if;--active
145: end if;--deactive
146:
147: else-- create case

Line 155: x_owner => fnd_global.user_id,

151:
152: -- a. update/insert fnd_profile_options and fnd_profile_options_tl
153: FND_PROFILE_OPTIONS_PKG.LOAD_ROW (
154: x_profile_name => p_ws_profile_id ,
155: x_owner => fnd_global.user_id,
156: x_application_short_name => l_appl_short_name,
157: x_user_profile_option_name =>p_ws_profile,
158: x_description => null,
159: x_user_changeable_flag => l_no,

Line 274: INTO l_count USING p_ws_name, l_not_valid_flag, FND_GLOBAL.CURRENT_LANGUAGE ;

270: IF (r_mode = 'create') then
271: EXECUTE IMMEDIATE ' select count(*) from ieu_uwqm_work_sources_b b, ieu_uwqm_work_sources_tl tl '||
272: ' where upper(tl.ws_name) = upper(:1) and b.not_valid_flag=:2 ' ||
273: ' and b.ws_id = tl.ws_id and tl.language = :3 '
274: INTO l_count USING p_ws_name, l_not_valid_flag, FND_GLOBAL.CURRENT_LANGUAGE ;
275: IF (l_count > 0) then
276: x_return_status := fnd_api.g_ret_sts_error;
277: x_msg_count := x_msg_count+1;
278: x_msg_data :=x_msg_data||'IEU_PROV_WS_NAME_INVALID$';