APPS.GMD_SPEC_VRS_PUB dependencies on GMD_WIP_SPEC_VRS

Line 231: | into gmd_wip_spec_vrs |

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

Line 262: l_wip_spec_vrs GMD_WIP_SPEC_VRS%ROWTYPE;

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

Line 263: l_wip_spec_vrs_out GMD_WIP_SPEC_VRS%ROWTYPE;

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

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

342: END IF;
343:
344: l_wip_spec_vrs := l_wip_spec_vrs_out;
345:
346: IF NOT GMD_WIP_SPEC_VRS_PVT.Insert_Row(l_wip_spec_vrs, l_wip_spec_vrs_out)
347: THEN
348: -- Diagnostic message is already on the stack
349: RAISE FND_API.G_EXC_ERROR;
350: END IF;

Line 1188: l_wip_spec_vrs GMD_WIP_SPEC_VRS%ROWTYPE;

1184: l_msg_count NUMBER :=0;
1185: l_msg_data VARCHAR2(2000);
1186: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
1187: l_spec GMD_SPECIFICATIONS%ROWTYPE;
1188: l_wip_spec_vrs GMD_WIP_SPEC_VRS%ROWTYPE;
1189: l_deleted_rows NUMBER :=0;
1190:
1191: BEGIN
1192:

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

1286:
1287:
1288: -- Lock the validity rule ahead of deleting
1289: -- ========================================
1290: IF NOT GMD_WIP_SPEC_VRS_PVT.Lock_Row( l_wip_spec_vrs.spec_vr_id)
1291: THEN
1292: -- Report Failure to obtain locks
1293: -- ==============================
1294: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',

Line 1295: 'l_table_name', 'GMD_WIP_SPEC_VRS',

1291: THEN
1292: -- Report Failure to obtain locks
1293: -- ==============================
1294: GMD_API_PUB.Log_Message('GMD_LOCKING_FAILURE',
1295: 'l_table_name', 'GMD_WIP_SPEC_VRS',
1296: 'l_column_name', 'SPEC_VR_ID',
1297: 'l_key_value', l_wip_spec_vrs.spec_vr_id);
1298: RAISE FND_API.G_EXC_ERROR;
1299: END IF;

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

1297: 'l_key_value', l_wip_spec_vrs.spec_vr_id);
1298: RAISE FND_API.G_EXC_ERROR;
1299: END IF;
1300:
1301: IF NOT GMD_WIP_SPEC_VRS_PVT.Delete_Row ( p_spec_vr_id => l_wip_spec_vrs.spec_vr_id
1302: , p_last_update_date => sysdate
1303: , p_last_updated_by => l_spec.last_updated_by
1304: )
1305: THEN

Line 1307: 'l_table_name', 'GMD_WIP_SPEC_VRS',

1303: , p_last_updated_by => l_spec.last_updated_by
1304: )
1305: THEN
1306: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
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: ELSE