eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_OAM_DSCRAM_DIAG_PKG dependencies on DBMS_SQL

Line 116: v1_vals DBMS_SQL.NUMBER_TABLE;

112: v5 VARCHAR2(2000) := 'ROWDESC';
113: v5_len NUMBER := 993;
114: v5_tmp VARCHAR2(2000);
115:
116: v1_vals DBMS_SQL.NUMBER_TABLE;
117: v2_vals DBMS_SQL.NUMBER_TABLE;
118: v3_vals DBMS_SQL.VARCHAR2_TABLE;
119: v4_vals DBMS_SQL.DATE_TABLE;
120: v5_vals DBMS_SQL.VARCHAR2_TABLE;

Line 117: v2_vals DBMS_SQL.NUMBER_TABLE;

113: v5_len NUMBER := 993;
114: v5_tmp VARCHAR2(2000);
115:
116: v1_vals DBMS_SQL.NUMBER_TABLE;
117: v2_vals DBMS_SQL.NUMBER_TABLE;
118: v3_vals DBMS_SQL.VARCHAR2_TABLE;
119: v4_vals DBMS_SQL.DATE_TABLE;
120: v5_vals DBMS_SQL.VARCHAR2_TABLE;
121: BEGIN

Line 118: v3_vals DBMS_SQL.VARCHAR2_TABLE;

114: v5_tmp VARCHAR2(2000);
115:
116: v1_vals DBMS_SQL.NUMBER_TABLE;
117: v2_vals DBMS_SQL.NUMBER_TABLE;
118: v3_vals DBMS_SQL.VARCHAR2_TABLE;
119: v4_vals DBMS_SQL.DATE_TABLE;
120: v5_vals DBMS_SQL.VARCHAR2_TABLE;
121: BEGIN
122: fnd_oam_debug.log(1, l_ctxt, 'Creating Test Table Data');

Line 119: v4_vals DBMS_SQL.DATE_TABLE;

115:
116: v1_vals DBMS_SQL.NUMBER_TABLE;
117: v2_vals DBMS_SQL.NUMBER_TABLE;
118: v3_vals DBMS_SQL.VARCHAR2_TABLE;
119: v4_vals DBMS_SQL.DATE_TABLE;
120: v5_vals DBMS_SQL.VARCHAR2_TABLE;
121: BEGIN
122: fnd_oam_debug.log(1, l_ctxt, 'Creating Test Table Data');
123: l_stmt := 'INSERT INTO '||p_owner||'.'||p_table_name||' (C1, C2, C3, C4, C5) VALUES (:1, :2, :3, :4, :5)';

Line 120: v5_vals DBMS_SQL.VARCHAR2_TABLE;

116: v1_vals DBMS_SQL.NUMBER_TABLE;
117: v2_vals DBMS_SQL.NUMBER_TABLE;
118: v3_vals DBMS_SQL.VARCHAR2_TABLE;
119: v4_vals DBMS_SQL.DATE_TABLE;
120: v5_vals DBMS_SQL.VARCHAR2_TABLE;
121: BEGIN
122: fnd_oam_debug.log(1, l_ctxt, 'Creating Test Table Data');
123: l_stmt := 'INSERT INTO '||p_owner||'.'||p_table_name||' (C1, C2, C3, C4, C5) VALUES (:1, :2, :3, :4, :5)';
124:

Line 570: l_ids DBMS_SQL.NUMBER_TABLE;

566: PROCEDURE DELETE_ALL_DIAGNOSTIC_RUNS(x_verdict OUT NOCOPY VARCHAR2)
567: IS
568: l_ctxt VARCHAR2(60) := PKG_NAME||'DELETE_ALL_DIAGNOSTIC_RUNS';
569:
570: l_ids DBMS_SQL.NUMBER_TABLE;
571: k NUMBER;
572: l_retbool BOOLEAN;
573: BEGIN
574: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

Line 617: FUNCTION DELETE_GLOBAL_ARGS(p_global_arg_names IN DBMS_SQL.VARCHAR2_TABLE)

613: RETURN;
614: END;
615:
616: -- helper to remove a list of global arguments since these would affect later tests
617: FUNCTION DELETE_GLOBAL_ARGS(p_global_arg_names IN DBMS_SQL.VARCHAR2_TABLE)
618: RETURN BOOLEAN
619: IS
620: l_ctxt VARCHAR2(60) := PKG_NAME||'DELETE_GLOBAL_ARGS';
621: k NUMBER;

Line 946: l_ids DBMS_SQL.NUMBER_TABLE;

942: RETURN BOOLEAN
943: IS
944: l_ctxt VARCHAR2(60) := PKG_NAME||'VALIDATE_UNIT_RECURSIVE';
945: l_run_stat_id NUMBER;
946: l_ids DBMS_SQL.NUMBER_TABLE;
947: l_id NUMBER;
948: k NUMBER;
949: l_count NUMBER;
950: BEGIN

Line 1046: l_ids DBMS_SQL.NUMBER_TABLE;

1042: RETURN BOOLEAN
1043: IS
1044: l_ctxt VARCHAR2(60) := PKG_NAME||'VALIDATE_TASK_RECURSIVE';
1045: l_run_stat_id NUMBER;
1046: l_ids DBMS_SQL.NUMBER_TABLE;
1047: l_id NUMBER;
1048: k NUMBER;
1049: l_count_units NUMBER;
1050: BEGIN

Line 1126: l_ids DBMS_SQL.NUMBER_TABLE;

1122: RETURN BOOLEAN
1123: IS
1124: l_ctxt VARCHAR2(60) := PKG_NAME||'VALIDATE_BUNDLE_RECURSIVE';
1125: l_run_stat_id NUMBER;
1126: l_ids DBMS_SQL.NUMBER_TABLE;
1127: l_id NUMBER;
1128: k NUMBER;
1129: l_count_tasks NUMBER;
1130: BEGIN

Line 1206: l_ids DBMS_SQL.NUMBER_TABLE;

1202: RETURN BOOLEAN
1203: IS
1204: l_ctxt VARCHAR2(60) := PKG_NAME||'VALIDATE_RUN_RECURSIVE';
1205: l_run_stat_id NUMBER;
1206: l_ids DBMS_SQL.NUMBER_TABLE;
1207: l_id NUMBER;
1208: k NUMBER;
1209: l_count_bundles NUMBER;
1210: BEGIN

Line 2345: p_global_arg_names IN DBMS_SQL.VARCHAR2_TABLE)

2341:
2342: --Helper to execute_test3 to remove any state that will negatively impact future tests
2343: FUNCTION CLEANUP_TEST3(p_run_id IN NUMBER,
2344: p_bundle_id IN NUMBER,
2345: p_global_arg_names IN DBMS_SQL.VARCHAR2_TABLE)
2346: RETURN BOOLEAN
2347: IS
2348: l_ctxt VARCHAR2(60) := PKG_NAME||'CLEANUP_TEST3';
2349: l_retbool BOOLEAN;

Line 2381: l_global_arg_names DBMS_SQL.VARCHAR2_TABLE;

2377: l_worker_id NUMBER;
2378: l_task_id NUMBER;
2379: l_unit_id NUMBER;
2380: l_arg_name VARCHAR2(60);
2381: l_global_arg_names DBMS_SQL.VARCHAR2_TABLE;
2382:
2383: l_did_init BOOLEAN := FALSE;
2384: l_lock_handle VARCHAR2(128);
2385: l_retval NUMBER;

Line 2654: l_ids DBMS_SQL.NUMBER_TABLE;

2650: l_return_msg VARCHAR2(2048);
2651: k NUMBER;
2652: j NUMBER;
2653: l_count NUMBER;
2654: l_ids DBMS_SQL.NUMBER_TABLE;
2655: BEGIN
2656: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
2657:
2658: --first validate the run