DBA Data[Home] [Help]

APPS.GMO_VBATCH_TASK_PVT dependencies on GME_BATCH_HEADER

Line 437: l_batch_record gme_batch_header%rowtype;

433: x_return_status OUT NOCOPY VARCHAR2,
434: x_message_count OUT NOCOPY NUMBER,
435: x_message_data OUT NOCOPY VARCHAR2
436: ) AS
437: l_batch_record gme_batch_header%rowtype;
438: l_rsrc_row_count number;
439: BEGIN
440:
441: if (gme_common_pvt.setup(p_org_id => p_org_id, p_org_code => p_org_code)) then

Line 446: select * into l_batch_record from gme_batch_header where batch_id = p_batch_id;

442: x_return_status := 'S';
443: else
444: x_return_status := 'E';
445: end if;
446: select * into l_batch_record from gme_batch_header where batch_id = p_batch_id;
447: gme_trans_engine_util.load_rsrc_trans (p_batch_row =>l_batch_record, x_rsc_row_count => l_rsrc_row_count, x_return_status => x_return_status);
448: FND_MSG_PUB.Count_And_Get (p_count => x_message_count, p_data => x_message_data);
449: END setup_resource_transaction;
450:

Line 1557: l_batch_header gme_batch_header%ROWTYPE;

1553:
1554: ) IS
1555:
1556: l_batch_step_details gme_batch_steps%ROWTYPE;
1557: l_batch_header gme_batch_header%ROWTYPE;
1558: vo_batch_step_details gme_batch_steps%ROWTYPE;
1559: vo_exception_material_tbl gme_common_pvt.exceptions_tab;
1560: x_batch_step_rec gme_batch_steps%ROWTYPE;
1561: v_batch_id NUMBER(15);

Line 1593: FROM gme_batch_header

1589: /*Fetching the batch details based on the batch_id */
1590:
1591: SELECT *
1592: INTO l_batch_header
1593: FROM gme_batch_header
1594: WHERE batch_id=v_batch_id;
1595: --checks for step dependencies
1596: gme_release_batch_step_pvt.validate_step_for_release
1597: ( p_batch_header_rec => l_batch_header