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_VRS_PUB dependencies on GMD_MONITORING_SPEC_VRS

Line 793: l_monitoring_spec_vrs GMD_MONITORING_SPEC_VRS%ROWTYPE;

789: l_api_version CONSTANT NUMBER := 1.0;
790: l_msg_count NUMBER :=0;
791: l_msg_data VARCHAR2(2000);
792: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
793: l_monitoring_spec_vrs GMD_MONITORING_SPEC_VRS%ROWTYPE;
794: l_monitoring_spec_vrs_out GMD_MONITORING_SPEC_VRS%ROWTYPE;
795: l_monitoring_spec_vrs_tbl GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl;
796: l_user_id NUMBER(15);
797:

Line 794: l_monitoring_spec_vrs_out GMD_MONITORING_SPEC_VRS%ROWTYPE;

790: l_msg_count NUMBER :=0;
791: l_msg_data VARCHAR2(2000);
792: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
793: l_monitoring_spec_vrs GMD_MONITORING_SPEC_VRS%ROWTYPE;
794: l_monitoring_spec_vrs_out GMD_MONITORING_SPEC_VRS%ROWTYPE;
795: l_monitoring_spec_vrs_tbl GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl;
796: l_user_id NUMBER(15);
797:
798: BEGIN

Line 890: IF NOT GMD_MONITORING_SPEC_VRS_PVT.Insert_Row(l_monitoring_spec_vrs, l_monitoring_spec_vrs_out)

886: -- Diagnostic message is already on the stack
887: RAISE FND_API.G_EXC_ERROR;
888: END IF;
889:
890: IF NOT GMD_MONITORING_SPEC_VRS_PVT.Insert_Row(l_monitoring_spec_vrs, l_monitoring_spec_vrs_out)
891: THEN
892: -- Diagnostic message is already on the stack
893: RAISE FND_API.G_EXC_ERROR;
894: END IF;

Line 1844: l_monitoring_spec_vrs GMD_MONITORING_SPEC_VRS%ROWTYPE;

1840: l_msg_count NUMBER :=0;
1841: l_msg_data VARCHAR2(2000);
1842: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
1843: l_spec GMD_SPECIFICATIONS%ROWTYPE;
1844: l_monitoring_spec_vrs GMD_MONITORING_SPEC_VRS%ROWTYPE;
1845: l_deleted_rows NUMBER :=0;
1846:
1847: BEGIN
1848:

Line 1947: IF NOT GMD_MONITORING_SPEC_VRS_PVT.Lock_Row( l_monitoring_spec_vrs.spec_vr_id)

1943:
1944:
1945: -- Lock the validity rule ahead of deleting
1946: -- ========================================
1947: IF NOT GMD_MONITORING_SPEC_VRS_PVT.Lock_Row( l_monitoring_spec_vrs.spec_vr_id)
1948: THEN
1949: -- Report Failure to obtain locks
1950: -- ==============================
1951: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

Line 1952: 'l_table_name', 'GMD_monitoring_SPEC_VRS',

1948: THEN
1949: -- Report Failure to obtain locks
1950: -- ==============================
1951: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1952: 'l_table_name', 'GMD_monitoring_SPEC_VRS',
1953: 'l_column_name', 'SPEC_VR_ID',
1954: 'l_key_value', l_monitoring_spec_vrs.spec_vr_id);
1955: RAISE FND_API.G_EXC_ERROR;
1956: END IF;

Line 1958: IF NOT GMD_MONITORING_SPEC_VRS_PVT.Delete_Row

1954: 'l_key_value', l_monitoring_spec_vrs.spec_vr_id);
1955: RAISE FND_API.G_EXC_ERROR;
1956: END IF;
1957:
1958: IF NOT GMD_MONITORING_SPEC_VRS_PVT.Delete_Row
1959: ( p_spec_vr_id => l_monitoring_spec_vrs.spec_vr_id
1960: , p_last_update_date => sysdate
1961: , p_last_updated_by => l_spec.last_updated_by
1962: )

Line 1965: 'l_table_name', 'GMD_MONITORING_SPEC_VRS',

1961: , p_last_updated_by => l_spec.last_updated_by
1962: )
1963: THEN
1964: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
1965: 'l_table_name', 'GMD_MONITORING_SPEC_VRS',
1966: 'l_column_name', 'SPEC_VR_ID',
1967: 'l_key_value', l_monitoring_spec_vrs.spec_vr_id);
1968: RAISE FND_API.G_EXC_ERROR;
1969: ELSE