DBA Data[Home] [Help]

APPS.FND_OAM_DSCRAM_UNITS_PKG dependencies on FND_OAM_DSCRAM_TASKS_PKG

Line 16: WHERE task_id = FND_OAM_DSCRAM_TASKS_PKG.GET_TASK_ID

12: CURSOR B_UNITS
13: IS
14: SELECT /*+ FIRST_ROWS(1) */ unit_id, unit_status, phase, actual_workers_allowed, workers_assigned
15: FROM fnd_oam_dscram_units
16: WHERE task_id = FND_OAM_DSCRAM_TASKS_PKG.GET_TASK_ID
17: AND unit_status in (FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_UNPROCESSED,
18: FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSING,
19: FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_RESTARTABLE,
20: FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_FINISHING) --need to include finishing to keep from violating phases

Line 371: IF NOT FND_OAM_DSCRAM_TASKS_PKG.VALIDATE_CONTINUED_EXECUTION(p_force_query,

367: END IF;
368:
369: -- make a recursive call to the the task if required
370: IF p_recurse THEN
371: IF NOT FND_OAM_DSCRAM_TASKS_PKG.VALIDATE_CONTINUED_EXECUTION(p_force_query,
372: TRUE,
373: l_return_status,
374: l_return_msg) THEN
375: -- the run has an invalid status, tell the execute to stop the unit

Line 1449: WHERE task_id = FND_OAM_DSCRAM_TASKS_PKG.GET_TASK_ID

1445: --first we need to fetch the component units of this meta-unit
1446: SELECT unit_id, unit_type, priority
1447: BULK COLLECT INTO l_unit_ids, l_types, l_priorities
1448: FROM fnd_oam_dscram_units
1449: WHERE task_id = FND_OAM_DSCRAM_TASKS_PKG.GET_TASK_ID
1450: AND concurrent_group_unit_id = b_unit_info.unit_id
1451: ORDER BY priority ASC, weight DESC;
1452:
1453: --now go through the unit list to create the master work queue

Line 1637: IF NOT FND_OAM_DSCRAM_TASKS_PKG.VALIDATE_CONTINUED_EXECUTION(FALSE,

1633: END IF;
1634:
1635: --before proceeding after the assign, check our parent objects to make sure
1636: --their state suggests we should continue
1637: IF NOT FND_OAM_DSCRAM_TASKS_PKG.VALIDATE_CONTINUED_EXECUTION(FALSE,
1638: TRUE,
1639: l_return_status,
1640: l_return_msg) THEN
1641: --we don't care why a parent is invalid, just knowing so forces us to