eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_XLA_INTF_REV_EVENTS dependencies on PA_DRAFT_REVENUES_ALL

Line 192: --Update event_id of pa_draft_revenues_all with the generated event_id in successful

188: Fetch c_event_cursor BULK COLLECT INTO l_event_id_tab, l_project_id_tab_tmp, l_revenue_num_tab_tmp;
189: Close c_event_cursor;
190:
191:
192: --Update event_id of pa_draft_revenues_all with the generated event_id in successful
193: --cases.
194:
195: IF l_debug_mode = 'Y' THEN
196: PA_MCB_INVOICE_PKG.log_message('PA_XLA_REVENUE_EVENTS.Create_Events : Before draft revenue updation ');

Line 200: UPDATE pa_draft_revenues_all

196: PA_MCB_INVOICE_PKG.log_message('PA_XLA_REVENUE_EVENTS.Create_Events : Before draft revenue updation ');
197: END IF;
198:
199: FORALL l_index IN l_revenue_num_tab_tmp.first .. l_revenue_num_tab_tmp.last
200: UPDATE pa_draft_revenues_all
201: SET event_id = l_event_id_tab(l_index),
202: transfer_rejection_reason = DECODE(sign(nvl(l_event_id_tab(l_index), -1)), 1 , NULL, l_reject_reason)
203: WHERE project_id = l_project_id_tab_tmp(l_index)
204: AND draft_revenue_num = l_revenue_num_tab_tmp(l_index);

Line 233: P_Acct_Event_Id IN PA_Draft_Revenues_All.Event_Id%TYPE

229:
230: END create_events;
231:
232: FUNCTION Get_Sla_Ccid(
233: P_Acct_Event_Id IN PA_Draft_Revenues_All.Event_Id%TYPE
234: ,P_Transfer_Status_Code IN PA_Draft_Revenues_All.Transfer_Status_Code%TYPE
235: ,P_Source_Distribution_Id_Num_1 IN XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE
236: ,P_Source_Distribution_Id_Num_2 IN XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE
237: ,P_Distribution_Type IN XLA_Distribution_Links.SOURCE_DISTRIBUTION_TYPE%TYPE

Line 234: ,P_Transfer_Status_Code IN PA_Draft_Revenues_All.Transfer_Status_Code%TYPE

230: END create_events;
231:
232: FUNCTION Get_Sla_Ccid(
233: P_Acct_Event_Id IN PA_Draft_Revenues_All.Event_Id%TYPE
234: ,P_Transfer_Status_Code IN PA_Draft_Revenues_All.Transfer_Status_Code%TYPE
235: ,P_Source_Distribution_Id_Num_1 IN XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE
236: ,P_Source_Distribution_Id_Num_2 IN XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE
237: ,P_Distribution_Type IN XLA_Distribution_Links.SOURCE_DISTRIBUTION_TYPE%TYPE
238: ,P_Ledger_Id IN PA_Implementations_All.Set_Of_Books_Id%TYPE