APPS.AP_VENDOR_PUB_PKG dependencies on AP_TOLERANCE_TEMPLATES

Line 2193: l_tolerance_id AP_TOLERANCE_TEMPLATES.tolerance_id%TYPE;

2189: x_valid OUT NOCOPY BOOLEAN,
2190: p_tolerance_type IN VARCHAR2
2191: ) IS
2192:
2193: l_tolerance_id AP_TOLERANCE_TEMPLATES.tolerance_id%TYPE;
2194: l_tolerance_name AP_TOLERANCE_TEMPLATES.tolerance_name%TYPE;
2195: l_default_tolerance AP_TOLERANCE_TEMPLATES.tolerance_id%TYPE;
2196:
2197: BEGIN

Line 2194: l_tolerance_name AP_TOLERANCE_TEMPLATES.tolerance_name%TYPE;

2190: p_tolerance_type IN VARCHAR2
2191: ) IS
2192:
2193: l_tolerance_id AP_TOLERANCE_TEMPLATES.tolerance_id%TYPE;
2194: l_tolerance_name AP_TOLERANCE_TEMPLATES.tolerance_name%TYPE;
2195: l_default_tolerance AP_TOLERANCE_TEMPLATES.tolerance_id%TYPE;
2196:
2197: BEGIN
2198: x_valid := TRUE;

Line 2195: l_default_tolerance AP_TOLERANCE_TEMPLATES.tolerance_id%TYPE;

2191: ) IS
2192:
2193: l_tolerance_id AP_TOLERANCE_TEMPLATES.tolerance_id%TYPE;
2194: l_tolerance_name AP_TOLERANCE_TEMPLATES.tolerance_name%TYPE;
2195: l_default_tolerance AP_TOLERANCE_TEMPLATES.tolerance_id%TYPE;
2196:
2197: BEGIN
2198: x_valid := TRUE;
2199:

Line 2251: FROM AP_TOLERANCE_TEMPLATES

2247: ELSIF (p_tolerance_id is NOT NULL and p_tolerance_name is NULL) THEN
2248: BEGIN
2249: SELECT tolerance_name
2250: INTO l_tolerance_name
2251: FROM AP_TOLERANCE_TEMPLATES
2252: WHERE tolerance_id = p_tolerance_id;
2253:
2254: EXCEPTION
2255: -- Trap validation error

Line 2274: FROM AP_TOLERANCE_TEMPLATES

2270: ELSIF (p_tolerance_id is NOT NULL and p_tolerance_name is NOT NULL) THEN
2271: BEGIN
2272: SELECT tolerance_id
2273: INTO l_tolerance_id
2274: FROM AP_TOLERANCE_TEMPLATES
2275: WHERE tolerance_id = p_tolerance_id
2276: AND tolerance_name = p_tolerance_name;
2277:
2278: EXCEPTION

Line 2300: FROM AP_TOLERANCE_TEMPLATES

2296: ELSIF (p_tolerance_id is NULL and p_tolerance_name is NOT NULL) THEN
2297: BEGIN
2298: SELECT tolerance_id
2299: INTO p_tolerance_id
2300: FROM AP_TOLERANCE_TEMPLATES
2301: WHERE tolerance_name = p_tolerance_name;
2302:
2303: EXCEPTION
2304: -- Trap validation error