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_FRGT_CLS

Line 1008: --| on ic_frgt_cls |

1004: --| Validates frt_class |
1005: --| |
1006: --| DESCRIPTION |
1007: --| This function validates that the Freight Class exists |
1008: --| on ic_frgt_cls |
1009: --| |
1010: --| PARAMETERS |
1011: --| p_frgt_class IN VARCHAR2(8) - Freight Class |
1012: --| |

Line 1028: CURSOR ic_frgt_cls_c1 IS

1024: )
1025: RETURN BOOLEAN
1026: IS
1027: l_frt_class ic_item_mst.frt_class%TYPE;
1028: CURSOR ic_frgt_cls_c1 IS
1029: SELECT
1030: icfrt_class
1031: FROM
1032: ic_frgt_cls

Line 1032: ic_frgt_cls

1028: CURSOR ic_frgt_cls_c1 IS
1029: SELECT
1030: icfrt_class
1031: FROM
1032: ic_frgt_cls
1033: WHERE
1034: ic_frgt_cls.icfrt_class = p_frt_class
1035: AND ic_frgt_cls.delete_mark = 0;
1036:

Line 1034: ic_frgt_cls.icfrt_class = p_frt_class

1030: icfrt_class
1031: FROM
1032: ic_frgt_cls
1033: WHERE
1034: ic_frgt_cls.icfrt_class = p_frt_class
1035: AND ic_frgt_cls.delete_mark = 0;
1036:
1037: BEGIN
1038:

Line 1035: AND ic_frgt_cls.delete_mark = 0;

1031: FROM
1032: ic_frgt_cls
1033: WHERE
1034: ic_frgt_cls.icfrt_class = p_frt_class
1035: AND ic_frgt_cls.delete_mark = 0;
1036:
1037: BEGIN
1038:
1039: OPEN ic_frgt_cls_c1;

Line 1039: OPEN ic_frgt_cls_c1;

1035: AND ic_frgt_cls.delete_mark = 0;
1036:
1037: BEGIN
1038:
1039: OPEN ic_frgt_cls_c1;
1040: FETCH ic_frgt_cls_c1 INTO l_frt_class;
1041: IF (ic_frgt_cls_c1%NOTFOUND)
1042: THEN
1043: CLOSE ic_frgt_cls_c1;

Line 1040: FETCH ic_frgt_cls_c1 INTO l_frt_class;

1036:
1037: BEGIN
1038:
1039: OPEN ic_frgt_cls_c1;
1040: FETCH ic_frgt_cls_c1 INTO l_frt_class;
1041: IF (ic_frgt_cls_c1%NOTFOUND)
1042: THEN
1043: CLOSE ic_frgt_cls_c1;
1044: RETURN FALSE;

Line 1041: IF (ic_frgt_cls_c1%NOTFOUND)

1037: BEGIN
1038:
1039: OPEN ic_frgt_cls_c1;
1040: FETCH ic_frgt_cls_c1 INTO l_frt_class;
1041: IF (ic_frgt_cls_c1%NOTFOUND)
1042: THEN
1043: CLOSE ic_frgt_cls_c1;
1044: RETURN FALSE;
1045: ELSE

Line 1043: CLOSE ic_frgt_cls_c1;

1039: OPEN ic_frgt_cls_c1;
1040: FETCH ic_frgt_cls_c1 INTO l_frt_class;
1041: IF (ic_frgt_cls_c1%NOTFOUND)
1042: THEN
1043: CLOSE ic_frgt_cls_c1;
1044: RETURN FALSE;
1045: ELSE
1046: CLOSE ic_frgt_cls_c1;
1047: RETURN TRUE;

Line 1046: CLOSE ic_frgt_cls_c1;

1042: THEN
1043: CLOSE ic_frgt_cls_c1;
1044: RETURN FALSE;
1045: ELSE
1046: CLOSE ic_frgt_cls_c1;
1047: RETURN TRUE;
1048: END IF;
1049:
1050: EXCEPTION