APPS.AP_APXVDDUP_XMLP_PKG dependencies on PO_VENDORS

Line 169: FROM po_vendors

165: 'a!@#\/~-$%^ ,''*.','a')) new_name,
166: substr(upper(translate(vendor_name,
167: 'a!@#\/~-$%^ ,''*.','a')),1,p_tst_len)
168: substr_new_name
169: FROM po_vendors
170: WHERE sysdate between nvl(start_date_active,sysdate-1)
171: and nvl(end_date_active,sysdate+1)
172: AND enabled_flag='Y'
173: ORDER BY upper(translate(vendor_name,

Line 175: l_VENDOR_NUMBER po_vendors.segment1%TYPE;

171: and nvl(end_date_active,sysdate+1)
172: AND enabled_flag='Y'
173: ORDER BY upper(translate(vendor_name,
174: 'a!@#\/~-$%^ ,''*.','a'));
175: l_VENDOR_NUMBER po_vendors.segment1%TYPE;
176: l_VENDOR_ID po_vendors.vendor_id%TYPE;
177: l_VENDOR_NAME po_vendors.vendor_name%TYPE;
178: l_NEW_NAME po_vendors.vendor_name%TYPE;
179: l_SUBSTR_NEW_NAME po_vendors.vendor_name%TYPE;

Line 176: l_VENDOR_ID po_vendors.vendor_id%TYPE;

172: AND enabled_flag='Y'
173: ORDER BY upper(translate(vendor_name,
174: 'a!@#\/~-$%^ ,''*.','a'));
175: l_VENDOR_NUMBER po_vendors.segment1%TYPE;
176: l_VENDOR_ID po_vendors.vendor_id%TYPE;
177: l_VENDOR_NAME po_vendors.vendor_name%TYPE;
178: l_NEW_NAME po_vendors.vendor_name%TYPE;
179: l_SUBSTR_NEW_NAME po_vendors.vendor_name%TYPE;
180: BEGIN

Line 177: l_VENDOR_NAME po_vendors.vendor_name%TYPE;

173: ORDER BY upper(translate(vendor_name,
174: 'a!@#\/~-$%^ ,''*.','a'));
175: l_VENDOR_NUMBER po_vendors.segment1%TYPE;
176: l_VENDOR_ID po_vendors.vendor_id%TYPE;
177: l_VENDOR_NAME po_vendors.vendor_name%TYPE;
178: l_NEW_NAME po_vendors.vendor_name%TYPE;
179: l_SUBSTR_NEW_NAME po_vendors.vendor_name%TYPE;
180: BEGIN
181: FOR one_active_vendor IN c1 LOOP

Line 178: l_NEW_NAME po_vendors.vendor_name%TYPE;

174: 'a!@#\/~-$%^ ,''*.','a'));
175: l_VENDOR_NUMBER po_vendors.segment1%TYPE;
176: l_VENDOR_ID po_vendors.vendor_id%TYPE;
177: l_VENDOR_NAME po_vendors.vendor_name%TYPE;
178: l_NEW_NAME po_vendors.vendor_name%TYPE;
179: l_SUBSTR_NEW_NAME po_vendors.vendor_name%TYPE;
180: BEGIN
181: FOR one_active_vendor IN c1 LOOP
182: l_VENDOR_NUMBER := one_active_vendor.vendor_number;

Line 179: l_SUBSTR_NEW_NAME po_vendors.vendor_name%TYPE;

175: l_VENDOR_NUMBER po_vendors.segment1%TYPE;
176: l_VENDOR_ID po_vendors.vendor_id%TYPE;
177: l_VENDOR_NAME po_vendors.vendor_name%TYPE;
178: l_NEW_NAME po_vendors.vendor_name%TYPE;
179: l_SUBSTR_NEW_NAME po_vendors.vendor_name%TYPE;
180: BEGIN
181: FOR one_active_vendor IN c1 LOOP
182: l_VENDOR_NUMBER := one_active_vendor.vendor_number;
183: l_VENDOR_ID := one_active_vendor.vendor_id;