APPS.FND_OAM_DSCFG_OBJECTS_PKG dependencies on FND_OAM_DSCFG_OBJECTS

Line 1: PACKAGE BODY FND_OAM_DSCFG_OBJECTS_PKG as

1: PACKAGE BODY FND_OAM_DSCFG_OBJECTS_PKG as
2: /* $Header: AFOAMDSCOBJB.pls 120.2 2006/01/17 11:36 ilawler noship $ */
3:
4: ----------------------------------------
5: -- Private Body Constants

Line 42: INSERT INTO fnd_oam_dscfg_objects (OBJECT_ID,

38: l_proc_id := FND_OAM_DSCFG_PROCS_PKG.GET_CURRENT_ID;
39: END IF;
40:
41: --do the insert
42: INSERT INTO fnd_oam_dscfg_objects (OBJECT_ID,
43: CONFIG_INSTANCE_ID,
44: OBJECT_TYPE,
45: PARENT_OBJECT_ID,
46: SOURCE_PROC_ID,

Line 56: VALUES (FND_OAM_DSCFG_OBJECTS_S.NEXTVAL,

52: CREATION_DATE,
53: LAST_UPDATED_BY,
54: LAST_UPDATE_DATE,
55: LAST_UPDATE_LOGIN)
56: VALUES (FND_OAM_DSCFG_OBJECTS_S.NEXTVAL,
57: l_config_instance_id,
58: p_object_type,
59: p_parent_object_id,
60: l_proc_id,

Line 98: FROM fnd_oam_dscfg_objects

94:
95: --do the fetch
96: SELECT object_id
97: BULK COLLECT INTO l_object_ids
98: FROM fnd_oam_dscfg_objects
99: WHERE object_type = p_object_type
100: ORDER BY object_id asc;
101:
102: x_object_ids := l_object_ids;

Line 127: FROM fnd_oam_dscfg_objects

123: --do the fetch
124: IF p_errors_found_flag IS NULL THEN
125: SELECT object_id
126: BULK COLLECT INTO l_object_ids
127: FROM fnd_oam_dscfg_objects
128: WHERE object_type = p_object_type
129: AND errors_found_flag IS NULL
130: ORDER BY object_id asc;
131: ELSE

Line 134: FROM fnd_oam_dscfg_objects

130: ORDER BY object_id asc;
131: ELSE
132: SELECT object_id
133: BULK COLLECT INTO l_object_ids
134: FROM fnd_oam_dscfg_objects
135: WHERE object_type = p_object_type
136: AND errors_found_flag = p_errors_found_flag
137: ORDER BY object_id asc;
138: END IF;

Line 174: DELETE FROM fnd_oam_dscfg_objects

170: END IF;
171: END IF;
172:
173: --now delete the object
174: DELETE FROM fnd_oam_dscfg_objects
175: WHERE object_id = p_object_id;
176:
177: --success
178: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 187: END FND_OAM_DSCFG_OBJECTS_PKG;

183: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
184: RETURN FALSE;
185: END;
186:
187: END FND_OAM_DSCFG_OBJECTS_PKG;