APPS.AP_VENDOR_PUB_PKG dependencies on AP_TERMS_TL

Line 1410: l_terms_id AP_TERMS_TL.term_id%TYPE;

1406: p_default_terms_id IN NUMBER,
1407: x_valid OUT NOCOPY BOOLEAN
1408: ) IS
1409:
1410: l_terms_id AP_TERMS_TL.term_id%TYPE;
1411: l_terms_name AP_TERMS_TL.name%TYPE;
1412:
1413: BEGIN
1414: x_valid := TRUE;

Line 1411: l_terms_name AP_TERMS_TL.name%TYPE;

1407: x_valid OUT NOCOPY BOOLEAN
1408: ) IS
1409:
1410: l_terms_id AP_TERMS_TL.term_id%TYPE;
1411: l_terms_name AP_TERMS_TL.name%TYPE;
1412:
1413: BEGIN
1414: x_valid := TRUE;
1415:

Line 1423: FROM AP_TERMS_TL

1419: ELSIF (p_terms_id is NOT NULL and p_terms_name is NULL) THEN
1420: BEGIN
1421: SELECT name
1422: INTO l_terms_name
1423: FROM AP_TERMS_TL
1424: WHERE term_id = p_terms_id
1425: AND language = userenv('LANG')
1426: AND sysdate < nvl(end_date_active, sysdate+1);
1427:

Line 1442: FROM AP_TERMS_TL

1438: ELSIF (p_terms_id is NOT NULL and p_terms_name is NOT NULL) THEN
1439: BEGIN
1440: SELECT term_id
1441: INTO l_terms_id
1442: FROM AP_TERMS_TL
1443: WHERE term_id = p_terms_id
1444: AND name = p_terms_name
1445: AND language = userenv('LANG')
1446: AND sysdate < nvl(end_date_active, sysdate+1);

Line 1463: FROM AP_TERMS_TL

1459: ELSIF (p_terms_id is NULL and p_terms_name is NOT NULL) THEN
1460: BEGIN
1461: SELECT term_id
1462: INTO p_terms_id
1463: FROM AP_TERMS_TL
1464: WHERE name = p_terms_name
1465: AND language = userenv('LANG')
1466: AND sysdate < nvl(end_date_active, sysdate+1);
1467: