APPS.CSM_MULTI_MOBQRY_PKG dependencies on FND_PROFILE

Line 148: EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_LANGUAGE='''||fnd_profile.value_specific('ICX_LANGUAGE',l_user_id ,l_resp_id ,l_app_id)||'''';

144: select user_id,responsibility_id,app_id
145: into l_user_id ,l_resp_id ,l_app_id
146: from asg_user where user_name=p_user_name;
147:
148: EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_LANGUAGE='''||fnd_profile.value_specific('ICX_LANGUAGE',l_user_id ,l_resp_id ,l_app_id)||'''';
149:
150: l_result:=l_result||'';
151: FOR rec IN c_style
152: LOOP

Line 245: EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_LANGUAGE='''||fnd_profile.value_specific('ICX_LANGUAGE',l_user_id ,l_resp_id ,l_app_id)||'''';

241: p_result:='E:Passed TO Location is invalid.';
242: return;
243: END IF;
244:
245: EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_LANGUAGE='''||fnd_profile.value_specific('ICX_LANGUAGE',l_user_id ,l_resp_id ,l_app_id)||'''';
246:
247: FOR rec IN c_ship_methods(l_hr_loc_id)
248: LOOP
249: l_result:=l_result||'';

Line 1466: l_profile_value := TO_NUMBER(fnd_profile.value_specific('CS_INV_VALIDATION_ORG',asg_base.get_user_id(p_user_name),NULL,NULL));

1462: BEGIN
1463:
1464: CSM_UTIL_PKG.LOG('Entering q_available_parts for Item : ' ||P_ITEM_NAME, 'CSM_MULTI_MOBQRY_PKG.q_available_parts', FND_LOG.LEVEL_PROCEDURE);
1465:
1466: l_profile_value := TO_NUMBER(fnd_profile.value_specific('CS_INV_VALIDATION_ORG',asg_base.get_user_id(p_user_name),NULL,NULL));
1467:
1468: x_return_status := FND_API.G_RET_STS_SUCCESS;
1469:
1470: IF NOT CSM_HTML5_PKG.authenticate(p_user_name,p_password) THEN

Line 1708: || ''||to_char(fnd_profile.value('CSFW_DEFAULT_DISTANCE_UNIT'))||''

1704: || ''||to_char(r_get_ohq.ship_method_meaning)||''
1705: || ''||to_char(r_get_ohq.SHIPPING_COST)||''
1706: || ''||to_char(r_get_ohq.ARRIVAL_DATE)||''
1707: || ''||to_char(r_get_ohq.DISTANCE)||''
1708: || ''||to_char(fnd_profile.value('CSFW_DEFAULT_DISTANCE_UNIT'))||''
1709: || ''||to_char(r_get_ohq.OPEN_OR_CLOSED)||''
1710: || ''||to_char(r_get_ohq.serial_number_control_code)||''
1711: || ' ';
1712: