APPS.AP_VENDOR_PUB_PKG dependencies on AP_TOLERANCE_TEMPLATES

Line 2504: l_tolerance_id AP_TOLERANCE_TEMPLATES.tolerance_id%TYPE;

2500: x_valid OUT NOCOPY BOOLEAN,
2501: p_tolerance_type IN VARCHAR2
2502: ) IS
2503:
2504: l_tolerance_id AP_TOLERANCE_TEMPLATES.tolerance_id%TYPE;
2505: l_tolerance_name AP_TOLERANCE_TEMPLATES.tolerance_name%TYPE;
2506: l_default_tolerance AP_TOLERANCE_TEMPLATES.tolerance_id%TYPE;
2507:
2508: BEGIN

Line 2505: l_tolerance_name AP_TOLERANCE_TEMPLATES.tolerance_name%TYPE;

2501: p_tolerance_type IN VARCHAR2
2502: ) IS
2503:
2504: l_tolerance_id AP_TOLERANCE_TEMPLATES.tolerance_id%TYPE;
2505: l_tolerance_name AP_TOLERANCE_TEMPLATES.tolerance_name%TYPE;
2506: l_default_tolerance AP_TOLERANCE_TEMPLATES.tolerance_id%TYPE;
2507:
2508: BEGIN
2509: x_valid := TRUE;

Line 2506: l_default_tolerance AP_TOLERANCE_TEMPLATES.tolerance_id%TYPE;

2502: ) IS
2503:
2504: l_tolerance_id AP_TOLERANCE_TEMPLATES.tolerance_id%TYPE;
2505: l_tolerance_name AP_TOLERANCE_TEMPLATES.tolerance_name%TYPE;
2506: l_default_tolerance AP_TOLERANCE_TEMPLATES.tolerance_id%TYPE;
2507:
2508: BEGIN
2509: x_valid := TRUE;
2510:

Line 2562: FROM AP_TOLERANCE_TEMPLATES

2558: ELSIF (p_tolerance_id is NOT NULL and p_tolerance_name is NULL) THEN
2559: BEGIN
2560: SELECT tolerance_name
2561: INTO l_tolerance_name
2562: FROM AP_TOLERANCE_TEMPLATES
2563: WHERE tolerance_id = p_tolerance_id;
2564:
2565: EXCEPTION
2566: -- Trap validation error

Line 2585: FROM AP_TOLERANCE_TEMPLATES

2581: ELSIF (p_tolerance_id is NOT NULL and p_tolerance_name is NOT NULL) THEN
2582: BEGIN
2583: SELECT tolerance_id
2584: INTO l_tolerance_id
2585: FROM AP_TOLERANCE_TEMPLATES
2586: WHERE tolerance_id = p_tolerance_id
2587: AND tolerance_name = p_tolerance_name;
2588:
2589: EXCEPTION

Line 2611: FROM AP_TOLERANCE_TEMPLATES

2607: ELSIF (p_tolerance_id is NULL and p_tolerance_name is NOT NULL) THEN
2608: BEGIN
2609: SELECT tolerance_id
2610: INTO p_tolerance_id
2611: FROM AP_TOLERANCE_TEMPLATES
2612: WHERE tolerance_name = p_tolerance_name;
2613:
2614: EXCEPTION
2615: -- Trap validation error