DBA Data[Home] [Help]

APPS.POA_CM_EVAL_SCORES_ICX dependencies on POA_CM_EVALUATION

Line 7: poa_cm_evaluation_icx.header_page( p_header.custom_measure_code,

3:
4: PROCEDURE Reload_Header(p_header t_header_record, error_msg VARCHAR2)
5: IS
6: BEGIN
7: poa_cm_evaluation_icx.header_page( p_header.custom_measure_code,
8: p_header.custom_measure,
9: p_header.period_type,
10: p_header.user_period_type,
11: p_header.period_name,

Line 373: POA_CM_EVALUATION_ID IN VARCHAR2 DEFAULT NULL

369: poa_cm_org_id IN VARCHAR2 DEFAULT NULL,
370: poa_cm_oper_unit_id IN VARCHAR2 DEFAULT NULL,
371: poa_cm_operating_unit IN VARCHAR2 DEFAULT NULL,
372: POA_CM_SUBMIT_TYPE IN VARCHAR2 DEFAULT NULL,
373: POA_CM_EVALUATION_ID IN VARCHAR2 DEFAULT NULL
374: ) IS
375:
376: x_category_set_id NUMBER;
377: x_structure_id NUMBER;

Line 392: l_evaluation_id NUMBER := to_number(poa_cm_evaluation_id);

388: l_category_id NUMBER := to_number(poa_cm_category_id);
389: l_item_id NUMBER := to_number(poa_cm_item_id);
390: l_evaluated_by_id NUMBER := to_number(poa_cm_evaluated_by_id);
391: l_oper_unit_id NUMBER := to_number(poa_cm_oper_unit_id);
392: l_evaluation_id NUMBER := to_number(poa_cm_evaluation_id);
393:
394: l_user_period_type VARCHAR2(15) := poa_cm_user_period_type;
395: l_supplier_name PO_VENDORS.VENDOR_NAME%TYPE := poa_cm_supplier;
396: l_site_name VARCHAR2(15) := poa_cm_supplier_site;

Line 431: l_header.evaluation_id := poa_cm_evaluation_id;

427: l_header.org_id := poa_cm_org_id;
428: l_header.oper_unit_id := poa_cm_oper_unit_id;
429: l_header.operating_unit := poa_cm_operating_unit;
430: l_header.submit_type := poa_cm_submit_type;
431: l_header.evaluation_id := poa_cm_evaluation_id;
432:
433:
434: -- Set multi-org context
435:

Line 682: POA_CM_EVALUATION_ID );

678: poa_cm_org_id ,
679: l_oper_unit_id ,
680: poa_cm_operating_unit ,
681: 'Update' ,
682: POA_CM_EVALUATION_ID );
683: end if;
684:
685: if (POA_CM_SUBMIT_TYPE = 'Update') then
686: poa_cm_eval_scores_icx.query_evals(

Line 707: poa_cm_evaluation_id );

703: poa_cm_org_id ,
704: l_oper_unit_id ,
705: poa_cm_operating_unit ,
706: poa_cm_submit_type ,
707: poa_cm_evaluation_id );
708: end if;
709:
710: if (POA_CM_SUBMIT_TYPE is null) then
711: poa_cm_evaluation_icx.header_page();

Line 711: poa_cm_evaluation_icx.header_page();

707: poa_cm_evaluation_id );
708: end if;
709:
710: if (POA_CM_SUBMIT_TYPE is null) then
711: poa_cm_evaluation_icx.header_page();
712: end if;
713:
714: END redirect_page;
715:

Line 736: poa_cm_evaluation_id IN VARCHAR2 DEFAULT NULL

732: poa_cm_org_id IN VARCHAR2 DEFAULT NULL,
733: poa_cm_oper_unit_id IN VARCHAR2 DEFAULT NULL,
734: poa_cm_operating_unit IN VARCHAR2 DEFAULT NULL,
735: poa_cm_submit_type IN VARCHAR2 DEFAULT NULL,
736: poa_cm_evaluation_id IN VARCHAR2 DEFAULT NULL
737: ) IS
738:
739: l_language VARCHAR2(5);
740: l_script_name VARCHAR2(240);

Line 751: l_evaluation_id NUMBER := to_number(poa_cm_evaluation_id);

