APPS.FND_OAM_DSCRAM_DMLS_PKG dependencies on FND_OAM_DSCRAM_UTILS_PKG

Line 86: FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_DML,

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

Line 127: FND_OAM_DSCRAM_ARGS_PKG.FETCH_ARG_LIST(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_DML,

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

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

379: ELSE
380: l_finished_ret_sts := p_finished_ret_sts;
381: l_message := p_message;
382: END IF;
383: l_finished_status := FND_OAM_DSCRAM_UTILS_PKG.CONV_RET_STS_TO_COMPL_STATUS(l_finished_ret_sts);
384:
385: fnd_oam_debug.log(1, l_ctxt, 'Finished DML with Status: '||l_finished_status||'('||l_finished_ret_sts||')');
386:
387: --update the dml

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

389: SET finished_ret_sts = l_finished_ret_sts
390: WHERE dml_id = p_dml_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_DML,
394: p_source_object_id => p_dml_id,
395: p_end_time => SYSDATE,
396: p_end_message => l_message,
397: p_postend_status => l_finished_status);

Line 498: FND_OAM_DSCRAM_UTILS_PKG.MAKE_FINAL_SQL_STMT(px_arg_context,

494: RETURN;
495: END IF;
496:
497: --prepare the final stmt from the stmt, where clause and possible the rowid restrict where clause
498: FND_OAM_DSCRAM_UTILS_PKG.MAKE_FINAL_SQL_STMT(px_arg_context,
499: l_dml_stmt,
500: l_where_clause,
501: p_use_splitting,
502: l_final_dml_stmt,

Line 567: IF NOT FND_OAM_DSCRAM_STATS_PKG.HAS_ENTRY(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_DML,

563:
564: --if the dml isn't cached, there's a chance that its stats row hasn't been created yet, query and
565: --create if necessary. This is not mt-safe but extra calls to create_entry will be discarded due to
566: --the unique index on fnd_oam_dscram_stats.
567: IF NOT FND_OAM_DSCRAM_STATS_PKG.HAS_ENTRY(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_DML,
568: p_dml_id) THEN
569: --autonomously create the stats entry
570: FND_OAM_DSCRAM_STATS_PKG.CREATE_ENTRY_AUTONOMOUSLY(p_source_object_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_DML,
571: p_source_object_id => p_dml_id,

Line 570: FND_OAM_DSCRAM_STATS_PKG.CREATE_ENTRY_AUTONOMOUSLY(p_source_object_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_DML,

566: --the unique index on fnd_oam_dscram_stats.
567: IF NOT FND_OAM_DSCRAM_STATS_PKG.HAS_ENTRY(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_DML,
568: p_dml_id) THEN
569: --autonomously create the stats entry
570: FND_OAM_DSCRAM_STATS_PKG.CREATE_ENTRY_AUTONOMOUSLY(p_source_object_type => FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_DML,
571: p_source_object_id => p_dml_id,
572: p_start_time => SYSDATE,
573: p_prestart_status => NULL,
574: p_dismiss_failure => FND_API.G_TRUE,

Line 616: FND_OAM_DSCRAM_ARGS_PKG.FETCH_ARG_LIST(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_DML,

612: RETURN;
613: END;
614:
615: --now lets get the arg list for the dml
616: FND_OAM_DSCRAM_ARGS_PKG.FETCH_ARG_LIST(FND_OAM_DSCRAM_UTILS_PKG.G_TYPE_DML,
617: p_dml_id,
618: l_arg_list,
619: l_has_writable_args,
620: l_return_status,

Line 726: FND_OAM_DSCRAM_UTILS_PKG.G_ARG_ROWID_LBOUND_NAME,

722: --cache entry should be valid now, do additional bindings if needed
723: IF p_use_splitting THEN
724: fnd_oam_debug.log(1, l_ctxt, 'Binding lower('||p_rowid_lbound||') and upper('||p_rowid_ubound||') rowids');
725: DBMS_SQL.BIND_VARIABLE(b_dml_cache(p_dml_id).cursor_id,
726: FND_OAM_DSCRAM_UTILS_PKG.G_ARG_ROWID_LBOUND_NAME,
727: p_rowid_lbound);
728: DBMS_SQL.BIND_VARIABLE(b_dml_cache(p_dml_id).cursor_id,
729: FND_OAM_DSCRAM_UTILS_PKG.G_ARG_ROWID_UBOUND_NAME,
730: p_rowid_ubound);

Line 729: FND_OAM_DSCRAM_UTILS_PKG.G_ARG_ROWID_UBOUND_NAME,

725: DBMS_SQL.BIND_VARIABLE(b_dml_cache(p_dml_id).cursor_id,
726: FND_OAM_DSCRAM_UTILS_PKG.G_ARG_ROWID_LBOUND_NAME,
727: p_rowid_lbound);
728: DBMS_SQL.BIND_VARIABLE(b_dml_cache(p_dml_id).cursor_id,
729: FND_OAM_DSCRAM_UTILS_PKG.G_ARG_ROWID_UBOUND_NAME,
730: p_rowid_ubound);
731: END IF;
732:
733: --skip the execute if we're in test-no-exec mode

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

730: p_rowid_ubound);
731: END IF;
732:
733: --skip the execute if we're in test-no-exec mode
734: IF FND_OAM_DSCRAM_RUNS_PKG.GET_RUN_MODE = FND_OAM_DSCRAM_UTILS_PKG.G_MODE_TEST_NO_EXEC THEN
735: fnd_oam_debug.log(1, l_ctxt, 'Skipping Executiong due to run mode.');
736: l_rows_processed := 0;
737: ELSE
738: --do the execute

Line 822: IF FND_OAM_DSCRAM_UTILS_PKG.RUN_IS_NORMAL THEN

818: b_dml_cache(p_dml_id).last_execute_ret_sts := l_return_status;
819: b_dml_cache(p_dml_id).last_execute_ret_msg := l_return_msg;
820:
821: --complete differently based on the run mode
822: IF FND_OAM_DSCRAM_UTILS_PKG.RUN_IS_NORMAL THEN
823: --complete the dml as part of the transaction
824: COMPLETE_DML(p_dml_id,
825: l_return_status,
826: l_return_msg,