APPS.AP_VENDOR_PUB_PKG dependencies on AP_DISTRIBUTION_SETS_ALL

Line 1223: l_dist_id AP_DISTRIBUTION_SETS_ALL.distribution_set_id%TYPE;

1219: p_default_dist_id IN NUMBER,
1220: x_valid OUT NOCOPY BOOLEAN
1221: ) IS
1222:
1223: l_dist_id AP_DISTRIBUTION_SETS_ALL.distribution_set_id%TYPE;
1224: l_dist_name AP_DISTRIBUTION_SETS_ALL.distribution_set_name%TYPE;
1225:
1226: BEGIN
1227: x_valid := TRUE;

Line 1224: l_dist_name AP_DISTRIBUTION_SETS_ALL.distribution_set_name%TYPE;

1220: x_valid OUT NOCOPY BOOLEAN
1221: ) IS
1222:
1223: l_dist_id AP_DISTRIBUTION_SETS_ALL.distribution_set_id%TYPE;
1224: l_dist_name AP_DISTRIBUTION_SETS_ALL.distribution_set_name%TYPE;
1225:
1226: BEGIN
1227: x_valid := TRUE;
1228:

Line 1237: FROM AP_DISTRIBUTION_SETS_ALL

1233: ELSIF p_dist_id is NOT NULL and p_dist_name is NOT NULL THEN
1234: BEGIN
1235: SELECT distribution_set_id
1236: INTO l_dist_id
1237: FROM AP_DISTRIBUTION_SETS_ALL
1238: WHERE distribution_set_id = p_dist_id
1239: AND distribution_set_name = p_dist_name
1240: AND sysdate < nvl(inactive_date, sysdate+1);
1241:

Line 1257: FROM AP_DISTRIBUTION_SETS_ALL

1253: ELSIF p_dist_id is NULL and p_dist_name is NOT NULL THEN
1254: BEGIN
1255: SELECT distribution_set_id
1256: INTO p_dist_id
1257: FROM AP_DISTRIBUTION_SETS_ALL
1258: WHERE distribution_set_name = p_dist_name
1259: AND sysdate < nvl(inactive_date, sysdate+1);
1260:
1261: EXCEPTION

Line 1275: FROM AP_DISTRIBUTION_SETS_ALL

1271: ELSIF p_dist_id is NOT NULL and p_dist_name is NULL THEN
1272: BEGIN
1273: SELECT distribution_set_name
1274: INTO l_dist_name
1275: FROM AP_DISTRIBUTION_SETS_ALL
1276: WHERE distribution_set_id = p_dist_id
1277: AND sysdate < nvl(inactive_date, sysdate+1);
1278:
1279: EXCEPTION