APPS.AP_VENDOR_PUB_PKG dependencies on AP_DISTRIBUTION_SETS_ALL

Line 1491: l_dist_id AP_DISTRIBUTION_SETS_ALL.distribution_set_id%TYPE;

1487: p_default_dist_id IN NUMBER,
1488: x_valid OUT NOCOPY BOOLEAN
1489: ) IS
1490:
1491: l_dist_id AP_DISTRIBUTION_SETS_ALL.distribution_set_id%TYPE;
1492: l_dist_name AP_DISTRIBUTION_SETS_ALL.distribution_set_name%TYPE;
1493:
1494: BEGIN
1495: x_valid := TRUE;

Line 1492: l_dist_name AP_DISTRIBUTION_SETS_ALL.distribution_set_name%TYPE;

1488: x_valid OUT NOCOPY BOOLEAN
1489: ) IS
1490:
1491: l_dist_id AP_DISTRIBUTION_SETS_ALL.distribution_set_id%TYPE;
1492: l_dist_name AP_DISTRIBUTION_SETS_ALL.distribution_set_name%TYPE;
1493:
1494: BEGIN
1495: x_valid := TRUE;
1496:

Line 1505: FROM AP_DISTRIBUTION_SETS_ALL

1501: ELSIF p_dist_id is NOT NULL and p_dist_name is NOT NULL THEN
1502: BEGIN
1503: SELECT distribution_set_id
1504: INTO l_dist_id
1505: FROM AP_DISTRIBUTION_SETS_ALL
1506: WHERE distribution_set_id = p_dist_id
1507: AND distribution_set_name = p_dist_name
1508: AND sysdate < nvl(inactive_date, sysdate+1);
1509:

Line 1525: FROM AP_DISTRIBUTION_SETS_ALL

1521: ELSIF p_dist_id is NULL and p_dist_name is NOT NULL THEN
1522: BEGIN
1523: SELECT distribution_set_id
1524: INTO p_dist_id
1525: FROM AP_DISTRIBUTION_SETS_ALL
1526: WHERE distribution_set_name = p_dist_name
1527: AND sysdate < nvl(inactive_date, sysdate+1);
1528:
1529: EXCEPTION

Line 1543: FROM AP_DISTRIBUTION_SETS_ALL

1539: ELSIF p_dist_id is NOT NULL and p_dist_name is NULL THEN
1540: BEGIN
1541: SELECT distribution_set_name
1542: INTO l_dist_name
1543: FROM AP_DISTRIBUTION_SETS_ALL
1544: WHERE distribution_set_id = p_dist_id
1545: AND sysdate < nvl(inactive_date, sysdate+1);
1546:
1547: EXCEPTION