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

61: --+========================================================================+
62: -- End of comments
63:
64: PROCEDURE check_for_null_and_fks_in_spec
65: ( p_spec_header IN gmd_specifications%ROWTYPE
66: , x_item_number OUT NOCOPY VARCHAR2
67: , x_owner OUT NOCOPY VARCHAR2
68: , x_return_status OUT NOCOPY VARCHAR2
69: ) IS

Line 126: FROM gmd_specifications_b

122:
123: -- Check for Approved Base Spec (Bug 3401368)
124: CURSOR c_spec (p_spec_id NUMBER) IS
125: SELECT 1
126: FROM gmd_specifications_b
127: WHERE spec_id = p_spec_id
128: AND spec_status = 700 ;
129:
130:

Line 772: p_spec_header IN gmd_specifications%ROWTYPE

768: -- End of comments
769:
770: PROCEDURE validate_spec_header
771: (
772: p_spec_header IN gmd_specifications%ROWTYPE
773: , p_called_from IN VARCHAR2
774: , p_operation IN VARCHAR2
775: , x_return_status OUT NOCOPY VARCHAR2
776: ) IS

Line 866: FROM gmd_specifications_b

862: RETURN BOOLEAN IS
863:
864: CURSOR c_spec (p_spec_name VARCHAR2, p_spec_vers NUMBER) IS
865: SELECT 1
866: FROM gmd_specifications_b
867: WHERE spec_name = p_spec_name
868: AND spec_vers = p_spec_vers;
869:
870: dummy PLS_INTEGER;

Line 1031: FROM gmd_specifications_b

1027: ) IS
1028:
1029: CURSOR c_spec (p_spec_name VARCHAR2, p_spec_vers NUMBER) IS
1030: SELECT 1
1031: FROM gmd_specifications_b
1032: WHERE spec_name = p_spec_name
1033: AND spec_vers = p_spec_vers;
1034:
1035: CURSOR c_test_value (p_test_id NUMBER, p_value_char VARCHAR2) IS

Line 1043: FROM gmd_specifications_b

1039: AND value_char = p_value_char ;
1040:
1041: CURSOR c_spec_type (p_spec_id NUMBER) IS
1042: SELECT spec_type
1043: FROM gmd_specifications_b
1044: WHERE spec_id = p_spec_id ;
1045:
1046: -- Local Variables
1047: l_dummy NUMBER;

Line 1057: l_specification GMD_SPECIFICATIONS%ROWTYPE;

1053: l_st_target NUMBER;
1054: l_st_max NUMBER;
1055:
1056:
1057: l_specification GMD_SPECIFICATIONS%ROWTYPE;
1058: l_specification_out GMD_SPECIFICATIONS%ROWTYPE;
1059: l_test GMD_QC_TESTS%ROWTYPE;
1060: l_test_out GMD_QC_TESTS%ROWTYPE;
1061: l_item MTL_SYSTEM_ITEMS_KFV%ROWTYPE;

Line 1058: l_specification_out GMD_SPECIFICATIONS%ROWTYPE;

1054: l_st_max NUMBER;
1055:
1056:
1057: l_specification GMD_SPECIFICATIONS%ROWTYPE;
1058: l_specification_out GMD_SPECIFICATIONS%ROWTYPE;
1059: l_test GMD_QC_TESTS%ROWTYPE;
1060: l_test_out GMD_QC_TESTS%ROWTYPE;
1061: l_item MTL_SYSTEM_ITEMS_KFV%ROWTYPE;
1062: -- Bug 3401368

