APPS.PA_MCB_REVENUE_PKG dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 655: | Purpose : To update the pa_expenditure_items_all table

651:
652:
653: /*----------------------------------------------------------------------------------------+
654: | Procedure : ei_amount_conversion |
655: | Purpose : To update the pa_expenditure_items_all table
656: | (bill transaction currency to revenue processing currency
657: |
658: | Parameters : |
659: | ================================================================================== |

Line 689: FROM pa_expenditure_items_all

685: expenditure_item_date, /* Added for bug 5907315*/
686: bill_trans_raw_revenue,
687: bill_trans_adjusted_revenue,
688: bill_trans_currency_code
689: FROM pa_expenditure_items_all
690: WHERE request_id = p_request_id
691: AND revenue_distributed_flag = 'D'
692: AND bill_trans_raw_revenue IS NOT NULL
693: AND raw_revenue IS NULL;

Line 1274: UPDATE pa_expenditure_items_all

1270: PA_MCB_INVOICE_PKG.log_message('ei_amount_conversion: ' || 'Inside If statement .....');
1271: END IF;
1272:
1273: FORALL I IN 1 ..l_ei_id_tab.COUNT
1274: UPDATE pa_expenditure_items_all
1275: SET raw_revenue =
1276: DECODE(l_final_error_status_tab(i), 'N', l_revproc_amount_tab(i), NULL),
1277: adjusted_revenue =
1278: DECODE(l_final_error_status_tab(i), 'N',

Line 1405: pa_expenditure_items_all ei

1401: RDL.REVPROC_REVTRANS_RATE_TYPE,
1402: RDL.REVPROC_REVTRANS_RATE_DATE,
1403: RDL.REVPROC_REVTRANS_EX_RATE
1404: FROM pa_cust_rev_dist_lines rdl,
1405: pa_expenditure_items_all ei
1406: WHERE rdl.project_id = p_project_id
1407: AND ei.expenditure_item_id = rdl.expenditure_item_id
1408: AND rdl.request_id = p_request_id
1409: AND rdl.bill_trans_amount is NULL ;

Line 2528: | Purpose : To update the pa_expenditure_items_all table

2524:
2525:
2526: /*----------------------------------------------------------------------------------------+
2527: | Procedure : ei_fcst_amount_conversion |
2528: | Purpose : To update the pa_expenditure_items_all table
2529: | (bill transaction currency to revenue processing currency for |
2530: | forecast revenue
2531: | Parameters : |
2532: | ================================================================================== |

Line 2560: FROM pa_expenditure_items_all

2556: SELECT project_id, /* 2456371 */
2557: expenditure_item_id,
2558: bill_trans_forecast_revenue,
2559: bill_trans_forecast_curr_code
2560: FROM pa_expenditure_items_all
2561: WHERE request_id = p_request_id
2562: AND revenue_distributed_flag = 'F'
2563: AND bill_trans_forecast_revenue IS NOT NULL
2564: AND forecast_revenue IS NULL

Line 2958: UPDATE pa_expenditure_items_all

2954: distributed flag to 'N */
2955:
2956:
2957: FORALL I IN 1 ..l_ei_id_tab.COUNT
2958: UPDATE pa_expenditure_items_all
2959: SET forecast_revenue =
2960: DECODE(l_raw_rev_status_tab(i), 'N', l_revproc_amount_tab(i), NULL),
2961: projfunc_fcst_rate_type = l_revproc_rate_type_tab(i),
2962: projfunc_fcst_rate_date = l_revproc_rate_date_tab(i),