[Home] [Help]
74: l_profile_option_value NUMBER;
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';
103: l_profile_option_value NUMBER;
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';
133: l_profile_option_value NUMBER;
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';
163: l_profile_option_value NUMBER;
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';
193: l_profile_option_value NUMBER;
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';
295: l_profile_option_value NUMBER;
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';
323: l_profile_option_value NUMBER;
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';
372: l_profile_option_value NUMBER;
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';
402: l_profile_option_value NUMBER;
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';
437: l_profile_option_value NUMBER;
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';