DBA Data[Home] [Help]

APPS.CHV_BUILD_SCHEDULES dependencies on PO_VENDORS

Line 58: ** VARCHAR2(80) with po_vendors.vendor_name type(which is 240) */

54: to 240 to make it UTF8 compliant */
55: x_organization_name VARCHAR2(240);
56:
57: /* Bug#2823839 Increased the width of the x_vendor_name by replacing
58: ** VARCHAR2(80) with po_vendors.vendor_name type(which is 240) */
59:
60: x_vendor_name po_vendors.vendor_name%type;
61: x_vendor_code VARCHAR2(15);
62: x_item_desc VARCHAR2(240);

Line 60: x_vendor_name po_vendors.vendor_name%type;

56:
57: /* Bug#2823839 Increased the width of the x_vendor_name by replacing
58: ** VARCHAR2(80) with po_vendors.vendor_name type(which is 240) */
59:
60: x_vendor_name po_vendors.vendor_name%type;
61: x_vendor_code VARCHAR2(15);
62: x_item_desc VARCHAR2(240);
63: x_bucket_pattern_id NUMBER;
64: x_mrp_compile_designator VARCHAR2(10);

Line 840: SELECT vendor_name into x_vendor_name from po_vendors where p_vendor_id = vendor_id;

836: SELECT organization_name INTO x_organization_name from org_organization_definitions
837: where organization_id = x_organization_id;
838:
839: IF p_vendor_id is not null THEN
840: SELECT vendor_name into x_vendor_name from po_vendors where p_vendor_id = vendor_id;
841: ELSE
842: x_vendor_name := 'No Vendor Provided';
843: END IF;
844: