eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FEM_UD_PKG dependencies on FEM_UD_LIST_CANDIDATES

Line 1081: from fem_ud_list_candidates

1077: p_msg_text => 'V02: Check to see if user list may be deleted.');
1078:
1079: SELECT DECODE(count(*),0,'Y','N') INTO v_undo_list_exec_successfully
1080: FROM (select exec_status_code
1081: from fem_ud_list_candidates
1082: where undo_list_obj_def_id = v_undo_list_obj_def_id
1083: and exec_status_code IS NOT NULL
1084: and exec_status_code <> 'SUCCESS'
1085: UNION

Line 1129: DELETE fem_ud_list_candidates

1125:
1126: DELETE fem_ud_list_dependents
1127: WHERE undo_list_obj_def_id = v_undo_list_obj_def_id;
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;

Line 1334: from fem_ud_list_candidates

1330: -- This query checks to see if the undo list has ever been run, (as
1331: -- the execution may no longer be in the PL tables).
1332: SELECT DECODE(count(*),0,'N','Y') INTO v_undo_list_ever_executed
1333: FROM (select exec_status_code
1334: from fem_ud_list_candidates
1335: where undo_list_obj_def_id = p_undo_list_obj_def_id
1336: and exec_status_code IS NOT NULL
1337: UNION
1338: select exec_status_code

Line 1433: INSERT INTO fem_ud_list_candidates (undo_list_obj_def_id,

1429: -- If the list has never been run, add the candidate to the list and
1430: -- generate the candidate's dependents.
1431: -- ============================================================================
1432:
1433: INSERT INTO fem_ud_list_candidates (undo_list_obj_def_id,
1434: object_id, request_id, object_version_number, created_by, creation_date,
1435: last_updated_by, last_update_date, last_update_login)
1436: VALUES (p_undo_list_obj_def_id, p_object_id, p_request_id,
1437: 1, pv_apps_user_id, sysdate, pv_apps_user_id, sysdate, pv_login_id);

Line 1467: INSERT INTO fem_ud_list_candidates (undo_list_obj_def_id,

1463: -- dataset code and source system as the current candidate.
1464: -- ============================================================================
1465: FOR an_integration_load_exec IN c1 LOOP
1466:
1467: INSERT INTO fem_ud_list_candidates (undo_list_obj_def_id,
1468: object_id, request_id, object_version_number, created_by, creation_date,
1469: last_updated_by, last_update_date, last_update_login)
1470: VALUES (p_undo_list_obj_def_id, an_integration_load_exec.object_id,
1471: an_integration_load_exec.request_id, 1, pv_apps_user_id, sysdate,

Line 1654: FROM fem_ud_list_candidates c, fem_object_catalog_b o, fem_pl_requests r1, fem_pl_requests r2

1650: -- dataset code and source system as the current candidate.
1651: -- Bug 5011140 (FP:4596447): Also retrieve all TP Process Rule executions.
1652: CURSOR c1 IS
1653: SELECT c.request_id, c.object_id
1654: FROM fem_ud_list_candidates c, fem_object_catalog_b o, fem_pl_requests r1, fem_pl_requests r2
1655: WHERE c.object_id = o.object_id
1656: AND o.object_type_code IN ('OGL_INTG_BAL_RULE','XGL_INTEGRATION',
1657: 'RCM_PROCESS_RULE','TP_PROCESS_RULE',
1658: 'SOURCE_DATA_LOADER','DATAX_LOADER')

Line 1710: from fem_ud_list_candidates

1706: -- This query checks to see if the undo list has ever been run, (as
1707: -- the execution may no longer be in the PL tables).
1708: SELECT DECODE(count(*),0,'N','Y') INTO v_undo_list_ever_executed
1709: FROM (select exec_status_code
1710: from fem_ud_list_candidates
1711: where undo_list_obj_def_id = p_undo_list_obj_def_id
1712: and exec_status_code IS NOT NULL
1713: UNION
1714: select exec_status_code

Line 1732: DELETE fem_ud_list_candidates

1728:
1729: -- ============================================================================
1730: -- Delete the candidate and its dependents if no edit locks are found.
1731: -- ============================================================================
1732: DELETE fem_ud_list_candidates
1733: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
1734: AND request_id = p_request_id
1735: AND object_id = p_object_id;
1736:

Line 1754: DELETE fem_ud_list_candidates

1750: -- dataset code and source system as the current candidate.
1751: -- ============================================================================
1752: FOR an_integration_load_exec IN c1 LOOP
1753:
1754: DELETE fem_ud_list_candidates
1755: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
1756: AND request_id = an_integration_load_exec.request_id
1757: AND object_id = an_integration_load_exec.object_id;
1758:

Line 2491: from fem_ud_list_candidates

2487:
2488: IF p_preview_flag = 'N' THEN
2489: SELECT DECODE(count(*),0,'N','Y') INTO v_undo_list_ever_exec
2490: FROM (select exec_status_code
2491: from fem_ud_list_candidates
2492: where undo_list_obj_def_id = p_undo_list_obj_def_id
2493: and exec_status_code IS NOT NULL
2494: UNION
2495: select exec_status_code

Line 2985: FROM fem_ud_list_candidates

2981:
2982: -- This cursor retrieves all candidates in an undo list that have not yet been processed.
2983: CURSOR c1 IS
2984: SELECT request_id, object_id
2985: FROM fem_ud_list_candidates
2986: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
2987: AND (exec_status_code IS NULL OR
2988: exec_status_code <> 'SUCCESS');
2989:

Line 3562: UPDATE fem_ud_list_candidates

3558: AND dependent_request_id = p_request_id
3559: AND dependent_object_id = p_object_id;
3560: ELSE
3561: -- p_obj_exec_type = 'CANDIDATE'
3562: UPDATE fem_ud_list_candidates
3563: SET exec_status_code = 'RUNNING',
3564: last_update_date = sysdate, last_Updated_by = pv_apps_user_id
3565: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
3566: AND request_id = p_request_id

Line 4094: UPDATE fem_ud_list_candidates

4090: AND dependent_request_id = p_request_id
4091: AND dependent_object_id = p_object_id;
4092: ELSE
4093: -- p_obj_exec_type = 'CANDIDATE'
4094: UPDATE fem_ud_list_candidates
4095: SET exec_status_code = 'SUCCESS',
4096: last_update_date = sysdate, last_updated_by = pv_apps_user_id
4097: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
4098: AND request_id = p_request_id

Line 4152: UPDATE fem_ud_list_candidates

4148: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
4149: AND dependent_request_id = p_request_id
4150: AND dependent_object_id = p_object_id;
4151:
4152: UPDATE fem_ud_list_candidates
4153: SET exec_status_code = 'ERROR_RERUN',
4154: last_update_date = sysdate, last_Updated_by = pv_apps_user_id
4155: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
4156: AND exec_status_code = 'RUNNING';

Line 4161: UPDATE fem_ud_list_candidates

4157: COMMIT;
4158:
4159: ELSE
4160: -- p_obj_exec_type = 'CANDIDATE'
4161: UPDATE fem_ud_list_candidates
4162: SET exec_status_code = 'ERROR_RERUN',
4163: last_update_date = sysdate, last_updated_by = pv_apps_user_id
4164: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
4165: AND request_id = p_request_id

Line 4188: UPDATE fem_ud_list_candidates

4184: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
4185: AND dependent_request_id = p_request_id
4186: AND dependent_object_id = p_object_id;
4187:
4188: UPDATE fem_ud_list_candidates
4189: SET exec_status_code = 'ERROR_RERUN',
4190: last_update_date = sysdate, last_Updated_by = pv_apps_user_id
4191: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
4192: AND exec_status_code = 'RUNNING';

Line 4197: UPDATE fem_ud_list_candidates

4193: COMMIT;
4194:
4195: ELSE
4196: -- p_obj_exec_type = 'CANDIDATE'
4197: UPDATE fem_ud_list_candidates
4198: SET exec_status_code = 'ERROR_RERUN',
4199: last_update_date = sysdate, last_updated_by = pv_apps_user_id
4200: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
4201: AND request_id = p_request_id

Line 4222: UPDATE fem_ud_list_candidates

4218: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
4219: AND dependent_request_id = p_request_id
4220: AND dependent_object_id = p_object_id;
4221:
4222: UPDATE fem_ud_list_candidates
4223: SET exec_status_code = 'ERROR_RERUN',
4224: last_update_date = sysdate, last_Updated_by = pv_apps_user_id
4225: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
4226: AND exec_status_code = 'RUNNING';

Line 4230: UPDATE fem_ud_list_candidates

4226: AND exec_status_code = 'RUNNING';
4227: COMMIT;
4228:
4229: ELSE -- p_obj_exec_type = 'CANDIDATE'
4230: UPDATE fem_ud_list_candidates
4231: SET exec_status_code = 'ERROR_RERUN',
4232: last_update_date = sysdate, last_Updated_by = pv_apps_user_id
4233: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
4234: AND request_id = p_request_id

Line 4257: UPDATE fem_ud_list_candidates

4253: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
4254: AND dependent_request_id = p_request_id
4255: AND dependent_object_id = p_object_id;
4256:
4257: UPDATE fem_ud_list_candidates
4258: SET exec_status_code = 'ERROR_RERUN',
4259: last_Update_date = sysdate, last_Updated_by = pv_apps_user_id
4260: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
4261: AND exec_status_code = 'RUNNING';

Line 4265: UPDATE fem_ud_list_candidates

4261: AND exec_status_code = 'RUNNING';
4262: COMMIT;
4263:
4264: ELSE -- p_obj_exec_type = 'CANDIDATE'
4265: UPDATE fem_ud_list_candidates
4266: SET exec_status_code = 'ERROR_RERUN',
4267: last_update_date = sysdate, last_Updated_by = pv_apps_user_id
4268: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
4269: AND request_id = p_request_id

Line 4309: UPDATE fem_ud_list_candidates

4305: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
4306: AND dependent_request_id = p_request_id
4307: AND dependent_object_id = p_object_id;
4308:
4309: UPDATE fem_ud_list_candidates
4310: SET exec_status_code = 'ERROR_RERUN',
4311: last_update_date = sysdate, last_updated_by = pv_apps_user_id
4312: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
4313: AND exec_status_code = 'RUNNING';

Line 4317: UPDATE fem_ud_list_candidates

4313: AND exec_status_code = 'RUNNING';
4314: COMMIT;
4315:
4316: ELSE -- p_obj_exec_type = 'CANDIDATE'
4317: UPDATE fem_ud_list_candidates
4318: SET exec_status_code = 'ERROR_RERUN',
4319: last_Update_date = sysdate, last_Updated_by = pv_apps_user_id
4320: WHERE undo_list_obj_def_id = p_undo_list_obj_def_id
4321: AND request_id = p_request_id

Line 4522: FROM fem_ud_list_candidates

4518: -- This cursor retrives all candidates in an undo list that have not
4519: -- been executed successfully.
4520: CURSOR c10 IS
4521: SELECT request_id, object_id
4522: FROM fem_ud_list_candidates
4523: WHERE undo_list_obj_def_id = v_undo_list_obj_def_id
4524: AND (exec_status_code IS NULL OR
4525: exec_status_code <> 'SUCCESS')
4526: ORDER BY request_id, object_id;

Line 4622: FROM fem_ud_list_candidates c

4618: SELECT count(*) INTO v_count
4619: FROM fem_pl_chains pl
4620: WHERE (pl.source_created_by_request_id, pl.source_created_by_object_id) IN (
4621: SELECT c.request_id, c.object_id
4622: FROM fem_ud_list_candidates c
4623: WHERE c.undo_list_obj_def_id = v_undo_list_obj_def_id);
4624:
4625: IF v_count > 0 THEN
4626: RAISE e_dependencies_found;

Line 4750: FROM fem_ud_list_candidates

4746: WHERE undo_list_obj_def_id = v_undo_list_obj_def_id;
4747: COMMIT;
4748:
4749: SELECT count(*) INTO v_count
4750: FROM fem_ud_list_candidates
4751: WHERE undo_list_obj_def_id = v_undo_list_obj_def_id
4752: AND (exec_status_code IS NULL OR exec_status_code <> 'SUCCESS');
4753:
4754: IF v_count > 0 THEN

Line 4805: UPDATE fem_ud_list_candidates

4801: raise_undo_business_event (p_event_name => 'oracle.apps.fem.ud.submit',
4802: p_request_id => a_candidate.request_id,
4803: p_object_id => a_candidate.object_id);
4804:
4805: UPDATE fem_ud_list_candidates
4806: SET exec_status_code = 'RUNNING',
4807: last_Update_date = sysdate, last_updated_by = pv_apps_user_Id
4808: WHERE undo_list_obj_def_id = v_undo_list_obj_def_id
4809: AND request_id = a_candidate.request_id