APPS.POA_CM_ENTER_SCORES_ICX dependencies on POA_CM_EVALUATION

Line 32: POA_CM_EVALUATION_ID IN VARCHAR2 DEFAULT NULL

28: poa_cm_org_id IN VARCHAR2 DEFAULT NULL,
29: poa_cm_oper_unit_id IN VARCHAR2 DEFAULT NULL,
30: poa_cm_operating_unit IN VARCHAR2 DEFAULT NULL,
31: POA_CM_SUBMIT_TYPE IN VARCHAR2 DEFAULT NULL,
32: POA_CM_EVALUATION_ID IN VARCHAR2 DEFAULT NULL
33: ) IS
34:
35: BEGIN
36:

Line 59: POA_CM_EVALUATION_ID );

55: poa_cm_org_id ,
56: poa_cm_oper_unit_id ,
57: poa_cm_operating_unit ,
58: 'Update' ,
59: POA_CM_EVALUATION_ID );
60: end if;
61:
62: if (POA_CM_SUBMIT_TYPE = 'Done') then
63: poa_cm_enter_scores_icx.insert_scores(

Line 92: poa_cm_evaluation_id );

88: poa_cm_org_id ,
89: poa_cm_oper_unit_id ,
90: poa_cm_operating_unit ,
91: poa_cm_submit_type ,
92: poa_cm_evaluation_id );
93: end if;
94:
95: END redirect_page;
96:

Line 125: POA_CM_EVALUATION_ID IN VARCHAR2 DEFAULT NULL

121: poa_cm_org_id IN VARCHAR2 DEFAULT NULL,
122: poa_cm_oper_unit_id IN VARCHAR2 DEFAULT NULL,
123: poa_cm_operating_unit IN VARCHAR2 DEFAULT NULL,
124: poa_cm_submit_type IN VARCHAR2 DEFAULT NULL,
125: POA_CM_EVALUATION_ID IN VARCHAR2 DEFAULT NULL
126: ) IS
127: X_evaluation_id number;
128: X_evaluation_score_id number;
129:

Line 131: l_evaluation_id NUMBER := to_number(POA_CM_EVALUATION_ID);

127: X_evaluation_id number;
128: X_evaluation_score_id number;
129:
130: l_progress varchar2(240);
131: l_evaluation_id NUMBER := to_number(POA_CM_EVALUATION_ID);
132: l_criteria_code VARCHAR2(30);
133: l_score NUMBER;
134: l_comments VARCHAR2(240);
135:

Line 144: SELECT poa_cm_evaluation_s.nextval

140: l_progress := '001';
141:
142: if (l_evaluation_id is null) then
143:
144: SELECT poa_cm_evaluation_s.nextval
145: INTO X_evaluation_id
146: FROM sys.dual;
147:
148: else

Line 156: insert into poa_cm_evaluation

152: l_progress := '001.5';
153:
154: if (l_evaluation_id is null) then
155:
156: insert into poa_cm_evaluation
157: ( EVALUATION_ID,
158: CUSTOM_MEASURE_CODE,
159: PERIOD_TYPE,
160: PERIOD_NAME,

Line 337: update poa_cm_evaluation pce

333: pes.comments = l_comments,
334: pes.last_update_date = SYSDATE
335: where evaluation_score_id = X_evaluation_score_id;
336:
337: update poa_cm_evaluation pce
338: set pce.last_update_date = SYSDATE
339: where evaluation_id = X_evaluation_id;
340: end if;
341:

Line 355: poa_cm_evaluation_icx.header_page();

351: end;
352:
353: l_progress := '006';
354:
355: poa_cm_evaluation_icx.header_page();
356:
357: l_progress := '007';
358:
359: END insert_scores;