APPS.POA_EDW_CSTM_MSR_F_C SQL Statements

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

Line: 42

  l_rows_inserted        Number:=0;

Line: 60

   Insert Into POA_EDW_CSTM_MSR_FSTG (
     DUNS_FK,
     UNSPSC_FK,
     SIC_CODE_FK,
     CRITERIA_CODE_FK,
     CSTM_MSR_PK,
     CUSTOM_MEASURE_FK,
     EVAL_COMMENTS,
     EVAL_DATE_FK,
     INSTANCE_FK,
     ITEM_FK,
     MAX_SCORE,
     MIN_SCORE,
     OPERATING_UNIT_FK,
     SCORE,
     SCORE_COMMENTS,
     SUPPLIER_SITE_FK,
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
	USER_ATTRIBUTE6,
	USER_ATTRIBUTE7,
	USER_ATTRIBUTE8,
	USER_ATTRIBUTE9,
	USER_ATTRIBUTE10,
	USER_ATTRIBUTE11,
	USER_ATTRIBUTE12,
	USER_ATTRIBUTE13,
	USER_ATTRIBUTE14,
	USER_ATTRIBUTE15,
     USER_FK1,
     USER_FK2,
     USER_FK3,
     USER_FK4,
     USER_FK5,
     USER_MEASURE1,
     USER_MEASURE2,
     USER_MEASURE3,
     USER_MEASURE4,
     USER_MEASURE5,
     USER_NAME,
     WEIGHT,
     WEIGHTED_SCORE,
     OPERATION_CODE,
     COLLECTION_STATUS,
     	EVALUATION_ID)
   select
     NVL(DUNS_FK, 'NA_EDW'),
     NVL(UNSPSC_FK, 'NA_EDW'),
     NVL(SIC_CODE_FK, 'NA_EDW'),
     NVL(CRITERIA_CODE_FK,'NA_EDW'),
     CSTM_MSR_PK,
     NVL(CUSTOM_MEASURE_FK,'NA_EDW'),
     EVAL_COMMENTS,
     NVL(EVAL_DATE_FK,'NA_EDW'),
     NVL(INSTANCE_FK,'NA_EDW'),
     NVL(ITEM_FK,'NA_EDW'),
     MAX_SCORE,
     MIN_SCORE,
     NVL(OPERATING_UNIT_FK,'NA_EDW'),
     SCORE,
     SCORE_COMMENTS,
     NVL(SUPPLIER_SITE_FK,'NA_EDW'),
     USER_ATTRIBUTE1,
     USER_ATTRIBUTE2,
     USER_ATTRIBUTE3,
     USER_ATTRIBUTE4,
     USER_ATTRIBUTE5,
	USER_ATTRIBUTE6,
	USER_ATTRIBUTE7,
	USER_ATTRIBUTE8,
	USER_ATTRIBUTE9,
	USER_ATTRIBUTE10,
	USER_ATTRIBUTE11,
	USER_ATTRIBUTE12,
	USER_ATTRIBUTE13,
	USER_ATTRIBUTE14,
	USER_ATTRIBUTE15,
     NVL(USER_FK1,'NA_EDW'),
     NVL(USER_FK2,'NA_EDW'),
     NVL(USER_FK3,'NA_EDW'),
     NVL(USER_FK4,'NA_EDW'),
     NVL(USER_FK5,'NA_EDW'),
     USER_MEASURE1,
     USER_MEASURE2,
     USER_MEASURE3,
     USER_MEASURE4,
     USER_MEASURE5,
     USER_NAME,
     WEIGHT,
     WEIGHTED_SCORE,
     NULL, -- OPERATION_CODE
     'LOCAL READY',
     EVALUATION_ID
   from POA_EDW_CUSTOM_MEASURE_FCV
   WHERE view_id   = p_view_id
   AND   seq_id    = p_seq_id;

Line: 160

   l_rows_inserted := sql%rowcount;

Line: 163

   edw_log.put_line('...Inserted ' || to_char(nvl(l_rows_inserted,0))||
         ' rows into the local staging table');

Line: 168

   RETURN (l_rows_inserted);

Line: 193

   select poa_edw_cstm_msr_inc_s.nextval into l_seq_id from dual;

Line: 195

	INSERT INTO poa_edw_cstm_msr_inc(primary_key, seq_id)
	SELECT  pms.evaluation_score_id, l_seq_id
	  FROM  poa_cm_eval_scores              pms,
                poa_cm_evaluation               pme
	 WHERE  pms.evaluation_id    = pme.evaluation_id
           AND  greatest(pms.last_update_date, pme.last_update_date)
                       between g_push_date_range1 and g_push_date_range2;

Line: 297

      edw_log.put_line('Inserting into local staging table for view type 1');

Line: 302

      edw_log.put_line('Inserted '|| nvl(l_row_count1, 0) ||
                       ' rows into the local staging table for view type 1');

Line: 318

      edw_log.put_line('Inserted '||nvl(g_row_count,0)||
                       ' rows into the staging table');

Line: 335

      rollback;   -- Rollback insert into local staging

Line: 336

      edw_log.put_line('Inserting into local staging have failed');