APPS.AP_VENDOR_PUB_PKG dependencies on AP_PRODUCT_SETUP

Line 1004: FROM ap_product_setup;

1000: x_valid := TRUE;
1001: --sally
1002: SELECT supplier_numbering_method
1003: INTO l_ven_num_code
1004: FROM ap_product_setup;
1005:
1006: IF ((NVL(l_ven_num_code, 'MANUAL') = 'MANUAL') AND
1007: (p_segment1 is Null)) THEN
1008: x_valid := FALSE;

Line 1112: l_ven_num_code ap_product_setup.SUPPLIER_NUMBERING_METHOD%TYPE;

1108: PROCEDURE Check_valid_vendor_num(p_segment1 IN VARCHAR2,
1109: x_valid OUT NOCOPY BOOLEAN
1110: ) IS
1111:
1112: l_ven_num_code ap_product_setup.SUPPLIER_NUMBERING_METHOD%TYPE;
1113:
1114: BEGIN
1115:
1116: /*Open Issue 11 -- This select needs to be adjusted for MOAC*/

Line 1119: FROM ap_product_setup;

1115:
1116: /*Open Issue 11 -- This select needs to be adjusted for MOAC*/
1117: SELECT nvl(supplier_numbering_method, 'MANUAL')
1118: INTO l_ven_num_code
1119: FROM ap_product_setup;
1120:
1121: IF ((l_ven_num_code = 'MANUAL') and (p_segment1 is NULL)) THEN
1122:
1123: x_valid := FALSE;

Line 8255: ap_product_setup aps -- Bug 8200984

8251: , l_sup_awt_flag
8252: ,l_create_debit_memo_flag --Bug8373166
8253: FROM po_vendors pv,
8254: ap_system_parameters_all asp,
8255: ap_product_setup aps -- Bug 8200984
8256: WHERE pv.vendor_id = p_vendor_site_rec.vendor_id
8257: AND asp.org_id=l_def_org_id;
8258:
8259: l_last_updated_by := fnd_global.user_id;