APPS.FND_OAM_DSCRAM_PLSQLS_PKG dependencies on FND_OAM_DSCRAM_UTILS_PKG

Line 85: FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,

81: k := l_ids.FIRST;
82: WHILE k IS NOT NULL LOOP
83: l_work_queue(k) := FND_OAM_DSCRAM_UNITS_PKG.CREATE_WORK_ITEM(l_priorities(k),
84: l_weights(k),
85: FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
86: l_ids(k));
87: k := l_ids.NEXT(k);
88: END LOOP;
89:

Line 126: FND_OAM_DSCRAM_ARGS_PKG.FETCH_ARG_LIST(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,

122: --make sure the plsql's in the cache, if not we need to fetch its arg list now to update the writable args
123: --and place it in the cache if its possible that we will update an arg here.
124: IF NOT b_plsql_cache.EXISTS(p_plsql_id) THEN
125: --fetch the arg list first
126: FND_OAM_DSCRAM_ARGS_PKG.FETCH_ARG_LIST(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
127: p_plsql_id,
128: l_arg_list,
129: l_has_writable_args,
130: l_return_status,

Line 380: l_finished_status := FND_OAM_DSCRAM_UTILS_PKG.CONV_RET_STS_TO_COMPL_STATUS(l_finished_ret_sts);

376: ELSE
377: l_finished_ret_sts := p_finished_ret_sts;
378: l_message := p_message;
379: END IF;
380: l_finished_status := FND_OAM_DSCRAM_UTILS_PKG.CONV_RET_STS_TO_COMPL_STATUS(l_finished_ret_sts);
381:
382: fnd_oam_debug.log(1, l_ctxt, 'Finished PLSQL with Status: '||l_finished_status||'('||l_finished_ret_sts||')');
383:
384: --update the plsql

Line 393: FND_OAM_DSCRAM_STATS_PKG.COMPLETE_ENTRY(p_source_object_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,

389: last_update_date = SYSDATE
390: WHERE plsql_id = p_plsql_id;
391:
392: --dump a stats row as well
393: FND_OAM_DSCRAM_STATS_PKG.COMPLETE_ENTRY(p_source_object_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
394: p_source_object_id => p_plsql_id,
395: p_end_time => SYSDATE,
396: p_end_message => l_message,
397: p_postend_status => l_finished_status);

Line 477: l_length := LENGTH(l_plsql_text) + LENGTH(FND_OAM_DSCRAM_UTILS_PKG.G_PLSQL_PREFIX) +

473: RETURN;
474: END IF;
475:
476: --create the SQL statement by wrapping the plsql procedure text in an anonymous block
477: l_length := LENGTH(l_plsql_text) + LENGTH(FND_OAM_DSCRAM_UTILS_PKG.G_PLSQL_PREFIX) +
478: LENGTH(FND_OAM_DSCRAM_UTILS_PKG.G_PLSQL_SUFFIX) + 1;
479: IF l_length > l_maxlen THEN
480: x_return_msg := 'PLSQL Final text length would be '||l_length||', greater than max: '||l_maxlen;
481: fnd_oam_debug.log(6, l_ctxt, x_return_msg);

Line 478: LENGTH(FND_OAM_DSCRAM_UTILS_PKG.G_PLSQL_SUFFIX) + 1;

474: END IF;
475:
476: --create the SQL statement by wrapping the plsql procedure text in an anonymous block
477: l_length := LENGTH(l_plsql_text) + LENGTH(FND_OAM_DSCRAM_UTILS_PKG.G_PLSQL_PREFIX) +
478: LENGTH(FND_OAM_DSCRAM_UTILS_PKG.G_PLSQL_SUFFIX) + 1;
479: IF l_length > l_maxlen THEN
480: x_return_msg := 'PLSQL Final text length would be '||l_length||', greater than max: '||l_maxlen;
481: fnd_oam_debug.log(6, l_ctxt, x_return_msg);
482: ROLLBACK;

Line 486: l_final_plsql_text := FND_OAM_DSCRAM_UTILS_PKG.G_PLSQL_PREFIX||l_plsql_text||';'||FND_OAM_DSCRAM_UTILS_PKG.G_PLSQL_SUFFIX;

482: ROLLBACK;
483: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
484: RETURN;
485: END IF;
486: l_final_plsql_text := FND_OAM_DSCRAM_UTILS_PKG.G_PLSQL_PREFIX||l_plsql_text||';'||FND_OAM_DSCRAM_UTILS_PKG.G_PLSQL_SUFFIX;
487:
488: --store this string as the final text
489: UPDATE fnd_oam_dscram_plsqls
490: SET plsql_final_text = l_final_plsql_text,

Line 541: IF NOT FND_OAM_DSCRAM_STATS_PKG.HAS_ENTRY(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,

537:
538: --if the plsql isn't cached, there's a chance that its stats row hasn't been created yet, query and
539: --create if necessary. This is not mt-safe but extra calls to create_entry will be discarded due to
540: --the unique index on fnd_oam_dscram_stats.
541: IF NOT FND_OAM_DSCRAM_STATS_PKG.HAS_ENTRY(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
542: p_plsql_id) THEN
543: --autonomously create the stats entry
544: FND_OAM_DSCRAM_STATS_PKG.CREATE_ENTRY_AUTONOMOUSLY(p_source_object_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
545: p_source_object_id => p_plsql_id,

Line 544: FND_OAM_DSCRAM_STATS_PKG.CREATE_ENTRY_AUTONOMOUSLY(p_source_object_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,

540: --the unique index on fnd_oam_dscram_stats.
541: IF NOT FND_OAM_DSCRAM_STATS_PKG.HAS_ENTRY(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
542: p_plsql_id) THEN
543: --autonomously create the stats entry
544: FND_OAM_DSCRAM_STATS_PKG.CREATE_ENTRY_AUTONOMOUSLY(p_source_object_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
545: p_source_object_id => p_plsql_id,
546: p_start_time => SYSDATE,
547: p_prestart_status => NULL,
548: p_dismiss_failure => FND_API.G_TRUE,

Line 589: FND_OAM_DSCRAM_ARGS_PKG.FETCH_ARG_LIST(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,

585: RETURN;
586: END;
587:
588: --now lets get the arg list for the plsql
589: FND_OAM_DSCRAM_ARGS_PKG.FETCH_ARG_LIST(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_PLSQL,
590: p_plsql_id,
591: l_arg_list,
592: l_has_writable_args,
593: l_return_status,

Line 697: IF FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_MODE = FND_OAM_DSCRAM_UTILS_PKG.G_MODE_TEST_NO_EXEC THEN

693: --do not automatically bind the rowids if we're using splitting, it's up to the plsql to declare what args it requires
694: --independent of the context in which it's called
695:
696: --skip the execute if we're in test-no-exec mode
697: IF FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_MODE = FND_OAM_DSCRAM_UTILS_PKG.G_MODE_TEST_NO_EXEC THEN
698: fnd_oam_debug.log(1, l_ctxt, 'Skipping Executiong due to run mode.');
699: ELSE
700: --do the execute
701: fnd_oam_debug.log(1, l_ctxt, 'Executing cursor...');

Line 782: IF FND_OAM_DSCRAM_UTILS_PKG.RUN_IS_NORMAL THEN

778:
779: --if in normal mode, complete normally, otherwise we need to complete autonomously for progress to be maintained
780: --the status of the complete is returned as the overall execute status so we have insight into whether the entire
781: --operation suceeded
782: IF FND_OAM_DSCRAM_UTILS_PKG.RUN_IS_NORMAL THEN
783: COMPLETE_PLSQL(p_plsql_id,
784: l_return_status,
785: l_return_msg,
786: x_return_status,