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 5919299*
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 944: FROM pa_expenditure_items_all

940: l_bill_trans_adj_rev_tab(j),
941: l_bill_trans_curr_code_tab(j),
942: l_revenue_distributed_flag_tab(j),
943: l_raw_revenue_amount_tab(j)
944: FROM pa_expenditure_items_all
945: WHERE expenditure_item_id = p_ei_id(I)
946: AND revenue_distributed_flag = 'D'
947: AND bill_trans_raw_revenue IS NOT NULL
948: AND raw_revenue IS NULL;

Line 1317: UPDATE pa_expenditure_items_all

1313: PA_MCB_INVOICE_PKG.log_message('ei_amount_conversion: ' || 'Inside If statement .....');
1314: END IF;
1315:
1316: FORALL I IN 1 ..j /*l_ei_id_tab.COUNT Commented for bug 9767275*/
1317: UPDATE pa_expenditure_items_all
1318: SET raw_revenue =
1319: DECODE(l_final_error_status_tab(i), 'N', l_revproc_amount_tab(i), NULL),
1320: adjusted_revenue =
1321: DECODE(l_final_error_status_tab(i), 'N',

Line 1448: pa_expenditure_items_all ei

1444: RDL.REVPROC_REVTRANS_RATE_TYPE,
1445: RDL.REVPROC_REVTRANS_RATE_DATE,
1446: RDL.REVPROC_REVTRANS_EX_RATE
1447: FROM pa_cust_rev_dist_lines rdl,
1448: pa_expenditure_items_all ei
1449: WHERE rdl.project_id = p_project_id
1450: AND ei.expenditure_item_id = rdl.expenditure_item_id
1451: AND rdl.request_id = p_request_id
1452: AND rdl.bill_trans_amount is NULL ;

Line 2572: | Purpose : To update the pa_expenditure_items_all table

2568:
2569:
2570: /*----------------------------------------------------------------------------------------+
2571: | Procedure : ei_fcst_amount_conversion |
2572: | Purpose : To update the pa_expenditure_items_all table
2573: | (bill transaction currency to revenue processing currency for |
2574: | forecast revenue
2575: | Parameters : |
2576: | ================================================================================== |

Line 2604: FROM pa_expenditure_items_all

2600: SELECT project_id, /* 2456371 */
2601: expenditure_item_id,
2602: bill_trans_forecast_revenue,
2603: bill_trans_forecast_curr_code
2604: FROM pa_expenditure_items_all
2605: WHERE request_id = p_request_id
2606: AND revenue_distributed_flag = 'F'
2607: AND bill_trans_forecast_revenue IS NOT NULL
2608: AND forecast_revenue IS NULL

Line 3002: UPDATE pa_expenditure_items_all

2998: distributed flag to 'N */
2999:
3000:
3001: FORALL I IN 1 ..l_ei_id_tab.COUNT
3002: UPDATE pa_expenditure_items_all
3003: SET forecast_revenue =
3004: DECODE(l_raw_rev_status_tab(i), 'N', l_revproc_amount_tab(i), NULL),
3005: projfunc_fcst_rate_type = l_revproc_rate_type_tab(i),
3006: projfunc_fcst_rate_date = l_revproc_rate_date_tab(i),