APPS.GMD_SPEC_GRP dependencies on GMD_SPEC_TESTS

Line 372: p_spec_tests IN gmd_spec_tests%ROWTYPE

368: -- End of comments
369:
370: PROCEDURE check_for_null_and_fks_in_stst
371: (
372: p_spec_tests IN gmd_spec_tests%ROWTYPE
373: , x_spec_tests OUT NOCOPY gmd_spec_tests%ROWTYPE
374: , x_return_status OUT NOCOPY VARCHAR2
375: ) IS
376:

Line 373: , x_spec_tests OUT NOCOPY gmd_spec_tests%ROWTYPE

369:
370: PROCEDURE check_for_null_and_fks_in_stst
371: (
372: p_spec_tests IN gmd_spec_tests%ROWTYPE
373: , x_spec_tests OUT NOCOPY gmd_spec_tests%ROWTYPE
374: , x_return_status OUT NOCOPY VARCHAR2
375: ) IS
376:
377:

Line 403: l_test_priority GMD_SPEC_TESTS_B.TEST_PRIORITY%TYPE;

399: l_test_code GMD_QC_TESTS_B.TEST_CODE%TYPE;
400: l_test_min_value_num NUMBER;
401: l_test_max_value_num NUMBER;
402: l_test_method_id NUMBER;
403: l_test_priority GMD_SPEC_TESTS_B.TEST_PRIORITY%TYPE;
404: l_test_method_replicate NUMBER;
405:
406: BEGIN
407:

Line 1012: FROM gmd_spec_tests_b st, mtl_units_of_measure um

1008: RETURN BOOLEAN IS
1009:
1010: CURSOR c_class_combo (p_spec_name VARCHAR2, p_spec_vers NUMBER, p_to_uom VARCHAR2) IS
1011: SELECT 1
1012: FROM gmd_spec_tests_b st, mtl_units_of_measure um
1013: WHERE st.spec_id = p_spec_id
1014: AND st.test_id <> p_test_id
1015: AND st.to_qty_uom = um.uom_code
1016: AND um.uom_class =

Line 1074: p_spec_test IN gmd_spec_tests%ROWTYPE

1070: --+========================================================================+
1071: -- End of comments
1072: PROCEDURE validate_spec_test
1073: (
1074: p_spec_test IN gmd_spec_tests%ROWTYPE
1075: , p_called_from IN VARCHAR2
1076: , p_operation IN VARCHAR2
1077: , x_spec_test OUT NOCOPY gmd_spec_tests%ROWTYPE
1078: , x_return_status OUT NOCOPY VARCHAR2

Line 1077: , x_spec_test OUT NOCOPY gmd_spec_tests%ROWTYPE

1073: (
1074: p_spec_test IN gmd_spec_tests%ROWTYPE
1075: , p_called_from IN VARCHAR2
1076: , p_operation IN VARCHAR2
1077: , x_spec_test OUT NOCOPY gmd_spec_tests%ROWTYPE
1078: , x_return_status OUT NOCOPY VARCHAR2
1079: ) IS
1080:
1081: CURSOR c_spec (p_spec_name VARCHAR2, p_spec_vers NUMBER) IS

Line 1458: FROM GMD_SPEC_TESTS_B a , GMD_QC_TESTS_B b

1454: x_return_status OUT NOCOPY VARCHAR2) IS
1455:
1456: CURSOR cr_expression_tests IS
1457: SELECT a.test_id,a.seq
1458: FROM GMD_SPEC_TESTS_B a , GMD_QC_TESTS_B b
1459: WHERE
1460: a.spec_id = p_spec_id
1461: AND a.test_id = b.test_id
1462: AND b.test_type = 'E' ;

Line 1479: FROM GMD_SPEC_TESTS_B

1475: END IF;
1476:
1477: -- atleast one test should be present in the spec.
1478: SELECT NVL(COUNT(1),0) INTO l_test_count
1479: FROM GMD_SPEC_TESTS_B
1480: WHERE spec_id = p_spec_id ;
1481:
1482: IF l_test_count = 0 THEN
1483: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_NO_TEST');

Line 1637: l_spec_tests GMD_SPEC_TESTS%ROWTYPE;

1633: x_message_data OUT NOCOPY VARCHAR2) IS
1634:
1635: l_progress VARCHAR2(3);
1636: l_temp VARCHAR2(1);
1637: l_spec_tests GMD_SPEC_TESTS%ROWTYPE;
1638: l_spec_tests_out GMD_SPEC_TESTS%ROWTYPE;
1639: l_spec_delete_mark BINARY_INTEGER;
1640:
1641: BEGIN

