APPS.AP_VENDOR_PUB_PKG dependencies on AP_AWT_GROUPS

Line 1187: l_dummy_id AP_AWT_GROUPS.group_id%TYPE;

1183: p_allow_awt_flag IN VARCHAR2,
1184: x_valid OUT NOCOPY BOOLEAN
1185: ) IS
1186:
1187: l_dummy_id AP_AWT_GROUPS.group_id%TYPE;
1188: l_dummy_name AP_AWT_GROUPS.name%TYPE;
1189:
1190: BEGIN
1191: x_valid := TRUE;

Line 1188: l_dummy_name AP_AWT_GROUPS.name%TYPE;

1184: x_valid OUT NOCOPY BOOLEAN
1185: ) IS
1186:
1187: l_dummy_id AP_AWT_GROUPS.group_id%TYPE;
1188: l_dummy_name AP_AWT_GROUPS.name%TYPE;
1189:
1190: BEGIN
1191: x_valid := TRUE;
1192:

Line 1218: FROM AP_AWT_GROUPS

1214: BEGIN
1215:
1216: SELECT name
1217: INTO l_dummy_name
1218: FROM AP_AWT_GROUPS
1219: WHERE group_id = p_awt_id
1220: AND sysdate < nvl(inactive_date, sysdate + 1);
1221:
1222: EXCEPTION

Line 1236: FROM AP_AWT_GROUPS

1232: BEGIN
1233:
1234: SELECT group_id
1235: INTO l_dummy_id
1236: FROM AP_AWT_GROUPS
1237: WHERE group_id = p_awt_id
1238: AND name = p_awt_name
1239: AND sysdate < nvl(inactive_date, sysdate + 1);
1240:

Line 1256: FROM AP_AWT_GROUPS

1252: BEGIN
1253:
1254: SELECT group_id
1255: INTO p_awt_id
1256: FROM AP_AWT_GROUPS
1257: WHERE name = p_awt_name
1258: AND sysdate < nvl(inactive_date, sysdate + 1);
1259:
1260: EXCEPTION

Line 1285: l_dummy_id AP_AWT_GROUPS.group_id%TYPE;

1281: p_allow_awt_flag IN VARCHAR2,
1282: x_valid OUT NOCOPY BOOLEAN
1283: ) IS
1284:
1285: l_dummy_id AP_AWT_GROUPS.group_id%TYPE;
1286: l_dummy_name AP_AWT_GROUPS.name%TYPE;
1287:
1288: BEGIN
1289:

Line 1286: l_dummy_name AP_AWT_GROUPS.name%TYPE;

1282: x_valid OUT NOCOPY BOOLEAN
1283: ) IS
1284:
1285: l_dummy_id AP_AWT_GROUPS.group_id%TYPE;
1286: l_dummy_name AP_AWT_GROUPS.name%TYPE;
1287:
1288: BEGIN
1289:
1290:

Line 1319: FROM AP_AWT_GROUPS

1315: BEGIN
1316:
1317: SELECT name
1318: INTO l_dummy_name
1319: FROM AP_AWT_GROUPS
1320: WHERE group_id = p_pay_awt_id
1321: AND sysdate < nvl(inactive_date, sysdate + 1);
1322:
1323: EXCEPTION

Line 1337: FROM AP_AWT_GROUPS

1333: BEGIN
1334:
1335: SELECT group_id
1336: INTO l_dummy_id
1337: FROM AP_AWT_GROUPS
1338: WHERE group_id = p_pay_awt_id
1339: AND name = p_pay_awt_name
1340: AND sysdate < nvl(inactive_date, sysdate + 1);
1341:

Line 1357: FROM AP_AWT_GROUPS

1353: BEGIN
1354:
1355: SELECT group_id
1356: INTO p_pay_awt_id
1357: FROM AP_AWT_GROUPS
1358: WHERE name = p_pay_awt_name
1359: AND sysdate < nvl(inactive_date, sysdate + 1);
1360:
1361: EXCEPTION