DBA Data[Home] [Help]

APPS.GMD_SPREAD_FETCH_PKG dependencies on GMD_QUALITY_GRP

Line 1575: l_inv_inp_rec_type GMD_QUALITY_GRP.inv_inp_rec_type;

1571:
1572: l_rec Cur_get_data%ROWTYPE;
1573: l_return_status VARCHAR2(1);
1574: l_value VARCHAR2(80);
1575: l_inv_inp_rec_type GMD_QUALITY_GRP.inv_inp_rec_type;
1576: l_inv_val_out_rec_type GMD_QUALITY_GRP.inv_val_out_rec_type;
1577:
1578: CURSOR Cur_get_value(Pline_id NUMBER,Pparm_id NUMBER) IS
1579: SELECT value

Line 1576: l_inv_val_out_rec_type GMD_QUALITY_GRP.inv_val_out_rec_type;

1572: l_rec Cur_get_data%ROWTYPE;
1573: l_return_status VARCHAR2(1);
1574: l_value VARCHAR2(80);
1575: l_inv_inp_rec_type GMD_QUALITY_GRP.inv_inp_rec_type;
1576: l_inv_val_out_rec_type GMD_QUALITY_GRP.inv_val_out_rec_type;
1577:
1578: CURSOR Cur_get_value(Pline_id NUMBER,Pparm_id NUMBER) IS
1579: SELECT value
1580: FROM gmd_technical_data_gtmp

Line 1601: gmd_quality_grp.get_inv_test_value (P_inv_test_inp_rec => l_inv_inp_rec_type,

1597: l_inv_inp_rec_type.locator_id := l_rec.locator_id;
1598: l_inv_inp_rec_type.plant_id := V_plant_id;
1599: FOR l_qmrec IN Cur_get_qmdata LOOP
1600: l_inv_inp_rec_type.test_id := l_qmrec.qcassy_typ_id;
1601: gmd_quality_grp.get_inv_test_value (P_inv_test_inp_rec => l_inv_inp_rec_type,
1602: x_inv_test_out_rec => l_inv_val_out_rec_type,
1603: x_return_status => l_return_status);
1604: l_value := l_inv_val_out_rec_type.entity_value;
1605: IF (l_rec.line_type = 3) THEN