APPS.CSM_PROFILE_PKG dependencies on FND_PROFILE_OPTIONS

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 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 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 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;