APPS.GMI_VALID_GRP dependencies on IC_LOTS_STS

Line 1745: --| This function validates that Lot Status exists on ic_lots_sts |

1741: --| USAGE |
1742: --| Validates lot_status |
1743: --| |
1744: --| DESCRIPTION |
1745: --| This function validates that Lot Status exists on ic_lots_sts |
1746: --| and is not blank if status_ctl = 1 |
1747: --| |
1748: --| PARAMETERS |
1749: --| p_lot_status IN VARCHAR2(4) - Lot Status Code |

Line 1767: CURSOR ic_lots_sts_c1 IS

1763: )
1764: RETURN BOOLEAN
1765: IS
1766: l_lot_status ic_item_mst.lot_status%TYPE;
1767: CURSOR ic_lots_sts_c1 IS
1768: SELECT
1769: lot_status
1770: FROM
1771: ic_lots_sts

Line 1771: ic_lots_sts

1767: CURSOR ic_lots_sts_c1 IS
1768: SELECT
1769: lot_status
1770: FROM
1771: ic_lots_sts
1772: WHERE
1773: ic_lots_sts.lot_status = p_lot_status
1774: AND ic_lots_sts.delete_mark = 0;
1775:

Line 1773: ic_lots_sts.lot_status = p_lot_status

1769: lot_status
1770: FROM
1771: ic_lots_sts
1772: WHERE
1773: ic_lots_sts.lot_status = p_lot_status
1774: AND ic_lots_sts.delete_mark = 0;
1775:
1776: BEGIN
1777:

Line 1774: AND ic_lots_sts.delete_mark = 0;

1770: FROM
1771: ic_lots_sts
1772: WHERE
1773: ic_lots_sts.lot_status = p_lot_status
1774: AND ic_lots_sts.delete_mark = 0;
1775:
1776: BEGIN
1777:
1778: IF (p_status_ctl = 0)

Line 1788: OPEN ic_lots_sts_c1;

1784: THEN
1785: RETURN FALSE;
1786: END IF;
1787:
1788: OPEN ic_lots_sts_c1;
1789: FETCH ic_lots_sts_c1 INTO l_lot_status;
1790: IF (ic_lots_sts_c1%NOTFOUND)
1791: THEN
1792: CLOSE ic_lots_sts_c1;

Line 1789: FETCH ic_lots_sts_c1 INTO l_lot_status;

1785: RETURN FALSE;
1786: END IF;
1787:
1788: OPEN ic_lots_sts_c1;
1789: FETCH ic_lots_sts_c1 INTO l_lot_status;
1790: IF (ic_lots_sts_c1%NOTFOUND)
1791: THEN
1792: CLOSE ic_lots_sts_c1;
1793: RETURN FALSE;

Line 1790: IF (ic_lots_sts_c1%NOTFOUND)

1786: END IF;
1787:
1788: OPEN ic_lots_sts_c1;
1789: FETCH ic_lots_sts_c1 INTO l_lot_status;
1790: IF (ic_lots_sts_c1%NOTFOUND)
1791: THEN
1792: CLOSE ic_lots_sts_c1;
1793: RETURN FALSE;
1794: ELSE

Line 1792: CLOSE ic_lots_sts_c1;

1788: OPEN ic_lots_sts_c1;
1789: FETCH ic_lots_sts_c1 INTO l_lot_status;
1790: IF (ic_lots_sts_c1%NOTFOUND)
1791: THEN
1792: CLOSE ic_lots_sts_c1;
1793: RETURN FALSE;
1794: ELSE
1795: CLOSE ic_lots_sts_c1;
1796: RETURN TRUE;

Line 1795: CLOSE ic_lots_sts_c1;

1791: THEN
1792: CLOSE ic_lots_sts_c1;
1793: RETURN FALSE;
1794: ELSE
1795: CLOSE ic_lots_sts_c1;
1796: RETURN TRUE;
1797: END IF;
1798:
1799: EXCEPTION