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_INTERFACE_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 2229: ,P_Distribution_Id_1 IN XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE

2225: P_Acct_Event_Id IN PA_Cost_Distribution_Lines_All.Acct_Event_Id%TYPE
2226: ,P_Transfer_Status_Code IN PA_Cost_Distribution_Lines_All.Transfer_Status_Code%TYPE
2227: ,P_Transaction_Source IN PA_Expenditure_Items_All.Transaction_Source%TYPE
2228: ,P_Historical_Flag IN PA_Expenditure_Items_All.Historical_Flag%TYPE
2229: ,P_Distribution_Id_1 IN XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE
2230: ,P_Distribution_Id_2 IN XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE
2231: ,P_Distribution_Type IN VARCHAR2
2232: ,P_Ccid IN PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE DEFAULT NULL
2233: ,P_Account_Type IN VARCHAR2 DEFAULT 'DEBIT'

Line 2230: ,P_Distribution_Id_2 IN XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE

2226: ,P_Transfer_Status_Code IN PA_Cost_Distribution_Lines_All.Transfer_Status_Code%TYPE
2227: ,P_Transaction_Source IN PA_Expenditure_Items_All.Transaction_Source%TYPE
2228: ,P_Historical_Flag IN PA_Expenditure_Items_All.Historical_Flag%TYPE
2229: ,P_Distribution_Id_1 IN XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE
2230: ,P_Distribution_Id_2 IN XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE
2231: ,P_Distribution_Type IN VARCHAR2
2232: ,P_Ccid IN PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE DEFAULT NULL
2233: ,P_Account_Type IN VARCHAR2 DEFAULT 'DEBIT'
2234: ,P_Ledger_Id IN PA_Implementations_All.Set_Of_Books_Id%TYPE

Line 2238: l_application_id XLA_Distribution_Links.Application_Id%TYPE;

2234: ,P_Ledger_Id IN PA_Implementations_All.Set_Of_Books_Id%TYPE
2235: )
2236: RETURN NUMBER
2237: IS
2238: l_application_id XLA_Distribution_Links.Application_Id%TYPE;
2239: l_ccid PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE;
2240: l_Source_Distribution_Id_Num_1 XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE;
2241: l_Source_Distribution_Id_Num_2 XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE;
2242: l_predefined_flag PA_Transaction_Sources.Predefined_Flag%TYPE;

Line 2240: l_Source_Distribution_Id_Num_1 XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE;

2236: RETURN NUMBER
2237: IS
2238: l_application_id XLA_Distribution_Links.Application_Id%TYPE;
2239: l_ccid PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE;
2240: l_Source_Distribution_Id_Num_1 XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE;
2241: l_Source_Distribution_Id_Num_2 XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE;
2242: l_predefined_flag PA_Transaction_Sources.Predefined_Flag%TYPE;
2243: l_acct_source_code PA_Transaction_Sources.Acct_Source_Code%TYPE;
2244: l_Program_Code Xla_Post_Acct_Progs_b.Program_Code%TYPE;

Line 2241: l_Source_Distribution_Id_Num_2 XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE;

2237: IS
2238: l_application_id XLA_Distribution_Links.Application_Id%TYPE;
2239: l_ccid PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE;
2240: l_Source_Distribution_Id_Num_1 XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE;
2241: l_Source_Distribution_Id_Num_2 XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE;
2242: l_predefined_flag PA_Transaction_Sources.Predefined_Flag%TYPE;
2243: l_acct_source_code PA_Transaction_Sources.Acct_Source_Code%TYPE;
2244: l_Program_Code Xla_Post_Acct_Progs_b.Program_Code%TYPE;
2245: l_acct_event_id XLA_Events.Event_ID%TYPE;

Line 2250: l_distribution_type Xla_Distribution_Links.Source_Distribution_Type%TYPE;

2246: l_transfer_status_code PA_Cost_Distribution_Lines_All.transfer_status_code%TYPE;
2247: l_sys_ref5 PA_Cost_Distribution_Lines_All.system_reference5%TYPE;
2248: l_document_distribution_id PA_Expenditure_Items_All.document_distribution_id%TYPE;
2249: l_document_payment_id PA_Expenditure_Items_All.document_payment_id%TYPE;
2250: l_distribution_type Xla_Distribution_Links.Source_Distribution_Type%TYPE;
2251: l_payment_dist_lookup_code varchar2(15);
2252: BEGIN
2253:
2254: l_predefined_flag := NULL;

Line 2344: -- These values are used in the join with xla_distribution_links. This is

2340: WHEN 'RCV' THEN 707
2341: ELSE 0
2342: END;
2343: -- Source Distribution Type is determined based on the acct_source_code value.
2344: -- These values are used in the join with xla_distribution_links. This is
2345: -- overriding the input parameter for distribution_type and is required only
2346: -- in case of 'V' lines.
2347: if l_acct_source_code = 'AP_PAY' then
2348: l_distribution_type := 'AP_PMT_DIST';

Line 2409: SELECT /+ leading( gl, xdl, ael, aeh, xaca, xad, xpap ) use_nl(xdl) index(xdl XLA_DISTRIBUTION_LINKS_N1) / code_combination_id

2405: ELSE
2406: l_program_code := 'PA_POSTACCOUNTING_CREDIT';
2407: END IF;
2408:
2409: SELECT /*+ leading( gl, xdl, ael, aeh, xaca, xad, xpap ) use_nl(xdl) index(xdl XLA_DISTRIBUTION_LINKS_N1) */ code_combination_id
2410: into l_Ccid
2411: FROM xla_distribution_links xdl,
2412: xla_ae_headers aeh,
2413: xla_ae_lines ael,

Line 2411: FROM xla_distribution_links xdl,

2407: END IF;
2408:
2409: SELECT /*+ leading( gl, xdl, ael, aeh, xaca, xad, xpap ) use_nl(xdl) index(xdl XLA_DISTRIBUTION_LINKS_N1) */ code_combination_id
2410: into l_Ccid
2411: FROM xla_distribution_links xdl,
2412: xla_ae_headers aeh,
2413: xla_ae_lines ael,
2414: xla_acct_class_assgns xaca,
2415: xla_assignment_defns_b xad,

Line 2477: ,P_Distribution_Type XLA_Distribution_Links.SOURCE_DISTRIBUTION_TYPE%TYPE

2473: */
2474: FUNCTION Get_Sla_Ccid( P_Application_Id NUMBER
2475: ,P_Distribution_Id_1 NUMBER
2476: ,P_Distribution_Id_2 NUMBER
2477: ,P_Distribution_Type XLA_Distribution_Links.SOURCE_DISTRIBUTION_TYPE%TYPE
2478: ,P_Account_Type VARCHAR2
2479: ,P_Ledger_Id NUMBER
2480: )
2481: RETURN NUMBER

Line 2495: FROM XLA_Distribution_Links xdl,

2491: END IF;
2492:
2493: SELECT /*+ leading( gl, xdl, ael, aeh, xaca, xad, xpap ) */ code_combination_id
2494: into l_ccid
2495: FROM XLA_Distribution_Links xdl,
2496: XLA_Ae_Headers aeh,
2497: XLA_Ae_Lines ael,
2498: XLA_Acct_Class_Assgns xaca,
2499: XLA_Assignment_Defns_b xad,