APPS.AP_VENDOR_PUB_PKG dependencies on AP_TERMS_TL

Line 1142: l_terms_id AP_TERMS_TL.term_id%TYPE;

1138: p_default_terms_id IN NUMBER,
1139: x_valid OUT NOCOPY BOOLEAN
1140: ) IS
1141:
1142: l_terms_id AP_TERMS_TL.term_id%TYPE;
1143: l_terms_name AP_TERMS_TL.name%TYPE;
1144:
1145: BEGIN
1146: x_valid := TRUE;

Line 1143: l_terms_name AP_TERMS_TL.name%TYPE;

1139: x_valid OUT NOCOPY BOOLEAN
1140: ) IS
1141:
1142: l_terms_id AP_TERMS_TL.term_id%TYPE;
1143: l_terms_name AP_TERMS_TL.name%TYPE;
1144:
1145: BEGIN
1146: x_valid := TRUE;
1147:

Line 1155: FROM AP_TERMS_TL

1151: ELSIF (p_terms_id is NOT NULL and p_terms_name is NULL) THEN
1152: BEGIN
1153: SELECT name
1154: INTO l_terms_name
1155: FROM AP_TERMS_TL
1156: WHERE term_id = p_terms_id
1157: AND language = userenv('LANG')
1158: AND sysdate < nvl(end_date_active, sysdate+1);
1159:

Line 1174: FROM AP_TERMS_TL

1170: ELSIF (p_terms_id is NOT NULL and p_terms_name is NOT NULL) THEN
1171: BEGIN
1172: SELECT term_id
1173: INTO l_terms_id
1174: FROM AP_TERMS_TL
1175: WHERE term_id = p_terms_id
1176: AND name = p_terms_name
1177: AND language = userenv('LANG')
1178: AND sysdate < nvl(end_date_active, sysdate+1);

Line 1195: FROM AP_TERMS_TL

1191: ELSIF (p_terms_id is NULL and p_terms_name is NOT NULL) THEN
1192: BEGIN
1193: SELECT term_id
1194: INTO p_terms_id
1195: FROM AP_TERMS_TL
1196: WHERE name = p_terms_name
1197: AND language = userenv('LANG')
1198: AND sysdate < nvl(end_date_active, sysdate+1);
1199: