APPS.FND_PROFILE_OPTION_VALUES_PKG dependencies on FND_PROFILE_OPTION_VALUES_PKG

Line 1: package body FND_PROFILE_OPTION_VALUES_PKG as

1: package body FND_PROFILE_OPTION_VALUES_PKG as
2: /* $Header: AFPOMPVB.pls 120.2.12010000.1 2008/07/25 14:19:48 appldev ship $ */
3:
4: function GET_HIERARCHY_TYPE(
5: X_PROFILE_OPTION_ID in NUMBER,

Line 92: L_HIERARCHY_TYPE := FND_PROFILE_OPTION_VALUES_PKG.GET_HIERARCHY_TYPE

88: if length(X_PROFILE_OPTION_VALUE) > 240 then
89: raise profile_option_value_too_large;
90: end if;
91:
92: L_HIERARCHY_TYPE := FND_PROFILE_OPTION_VALUES_PKG.GET_HIERARCHY_TYPE
93: (X_PROFILE_OPTION_ID, X_APPLICATION_ID);
94:
95: /* Being conservative here and wanting to make sure that levels get
96: profile option values inserted correctly. For example, if, by some

Line 306: L_HIERARCHY_TYPE := FND_PROFILE_OPTION_VALUES_PKG.GET_HIERARCHY_TYPE

302: if length(X_PROFILE_OPTION_VALUE) > 240 then
303: raise profile_option_value_too_large;
304: end if;
305:
306: L_HIERARCHY_TYPE := FND_PROFILE_OPTION_VALUES_PKG.GET_HIERARCHY_TYPE
307: (X_PROFILE_OPTION_ID, X_APPLICATION_ID);
308:
309: if (X_LEVEL_ID = 10007 and L_HIERARCHY_TYPE = 'SERVRESP') then
310: /* ServResp U P D A T E */

Line 345: FND_PROFILE_OPTION_VALUES_PKG.INSERT_ROW(

341: end if;
342:
343: if SQL%NOTFOUND then
344: /* I N S E R T */
345: FND_PROFILE_OPTION_VALUES_PKG.INSERT_ROW(
346: L_ROWID,
347: X_APPLICATION_ID,
348: X_PROFILE_OPTION_ID,
349: X_LEVEL_ID,

Line 424: L_HIERARCHY_TYPE := FND_PROFILE_OPTION_VALUES_PKG.GET_HIERARCHY_TYPE

420: L_HIERARCHY_TYPE VARCHAR2(8);
421:
422: begin
423:
424: L_HIERARCHY_TYPE := FND_PROFILE_OPTION_VALUES_PKG.GET_HIERARCHY_TYPE
425: (X_PROFILE_OPTION_ID, X_APPLICATION_ID);
426:
427: if (X_LEVEL_ID = 10007 and L_HIERARCHY_TYPE = 'SERVRESP') then
428:

Line 537: end FND_PROFILE_OPTION_VALUES_PKG;

533: end if;
534:
535: end DELETE_PROFILE_OPTION_VALUES;
536:
537: end FND_PROFILE_OPTION_VALUES_PKG;