APPS.PA_MCB_INVOICE_PKG dependencies on PA_EVENTS

Line 8: -- Update pa_events table

4: -- Procedure to
5: -- Convert the Bill Transaction to Invoice Processing
6: -- Bill Transaction to Project Functional
7: -- Bill Transaction to Project
8: -- Update pa_events table
9:
10: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
11:
12: PROCEDURE Event_Convert_amount_bulk (

Line 601: UPDATE pa_events

597:
598:
599: FORALL I IN p_event_num.FIRST..p_event_num.LAST
600: /** Bug 2874486, added decode statement for ensuring all amt fields have same sign as bill_trans_bill_amount */
601: UPDATE pa_events
602: SET bill_amount = decode(SIGN(bill_trans_bill_amount),SIGN(tmp_invproc_bill_amount(i)),
603: tmp_invproc_bill_amount(i),(-1) * tmp_invproc_bill_amount(i)),
604: invproc_currency_code =decode(invproc_currency_code,NULL,
605: tmp_invproc_currency_code(i),invproc_currency_code),

Line 846: FROM pa_events evt, pa_projects_all pr,

842: tmp_projfunc_inv_exch_rate,
843: tmp_projfunc_inv_rate_date,
844: tmp_projfunc_rate_type,
845: tmp_invproc_currency_type
846: FROM pa_events evt, pa_projects_all pr,
847: pa_event_types etyp
848: WHERE evt.project_id = p_project_id
849: AND NVL(evt.task_id,0) = NVL(p_task_id,0)
850: AND evt.event_num = p_event_num

Line 1687: pa_events evt

1683: NVL(dii.event_num,0) event_num,
1684: NVL(evt.revenue_amount,0) revenue_amount
1685: FROM pa_draft_invoices_all di,
1686: pa_draft_invoice_items dii,
1687: pa_events evt
1688: WHERE di.project_id = p_project_id
1689: AND di.project_id = dii.project_id
1690: AND dii.request_id = p_request_id
1691: AND di.request_id = p_request_id