DBA Data[Home] [Help]

APPS.GME_RESOURCE_ENGINE_PVT dependencies on GME_UPDATE_STEP_QTY_PVT

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

1026: || 'DEL'
1027: || ''''
1028: || ')'
1029: --nsinghi bug#5609683
1030: -- If called from gme_update_step_qty_pvt.reduce_pending_usage, then we need to order the resources by usage ASC
1031: -- so that the remaining usage gets factored in for the remaining pending resource txn.
1032: -- || ' AND delete_mark <> 1 ORDER BY completed_ind, poc_trans_id ';
1033: || ' AND delete_mark <> 1 ';
1034:

Line 1320: gme_update_step_qty_pvt.adjust_pending_usage

1316:
1317: IF p_action_code IN ('INSERT', 'UPDATE') THEN
1318: IF l_batch_header.update_inventory_ind = 'Y' THEN
1319: IF l_batch_step.step_status = 1 THEN
1320: gme_update_step_qty_pvt.adjust_pending_usage
1321: (p_batch_step_resources_rec => x_step_resources_rec
1322: ,x_return_status => l_return_status);
1323:
1324: IF l_return_status <> x_return_status THEN

Line 1329: gme_update_step_qty_pvt.adjust_actual_usage

1325: RAISE fnd_api.g_exc_error;
1326: END IF;
1327: ELSIF l_batch_step.step_status > 1
1328: AND NVL (x_step_resources_rec.actual_rsrc_usage, -1) >= 0 THEN
1329: gme_update_step_qty_pvt.adjust_actual_usage
1330: (p_batch_step_resources_rec => x_step_resources_rec
1331: ,x_return_status => l_return_status);
1332:
1333: IF l_return_status <> x_return_status THEN

Line 1462: gme_update_step_qty_pvt.recalculate_charges(

1458: END IF;
1459:
1460: ELSIF p_action_code IN ('INSERT', 'DELETE') THEN
1461: --call recalculate charges procedure with R as p_cal_type
1462: gme_update_step_qty_pvt.recalculate_charges(
1463: p_batchstep_rec => l_batch_step
1464: ,p_cal_type => 'R'
1465: ,x_batchstep_rec => x_batch_step
1466: ,x_return_status => l_return_status );

Line 3132: gme_update_step_qty_pvt.reduce_pending_usage

3128: IF l_return_status <> x_return_status THEN
3129: RAISE error_load_trans;
3130: END IF;
3131:
3132: gme_update_step_qty_pvt.reduce_pending_usage
3133: (p_batch_step_resources_rec => l_step_resources
3134: ,x_return_status => x_return_status);
3135:
3136: IF x_return_status <> 'S' THEN

Line 3464: gme_update_step_qty_pvt.reduce_pending_usage

3460: IF l_return_status <> x_return_status THEN
3461: RAISE error_load_trans;
3462: END IF;
3463:
3464: gme_update_step_qty_pvt.reduce_pending_usage
3465: (p_batch_step_resources_rec => l_step_resources
3466: ,x_return_status => x_return_status);
3467:
3468: IF x_return_status <> 'S' THEN

Line 4068: gme_update_step_qty_pvt.reduce_pending_usage

4064: IF l_return_status <> x_return_status THEN
4065: RAISE error_load_trans;
4066: END IF;
4067:
4068: gme_update_step_qty_pvt.reduce_pending_usage
4069: (p_batch_step_resources_rec => l_step_resources
4070: ,x_return_status => x_return_status);
4071:
4072: IF x_return_status <> 'S' THEN