DBA Data[Home] [Help]

APPS.GME_UPDATE_STEP_QTY_PVT dependencies on GME_BATCH_STEP_CHARGES

Line 667: l_batch_step_charges_in gme_batch_step_charges%ROWTYPE;

663: AND scale_type = 2);
664:
665: l_scale_type gme_batch_step_resources.scale_type%TYPE;
666: l_remaining_quantity NUMBER;
667: l_batch_step_charges_in gme_batch_step_charges%ROWTYPE;
668: l_return_status VARCHAR2 (1);
669: l_charge gme_batch_steps.plan_charges%TYPE;
670: l_batch_id NUMBER;
671: l_rsrc_plan_start_date DATE;

Line 901: --Generating the charge details and populating the gme_batch_step_charges table.

897: gme_debug.put_line ('l_scale_type is' || l_scale_type);
898: END IF;
899:
900: IF l_scale_type = 1 THEN
901: --Generating the charge details and populating the gme_batch_step_charges table.
902: l_charge := x_charge;
903:
904: OPEN cur_get_batch_id (p_step_id);
905:

Line 2893: /*DELETE FROM gme_batch_step_charges

2889: gme_debug.put_line('Capacity Resource : '||l_resource);
2890: END IF;
2891:
2892: /*clear the charges */
2893: /*DELETE FROM gme_batch_step_charges
2894: WHERE batchstep_id = l_step_rec.batchstep_id; */
2895: gme_batch_step_chg_pvt.clear_charges(
2896: p_batch_id => x_batchstep_rec.batch_id
2897: ,p_batchstep_id => x_batchstep_rec.batchstep_id