747: l_category_id NUMBER := to_number(poa_cm_category_id);
748: l_item_id NUMBER := to_number(poa_cm_item_id);
749: l_evaluated_by_id NUMBER := to_number(poa_cm_evaluated_by_id);
750: l_oper_unit_id NUMBER := to_number(poa_cm_oper_unit_id);
751: l_evaluation_id NUMBER := to_number(poa_cm_evaluation_id);
752:
753: l_user_period_type VARCHAR2(15) := poa_cm_user_period_type;
754: l_supplier_name PO_VENDORS.VENDOR_NAME%TYPE := poa_cm_supplier;
755: l_site_name VARCHAR2(15) := poa_cm_supplier_site;

Line 786: FROM poa_cm_evaluation

782: ELSE
783:
784: SELECT category_id, oper_unit_id
785: INTO l_category_id, l_oper_unit_id
786: FROM poa_cm_evaluation
787: WHERE evaluation_id = l_evaluation_id;
788:
789: open c_Criteria for
790: select criteria_code, weight, min_score, max_score

Line 1180: htp.p('');

1176: htp.p('');
1177: htp.p('');
1178: htp.p('');
1179: htp.p('');
1180: htp.p('');
1181:
1182: htp.p('');
1183:
1184: htp.p('');

Line 1218: POA_CM_EVALUATION_ID IN VARCHAR2 DEFAULT NULL

1214: poa_cm_org_id IN VARCHAR2 DEFAULT NULL,
1215: poa_cm_oper_unit_id IN VARCHAR2 DEFAULT NULL,
1216: poa_cm_operating_unit IN VARCHAR2 DEFAULT NULL,
1217: POA_CM_SUBMIT_TYPE IN VARCHAR2 DEFAULT NULL,
1218: POA_CM_EVALUATION_ID IN VARCHAR2 DEFAULT NULL
1219: ) IS
1220:
1221: l_language VARCHAR2(5);
1222: l_script_name VARCHAR2(240);

Line 1233: l_evaluation_id NUMBER := to_number(poa_cm_evaluation_id);

1229: l_category_id NUMBER := to_number(poa_cm_category_id);
1230: l_item_id NUMBER := to_number(poa_cm_item_id);
1231: l_evaluated_by_id NUMBER := to_number(poa_cm_evaluated_by_id);
1232: l_oper_unit_id NUMBER := to_number(poa_cm_oper_unit_id);
1233: l_evaluation_id NUMBER := to_number(poa_cm_evaluation_id);
1234:
1235: l_user_period_type VARCHAR2(15) := poa_cm_user_period_type;
1236: l_supplier_name PO_VENDORS.VENDOR_NAME%TYPE := poa_cm_supplier;
1237: l_site_name VARCHAR2(15) := poa_cm_supplier_site;

Line 1418: FROM poa_cm_evaluation pce,

1414: item.concatenated_segments,
1415: fu.user_name,
1416: pce.creation_date,
1417: pce.last_update_date
1418: FROM poa_cm_evaluation pce,
1419: hr_operating_units hr,
1420: fnd_user fu,
1421: mtl_categories_kfv cat,
1422: mtl_system_items_kfv item,

Line 1446: FROM poa_cm_evaluation pce,

1442: item.concatenated_segments,
1443: fu.user_name,
1444: pce.creation_date,
1445: pce.last_update_date
1446: FROM poa_cm_evaluation pce,
1447: hr_operating_units hr,
1448: fnd_user fu,
1449: mtl_categories_kfv cat,
1450: mtl_system_items_kfv item,

Line 1474: FROM poa_cm_evaluation pce,

1470: item.concatenated_segments,
1471: fu.user_name,
1472: pce.creation_date,
1473: pce.last_update_date
1474: FROM poa_cm_evaluation pce,
1475: hr_operating_units hr,
1476: fnd_user fu,
1477: mtl_categories_kfv cat,
1478: mtl_system_items_kfv item,

Line 1503: FROM poa_cm_evaluation pce,

1499: item.concatenated_segments,
1500: fu.user_name,
1501: pce.creation_date,
1502: pce.last_update_date
1503: FROM poa_cm_evaluation pce,
1504: hr_operating_units hr,
1505: fnd_user fu,
1506: mtl_categories_kfv cat,
1507: mtl_system_items_kfv item,

Line 1536: htp.p(' ');

1532: end if;
1533:
1534: if (v_counter = 1) THEN
1535:
1536: htp.p(' ');
1537: else
1538: htp.p(' ');
1539: end if;
1540:

Line 1538: htp.p(' ');

1534: if (v_counter = 1) THEN
1535:
1536: htp.p(' ');
1537: else
1538: htp.p(' ');
1539: end if;
1540:
1541: htp.p('
1542: ' || v_oper_unit || '