Line 1638: l_spec_tests_out GMD_SPEC_TESTS%ROWTYPE;

1634:
1635: l_progress VARCHAR2(3);
1636: l_temp VARCHAR2(1);
1637: l_spec_tests GMD_SPEC_TESTS%ROWTYPE;
1638: l_spec_tests_out GMD_SPEC_TESTS%ROWTYPE;
1639: l_spec_delete_mark BINARY_INTEGER;
1640:
1641: BEGIN
1642: l_progress := '010';

Line 1665: IF NOT GMD_Spec_Tests_PVT.Fetch_Row(l_spec_tests,l_spec_tests_out)

1661: END IF;
1662:
1663: -- Fetch the row
1664: -- =============
1665: IF NOT GMD_Spec_Tests_PVT.Fetch_Row(l_spec_tests,l_spec_tests_out)
1666: THEN
1667: fnd_message.set_name('GMD','GMD_FAILED_TO_FETCH_ROW');
1668: fnd_message.set_token('L_TABLE_NAME','GMD_SPEC_TESTS');
1669: fnd_message.set_token('L_COLUMN_NAME','TEST_ID');

Line 1668: fnd_message.set_token('L_TABLE_NAME','GMD_SPEC_TESTS');

1664: -- =============
1665: IF NOT GMD_Spec_Tests_PVT.Fetch_Row(l_spec_tests,l_spec_tests_out)
1666: THEN
1667: fnd_message.set_name('GMD','GMD_FAILED_TO_FETCH_ROW');
1668: fnd_message.set_token('L_TABLE_NAME','GMD_SPEC_TESTS');
1669: fnd_message.set_token('L_COLUMN_NAME','TEST_ID');
1670: fnd_message.set_token('L_KEY_VALUE',l_spec_tests.test_id);
1671: fnd_msg_pub.ADD;
1672: RAISE FND_API.G_EXC_ERROR;

Line 1745: FROM GMD_SPEC_TESTS_B

1741: BEGIN
1742:
1743: IF p_exclude_test_id IS NULL THEN
1744: SELECT 1 INTO dummy
1745: FROM GMD_SPEC_TESTS_B
1746: WHERE spec_id = p_spec_id
1747: AND seq = p_seq ;
1748: ELSE
1749: SELECT 1 INTO dummy

Line 1750: FROM GMD_SPEC_TESTS_B

1746: WHERE spec_id = p_spec_id
1747: AND seq = p_seq ;
1748: ELSE
1749: SELECT 1 INTO dummy
1750: FROM GMD_SPEC_TESTS_B
1751: WHERE spec_id = p_spec_id
1752: AND seq = p_seq
1753: AND test_id <> p_exclude_test_id ;
1754: END IF;

Line 1792: FROM GMD_SPEC_TESTS_B

1788:
1789: BEGIN
1790:
1791: SELECT 1 INTO dummy
1792: FROM GMD_SPEC_TESTS_B
1793: WHERE spec_id = p_spec_id
1794: AND test_id = p_test_id;
1795:
1796: RETURN TRUE;

Line 1835: FROM GMD_SPEC_TESTS_B

1831: WHERE test_id = p_exp_test_id;
1832:
1833: CURSOR c_spec_test (p_spec_id NUMBER, p_exp_test_seq NUMBER, p_ref_test_id NUMBER) IS
1834: SELECT 1
1835: FROM GMD_SPEC_TESTS_B
1836: WHERE spec_id = p_spec_id
1837: AND test_id = p_ref_test_id
1838: AND seq < p_exp_test_seq;
1839:

Line 2518: FROM gmd_spec_tests

2514: X_hdr_rec Cur_get_hdr%ROWTYPE;
2515:
2516: CURSOR Cur_get_dtl IS
2517: SELECT *
2518: FROM gmd_spec_tests
2519: WHERE spec_id = p_spec_id;
2520: TYPE detail_tab IS TABLE OF Cur_get_dtl%ROWTYPE INDEX BY BINARY_INTEGER;
2521: X_dtl_tbl detail_tab;
2522:

Line 2632: GMD_SPEC_TESTS_PVT.INSERT_ROW(

2628:
2629: l_progress := '030';
2630:
2631: FOR i IN 1..X_dtl_tbl.count LOOP
2632: GMD_SPEC_TESTS_PVT.INSERT_ROW(
2633: X_ROWID => l_rowid,
2634: X_SPEC_ID => x_spec_id,
2635: X_FROM_BASE_IND => x_dtl_tbl(i).FROM_BASE_IND,
2636: X_EXCLUDE_IND => x_dtl_tbl(i).EXCLUDE_IND,