APPS.POA_CM_ENTER_SCORES_ICX SQL Statements

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

Line: 58

			'Update'		   ,
			POA_CM_EVALUATION_ID	   );

Line: 63

   	poa_cm_enter_scores_icx.insert_scores(
			criteria_code	,
			score 		,
			weight		,
			weighted_score  ,
			min_score	,
			max_score	,
			comments	,
			total_score	,
			poa_cm_custom_measure_code ,
			poa_cm_custom_measure      ,
			poa_cm_period_type	   ,
			poa_cm_user_period_type    ,
			poa_cm_period_name	   ,
			poa_cm_supplier_id	   ,
			poa_cm_supplier	      	   ,
			poa_cm_supplier_site_id    ,
		 	poa_cm_supplier_site       ,
			poa_cm_category_id	   ,
			poa_cm_commodity	   ,
			poa_cm_item_id		   ,
			poa_cm_item		   ,
			poa_cm_comments		   ,
			poa_cm_evaluated_by_id     ,
			poa_cm_evaluated_by	   ,
			poa_cm_org_id	      	   ,
			poa_cm_oper_unit_id	   ,
			poa_cm_operating_unit      ,
			poa_cm_submit_type	   ,
			poa_cm_evaluation_id	   );

Line: 97

PROCEDURE insert_scores(criteria_code	IN t_text_table,
			score 		IN t_text_table,
			weight		IN t_text_table,
			weighted_score  IN t_text_table,
			min_score	IN t_text_table,
			max_score	IN t_text_table,
			comments	IN t_text_table,
			total_score	IN VARCHAR2,
			poa_cm_custom_measure_code IN VARCHAR2 DEFAULT NULL,
			poa_cm_custom_measure      IN VARCHAR2 DEFAULT NULL,
			poa_cm_period_type	   IN VARCHAR2 DEFAULT NULL,
			poa_cm_user_period_type    IN VARCHAR2 DEFAULT NULL,
			poa_cm_period_name	   IN VARCHAR2 DEFAULT NULL,
			poa_cm_supplier_id	   IN VARCHAR2 DEFAULT NULL,
			poa_cm_supplier	      	   IN VARCHAR2 DEFAULT NULL,
			poa_cm_supplier_site_id    IN VARCHAR2 DEFAULT NULL,
		 	poa_cm_supplier_site       IN VARCHAR2 DEFAULT NULL,
			poa_cm_category_id	   IN VARCHAR2 DEFAULT NULL,
			poa_cm_commodity	   IN VARCHAR2 DEFAULT NULL,
			poa_cm_item_id		   IN VARCHAR2 DEFAULT NULL,
			poa_cm_item		   IN VARCHAR2 DEFAULT NULL,
			poa_cm_comments		   IN VARCHAR2 DEFAULT NULL,
			poa_cm_evaluated_by_id     IN VARCHAR2 DEFAULT NULL,
			poa_cm_evaluated_by	   IN VARCHAR2 DEFAULT NULL,
			poa_cm_org_id	      	   IN VARCHAR2 DEFAULT NULL,
			poa_cm_oper_unit_id	   IN VARCHAR2 DEFAULT NULL,
			poa_cm_operating_unit      IN VARCHAR2 DEFAULT NULL,
			poa_cm_submit_type	   IN VARCHAR2 DEFAULT NULL,
			POA_CM_EVALUATION_ID	   IN VARCHAR2 DEFAULT NULL
) IS
  X_evaluation_id number;

Line: 144

    SELECT poa_cm_evaluation_s.nextval
      INTO X_evaluation_id
      FROM sys.dual;

