APPS.GMI_VALID_GRP dependencies on IC_COST_CLS

Line 1472: --| on ic_cost_cls |

1468: --| Validates itemcost_class |
1469: --| |
1470: --| DESCRIPTION |
1471: --| This function validates that the Item Cost Class exists |
1472: --| on ic_cost_cls |
1473: --| |
1474: --| PARAMETERS |
1475: --| p_itemcost_class class IN VARCHAR2(8) - Item Cost Class |
1476: --| |

Line 1492: CURSOR ic_cost_cls_c1 IS

1488: )
1489: RETURN BOOLEAN
1490: IS
1491: l_itemcost_class ic_item_mst.itemcost_class%TYPE;
1492: CURSOR ic_cost_cls_c1 IS
1493: SELECT
1494: itemcost_class
1495: FROM
1496: ic_cost_cls

Line 1496: ic_cost_cls

1492: CURSOR ic_cost_cls_c1 IS
1493: SELECT
1494: itemcost_class
1495: FROM
1496: ic_cost_cls
1497: WHERE
1498: ic_cost_cls.itemcost_class = p_itemcost_class
1499: AND ic_cost_cls.delete_mark = 0;
1500:

Line 1498: ic_cost_cls.itemcost_class = p_itemcost_class

1494: itemcost_class
1495: FROM
1496: ic_cost_cls
1497: WHERE
1498: ic_cost_cls.itemcost_class = p_itemcost_class
1499: AND ic_cost_cls.delete_mark = 0;
1500:
1501: BEGIN
1502:

Line 1499: AND ic_cost_cls.delete_mark = 0;

1495: FROM
1496: ic_cost_cls
1497: WHERE
1498: ic_cost_cls.itemcost_class = p_itemcost_class
1499: AND ic_cost_cls.delete_mark = 0;
1500:
1501: BEGIN
1502:
1503: OPEN ic_cost_cls_c1;

Line 1503: OPEN ic_cost_cls_c1;

1499: AND ic_cost_cls.delete_mark = 0;
1500:
1501: BEGIN
1502:
1503: OPEN ic_cost_cls_c1;
1504: FETCH ic_cost_cls_c1 INTO l_itemcost_class;
1505: IF (ic_cost_cls_c1%NOTFOUND) THEN
1506: CLOSE ic_cost_cls_c1;
1507: RETURN FALSE;

Line 1504: FETCH ic_cost_cls_c1 INTO l_itemcost_class;

1500:
1501: BEGIN
1502:
1503: OPEN ic_cost_cls_c1;
1504: FETCH ic_cost_cls_c1 INTO l_itemcost_class;
1505: IF (ic_cost_cls_c1%NOTFOUND) THEN
1506: CLOSE ic_cost_cls_c1;
1507: RETURN FALSE;
1508: ELSE

Line 1505: IF (ic_cost_cls_c1%NOTFOUND) THEN

1501: BEGIN
1502:
1503: OPEN ic_cost_cls_c1;
1504: FETCH ic_cost_cls_c1 INTO l_itemcost_class;
1505: IF (ic_cost_cls_c1%NOTFOUND) THEN
1506: CLOSE ic_cost_cls_c1;
1507: RETURN FALSE;
1508: ELSE
1509: CLOSE ic_cost_cls_c1;

Line 1506: CLOSE ic_cost_cls_c1;

1502:
1503: OPEN ic_cost_cls_c1;
1504: FETCH ic_cost_cls_c1 INTO l_itemcost_class;
1505: IF (ic_cost_cls_c1%NOTFOUND) THEN
1506: CLOSE ic_cost_cls_c1;
1507: RETURN FALSE;
1508: ELSE
1509: CLOSE ic_cost_cls_c1;
1510: RETURN TRUE;

Line 1509: CLOSE ic_cost_cls_c1;

1505: IF (ic_cost_cls_c1%NOTFOUND) THEN
1506: CLOSE ic_cost_cls_c1;
1507: RETURN FALSE;
1508: ELSE
1509: CLOSE ic_cost_cls_c1;
1510: RETURN TRUE;
1511: END IF;
1512:
1513: EXCEPTION