APPS.FND_OAM_DSCRAM_DIAG_PKG dependencies on FND_OAM_DSCRAM_TASKS

Line 804: FROM fnd_oam_dscram_tasks

800:
801: --query out the run's final status
802: SELECT task_status, workers_assigned
803: INTO l_status, l_workers_assigned
804: FROM fnd_oam_dscram_tasks
805: WHERE task_id = p_task_id;
806:
807: --status check
808: IF l_status IS NULL OR l_status <> p_target_status THEN

Line 1145: FROM fnd_oam_dscram_tasks

1141: IF p_num_tasks >= 0 THEN
1142: --now query the tasks and validate those
1143: SELECT task_id
1144: BULK COLLECT INTO l_ids
1145: FROM fnd_oam_dscram_tasks
1146: WHERE bundle_id = p_bundle_id;
1147:
1148: l_count_tasks := 0;
1149: k := l_ids.FIRST;

Line 1570: INSERT INTO FND_OAM_DSCRAM_TASKS (TASK_ID,

1566: l_retval NUMBER;
1567: BEGIN
1568: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1569:
1570: INSERT INTO FND_OAM_DSCRAM_TASKS (TASK_ID,
1571: BUNDLE_ID,
1572: TASK_STATUS,
1573: PRIORITY,
1574: WEIGHT,

Line 1583: (fnd_oam_dscram_tasks_s.nextval,

1579: LAST_UPDATE_DATE,
1580: LAST_UPDATE_LOGIN
1581: )
1582: VALUES
1583: (fnd_oam_dscram_tasks_s.nextval,
1584: p_bundle_id,
1585: p_status,
1586: p_priority,
1587: p_weight,

Line 2673: FROM fnd_oam_dscram_tasks

2669:
2670: --now query out the task ids to validate each
2671: SELECT task_id
2672: BULK COLLECT INTO l_ids
2673: FROM fnd_oam_dscram_tasks
2674: WHERE bundle_id = p_bundle_id
2675: ORDER BY task_id ASC;
2676:
2677: l_count := 0;

Line 3832: FROM fnd_oam_dscram_tasks

3828: --check task_id
3829: BEGIN
3830: SELECT task_id
3831: INTO l_id
3832: FROM fnd_oam_dscram_tasks
3833: WHERE bundle_id = p_bundle_id
3834: AND task_id = p_task_id;
3835: EXCEPTION
3836: WHEN no_data_found THEN