APPS.FEM_UD_PKG dependencies on FEM_UD_LISTS

Line 901: -- Create list header in FEM_UD_LISTS

897: x_return_status => x_return_status);
898:
899: IF x_return_status = pc_ret_sts_success THEN
900: -- ============================================================================
901: -- Create list header in FEM_UD_LISTS
902: -- ============================================================================
903:
904: INSERT INTO fem_ud_lists (undo_list_obj_def_id ,include_dependencies_flag ,
905: ignore_dependency_errs_flag,execution_date,

Line 904: INSERT INTO fem_ud_lists (undo_list_obj_def_id ,include_dependencies_flag ,

900: -- ============================================================================
901: -- Create list header in FEM_UD_LISTS
902: -- ============================================================================
903:
904: INSERT INTO fem_ud_lists (undo_list_obj_def_id ,include_dependencies_flag ,
905: ignore_dependency_errs_flag,execution_date,
906: object_version_number,created_by,creation_date,
907: last_updated_by,last_update_date,last_update_login)
908: VALUES(x_undo_list_obj_def_id ,p_include_dependencies_flag ,

Line 1093: from fem_ud_lists

1089: and exec_status_code IS NOT NULL
1090: and exec_status_code <> 'SUCCESS'
1091: UNION
1092: select exec_status_code
1093: from fem_ud_lists
1094: where undo_list_obj_def_id = v_undo_list_obj_def_id
1095: and exec_status_code IS NOT NULL
1096: and exec_status_code <> 'SUCCESS');
1097:

Line 1132: DELETE fem_ud_lists

1128:
1129: DELETE fem_ud_list_candidates
1130: WHERE undo_list_obj_def_id = v_undo_list_obj_def_id;
1131:
1132: DELETE fem_ud_lists
1133: WHERE undo_list_obj_def_id = v_undo_list_obj_def_id;
1134:
1135: ELSE
1136: RAISE e_cannot_delete_object;

Line 1344: from fem_ud_lists

1340: where undo_list_obj_def_id = p_undo_list_obj_def_id
1341: and exec_status_code IS NOT NULL
1342: UNION
1343: select exec_status_code
1344: from fem_ud_lists
1345: where undo_list_obj_def_id = p_undo_list_obj_def_id
1346: and exec_status_code IS NOT NULL);
1347:
1348:

Line 1363: FROM fem_ud_lists

1359: -- ============================================================================
1360: SELECT include_dependencies_flag, ignore_dependency_errs_flag,
1361: DECODE(include_dependencies_flag,'Y','ALL','UPDATE')
1362: INTO v_include_dependencies_flag, v_ignore_dependency_errs_flag,v_dependency_type
1363: FROM fem_ud_lists
1364: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id;
1365:
1366: IF v_include_dependencies_flag = 'N' AND v_ignore_dependency_errs_flag = 'N'
1367: THEN

Line 1720: from fem_ud_lists

1716: where undo_list_obj_def_id = p_undo_list_obj_def_id
1717: and exec_status_code IS NOT NULL
1718: UNION
1719: select exec_status_code
1720: from fem_ud_lists
1721: where undo_list_obj_def_id = p_undo_list_obj_def_id
1722: and exec_status_code IS NOT NULL);
1723:
1724: IF v_approval_edit_lock_exists = 'T' OR v_data_edit_lock_exists = 'T'

Line 2501: from fem_ud_lists

2497: where undo_list_obj_def_id = p_undo_list_obj_def_id
2498: and exec_status_code IS NOT NULL
2499: UNION
2500: select exec_status_code
2501: from fem_ud_lists
2502: where undo_list_obj_def_id = p_undo_list_obj_def_id
2503: and exec_status_code IS NOT NULL);
2504:
2505: IF v_undo_list_ever_exec = 'N' THEN

Line 4350: UPDATE fem_ud_lists

4346: p_msg_text => 'Begin. P_OBJECT_ID: '||p_undo_list_obj_id||
4347: ' P_EXECUTION_STATUS: '||p_execution_status);
4348:
4349: -- Update status of undo list
4350: UPDATE fem_ud_lists
4351: SET exec_status_code = p_execution_status,
4352: last_update_date = sysdate, last_Updated_by = pv_apps_user_id
4353: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id;
4354:

Line 4568: FROM fem_object_catalog_b o, fem_object_definition_b d, fem_ud_lists u

4564: BEGIN
4565:
4566: SELECT u.undo_list_obj_def_id
4567: INTO v_undo_list_obj_def_id
4568: FROM fem_object_catalog_b o, fem_object_definition_b d, fem_ud_lists u
4569: WHERE o.object_id = p_undo_list_obj_id
4570: AND o.object_type_code = 'UNDO'
4571: AND o.object_id = d.object_id
4572: AND d.object_definition_id = u.undo_list_obj_def_id;

Line 4612: FROM fem_ud_lists

4608: -- ============================================================================
4609:
4610: SELECT include_dependencies_flag, ignore_dependency_errs_flag
4611: INTO v_include_dependencies_flag, v_ignore_dependency_errs_flag
4612: FROM fem_ud_lists
4613: WHERE undo_list_obj_def_id = v_undo_list_obj_def_id;
4614:
4615: IF v_include_dependencies_flag = 'N' AND v_ignore_dependency_errs_flag = 'N'
4616: THEN

Line 4743: UPDATE fem_ud_lists

4739: p_msg_text => 'Begin PROCESSING: '||to_char(sysdate,'MM/DD/YYYY HH:MI:SS'));
4740:
4741:
4742: -- Set status of undo list to 'RUNNING'
4743: UPDATE fem_ud_lists
4744: SET exec_status_code = 'RUNNING',
4745: last_update_date = sysdate, last_updated_by = pv_apps_User_id
4746: WHERE undo_list_obj_def_id = v_undo_list_obj_def_id;
4747: COMMIT;

Line 4911: UPDATE fem_ud_lists

4907: END LOOP;
4908:
4909: -- Delete undo list.
4910: -- Set status of undo list to 'SUCCESS'
4911: UPDATE fem_ud_lists
4912: SET exec_status_code = 'SUCCESS',
4913: last_update_date = sysdate, last_updated_by = pv_apps_user_id
4914: WHERE undo_list_obj_def_id = v_undo_list_obj_def_id;
4915: COMMIT;

Line 5148: FROM fem_object_catalog_b o, fem_object_definition_b d, fem_ud_lists u

5144: v_check_status BOOLEAN;
5145:
5146: CURSOR c1 IS
5147: SELECT o.object_id
5148: FROM fem_object_catalog_b o, fem_object_definition_b d, fem_ud_lists u
5149: WHERE o.object_type_code = 'UNDO'
5150: AND o.object_id = d.object_id
5151: AND d.object_definition_id = u.undo_list_obj_def_id
5152: AND (u.execution_date < SYSDATE OR u.execution_date = SYSDATE)