eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_SPEC_GRP dependencies on GMD_SPECIFICATIONS

Line 80: ( p_spec_header IN gmd_specifications%ROWTYPE

76: --+========================================================================+
77: -- End of comments
78:
79: PROCEDURE check_for_null_and_fks_in_spec
80: ( p_spec_header IN gmd_specifications%ROWTYPE
81: , x_item_number OUT NOCOPY VARCHAR2
82: , x_owner OUT NOCOPY VARCHAR2
83: , x_return_status OUT NOCOPY VARCHAR2
84: ) IS

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 814: p_spec_header IN gmd_specifications%ROWTYPE

810: -- End of comments
811:
812: PROCEDURE validate_spec_header
813: (
814: p_spec_header IN gmd_specifications%ROWTYPE
815: , p_called_from IN VARCHAR2
816: , p_operation IN VARCHAR2
817: , x_return_status OUT NOCOPY VARCHAR2
818: ) IS

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 1109: l_specification GMD_SPECIFICATIONS%ROWTYPE;

1105: l_st_target NUMBER;
1106: l_st_max NUMBER;
1107:
1108:
1109: l_specification GMD_SPECIFICATIONS%ROWTYPE;
1110: l_specification_out GMD_SPECIFICATIONS%ROWTYPE;
1111: l_test GMD_QC_TESTS%ROWTYPE;
1112: l_test_out GMD_QC_TESTS%ROWTYPE;
1113: l_item MTL_SYSTEM_ITEMS_KFV%ROWTYPE;

Line 1110: l_specification_out GMD_SPECIFICATIONS%ROWTYPE;

1106: l_st_max NUMBER;
1107:
1108:
1109: l_specification GMD_SPECIFICATIONS%ROWTYPE;
1110: l_specification_out GMD_SPECIFICATIONS%ROWTYPE;
1111: l_test GMD_QC_TESTS%ROWTYPE;
1112: l_test_out GMD_QC_TESTS%ROWTYPE;
1113: l_item MTL_SYSTEM_ITEMS_KFV%ROWTYPE;
1114: -- Bug 3401368

Line 1132: IF NOT ( GMD_Specifications_PVT.Fetch_Row(

1128:
1129: -- Fetch Specification Record. Spec must exists for Spec Test.
1130: l_specification.spec_id := p_spec_test.spec_id;
1131: -- Introduce l_specification_out as part of NOCOPY changes.
1132: IF NOT ( GMD_Specifications_PVT.Fetch_Row(
1133: p_specifications => l_specification,
1134: x_specifications => l_specification_out)
1135: ) THEN
1136: -- Fetch Error

Line 1521: DESCRIPTION: This procedure validates GMD_SPECIFICATIONS:

1517:
1518: /*===========================================================================
1519: PROCEDURE NAME: validate_before_delete
1520:
1521: DESCRIPTION: This procedure validates GMD_SPECIFICATIONS:
1522: a) Primary key supplied
1523: b) Spec is not already delete_marked
1524: c) Status permits update
1525:

Line 1538: l_spec GMD_SPECIFICATIONS%ROWTYPE;

1534: x_message_data OUT NOCOPY VARCHAR2) IS
1535:
1536: l_progress VARCHAR2(3);
1537: l_temp VARCHAR2(1);
1538: l_spec GMD_SPECIFICATIONS%ROWTYPE;
1539: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
1540:
1541: BEGIN
1542: l_progress := '010';

Line 1539: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;

1535:
1536: l_progress VARCHAR2(3);
1537: l_temp VARCHAR2(1);
1538: l_spec GMD_SPECIFICATIONS%ROWTYPE;
1539: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
1540:
1541: BEGIN
1542: l_progress := '010';
1543: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1557: IF NOT GMD_Specifications_PVT.Fetch_Row(l_spec,l_spec_out)

1553: END IF;
1554:
1555: -- Fetch the row
1556: -- =============
1557: IF NOT GMD_Specifications_PVT.Fetch_Row(l_spec,l_spec_out)
1558: THEN
1559: fnd_message.set_name('GMD','GMD_FAILED_TO_FETCH_ROW');
1560: fnd_message.set_token('L_TABLE_NAME','GMD_SPECIFICATIONS');
1561: fnd_message.set_token('L_COLUMN_NAME','SPEC_ID');

Line 1560: fnd_message.set_token('L_TABLE_NAME','GMD_SPECIFICATIONS');

1556: -- =============
1557: IF NOT GMD_Specifications_PVT.Fetch_Row(l_spec,l_spec_out)
1558: THEN
1559: fnd_message.set_name('GMD','GMD_FAILED_TO_FETCH_ROW');
1560: fnd_message.set_token('L_TABLE_NAME','GMD_SPECIFICATIONS');
1561: fnd_message.set_token('L_COLUMN_NAME','SPEC_ID');
1562: fnd_message.set_token('L_KEY_VALUE',l_spec.spec_id);
1563: fnd_msg_pub.ADD;
1564: RAISE FND_API.G_EXC_ERROR;

Line 1574: fnd_message.set_token('L_TABLE_NAME','GMD_SPECIFICATIONS');

1570: -- =============================================
1571: IF l_spec.delete_mark <> 0
1572: THEN
1573: fnd_message.set_name('GMD','GMD_RECORD_DELETE_MARKED');
1574: fnd_message.set_token('L_TABLE_NAME','GMD_SPECIFICATIONS');
1575: fnd_message.set_token('L_COLUMN_NAME','SPEC_ID');
1576: fnd_message.set_token('L_KEY_VALUE',l_spec.spec_id);
1577: fnd_msg_pub.ADD;
1578: RAISE FND_API.G_EXC_ERROR;

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 1684: fnd_message.set_token('L_TABLE_NAME','GMD_SPECIFICATIONS');

1680:
1681: IF l_spec_delete_mark <> 0
1682: THEN
1683: fnd_message.set_name('GMD','GMD_RECORD_DELETE_MARKED');
1684: fnd_message.set_token('L_TABLE_NAME','GMD_SPECIFICATIONS');
1685: fnd_message.set_token('L_COLUMN_NAME','SPEC_ID');
1686: fnd_message.set_token('L_KEY_VALUE',p_spec_id);
1687: fnd_msg_pub.ADD;
1688: RAISE FND_API.G_EXC_ERROR;

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 2512: FROM gmd_specifications

2508:
2509:
2510: CURSOR Cur_get_hdr IS
2511: SELECT *
2512: FROM gmd_specifications
2513: WHERE spec_id = p_spec_id ;
2514: X_hdr_rec Cur_get_hdr%ROWTYPE;
2515:
2516: CURSOR Cur_get_dtl IS

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 2574: GMD_SPECIFICATIONS_PVT.INSERT_ROW(

2570:
2571: l_progress := '020';
2572: /* Insert spec header record */
2573:
2574: GMD_SPECIFICATIONS_PVT.INSERT_ROW(
2575: X_ROWID => l_rowid,
2576: X_SPEC_ID => x_spec_id,
2577: X_SPEC_NAME => X_hdr_rec.SPEC_NAME,
2578: X_SPEC_VERS => x_spec_vers,

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