APPS.GMI_VALID_GRP dependencies on QC_HRES_MST

Line 1815: --| qc_hres_mst |

1811: --| Validates qchold_res_code |
1812: --| |
1813: --| DESCRIPTION |
1814: --| This function validates that QC Hold Reason Code exists on |
1815: --| qc_hres_mst |
1816: --| |
1817: --| PARAMETERS |
1818: --| p_qchold_res_code IN VARCHAR2(4) - QC Hold reason Code |
1819: --| p_grade_ctl IN NUMBER - Lot Status Indicator |

Line 1836: CURSOR qc_hres_mst_c1 IS

1832: )
1833: RETURN BOOLEAN
1834: IS
1835: l_qchold_res_code ic_item_mst.qchold_res_code%TYPE;
1836: CURSOR qc_hres_mst_c1 IS
1837: SELECT
1838: qchold_res_code
1839: FROM
1840: qc_hres_mst

Line 1840: qc_hres_mst

1836: CURSOR qc_hres_mst_c1 IS
1837: SELECT
1838: qchold_res_code
1839: FROM
1840: qc_hres_mst
1841: WHERE
1842: qc_hres_mst.qchold_res_code = p_qchold_res_code
1843: AND qc_hres_mst.delete_mark = 0;
1844:

Line 1842: qc_hres_mst.qchold_res_code = p_qchold_res_code

1838: qchold_res_code
1839: FROM
1840: qc_hres_mst
1841: WHERE
1842: qc_hres_mst.qchold_res_code = p_qchold_res_code
1843: AND qc_hres_mst.delete_mark = 0;
1844:
1845: BEGIN
1846:

Line 1843: AND qc_hres_mst.delete_mark = 0;

1839: FROM
1840: qc_hres_mst
1841: WHERE
1842: qc_hres_mst.qchold_res_code = p_qchold_res_code
1843: AND qc_hres_mst.delete_mark = 0;
1844:
1845: BEGIN
1846:
1847: IF (p_qchold_res_code = ' ' OR p_qchold_res_code IS NULL)

Line 1855: OPEN qc_hres_mst_c1;

1851: THEN
1852: RETURN FALSE;
1853: END IF;
1854:
1855: OPEN qc_hres_mst_c1;
1856:
1857: FETCH qc_hres_mst_c1 INTO l_qchold_res_code;
1858:
1859: IF (qc_hres_mst_c1%NOTFOUND)

Line 1857: FETCH qc_hres_mst_c1 INTO l_qchold_res_code;

1853: END IF;
1854:
1855: OPEN qc_hres_mst_c1;
1856:
1857: FETCH qc_hres_mst_c1 INTO l_qchold_res_code;
1858:
1859: IF (qc_hres_mst_c1%NOTFOUND)
1860: THEN
1861: CLOSE qc_hres_mst_c1;

Line 1859: IF (qc_hres_mst_c1%NOTFOUND)

1855: OPEN qc_hres_mst_c1;
1856:
1857: FETCH qc_hres_mst_c1 INTO l_qchold_res_code;
1858:
1859: IF (qc_hres_mst_c1%NOTFOUND)
1860: THEN
1861: CLOSE qc_hres_mst_c1;
1862: RETURN FALSE;
1863: ELSE

Line 1861: CLOSE qc_hres_mst_c1;

1857: FETCH qc_hres_mst_c1 INTO l_qchold_res_code;
1858:
1859: IF (qc_hres_mst_c1%NOTFOUND)
1860: THEN
1861: CLOSE qc_hres_mst_c1;
1862: RETURN FALSE;
1863: ELSE
1864: CLOSE qc_hres_mst_c1;
1865: RETURN TRUE;

Line 1864: CLOSE qc_hres_mst_c1;

1860: THEN
1861: CLOSE qc_hres_mst_c1;
1862: RETURN FALSE;
1863: ELSE
1864: CLOSE qc_hres_mst_c1;
1865: RETURN TRUE;
1866: END IF;
1867:
1868: EXCEPTION