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 QC_GRAD_MST

Line 1675: --| This function validates that QC Grqde exists on qc_grad_mst |

1671: --| USAGE |
1672: --| Validates qc_grade |
1673: --| |
1674: --| DESCRIPTION |
1675: --| This function validates that QC Grqde exists on qc_grad_mst |
1676: --| and is not blank if grade_ctl = 1 |
1677: --| |
1678: --| PARAMETERS |
1679: --| p_qc_grade IN VARCHAR2(4) - QC Grade Code |

Line 1697: CURSOR qc_grad_mst_c1 IS

1693: )
1694: RETURN BOOLEAN
1695: IS
1696: l_qc_grade ic_item_mst.qc_grade%TYPE;
1697: CURSOR qc_grad_mst_c1 IS
1698: SELECT
1699: qc_grade
1700: FROM
1701: qc_grad_mst

Line 1701: qc_grad_mst

1697: CURSOR qc_grad_mst_c1 IS
1698: SELECT
1699: qc_grade
1700: FROM
1701: qc_grad_mst
1702: WHERE
1703: qc_grad_mst.qc_grade = p_qc_grade
1704: AND qc_grad_mst.delete_mark = 0;
1705:

Line 1703: qc_grad_mst.qc_grade = p_qc_grade

1699: qc_grade
1700: FROM
1701: qc_grad_mst
1702: WHERE
1703: qc_grad_mst.qc_grade = p_qc_grade
1704: AND qc_grad_mst.delete_mark = 0;
1705:
1706: BEGIN
1707:

Line 1704: AND qc_grad_mst.delete_mark = 0;

1700: FROM
1701: qc_grad_mst
1702: WHERE
1703: qc_grad_mst.qc_grade = p_qc_grade
1704: AND qc_grad_mst.delete_mark = 0;
1705:
1706: BEGIN
1707:
1708: IF (p_grade_ctl = 0)

Line 1719: OPEN qc_grad_mst_c1;

1715: THEN
1716: RETURN FALSE;
1717: END IF;
1718:
1719: OPEN qc_grad_mst_c1;
1720: FETCH qc_grad_mst_c1 INTO l_qc_grade;
1721: IF (qc_grad_mst_c1%NOTFOUND)
1722: THEN
1723: CLOSE qc_grad_mst_c1;

Line 1720: FETCH qc_grad_mst_c1 INTO l_qc_grade;

1716: RETURN FALSE;
1717: END IF;
1718:
1719: OPEN qc_grad_mst_c1;
1720: FETCH qc_grad_mst_c1 INTO l_qc_grade;
1721: IF (qc_grad_mst_c1%NOTFOUND)
1722: THEN
1723: CLOSE qc_grad_mst_c1;
1724: RETURN FALSE;

Line 1721: IF (qc_grad_mst_c1%NOTFOUND)

1717: END IF;
1718:
1719: OPEN qc_grad_mst_c1;
1720: FETCH qc_grad_mst_c1 INTO l_qc_grade;
1721: IF (qc_grad_mst_c1%NOTFOUND)
1722: THEN
1723: CLOSE qc_grad_mst_c1;
1724: RETURN FALSE;
1725: ELSE

Line 1723: CLOSE qc_grad_mst_c1;

1719: OPEN qc_grad_mst_c1;
1720: FETCH qc_grad_mst_c1 INTO l_qc_grade;
1721: IF (qc_grad_mst_c1%NOTFOUND)
1722: THEN
1723: CLOSE qc_grad_mst_c1;
1724: RETURN FALSE;
1725: ELSE
1726: CLOSE qc_grad_mst_c1;
1727: RETURN TRUE;

Line 1726: CLOSE qc_grad_mst_c1;

1722: THEN
1723: CLOSE qc_grad_mst_c1;
1724: RETURN FALSE;
1725: ELSE
1726: CLOSE qc_grad_mst_c1;
1727: RETURN TRUE;
1728: END IF;
1729:
1730: EXCEPTION