Line: 156

    insert into poa_cm_evaluation
    (	EVALUATION_ID,
	CUSTOM_MEASURE_CODE,
	PERIOD_TYPE,
 	PERIOD_NAME,
 	SUPPLIER_ID,
 	OPER_UNIT_ID,
 	ORG_ID,
 	SUPPLIER_SITE_ID,
 	CATEGORY_ID,
 	ITEM_ID,
 	EVALUATED_BY,
 	COMMENTS,
 	CREATED_BY,
 	CREATION_DATE,
 	LAST_UPDATED_BY,
 	LAST_UPDATE_DATE,
 	LAST_UPDATE_LOGIN,
 	REQUEST_ID,
 	PROGRAM_APPLICATION_ID,
 	PROGRAM_ID,
 	PROGRAM_UPDATE_DATE,
 	ATTRIBUTE_CATEGORY,
 	ATTRIBUTE1,
 	ATTRIBUTE2,
 	ATTRIBUTE3,
 	ATTRIBUTE4,
 	ATTRIBUTE5,
 	ATTRIBUTE6,
 	ATTRIBUTE7,
 	ATTRIBUTE8,
 	ATTRIBUTE9,
 	ATTRIBUTE10,
 	ATTRIBUTE11,
 	ATTRIBUTE12,
 	ATTRIBUTE13,
 	ATTRIBUTE14,
 	ATTRIBUTE15
    ) VALUES
    (	X_evaluation_id,
	poa_cm_custom_measure_code,
	poa_cm_period_type,
	poa_cm_period_name,
	to_number(poa_cm_supplier_id),
	to_number(poa_cm_oper_unit_id),
	to_number(poa_cm_org_id),
	to_number(poa_cm_supplier_site_id),
	to_number(poa_cm_category_id),
	to_number(poa_cm_item_id),
	to_number(poa_cm_evaluated_by_id),
	poa_cm_comments,
	fnd_global.user_id,
	SYSDATE,
	fnd_global.user_id,
	SYSDATE,
	fnd_global.login_id,
	fnd_global.conc_request_id,
	fnd_global.prog_appl_id,
	fnd_global.conc_program_id,
	SYSDATE,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL);

Line: 244

        SELECT poa_cm_eval_scores_s.nextval
        INTO X_evaluation_score_id
        FROM sys.dual;

Line: 248

	SELECT pes.evaluation_score_id
	INTO X_evaluation_score_id
	FROM poa_cm_eval_scores pes
	WHERE pes.criteria_code = l_criteria_code
	AND pes.evaluation_id = X_evaluation_id;

Line: 261

      insert into poa_cm_eval_scores
      (
        EVALUATION_SCORE_ID,
        CRITERIA_CODE,
        SCORE,
        WEIGHT,
        MIN_SCORE,
        MAX_SCORE,
        COMMENTS,
        EVALUATION_ID,
 	CREATED_BY,
 	CREATION_DATE,
 	LAST_UPDATED_BY,
 	LAST_UPDATE_DATE,
 	LAST_UPDATE_LOGIN,
 	REQUEST_ID,
 	PROGRAM_APPLICATION_ID,
 	PROGRAM_ID,
 	PROGRAM_UPDATE_DATE,
 	ATTRIBUTE_CATEGORY,
 	ATTRIBUTE1,
 	ATTRIBUTE2,
 	ATTRIBUTE3,
 	ATTRIBUTE4,
 	ATTRIBUTE5,
 	ATTRIBUTE6,
 	ATTRIBUTE7,
 	ATTRIBUTE8,
 	ATTRIBUTE9,
 	ATTRIBUTE10,
 	ATTRIBUTE11,
 	ATTRIBUTE12,
 	ATTRIBUTE13,
 	ATTRIBUTE14,
 	ATTRIBUTE15
      ) values (
        X_evaluation_score_id,
        criteria_code(v_counter),
        to_number(score(v_counter)),
        to_number(weight(v_counter)),
        to_number(min_score(v_counter)),
        to_number(max_score(v_counter)),
        comments(v_counter),
        X_evaluation_id,
	fnd_global.user_id,
	SYSDATE,
	fnd_global.user_id,
	SYSDATE,
	fnd_global.login_id,
	fnd_global.conc_request_id,
	fnd_global.prog_appl_id,
	fnd_global.conc_program_id,
	SYSDATE,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL,
	NULL);

Line: 331

	update poa_cm_eval_scores pes
	set pes.score = l_score,
	    pes.comments = l_comments,
	    pes.last_update_date = SYSDATE
	where evaluation_score_id = X_evaluation_score_id;

Line: 337

	update poa_cm_evaluation pce
	set pce.last_update_date = SYSDATE
	where evaluation_id = X_evaluation_id;

Line: 349

      htp.p('POA_CM_ENTER_SCORES_ICX.INSERT_SCORE: Progress ' || l_progress || ' ' || sqlerrm);

Line: 359

END insert_scores;