APPS.GMD_QC_TESTS_GRP dependencies on GMD_TEST_GROUP_GT

Line 1331: from gmd_test_group_gt;

1327: and nvl(c.spec_used_for_lot_attrib_ind,'N') ='Y';
1328:
1329: CURSOR c_get_test_id IS
1330: select test_id
1331: from gmd_test_group_gt;
1332:
1333:
1334: l_spec_id NUMBER;
1335: l_test_qty_uom VARCHAR2(80);

Line 1342: delete gmd_test_group_gt;

1338: BEGIN
1339:
1340: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1341:
1342: delete gmd_test_group_gt;
1343: INSERT INTO GMD_TEST_GROUP_GT
1344: (TEST_GROUP_ORDER,
1345: TEST_CODE,
1346: TEST_ID,

Line 1343: INSERT INTO GMD_TEST_GROUP_GT

1339:
1340: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1341:
1342: delete gmd_test_group_gt;
1343: INSERT INTO GMD_TEST_GROUP_GT
1344: (TEST_GROUP_ORDER,
1345: TEST_CODE,
1346: TEST_ID,
1347: TEST_DESC,

Line 1370: UPDATE gmd_test_group_gt

1366: AND a.test_method_id = c.test_method_id
1367: ORDER BY test_group_order; --RLNAGARA B5099998 Added this ORDER BY Clause.
1368:
1369: IF (p_spec_id IS NOT NULL) THEN
1370: UPDATE gmd_test_group_gt
1371: SET used_in_spec = 'Y', include = 'N'
1372: WHERE test_id IN (SELECT test_id
1373: FROM gmd_spec_tests
1374: WHERE spec_id = p_spec_id);

Line 1404: UPDATE gmd_test_group_gt

1400:
1401:
1402:
1403: IF (l_test_qty_uom is NOT NULL) THEN
1404: UPDATE gmd_test_group_gt
1405: SET test_qty = l_test_qty,
1406: test_qty_uom = l_test_qty_uom
1407: WHERE test_id = l_test_id.test_id;
1408: END IF;

Line 1435: UPDATE gmd_test_group_gt SET

1431: p_include IN VARCHAR2,
1432: p_test_qty IN NUMBER,
1433: p_test_uom IN VARCHAR2) IS
1434: BEGIN
1435: UPDATE gmd_test_group_gt SET
1436: include = p_include,
1437: test_qty = p_test_qty,
1438: test_qty_uom = p_test_uom
1439: WHERE test_id = p_test_id;