DBA Data[Home] [Help]

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 5803: 'AP_LOOKUP_CODES',x_valid);

5799: AND p_vendor_rec.terms_date_basis <> ap_null_char THEN
5800:
5801: Validate_Lookups( 'TERMS_DATE_BASIS',
5802: p_vendor_rec.terms_date_basis,'TERMS DATE BASIS',
5803: 'AP_LOOKUP_CODES',x_valid);
5804: IF NOT x_valid THEN
5805: x_return_status := FND_API.G_RET_STS_ERROR;
5806: IF g_source = 'IMPORT' THEN
5807: IF (Insert_Rejections(

Line 10462: 'AP_LOOKUP_CODES',x_valid);

10458: --
10459: IF p_vendor_site_rec.terms_date_basis is NOT NULL THEN
10460:
10461: Validate_Lookups( 'TERMS_DATE_BASIS',p_vendor_site_rec.terms_date_basis,'TERMS DATE BASIS',
10462: 'AP_LOOKUP_CODES',x_valid);
10463: IF NOT x_valid THEN
10464: x_return_status := FND_API.G_RET_STS_ERROR;
10465: IF g_source = 'IMPORT' THEN
10466: IF (Insert_Rejections(