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_PUB dependencies on GMD_SPECIFICATIONS

Line 80: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE

76: ( p_api_version IN NUMBER
77: , p_init_msg_list IN VARCHAR2
78: , p_commit IN VARCHAR2
79: , p_validation_level IN VARCHAR2
80: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
81: , p_spec_tests_tbl IN GMD_SPEC_PUB.spec_tests_tbl
82: , p_user_name IN VARCHAR2
83: , x_spec OUT NOCOPY GMD_SPECIFICATIONS%ROWTYPE
84: , x_spec_tests_tbl OUT NOCOPY GMD_SPEC_PUB.spec_tests_tbl

Line 83: , x_spec OUT NOCOPY GMD_SPECIFICATIONS%ROWTYPE

79: , p_validation_level IN VARCHAR2
80: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
81: , p_spec_tests_tbl IN GMD_SPEC_PUB.spec_tests_tbl
82: , p_user_name IN VARCHAR2
83: , x_spec OUT NOCOPY GMD_SPECIFICATIONS%ROWTYPE
84: , x_spec_tests_tbl OUT NOCOPY GMD_SPEC_PUB.spec_tests_tbl
85: , x_return_status OUT NOCOPY VARCHAR2
86: , x_msg_count OUT NOCOPY NUMBER
87: , x_msg_data OUT NOCOPY VARCHAR2

Line 95: l_spec GMD_SPECIFICATIONS%ROWTYPE;

91: l_api_version CONSTANT NUMBER := 2.0;
92: l_msg_count NUMBER :=0;
93: l_msg_data VARCHAR2(2000);
94: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
95: l_spec GMD_SPECIFICATIONS%ROWTYPE;
96: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
97: l_spec_tests GMD_SPEC_TESTS%ROWTYPE;
98: l_spec_tests_out GMD_SPEC_TESTS%ROWTYPE;
99: l_spec_tests_tbl GMD_SPEC_PUB.spec_tests_tbl;

Line 96: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;

92: l_msg_count NUMBER :=0;
93: l_msg_data VARCHAR2(2000);
94: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
95: l_spec GMD_SPECIFICATIONS%ROWTYPE;
96: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
97: l_spec_tests GMD_SPEC_TESTS%ROWTYPE;
98: l_spec_tests_out GMD_SPEC_TESTS%ROWTYPE;
99: l_spec_tests_tbl GMD_SPEC_PUB.spec_tests_tbl;
100: l_spec_id NUMBER;

Line 185: -- Need to create the header (gmd_specifications) so validate the spec data

181: -- Ensure spec_id is null
182: -- ======================
183: l_spec.spec_id := NULL;
184:
185: -- Need to create the header (gmd_specifications) so validate the spec data
186: -- ========================================================================
187: GMD_SPEC_GRP.Validate_Spec_Header (
188: p_spec_header => l_spec
189: , p_called_from => 'API'

Line 205: IF NOT GMD_Specifications_PVT.INSERT_ROW(p_spec => l_spec)

201: l_spec.last_updated_by := l_user_id;
202:
203: -- Insert SPEC
204: -- ===========
205: IF NOT GMD_Specifications_PVT.INSERT_ROW(p_spec => l_spec)
206: THEN
207: GMD_API_PUB.Log_Message('GMD_FAILED_TO_INSERT_ROW',
208: 'l_table_name', 'GMD_SPECIFICATIONS',
209: 'l_column_name', 'SPEC_ID',

Line 208: 'l_table_name', 'GMD_SPECIFICATIONS',

204: -- ===========
205: IF NOT GMD_Specifications_PVT.INSERT_ROW(p_spec => l_spec)
206: THEN
207: GMD_API_PUB.Log_Message('GMD_FAILED_TO_INSERT_ROW',
208: 'l_table_name', 'GMD_SPECIFICATIONS',
209: 'l_column_name', 'SPEC_ID',
210: 'l_key_value', l_spec.spec_id);
211: RAISE FND_API.G_EXC_ERROR;
212: END IF;

Line 344: 'l_table_name', 'GMD_SPECIFICATIONS',

340: -- Message detailing cause of validation failure is already on
341: -- the stack. But ensure the precise record is identified
342: -- ==========================================================
343: GMD_API_PUB.Log_Message('GMD_API_RECORD_IDENTIFIER',
344: 'l_table_name', 'GMD_SPECIFICATIONS',
345: 'l_column_name', 'SPEC_NAME',
346: 'l_key_value', l_spec.spec_name);
347: RAISE FND_API.G_EXC_ERROR;
348: END IF;

Line 418: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE

414: ( p_api_version IN NUMBER
415: , p_init_msg_list IN VARCHAR2
416: , p_commit IN VARCHAR2
417: , p_validation_level IN VARCHAR2
418: , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
419: , p_user_name IN VARCHAR2
420: , x_deleted_rows OUT NOCOPY NUMBER
421: , x_return_status OUT NOCOPY VARCHAR2
422: , x_msg_count OUT NOCOPY NUMBER

Line 431: l_spec GMD_SPECIFICATIONS%ROWTYPE;

427: l_api_version CONSTANT NUMBER := 1.0;
428: l_msg_count NUMBER :=0;
429: l_msg_data VARCHAR2(2000);
430: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
431: l_spec GMD_SPECIFICATIONS%ROWTYPE;
432: l_deleted_rows NUMBER :=0;
433:
434: BEGIN
435:

Line 494: IF NOT GMD_Specifications_PVT.Lock_Row(p_spec.spec_id)

490: END IF;
491:
492: -- Lock the row ahead of delete marking
493: -- ====================================
494: IF NOT GMD_Specifications_PVT.Lock_Row(p_spec.spec_id)
495: THEN
496: -- Report Failure to obtain locks
497: -- ==============================
498: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

Line 499: 'l_table_name', 'GMD_SPECIFICATIONS',

495: THEN
496: -- Report Failure to obtain locks
497: -- ==============================
498: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
499: 'l_table_name', 'GMD_SPECIFICATIONS',
500: 'l_column_name', 'SPEC_ID',
501: 'l_key_value', p_spec.spec_id);
502: RAISE FND_API.G_EXC_ERROR;
503: END IF;

Line 505: IF NOT GMD_Specifications_PVT.Mark_for_Delete ( p_spec_id => p_spec.spec_id

501: 'l_key_value', p_spec.spec_id);
502: RAISE FND_API.G_EXC_ERROR;
503: END IF;
504:
505: IF NOT GMD_Specifications_PVT.Mark_for_Delete ( p_spec_id => p_spec.spec_id
506: , p_last_update_date => sysdate
507: , p_last_updated_by => l_spec.last_updated_by
508: )
509: THEN

Line 511: 'l_table_name', 'GMD_SPECIFICATIONS',

507: , p_last_updated_by => l_spec.last_updated_by
508: )
509: THEN
510: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
511: 'l_table_name', 'GMD_SPECIFICATIONS',
512: 'l_column_name', 'SPEC_ID',
513: 'l_key_value', p_spec.spec_id);
514: ELSE -- Report one row successfully delete marked
515: x_deleted_rows := 1;

Line 662: IF NOT GMD_Specifications_PVT.Lock_Row(l_spec_tests.spec_id)

658: l_spec_id := l_spec_tests.spec_id;
659:
660: -- Lock the SPEC ahead of manipulating SPEC_TESTS
661: -- ===============================================
662: IF NOT GMD_Specifications_PVT.Lock_Row(l_spec_tests.spec_id)
663: THEN
664: -- Report Failure to obtain locks
665: -- ==============================
666: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

Line 667: 'l_table_name', 'GMD_SPECIFICATIONS',

663: THEN
664: -- Report Failure to obtain locks
665: -- ==============================
666: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
667: 'l_table_name', 'GMD_SPECIFICATIONS',
668: 'l_column_name', 'SPEC_ID',
669: 'l_key_value', l_spec_tests.spec_id);
670: RAISE FND_API.G_EXC_ERROR;
671: END IF;