APPS.FND_OAM_DSCFG_PROPERTIES_PKG dependencies on FND_OAM_DSCFG_PROPERTIES

Line 1: PACKAGE BODY FND_OAM_DSCFG_PROPERTIES_PKG as

1: PACKAGE BODY FND_OAM_DSCFG_PROPERTIES_PKG as
2: /* $Header: AFOAMDSCPROPB.pls 120.2 2005/12/19 09:42 ilawler noship $ */
3:
4: ----------------------------------------
5: -- Private Body Constants

Line 36: INSERT INTO fnd_oam_dscfg_properties (PROPERTY_ID,

32: RAISE NO_DATA_FOUND;
33: END IF;
34:
35: --do the insert
36: INSERT INTO fnd_oam_dscfg_properties (PROPERTY_ID,
37: PARENT_TYPE,
38: PARENT_ID,
39: PROPERTY_NAME,
40: DATATYPE,

Line 47: VALUES (FND_OAM_DSCFG_PROPERTIES_S.NEXTVAL,

43: CREATION_DATE,
44: LAST_UPDATED_BY,
45: LAST_UPDATE_DATE,
46: LAST_UPDATE_LOGIN)
47: VALUES (FND_OAM_DSCFG_PROPERTIES_S.NEXTVAL,
48: p_parent_type,
49: p_parent_id,
50: p_property_name,
51: p_datatype,

Line 183: FROM fnd_oam_dscfg_properties

179: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
180:
181: SELECT canonical_value
182: INTO x_canonical_value
183: FROM fnd_oam_dscfg_properties
184: WHERE parent_type = p_parent_type
185: AND parent_id = p_parent_id
186: AND property_name = p_property_name;
187:

Line 270: FROM fnd_oam_dscfg_properties

266: --see if the property's present
267: BEGIN
268: SELECT property_id
269: INTO l_property_id
270: FROM fnd_oam_dscfg_properties
271: WHERE parent_type = p_parent_type
272: AND parent_id = p_parent_id
273: AND property_name = p_property_name;
274:

Line 277: UPDATE fnd_oam_dscfg_properties

273: AND property_name = p_property_name;
274:
275: --if we didn't throw an exception, we found a single row we can update
276: --don't allow changing the datatype
277: UPDATE fnd_oam_dscfg_properties
278: SET canonical_value = p_canonical_value,
279: last_updated_by = FND_GLOBAL.USER_ID,
280: last_update_date = SYSDATE,
281: last_update_login = FND_GLOBAL.USER_ID

Line 369: DELETE FROM fnd_oam_dscfg_properties

365: BEGIN
366: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
367:
368: --just delete the property
369: DELETE FROM fnd_oam_dscfg_properties
370: WHERE parent_type = p_parent_type
371: AND parent_id = p_parent_id;
372: fnd_oam_debug.log(1, l_ctxt, 'Deleted '||SQL%ROWCOUNT||' properties.');
373:

Line 395: DELETE FROM fnd_oam_dscfg_properties

391: BEGIN
392: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
393:
394: --just delete the property
395: DELETE FROM fnd_oam_dscfg_properties
396: WHERE property_id = p_property_id;
397:
398: --success
399: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

Line 408: END FND_OAM_DSCFG_PROPERTIES_PKG;

404: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
405: RETURN FALSE;
406: END;
407:
408: END FND_OAM_DSCFG_PROPERTIES_PKG;