APPS.FND_OAM_DSCFG_COMPILER_PKG dependencies on DUAL

Line 1692: FROM dual;

1688: IF b_run.run_id IS NULL THEN
1689: --get a run_id
1690: SELECT FND_OAM_DSCRAM_RUNS_S.NEXTVAL
1691: INTO b_run.run_id
1692: FROM dual;
1693: ELSE
1694: fnd_oam_debug.log(1, l_ctxt, 'Deleting Existing, Stale run_id: '||b_run.run_id);
1695: --TODO: make this smarter
1696: IF NOT FND_OAM_DSCRAM_UTILS_PKG.DELETE_RUN(b_run.run_id) THEN

Line 2124: FROM dual;

2120:
2121: IF px_unit_id IS NULL THEN
2122: SELECT FND_OAM_DSCRAM_UNITS_S.NEXTVAL
2123: INTO px_unit_id
2124: FROM dual;
2125: END IF;
2126:
2127: INSERT INTO FND_OAM_DSCRAM_UNITS (UNIT_ID,
2128: TASK_ID,

Line 2189: FROM DUAL;

2185: l_retval NUMBER;
2186: BEGIN
2187: SELECT FND_OAM_DSCRAM_UNITS_S.NEXTVAL
2188: INTO l_retval
2189: FROM DUAL;
2190: RETURN l_retval;
2191: END;
2192:
2193: -- Helper to ADD_ENGINE_UNITS to update the logical and physical weight counters.

Line 3095: FROM dual;

3091:
3092: -- fetch a task_id to use for creating units
3093: SELECT FND_OAM_DSCRAM_TASKS_S.NEXTVAL
3094: INTO l_task_id
3095: FROM dual;
3096: b_dependency_groups(p_group_id).task_id := l_task_id;
3097: fnd_oam_debug.log(1, l_ctxt, 'Using task_id: '||l_task_id);
3098:
3099: -- loop through the primary domains, creating units for each kind of object in each domain - we don't allow