APPS.FND_OAM_DSCRAM_DIAG_PKG dependencies on FND_OAM_DSCRAM_BUNDLES

Line 853: FROM fnd_oam_dscram_bundles

849:
850: --query out the run's final status
851: SELECT bundle_status, workers_assigned
852: INTO l_status, l_workers_assigned
853: FROM fnd_oam_dscram_bundles
854: WHERE run_id = p_run_id
855: AND bundle_id = p_bundle_id;
856:
857: --status check

Line 1228: FROM fnd_oam_dscram_bundles

1224: IF p_num_bundles >= 0 THEN
1225: --now query the bundles and validate those
1226: SELECT bundle_id
1227: BULK COLLECT INTO l_ids
1228: FROM fnd_oam_dscram_bundles
1229: WHERE run_id = p_run_id;
1230:
1231: l_count_bundles := 0;
1232: k := l_ids.FIRST;

Line 1627: INSERT INTO FND_OAM_DSCRAM_BUNDLES (BUNDLE_ID,

1623: IF p_batch_size IS NULL THEN
1624: l_batch_size := 1000;
1625: END IF;
1626:
1627: INSERT INTO FND_OAM_DSCRAM_BUNDLES (BUNDLE_ID,
1628: RUN_ID,
1629: BUNDLE_STATUS,
1630: WEIGHT,
1631: WORKERS_ALLOWED,

Line 1883: FROM fnd_oam_dscram_bundles

1879: SELECT 1
1880: INTO l_temp
1881: FROM DUAL
1882: WHERE EXISTS (SELECT 1
1883: FROM fnd_oam_dscram_bundles
1884: WHERE run_id = p_run_id
1885: AND (workers_assigned > 0 OR bundle_status NOT IN (FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSED,
1886: FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_STOPPED,
1887: FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_SKIPPED,

Line 2100: FND_OAM_DSCRAM_BUNDLES_PKG.EXECUTE_BUNDLE(p_run_id => p_run_id,

2096: l_start NUMBER;
2097: l_end NUMBER;
2098: BEGIN
2099: l_start := DBMS_UTILITY.GET_TIME;
2100: FND_OAM_DSCRAM_BUNDLES_PKG.EXECUTE_BUNDLE(p_run_id => p_run_id,
2101: p_bundle_id => p_bundle_id,
2102: px_worker_id => px_worker_id,
2103: x_return_status => x_return_status,
2104: x_return_msg => x_return_msg);

Line 3800: FROM fnd_oam_dscram_bundles

3796: --check bundle_id/batch size
3797: BEGIN
3798: SELECT batch_size, workers_allowed
3799: INTO l_batch_size, l_workers_allowed
3800: FROM fnd_oam_dscram_bundles
3801: WHERE run_id = p_run_id
3802: AND bundle_id = p_bundle_id;
3803: EXCEPTION
3804: WHEN no_data_found THEN

Line 3822: l_worker_id := FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKER_ID;

3818: x_return_msg := 'Expected bundle workers_allowed('||p_bundle_workers_allowed||'), found workers_allowed('||l_workers_allowed||')';
3819: RETURN;
3820: END IF;
3821: --check the worker_id matches the state
3822: l_worker_id := FND_OAM_DSCRAM_BUNDLES_PKG.GET_WORKER_ID;
3823: IF p_worker_id IS NULL OR p_worker_id <> l_worker_id THEN
3824: x_return_msg := 'Worker ID('||p_worker_id||') not the same as the one provided by dscram_bundles('||l_worker_id||')';
3825: RETURN;
3826: END IF;