DBA Data[Home] [Help]

APPS.FND_OAM_DSCFG_COMPILER_PKG dependencies on FND_OAM_DSCRAM_UTILS_PKG

Line 11: B_DEFAULT_RUN_MODE CONSTANT VARCHAR2(30) := FND_OAM_DSCRAM_UTILS_PKG.G_MODE_NORMAL;

7: PKG_NAME CONSTANT VARCHAR2(20) := 'DSCFG_COMPILER_PKG.';
8:
9: -- Defaults used when creating engine entities
10: B_DEFAULT_NUM_BUNDLES CONSTANT NUMBER := 1;
11: B_DEFAULT_RUN_MODE CONSTANT VARCHAR2(30) := FND_OAM_DSCRAM_UTILS_PKG.G_MODE_NORMAL;
12:
13: --Pseudo-private state set and returned by public Getters
14: B_DEFAULT_WORKERS_ALLOWED NUMBER := NULL; -- set to MAX(#CPU-1,1) by first call to compile_config_instance
15: B_DEFAULT_BATCH_SIZE CONSTANT NUMBER := 10000;

Line 1624: IF b_run.run_mode NOT IN (FND_OAM_DSCRAM_UTILS_PKG.G_MODE_NORMAL,

1620: p_property_name => FND_OAM_DSCFG_API_PKG.G_PROP_RUN_MODE,
1621: p_varchar2_value => b_run.run_mode,
1622: x_property_id => l_property_id);
1623: ELSE
1624: IF b_run.run_mode NOT IN (FND_OAM_DSCRAM_UTILS_PKG.G_MODE_NORMAL,
1625: FND_OAM_DSCRAM_UTILS_PKG.G_MODE_TEST,
1626: FND_OAM_DSCRAM_UTILS_PKG.G_MODE_TEST_NO_EXEC,
1627: FND_OAM_DSCRAM_UTILS_PKG.G_MODE_DIAGNOSTIC) THEN
1628: l_msg := 'Invalid run mode specified: "'||b_run.run_mode||'".';

Line 1625: FND_OAM_DSCRAM_UTILS_PKG.G_MODE_TEST,

1621: p_varchar2_value => b_run.run_mode,
1622: x_property_id => l_property_id);
1623: ELSE
1624: IF b_run.run_mode NOT IN (FND_OAM_DSCRAM_UTILS_PKG.G_MODE_NORMAL,
1625: FND_OAM_DSCRAM_UTILS_PKG.G_MODE_TEST,
1626: FND_OAM_DSCRAM_UTILS_PKG.G_MODE_TEST_NO_EXEC,
1627: FND_OAM_DSCRAM_UTILS_PKG.G_MODE_DIAGNOSTIC) THEN
1628: l_msg := 'Invalid run mode specified: "'||b_run.run_mode||'".';
1629: fnd_oam_debug.log(3, l_ctxt, l_msg);

Line 1626: FND_OAM_DSCRAM_UTILS_PKG.G_MODE_TEST_NO_EXEC,

1622: x_property_id => l_property_id);
1623: ELSE
1624: IF b_run.run_mode NOT IN (FND_OAM_DSCRAM_UTILS_PKG.G_MODE_NORMAL,
1625: FND_OAM_DSCRAM_UTILS_PKG.G_MODE_TEST,
1626: FND_OAM_DSCRAM_UTILS_PKG.G_MODE_TEST_NO_EXEC,
1627: FND_OAM_DSCRAM_UTILS_PKG.G_MODE_DIAGNOSTIC) THEN
1628: l_msg := 'Invalid run mode specified: "'||b_run.run_mode||'".';
1629: fnd_oam_debug.log(3, l_ctxt, l_msg);
1630: MARK_OBJECT_AS_ERRORED(b_run.object_id,

Line 1627: FND_OAM_DSCRAM_UTILS_PKG.G_MODE_DIAGNOSTIC) THEN

1623: ELSE
1624: IF b_run.run_mode NOT IN (FND_OAM_DSCRAM_UTILS_PKG.G_MODE_NORMAL,
1625: FND_OAM_DSCRAM_UTILS_PKG.G_MODE_TEST,
1626: FND_OAM_DSCRAM_UTILS_PKG.G_MODE_TEST_NO_EXEC,
1627: FND_OAM_DSCRAM_UTILS_PKG.G_MODE_DIAGNOSTIC) THEN
1628: l_msg := 'Invalid run mode specified: "'||b_run.run_mode||'".';
1629: fnd_oam_debug.log(3, l_ctxt, l_msg);
1630: MARK_OBJECT_AS_ERRORED(b_run.object_id,
1631: l_msg);

Line 1696: IF NOT FND_OAM_DSCRAM_UTILS_PKG.DELETE_RUN(b_run.run_id) THEN

1692: FROM dual;
1693: ELSE
1694: fnd_oam_debug.log(1, l_ctxt, 'Deleting Existing, Stale run_id: '||b_run.run_id);
1695: --TODO: make this smarter
1696: IF NOT FND_OAM_DSCRAM_UTILS_PKG.DELETE_RUN(b_run.run_id) THEN
1697: l_msg := 'Failed to delete previously compiled run: '||b_run.run_id;
1698: fnd_oam_debug.log(3, l_ctxt, l_msg);
1699: END IF;
1700: END IF;

Line 1723: FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_UNPROCESSED,

