DBA Data[Home] [Help]

APPS.GMD_SPREAD_FETCH_PKG dependencies on GMD_QUALITY_GRP

Line 1531: l_inv_inp_rec_type GMD_QUALITY_GRP.inv_inp_rec_type;

1527:
1528: l_rec Cur_get_data%ROWTYPE;
1529: l_return_status VARCHAR2(1);
1530: l_value VARCHAR2(80);
1531: l_inv_inp_rec_type GMD_QUALITY_GRP.inv_inp_rec_type;
1532: l_inv_val_out_rec_type GMD_QUALITY_GRP.inv_val_out_rec_type;
1533:
1534: CURSOR Cur_get_value(Pline_id NUMBER,Pparm_id NUMBER) IS
1535: SELECT value

Line 1532: l_inv_val_out_rec_type GMD_QUALITY_GRP.inv_val_out_rec_type;

1528: l_rec Cur_get_data%ROWTYPE;
1529: l_return_status VARCHAR2(1);
1530: l_value VARCHAR2(80);
1531: l_inv_inp_rec_type GMD_QUALITY_GRP.inv_inp_rec_type;
1532: l_inv_val_out_rec_type GMD_QUALITY_GRP.inv_val_out_rec_type;
1533:
1534: CURSOR Cur_get_value(Pline_id NUMBER,Pparm_id NUMBER) IS
1535: SELECT value
1536: FROM gmd_technical_data_gtmp

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

1553: l_inv_inp_rec_type.locator_id := l_rec.locator_id;
1554: l_inv_inp_rec_type.plant_id := V_plant_id;
1555: FOR l_qmrec IN Cur_get_qmdata LOOP
1556: l_inv_inp_rec_type.test_id := l_qmrec.qcassy_typ_id;
1557: gmd_quality_grp.get_inv_test_value (P_inv_test_inp_rec => l_inv_inp_rec_type,
1558: x_inv_test_out_rec => l_inv_val_out_rec_type,
1559: x_return_status => l_return_status);
1560: l_value := l_inv_val_out_rec_type.entity_value;
1561: IF (l_rec.line_type = 3) THEN