APPS.FEM_UD_PKG dependencies on FEM_UD_PRVIEW_DEPENDENTS

Line 2333: -- FEM_UD_PRVIEW_DEPENDENTS when p_preview_flag = 'Y'. This procedure always

2329: -- PUBLIC
2330: -- This procedure generates a list of all object executions that used the
2331: -- result data of an undo list candidate as input. The list of dependents are
2332: -- stored in FEM_UD_LIST_DEPENDENTS when p_preview_flag = 'N' and are stored in
2333: -- FEM_UD_PRVIEW_DEPENDENTS when p_preview_flag = 'Y'. This procedure always
2334: -- generates update dependents, and will only generate chain dependents if
2335: -- p_dependency_type = 'ALL'.
2336: -- Note: Original logic allowed user to specify the type of dependencies to
2337: -- include. Current logic always includes update dependencies.

Line 2411: FROM fem_ud_prview_dependents d, fem_object_catalog_b o, fem_user_folders u

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

Line 2515: DELETE fem_ud_prview_dependents

2511:
2512: END IF;
2513: ELSIF p_preview_flag = 'Y' THEN
2514: -- Delete dependents for preview list candidate.
2515: DELETE fem_ud_prview_dependents
2516: WHERE ud_session_id = p_ud_session_id
2517: AND request_id = p_request_id
2518: AND object_id = p_object_id;
2519:

Line 2558: INSERT INTO fem_ud_prview_dependents (ud_session_id,

2554: VALUES (p_undo_list_obj_def_id, p_request_id, p_object_id,
2555: updated_col.dependent_request_id, updated_col.dependent_object_id,
2556: pv_apps_user_id, sysdate, pv_apps_user_id, sysdate, pv_login_id,1);
2557: ELSE -- p_preview_flag = 'Y'
2558: INSERT INTO fem_ud_prview_dependents (ud_session_id,
2559: request_id, object_id, dependent_request_id, dependent_object_id,
2560: created_by, creation_date, last_updated_by, last_update_date,
2561: last_update_login, object_version_Number)
2562: VALUES (p_ud_session_id, p_request_id, p_object_id,

Line 2635: INSERT INTO fem_ud_prview_dependents (ud_session_id,

2631: VALUES (p_undo_list_obj_def_id, p_request_id, p_object_id, achain.request_id,
2632: achain.object_id, pv_apps_user_id, sysdate, pv_apps_user_id, sysdate,
2633: pv_login_id,1);
2634: ELSE -- p_preview_flag = 'Y'
2635: INSERT INTO fem_ud_prview_dependents (ud_session_id,
2636: request_id, object_id, dependent_request_id, dependent_object_id,
2637: created_by, creation_date, last_updated_by, last_update_date,
2638: last_update_login, object_version_number)
2639: VALUES (p_ud_session_id, p_request_id, p_object_id,

Line 2675: INSERT INTO fem_ud_prview_dependents

2671: v_count := 0;
2672: FOR repeat_execs IN c_repeat_execs(p_request_id, p_object_id) LOOP
2673: v_count := v_count + 1;
2674: BEGIN
2675: INSERT INTO fem_ud_prview_dependents
2676: (ud_session_id,request_id, object_id, dependent_request_id,
2677: dependent_object_id,created_by, creation_date, last_updated_by,
2678: last_update_date,last_update_login, object_version_Number)
2679: VALUES

Line 2774: UPDATE fem_ud_prview_dependents

2770: -- Validate that the user can execute (same as user can read) the dependent
2771: -- =========================================================================
2772: IF a_prvw_dep.folder_id IS NULL THEN
2773: v_count := v_count + 1;
2774: UPDATE fem_ud_prview_dependents
2775: SET validation_status_code = 'FEM_UD_CANNOT_READ_OBJECT_ERR',
2776: last_Update_date = sysdate, last_Updated_by = pv_apps_user_id
2777: WHERE ud_session_id = p_ud_session_id
2778: AND dependent_request_id = a_prvw_dep.dependent_request_id

Line 2818: UPDATE fem_ud_prview_dependents

2814: AND object_id = a_prvw_dep.dependent_object_id;
2815:
2816: IF v_exec_status_code = 'RUNNING' THEN
2817: v_count := v_count + 1;
2818: UPDATE fem_ud_prview_dependents
2819: SET validation_status_code = 'FEM_UD_OBJEXEC_IS_RUNNING_ERR',
2820: last_Update_date = sysdate, last_updated_by = pv_apps_user_id
2821: WHERE ud_session_id = p_ud_session_id
2822: AND dependent_request_id = a_prvw_dep.dependent_request_id

Line 2829: UPDATE fem_ud_prview_dependents

2825: END IF;
2826: END LOOP; -- End a_prvw_dep loop
2827:
2828: -- Set validation status of dependents that passed validation to 'VALID'
2829: UPDATE fem_ud_prview_dependents
2830: SET validation_status_code = 'FEM_UD_VALID_TXT',
2831: last_update_date = sysdate, last_updated_By = pv_apps_user_id
2832: WHERE ud_session_id = p_ud_session_id
2833: AND request_id = p_request_id

Line 6320: DELETE FROM fem_ud_prview_dependents

6316: END IF;
6317:
6318: -- Bug 4337210. Last step is to clean up the preview tables.
6319: -- First delete the preview dependents
6320: DELETE FROM fem_ud_prview_dependents
6321: WHERE ud_session_id = p_ud_session_id;
6322: -- Then delete the preview candidates
6323: DELETE FROM fem_ud_prview_candidates
6324: WHERE ud_session_id = p_ud_session_id;