APPS.GMD_SPEC_VRS_PUB dependencies on GMD_WIP_SPEC_VRS

Line 235: | into gmd_wip_spec_vrs |

231: | |
232: | DESCRIPTION |
233: | Accepts a table of wip_spec_vrs definitions. Validates |
234: | each table entry and where valid, inserts a corresponding row |
235: | into gmd_wip_spec_vrs |
236: | In the case of any failure a rollback is instigated. |
237: | |
238: | HISTORY |
239: | 03-AUG-2002 K.Y.Hunt |

Line 266: l_wip_spec_vrs GMD_WIP_SPEC_VRS%ROWTYPE;

262: l_msg_count NUMBER :=0;
263: l_msg_data VARCHAR2(2000);
264: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
265: l_spec GMD_SPECIFICATIONS%ROWTYPE;
266: l_wip_spec_vrs GMD_WIP_SPEC_VRS%ROWTYPE;
267: l_wip_spec_vrs_out GMD_WIP_SPEC_VRS%ROWTYPE;
268: l_wip_spec_vrs_tbl GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl;
269: l_rowid ROWID;
270: l_user_id NUMBER(15);

Line 267: l_wip_spec_vrs_out GMD_WIP_SPEC_VRS%ROWTYPE;

263: l_msg_data VARCHAR2(2000);
264: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
265: l_spec GMD_SPECIFICATIONS%ROWTYPE;
266: l_wip_spec_vrs GMD_WIP_SPEC_VRS%ROWTYPE;
267: l_wip_spec_vrs_out GMD_WIP_SPEC_VRS%ROWTYPE;
268: l_wip_spec_vrs_tbl GMD_SPEC_VRS_PUB.wip_spec_vrs_tbl;
269: l_rowid ROWID;
270: l_user_id NUMBER(15);
271:

Line 352: IF NOT GMD_WIP_SPEC_VRS_PVT.Insert_Row(l_wip_spec_vrs, l_wip_spec_vrs_out)

348: END IF;
349:
350: l_wip_spec_vrs := l_wip_spec_vrs_out;
351:
352: IF NOT GMD_WIP_SPEC_VRS_PVT.Insert_Row(l_wip_spec_vrs, l_wip_spec_vrs_out)
353: THEN
354: -- Diagnostic message is already on the stack
355: RAISE FND_API.G_EXC_ERROR;
356: END IF;

Line 1200: l_wip_spec_vrs GMD_WIP_SPEC_VRS%ROWTYPE;

1196: l_msg_count NUMBER :=0;
1197: l_msg_data VARCHAR2(2000);
1198: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
1199: l_spec GMD_SPECIFICATIONS%ROWTYPE;
1200: l_wip_spec_vrs GMD_WIP_SPEC_VRS%ROWTYPE;
1201: l_deleted_rows NUMBER :=0;
1202:
1203: BEGIN
1204:

Line 1302: IF NOT GMD_WIP_SPEC_VRS_PVT.Lock_Row( l_wip_spec_vrs.spec_vr_id)

1298:
1299:
1300: -- Lock the validity rule ahead of deleting
1301: -- ========================================
1302: IF NOT GMD_WIP_SPEC_VRS_PVT.Lock_Row( l_wip_spec_vrs.spec_vr_id)
1303: THEN
1304: -- Report Failure to obtain locks
1305: -- ==============================
1306: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

Line 1307: 'l_table_name', 'GMD_WIP_SPEC_VRS',

1303: THEN
1304: -- Report Failure to obtain locks
1305: -- ==============================
1306: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1307: 'l_table_name', 'GMD_WIP_SPEC_VRS',
1308: 'l_column_name', 'SPEC_VR_ID',
1309: 'l_key_value', l_wip_spec_vrs.spec_vr_id);
1310: RAISE FND_API.G_EXC_ERROR;
1311: END IF;

Line 1313: IF NOT GMD_WIP_SPEC_VRS_PVT.Delete_Row ( p_spec_vr_id => l_wip_spec_vrs.spec_vr_id

1309: 'l_key_value', l_wip_spec_vrs.spec_vr_id);
1310: RAISE FND_API.G_EXC_ERROR;
1311: END IF;
1312:
1313: IF NOT GMD_WIP_SPEC_VRS_PVT.Delete_Row ( p_spec_vr_id => l_wip_spec_vrs.spec_vr_id
1314: , p_last_update_date => sysdate
1315: , p_last_updated_by => l_spec.last_updated_by
1316: )
1317: THEN

Line 1319: 'l_table_name', 'GMD_WIP_SPEC_VRS',

1315: , p_last_updated_by => l_spec.last_updated_by
1316: )
1317: THEN
1318: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
1319: 'l_table_name', 'GMD_WIP_SPEC_VRS',
1320: 'l_column_name', 'SPEC_VR_ID',
1321: 'l_key_value', l_wip_spec_vrs.spec_vr_id);
1322: RAISE FND_API.G_EXC_ERROR;
1323: ELSE