APPS.GME_API_GRP dependencies on GME_BATCH_STEP_RESOURCES

Line 2752: l_step_resources gme_batch_step_resources%ROWTYPE;

2748: l_rsrc_trans_count NUMBER;
2749: l_trans_date DATE;
2750: l_batch_header_rec gme_batch_header%ROWTYPE;
2751: l_rsrc_txn_gtmp_rec gme_resource_txns_gtmp%ROWTYPE;
2752: l_step_resources gme_batch_step_resources%ROWTYPE;
2753: setup_failed EXCEPTION;
2754: create_txn_fail EXCEPTION;
2755: validate_txn_fail EXCEPTION;
2756: uom_conversion_err EXCEPTION;

Line 2826: IF NOT Gme_Batch_Step_Resources_Dbl.fetch_row(p_batch_step_resources => l_step_resources

2822: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2823: RAISE create_txn_fail;
2824: END IF;
2825: l_step_resources.batchstep_resource_id := l_rsrc_txn_gtmp_rec.line_id;
2826: IF NOT Gme_Batch_Step_Resources_Dbl.fetch_row(p_batch_step_resources => l_step_resources
2827: ,x_batch_step_resources => l_step_resources) THEN
2828: RAISE rsrc_fetch_err;
2829: END IF;
2830: l_step_resources.actual_rsrc_usage := NVL (l_step_resources.actual_rsrc_usage, 0) + l_txn_usage;

Line 2844: IF NOT Gme_Batch_Step_Resources_Dbl.update_row(p_batch_step_resources => l_step_resources) THEN

2840: IF l_return_status <> 'S' THEN
2841: RAISE reduce_pend_usage_err;
2842: END IF;
2843: END IF;
2844: IF NOT Gme_Batch_Step_Resources_Dbl.update_row(p_batch_step_resources => l_step_resources) THEN
2845: RAISE rsrc_update_err;
2846: END IF;
2847: IF g_debug <= gme_debug.g_log_procedure THEN
2848: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

Line 2874: l_step_resources gme_batch_step_resources%ROWTYPE;

2870: l_step_status NUMBER;
2871: l_rsrc_trans_count NUMBER;
2872: l_trans_date DATE;
2873: l_batch_header_rec gme_batch_header%ROWTYPE;
2874: l_step_resources gme_batch_step_resources%ROWTYPE;
2875: l_new_step_resources gme_batch_step_resources%ROWTYPE;
2876: error_load_trans EXCEPTION;
2877: setup_failed EXCEPTION;
2878: update_txn_fail EXCEPTION;

Line 2875: l_new_step_resources gme_batch_step_resources%ROWTYPE;

2871: l_rsrc_trans_count NUMBER;
2872: l_trans_date DATE;
2873: l_batch_header_rec gme_batch_header%ROWTYPE;
2874: l_step_resources gme_batch_step_resources%ROWTYPE;
2875: l_new_step_resources gme_batch_step_resources%ROWTYPE;
2876: error_load_trans EXCEPTION;
2877: setup_failed EXCEPTION;
2878: update_txn_fail EXCEPTION;
2879: validate_txn_fail EXCEPTION;

Line 2923: IF NOT Gme_Batch_Step_Resources_Dbl.fetch_row(p_batch_step_resources => l_step_resources

2919: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2920: RAISE update_txn_fail;
2921: END IF;
2922: l_step_resources.batchstep_resource_id := p_rsrc_txn_gtmp_rec.line_id;
2923: IF NOT Gme_Batch_Step_Resources_Dbl.fetch_row(p_batch_step_resources => l_step_resources
2924: ,x_batch_step_resources => l_step_resources) THEN
2925: RAISE rsrc_fetch_err;
2926: END IF;
2927: gme_resource_engine_pvt.get_resource_usage(p_step_resources_rec => l_step_resources

Line 2942: IF NOT gme_batch_step_resources_dbl.update_row(p_batch_step_resources => l_step_resources) THEN

2938: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2939: RAISE reduce_pend_usage_err;
2940: END IF;
2941: END IF;
2942: IF NOT gme_batch_step_resources_dbl.update_row(p_batch_step_resources => l_step_resources) THEN
2943: RAISE upd_rsrc_err;
2944: END IF;
2945: END IF;
2946: IF g_debug <= gme_debug.g_log_procedure THEN

Line 2968: l_step_resources gme_batch_step_resources%ROWTYPE;

2964: l_api_name CONSTANT VARCHAR2 (30) := 'delete_resource_txn';
2965: l_asqc NUMBER;
2966: l_return_status VARCHAR2(1);
2967: l_step_status VARCHAR2(1);
2968: l_step_resources gme_batch_step_resources%ROWTYPE;
2969: l_new_step_resources gme_batch_step_resources%ROWTYPE;
2970: l_rsrc_txn_gtmp_rec gme_resource_txns_gtmp%ROWTYPE;
2971: CURSOR Cur_get_step(v_line_id NUMBER) IS
2972: SELECT s.step_status, h.automatic_step_calculation

Line 2969: l_new_step_resources gme_batch_step_resources%ROWTYPE;

2965: l_asqc NUMBER;
2966: l_return_status VARCHAR2(1);
2967: l_step_status VARCHAR2(1);
2968: l_step_resources gme_batch_step_resources%ROWTYPE;
2969: l_new_step_resources gme_batch_step_resources%ROWTYPE;
2970: l_rsrc_txn_gtmp_rec gme_resource_txns_gtmp%ROWTYPE;
2971: CURSOR Cur_get_step(v_line_id NUMBER) IS
2972: SELECT s.step_status, h.automatic_step_calculation
2973: FROM gme_batch_steps s, gme_batch_step_activities a, gme_batch_step_resources r, gme_batch_header h

Line 2973: FROM gme_batch_steps s, gme_batch_step_activities a, gme_batch_step_resources r, gme_batch_header h

2969: l_new_step_resources gme_batch_step_resources%ROWTYPE;
2970: l_rsrc_txn_gtmp_rec gme_resource_txns_gtmp%ROWTYPE;
2971: CURSOR Cur_get_step(v_line_id NUMBER) IS
2972: SELECT s.step_status, h.automatic_step_calculation
2973: FROM gme_batch_steps s, gme_batch_step_activities a, gme_batch_step_resources r, gme_batch_header h
2974: WHERE r.batchstep_resource_id = v_line_id
2975: AND a.batchstep_activity_id = r.batchstep_activity_id
2976: AND s.batchstep_id = a.batchstep_id
2977: AND h.batch_id = s.batch_id;

Line 3018: IF NOT Gme_Batch_Step_Resources_Dbl.fetch_row(p_batch_step_resources => l_step_resources

3014: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3015: RAISE delete_txn_fail;
3016: END IF;
3017: l_step_resources.batchstep_resource_id := p_rsrc_txn_gtmp_rec.line_id;
3018: IF NOT Gme_Batch_Step_Resources_Dbl.fetch_row(p_batch_step_resources => l_step_resources
3019: ,x_batch_step_resources => l_step_resources) THEN
3020: RAISE rsrc_fetch_err;
3021: END IF;
3022: gme_resource_engine_pvt.get_resource_usage(p_step_resources_rec => l_step_resources

Line 3037: IF NOT gme_batch_step_resources_dbl.update_row(p_batch_step_resources => l_step_resources) THEN

3033: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3034: RAISE reduce_pend_usage_err;
3035: END IF;
3036: END IF;
3037: IF NOT gme_batch_step_resources_dbl.update_row(p_batch_step_resources => l_step_resources) THEN
3038: RAISE upd_rsrc_err;
3039: END IF;
3040: END IF;
3041: IF g_debug <= gme_debug.g_log_procedure THEN