APPS.FND_OAM_DSCRAM_DIAG_PKG dependencies on FND_OAM_DSCRAM_UNITS

Line 752: FROM fnd_oam_dscram_units

748:
749: --query out the run's final status
750: SELECT unit_status, workers_assigned
751: INTO l_status, l_workers_assigned
752: FROM fnd_oam_dscram_units
753: WHERE unit_id = p_unit_id;
754:
755: --status check
756: IF (l_status IS NULL AND p_target_status IS NOT NULL) OR

Line 1065: FROM fnd_oam_dscram_units

1061: IF p_num_units >= 0 THEN
1062: --now query the units and validate those
1063: SELECT unit_id
1064: BULK COLLECT INTO l_ids
1065: FROM fnd_oam_dscram_units
1066: WHERE task_id = p_task_id
1067: AND concurrent_group_unit_id IS NULL;
1068:
1069: l_count_units := 0;

Line 1496: INSERT INTO FND_OAM_DSCRAM_UNITS (UNIT_ID,

1492: l_retval NUMBER;
1493: BEGIN
1494: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1495:
1496: INSERT INTO FND_OAM_DSCRAM_UNITS (UNIT_ID,
1497: TASK_ID,
1498: CONCURRENT_GROUP_UNIT_ID,
1499: UNIT_TYPE,
1500: UNIT_STATUS,

Line 1520: (fnd_oam_dscram_units_s.nextval,

1516: LAST_UPDATE_DATE,
1517: LAST_UPDATE_LOGIN
1518: )
1519: VALUES
1520: (fnd_oam_dscram_units_s.nextval,
1521: p_task_id,
1522: p_conc_unit_id,
1523: p_unit_type,
1524: p_status,

Line 3845: FROM fnd_oam_dscram_units

3841: --check the unit
3842: BEGIN
3843: SELECT actual_disable_splitting, actual_workers_allowed, unit_object_owner, unit_object_name, batch_size
3844: INTO l_disable_splitting, l_workers_allowed, l_unit_object_owner, l_unit_object_name, l_batch_size
3845: FROM fnd_oam_dscram_units
3846: WHERE task_id = p_task_id
3847: AND unit_id = p_unit_id;
3848: EXCEPTION
3849: WHEN no_data_found THEN