DBA Data[Home] [Help]

APPS.GME_RESOURCE_ENGINE_PVT dependencies on GME_UPDATE_STEP_QTY_PVT

Line 919: -- If called from gme_update_step_qty_pvt.reduce_pending_usage, then we need to order the resources by usage ASC

915: || 'DEL'
916: || ''''
917: || ')'
918: --nsinghi bug#5609683
919: -- If called from gme_update_step_qty_pvt.reduce_pending_usage, then we need to order the resources by usage ASC
920: -- so that the remaining usage gets factored in for the remaining pending resource txn.
921: -- || ' AND delete_mark <> 1 ORDER BY completed_ind, poc_trans_id ';
922: || ' AND delete_mark <> 1 ';
923:

Line 1200: gme_update_step_qty_pvt.adjust_pending_usage

1196:
1197: IF p_action_code IN ('INSERT', 'UPDATE') THEN
1198: IF l_batch_header.update_inventory_ind = 'Y' THEN
1199: IF l_batch_step.step_status = 1 THEN
1200: gme_update_step_qty_pvt.adjust_pending_usage
1201: (p_batch_step_resources_rec => x_step_resources_rec
1202: ,x_return_status => l_return_status);
1203:
1204: IF l_return_status <> x_return_status THEN

Line 1209: gme_update_step_qty_pvt.adjust_actual_usage

1205: RAISE fnd_api.g_exc_error;
1206: END IF;
1207: ELSIF l_batch_step.step_status > 1
1208: AND NVL (x_step_resources_rec.actual_rsrc_usage, -1) >= 0 THEN
1209: gme_update_step_qty_pvt.adjust_actual_usage
1210: (p_batch_step_resources_rec => x_step_resources_rec
1211: ,x_return_status => l_return_status);
1212:
1213: IF l_return_status <> x_return_status THEN

Line 1342: gme_update_step_qty_pvt.recalculate_charges(

1338: END IF;
1339:
1340: ELSIF p_action_code IN ('INSERT', 'DELETE') THEN
1341: --call recalculate charges procedure with R as p_cal_type
1342: gme_update_step_qty_pvt.recalculate_charges(
1343: p_batchstep_rec => l_batch_step
1344: ,p_cal_type => 'R'
1345: ,x_batchstep_rec => x_batch_step
1346: ,x_return_status => l_return_status );

Line 2976: gme_update_step_qty_pvt.reduce_pending_usage

2972: IF l_return_status <> x_return_status THEN
2973: RAISE error_load_trans;
2974: END IF;
2975:
2976: gme_update_step_qty_pvt.reduce_pending_usage
2977: (p_batch_step_resources_rec => l_step_resources
2978: ,x_return_status => x_return_status);
2979:
2980: IF x_return_status <> 'S' THEN

Line 3272: gme_update_step_qty_pvt.reduce_pending_usage

3268: IF l_return_status <> x_return_status THEN
3269: RAISE error_load_trans;
3270: END IF;
3271:
3272: gme_update_step_qty_pvt.reduce_pending_usage
3273: (p_batch_step_resources_rec => l_step_resources
3274: ,x_return_status => x_return_status);
3275:
3276: IF x_return_status <> 'S' THEN

Line 3873: gme_update_step_qty_pvt.reduce_pending_usage

3869: IF l_return_status <> x_return_status THEN
3870: RAISE error_load_trans;
3871: END IF;
3872:
3873: gme_update_step_qty_pvt.reduce_pending_usage
3874: (p_batch_step_resources_rec => l_step_resources
3875: ,x_return_status => x_return_status);
3876:
3877: IF x_return_status <> 'S' THEN