APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PO_VENDORS

Line 449: FROM po_vendors

445: l_id_found_flag VARCHAR(1) := 'N';
446:
447: CURSOR c_ids IS
448: SELECT vendor_id
449: FROM po_vendors
450: WHERE vendor_name = p_supplier_name;
451: BEGIN
452: IF (p_supplier_id IS NOT NULL)
453: THEN

Line 458: FROM PO_Vendors

454: IF (p_check_id_flag = 'Y') THEN
455: BEGIN
456: SELECT vendor_id
457: INTO x_supplier_id
458: FROM PO_Vendors
459: WHERE vendor_id = p_supplier_id;
460: EXCEPTION
461: WHEN OTHERS THEN
462: x_supplier_id := NULL;

Line 511: FROM po_vendors

507: IF (p_supplier_name IS NOT NULL) THEN
508: BEGIN
509: SELECT vendor_id
510: INTO x_supplier_id
511: FROM po_vendors
512: WHERE vendor_name = p_supplier_name;
513: EXCEPTION
514: WHEN OTHERS THEN
515: x_supplier_id := NULL;

Line 559: l_supplier_id PO_VENDORS.vendor_id%TYPE := NULL;

555:
556: IS
557: l_return_status VARCHAR2(1);
558: l_error_msg_code fnd_new_messages.message_name%TYPE;
559: l_supplier_id PO_VENDORS.vendor_id%TYPE := NULL;
560: l_err_status VARCHAR2(30) := 'N';
561: /************************************************************************
562: * Sub-function : Is_Contingent_Worker
563: * Description : This Subprog checks if the resource is a contingent

Line 3951: Po_Vendors

3947: Cursor c_Supplier (P_Vendor_Id IN Number) Is
3948: Select
3949: Vendor_Name
3950: From
3951: Po_Vendors
3952: Where
3953: Vendor_id = P_Vendor_Id;
3954:
3955: Begin