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_PRCE_CLS

Line 1066: --| on ic_prce_cls |

1062: --| Validates price_class |
1063: --| |
1064: --| DESCRIPTION |
1065: --| This function validates that the Price Class exists |
1066: --| on ic_prce_cls |
1067: --| |
1068: --| PARAMETERS |
1069: --| p_price_class IN VARCHAR2(8) - Price Class |
1070: --| |

Line 1086: CURSOR ic_prce_cls_c1 IS

1082: )
1083: RETURN BOOLEAN
1084: IS
1085: l_price_class ic_item_mst.price_class%TYPE;
1086: CURSOR ic_prce_cls_c1 IS
1087: SELECT
1088: icprice_class
1089: FROM
1090: ic_prce_cls

Line 1090: ic_prce_cls

1086: CURSOR ic_prce_cls_c1 IS
1087: SELECT
1088: icprice_class
1089: FROM
1090: ic_prce_cls
1091: WHERE
1092: ic_prce_cls.icprice_class = p_price_class
1093: AND ic_prce_cls.delete_mark = 0;
1094:

Line 1092: ic_prce_cls.icprice_class = p_price_class

1088: icprice_class
1089: FROM
1090: ic_prce_cls
1091: WHERE
1092: ic_prce_cls.icprice_class = p_price_class
1093: AND ic_prce_cls.delete_mark = 0;
1094:
1095: BEGIN
1096:

Line 1093: AND ic_prce_cls.delete_mark = 0;

1089: FROM
1090: ic_prce_cls
1091: WHERE
1092: ic_prce_cls.icprice_class = p_price_class
1093: AND ic_prce_cls.delete_mark = 0;
1094:
1095: BEGIN
1096:
1097: OPEN ic_prce_cls_c1;

Line 1097: OPEN ic_prce_cls_c1;

1093: AND ic_prce_cls.delete_mark = 0;
1094:
1095: BEGIN
1096:
1097: OPEN ic_prce_cls_c1;
1098: FETCH ic_prce_cls_c1 INTO l_price_class;
1099: IF (ic_prce_cls_c1%NOTFOUND)
1100: THEN
1101: CLOSE ic_prce_cls_c1;

Line 1098: FETCH ic_prce_cls_c1 INTO l_price_class;

1094:
1095: BEGIN
1096:
1097: OPEN ic_prce_cls_c1;
1098: FETCH ic_prce_cls_c1 INTO l_price_class;
1099: IF (ic_prce_cls_c1%NOTFOUND)
1100: THEN
1101: CLOSE ic_prce_cls_c1;
1102: RETURN FALSE;

Line 1099: IF (ic_prce_cls_c1%NOTFOUND)

1095: BEGIN
1096:
1097: OPEN ic_prce_cls_c1;
1098: FETCH ic_prce_cls_c1 INTO l_price_class;
1099: IF (ic_prce_cls_c1%NOTFOUND)
1100: THEN
1101: CLOSE ic_prce_cls_c1;
1102: RETURN FALSE;
1103: ELSE

Line 1101: CLOSE ic_prce_cls_c1;

1097: OPEN ic_prce_cls_c1;
1098: FETCH ic_prce_cls_c1 INTO l_price_class;
1099: IF (ic_prce_cls_c1%NOTFOUND)
1100: THEN
1101: CLOSE ic_prce_cls_c1;
1102: RETURN FALSE;
1103: ELSE
1104: CLOSE ic_prce_cls_c1;
1105: RETURN TRUE;

Line 1104: CLOSE ic_prce_cls_c1;

1100: THEN
1101: CLOSE ic_prce_cls_c1;
1102: RETURN FALSE;
1103: ELSE
1104: CLOSE ic_prce_cls_c1;
1105: RETURN TRUE;
1106: END IF;
1107:
1108: EXCEPTION