APPS.FND_OAM_DSCRAM_BUNDLES_PKG dependencies on FND_OAM_DSCRAM_BUNDLES

Line 1: PACKAGE BODY FND_OAM_DSCRAM_BUNDLES_PKG as

1: PACKAGE BODY FND_OAM_DSCRAM_BUNDLES_PKG as
2: /* $Header: AFOAMDSBDLB.pls 120.8 2006/05/16 20:47:20 ilawler noship $ */
3:
4: ----------------------------------------
5: -- Private Body Constants

Line 112: FROM fnd_oam_dscram_bundles

108: l_return_msg VARCHAR2(4000);
109: CURSOR C1
110: IS
111: SELECT bundle_status, workers_allowed, workers_assigned
112: FROM fnd_oam_dscram_bundles
113: WHERE run_id = p_run_id
114: AND bundle_id = p_bundle_id;
115: BEGIN
116: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

Line 195: FROM fnd_oam_dscram_bundles

191:
192: CURSOR C1
193: IS
194: SELECT bundle_status
195: FROM fnd_oam_dscram_bundles
196: WHERE bundle_id = b_bundle_info.bundle_id;
197: BEGIN
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: x_return_msg := '';

Line 321: FROM fnd_oam_dscram_bundles

317: -- row to add to the # of workers assigned. Also updates the status to started if it
318: -- hasn't been set yet.
319: SELECT bundle_status, workers_allowed, workers_assigned, batch_size, min_parallel_unit_weight
320: INTO l_status, l_workers_allowed, l_workers_assigned, l_batch_size, l_min_parallel_unit_weight
321: FROM fnd_oam_dscram_bundles
322: WHERE bundle_id = p_bundle_id
323: FOR UPDATE;
324:
325: fnd_oam_debug.log(1, l_ctxt, 'Bundle Status: '||l_status);

Line 362: UPDATE fnd_oam_dscram_bundles

358: p_start_time => SYSDATE,
359: p_prestart_status => l_status,
360: x_stat_id => l_stat_id);
361: --update the status
362: UPDATE fnd_oam_dscram_bundles
363: SET bundle_status = FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_PROCESSING,
364: STATS_FINISHED = FND_API.G_FALSE
365: WHERE bundle_id = p_bundle_id;
366: ELSE

Line 386: UPDATE fnd_oam_dscram_bundles

382: IF px_worker_id IS NULL THEN
383: px_worker_id := l_workers_assigned + 1;
384: END IF;
385:
386: UPDATE fnd_oam_dscram_bundles
387: SET workers_assigned = l_workers_assigned + 1,
388: last_updated_by = fnd_global.user_id,
389: last_update_login = fnd_global.user_id,
390: last_update_date = SYSDATE

Line 457: FROM fnd_oam_dscram_bundles

453:
454: -- always lock the bundle since we have to decrement the worker count
455: SELECT bundle_status, workers_assigned
456: INTO l_status, l_workers_assigned
457: FROM fnd_oam_dscram_bundles
458: WHERE bundle_id = b_bundle_info.bundle_id
459: FOR UPDATE;
460:
461: -- translate the new_status into a valid final status

Line 472: UPDATE fnd_oam_dscram_bundles

468: fnd_oam_debug.log(1, l_ctxt, 'Translated status "'||p_proposed_status||'" into "'||l_final_status||'"');
469: fnd_oam_debug.log(1, l_ctxt, 'Translated Execute Ret Sts "'||p_proposed_ret_sts||'" into "'||l_final_ret_sts||'"');
470:
471: --update the status, workers_assigned
472: UPDATE fnd_oam_dscram_bundles
473: SET bundle_status = l_final_status,
474: workers_assigned = workers_assigned - 1,
475: last_updated_by = fnd_global.user_id,
476: last_update_login = fnd_global.user_id,

Line 775: FROM fnd_oam_dscram_bundles

771:
772: --query the bundles for the host as well as any bundles for all hosts denoted by a null hostname
773: SELECT bundle_id
774: BULK COLLECT INTO l_bundle_ids
775: FROM fnd_oam_dscram_bundles
776: WHERE run_id = p_run_id
777: AND (target_hostname = l_host_name OR target_hostname IS NULL)
778: ORDER BY target_hostname DESC, weight DESC;
779:

Line 812: END FND_OAM_DSCRAM_BUNDLES_PKG;

808: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
809: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
810: END;
811:
812: END FND_OAM_DSCRAM_BUNDLES_PKG;