APPS.GMD_SPEC_VRS_PUB dependencies on GMD_MONITORING_SPEC_VRS

Line 783: l_monitoring_spec_vrs GMD_MONITORING_SPEC_VRS%ROWTYPE;

779: l_api_version CONSTANT NUMBER := 1.0;
780: l_msg_count NUMBER :=0;
781: l_msg_data VARCHAR2(2000);
782: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
783: l_monitoring_spec_vrs GMD_MONITORING_SPEC_VRS%ROWTYPE;
784: l_monitoring_spec_vrs_out GMD_MONITORING_SPEC_VRS%ROWTYPE;
785: l_monitoring_spec_vrs_tbl GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl;
786: l_user_id NUMBER(15);
787:

Line 784: l_monitoring_spec_vrs_out GMD_MONITORING_SPEC_VRS%ROWTYPE;

780: l_msg_count NUMBER :=0;
781: l_msg_data VARCHAR2(2000);
782: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
783: l_monitoring_spec_vrs GMD_MONITORING_SPEC_VRS%ROWTYPE;
784: l_monitoring_spec_vrs_out GMD_MONITORING_SPEC_VRS%ROWTYPE;
785: l_monitoring_spec_vrs_tbl GMD_SPEC_VRS_PUB.monitoring_spec_vrs_tbl;
786: l_user_id NUMBER(15);
787:
788: BEGIN

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

874: -- Diagnostic message is already on the stack
875: RAISE FND_API.G_EXC_ERROR;
876: END IF;
877:
878: IF NOT GMD_MONITORING_SPEC_VRS_PVT.Insert_Row(l_monitoring_spec_vrs, l_monitoring_spec_vrs_out)
879: THEN
880: -- Diagnostic message is already on the stack
881: RAISE FND_API.G_EXC_ERROR;
882: END IF;

Line 1832: l_monitoring_spec_vrs GMD_MONITORING_SPEC_VRS%ROWTYPE;

1828: l_msg_count NUMBER :=0;
1829: l_msg_data VARCHAR2(2000);
1830: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
1831: l_spec GMD_SPECIFICATIONS%ROWTYPE;
1832: l_monitoring_spec_vrs GMD_MONITORING_SPEC_VRS%ROWTYPE;
1833: l_deleted_rows NUMBER :=0;
1834:
1835: BEGIN
1836:

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

1931:
1932:
1933: -- Lock the validity rule ahead of deleting
1934: -- ========================================
1935: IF NOT GMD_MONITORING_SPEC_VRS_PVT.Lock_Row( l_monitoring_spec_vrs.spec_vr_id)
1936: THEN
1937: -- Report Failure to obtain locks
1938: -- ==============================
1939: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

Line 1940: 'l_table_name', 'GMD_monitoring_SPEC_VRS',

1936: THEN
1937: -- Report Failure to obtain locks
1938: -- ==============================
1939: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1940: 'l_table_name', 'GMD_monitoring_SPEC_VRS',
1941: 'l_column_name', 'SPEC_VR_ID',
1942: 'l_key_value', l_monitoring_spec_vrs.spec_vr_id);
1943: RAISE FND_API.G_EXC_ERROR;
1944: END IF;

Line 1946: IF NOT GMD_MONITORING_SPEC_VRS_PVT.Delete_Row

1942: 'l_key_value', l_monitoring_spec_vrs.spec_vr_id);
1943: RAISE FND_API.G_EXC_ERROR;
1944: END IF;
1945:
1946: IF NOT GMD_MONITORING_SPEC_VRS_PVT.Delete_Row
1947: ( p_spec_vr_id => l_monitoring_spec_vrs.spec_vr_id
1948: , p_last_update_date => sysdate
1949: , p_last_updated_by => l_spec.last_updated_by
1950: )

Line 1953: 'l_table_name', 'GMD_MONITORING_SPEC_VRS',

1949: , p_last_updated_by => l_spec.last_updated_by
1950: )
1951: THEN
1952: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
1953: 'l_table_name', 'GMD_MONITORING_SPEC_VRS',
1954: 'l_column_name', 'SPEC_VR_ID',
1955: 'l_key_value', l_monitoring_spec_vrs.spec_vr_id);
1956: RAISE FND_API.G_EXC_ERROR;
1957: ELSE