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_UTILS_PKG dependencies on DBMS_SQL

Line 501: l_ids DBMS_SQL.NUMBER_TABLE;

497: PROCEDURE DELETE_ARGS(p_object_type IN VARCHAR2,
498: p_object_id IN VARCHAR2)
499: IS
500: l_ctxt VARCHAR2(60) := PKG_NAME||'DELETE_ARGS';
501: l_ids DBMS_SQL.NUMBER_TABLE;
502: k NUMBER;
503: l_id NUMBER;
504: BEGIN
505: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

Line 543: l_ids DBMS_SQL.NUMBER_TABLE;

539: IS
540: l_ctxt VARCHAR2(60) := PKG_NAME||'DELETE_AD_DATA';
541:
542: l_script_key VARCHAR2(30) := MAKE_AD_SCRIPT_KEY(p_run_id, p_unit_id);
543: l_ids DBMS_SQL.NUMBER_TABLE;
544: l_id NUMBER;
545:
546: k NUMBER;
547: BEGIN

Line 585: l_ids DBMS_SQL.NUMBER_TABLE;

581: RETURN BOOLEAN
582: IS
583: l_ctxt VARCHAR2(60) := PKG_NAME||'DELETE_PLSQL';
584:
585: l_ids DBMS_SQL.NUMBER_TABLE;
586: k NUMBER;
587:
588: BEGIN
589: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

Line 619: l_ids DBMS_SQL.NUMBER_TABLE;

615: RETURN BOOLEAN
616: IS
617: l_ctxt VARCHAR2(60) := PKG_NAME||'DELETE_DML';
618:
619: l_ids DBMS_SQL.NUMBER_TABLE;
620: k NUMBER;
621:
622: BEGIN
623: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

Line 654: l_ids DBMS_SQL.NUMBER_TABLE;

650: RETURN BOOLEAN
651: IS
652: l_ctxt VARCHAR2(60) := PKG_NAME||'DELETE_UNIT';
653:
654: l_ids DBMS_SQL.NUMBER_TABLE;
655: l_unit_type VARCHAR2(30);
656: l_object_owner VARCHAR2(30);
657: l_object_name VARCHAR2(30);
658:

Line 757: l_ids DBMS_SQL.NUMBER_TABLE;

753: RETURN BOOLEAN
754: IS
755: l_ctxt VARCHAR2(60) := PKG_NAME||'DELETE_TASK';
756:
757: l_ids DBMS_SQL.NUMBER_TABLE;
758: k NUMBER;
759:
760: BEGIN
761: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

Line 807: l_ids DBMS_SQL.NUMBER_TABLE;

803: RETURN BOOLEAN
804: IS
805: l_ctxt VARCHAR2(60) := PKG_NAME||'DELETE_BUNDLE';
806:
807: l_ids DBMS_SQL.NUMBER_TABLE;
808: k NUMBER;
809:
810: BEGIN
811: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

Line 857: l_ids DBMS_SQL.NUMBER_TABLE;

853: l_ctxt VARCHAR2(60) := PKG_NAME||'DELETE_RUN';
854:
855: l_lock_handle VARCHAR2(128);
856: l_retval NUMBER;
857: l_ids DBMS_SQL.NUMBER_TABLE;
858: k NUMBER;
859:
860: l_retbool BOOLEAN;
861: BEGIN

Line 1120: FUNCTION GET_MAP_KEYS(p_map IN DBMS_SQL.NUMBER_TABLE)

1116: END;
1117:
1118: -- Private helper function to take the keys of a number_table and return them as an in order list. Useful
1119: -- for cases where we need a list that's 1->N for FORALL bulk binding. Keys are assumed to be numeric.
1120: FUNCTION GET_MAP_KEYS(p_map IN DBMS_SQL.NUMBER_TABLE)
1121: RETURN DBMS_SQL.NUMBER_TABLE
1122: IS
1123: l_list DBMS_SQL.NUMBER_TABLE;
1124: k NUMBER;

