APPS.MSD_CS_DEFN_CLMN_LOAD_DATA SQL Statements

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

Line: 15

       p_last_update_date           in varchar2,
       p_custom_mode                in varchar2
       ) is
    Begin
        --
         Update_row(
           p_definition_name            ,
           p_table_column               ,
           p_column_identifier          ,
           p_source_view_column_name    ,
           p_planning_view_column_name  ,
--           p_alt_key_flag               ,
           p_aggregation_type           ,
           p_allocation_type            ,
           p_uom_conversion_flag        ,
           p_owner                      ,
           p_last_update_date           ,
           p_custom_mode                );

Line: 35

        Insert_row(
           p_definition_name            ,
           p_table_column               ,
           p_column_identifier          ,
           p_source_view_column_name    ,
           p_planning_view_column_name  ,
--           p_alt_key_flag             ,
           p_aggregation_type           ,
           p_allocation_type            ,
           p_uom_conversion_flag        ,
           p_owner                      ,
           p_last_update_date           );

Line: 51

    Procedure Update_row (
       p_definition_name            in varchar2,
       p_table_column               in varchar2,
       p_column_identifier          in varchar2,
       p_source_view_column_name    in varchar2,
       p_planning_view_column_name  in varchar2,
--       p_alt_key_flag               in varchar2,
       p_aggregation_type           in varchar2,
       p_allocation_type            in varchar2,
       p_uom_conversion_flag        in varchar2,
       p_owner                      in  varchar2,
       p_last_update_date           in varchar2,
       p_custom_mode                in varchar2
       )  is
        --
        --
        l_user              number;

Line: 70

        f_ludate            date;    -- entity update date in file

Line: 72

        db_ludate           date;    -- entity update date in db

Line: 75

        select
            cs_definition_id
        from
            msd_cs_definitions
        where
            name = p_definition_name;

Line: 83

        select last_updated_by,
               last_update_date
          from msd_cs_defn_column_dtls
         where cs_definition_id = p_id
           and table_column = p_column;

Line: 115

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

Line: 126

            update MSD_CS_DEFN_COLUMN_DTLS set
                source_view_column_name     = p_source_view_column_name,
                planning_view_column_name   = p_planning_view_column_name,
                column_identifier           = p_column_identifier,
          --            alt_key_flag                = p_alt_key_flag,
                uom_conversion_flag         = p_uom_conversion_flag,
                aggregation_type            = p_aggregation_type,
                allocation_type             = p_allocation_type,
                last_updated_by             = l_user,
                last_update_date            = f_ludate
              where
                cs_definition_id = l_cs_definition_id and
                table_column     = p_table_column;

Line: 148

Procedure Insert_row (
       p_definition_name            in varchar2,
       p_table_column               in varchar2,
       p_column_identifier          in varchar2,
       p_source_view_column_name    in varchar2,
       p_planning_view_column_name  in varchar2,
--       p_alt_key_flag               in varchar2,
       p_aggregation_type           in varchar2,
       p_allocation_type            in varchar2,
       p_uom_conversion_flag        in varchar2,
       p_owner                      in  varchar2,
       p_last_update_date           in varchar2
       ) is
       --
       --
       l_user               number;

Line: 166

       f_ludate             date;    -- entity update date in file

Line: 169

        select
            cs_definition_id
        from
            msd_cs_definitions
        where
            name = p_definition_name;

Line: 191

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

Line: 193

        select MSD_CS_DEFN_COLUMN_DTLS_S.nextval into l_cs_column_dtls_id from dual;

Line: 195

        insert into MSD_CS_DEFN_COLUMN_DTLS(
            cs_column_dtls_id,
            cs_definition_id,
            source_view_column_name,
            planning_view_column_name,
            column_identifier,
            table_column,
--            alt_key_flag,
            uom_conversion_flag,
            aggregation_type,
            allocation_type,
            created_by,
            creation_date,
            last_updated_by,
            last_update_date ,
            last_update_login
        )
        values
          (
            l_cs_column_dtls_id,
            l_cs_definition_id,
            p_source_view_column_name,
            p_planning_view_column_name,
            p_column_identifier,
            p_table_column,
--            p_alt_key_flag,
            p_uom_conversion_flag,
            p_aggregation_type,
            p_allocation_type,
            l_user,
            f_ludate,
            l_user,
            f_ludate,
            fnd_global.login_id
        );