1: package body IEB_SERVICE_LEVELS_PKG as
2: /* $Header: IEBSVCLVLB.pls 120.3 2005/09/29 06:09:03 appldev ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,
369: p_OWNER IN VARCHAR2,
370: p_UPLOAD_MODE IN VARCHAR2) is
371: BEGIN
372: if (p_UPLOAD_MODE = 'NLS') then
373: IEB_SERVICE_LEVELS_PKG.TRANSLATE_ROW (
374: p_SERVICE_LEVEL_ID,
375: p_LEVEL_NAME,
376: p_DESCRIPTION,
377: p_OWNER);
375: p_LEVEL_NAME,
376: p_DESCRIPTION,
377: p_OWNER);
378: else
379: IEB_SERVICE_LEVELS_PKG.LOAD_ROW (
380: p_service_level_id ,
381: p_mandatory_flag ,
382: p_direction ,
383: p_hourly_quota ,
499: and T.SERVICE_LEVEL_ID = B.SERVICE_LEVEL_ID
500: and T.LANGUAGE = L.LANGUAGE_CODE);
501: end ADD_LANGUAGE;
502:
503: end IEB_SERVICE_LEVELS_PKG;