APPS.FND_OAM_DSCRAM_PLSQLS_PKG dependencies on FND_OAM_DSCRAM_ARGS_PKG

Line 19: arg_list FND_OAM_DSCRAM_ARGS_PKG.arg_list,

15: TYPE b_plsql_cache_entry IS RECORD
16: (
17: plsql_id NUMBER(15) := NULL,
18: cursor_id INTEGER := NULL,
19: arg_list FND_OAM_DSCRAM_ARGS_PKG.arg_list,
20: use_splitting BOOLEAN := FALSE, --not needed for plsqls, just for args of plsql
21: has_writable_args BOOLEAN := FALSE,
22: last_execute_ret_sts VARCHAR2(3) := NULL,
23: last_execute_ret_msg VARCHAR2(2048) := NULL

Line 104: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,

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

Line 111: l_arg_list FND_OAM_DSCRAM_ARGS_PKG.arg_list;

107: x_return_msg OUT NOCOPY VARCHAR2)
108: IS
109: l_ctxt VARCHAR2(60) := PKG_NAME||'UPDATE_COMP_PLS_WRITABLE_ARGS';
110:
111: l_arg_list FND_OAM_DSCRAM_ARGS_PKG.arg_list;
112: l_has_writable_args BOOLEAN;
113: l_plsql_cache_entry b_plsql_cache_entry;
114:
115: l_return_status VARCHAR2(6);

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 150: FND_OAM_DSCRAM_ARGS_PKG.UPDATE_WRITABLE_ARG_VALUES(b_plsql_cache(p_plsql_id).arg_list,

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

Line 181: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,

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

Line 196: FND_OAM_DSCRAM_ARGS_PKG.UPDATE_CONTEXT_USING_ARG_LIST(px_arg_context,

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

Line 202: FND_OAM_DSCRAM_ARGS_PKG.DESTROY_ARG_LIST(b_plsql_cache(p_plsql_id).arg_list,

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

Line 230: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,

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

Line 270: PROCEDURE DESTROY_PLSQL_CACHE(px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,

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

Line 438: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,

434:
435: -- Private: helper to ADD_PLSQL_TO_CACHE to prepare the final statement for a PLSQL. This is
436: -- autonomous to keep from commiting data on the transaction.
437: PROCEDURE GENERATE_FINAL_PLSQL_TEXT(p_plsql_id IN NUMBER,
438: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,
439: x_final_plsql_text OUT NOCOPY VARCHAR2,
440: x_return_status OUT NOCOPY VARCHAR2,
441: x_return_msg OUT NOCOPY VARCHAR2)
442: IS

Line 516: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,

512:
513: -- Private helper to EXECUTE_PLSQL* to take a foreign plsql_id and prepare it by parsing it into
514: -- a cursor and fetching the arg list
515: PROCEDURE ADD_PLSQL_TO_CACHE(p_plsql_id IN NUMBER,
516: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,
517: p_use_splitting IN BOOLEAN,
518: x_return_status OUT NOCOPY VARCHAR2,
519: x_return_msg OUT NOCOPY VARCHAR2)
520: IS

Line 528: l_arg_list FND_OAM_DSCRAM_ARGS_PKG.arg_list;

524:
525: l_stat_id NUMBER;
526: l_cache_entry b_plsql_cache_entry;
527: l_cursor_id INTEGER;
528: l_arg_list FND_OAM_DSCRAM_ARGS_PKG.arg_list;
529: l_has_writable_args BOOLEAN;
530:
531: l_return_status VARCHAR2(6);
532: l_return_msg VARCHAR2(4000);

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

627:
628: -- Private, helper to EXECUTE_PLSQL* procedures to do the grunt work. the call to complete the PLSQL
629: -- will be done by the caller. No commits or rollbacks are done here.
630: PROCEDURE INTERNAL_EXECUTE_PLSQL(p_plsql_id IN NUMBER,
631: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,
632: p_use_splitting IN BOOLEAN,
633: p_rowid_lbound IN ROWID,
634: p_rowid_ubound IN ROWID,
635: x_return_status OUT NOCOPY VARCHAR2,

Line 679: FND_OAM_DSCRAM_ARGS_PKG.BIND_ARG_LIST_TO_CURSOR(b_plsql_cache(p_plsql_id).arg_list,

675: END IF;
676:
677: --before every execution, re-bind the readable argument values. This may or may not change the
678: --value of the binding depending on the arg's write policy.
679: FND_OAM_DSCRAM_ARGS_PKG.BIND_ARG_LIST_TO_CURSOR(b_plsql_cache(p_plsql_id).arg_list,
680: px_arg_context,
681: b_plsql_cache(p_plsql_id).cursor_id,
682: p_use_splitting,
683: p_rowid_lbound,

Line 715: FND_OAM_DSCRAM_ARGS_PKG.UPDATE_WRITABLE_ARG_VALUES(b_plsql_cache(p_plsql_id).arg_list,

711: END IF;
712:
713: -- If the plsql has any output variables, we should get values for them
714: IF b_plsql_cache(p_plsql_id).has_writable_args THEN
715: FND_OAM_DSCRAM_ARGS_PKG.UPDATE_WRITABLE_ARG_VALUES(b_plsql_cache(p_plsql_id).arg_list,
716: px_arg_context,
717: NOT p_use_splitting, --we're finished if we're not splitting
718: p_use_splitting,
719: p_rowid_lbound,

Line 751: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,

747: END;
748:
749: -- Public
750: PROCEDURE EXECUTE_PLSQL(p_plsql_id IN NUMBER,
751: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,
752: x_return_status OUT NOCOPY VARCHAR2,
753: x_return_msg OUT NOCOPY VARCHAR2)
754: IS
755: l_ctxt VARCHAR2(60) := PKG_NAME||'EXECUTE_PLSQL';

Line 826: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,

822: END;
823:
824: -- Public
825: PROCEDURE EXECUTE_PLSQL_ON_RANGE(p_plsql_id IN NUMBER,
826: px_arg_context IN OUT NOCOPY FND_OAM_DSCRAM_ARGS_PKG.arg_context,
827: p_rowid_lbound IN ROWID,
828: p_rowid_ubound IN ROWID,
829: x_return_status OUT NOCOPY VARCHAR2,
830: x_return_msg OUT NOCOPY VARCHAR2)