[Home] [Help]
1308: -- STEP V1: Check to see if user can execute the rule. In FEM.D, if a user
1309: -- can read a rule, then they can execute a rule.
1310: -- ============================================================================
1311: SELECT count(*) INTO v_count
1312: FROM fem_user_folders u, fem_object_catalog_b o
1313: WHERE o.object_id = p_object_id
1314: AND o.folder_id = u.folder_id
1315: AND u.user_id = pv_apps_user_id;
1316:
2394: -- cursor is used to validate the dependents. Use this query when
2395: -- p_preview_flag = 'N'
2396: CURSOR c3 IS
2397: SELECT d.dependent_request_id, d.dependent_object_id, u.folder_id
2398: FROM fem_ud_list_dependents d, fem_object_catalog_b o, fem_user_folders u
2399: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
2400: AND d.request_id = p_request_id
2401: AND d.object_id = p_object_id
2402: AND d.dependent_object_id = o.object_id
2407: -- cursor is used to validate the dependents. Use this query when
2408: -- p_preview_flag = 'Y'
2409: CURSOR c4 IS
2410: SELECT d.dependent_request_id, d.dependent_object_id, u.folder_id
2411: FROM fem_ud_prview_dependents d, fem_object_catalog_b o, fem_user_folders u
2412: WHERE d.ud_session_id = p_ud_session_id
2413: AND d.request_id = p_request_id
2414: AND d.object_id = p_object_id
2415: AND d.dependent_object_id = o.object_id
3065: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3066: p_msg_text => 'Checking to make sure user can read/execute the object');
3067:
3068: SELECT count(*) INTO v_count
3069: FROM fem_user_folders u, fem_object_catalog_b o
3070: WHERE o.object_id = a_candidate.object_id
3071: AND o.folder_id = u.folder_id
3072: AND u.user_id = pv_apps_user_id;
3073:
3166: p_module => 'fem.plsql.'||pc_pkg_name||'.'||c_api_name,
3167: p_msg_text => 'Checking to make sure user can read/execute the object');
3168:
3169: SELECT count(*) INTO v_count
3170: FROM fem_user_folders u, fem_object_catalog_b o
3171: WHERE o.object_id = a_candidate.object_id
3172: AND o.folder_id = u.folder_id
3173: AND u.user_id = pv_apps_user_id;
3174:
4587: -- BEGIN
4588:
4589: -- SELECT 'Y'
4590: -- INTO v_can_user_read_rule_flag
4591: -- FROM fem_object_catalog_b o, fem_user_folders u
4592: -- WHERE o.object_id = p_undo_list_obj_id
4593: -- AND o.folder_id = u.folder_id
4594: -- AND u.user_id = pv_apps_user_id;
4595:
5320: -- ============================================================================
5321: -- V01b: Check to make sure user can execute/read the object.
5322: -- ============================================================================
5323: SELECT count(*) INTO v_count
5324: FROM fem_user_folders u, fem_object_catalog_b o
5325: WHERE o.object_id = p_object_id
5326: AND o.folder_id = u.folder_id
5327: AND u.user_id = pv_apps_user_id;
5328:
5338: -- SELECT count(*)
5339: -- INTO v_count
5340: -- FROM fem_folders_b b
5341: -- WHERE b.folder_id = p_folder_id
5342: -- AND b.folder_id IN (SELECT u.folder_id FROM fem_user_folders u
5343: -- WHERE u.user_id = pv_apps_user_id
5344: -- AND u.write_flag = 'Y');
5345:
5346: -- IF v_count = 0 THEN
5693: -- SELECT count(*)
5694: -- INTO v_count
5695: -- FROM fem_folders_b b
5696: -- WHERE b.folder_id = p_folder_id
5697: -- AND b.folder_id IN (SELECT u.folder_id FROM fem_user_folders u
5698: -- WHERE u.user_id = pv_apps_user_id
5699: -- AND u.write_flag = 'Y');
5700:
5701: -- IF v_count = 0 THEN
5795: WHERE p.request_id = p_request_id
5796: AND p.object_id = o.object_id
5797: AND o.folder_id NOT IN
5798: (SELECT folder_id
5799: FROM fem_user_folders
5800: WHERE user_id = pv_apps_user_id);
5801:
5802: IF v_count > 0 THEN
5803: RAISE e_cannot_read_object;
6160: -- SELECT count(*)
6161: -- INTO v_count
6162: -- FROM fem_folders_b b
6163: -- WHERE b.folder_id = p_folder_id
6164: -- AND b.folder_id IN (SELECT u.folder_id FROM fem_user_folders u
6165: -- WHERE u.user_id = pv_apps_user_id
6166: -- AND u.write_flag = 'Y');
6167:
6168: -- IF v_count = 0 THEN