1719: LAST_UPDATE_LOGIN
1720: )
1721: VALUES
1722: (b_run.run_id,
1723: FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_UNPROCESSED,
1724: b_run.run_mode,
1725: l_dbname,
1726: p_config_instance_id,
1727: b_run.valid_check_interval,

Line 2022: FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_UNPROCESSED,

2018: )
2019: VALUES
2020: (FND_OAM_DSCRAM_BUNDLES_S.NEXTVAL,
2021: b_run.run_id,
2022: FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_UNPROCESSED,
2023: b_bundles(k).target_hostname,
2024: b_bundles(k).workers_allowed,
2025: 0,
2026: b_bundles(k).batch_size,

Line 2153: FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_UNPROCESSED,

2149: (px_unit_id,
2150: p_task_id,
2151: p_concurrent_group_unit_id,
2152: p_unit_type,
2153: FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_UNPROCESSED,
2154: p_phase,
2155: p_priority,
2156: p_weight,
2157: p_workers_allowed,

Line 2620: FND_OAM_DSCRAM_UTILS_PKG.G_UNIT_TYPE_CONC_GROUP,

2616: --create the necessary units
2617: IF l_unit_id IS NOT NULL THEN
2618: --concurrent_units case
2619: ADD_ENGINE_UNIT(p_task_id,
2620: FND_OAM_DSCRAM_UTILS_PKG.G_UNIT_TYPE_CONC_GROUP,
2621: p_phase => px_bound_operations_phase,
2622: p_weight => l_unit_logical_weight,
2623: p_unit_object_owner => l_table_owner,
2624: p_unit_object_name => l_table_name,

Line 2629: FND_OAM_DSCRAM_UTILS_PKG.G_UNIT_TYPE_DML_SET,

2625: px_unit_id => l_unit_id);
2626: -- create child units, weight and phase are meaningless here
2627: IF l_dml_unit_id IS NOT NULL THEN
2628: ADD_ENGINE_UNIT(p_task_id,
2629: FND_OAM_DSCRAM_UTILS_PKG.G_UNIT_TYPE_DML_SET,
2630: p_concurrent_group_unit_id => l_unit_id,
2631: px_unit_id => l_dml_unit_id);
2632: END IF;
2633: IF l_plsql_unit_id IS NOT NULL THEN

Line 2635: FND_OAM_DSCRAM_UTILS_PKG.G_UNIT_TYPE_PLSQL_SET,

2631: px_unit_id => l_dml_unit_id);
2632: END IF;
2633: IF l_plsql_unit_id IS NOT NULL THEN
2634: ADD_ENGINE_UNIT(p_task_id,
2635: FND_OAM_DSCRAM_UTILS_PKG.G_UNIT_TYPE_PLSQL_SET,
2636: p_concurrent_group_unit_id => l_unit_id,
2637: px_unit_id => l_plsql_unit_id);
2638: END IF;
2639: ELSE

Line 2643: FND_OAM_DSCRAM_UTILS_PKG.G_UNIT_TYPE_DML_SET,

2639: ELSE
2640: --create topmost unit depending on which unit_id isn't null
2641: IF l_dml_unit_id IS NOT NULL THEN
2642: ADD_ENGINE_UNIT(p_task_id,
2643: FND_OAM_DSCRAM_UTILS_PKG.G_UNIT_TYPE_DML_SET,
2644: p_phase => px_bound_operations_phase,
2645: p_weight => l_unit_logical_weight,
2646: p_unit_object_owner => l_table_owner,
2647: p_unit_object_name => l_table_name,

Line 2651: FND_OAM_DSCRAM_UTILS_PKG.G_UNIT_TYPE_PLSQL_SET,

2647: p_unit_object_name => l_table_name,
2648: px_unit_id => l_dml_unit_id);
2649: ELSIF l_plsql_unit_id IS NOT NULL THEN
2650: ADD_ENGINE_UNIT(p_task_id,
2651: FND_OAM_DSCRAM_UTILS_PKG.G_UNIT_TYPE_PLSQL_SET,
2652: p_phase => px_bound_operations_phase,
2653: p_weight => l_unit_logical_weight,
2654: p_unit_object_owner => l_table_owner,
2655: p_unit_object_name => l_table_name,

Line 2827: IF b_run.run_mode <> FND_OAM_DSCRAM_UTILS_PKG.G_MODE_NORMAL THEN

2823: WHEN FND_OAM_DSCFG_API_PKG.G_OTYPE_DML_TRUNCATE_STMT THEN
2824: l_truncate_stmt := b_dml_truncate_stmts(l_object_id);
2825:
2826: --if the run mode isn't normal, truncates need to become deletes so they can be rolled back
2827: IF b_run.run_mode <> FND_OAM_DSCRAM_UTILS_PKG.G_MODE_NORMAL THEN
2828: --since these deletes can take a long time, give a more accurate perf viewpoint by just skipping
2829: --the truncate
2830: MARK_OBJECT_WITH_WARNING(l_object_id,
2831: l_ctxt,

Line 2899: FND_OAM_DSCRAM_UTILS_PKG.G_UNIT_TYPE_PLSQL_SET,

2895: --unbound pl/sql, run in phases after truncate and also can't be split
2896: BEGIN
2897: l_unit_id := NULL;
2898: ADD_ENGINE_UNIT(p_task_id,
2899: FND_OAM_DSCRAM_UTILS_PKG.G_UNIT_TYPE_PLSQL_SET,
2900: p_phase => px_unbound_plsql_phase,
2901: p_weight => l_plsql.weight,
2902: p_disable_splitting => FND_API.G_TRUE,
2903: px_unit_id => l_unit_id);

Line 2951: FND_OAM_DSCRAM_UTILS_PKG.G_UNIT_TYPE_DML_SET,

2947: BEGIN
2948: l_unit_id := NULL;
2949: --even though truncates don't use AD splitting, store the unit object owner/name to simplify reporting
2950: ADD_ENGINE_UNIT(p_task_id,
2951: FND_OAM_DSCRAM_UTILS_PKG.G_UNIT_TYPE_DML_SET,
2952: p_phase => px_truncate_phase,
2953: p_weight => l_weight,
2954: p_unit_object_owner => l_table_owner,
2955: p_unit_object_name => l_table_name,

Line 3148: FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_UNPROCESSED,

3144: )
3145: VALUES
3146: (l_task_id,
3147: b_bundles(l_bundle_object_id).bundle_id,
3148: FND_OAM_DSCRAM_UTILS_PKG.G_STATUS_UNPROCESSED,
3149: l_weight,
3150: 0,
3151: FND_GLOBAL.USER_ID,
3152: SYSDATE,