APPS.WIP_PREFERENCES_PKG dependencies on WIP_CONSTANTS

Line 415: return WIP_CONSTANTS.PREF_NOT_INHERITED;

411: begin
412: -- if at default value (no parent) or parent levels have no values
413: -- return not inherited
414: if p_level_code = 0 or p_level_id is null then
415: return WIP_CONSTANTS.PREF_NOT_INHERITED;
416: end if;
417:
418: open get_row;
419: fetch get_row into l_level_code;

Line 423: return WIP_CONSTANTS.PREF_INHERITED;

419: fetch get_row into l_level_code;
420:
421: if l_level_code < p_level_code then
422: close get_row;
423: return WIP_CONSTANTS.PREF_INHERITED;
424: else
425: close get_row;
426: return WIP_CONSTANTS.PREF_NOT_INHERITED;
427: end if;

Line 426: return WIP_CONSTANTS.PREF_NOT_INHERITED;

422: close get_row;
423: return WIP_CONSTANTS.PREF_INHERITED;
424: else
425: close get_row;
426: return WIP_CONSTANTS.PREF_NOT_INHERITED;
427: end if;
428: end;
429:
430: