APPS.POA_CM_ENTER_SCORES_ICX dependencies on POA_CM_EVAL_SCORES

Line 38: poa_cm_eval_scores_icx.score_entry_page(

34:
35: BEGIN
36:
37: if (POA_CM_SUBMIT_TYPE = 'Refresh') then
38: poa_cm_eval_scores_icx.score_entry_page(
39: poa_cm_custom_measure_code ,
40: poa_cm_custom_measure ,
41: poa_cm_period_type ,
42: poa_cm_user_period_type ,

Line 244: SELECT poa_cm_eval_scores_s.nextval

240: l_criteria_code := criteria_code(v_counter);
241:
242: if (l_evaluation_id is null) then
243:
244: SELECT poa_cm_eval_scores_s.nextval
245: INTO X_evaluation_score_id
246: FROM sys.dual;
247: else
248: SELECT pes.evaluation_score_id

Line 250: FROM poa_cm_eval_scores pes

246: FROM sys.dual;
247: else
248: SELECT pes.evaluation_score_id
249: INTO X_evaluation_score_id
250: FROM poa_cm_eval_scores pes
251: WHERE pes.criteria_code = l_criteria_code
252: AND pes.evaluation_id = X_evaluation_id;
253:
254: end if;

Line 261: insert into poa_cm_eval_scores

257: l_comments := comments(v_counter);
258:
259: if (l_evaluation_id is null) then
260:
261: insert into poa_cm_eval_scores
262: (
263: EVALUATION_SCORE_ID,
264: CRITERIA_CODE,
265: SCORE,

Line 331: update poa_cm_eval_scores pes

327: NULL,
328: NULL,
329: NULL);
330: else
331: update poa_cm_eval_scores pes
332: set pes.score = l_score,
333: pes.comments = l_comments,
334: pes.last_update_date = SYSDATE
335: where evaluation_score_id = X_evaluation_score_id;