APPS.AMW_EVALUATIONS_PKG dependencies on AMW_EVALUATIONS_DETAILS

Line 138: insert into amw_evaluations_details (

134: and T.LANGUAGE = L.LANGUAGE_CODE);
135:
136:
137: if p_EVALUATION_OBJECT_NAME = 'PROCEDURE_CONTROL' then
138: insert into amw_evaluations_details (
139: EVALUATION_ID,
140: EVALUATION_COMPONENT,
141: LAST_UPDATE_DATE,
142: LAST_UPDATED_BY,

Line 158: insert into amw_evaluations_details (

154: G_USER_ID,
155: G_LOGIN_ID,
156: p_DES_EFF
157: );
158: insert into amw_evaluations_details (
159: EVALUATION_ID,
160: EVALUATION_COMPONENT,
161: LAST_UPDATE_DATE,
162: LAST_UPDATED_BY,

Line 180: insert into amw_evaluations_details (

176: p_OP_EFF
177: );
178: end if;
179: if p_EVALUATION_OBJECT_NAME = 'PROCEDURE' then
180: insert into amw_evaluations_details (
181: EVALUATION_ID,
182: EVALUATION_COMPONENT,
183: LAST_UPDATE_DATE,
184: LAST_UPDATED_BY,

Line 202: insert into amw_evaluations_details (

198: p_OV_EFF
199: );
200: end if;
201: if p_EVALUATION_OBJECT_NAME = 'ASSESSMENT_COMPONENT' OR p_EVALUATION_OBJECT_NAME = 'ASSESSMENT' then
202: insert into amw_evaluations_details (
203: EVALUATION_ID,
204: EVALUATION_COMPONENT,
205: LAST_UPDATE_DATE,
206: LAST_UPDATED_BY,

Line 261: update amw_evaluations_details set

257:
258:
259: if p_EVALUATION_OBJECT_NAME = 'PROCEDURE_CONTROL' then
260:
261: update amw_evaluations_details set
262: EVALUATION_CONCLUSION = p_DES_EFF,
263: LAST_UPDATE_DATE = sysdate,
264: LAST_UPDATED_BY = G_USER_ID,
265: CREATION_DATE = sysdate,

Line 272: update amw_evaluations_details set

268: where evaluation_id = p_evaluation_id
269: and EVALUATION_COMPONENT = 'DESIGN_EFFECTIVENESS';
270:
271:
272: update amw_evaluations_details set
273: EVALUATION_CONCLUSION = p_OP_EFF,
274: LAST_UPDATE_DATE = sysdate,
275: LAST_UPDATED_BY = G_USER_ID,
276: CREATION_DATE = sysdate,

Line 285: update amw_evaluations_details set

281: end if;
282:
283: if p_EVALUATION_OBJECT_NAME = 'PROCEDURE' then
284:
285: update amw_evaluations_details set
286: EVALUATION_CONCLUSION = p_OV_EFF,
287: LAST_UPDATE_DATE = sysdate,
288: LAST_UPDATED_BY = G_USER_ID,
289: CREATION_DATE = sysdate,

Line 300: update amw_evaluations_details set

296:
297:
298: if p_EVALUATION_OBJECT_NAME = 'ASSESSMENT_COMPONENT' OR p_EVALUATION_OBJECT_NAME = 'ASSESSMENT' then
299:
300: update amw_evaluations_details set
301: EVALUATION_CONCLUSION = p_OV_EFF,
302: LAST_UPDATE_DATE = sysdate,
303: LAST_UPDATED_BY = G_USER_ID,
304: CREATION_DATE = sysdate,

Line 343: from amw_evaluations_details

339: l_ev_conl varchar2(1);
340: begin
341: select evaluation_conclusion
342: into l_ev_conl
343: from amw_evaluations_details
344: where evaluation_id = p_evaluation_id
345: and evaluation_component = 'OPERATING_EFFECTIVENESS';
346:
347: RETURN AMW_Utility_PVT.get_lookup_meaning('AMW_PASS_FAIL', l_ev_conl);

Line 356: from amw_evaluations_details

352: l_ev_conl varchar2(1);
353: begin
354: select evaluation_conclusion
355: into l_ev_conl
356: from amw_evaluations_details
357: where evaluation_id = p_evaluation_id
358: and evaluation_component = 'DESIGN_EFFECTIVENESS';
359:
360: RETURN AMW_Utility_PVT.get_lookup_meaning('AMW_PASS_FAIL', l_ev_conl);

Line 368: from amw_evaluations_details

364: l_ev_conl varchar2(1);
365: begin
366: select evaluation_conclusion
367: into l_ev_conl
368: from amw_evaluations_details
369: where evaluation_id = p_evaluation_id
370: and evaluation_component = 'OPERATING_EFFECTIVENESS';
371:
372: RETURN l_ev_conl;

Line 381: from amw_evaluations_details

377: l_ev_conl varchar2(1);
378: begin
379: select evaluation_conclusion
380: into l_ev_conl
381: from amw_evaluations_details
382: where evaluation_id = p_evaluation_id
383: and evaluation_component = 'DESIGN_EFFECTIVENESS';
384:
385: RETURN l_ev_conl;

Line 393: from amw_evaluations_details

389: l_ev_conl varchar2(1);
390: begin
391: select evaluation_conclusion
392: into l_ev_conl
393: from amw_evaluations_details
394: where evaluation_id = p_evaluation_id
395: and evaluation_component = 'LINE_CONCLUSION';
396:
397: RETURN AMW_Utility_PVT.get_lookup_meaning('AMW_EVALUATION_CONCLUSION', l_ev_conl);

Line 405: from amw_evaluations_details

401: l_ev_conl varchar2(1);
402: begin
403: select evaluation_conclusion
404: into l_ev_conl
405: from amw_evaluations_details
406: where evaluation_id = p_evaluation_id
407: and evaluation_component = 'LINE_COMPONENT';
408:
409: RETURN l_ev_conl;