APPS.AP_VENDOR_PUB_PKG dependencies on AP_PRODUCT_SETUP

Line 836: FROM ap_product_setup;

832: x_valid := TRUE;
833: --sally
834: SELECT supplier_numbering_method
835: INTO l_ven_num_code
836: FROM ap_product_setup;
837:
838: IF ((NVL(l_ven_num_code, 'MANUAL') = 'MANUAL') AND
839: (p_segment1 is Null)) THEN
840: x_valid := FALSE;

Line 944: l_ven_num_code ap_product_setup.SUPPLIER_NUMBERING_METHOD%TYPE;

940: PROCEDURE Check_valid_vendor_num(p_segment1 IN VARCHAR2,
941: x_valid OUT NOCOPY BOOLEAN
942: ) IS
943:
944: l_ven_num_code ap_product_setup.SUPPLIER_NUMBERING_METHOD%TYPE;
945:
946: BEGIN
947:
948: /*Open Issue 11 -- This select needs to be adjusted for MOAC*/

Line 951: FROM ap_product_setup;

947:
948: /*Open Issue 11 -- This select needs to be adjusted for MOAC*/
949: SELECT nvl(supplier_numbering_method, 'MANUAL')
950: INTO l_ven_num_code
951: FROM ap_product_setup;
952:
953: IF ((l_ven_num_code = 'MANUAL') and (p_segment1 is NULL)) THEN
954:
955: x_valid := FALSE;