APPS.MSD_LEVELS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 33

          x_last_update_date in varchar2,
          x_owner in varchar2,
          x_custom_mode in varchar2,
          X_SYSTEM_ATTRIBUTE1_CONTEXT  VARCHAR2,
          X_SYSTEM_ATTRIBUTE2_CONTEXT  VARCHAR2) is

        f_luby    number;  -- entity owner in file

Line: 40

        f_ludate  date;    -- entity update date in file

Line: 42

        db_ludate date;    -- entity update date in db

Line: 52

         f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 55

          select LAST_UPDATED_BY, LAST_UPDATE_DATE
          into db_luby, db_ludate
          from MSD_LEVELS
          where LEVEL_ID = to_number(x_level_id) and nvl(plan_type, -1)  = nvl( to_char(x_plan_type),-1) ;

Line: 69

            update MSD_LEVELS set
             LEVEL_NAME = X_LEVEL_NAME,
             DESCRIPTION = X_DESCRIPTION,
             DIMENSION_CODE = X_DIMENSION_CODE,
             LEVEL_TYPE_CODE = X_LEVEL_TYPE_CODE,
             ORG_RELATIONSHIP_VIEW = X_ORG_RELATIONSHIP_VIEW,
             ATTRIBUTE1_CONTEXT = X_ATTRIBUTE1_CONTEXT,
             ATTRIBUTE2_CONTEXT = X_ATTRIBUTE2_CONTEXT,
             ATTRIBUTE3_CONTEXT = X_ATTRIBUTE3_CONTEXT,
             ATTRIBUTE4_CONTEXT = X_ATTRIBUTE4_CONTEXT,
             ATTRIBUTE5_CONTEXT = X_ATTRIBUTE5_CONTEXT,
             ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
             ATTRIBUTE1 = X_ATTRIBUTE1,
             ATTRIBUTE2 = X_ATTRIBUTE2,
             ATTRIBUTE3 = X_ATTRIBUTE3,
             ATTRIBUTE4 = X_ATTRIBUTE4,
             ATTRIBUTE5 = X_ATTRIBUTE5,
             ATTRIBUTE6 = X_ATTRIBUTE6,
             ATTRIBUTE7 = X_ATTRIBUTE7,
             ATTRIBUTE8 = X_ATTRIBUTE8,
             ATTRIBUTE9 = X_ATTRIBUTE9,
             ATTRIBUTE10 = X_ATTRIBUTE10,
             ATTRIBUTE11 = X_ATTRIBUTE11,
             ATTRIBUTE12 = X_ATTRIBUTE12,
             ATTRIBUTE13 = X_ATTRIBUTE13,
             ATTRIBUTE14 = X_ATTRIBUTE14,
             ATTRIBUTE15 = X_ATTRIBUTE15,
             LAST_UPDATE_DATE = f_ludate,
             LAST_UPDATED_BY = f_luby,
             LAST_UPDATE_LOGIN = 0,
             SYSTEM_ATTRIBUTE1_CONTEXT = X_SYSTEM_ATTRIBUTE1_CONTEXT,
             SYSTEM_ATTRIBUTE2_CONTEXT = X_SYSTEM_ATTRIBUTE2_CONTEXT
            where LEVEL_ID = to_number(X_LEVEL_ID)and
                   nvl(  PLAN_TYPE, -1) = nvl ( x_plan_type , -1) ;

Line: 106

            update MSD_LEVELS set
             ORG_RELATIONSHIP_VIEW = X_ORG_RELATIONSHIP_VIEW,
             LAST_UPDATE_DATE = f_ludate,
             LAST_UPDATED_BY = f_luby,
             LAST_UPDATE_LOGIN = 0
            where LEVEL_ID = to_number(X_LEVEL_ID)
               and nvl(  PLAN_TYPE, -1) = nvl(  x_plan_type , -1) ;

Line: 119

            insert into MSD_LEVELS (
              LEVEL_ID,
              PLAN_TYPE,
              LEVEL_NAME,
              DESCRIPTION,
              DIMENSION_CODE,
              LEVEL_TYPE_CODE,
              ORG_RELATIONSHIP_VIEW,
              ATTRIBUTE1_CONTEXT,
              ATTRIBUTE2_CONTEXT,
              ATTRIBUTE3_CONTEXT,
              ATTRIBUTE4_CONTEXT,
              ATTRIBUTE5_CONTEXT,
              ATTRIBUTE_CATEGORY,
              ATTRIBUTE1,
              ATTRIBUTE2,
              ATTRIBUTE3,
              ATTRIBUTE4,
              ATTRIBUTE5,
              ATTRIBUTE6,
              ATTRIBUTE7,
              ATTRIBUTE8,
              ATTRIBUTE9,
              ATTRIBUTE10,
              ATTRIBUTE11,
              ATTRIBUTE12,
              ATTRIBUTE13,
              ATTRIBUTE14,
              ATTRIBUTE15,
              CREATION_DATE,
              CREATED_BY,
              LAST_UPDATE_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_LOGIN,
              SYSTEM_ATTRIBUTE1_CONTEXT,
              SYSTEM_ATTRIBUTE2_CONTEXT
            ) values (
              to_number(X_LEVEL_ID),
              X_PLAN_TYPE,
              X_LEVEL_NAME,
              X_DESCRIPTION,
              X_DIMENSION_CODE,
              X_LEVEL_TYPE_CODE,
              X_ORG_RELATIONSHIP_VIEW,
              X_ATTRIBUTE1_CONTEXT,
              X_ATTRIBUTE2_CONTEXT,
              X_ATTRIBUTE3_CONTEXT,
              X_ATTRIBUTE4_CONTEXT,
              X_ATTRIBUTE5_CONTEXT,
              X_ATTRIBUTE_CATEGORY,
              X_ATTRIBUTE1,
              X_ATTRIBUTE2,
              X_ATTRIBUTE3,
              X_ATTRIBUTE4,
              X_ATTRIBUTE5,
              X_ATTRIBUTE6,
              X_ATTRIBUTE7,
              X_ATTRIBUTE8,
              X_ATTRIBUTE9,
              X_ATTRIBUTE10,
              X_ATTRIBUTE11,
              X_ATTRIBUTE12,
              X_ATTRIBUTE13,
              X_ATTRIBUTE14,
              X_ATTRIBUTE15,
              f_ludate,
              f_luby,
              f_ludate,
              f_luby,
              0,
              X_SYSTEM_ATTRIBUTE1_CONTEXT,
              X_SYSTEM_ATTRIBUTE2_CONTEXT);

Line: 200

        x_last_update_date in varchar2,
        x_owner in varchar2,
        x_custom_mode in varchar2) is

        secgrp_id number;

Line: 209

        f_ludate  date;    -- entity update date in file

Line: 211

        db_ludate date;    -- entity update date in db

Line: 221

        f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 227

          select LAST_UPDATED_BY, LAST_UPDATE_DATE
          into db_luby, db_ludate
          from msd_levels
          where level_id = to_number(x_level_id) and nvl( PLAN_TYPE, -1) = nvl(  x_plan_type , -1) ;

Line: 241

            update msd_levels
            set
              level_name = nvl(x_level_name, level_name),
              DESCRIPTION = nvl(x_description, DESCRIPTION),
              LAST_UPDATE_DATE = f_ludate,
              LAST_UPDATED_BY = f_luby,
              LAST_UPDATE_LOGIN = 0
            where level_id = to_number(x_level_id)
              and nvl( plan_type, -1) = nvl(  x_plan_type , -1)
              and userenv('LANG') = (select language_code
                                      from FND_LANGUAGES
                                      where installed_flag = 'B');