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.CSM_PROFILE_PKG dependencies on FND_PROFILE

Line 52: l_retvalue := fnd_profile.value_specific(p_profile_option_name, l_user_id,

48: if p_responsibility_id is not null then
49: l_responsibility_id := p_responsibility_id;
50: end if;
51:
52: l_retvalue := fnd_profile.value_specific(p_profile_option_name, l_user_id,
53: l_responsibility_id, l_application_id);
54:
55: return l_retvalue;
56: end value_specific;

Line 64: -- return fnd_profile.value('ASO_PRODUCT_ORGANIZATION_ID');

60: p_application_id fnd_application.application_id%type default null)
61: return number
62: IS
63: begin
64: -- return fnd_profile.value('ASO_PRODUCT_ORGANIZATION_ID');
65: return value_specific('ASO_PRODUCT_ORGANIZATION_ID', p_user_id,
66: p_responsibility_id, p_application_id);
67: end get_master_organization_id;
68:

Line 79: fnd_profile_options po

75:
76: CURSOR l_profile_opt_value_csr(p_userid IN NUMBER) IS
77: SELECT acc.profile_option_value
78: FROM csm_profile_option_values_acc acc,
79: fnd_profile_options po
80: WHERE acc.user_id = p_user_id
81: AND acc.profile_option_id = po.profile_option_id
82: AND po.profile_option_name = 'CS_INV_VALIDATION_ORG';
83:

Line 108: fnd_profile_options po

104:
105: CURSOR l_profile_opt_value_csr(p_userid IN NUMBER) IS
106: SELECT acc.profile_option_value
107: FROM csm_profile_option_values_acc acc,
108: fnd_profile_options po
109: WHERE acc.user_id = p_user_id
110: AND acc.profile_option_id = po.profile_option_id
111: AND po.profile_option_name = 'CS_INV_VALIDATION_ORG';
112:

Line 138: fnd_profile_options po

134:
135: CURSOR l_profile_opt_value_csr(p_userid IN NUMBER) IS
136: SELECT acc.profile_option_value
137: FROM csm_profile_option_values_acc acc,
138: fnd_profile_options po
139: WHERE acc.user_id = p_user_id
140: AND acc.profile_option_id = po.profile_option_id
141: AND po.profile_option_name = 'CSM_ITEM_CATEGORY_SET_FILTER';
142:

Line 168: fnd_profile_options po

164:
165: CURSOR l_profile_opt_value_csr(p_userid IN NUMBER) IS
166: SELECT acc.profile_option_value
167: FROM csm_profile_option_values_acc acc,
168: fnd_profile_options po
169: WHERE acc.user_id = p_user_id
170: AND acc.profile_option_id = po.profile_option_id
171: AND po.profile_option_name = 'CSM_ITEM_CATEGORY_FILTER';
172:

Line 198: fnd_profile_options po

194:
195: CURSOR l_profile_opt_value_csr(p_userid IN NUMBER) IS
196: SELECT NVL(acc.profile_option_value,0)
197: FROM csm_profile_option_values_acc acc,
198: fnd_profile_options po
199: WHERE acc.user_id = p_user_id
200: AND acc.profile_option_id = po.profile_option_id
201: AND po.profile_option_name = 'CSM_HISTORY_COUNT';
202:

Line 243: FROM fnd_profile_options opt,

239: p_resp_level_value NUMBER,
240: p_user_level_value NUMBER
241: ) IS
242: SELECT val.profile_option_value
243: FROM fnd_profile_options opt,
244: fnd_profile_option_values val
245: WHERE NVL(opt.start_date_active, SYSDATE) <= SYSDATE
246: AND NVL(opt.end_date_active, SYSDATE) >= SYSDATE
247: AND opt.profile_option_name = p_profile_option_name

Line 244: fnd_profile_option_values val

240: p_user_level_value NUMBER
241: ) IS
242: SELECT val.profile_option_value
243: FROM fnd_profile_options opt,
244: fnd_profile_option_values val
245: WHERE NVL(opt.start_date_active, SYSDATE) <= SYSDATE
246: AND NVL(opt.end_date_active, SYSDATE) >= SYSDATE
247: AND opt.profile_option_name = p_profile_option_name
248: AND opt.application_id = val.application_id

Line 272: fnd_profile.GET(NAME => x_name, VAL => l_profile_option_value );

268: CLOSE c_profile;
269:
270: l_return_val := TO_NUMBER( l_profile_option_value);
271: IF l_return_val IS NULL AND x_site_level = TRUE THEN
272: fnd_profile.GET(NAME => x_name, VAL => l_profile_option_value );
273: l_return_val := TO_NUMBER(l_profile_option_value);
274: END IF;
275: RETURN l_return_val;
276: end GetProfileAt;

Line 300: fnd_profile_options po

