[Home] [Help]
2: --$Header: PAXMCRUB.pls 120.9.12020000.3 2013/03/22 10:05:53 rvadali ship $
3:
4: /*----------------------------------------------------------------------------------------+
5: | Procedure : event_amount_conversion |
6: | Purpose : To update the pa_events table (bill transaction currency to |
7: | revenue processing currency |
8: | Parameters : |
9: | ================================================================================== |
10: | Name Mode Description |
91: revproc_rate_type,
92: revproc_rate_date,
93: revproc_exchange_rate,
94: 'N' /* Bug 2563738 */
95: FROM pa_events v
96: WHERE v.project_id = p_project_id
97: AND v.request_id = p_request_id
98: AND v. revenue_distributed_flag = 'D'
99: AND nvl(v.task_id, -1) IN
143: revproc_rate_date,
144: revproc_exchange_rate,
145: DECODE(vt.event_type_classification , 'REALIZED_GAINS', 'Y',
146: 'REALIZED_LOSSES', 'Y','N')
147: FROM pa_events evt,
148: pa_event_types vt
149: WHERE evt.project_id = p_project_id
150: AND evt.request_id = p_request_id
151: AND evt.revenue_distributed_flag = 'D'
550:
551:
552:
553:
554: /* Updating pa_events table with all converted amounts. Set the
555: revenue_distributed flag = 'N' if conversion fails,
556: so that this event will pick up next time revenue distribution */
557:
558:
559: /* Bug : 2563738 - Ignore the project amount and attributes if event type is realized gain and loss event
560: l_rgain_rloss_flag = 'Y' (realized_gain and realized_loss event ) */
561:
562: FORALL I IN 1 .. l_event_id_tab.COUNT
563: UPDATE pa_events
564: SET project_revenue_amount =
565: DECODE(l_project_status_tab(i), 'N',
566: (DECODE(l_projfunc_status_tab(i), 'N',l_project_amount_tab(i), NULL)), NULL),
567: project_rate_type =