DBA Data[Home] [Help]

APPS.MSC_E1APS_DEMCL SQL Statements

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

Line: 22

                        SELECT MSC_E1APS_UTIL.MSC_E1APS_ODIScenarioExecute(scenario_name,scenario_version,scenario_param,wsurl)
                        INTO   return_str
                        FROM   dual;
Line: 28

                        SELECT instr(return_str,'#')
                        INTO   start_index
                        FROM   dual;
Line: 32

                        SELECT SUBSTR(return_str,start_index+1,1800)
                        INTO   err_message
                        FROM   dual;
Line: 42

                SELECT instr(return_str,'#')
                INTO   start_index
                FROM   dual;
Line: 46

                SELECT SUBSTR(return_str,0,start_index-1)
                INTO   session_num
                FROM   dual;
Line: 50

                SELECT SUBSTR(return_str,start_index+1,1800)
                INTO   err_message
                FROM   dual;
Line: 134

                select instance_code into l_instance_code
                from msc_apps_instances
                where instance_id = p_instance_id;
Line: 162

                        DELETE
                        FROM   MSD_DEM_PRICE_LISTS;
Line: 168

                        MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSD_DEM_PRICE_LISTS');
Line: 172

                MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSD_DEM_PRICE_LISTS');
Line: 174

                /* Step 1: Inserting rows into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIST */
                BEGIN
                        INSERT
                        INTO   MSD_DEM_PRICE_LISTS
                               (      PRICE_LIST_NAME  ,
                                      LAST_UPDATE_LOGIN,
                                      LAST_UPDATE_DATE ,
                                      LAST_UPDATED_BY  ,
                                      CREATION_DATE    ,
                                      CREATED_BY
                               )
                        SELECT DISTINCT PRICE_LIST_NAME,
                                        -1             ,
                                        SYSDATE        ,
                                        -1             ,
                                        SYSDATE        ,
                                        -1
                        FROM            MSC_ST_PRICE_LIST;
Line: 196

                        MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Inserted into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIS');
Line: 200

                SELECT COUNT(*)
                INTO   total_rows
                FROM   MSD_DEM_PRICE_LISTS;
Line: 203

                MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Inserted ' || total_rows || 'rows into MSD_DEM_PRICE_LISTS from MSD_ST_PRICE_LIS');
Line: 269

                select instance_code into l_instance_code
                from msc_apps_instances
                where instance_id = p_instance_id;
Line: 356

                select instance_code into l_instance_code from msc_apps_instances
                where instance_id = p_instance_id;
Line: 391

        SELECT ATTRIBUTE13,
               ATTRIBUTE12,
               ATTRIBUTE13,
               ATTRIBUTE14
        INTO   p_data_path     ,
               p_control_path  ,
               destination_file,
               source_file
        FROM   MSC_APPS_INSTANCES
        WHERE  INSTANCE_ID = p_instance_id;
Line: 404

                DELETE
                FROM   MSD_DEM_CALENDARS;
Line: 410

                MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSD_DEM_CALENDARS');
Line: 414

        MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSD_DEM_CALENDARS');
Line: 416

                INSERT
                INTO   MSD_DEM_CALENDARS
                       (
                              INSTANCE        ,
                              CALENDAR_TYPE   ,
                              CALENDAR_CODE   ,
                              LAST_UPDATE_DATE,
                              LAST_UPDATED_BY ,
                              CREATION_DATE   ,
                              CREATED_BY      ,
                              LAST_UPDATE_LOGIN
                       )
                SELECT MAI.INSTANCE_CODE  ,
                       'Manufacturing'    ,
                       MC.CALENDAR_CODE   ,
                       MC.LAST_UPDATE_DATE,
                       MC.LAST_UPDATED_BY ,
                       MC.CREATION_DATE   ,
                       MC.CREATED_BY      ,
                       MC.LAST_UPDATE_LOGIN
                FROM   MSC_CALENDARS MC,
                       MSC_APPS_INSTANCES MAI
                WHERE  MC.SR_INSTANCE_ID = p_instance_id
                   AND MAI.INSTANCE_ID   = MC.SR_INSTANCE_ID;