296:
297: CURSOR l_profile_opt_value_csr(p_userid IN NUMBER) IS
298: SELECT acc.profile_option_value
299: FROM csm_profile_option_values_acc acc,
300: fnd_profile_options po
301: WHERE acc.user_id = p_user_id
302: AND acc.profile_option_id = po.profile_option_id
303: AND po.profile_option_name = 'CSF_M_CHANGE_COMPLETED_TASKS';
304:

Line 328: fnd_profile_options po

324:
325: CURSOR l_profile_opt_value_csr(p_userid IN NUMBER) IS
326: SELECT acc.profile_option_value
327: FROM csm_profile_option_values_acc acc,
328: fnd_profile_options po
329: WHERE acc.user_id = p_user_id
330: AND acc.profile_option_id = po.profile_option_id
331: AND po.profile_option_name = 'CSF_M_SHOW_NEW_MAIL_ONLY';
332:

Line 377: fnd_profile_options po

373:
374: CURSOR l_profile_opt_value_csr(p_userid IN NUMBER) IS
375: SELECT acc.profile_option_value
376: FROM csm_profile_option_values_acc acc,
377: fnd_profile_options po
378: WHERE acc.user_id = p_user_id
379: AND acc.profile_option_id = po.profile_option_id
380: AND po.profile_option_name = 'CSM_MAX_ATTACHMENT_SIZE';
381:

Line 407: fnd_profile_options po

403:
404: CURSOR l_profile_opt_value_csr(p_userid IN NUMBER) IS
405: SELECT NVL(acc.profile_option_value,0)
406: FROM csm_profile_option_values_acc acc,
407: fnd_profile_options po
408: WHERE acc.user_id = p_user_id
409: AND acc.profile_option_id = po.profile_option_id
410: AND po.profile_option_name = 'CSM_IB_ITEMS_AT_LOCATION';
411:

Line 442: fnd_profile_options po

438:
439: CURSOR l_profile_opt_value_csr(p_userid IN NUMBER) IS
440: SELECT NVL(acc.profile_option_value,3) -- download just 3 readings if profile is not set
441: FROM csm_profile_option_values_acc acc,
442: fnd_profile_options po
443: WHERE acc.user_id = p_user_id
444: AND acc.profile_option_id = po.profile_option_id
445: AND po.profile_option_name = 'CSM_MAX_READINGS_PER_COUNTER';
446:

Line 501: FROM FND_PROFILE_OPTION_VALUES val,

497:
498: CURSOR c_get_resp_value (c_resp_id NUMBER)
499: IS
500: SELECT val.PROFILE_OPTION_VALUE
501: FROM FND_PROFILE_OPTION_VALUES val,
502: FND_PROFILE_OPTIONS prf
503: WHERE prf.PROFILE_OPTION_ID = val.PROFILE_OPTION_ID
504: AND prf.PROFILE_OPTION_NAME = 'CSM_MOBILE_QUERY_SCHEMA'
505: AND LEVEL_ID = 10003

Line 502: FND_PROFILE_OPTIONS prf

498: CURSOR c_get_resp_value (c_resp_id NUMBER)
499: IS
500: SELECT val.PROFILE_OPTION_VALUE
501: FROM FND_PROFILE_OPTION_VALUES val,
502: FND_PROFILE_OPTIONS prf
503: WHERE prf.PROFILE_OPTION_ID = val.PROFILE_OPTION_ID
504: AND prf.PROFILE_OPTION_NAME = 'CSM_MOBILE_QUERY_SCHEMA'
505: AND LEVEL_ID = 10003
506: AND LEVEL_VALUE = c_resp_id;

Line 511: FROM FND_PROFILE_OPTION_VALUES val,

507:
508: CURSOR c_get_site_value
509: IS
510: SELECT val.PROFILE_OPTION_VALUE
511: FROM FND_PROFILE_OPTION_VALUES val,
512: FND_PROFILE_OPTIONS prf
513: WHERE prf.PROFILE_OPTION_ID = val.PROFILE_OPTION_ID
514: AND prf.PROFILE_OPTION_NAME = 'CSM_MOBILE_QUERY_SCHEMA'
515: AND LEVEL_ID = 10001

Line 512: FND_PROFILE_OPTIONS prf

508: CURSOR c_get_site_value
509: IS
510: SELECT val.PROFILE_OPTION_VALUE
511: FROM FND_PROFILE_OPTION_VALUES val,
512: FND_PROFILE_OPTIONS prf
513: WHERE prf.PROFILE_OPTION_ID = val.PROFILE_OPTION_ID
514: AND prf.PROFILE_OPTION_NAME = 'CSM_MOBILE_QUERY_SCHEMA'
515: AND LEVEL_ID = 10001
516: AND LEVEL_VALUE = 0;

Line 571: l_profile_option_value := fnd_profile.value_specific(l_profile_option_NAME, l_user_id,

567: CLOSE l_get_resp_id;
568:
569: END IF;
570:
571: l_profile_option_value := fnd_profile.value_specific(l_profile_option_NAME, l_user_id,
572: l_responsibility_id, l_application_id);
573: -- if profile is not set then return Null
574: RETURN l_profile_option_value;
575: