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_DSCFG_PROC_LIBRARY_PKG dependencies on FND_OAM_DSCFG_API_PKG

Line 10: B_OTYPE_DISABLED_TRIGGER CONSTANT VARCHAR2(30) := FND_OAM_DSCFG_API_PKG.G_INTERNAL_PREFIX||'DISABLED_TRIGGER';

6: ----------------------------------------
7: PKG_NAME CONSTANT VARCHAR2(30) := 'DSCFG_PROC_LIBRARY_PKG.';
8:
9: -- Object Types
10: B_OTYPE_DISABLED_TRIGGER CONSTANT VARCHAR2(30) := FND_OAM_DSCFG_API_PKG.G_INTERNAL_PREFIX||'DISABLED_TRIGGER';
11: B_OTYPE_DISABLED_PRIMARY_KEY CONSTANT VARCHAR2(30) := FND_OAM_DSCFG_API_PKG.G_INTERNAL_PREFIX||'DISABLED_PRIMARY_KEY';
12:
13: -- Property_Names
14: B_PROP_TRIGGER_OWNER CONSTANT VARCHAR2(30) := 'TRIGGER_OWNER';

Line 11: B_OTYPE_DISABLED_PRIMARY_KEY CONSTANT VARCHAR2(30) := FND_OAM_DSCFG_API_PKG.G_INTERNAL_PREFIX||'DISABLED_PRIMARY_KEY';

7: PKG_NAME CONSTANT VARCHAR2(30) := 'DSCFG_PROC_LIBRARY_PKG.';
8:
9: -- Object Types
10: B_OTYPE_DISABLED_TRIGGER CONSTANT VARCHAR2(30) := FND_OAM_DSCFG_API_PKG.G_INTERNAL_PREFIX||'DISABLED_TRIGGER';
11: B_OTYPE_DISABLED_PRIMARY_KEY CONSTANT VARCHAR2(30) := FND_OAM_DSCFG_API_PKG.G_INTERNAL_PREFIX||'DISABLED_PRIMARY_KEY';
12:
13: -- Property_Names
14: B_PROP_TRIGGER_OWNER CONSTANT VARCHAR2(30) := 'TRIGGER_OWNER';
15: B_PROP_TRIGGER_NAME CONSTANT VARCHAR2(30) := 'TRIGGER_NAME';

Line 111: FND_OAM_DSCFG_API_PKG.GET_CURRENT_TARGET_TABLE_LIST(x_table_owners => l_table_owners,

107: BEGIN
108: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
109:
110: --get the owners/tables in scope of the engine
111: FND_OAM_DSCFG_API_PKG.GET_CURRENT_TARGET_TABLE_LIST(x_table_owners => l_table_owners,
112: x_table_names => l_table_names);
113: fnd_oam_debug.log(1, l_ctxt, 'Found '||l_table_owners.COUNT||' candidate target tables.');
114:
115: -- iterate across the tables found

Line 126: FND_OAM_DSCFG_API_PKG.ADD_OBJECT(p_object_type => B_OTYPE_DISABLED_TRIGGER,

122: fnd_oam_debug.log(1, l_ctxt, 'Processing Trigger('||l_seen||'): '||l_trig.trigger_owner||'.'||l_trig.trigger_name);
123:
124: fnd_oam_debug.log(1, l_ctxt, 'Creating corresponding dscfg_object...');
125: --create the disabled trigger object first since the alter trigger call is immediate
126: FND_OAM_DSCFG_API_PKG.ADD_OBJECT(p_object_type => B_OTYPE_DISABLED_TRIGGER,
127: x_object_id => l_object_id);
128:
129: --keep the object creation above the alter trigger since we want this object if the alter suceeds or fails.
130: --and properties for the trigger owner/name and when we disabled it

Line 131: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,

127: x_object_id => l_object_id);
128:
129: --keep the object creation above the alter trigger since we want this object if the alter suceeds or fails.
130: --and properties for the trigger owner/name and when we disabled it
131: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,
132: p_property_name => B_PROP_TRIGGER_OWNER,
133: p_varchar2_value => l_trig.trigger_owner,
134: x_property_id => l_property_id);
135: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,

Line 135: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,

131: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,
132: p_property_name => B_PROP_TRIGGER_OWNER,
133: p_varchar2_value => l_trig.trigger_owner,
134: x_property_id => l_property_id);
135: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,
136: p_property_name => B_PROP_TRIGGER_NAME,
137: p_varchar2_value => l_trig.trigger_name,
138: x_property_id => l_property_id);
139: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,

Line 139: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,

135: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,
136: p_property_name => B_PROP_TRIGGER_NAME,
137: p_varchar2_value => l_trig.trigger_name,
138: x_property_id => l_property_id);
139: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,
140: p_property_name => B_PROP_TRIGGER_DISABLED_DATE,
141: p_date_value => SYSDATE,
142: x_property_id => l_property_id);
143:

Line 203: FND_OAM_DSCFG_API_PKG.GET_OBJECTS_FOR_TYPE(p_object_type => B_OTYPE_DISABLED_TRIGGER,

199: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
200:
201: --get all objects representing disabled triggers which don't have errors(flag=T) or have already been
202: --processed(flag=F).
203: FND_OAM_DSCFG_API_PKG.GET_OBJECTS_FOR_TYPE(p_object_type => B_OTYPE_DISABLED_TRIGGER,
204: p_errors_found_flag => NULL,
205: x_object_ids => l_object_ids);
206: fnd_oam_debug.log(1, l_ctxt, 'Found '||l_object_ids.COUNT||' processable disabled trigger objects.');
207:

Line 212: FND_OAM_DSCFG_API_PKG.GET_OBJECT_PROPERTY_VALUE(p_object_id => l_object_ids(k),

208: -- iterate across the objects found
209: k := l_object_ids.FIRST;
210: WHILE k IS NOT NULL LOOP
211: --get the trigger owner/name properties
212: FND_OAM_DSCFG_API_PKG.GET_OBJECT_PROPERTY_VALUE(p_object_id => l_object_ids(k),
213: p_property_name => B_PROP_TRIGGER_OWNER,
214: x_varchar2_value => l_trigger_owner);
215: FND_OAM_DSCFG_API_PKG.GET_OBJECT_PROPERTY_VALUE(p_object_id => l_object_ids(k),
216: p_property_name => B_PROP_TRIGGER_NAME,

Line 215: FND_OAM_DSCFG_API_PKG.GET_OBJECT_PROPERTY_VALUE(p_object_id => l_object_ids(k),

211: --get the trigger owner/name properties
212: FND_OAM_DSCFG_API_PKG.GET_OBJECT_PROPERTY_VALUE(p_object_id => l_object_ids(k),
213: p_property_name => B_PROP_TRIGGER_OWNER,
214: x_varchar2_value => l_trigger_owner);
215: FND_OAM_DSCFG_API_PKG.GET_OBJECT_PROPERTY_VALUE(p_object_id => l_object_ids(k),
216: p_property_name => B_PROP_TRIGGER_NAME,
217: x_varchar2_value => l_trigger_name);
218: l_seen := l_seen + 1;
219: fnd_oam_debug.log(1, l_ctxt, 'Processing Trigger('||l_seen||'): '||l_trigger_owner||'.'||l_trigger_name);

Line 228: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_ids(k),

224: BEGIN
225: EXECUTE IMMEDIATE 'ALTER TRIGGER '||l_trigger_owner||'.'||l_trigger_name||' ENABLE';
226: fnd_oam_debug.log(1, l_ctxt, 'Trigger re-enabled.');
227: --add property for when the trigger was re-enabled
228: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_ids(k),
229: p_property_name => B_PROP_TRIGGER_RE_ENABLED_DATE,
230: p_date_value => SYSDATE,
231: x_property_id => l_property_id);
232: UPDATE_OBJECT_WITH_SUCCESS(l_ctxt,

Line 294: FND_OAM_DSCFG_API_PKG.GET_CURRENT_TARGET_TABLE_LIST(x_table_owners => l_table_owners,

290: BEGIN
291: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
292:
293: --get the owners/tables in scope of the engine
294: FND_OAM_DSCFG_API_PKG.GET_CURRENT_TARGET_TABLE_LIST(x_table_owners => l_table_owners,
295: x_table_names => l_table_names);
296: fnd_oam_debug.log(1, l_ctxt, 'Found '||l_table_owners.COUNT||' candidate target tables.');
297:
298: -- iterate across the tables found

Line 327: FND_OAM_DSCFG_API_PKG.ADD_OBJECT(p_object_type => B_OTYPE_DISABLED_PRIMARY_KEY,

323: fnd_oam_debug.log(1, l_ctxt, 'Table does not exist - skipping.');
324: l_commit := FALSE;
325: WHEN OTHERS THEN
326: --create the object and store the error message
327: FND_OAM_DSCFG_API_PKG.ADD_OBJECT(p_object_type => B_OTYPE_DISABLED_PRIMARY_KEY,
328: x_object_id => l_object_id);
329: UPDATE_OBJECT_WITH_ERROR(l_ctxt,
330: l_object_id,
331: SQLCODE,

Line 340: FND_OAM_DSCFG_API_PKG.ADD_OBJECT(p_object_type => B_OTYPE_DISABLED_PRIMARY_KEY,

336: IF l_commit THEN
337: --create the object if we haven't already created an errored object
338: IF l_object_id IS NULL THEN
339: fnd_oam_debug.log(1, l_ctxt, 'Creating corresponding dscfg_object...');
340: FND_OAM_DSCFG_API_PKG.ADD_OBJECT(p_object_type => B_OTYPE_DISABLED_PRIMARY_KEY,
341: x_object_id => l_object_id);
342: END IF;
343:
344: --and properties for the primary key owner/name and when we disabled it

Line 345: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,

341: x_object_id => l_object_id);
342: END IF;
343:
344: --and properties for the primary key owner/name and when we disabled it
345: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,
346: p_property_name => B_PROP_PRIM_KEY_TABLE_OWNER,
347: p_varchar2_value => l_table_owners(k),
348: x_property_id => l_property_id);
349: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,

Line 349: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,

345: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,
346: p_property_name => B_PROP_PRIM_KEY_TABLE_OWNER,
347: p_varchar2_value => l_table_owners(k),
348: x_property_id => l_property_id);
349: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,
350: p_property_name => B_PROP_PRIM_KEY_TABLE_NAME,
351: p_varchar2_value => l_table_names(k),
352: x_property_id => l_property_id);
353: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,

Line 353: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,

349: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,
350: p_property_name => B_PROP_PRIM_KEY_TABLE_NAME,
351: p_varchar2_value => l_table_names(k),
352: x_property_id => l_property_id);
353: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_id,
354: p_property_name => B_PROP_PRIM_KEY_DISABLED_DATE,
355: p_date_value => SYSDATE,
356: x_property_id => l_property_id);
357: fnd_oam_debug.log(1, l_ctxt, 'Comitting.');

Line 399: FND_OAM_DSCFG_API_PKG.GET_OBJECTS_FOR_TYPE(p_object_type => B_OTYPE_DISABLED_PRIMARY_KEY,

395: BEGIN
396: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
397:
398: --get all objects representing disabled primary keys
399: FND_OAM_DSCFG_API_PKG.GET_OBJECTS_FOR_TYPE(p_object_type => B_OTYPE_DISABLED_PRIMARY_KEY,
400: p_errors_found_flag => NULL,
401: x_object_ids => l_object_ids);
402: fnd_oam_debug.log(1, l_ctxt, 'Found '||l_object_ids.COUNT||' processable disabled primary key objects.');
403:

Line 408: FND_OAM_DSCFG_API_PKG.GET_OBJECT_PROPERTY_VALUE(p_object_id => l_object_ids(k),

404: -- iterate across the objects found
405: k := l_object_ids.FIRST;
406: WHILE k IS NOT NULL LOOP
407: --get the primary key table owner/name properties
408: FND_OAM_DSCFG_API_PKG.GET_OBJECT_PROPERTY_VALUE(p_object_id => l_object_ids(k),
409: p_property_name => B_PROP_PRIM_KEY_TABLE_OWNER,
410: x_varchar2_value => l_table_owner);
411: FND_OAM_DSCFG_API_PKG.GET_OBJECT_PROPERTY_VALUE(p_object_id => l_object_ids(k),
412: p_property_name => B_PROP_PRIM_KEY_TABLE_NAME,

Line 411: FND_OAM_DSCFG_API_PKG.GET_OBJECT_PROPERTY_VALUE(p_object_id => l_object_ids(k),

407: --get the primary key table owner/name properties
408: FND_OAM_DSCFG_API_PKG.GET_OBJECT_PROPERTY_VALUE(p_object_id => l_object_ids(k),
409: p_property_name => B_PROP_PRIM_KEY_TABLE_OWNER,
410: x_varchar2_value => l_table_owner);
411: FND_OAM_DSCFG_API_PKG.GET_OBJECT_PROPERTY_VALUE(p_object_id => l_object_ids(k),
412: p_property_name => B_PROP_PRIM_KEY_TABLE_NAME,
413: x_varchar2_value => l_table_name);
414:
415: l_seen := l_seen + 1;

Line 424: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_ids(k),

420: BEGIN
421: EXECUTE IMMEDIATE 'ALTER TABLE '||l_table_owner||'.'||l_table_name||' ENABLE PRIMARY KEY';
422: fnd_oam_debug.log(1, l_ctxt, 'Primary Key(s) re-enabled.');
423: --add property for when the primary key was re-enabled
424: FND_OAM_DSCFG_API_PKG.ADD_OBJECT_PROPERTY(p_object_id => l_object_ids(k),
425: p_property_name => B_PROP_PRIM_KEY_ENABLED_DATE,
426: p_date_value => SYSDATE,
427: x_property_id => l_property_id);
428: UPDATE_OBJECT_WITH_SUCCESS(l_ctxt,