[Home] [Help]
1306:
1307: -- Bug 12576806 - Initialize org id.
1308: x_step_resources_rec.organization_id := l_batch_header.organization_id;
1309:
1310: IF NOT (gme_batch_step_resources_dbl.insert_row
1311: (p_batch_step_resources => x_step_resources_rec
1312: ,x_batch_step_resources => x_step_resources_rec) ) THEN
1313: RAISE fnd_api.g_exc_error;
1314: END IF;
1394: /* Update has to be done after updating the transactions as the adjust actual */
1395: /* usage logic depends on the previous actual usage to deduce the usage to be */
1396: /* deducted from the pending resource transactions */
1397: IF p_action_code = 'UPDATE' THEN
1398: IF NOT (gme_batch_step_resources_dbl.update_row
1399: (p_batch_step_resources => x_step_resources_rec) ) THEN
1400: RAISE fnd_api.g_exc_error;
1401: END IF;
1402:
1945: x_return_status := fnd_api.g_ret_sts_success;
1946: x_step_resources_rec.batchstep_resource_id :=
1947: p_step_resources_rec.batchstep_resource_id;
1948:
1949: IF NOT gme_batch_step_resources_dbl.fetch_row
1950: (p_batch_step_resources => x_step_resources_rec
1951: ,x_batch_step_resources => x_step_resources_rec) THEN
1952: RAISE fnd_api.g_exc_error;
1953: END IF;
2841: ,l_batch_header.batch_id);
2842: END IF;
2843:
2844: l_step_resources.batchstep_resource_id := l_rsrc_txn_rec.line_id;
2845: IF NOT gme_batch_step_resources_dbl.fetch_row
2846: (p_batch_step_resources => l_step_resources
2847: ,x_batch_step_resources => l_step_resources) THEN
2848: RAISE rsrc_fetch_err;
2849: END IF;
2850:
2851: l_step_resources.actual_rsrc_count := 1;
2852: l_step_resources.actual_rsrc_usage := l_rsrc_txn_rec.resource_usage;
2853:
2854: IF NOT gme_batch_step_resources_dbl.update_row
2855: (p_batch_step_resources => l_step_resources) THEN
2856: RAISE rsrc_update_err;
2857: END IF;
2858:
3107: -- update resource actual count and usage
3108: -- l_step_resources.batchstep_resource_id := l_resource_txns.line_id;
3109: l_step_resources.batchstep_resource_id := l_rsrc_txn_rec.line_id;
3110:
3111: IF NOT gme_batch_step_resources_dbl.fetch_row
3112: (p_batch_step_resources => l_step_resources
3113: ,x_batch_step_resources => l_step_resources) THEN
3114: RAISE rsrc_fetch_err;
3115: END IF;
3137: RAISE reduce_pend_usage_err;
3138: END IF;
3139: END IF;
3140:
3141: IF NOT gme_batch_step_resources_dbl.update_row
3142: (p_batch_step_resources => l_step_resources) THEN
3143: RAISE rsrc_update_err;
3144: END IF;
3145:
3439: -- update resource actual count and usage
3440: --l_step_resources.batchstep_resource_id := l_resource_txns.line_id;
3441: l_step_resources.batchstep_resource_id := l_rsrc_txn_rec.line_id;
3442:
3443: IF NOT gme_batch_step_resources_dbl.fetch_row
3444: (p_batch_step_resources => l_step_resources
3445: ,x_batch_step_resources => l_step_resources) THEN
3446: RAISE rsrc_fetch_err;
3447: END IF;
3469: RAISE reduce_pend_usage_err;
3470: END IF;
3471: END IF;
3472:
3473: IF NOT gme_batch_step_resources_dbl.update_row
3474: (p_batch_step_resources => l_step_resources) THEN
3475: RAISE rsrc_update_err;
3476: END IF;
3477:
4036: -- update resource actual count and usage
4037: ---l_step_resources.batchstep_resource_id := l_resource_txns.line_id;
4038: l_step_resources.batchstep_resource_id := l_rsrc_txn_rec.line_id;
4039:
4040: IF NOT gme_batch_step_resources_dbl.fetch_row
4041: (p_batch_step_resources => l_step_resources
4042: ,x_batch_step_resources => l_step_resources) THEN
4043: RAISE rsrc_fetch_err;
4044: END IF;
4073: RAISE reduce_pend_usage_err;
4074: END IF;
4075: END IF;
4076:
4077: IF NOT gme_batch_step_resources_dbl.update_row
4078: (p_batch_step_resources => l_step_resources) THEN
4079: RAISE rsrc_update_err;
4080: END IF;
4081: