APPS.GMI_VALID_GRP dependencies on IC_ALLC_CLS

Line 1356: --| on ic_allc_cls |

1352: --| Validates alloc_class |
1353: --| |
1354: --| DESCRIPTION |
1355: --| This function validates that the Allocation Class exists |
1356: --| on ic_allc_cls |
1357: --| |
1358: --| PARAMETERS |
1359: --| p_alloc_class IN VARCHAR2(8) - Allocation Clas |
1360: --| |

Line 1376: CURSOR ic_allc_cls_c1 IS

1372: )
1373: RETURN BOOLEAN
1374: IS
1375: l_alloc_class ic_item_mst.alloc_class%TYPE;
1376: CURSOR ic_allc_cls_c1 IS
1377: SELECT
1378: alloc_class
1379: FROM
1380: ic_allc_cls

Line 1380: ic_allc_cls

1376: CURSOR ic_allc_cls_c1 IS
1377: SELECT
1378: alloc_class
1379: FROM
1380: ic_allc_cls
1381: WHERE
1382: ic_allc_cls.alloc_class = p_alloc_class
1383: AND ic_allc_cls.delete_mark = 0;
1384:

Line 1382: ic_allc_cls.alloc_class = p_alloc_class

1378: alloc_class
1379: FROM
1380: ic_allc_cls
1381: WHERE
1382: ic_allc_cls.alloc_class = p_alloc_class
1383: AND ic_allc_cls.delete_mark = 0;
1384:
1385: BEGIN
1386:

Line 1383: AND ic_allc_cls.delete_mark = 0;

1379: FROM
1380: ic_allc_cls
1381: WHERE
1382: ic_allc_cls.alloc_class = p_alloc_class
1383: AND ic_allc_cls.delete_mark = 0;
1384:
1385: BEGIN
1386:
1387: OPEN ic_allc_cls_c1;

Line 1387: OPEN ic_allc_cls_c1;

1383: AND ic_allc_cls.delete_mark = 0;
1384:
1385: BEGIN
1386:
1387: OPEN ic_allc_cls_c1;
1388: FETCH ic_allc_cls_c1 INTO l_alloc_class;
1389: IF (ic_allc_cls_c1%NOTFOUND)
1390: THEN
1391: CLOSE ic_allc_cls_c1;

Line 1388: FETCH ic_allc_cls_c1 INTO l_alloc_class;

1384:
1385: BEGIN
1386:
1387: OPEN ic_allc_cls_c1;
1388: FETCH ic_allc_cls_c1 INTO l_alloc_class;
1389: IF (ic_allc_cls_c1%NOTFOUND)
1390: THEN
1391: CLOSE ic_allc_cls_c1;
1392: RETURN FALSE;

Line 1389: IF (ic_allc_cls_c1%NOTFOUND)

1385: BEGIN
1386:
1387: OPEN ic_allc_cls_c1;
1388: FETCH ic_allc_cls_c1 INTO l_alloc_class;
1389: IF (ic_allc_cls_c1%NOTFOUND)
1390: THEN
1391: CLOSE ic_allc_cls_c1;
1392: RETURN FALSE;
1393: ELSE

Line 1391: CLOSE ic_allc_cls_c1;

1387: OPEN ic_allc_cls_c1;
1388: FETCH ic_allc_cls_c1 INTO l_alloc_class;
1389: IF (ic_allc_cls_c1%NOTFOUND)
1390: THEN
1391: CLOSE ic_allc_cls_c1;
1392: RETURN FALSE;
1393: ELSE
1394: CLOSE ic_allc_cls_c1;
1395: RETURN TRUE;

Line 1394: CLOSE ic_allc_cls_c1;

1390: THEN
1391: CLOSE ic_allc_cls_c1;
1392: RETURN FALSE;
1393: ELSE
1394: CLOSE ic_allc_cls_c1;
1395: RETURN TRUE;
1396: END IF;
1397:
1398: EXCEPTION