eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMI_VALID_GRP dependencies on IC_RANK_MST

Line 713: --| on ic_rank_mst |

709: --| Validates item_abccode |
710: --| |
711: --| DESCRIPTION |
712: --| This function validates that the item ABC code exists |
713: --| on ic_rank_mst |
714: --| |
715: --| PARAMETERS |
716: --| p_item_abccode IN VARCHAR2(4) - Item ABC Code |
717: --| |

Line 733: CURSOR ic_rank_mst_c1 IS

729: )
730: RETURN BOOLEAN
731: IS
732: l_item_abccode ic_item_mst.item_abccode%TYPE;
733: CURSOR ic_rank_mst_c1 IS
734: SELECT
735: abc_code
736: FROM
737: ic_rank_mst

Line 737: ic_rank_mst

733: CURSOR ic_rank_mst_c1 IS
734: SELECT
735: abc_code
736: FROM
737: ic_rank_mst
738: WHERE
739: ic_rank_mst.abc_code = p_item_abccode
740: AND ic_rank_mst.delete_mark = 0;
741:

Line 739: ic_rank_mst.abc_code = p_item_abccode

735: abc_code
736: FROM
737: ic_rank_mst
738: WHERE
739: ic_rank_mst.abc_code = p_item_abccode
740: AND ic_rank_mst.delete_mark = 0;
741:
742: BEGIN
743:

Line 740: AND ic_rank_mst.delete_mark = 0;

736: FROM
737: ic_rank_mst
738: WHERE
739: ic_rank_mst.abc_code = p_item_abccode
740: AND ic_rank_mst.delete_mark = 0;
741:
742: BEGIN
743:
744: IF (p_item_abccode = ' ' OR p_item_abccode IS NULL)

Line 748: OPEN ic_rank_mst_c1;

744: IF (p_item_abccode = ' ' OR p_item_abccode IS NULL)
745: THEN
746: RETURN TRUE;
747: ELSE
748: OPEN ic_rank_mst_c1;
749: FETCH ic_rank_mst_c1 INTO l_item_abccode;
750: IF (ic_rank_mst_c1%NOTFOUND)
751: THEN
752: CLOSE ic_rank_mst_c1;

Line 749: FETCH ic_rank_mst_c1 INTO l_item_abccode;

745: THEN
746: RETURN TRUE;
747: ELSE
748: OPEN ic_rank_mst_c1;
749: FETCH ic_rank_mst_c1 INTO l_item_abccode;
750: IF (ic_rank_mst_c1%NOTFOUND)
751: THEN
752: CLOSE ic_rank_mst_c1;
753: RETURN FALSE;

Line 750: IF (ic_rank_mst_c1%NOTFOUND)

746: RETURN TRUE;
747: ELSE
748: OPEN ic_rank_mst_c1;
749: FETCH ic_rank_mst_c1 INTO l_item_abccode;
750: IF (ic_rank_mst_c1%NOTFOUND)
751: THEN
752: CLOSE ic_rank_mst_c1;
753: RETURN FALSE;
754: ELSE

Line 752: CLOSE ic_rank_mst_c1;

748: OPEN ic_rank_mst_c1;
749: FETCH ic_rank_mst_c1 INTO l_item_abccode;
750: IF (ic_rank_mst_c1%NOTFOUND)
751: THEN
752: CLOSE ic_rank_mst_c1;
753: RETURN FALSE;
754: ELSE
755: CLOSE ic_rank_mst_c1;
756: RETURN TRUE;

Line 755: CLOSE ic_rank_mst_c1;

751: THEN
752: CLOSE ic_rank_mst_c1;
753: RETURN FALSE;
754: ELSE
755: CLOSE ic_rank_mst_c1;
756: RETURN TRUE;
757: END IF;
758: END IF;
759: