APPS.FND_OAM_DSCRAM_DMLS_PKG dependencies on FND_OAM_DSCRAM_ARGS_PKG

Line 19: arg_list FND_OAM_DSCRAM_ARGS_PKG.arg_list,

15: TYPE b_dml_cache_entry IS RECORD
16: (
17: dml_id NUMBER(15) := NULL,
18: cursor_id INTEGER := NULL,
19: arg_list FND_OAM_DSCRAM_ARGS_PKG.arg_list,
20: use_splitting BOOLEAN := FALSE,
21: has_writable_args BOOLEAN := FALSE,
22: rows_processed NUMBER := NULL,
23: last_execute_ret_sts VARCHAR2(3) := NULL,

Line 105: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,

101: END;
102:
103: -- Public
104: PROCEDURE UPDATE_COMP_DML_WRITABLE_ARGS(p_dml_id IN NUMBER,
105: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,
106: p_using_splitting IN BOOLEAN,
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_return_msg OUT NOCOPY VARCHAR2)
109: IS

Line 112: l_arg_list FND_OAM_DSCRAM_ARGS_PKG.arg_list;

108: x_return_msg OUT NOCOPY VARCHAR2)
109: IS
110: l_ctxt VARCHAR2(60) := PKG_NAME||'UPDATE_COMP_DML_WRITABLE_ARGS';
111:
112: l_arg_list FND_OAM_DSCRAM_ARGS_PKG.arg_list;
113: l_has_writable_args BOOLEAN;
114: l_dml_cache_entry b_dml_cache_entry;
115:
116: l_return_status VARCHAR2(6);

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 151: FND_OAM_DSCRAM_ARGS_PKG.UPDATE_WRITABLE_ARG_VALUES(b_dml_cache(p_dml_id).arg_list,

147: END IF;
148:
149: --if the dml made it into the cache and has writable args, update them
150: IF b_dml_cache.EXISTS(p_dml_id) AND b_dml_cache(p_dml_id).has_writable_args THEN
151: FND_OAM_DSCRAM_ARGS_PKG.UPDATE_WRITABLE_ARG_VALUES(b_dml_cache(p_dml_id).arg_list,
152: px_arg_context,
153: TRUE,
154: b_dml_cache(p_dml_id).use_splitting,
155: NULL,

Line 182: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,

178:
179: -- Private helper to the destroy procedures to do the actual work of destroying a
180: -- cache entry, assumes p_dml_id is in the cache.
181: PROCEDURE INTERNAL_DESTROY_CACHE_ENTRY(p_dml_id IN NUMBER,
182: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,
183: p_update_context IN BOOLEAN,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_return_msg OUT NOCOPY VARCHAR2)
186: IS

Line 197: FND_OAM_DSCRAM_ARGS_PKG.UPDATE_CONTEXT_USING_ARG_LIST(px_arg_context,

193: x_return_msg := '';
194:
195: -- if requested, roll the arg list into the context
196: IF p_update_context THEN
197: FND_OAM_DSCRAM_ARGS_PKG.UPDATE_CONTEXT_USING_ARG_LIST(px_arg_context,
198: b_dml_cache(p_dml_id).arg_list,
199: b_dml_cache(p_dml_id).use_splitting);
200: END IF;
201:

Line 203: FND_OAM_DSCRAM_ARGS_PKG.DESTROY_ARG_LIST(b_dml_cache(p_dml_id).arg_list,

199: b_dml_cache(p_dml_id).use_splitting);
200: END IF;
201:
202: --first destroy the argument list
203: FND_OAM_DSCRAM_ARGS_PKG.DESTROY_ARG_LIST(b_dml_cache(p_dml_id).arg_list,
204: l_return_status,
205: l_return_msg);
206: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
207: x_return_status := l_return_status;

Line 231: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,

227: END;
228:
229: -- Public
230: PROCEDURE DESTROY_DML_CACHE_ENTRY(p_dml_id IN NUMBER,
231: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,
232: p_update_context IN BOOLEAN,
233: x_return_status OUT NOCOPY VARCHAR2,
234: x_return_msg OUT NOCOPY VARCHAR2)
235: IS

Line 271: PROCEDURE DESTROY_DML_CACHE(px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,

267: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
268: END;
269:
270: -- Public
271: PROCEDURE DESTROY_DML_CACHE(px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_return_msg OUT NOCOPY VARCHAR2)
274: IS
275: l_ctxt VARCHAR2(60) := PKG_NAME||'DESTROY_DML_CACHE';

Line 457: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,

453:
454: -- Private: helper to ADD_DML_TO_CACHE to prepare the final statement for a DML. This is
455: -- autonomous to keep from commiting data on the transaction.
456: PROCEDURE GENERATE_FINAL_DML_STMT(p_dml_id IN NUMBER,
457: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,
458: p_use_splitting IN BOOLEAN,
459: x_final_dml_stmt OUT NOCOPY VARCHAR2,
460: x_return_status OUT NOCOPY VARCHAR2,
461: x_return_msg OUT NOCOPY VARCHAR2)

Line 542: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,

538:
539: -- Private helper to EXECUTE_DML* to take a foreign dml_id and prepare it by generating the
540: -- final dml statement if necessary, parsing it into a cursor and fetching the arg list
541: PROCEDURE ADD_DML_TO_CACHE(p_dml_id IN NUMBER,
542: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,
543: p_use_splitting IN BOOLEAN,
544: x_return_status OUT NOCOPY VARCHAR2,
545: x_return_msg OUT NOCOPY VARCHAR2)
546: IS

Line 553: l_arg_list FND_OAM_DSCRAM_ARGS_PKG.arg_list;

549: l_stat_id NUMBER;
550: l_cache_entry b_dml_cache_entry;
551: l_final_dml_stmt VARCHAR2(4000);
552: l_cursor_id INTEGER;
553: l_arg_list FND_OAM_DSCRAM_ARGS_PKG.arg_list;
554: l_has_writable_args BOOLEAN;
555:
556: l_return_status VARCHAR2(6);
557: l_return_msg VARCHAR2(2048);

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 659: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,

655:
656: -- Private, helper to EXECUTE_DML* procedures to do the grunt work. the call to complete the DML
657: -- will be done by the caller. No commits or rollbacks are done here.
658: PROCEDURE INTERNAL_EXECUTE_DML(p_dml_id IN NUMBER,
659: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,
660: p_use_splitting IN BOOLEAN,
661: p_rowid_lbound IN ROWID,
662: p_rowid_ubound IN ROWID,
663: x_rows_processed OUT NOCOPY NUMBER,

Line 708: FND_OAM_DSCRAM_ARGS_PKG.BIND_ARG_LIST_TO_CURSOR(b_dml_cache(p_dml_id).arg_list,

704: END IF;
705:
706: --before every execution, re-bind the readable argument values. This may or may not change the
707: --value of the binding depending on the arg's write policy.
708: FND_OAM_DSCRAM_ARGS_PKG.BIND_ARG_LIST_TO_CURSOR(b_dml_cache(p_dml_id).arg_list,
709: px_arg_context,
710: b_dml_cache(p_dml_id).cursor_id,
711: p_use_splitting,
712: p_rowid_lbound,

Line 753: FND_OAM_DSCRAM_ARGS_PKG.UPDATE_WRITABLE_ARG_VALUES(b_dml_cache(p_dml_id).arg_list,

749: END IF;
750:
751: -- If the dml has any output variables, we should get values for them now if we can
752: IF b_dml_cache(p_dml_id).has_writable_args THEN
753: FND_OAM_DSCRAM_ARGS_PKG.UPDATE_WRITABLE_ARG_VALUES(b_dml_cache(p_dml_id).arg_list,
754: px_arg_context,
755: NOT p_use_splitting, --we're finished if we're not splitting
756: p_use_splitting,
757: p_rowid_lbound,

Line 790: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,

786: END;
787:
788: -- Public
789: PROCEDURE EXECUTE_DML(p_dml_id IN NUMBER,
790: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,
791: x_return_status OUT NOCOPY VARCHAR2,
792: x_return_msg OUT NOCOPY VARCHAR2)
793: IS
794: l_ctxt VARCHAR2(60) := PKG_NAME||'EXECUTE_DML';

Line 872: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,

868: END;
869:
870: -- Public
871: PROCEDURE EXECUTE_DML_ON_RANGE(p_dml_id IN NUMBER,
872: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,
873: p_rowid_lbound IN ROWID,
874: p_rowid_ubound IN ROWID,
875: x_rows_processed OUT NOCOPY NUMBER,
876: x_return_status OUT NOCOPY VARCHAR2,