APPS.FND_OAM_DSCFG_INSTANCES_PKG dependencies on FND_OAM_DSCFG_INSTANCES

Line 1: PACKAGE BODY FND_OAM_DSCFG_INSTANCES_PKG as

1: PACKAGE BODY FND_OAM_DSCFG_INSTANCES_PKG as
2: /* $Header: AFOAMDSCINSTB.pls 120.1 2005/12/19 09:51 ilawler noship $ */
3:
4: ----------------------------------------
5: -- Private Body Constants

Line 105: UPDATE fnd_oam_dscfg_instances

101: IF NOT b_config_instance_info.initialized THEN
102: RAISE NO_DATA_FOUND;
103: END IF;
104:
105: UPDATE fnd_oam_dscfg_instances
106: SET last_imported = p_last_imported
107: WHERE config_instance_id = b_config_instance_info.config_instance_id;
108:
109: b_config_instance_info.last_imported := p_last_imported;

Line 132: UPDATE fnd_oam_dscfg_instances

128: IF NOT b_config_instance_info.initialized THEN
129: RAISE NO_DATA_FOUND;
130: END IF;
131:
132: UPDATE fnd_oam_dscfg_instances
133: SET import_duration = p_import_duration
134: WHERE config_instance_id = b_config_instance_info.config_instance_id;
135:
136: b_config_instance_info.import_duration := p_import_duration;

Line 160: UPDATE fnd_oam_dscfg_instances

156: IF NOT b_config_instance_info.initialized THEN
157: RAISE NO_DATA_FOUND;
158: END IF;
159:
160: UPDATE fnd_oam_dscfg_instances
161: SET last_compiled = p_last_compiled
162: WHERE config_instance_id = b_config_instance_info.config_instance_id;
163:
164: b_config_instance_info.last_compiled := p_last_compiled;

Line 188: UPDATE fnd_oam_dscfg_instances

184: IF NOT b_config_instance_info.initialized THEN
185: RAISE NO_DATA_FOUND;
186: END IF;
187:
188: UPDATE fnd_oam_dscfg_instances
189: SET compile_duration = p_compile_duration
190: WHERE config_instance_id = b_config_instance_info.config_instance_id;
191:
192: b_config_instance_info.compile_duration := p_compile_duration;

Line 227: FROM fnd_oam_dscfg_instances

223: CASE p_config_instance_type
224: WHEN FND_OAM_DSCFG_API_PKG.G_CONFTYPE_CLONING THEN
225: SELECT config_instance_id
226: INTO l_config_instance_id
227: FROM fnd_oam_dscfg_instances
228: WHERE config_instance_type = p_config_instance_type
229: AND target_dbname = p_target_dbname
230: AND clone_key = p_clone_key
231: AND ((policyset_id IS NULL) OR (policyset_id = p_policyset_id));

Line 304: INSERT INTO fnd_oam_dscfg_instances (CONFIG_INSTANCE_ID,

300: RAISE PROGRAM_ERROR;
301: END IF;
302:
303: --do the insert
304: INSERT INTO fnd_oam_dscfg_instances (CONFIG_INSTANCE_ID,
305: TARGET_DBNAME,
306: CONFIG_INSTANCE_TYPE,
307: NAME,
308: DESCRIPTION,

Line 318: VALUES (FND_OAM_DSCFG_INSTANCES_S.NEXTVAL,

314: CREATION_DATE,
315: LAST_UPDATED_BY,
316: LAST_UPDATE_DATE,
317: LAST_UPDATE_LOGIN)
318: VALUES (FND_OAM_DSCFG_INSTANCES_S.NEXTVAL,
319: p_target_dbname,
320: p_config_instance_type,
321: p_name,
322: p_description,

Line 381: FROM fnd_oam_dscfg_instances

377:
378: --query out the instance attributes
379: SELECT target_dbname, config_instance_type, last_imported, import_duration, last_compiled, compile_duration, source_dbname, clone_key, policyset_id
380: INTO l_target_dbname, l_config_instance_type, l_last_imported, l_import_duration, l_last_compiled, l_compile_duration, l_source_dbname, l_clone_key, l_policyset_id
381: FROM fnd_oam_dscfg_instances
382: WHERE config_instance_id = p_config_instance_id;
383:
384: --set the state
385: INIT_STATE(p_config_instance_id => p_config_instance_id,

Line 475: DELETE FROM fnd_oam_dscfg_instances

471: END IF;
472:
473: --now delete the config instance
474: fnd_oam_debug.log(1, l_ctxt, 'Deleting the instance row');
475: DELETE FROM fnd_oam_dscfg_instances
476: WHERE config_instance_id = p_config_instance_id;
477:
478: --success
479: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 488: END FND_OAM_DSCFG_INSTANCES_PKG;

484: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
485: RETURN FALSE;
486: END;
487:
488: END FND_OAM_DSCFG_INSTANCES_PKG;