DBA Data[Home] [Help]

APPS.FND_OAM_DSCRAM_TASKS_PKG dependencies on FND_OAM_DSCRAM_BUNDLES_PKG

Line 21: WHERE T.bundle_id = FND_OAM_DSCRAM_BUNDLES_PKG.GET_BUNDLE_ID

17: CURSOR B_TASKS
18: IS
19: SELECT /*+ FIRST_ROWS(1) */ T.task_id, T.task_status
20: FROM fnd_oam_dscram_tasks T
21: WHERE T.bundle_id = FND_OAM_DSCRAM_BUNDLES_PKG.GET_BUNDLE_ID
22: AND T.task_status in (FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_UNPROCESSED,
23: FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSING,
24: FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_RESTARTABLE)
25: AND (EXISTS (SELECT unit_id

Line 266: IF NOT FND_OAM_DSCRAM_BUNDLES_PKG.VALIDATE_CONTINUED_EXECUTION(p_force_query,

262: END IF;
263:
264: -- make a recursive call to the bundle if required
265: IF p_recurse THEN
266: IF NOT FND_OAM_DSCRAM_BUNDLES_PKG.VALIDATE_CONTINUED_EXECUTION(p_force_query,
267: TRUE,
268: l_return_status,
269: l_return_msg) THEN
270: -- the run/bundle has an invalid status, tell the execute to stop the task

Line 523: IF NOT FND_OAM_DSCRAM_BUNDLES_PKG.VALIDATE_CONTINUED_EXECUTION(FALSE,

519: END IF;
520:
521: --before proceeding after the assign, check our parent objects to make sure
522: --their state suggests we should continue
523: IF NOT FND_OAM_DSCRAM_BUNDLES_PKG.VALIDATE_CONTINUED_EXECUTION(FALSE,
524: TRUE,
525: l_return_status,
526: l_return_msg) THEN
527: --we don't care why a parent is invalid, just knowing so forces us to