1328: p_canon_value,
1329: p_src_type,
1330: p_src_text,
1331: p_src_where_clause,
1332: FND_GLOBAL.USER_ID,
1333: SYSDATE,
1334: FND_GLOBAL.USER_ID,
1335: SYSDATE,
1336: FND_GLOBAL.USER_ID)
1330: p_src_text,
1331: p_src_where_clause,
1332: FND_GLOBAL.USER_ID,
1333: SYSDATE,
1334: FND_GLOBAL.USER_ID,
1335: SYSDATE,
1336: FND_GLOBAL.USER_ID)
1337: RETURNING ARG_ID INTO l_retval;
1338:
1332: FND_GLOBAL.USER_ID,
1333: SYSDATE,
1334: FND_GLOBAL.USER_ID,
1335: SYSDATE,
1336: FND_GLOBAL.USER_ID)
1337: RETURNING ARG_ID INTO l_retval;
1338:
1339: INSERT INTO FND_OAM_DSCRAM_ARGS_TL (ARG_ID,
1340: DISPLAY_NAME,
1350: VALUES
1351: (l_retval,
1352: 'ARG'||l_retval,
1353: 'DESC'||l_retval,
1354: FND_GLOBAL.CURRENT_LANGUAGE,
1355: FND_GLOBAL.CURRENT_LANGUAGE,
1356: FND_GLOBAL.USER_ID,
1357: SYSDATE,
1358: FND_GLOBAL.USER_ID,
1351: (l_retval,
1352: 'ARG'||l_retval,
1353: 'DESC'||l_retval,
1354: FND_GLOBAL.CURRENT_LANGUAGE,
1355: FND_GLOBAL.CURRENT_LANGUAGE,
1356: FND_GLOBAL.USER_ID,
1357: SYSDATE,
1358: FND_GLOBAL.USER_ID,
1359: SYSDATE,
1352: 'ARG'||l_retval,
1353: 'DESC'||l_retval,
1354: FND_GLOBAL.CURRENT_LANGUAGE,
1355: FND_GLOBAL.CURRENT_LANGUAGE,
1356: FND_GLOBAL.USER_ID,
1357: SYSDATE,
1358: FND_GLOBAL.USER_ID,
1359: SYSDATE,
1360: FND_GLOBAL.USER_ID);
1354: FND_GLOBAL.CURRENT_LANGUAGE,
1355: FND_GLOBAL.CURRENT_LANGUAGE,
1356: FND_GLOBAL.USER_ID,
1357: SYSDATE,
1358: FND_GLOBAL.USER_ID,
1359: SYSDATE,
1360: FND_GLOBAL.USER_ID);
1361:
1362: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1356: FND_GLOBAL.USER_ID,
1357: SYSDATE,
1358: FND_GLOBAL.USER_ID,
1359: SYSDATE,
1360: FND_GLOBAL.USER_ID);
1361:
1362: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1363: x_arg_id := l_retval;
1364: RETURN TRUE;
1402: p_priority,
1403: p_weight,
1404: p_dml_stmt,
1405: p_where_clause,
1406: FND_GLOBAL.USER_ID,
1407: SYSDATE,
1408: FND_GLOBAL.USER_ID,
1409: SYSDATE,
1410: FND_GLOBAL.USER_ID)
1404: p_dml_stmt,
1405: p_where_clause,
1406: FND_GLOBAL.USER_ID,
1407: SYSDATE,
1408: FND_GLOBAL.USER_ID,
1409: SYSDATE,
1410: FND_GLOBAL.USER_ID)
1411: RETURNING DML_ID INTO l_retval;
1412:
1406: FND_GLOBAL.USER_ID,
1407: SYSDATE,
1408: FND_GLOBAL.USER_ID,
1409: SYSDATE,
1410: FND_GLOBAL.USER_ID)
1411: RETURNING DML_ID INTO l_retval;
1412:
1413: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1414: x_dml_id := l_retval;
1450: p_unit_id,
1451: p_priority,
1452: p_weight,
1453: p_plsql_text,
1454: FND_GLOBAL.USER_ID,
1455: SYSDATE,
1456: FND_GLOBAL.USER_ID,
1457: SYSDATE,
1458: FND_GLOBAL.USER_ID)
1452: p_weight,
1453: p_plsql_text,
1454: FND_GLOBAL.USER_ID,
1455: SYSDATE,
1456: FND_GLOBAL.USER_ID,
1457: SYSDATE,
1458: FND_GLOBAL.USER_ID)
1459: RETURNING PLSQL_ID INTO l_retval;
1460:
1454: FND_GLOBAL.USER_ID,
1455: SYSDATE,
1456: FND_GLOBAL.USER_ID,
1457: SYSDATE,
1458: FND_GLOBAL.USER_ID)
1459: RETURNING PLSQL_ID INTO l_retval;
1460:
1461: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1462: x_plsql_id := l_retval;
1533: p_batch_size,
1534: p_fatality_level,
1535: p_sug_disable_splitting,
1536: p_act_disable_splitting,
1537: FND_GLOBAL.USER_ID,
1538: SYSDATE,
1539: FND_GLOBAL.USER_ID,
1540: SYSDATE,
1541: FND_GLOBAL.USER_ID)
1535: p_sug_disable_splitting,
1536: p_act_disable_splitting,
1537: FND_GLOBAL.USER_ID,
1538: SYSDATE,
1539: FND_GLOBAL.USER_ID,
1540: SYSDATE,
1541: FND_GLOBAL.USER_ID)
1542: RETURNING UNIT_ID INTO l_retval;
1543:
1537: FND_GLOBAL.USER_ID,
1538: SYSDATE,
1539: FND_GLOBAL.USER_ID,
1540: SYSDATE,
1541: FND_GLOBAL.USER_ID)
1542: RETURNING UNIT_ID INTO l_retval;
1543:
1544: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1545: x_unit_id := l_retval;
1585: p_status,
1586: p_priority,
1587: p_weight,
1588: 0,
1589: FND_GLOBAL.USER_ID,
1590: SYSDATE,
1591: FND_GLOBAL.USER_ID,
1592: SYSDATE,
1593: FND_GLOBAL.USER_ID)
1587: p_weight,
1588: 0,
1589: FND_GLOBAL.USER_ID,
1590: SYSDATE,
1591: FND_GLOBAL.USER_ID,
1592: SYSDATE,
1593: FND_GLOBAL.USER_ID)
1594: RETURNING TASK_ID INTO l_retval;
1595:
1589: FND_GLOBAL.USER_ID,
1590: SYSDATE,
1591: FND_GLOBAL.USER_ID,
1592: SYSDATE,
1593: FND_GLOBAL.USER_ID)
1594: RETURNING TASK_ID INTO l_retval;
1595:
1596: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1597: x_task_id := l_retval;
1646: p_workers_allowed,
1647: 0,
1648: l_batch_size,
1649: p_min_par_weight,
1650: FND_GLOBAL.USER_ID,
1651: SYSDATE,
1652: FND_GLOBAL.USER_ID,
1653: SYSDATE,
1654: FND_GLOBAL.USER_ID);
1648: l_batch_size,
1649: p_min_par_weight,
1650: FND_GLOBAL.USER_ID,
1651: SYSDATE,
1652: FND_GLOBAL.USER_ID,
1653: SYSDATE,
1654: FND_GLOBAL.USER_ID);
1655:
1656: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1650: FND_GLOBAL.USER_ID,
1651: SYSDATE,
1652: FND_GLOBAL.USER_ID,
1653: SYSDATE,
1654: FND_GLOBAL.USER_ID);
1655:
1656: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1657: RETURN TRUE;
1658: EXCEPTION
1710: p_mode,
1711: l_dbname,
1712: p_weight,
1713: p_check_interval,
1714: FND_GLOBAL.USER_ID,
1715: SYSDATE,
1716: FND_GLOBAL.USER_ID,
1717: SYSDATE,
1718: FND_GLOBAL.USER_ID);
1712: p_weight,
1713: p_check_interval,
1714: FND_GLOBAL.USER_ID,
1715: SYSDATE,
1716: FND_GLOBAL.USER_ID,
1717: SYSDATE,
1718: FND_GLOBAL.USER_ID);
1719:
1720: INSERT INTO FND_OAM_DSCRAM_RUNS_TL (RUN_ID,
1714: FND_GLOBAL.USER_ID,
1715: SYSDATE,
1716: FND_GLOBAL.USER_ID,
1717: SYSDATE,
1718: FND_GLOBAL.USER_ID);
1719:
1720: INSERT INTO FND_OAM_DSCRAM_RUNS_TL (RUN_ID,
1721: DISPLAY_NAME,
1722: DESCRIPTION,
1731: VALUES
1732: (p_run_id,
1733: l_run_name,
1734: p_desc,
1735: FND_GLOBAL.CURRENT_LANGUAGE,
1736: FND_GLOBAL.CURRENT_LANGUAGE,
1737: FND_GLOBAL.USER_ID,
1738: SYSDATE,
1739: FND_GLOBAL.USER_ID,
1732: (p_run_id,
1733: l_run_name,
1734: p_desc,
1735: FND_GLOBAL.CURRENT_LANGUAGE,
1736: FND_GLOBAL.CURRENT_LANGUAGE,
1737: FND_GLOBAL.USER_ID,
1738: SYSDATE,
1739: FND_GLOBAL.USER_ID,
1740: SYSDATE,
1733: l_run_name,
1734: p_desc,
1735: FND_GLOBAL.CURRENT_LANGUAGE,
1736: FND_GLOBAL.CURRENT_LANGUAGE,
1737: FND_GLOBAL.USER_ID,
1738: SYSDATE,
1739: FND_GLOBAL.USER_ID,
1740: SYSDATE,
1741: FND_GLOBAL.USER_ID);
1735: FND_GLOBAL.CURRENT_LANGUAGE,
1736: FND_GLOBAL.CURRENT_LANGUAGE,
1737: FND_GLOBAL.USER_ID,
1738: SYSDATE,
1739: FND_GLOBAL.USER_ID,
1740: SYSDATE,
1741: FND_GLOBAL.USER_ID);
1742:
1743: --also create the run stats entry
1737: FND_GLOBAL.USER_ID,
1738: SYSDATE,
1739: FND_GLOBAL.USER_ID,
1740: SYSDATE,
1741: FND_GLOBAL.USER_ID);
1742:
1743: --also create the run stats entry
1744: FND_OAM_DSCRAM_STATS_PKG.CREATE_ENTRY_FOR_RUN(p_run_id => p_run_id,
1745: p_start_time => SYSDATE,