DBA Data[Home] [Help]

APPS.POA_CM_EVAL_SCORES_ICX dependencies on PO_VENDORS

Line 395: l_supplier_name PO_VENDORS.VENDOR_NAME%TYPE := poa_cm_supplier;

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;
397: l_operating_unit hr_all_organization_units.NAME%TYPE := poa_cm_operating_unit;
398: l_commodity VARCHAR2(81) := poa_cm_commodity;
399: l_item VARCHAR2(40) := poa_cm_item;

Line 494: FROM PO_VENDORS

490: if l_supplier_id is null then
491:
492: SELECT min(vendor_id)
493: INTO l_supplier_id
494: FROM PO_VENDORS
495: WHERE VENDOR_NAME = l_supplier_name;
496:
497: if l_supplier_id is null then
498: reload_header(l_header, 'Invalid Supplier');

Line 754: l_supplier_name PO_VENDORS.VENDOR_NAME%TYPE := poa_cm_supplier;

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;
756: l_operating_unit hr_all_organization_units.NAME%TYPE := poa_cm_operating_unit;
757: l_commodity VARCHAR2(81) := poa_cm_commodity;
758: l_item VARCHAR2(40) := poa_cm_item;

Line 1236: l_supplier_name PO_VENDORS.VENDOR_NAME%TYPE := poa_cm_supplier;

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;
1238: l_operating_unit hr_all_organization_units.NAME%TYPE := poa_cm_operating_unit;
1239: l_commodity VARCHAR2(81) := poa_cm_commodity;
1240: l_item VARCHAR2(40) := poa_cm_item;