Line 1080: IF NOT ( GMD_Specifications_PVT.Fetch_Row(

1076:
1077: -- Fetch Specification Record. Spec must exists for Spec Test.
1078: l_specification.spec_id := p_spec_test.spec_id;
1079: -- Introduce l_specification_out as part of NOCOPY changes.
1080: IF NOT ( GMD_Specifications_PVT.Fetch_Row(
1081: p_specifications => l_specification,
1082: x_specifications => l_specification_out)
1083: ) THEN
1084: -- Fetch Error

Line 1449: DESCRIPTION: This procedure validates GMD_SPECIFICATIONS:

1445:
1446: /*===========================================================================
1447: PROCEDURE NAME: validate_before_delete
1448:
1449: DESCRIPTION: This procedure validates GMD_SPECIFICATIONS:
1450: a) Primary key supplied
1451: b) Spec is not already delete_marked
1452: c) Status permits update
1453:

Line 1466: l_spec GMD_SPECIFICATIONS%ROWTYPE;

1462: x_message_data OUT NOCOPY VARCHAR2) IS
1463:
1464: l_progress VARCHAR2(3);
1465: l_temp VARCHAR2(1);
1466: l_spec GMD_SPECIFICATIONS%ROWTYPE;
1467: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
1468:
1469: BEGIN
1470: l_progress := '010';

Line 1467: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;

1463:
1464: l_progress VARCHAR2(3);
1465: l_temp VARCHAR2(1);
1466: l_spec GMD_SPECIFICATIONS%ROWTYPE;
1467: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
1468:
1469: BEGIN
1470: l_progress := '010';
1471: x_return_status := FND_API.G_RET_STS_SUCCESS ;

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

1481: END IF;
1482:
1483: -- Fetch the row
1484: -- =============
1485: IF NOT GMD_Specifications_PVT.Fetch_Row(l_spec,l_spec_out)
1486: THEN
1487: fnd_message.set_name('GMD','GMD_FAILED_TO_FETCH_ROW');
1488: fnd_message.set_token('L_TABLE_NAME','GMD_SPECIFICATIONS');
1489: fnd_message.set_token('L_COLUMN_NAME','SPEC_ID');

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

1484: -- =============
1485: IF NOT GMD_Specifications_PVT.Fetch_Row(l_spec,l_spec_out)
1486: THEN
1487: fnd_message.set_name('GMD','GMD_FAILED_TO_FETCH_ROW');
1488: fnd_message.set_token('L_TABLE_NAME','GMD_SPECIFICATIONS');
1489: fnd_message.set_token('L_COLUMN_NAME','SPEC_ID');
1490: fnd_message.set_token('L_KEY_VALUE',l_spec.spec_id);
1491: fnd_msg_pub.ADD;
1492: RAISE FND_API.G_EXC_ERROR;

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

1498: -- =============================================
1499: IF l_spec.delete_mark <> 0
1500: THEN
1501: fnd_message.set_name('GMD','GMD_RECORD_DELETE_MARKED');
1502: fnd_message.set_token('L_TABLE_NAME','GMD_SPECIFICATIONS');
1503: fnd_message.set_token('L_COLUMN_NAME','SPEC_ID');
1504: fnd_message.set_token('L_KEY_VALUE',l_spec.spec_id);
1505: fnd_msg_pub.ADD;
1506: RAISE FND_API.G_EXC_ERROR;

Line 1606: FROM GMD_SPECIFICATIONS_B

1602:
1603: l_spec_tests := l_spec_tests_out ;
1604:
1605: SELECT delete_mark into l_spec_delete_mark
1606: FROM GMD_SPECIFICATIONS_B
1607: WHERE spec_id = p_spec_id ;
1608:
1609: IF l_spec_delete_mark <> 0
1610: THEN

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

1608:
1609: IF l_spec_delete_mark <> 0
1610: THEN
1611: fnd_message.set_name('GMD','GMD_RECORD_DELETE_MARKED');
1612: fnd_message.set_token('L_TABLE_NAME','GMD_SPECIFICATIONS');
1613: fnd_message.set_token('L_COLUMN_NAME','SPEC_ID');
1614: fnd_message.set_token('L_KEY_VALUE',p_spec_id);
1615: fnd_msg_pub.ADD;
1616: RAISE FND_API.G_EXC_ERROR;

Line 2390: From gmd_specifications_b a, gmd_qc_status b

2386: END IF;
2387:
2388: OPEN Status_cur FOR
2389: Select b.version_enabled
2390: From gmd_specifications_b a, gmd_qc_status b
2391: Where a.spec_id = p_entity_id
2392: And a.spec_status = b.status_code
2393: and b.entity_type = 'S';
2394: FETCH Status_cur INTO l_version_enabled;

Line 2440: FROM gmd_specifications

2436:
2437:
2438: CURSOR Cur_get_hdr IS
2439: SELECT *
2440: FROM gmd_specifications
2441: WHERE spec_id = p_spec_id ;
2442: X_hdr_rec Cur_get_hdr%ROWTYPE;
2443:
2444: CURSOR Cur_get_dtl IS

Line 2460: FROM gmd_specifications_b

2456:
2457:
2458: CURSOR Cur_spec_vers IS
2459: SELECT MAX(spec_vers) + 1
2460: FROM gmd_specifications_b
2461: WHERE spec_name = X_hdr_rec.spec_name;
2462:
2463: l_progress VARCHAR2(3);
2464:

Line 2502: GMD_SPECIFICATIONS_PVT.INSERT_ROW(

2498:
2499: l_progress := '020';
2500: /* Insert spec header record */
2501:
2502: GMD_SPECIFICATIONS_PVT.INSERT_ROW(
2503: X_ROWID => l_rowid,
2504: X_SPEC_ID => x_spec_id,
2505: X_SPEC_NAME => X_hdr_rec.SPEC_NAME,
2506: X_SPEC_VERS => x_spec_vers,

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

2764: END IF;
2765:
2766: -- Now construct the SQL Stmt.
2767: -- B2943737 SQL Bind Variable Project.
2768: IF (upper(p_table_name) = 'GMD_SPECIFICATIONS_B' ) THEN
2769: l_sql_stmt := 'UPDATE GMD_SPECIFICATIONS_B' ||
2770: ' SET spec_status = :l_status' ||
2771: ' WHERE spec_id = :p_id';
2772: -- added by mahesh to support stability study

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

2765:
2766: -- Now construct the SQL Stmt.
2767: -- B2943737 SQL Bind Variable Project.
2768: IF (upper(p_table_name) = 'GMD_SPECIFICATIONS_B' ) THEN
2769: l_sql_stmt := 'UPDATE GMD_SPECIFICATIONS_B' ||
2770: ' SET spec_status = :l_status' ||
2771: ' WHERE spec_id = :p_id';
2772: -- added by mahesh to support stability study
2773: ELSIF (upper(p_table_name) = 'GMD_STABILITY_STUDIES_B' ) THEN