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 XLA_DISTRIBUTION_LINKS

Line 235: ,P_Source_Distribution_Id_Num_1 IN XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE

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
239: )

Line 236: ,P_Source_Distribution_Id_Num_2 IN XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE

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
239: )
240: RETURN NUMBER

Line 237: ,P_Distribution_Type IN XLA_Distribution_Links.SOURCE_DISTRIBUTION_TYPE%TYPE

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
239: )
240: RETURN NUMBER
241: IS

Line 246: FROM xla_distribution_links xdl,

242: l_ccid PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE;
243: BEGIN
244: SELECT code_combination_id
245: INTO l_ccid
246: FROM xla_distribution_links xdl,
247: xla_ae_headers aeh,
248: xla_ae_lines ael
249: WHERE xdl.source_distribution_id_num_1 = P_Source_Distribution_Id_Num_1
250: AND xdl.source_distribution_id_num_2 = P_Source_Distribution_Id_Num_2