APPS.GMD_SPEC_GRP dependencies on GMD_SPECIFICATIONS_B

Line 141: FROM gmd_specifications_b

137:
138: -- Check for Approved Base Spec (Bug 3401368)
139: CURSOR c_spec (p_spec_id NUMBER) IS
140: SELECT 1
141: FROM gmd_specifications_b
142: WHERE spec_id = p_spec_id
143: AND spec_status = 700 ;
144:
145:

Line 908: FROM gmd_specifications_b

904: RETURN BOOLEAN IS
905:
906: CURSOR c_spec (p_spec_name VARCHAR2, p_spec_vers NUMBER) IS
907: SELECT 1
908: FROM gmd_specifications_b
909: WHERE spec_name = p_spec_name
910: AND spec_vers = p_spec_vers;
911:
912: dummy PLS_INTEGER;

Line 1083: FROM gmd_specifications_b

1079: ) IS
1080:
1081: CURSOR c_spec (p_spec_name VARCHAR2, p_spec_vers NUMBER) IS
1082: SELECT 1
1083: FROM gmd_specifications_b
1084: WHERE spec_name = p_spec_name
1085: AND spec_vers = p_spec_vers;
1086:
1087: CURSOR c_test_value (p_test_id NUMBER, p_value_char VARCHAR2) IS

Line 1095: FROM gmd_specifications_b

1091: AND value_char = p_value_char ;
1092:
1093: CURSOR c_spec_type (p_spec_id NUMBER) IS
1094: SELECT spec_type
1095: FROM gmd_specifications_b
1096: WHERE spec_id = p_spec_id ;
1097:
1098: -- Local Variables
1099: l_dummy NUMBER;

Line 1678: FROM GMD_SPECIFICATIONS_B

1674:
1675: l_spec_tests := l_spec_tests_out ;
1676:
1677: SELECT delete_mark into l_spec_delete_mark
1678: FROM GMD_SPECIFICATIONS_B
1679: WHERE spec_id = p_spec_id ;
1680:
1681: IF l_spec_delete_mark <> 0
1682: THEN

Line 2462: From gmd_specifications_b a, gmd_qc_status b

2458: END IF;
2459:
2460: OPEN Status_cur FOR
2461: Select b.version_enabled
2462: From gmd_specifications_b a, gmd_qc_status b
2463: Where a.spec_id = p_entity_id
2464: And a.spec_status = b.status_code
2465: and b.entity_type = 'S';
2466: FETCH Status_cur INTO l_version_enabled;

Line 2532: FROM gmd_specifications_b

2528:
2529:
2530: CURSOR Cur_spec_vers IS
2531: SELECT MAX(spec_vers) + 1
2532: FROM gmd_specifications_b
2533: WHERE spec_name = X_hdr_rec.spec_name;
2534:
2535: l_progress VARCHAR2(3);
2536:

Line 2840: IF (upper(p_table_name) = 'GMD_SPECIFICATIONS_B' ) THEN

2836: END IF;
2837:
2838: -- Now construct the SQL Stmt.
2839: -- B2943737 SQL Bind Variable Project.
2840: IF (upper(p_table_name) = 'GMD_SPECIFICATIONS_B' ) THEN
2841: l_sql_stmt := 'UPDATE GMD_SPECIFICATIONS_B' ||
2842: ' SET spec_status = :l_status' ||
2843: ' WHERE spec_id = :p_id';
2844: -- added by mahesh to support stability study

Line 2841: l_sql_stmt := 'UPDATE GMD_SPECIFICATIONS_B' ||

2837:
2838: -- Now construct the SQL Stmt.
2839: -- B2943737 SQL Bind Variable Project.
2840: IF (upper(p_table_name) = 'GMD_SPECIFICATIONS_B' ) THEN
2841: l_sql_stmt := 'UPDATE GMD_SPECIFICATIONS_B' ||
2842: ' SET spec_status = :l_status' ||
2843: ' WHERE spec_id = :p_id';
2844: -- added by mahesh to support stability study
2845: ELSIF (upper(p_table_name) = 'GMD_STABILITY_STUDIES_B' ) THEN