APPS.GME_SCALE_BATCH_PVT dependencies on GME_BATCH_STEP_RESOURCES

Line 1409: l_gme_batchstep_resources gme_batch_step_resources%ROWTYPE;

1405: l_auto_step_calc NUMBER (5);
1406: l_batch_step gme_batch_steps%ROWTYPE;
1407: l_in_batch_step gme_batch_steps%ROWTYPE;
1408: l_batchstep_resource_ids gme_common_pvt.number_tab;
1409: l_gme_batchstep_resources gme_batch_step_resources%ROWTYPE;
1410: l_gme_resource_txns_gtmp gme_resource_txns_gtmp%ROWTYPE;
1411: l_return_status VARCHAR2 (1);
1412: l_message_count NUMBER;
1413: l_message_list VARCHAR2 (2000);

Line 1441: FROM gme_batch_step_resources

1437:
1438: CURSOR cur_get_res (v_step_id gme_batch_steps.batchstep_id%TYPE)
1439: IS
1440: SELECT batchstep_resource_id
1441: FROM gme_batch_step_resources
1442: WHERE batchstep_id = v_step_id AND scale_type <> 0;
1443:
1444: CURSOR cur_get_res_txns (
1445: v_batch_id gme_batch_header.batch_id%TYPE

Line 1446: ,v_res_id gme_batch_step_resources.batchstep_resource_id%TYPE)

1442: WHERE batchstep_id = v_step_id AND scale_type <> 0;
1443:
1444: CURSOR cur_get_res_txns (
1445: v_batch_id gme_batch_header.batch_id%TYPE
1446: ,v_res_id gme_batch_step_resources.batchstep_resource_id%TYPE)
1447: IS
1448: SELECT poc_trans_id
1449: FROM gme_resource_txns_gtmp
1450: WHERE doc_id = v_batch_id AND line_id = v_res_id;

Line 1545: IF NOT (gme_batch_step_resources_dbl.fetch_row

1541: FOR i IN 1 .. l_batchstep_resource_ids.COUNT LOOP
1542: l_gme_batchstep_resources.batchstep_resource_id :=
1543: l_batchstep_resource_ids (i);
1544:
1545: IF NOT (gme_batch_step_resources_dbl.fetch_row
1546: (l_gme_batchstep_resources
1547: ,l_gme_batchstep_resources) ) THEN
1548: RAISE activity_rsrc_fetch_error;
1549: END IF;

Line 1585: IF NOT (gme_batch_step_resources_dbl.update_row

1581: RAISE update_res_txn_error;
1582: END IF;
1583: END IF; /* IF l_update_inventory_ind = 'Y' */
1584:
1585: IF NOT (gme_batch_step_resources_dbl.update_row
1586: (l_gme_batchstep_resources) ) THEN
1587: RAISE update_res_error;
1588: END IF;
1589: END LOOP; /* FOR i IN 1..l_batchstep_resource_ids.COUNT */