Line: 444

                MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');
Line: 448

        MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');
Line: 453

                        SELECT MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(odi_url,2)
                        INTO   ReturnStr
                        FROM   dual;
Line: 459

                select instr(ReturnStr,'#') into StartIndex from dual;
Line: 460

				        select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
Line: 466

                select instr(ReturnStr,'#') into StartIndex from dual;
Line: 467

				        select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
Line: 648

                select instance_code into l_instance_code from msc_apps_instances
                where instance_id = p_instance_id;
Line: 677

                        SELECT MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(odi_url,2)
                        INTO   ReturnStr
                        FROM   dual;
Line: 683

                select instr(ReturnStr,'#') into StartIndex from dual;
Line: 684

				        select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
Line: 690

                 select instr(ReturnStr,'#') into StartIndex from dual;
Line: 691

				         select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
Line: 701

        SELECT ATTRIBUTE14,
               ATTRIBUTE13
        INTO   source_file,
               destination_file
        FROM   MSC_APPS_INSTANCES
        WHERE  INSTANCE_ID = p_instance_id;
Line: 956

                select instance_code into l_instance_code from msc_apps_instances
                where instance_id = p_instance_id;
Line: 990

                                SELECT MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(odi_url,2)
                                INTO   ReturnStr
                                FROM   dual;
Line: 996

                          select instr(ReturnStr,'#') into StartIndex from dual;
Line: 997

				                  select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
Line: 1003

                        select instr(ReturnStr,'#') into StartIndex from dual;
Line: 1004

				                select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
Line: 1127

                select instance_code into l_instance_code from msc_apps_instances
                where instance_id = p_instance_id;
Line: 1150

                x_org_sql := 'select t_ep_organization_ep_id from ' || g_demantra_schema
                        			||'.t_ep_organization where organization IN ( select organization_code from msc_trading_partners '
                        			||'where sr_instance_id = ' || p_instance_id|| ' and partner_type=3) order by t_ep_organization_ep_id' ;
Line: 1154

                x_sql := 'select id from '|| g_demantra_schema ||'.TRANSFER_QUERY where query_name like ''AIA-Forecast data''';
Line: 1157

                x_sql := 'select filter_id from '|| g_demantra_schema ||'.transfer_query_filters where id = ' || g_data_profile_id ;
Line: 1160

                x_sql := 'Delete from ' || g_demantra_schema ||'.transfer_query_filter_m where filter_id = ' || g_filter_id ;
Line: 1168

                x_sql := 'INSERT INTO ' || g_demantra_schema ||'.transfer_query_filter_m VALUES('||g_filter_id ||','||g_member_id || ')';
Line: 1191

                                        SELECT MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(odi_url,2)
                                        INTO   ReturnStr
                                        FROM   dual;
Line: 1197

                                   select instr(ReturnStr,'#') into StartIndex from dual;
Line: 1198

				                           select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
Line: 1305

                select instance_code into l_instance_code
                from msc_apps_instances
                where instance_id = p_instance_id;
Line: 1342

                                SELECT MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(odi_url,2)
                                INTO   ReturnStr
                                FROM   dual;
Line: 1348

                          select instr(ReturnStr,'#') into StartIndex from dual;
Line: 1349

				                  select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;
Line: 1406

                scenario_name := 'LOADDMDELETEPROMOPRICINGDATATOE1PKG';
Line: 1495

                select instance_code into l_instance_code
                from msc_apps_instances
                where instance_id = p_instance_id;
Line: 1526

                                SELECT MSC_E1APS_UTIL.MSC_E1APS_ODIInitialize(odi_url,2)
                                INTO   ReturnStr
                                FROM   dual;
Line: 1532

                          select instr(ReturnStr,'#') into StartIndex from dual;
Line: 1533

				                  select substr(ReturnStr,StartIndex+1,1800) into ErrMessage from dual;