APPS.MSD_CS_CLMN_DIM_LOAD_DATA SQL Statements

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

Line: 11

       p_last_update_date           in varchar2,
       p_custom_mode                in varchar2
       ) is
    Begin
        --
         Update_row(
           p_definition_name            ,
           p_dimension_code             ,
           p_table_column               ,
           p_aggregation_type           ,
           p_allocation_type            ,
           p_owner                      ,
           p_last_update_date           ,
           p_custom_mode                );

Line: 27

        Insert_row(
           p_definition_name            ,
           p_dimension_code             ,
           p_table_column               ,
           p_aggregation_type           ,
           p_allocation_type            ,
           p_owner                      ,
           p_last_update_date           );

Line: 38

    Procedure Update_row (
       p_definition_name            in varchar2,
       p_dimension_code             in varchar2,
       p_table_column               in varchar2,
       p_aggregation_type           in varchar2,
       p_allocation_type            in varchar2,
       p_owner                      in varchar2,
       p_last_update_date           in varchar2,
       p_custom_mode                in varchar2
       )  is
        --
        --
        l_user              number;

Line: 54

        select cs_clmn_dim_dtls_id,
               last_updated_by,
               last_update_date
            from MSD_CS_CLMN_DIM_DTLS_V
        where
            cs_definition_id = (select cs_definition_id from msd_cs_definitions where name = p_definition_name) and
            table_column = p_table_column and
            dimension_code = p_dimension_code;

Line: 63

        f_ludate  date;    -- entity update date in file

Line: 65

        db_ludate date;    -- entity update date in db

Line: 75

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

Line: 95

            update MSD_CS_CLMN_DIM_DTLS set
               aggregation_type            = p_aggregation_type,
               allocation_type             = p_allocation_type,
               last_updated_by             = l_user,
               last_update_date            = f_ludate
            where
               cs_clmn_dim_dtls_id = l_cs_id;

Line: 112

Procedure Insert_row (
       p_definition_name            in varchar2,
       p_dimension_code             in varchar2,
       p_table_column               in varchar2,
       p_aggregation_type           in varchar2,
       p_allocation_type            in varchar2,
       p_owner                      in varchar2,
       p_last_update_date           in varchar2
       ) is
       --
        --
        l_user               number;

Line: 128

        f_ludate            date;    -- entity update date in file

Line: 131

        select cs_defn_dim_dtls_id
            from msd_cs_defn_dim_dtls
        where
            cs_definition_id = (select cs_definition_id from msd_cs_definitions where name = p_definition_name) and
            dimension_code = p_dimension_code;

Line: 138

        select cs_column_dtls_id
    		from msd_cs_defn_column_dtls
				where cs_definition_id = (select cs_definition_id from msd_cs_definitions where name =p_definition_name)
				and table_column = p_table_column;

Line: 151

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

Line: 165

        select MSD_CS_CLMN_DIM_DTLS_S.nextval into l_PK_id from dual;

Line: 167

        insert into MSD_CS_CLMN_DIM_DTLS(
            cs_clmn_dim_dtls_id,
            cs_defn_dim_dtls_id,
            cs_column_dtls_id,
            aggregation_type,
            allocation_type,
            created_by,
            creation_date,
            last_updated_by,
            last_update_date ,
            last_update_login
        )
        values
          (
            l_pk_id,
            l_cs_id1,
            l_cs_id2,
            p_aggregation_type,
            p_allocation_type,
            l_user,
            f_ludate,
            l_user,
            f_ludate,
            fnd_global.login_id
        );