Line 1121: RETURN DBMS_SQL.NUMBER_TABLE

1117:
1118: -- Private helper function to take the keys of a number_table and return them as an in order list. Useful
1119: -- for cases where we need a list that's 1->N for FORALL bulk binding. Keys are assumed to be numeric.
1120: FUNCTION GET_MAP_KEYS(p_map IN DBMS_SQL.NUMBER_TABLE)
1121: RETURN DBMS_SQL.NUMBER_TABLE
1122: IS
1123: l_list DBMS_SQL.NUMBER_TABLE;
1124: k NUMBER;
1125: j NUMBER := 1;

Line 1123: l_list DBMS_SQL.NUMBER_TABLE;

1119: -- for cases where we need a list that's 1->N for FORALL bulk binding. Keys are assumed to be numeric.
1120: FUNCTION GET_MAP_KEYS(p_map IN DBMS_SQL.NUMBER_TABLE)
1121: RETURN DBMS_SQL.NUMBER_TABLE
1122: IS
1123: l_list DBMS_SQL.NUMBER_TABLE;
1124: k NUMBER;
1125: j NUMBER := 1;
1126: BEGIN
1127: k := p_map.FIRST;

Line 1138: PROCEDURE PREPARE_RUNS_FOR_RETRY(p_run_ids IN DBMS_SQL.NUMBER_TABLE,

1134: RETURN l_list;
1135: END;
1136:
1137: -- Forward Declarations
1138: PROCEDURE PREPARE_RUNS_FOR_RETRY(p_run_ids IN DBMS_SQL.NUMBER_TABLE,
1139: p_recurse_children IN VARCHAR2);
1140: PROCEDURE PREPARE_BUNDLES_FOR_RETRY(p_bundle_ids IN DBMS_SQL.NUMBER_TABLE,
1141: p_recurse_parents IN VARCHAR2,
1142: p_recurse_children IN VARCHAR2);

Line 1140: PROCEDURE PREPARE_BUNDLES_FOR_RETRY(p_bundle_ids IN DBMS_SQL.NUMBER_TABLE,

1136:
1137: -- Forward Declarations
1138: PROCEDURE PREPARE_RUNS_FOR_RETRY(p_run_ids IN DBMS_SQL.NUMBER_TABLE,
1139: p_recurse_children IN VARCHAR2);
1140: PROCEDURE PREPARE_BUNDLES_FOR_RETRY(p_bundle_ids IN DBMS_SQL.NUMBER_TABLE,
1141: p_recurse_parents IN VARCHAR2,
1142: p_recurse_children IN VARCHAR2);
1143: PROCEDURE PREPARE_TASKS_FOR_RETRY(p_task_ids IN DBMS_SQL.NUMBER_TABLE,
1144: p_recurse_parents IN VARCHAR2,

Line 1143: PROCEDURE PREPARE_TASKS_FOR_RETRY(p_task_ids IN DBMS_SQL.NUMBER_TABLE,

1139: p_recurse_children IN VARCHAR2);
1140: PROCEDURE PREPARE_BUNDLES_FOR_RETRY(p_bundle_ids IN DBMS_SQL.NUMBER_TABLE,
1141: p_recurse_parents IN VARCHAR2,
1142: p_recurse_children IN VARCHAR2);
1143: PROCEDURE PREPARE_TASKS_FOR_RETRY(p_task_ids IN DBMS_SQL.NUMBER_TABLE,
1144: p_recurse_parents IN VARCHAR2,
1145: p_recurse_children IN VARCHAR2);
1146: PROCEDURE PREPARE_UNITS_FOR_RETRY(p_unit_ids IN DBMS_SQL.NUMBER_TABLE,
1147: p_recurse_parents IN VARCHAR2,

Line 1146: PROCEDURE PREPARE_UNITS_FOR_RETRY(p_unit_ids IN DBMS_SQL.NUMBER_TABLE,

1142: p_recurse_children IN VARCHAR2);
1143: PROCEDURE PREPARE_TASKS_FOR_RETRY(p_task_ids IN DBMS_SQL.NUMBER_TABLE,
1144: p_recurse_parents IN VARCHAR2,
1145: p_recurse_children IN VARCHAR2);
1146: PROCEDURE PREPARE_UNITS_FOR_RETRY(p_unit_ids IN DBMS_SQL.NUMBER_TABLE,
1147: p_recurse_parents IN VARCHAR2,
1148: p_recurse_children IN VARCHAR2);
1149: PROCEDURE PREPARE_DMLS_FOR_RETRY(p_dml_ids IN DBMS_SQL.NUMBER_TABLE,
1150: p_recurse_parents IN VARCHAR2);

Line 1149: PROCEDURE PREPARE_DMLS_FOR_RETRY(p_dml_ids IN DBMS_SQL.NUMBER_TABLE,

1145: p_recurse_children IN VARCHAR2);
1146: PROCEDURE PREPARE_UNITS_FOR_RETRY(p_unit_ids IN DBMS_SQL.NUMBER_TABLE,
1147: p_recurse_parents IN VARCHAR2,
1148: p_recurse_children IN VARCHAR2);
1149: PROCEDURE PREPARE_DMLS_FOR_RETRY(p_dml_ids IN DBMS_SQL.NUMBER_TABLE,
1150: p_recurse_parents IN VARCHAR2);
1151: PROCEDURE PREPARE_PLSQLS_FOR_RETRY(p_plsql_ids IN DBMS_SQL.NUMBER_TABLE,
1152: p_recurse_parents IN VARCHAR2);
1153:

Line 1151: PROCEDURE PREPARE_PLSQLS_FOR_RETRY(p_plsql_ids IN DBMS_SQL.NUMBER_TABLE,

1147: p_recurse_parents IN VARCHAR2,
1148: p_recurse_children IN VARCHAR2);
1149: PROCEDURE PREPARE_DMLS_FOR_RETRY(p_dml_ids IN DBMS_SQL.NUMBER_TABLE,
1150: p_recurse_parents IN VARCHAR2);
1151: PROCEDURE PREPARE_PLSQLS_FOR_RETRY(p_plsql_ids IN DBMS_SQL.NUMBER_TABLE,
1152: p_recurse_parents IN VARCHAR2);
1153:
1154: -- Private, prepares multiple plsqls for retry at once.
1155: PROCEDURE PREPARE_PLSQLS_FOR_RETRY(p_plsql_ids IN DBMS_SQL.NUMBER_TABLE,

Line 1155: PROCEDURE PREPARE_PLSQLS_FOR_RETRY(p_plsql_ids IN DBMS_SQL.NUMBER_TABLE,

1151: PROCEDURE PREPARE_PLSQLS_FOR_RETRY(p_plsql_ids IN DBMS_SQL.NUMBER_TABLE,
1152: p_recurse_parents IN VARCHAR2);
1153:
1154: -- Private, prepares multiple plsqls for retry at once.
1155: PROCEDURE PREPARE_PLSQLS_FOR_RETRY(p_plsql_ids IN DBMS_SQL.NUMBER_TABLE,
1156: p_recurse_parents IN VARCHAR2)
1157: IS
1158: l_ctxt VARCHAR2(60) := PKG_NAME||'PREPARE_PLSQLS_FOR_RETRY';
1159:

Line 1161: l_parents_map DBMS_SQL.NUMBER_TABLE;

1157: IS
1158: l_ctxt VARCHAR2(60) := PKG_NAME||'PREPARE_PLSQLS_FOR_RETRY';
1159:
1160: l_parent_id NUMBER;
1161: l_parents_map DBMS_SQL.NUMBER_TABLE;
1162: j NUMBER;
1163: k NUMBER;
1164: l_msg VARCHAR2(4000);
1165: BEGIN

Line 1219: PROCEDURE PREPARE_DMLS_FOR_RETRY(p_dml_ids IN DBMS_SQL.NUMBER_TABLE,

1215: RAISE_APPLICATION_ERROR(-20000, l_msg, TRUE);
1216: END;
1217:
1218: -- Private, prepares multiple dmls for retry at once.
1219: PROCEDURE PREPARE_DMLS_FOR_RETRY(p_dml_ids IN DBMS_SQL.NUMBER_TABLE,
1220: p_recurse_parents IN VARCHAR2)
1221: IS
1222: l_ctxt VARCHAR2(60) := PKG_NAME||'PREPARE_DMLS_FOR_RETRY';
1223:

Line 1225: l_parents_map DBMS_SQL.NUMBER_TABLE;

1221: IS
1222: l_ctxt VARCHAR2(60) := PKG_NAME||'PREPARE_DMLS_FOR_RETRY';
1223:
1224: l_parent_id NUMBER;
1225: l_parents_map DBMS_SQL.NUMBER_TABLE;
1226: j NUMBER;
1227: k NUMBER;
1228: l_msg VARCHAR2(4000);
1229: BEGIN

Line 1283: PROCEDURE PREPARE_UNITS_FOR_RETRY(p_unit_ids IN DBMS_SQL.NUMBER_TABLE,

1279: RAISE_APPLICATION_ERROR(-20000, l_msg, TRUE);
1280: END;
1281:
1282: -- Private, prepares multiple units for retry at once.
1283: PROCEDURE PREPARE_UNITS_FOR_RETRY(p_unit_ids IN DBMS_SQL.NUMBER_TABLE,
1284: p_recurse_parents IN VARCHAR2,
1285: p_recurse_children IN VARCHAR2)
1286: IS
1287: l_ctxt VARCHAR2(60) := PKG_NAME||'PREPARE_UNITS_FOR_RETRY';

Line 1289: l_ids DBMS_SQL.NUMBER_TABLE;

1285: p_recurse_children IN VARCHAR2)
1286: IS
1287: l_ctxt VARCHAR2(60) := PKG_NAME||'PREPARE_UNITS_FOR_RETRY';
1288:
1289: l_ids DBMS_SQL.NUMBER_TABLE;
1290: l_parent_id NUMBER;
1291: l_parents_map DBMS_SQL.NUMBER_TABLE;
1292: j NUMBER;
1293: k NUMBER;

Line 1291: l_parents_map DBMS_SQL.NUMBER_TABLE;

1287: l_ctxt VARCHAR2(60) := PKG_NAME||'PREPARE_UNITS_FOR_RETRY';
1288:
1289: l_ids DBMS_SQL.NUMBER_TABLE;
1290: l_parent_id NUMBER;
1291: l_parents_map DBMS_SQL.NUMBER_TABLE;
1292: j NUMBER;
1293: k NUMBER;
1294: l_msg VARCHAR2(4000);
1295: BEGIN

Line 1396: PROCEDURE PREPARE_TASKS_FOR_RETRY(p_task_ids IN DBMS_SQL.NUMBER_TABLE,

1392: RAISE_APPLICATION_ERROR(-20000, l_msg, TRUE);
1393: END;
1394:
1395: -- Private, prepares multiple tasks for retry at once.
1396: PROCEDURE PREPARE_TASKS_FOR_RETRY(p_task_ids IN DBMS_SQL.NUMBER_TABLE,
1397: p_recurse_parents IN VARCHAR2,
1398: p_recurse_children IN VARCHAR2)
1399: IS
1400: l_ctxt VARCHAR2(60) := PKG_NAME||'PREPARE_TASKS_FOR_RETRY';

Line 1402: l_ids DBMS_SQL.NUMBER_TABLE;

1398: p_recurse_children IN VARCHAR2)
1399: IS
1400: l_ctxt VARCHAR2(60) := PKG_NAME||'PREPARE_TASKS_FOR_RETRY';
1401:
1402: l_ids DBMS_SQL.NUMBER_TABLE;
1403: l_parent_id NUMBER;
1404: l_parents_map DBMS_SQL.NUMBER_TABLE;
1405: j NUMBER;
1406: k NUMBER;

Line 1404: l_parents_map DBMS_SQL.NUMBER_TABLE;

1400: l_ctxt VARCHAR2(60) := PKG_NAME||'PREPARE_TASKS_FOR_RETRY';
1401:
1402: l_ids DBMS_SQL.NUMBER_TABLE;
1403: l_parent_id NUMBER;
1404: l_parents_map DBMS_SQL.NUMBER_TABLE;
1405: j NUMBER;
1406: k NUMBER;
1407: l_msg VARCHAR2(4000);
1408: BEGIN

Line 1482: PROCEDURE PREPARE_BUNDLES_FOR_RETRY(p_bundle_ids IN DBMS_SQL.NUMBER_TABLE,

1478: RAISE_APPLICATION_ERROR(-20000, l_msg, TRUE);
1479: END;
1480:
1481: -- Private, prepares multiple bundles for retry at once.
1482: PROCEDURE PREPARE_BUNDLES_FOR_RETRY(p_bundle_ids IN DBMS_SQL.NUMBER_TABLE,
1483: p_recurse_parents IN VARCHAR2,
1484: p_recurse_children IN VARCHAR2)
1485: IS
1486: l_ctxt VARCHAR2(60) := PKG_NAME||'PREPARE_BUNDLES_FOR_RETRY';

Line 1488: l_ids DBMS_SQL.NUMBER_TABLE;

1484: p_recurse_children IN VARCHAR2)
1485: IS
1486: l_ctxt VARCHAR2(60) := PKG_NAME||'PREPARE_BUNDLES_FOR_RETRY';
1487:
1488: l_ids DBMS_SQL.NUMBER_TABLE;
1489: l_parent_id NUMBER;
1490: l_parents_map DBMS_SQL.NUMBER_TABLE;
1491: j NUMBER;
1492: k NUMBER;

Line 1490: l_parents_map DBMS_SQL.NUMBER_TABLE;

1486: l_ctxt VARCHAR2(60) := PKG_NAME||'PREPARE_BUNDLES_FOR_RETRY';
1487:
1488: l_ids DBMS_SQL.NUMBER_TABLE;
1489: l_parent_id NUMBER;
1490: l_parents_map DBMS_SQL.NUMBER_TABLE;
1491: j NUMBER;
1492: k NUMBER;
1493: l_msg VARCHAR2(4000);
1494: BEGIN

Line 1567: PROCEDURE PREPARE_RUNS_FOR_RETRY(p_run_ids IN DBMS_SQL.NUMBER_TABLE,

1563: RAISE_APPLICATION_ERROR(-20000, l_msg, TRUE);
1564: END;
1565:
1566: -- Private, prepares multiple runs at once.
1567: PROCEDURE PREPARE_RUNS_FOR_RETRY(p_run_ids IN DBMS_SQL.NUMBER_TABLE,
1568: p_recurse_children IN VARCHAR2)
1569: IS
1570: l_ctxt VARCHAR2(60) := PKG_NAME||'PREPARE_RUNS_FOR_RETRY';
1571:

Line 1572: l_ids DBMS_SQL.NUMBER_TABLE;

1568: p_recurse_children IN VARCHAR2)
1569: IS
1570: l_ctxt VARCHAR2(60) := PKG_NAME||'PREPARE_RUNS_FOR_RETRY';
1571:
1572: l_ids DBMS_SQL.NUMBER_TABLE;
1573: k NUMBER;
1574: l_msg VARCHAR2(4000);
1575: BEGIN
1576: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

Line 1627: l_ids DBMS_SQL.NUMBER_TABLE;

1623:
1624: l_lock_handle VARCHAR2(128);
1625: l_retval NUMBER;
1626: l_status VARCHAR2(30);
1627: l_ids DBMS_SQL.NUMBER_TABLE;
1628:
1629: l_msg VARCHAR2(4000);
1630: BEGIN
1631: fnd_oam_debug.log(2, l_ctxt, 'ENTER');