DBA Data[Home] [Help]

APPS.GME_UPDATE_STEP_QTY_PVT dependencies on GME_RESOURCE_ENGINE_PVT

Line 2132: gme_resource_engine_pvt.fetch_active_resources

2128: l_resource_txns.poc_trans_id := NULL;
2129: l_resource_txns.doc_id := NULL;
2130: l_resource_txns.line_id :=
2131: p_batch_step_resources_rec.batchstep_resource_id;
2132: gme_resource_engine_pvt.fetch_active_resources
2133: (p_resource_rec => l_resource_txns
2134: ,x_resource_tbl => l_resource_tab
2135: ,x_return_status => l_return_status);
2136:

Line 2227: gme_resource_engine_pvt.delete_resource_trans

2223: FOR i IN 1 .. l_resource_tab.COUNT LOOP
2224: IF (l_resource_tab (i).overrided_protected_ind <> 'Y')
2225: AND (l_resource_tab (i).completed_ind = 1) THEN
2226: l_resource_txns := l_resource_tab (i);
2227: gme_resource_engine_pvt.delete_resource_trans
2228: (p_tran_rec => l_resource_txns
2229: ,x_return_status => l_return_status);
2230:
2231: IF l_return_status <> x_return_status THEN

Line 2365: gme_resource_engine_pvt.fetch_active_resources

2361:
2362: --nsinghi bug#5609683
2363: --calling the procedure with additional parameter p_calling_mode.
2364: --For reducing pending resource usage, we need to fetch the resources in ascending order of resource usage.
2365: gme_resource_engine_pvt.fetch_active_resources
2366: (p_resource_rec => l_resource_txns
2367: ,p_calling_mode => 'REDUCE_USAGE'
2368: ,x_resource_tbl => l_resource_tab
2369: ,x_return_status => l_return_status);

Line 2472: gme_resource_engine_pvt.update_resource_trans

2468: -- l_resource_txns.start_date :=
2469: -- l_resource_txns.end_date
2470: -- - (l_resource_txns.resource_usage / 24);
2471:
2472: gme_resource_engine_pvt.update_resource_trans
2473: (p_tran_rec => l_resource_txns
2474: ,x_return_status => l_return_status);
2475:
2476: IF l_return_status <> x_return_status THEN

Line 2481: gme_resource_engine_pvt.delete_resource_trans

2477: RAISE fnd_api.g_exc_error;
2478: END IF;
2479: ELSIF l_step_status > gme_common_pvt.g_step_wip THEN
2480: /* If the step is certified then their shouldn't be any further pending transactions */
2481: gme_resource_engine_pvt.delete_resource_trans
2482: (p_tran_rec => l_resource_txns
2483: ,x_return_status => l_return_status);
2484:
2485: IF l_return_status <> x_return_status THEN