APPS.MSC_CL_FUNCTION SQL Statements

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

Line: 33

	   SELECT DECODE( M2A_DBLINK,
                        NULL, NULL_DBLINK,
                        '@'||M2A_DBLINK)
           INTO v_dblink
           FROM MSC_APPS_INSTANCES
          WHERE INSTANCE_ID= p_instance_id;

Line: 41

	lv_sql_stmt := 'select mp.organization_code org_code '
	               ||' from msc_instance_orgs ins , mtl_parameters'||v_dblink||'  mp '
	               ||' where ins.organization_id=mp.organization_id '
	               ||' and ins.enabled_flag=1 '
	               ||' and ins.org_group = :p_org_group '
	               ||' and ins.sr_instance_id = :p_instance_id ';

Line: 72

PROCEDURE  UPDATE_DATE_COLUMNS(ERRBUF               OUT NOCOPY VARCHAR2,
                              RETCODE              OUT NOCOPY NUMBER,
                              pINSTANCE_ID         IN  NUMBER,
                              pNUM_OF_DAYS         IN  NUMBER)
IS

lv_sql_tmp_stmt varchar2(4000);

Line: 81

SELECT flv.attribute2 table_name, atc.COLUMN_NAME column_name
         FROM all_tab_columns atc , fnd_lookup_values flv
      WHERE
	     flv.lookup_type='MSC_ODS_TABLE'
		 and flv.enabled_flag = 'Y' AND  flv.view_application_id = 700
         and flv.attribute11 is null   and flv.attribute12 is null
	     and upper(atc.TABLE_NAME) = flv.attribute2
        AND atc.OWNER = lv_msc_schema
        AND atc.DATA_TYPE = 'DATE'
        and flv.language=userenv('lang');

Line: 93

SELECT flv.attribute2 table_name, atc.COLUMN_NAME column_name
         FROM all_tab_columns atc , fnd_lookup_values flv
      WHERE
	     flv.lookup_type='MSC_ODS_TABLE'
		 and flv.enabled_flag = 'Y' AND  flv.view_application_id = 700
         and flv.attribute11='Y'   and flv.attribute12 is null
	     and upper(atc.TABLE_NAME) = flv.attribute2
        AND atc.OWNER = lv_msc_schema
        AND atc.DATA_TYPE = 'DATE'
        and flv.language=userenv('lang');

Line: 106

SELECT flv.attribute2 table_name, atc.COLUMN_NAME column_name
         FROM all_tab_columns atc , fnd_lookup_values flv
      WHERE
	     flv.lookup_type='MSC_ODS_TABLE'
		 and flv.enabled_flag = 'Y' AND  flv.view_application_id = 700
         and flv.attribute11='Y'   and flv.attribute12='Y'
	     and upper(atc.TABLE_NAME) = flv.attribute2
        AND atc.OWNER = lv_msc_schema
        AND atc.DATA_TYPE = 'DATE'
        and flv.language=userenv('lang');

Line: 133

               ' UPDATE /*+ PARALLEL('|| lv_table_name || ') */ ' || lv_table_name
              ||' SET  ' || lv_sql_tmp_stmt;

Line: 135

	 			 LOG_MESSAGE('Table Updated :   ' || lv_table_name || ' row updated : '|| SQL%ROWCOUNT );

Line: 148

     ' UPDATE /*+ PARALLEL('|| lv_table_name || ') */ ' || lv_table_name
              ||' SET  ' || lv_sql_tmp_stmt;

Line: 150

    LOG_MESSAGE('Table Updated :   ' || lv_table_name || ' row updated : '|| SQL%ROWCOUNT );

Line: 160

               ' UPDATE /*+ PARALLEL('|| lv_table_name || ') */ ' || lv_table_name
              ||' SET  ' || lv_sql_tmp_stmt
              ||' WHERE SR_INSTANCE_ID = :pINSTANCE_ID '
       	USING pINSTANCE_ID;

Line: 164

	 			 LOG_MESSAGE('Table Updated :   ' || lv_table_name || ' row updated : '|| SQL%ROWCOUNT );

Line: 178

		    ' UPDATE /*+ PARALLEL('|| lv_table_name || ') */ ' || lv_table_name
		    ||' SET  ' || lv_sql_tmp_stmt
		    ||' WHERE SR_INSTANCE_ID = :pINSTANCE_ID '
    USING pINSTANCE_ID;

Line: 182

   LOG_MESSAGE('Table Updated :   ' || lv_table_name || ' row updated : '|| SQL%ROWCOUNT );

Line: 193

               ' UPDATE /*+ PARALLEL('|| lv_table_name || ') */ ' || lv_table_name
              ||' SET  ' || lv_sql_tmp_stmt
              ||' WHERE SR_INSTANCE_ID = :pINSTANCE_ID '
              ||' AND PLAN_ID = -1 '
         	USING pINSTANCE_ID;

Line: 198

	 			 LOG_MESSAGE('Table Updated :   ' || lv_table_name || ' row updated : '|| SQL%ROWCOUNT );

Line: 212

               ' UPDATE /*+ PARALLEL('|| lv_table_name || ') */ ' || lv_table_name
              ||' SET  ' || lv_sql_tmp_stmt
              ||' WHERE SR_INSTANCE_ID = :pINSTANCE_ID '
              ||' AND PLAN_ID = -1 '
     USING pINSTANCE_ID;

Line: 217

   LOG_MESSAGE('Table Updated :   ' || lv_table_name || ' row updated : '|| SQL%ROWCOUNT );

Line: 227

END UPDATE_DATE_COLUMNS;