APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PO_VENDORS

Line 453: FROM po_vendors

449: l_id_found_flag VARCHAR(1) := 'N';
450:
451: CURSOR c_ids IS
452: SELECT vendor_id
453: FROM po_vendors
454: WHERE vendor_name = p_supplier_name;
455: BEGIN
456: IF (p_supplier_id IS NOT NULL)
457: THEN

Line 462: FROM PO_Vendors

458: IF (p_check_id_flag = 'Y') THEN
459: BEGIN
460: SELECT vendor_id
461: INTO x_supplier_id
462: FROM PO_Vendors
463: WHERE vendor_id = p_supplier_id;
464: EXCEPTION
465: WHEN OTHERS THEN
466: x_supplier_id := NULL;

Line 515: FROM po_vendors

511: IF (p_supplier_name IS NOT NULL) THEN
512: BEGIN
513: SELECT vendor_id
514: INTO x_supplier_id
515: FROM po_vendors
516: WHERE vendor_name = p_supplier_name;
517: EXCEPTION
518: WHEN OTHERS THEN
519: x_supplier_id := NULL;

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

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

Line 3992: Po_Vendors

3988: Cursor c_Supplier (P_Vendor_Id IN Number) Is
3989: Select
3990: Vendor_Name
3991: From
3992: Po_Vendors
3993: Where
3994: Vendor_id = P_Vendor_Id;
3995:
3996: Begin