DBA Data[Home] [Help]

APPS.GMO_VBATCH_TASK_PVT dependencies on GME_BATCH_STEPS

Line 1556: l_batch_step_details gme_batch_steps%ROWTYPE;

1552: x_message_count OUT NOCOPY NUMBER
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;

Line 1558: vo_batch_step_details gme_batch_steps%ROWTYPE;

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);
1562:

Line 1560: x_batch_step_rec gme_batch_steps%ROWTYPE;

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);
1562:
1563: x_validate_status VARCHAR2(1);
1564: l_batch_no VARCHAR2(32);

Line 1577: FROM gme_batch_steps

1573: IF(v_batch_id=0) THEN
1574:
1575: SELECT batch_id
1576: INTO v_batch_id
1577: FROM gme_batch_steps
1578: WHERE batchstep_id=p_batchstep_id;
1579: END IF;
1580:
1581: /*Fetching the batch step details based on the batch_id and batchstep_id*/

Line 1585: FROM gme_batch_steps

1581: /*Fetching the batch step details based on the batch_id and batchstep_id*/
1582:
1583: SELECT *
1584: INTO l_batch_step_details
1585: FROM gme_batch_steps
1586: WHERE batchstep_id=p_batchstep_id
1587: AND batch_id=v_batch_id;
1588:
1589: /*Fetching the batch details based on the batch_id */