DBA Data[Home] [Help]

APPS.GMIVQTY dependencies on QC_GRAD_MST

Line 185: , p_qc_grade IN qc_grad_mst.qc_grade%TYPE

181: */
182: FUNCTION Check_unposted_jnl_qc_grade
183: ( p_item_id IN ic_item_mst.item_id%TYPE
184: , p_lot_id IN ic_lots_mst.lot_id%TYPE
185: , p_qc_grade IN qc_grad_mst.qc_grade%TYPE
186: )
187: RETURN BOOLEAN
188: IS
189:

Line 494: l_qc_grad_mst_row qc_grad_mst%ROWTYPE;

490: l_ic_whse_mst_rec ic_whse_mst%ROWTYPE;
491: l_ic_loct_inv_row_from ic_loct_inv%ROWTYPE;
492: l_ic_loct_inv_row_to ic_loct_inv%ROWTYPE;
493: l_sy_reas_cds_row sy_reas_cds%ROWTYPE;
494: l_qc_grad_mst_row qc_grad_mst%ROWTYPE;
495: l_ic_lots_sts_row ic_lots_sts%ROWTYPE;
496: l_qty2 NUMBER;
497: l_onhand NUMBER;
498: l_onhand2 NUMBER;

Line 820: IF GMIGUTL.v_qc_grade(l_qty_rec.qc_grade, l_qc_grad_mst_row)

816: IF (l_trans_type IN (5,10))
817: THEN
818: IF l_qty_rec.qc_grade <> p_ic_lots_mst_row.qc_grade
819: THEN
820: IF GMIGUTL.v_qc_grade(l_qty_rec.qc_grade, l_qc_grad_mst_row)
821: THEN
822: /* Check for unposted journals with different QC grade */
823: IF Check_unposted_jnl_qc_grade
824: ( p_item_id => p_ic_item_mst_row.item_id