APPS.AP_VENDOR_PUB_PKG dependencies on AP_LOOKUP_CODES

Line 148: IF p_lookup_table = 'AP_LOOKUP_CODES' THEN

144:
145: BEGIN
146: x_valid := TRUE;
147:
148: IF p_lookup_table = 'AP_LOOKUP_CODES' THEN
149:
150: Begin
151: SELECT lookup_code
152: INTO l_dummy_lookup

Line 153: FROM ap_lookup_codes

149:
150: Begin
151: SELECT lookup_code
152: INTO l_dummy_lookup
153: FROM ap_lookup_codes
154: WHERE lookup_type = p_lookup_type
155: AND lookup_code = p_column_value
156: AND enabled_flag = 'Y'
157: AND nvl(inactive_date,sysdate+1) > sysdate;

Line 6556: 'AP_LOOKUP_CODES',x_valid);

6552: AND p_vendor_rec.terms_date_basis <> ap_null_char THEN
6553:
6554: Validate_Lookups( 'TERMS_DATE_BASIS',
6555: p_vendor_rec.terms_date_basis,'TERMS DATE BASIS',
6556: 'AP_LOOKUP_CODES',x_valid);
6557: IF NOT x_valid THEN
6558: x_return_status := FND_API.G_RET_STS_ERROR;
6559: IF g_source = 'IMPORT' THEN
6560: IF (Insert_Rejections(

Line 11179: ,'AP_LOOKUP_CODES'

11175: ) THEN
11176: validate_lookups('SMALL_BUSINESS_CODE'
11177: ,p_vendor_site_rec.small_business_code
11178: ,'SMALL_NOT_SMALL_BUSINESS_CODE'
11179: ,'AP_LOOKUP_CODES'
11180: ,x_valid);
11181: IF (NOT x_valid) THEN
11182: x_return_status := FND_API.G_RET_STS_ERROR;
11183: IF g_source = 'IMPORT' THEN

Line 12539: 'AP_LOOKUP_CODES',x_valid);

12535: --
12536: IF p_vendor_site_rec.terms_date_basis is NOT NULL THEN
12537:
12538: Validate_Lookups( 'TERMS_DATE_BASIS',p_vendor_site_rec.terms_date_basis,'TERMS DATE BASIS',
12539: 'AP_LOOKUP_CODES',x_valid);
12540: IF NOT x_valid THEN
12541: x_return_status := FND_API.G_RET_STS_ERROR;
12542: IF g_source = 'IMPORT' THEN
12543: IF (Insert_Rejections(