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 2219: ,P_Distribution_Id_1 IN XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE

2215: P_Acct_Event_Id IN PA_Cost_Distribution_Lines_All.Acct_Event_Id%TYPE
2216: ,P_Transfer_Status_Code IN PA_Cost_Distribution_Lines_All.Transfer_Status_Code%TYPE
2217: ,P_Transaction_Source IN PA_Expenditure_Items_All.Transaction_Source%TYPE
2218: ,P_Historical_Flag IN PA_Expenditure_Items_All.Historical_Flag%TYPE
2219: ,P_Distribution_Id_1 IN XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE
2220: ,P_Distribution_Id_2 IN XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE
2221: ,P_Distribution_Type IN VARCHAR2
2222: ,P_Ccid IN PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE DEFAULT NULL
2223: ,P_Account_Type IN VARCHAR2 DEFAULT 'DEBIT'

Line 2220: ,P_Distribution_Id_2 IN XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE

2216: ,P_Transfer_Status_Code IN PA_Cost_Distribution_Lines_All.Transfer_Status_Code%TYPE
2217: ,P_Transaction_Source IN PA_Expenditure_Items_All.Transaction_Source%TYPE
2218: ,P_Historical_Flag IN PA_Expenditure_Items_All.Historical_Flag%TYPE
2219: ,P_Distribution_Id_1 IN XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE
2220: ,P_Distribution_Id_2 IN XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE
2221: ,P_Distribution_Type IN VARCHAR2
2222: ,P_Ccid IN PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE DEFAULT NULL
2223: ,P_Account_Type IN VARCHAR2 DEFAULT 'DEBIT'
2224: ,P_Ledger_Id IN PA_Implementations_All.Set_Of_Books_Id%TYPE

Line 2228: l_application_id XLA_Distribution_Links.Application_Id%TYPE;

2224: ,P_Ledger_Id IN PA_Implementations_All.Set_Of_Books_Id%TYPE
2225: )
2226: RETURN NUMBER
2227: IS
2228: l_application_id XLA_Distribution_Links.Application_Id%TYPE;
2229: l_ccid PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE;
2230: l_Source_Distribution_Id_Num_1 XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE;
2231: l_Source_Distribution_Id_Num_2 XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE;
2232: l_predefined_flag PA_Transaction_Sources.Predefined_Flag%TYPE;

Line 2230: l_Source_Distribution_Id_Num_1 XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE;

2226: RETURN NUMBER
2227: IS
2228: l_application_id XLA_Distribution_Links.Application_Id%TYPE;
2229: l_ccid PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE;
2230: l_Source_Distribution_Id_Num_1 XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE;
2231: l_Source_Distribution_Id_Num_2 XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE;
2232: l_predefined_flag PA_Transaction_Sources.Predefined_Flag%TYPE;
2233: l_acct_source_code PA_Transaction_Sources.Acct_Source_Code%TYPE;
2234: l_Program_Code Xla_Post_Acct_Progs_b.Program_Code%TYPE;

Line 2231: l_Source_Distribution_Id_Num_2 XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE;

2227: IS
2228: l_application_id XLA_Distribution_Links.Application_Id%TYPE;
2229: l_ccid PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE;
2230: l_Source_Distribution_Id_Num_1 XLA_Distribution_Links.Source_Distribution_Id_Num_1%TYPE;
2231: l_Source_Distribution_Id_Num_2 XLA_Distribution_Links.Source_Distribution_Id_Num_2%TYPE;
2232: l_predefined_flag PA_Transaction_Sources.Predefined_Flag%TYPE;
2233: l_acct_source_code PA_Transaction_Sources.Acct_Source_Code%TYPE;
2234: l_Program_Code Xla_Post_Acct_Progs_b.Program_Code%TYPE;
2235: l_acct_event_id XLA_Events.Event_ID%TYPE;

Line 2240: l_distribution_type Xla_Distribution_Links.Source_Distribution_Type%TYPE;

2236: l_transfer_status_code PA_Cost_Distribution_Lines_All.transfer_status_code%TYPE;
2237: l_sys_ref5 PA_Cost_Distribution_Lines_All.system_reference5%TYPE;
2238: l_document_distribution_id PA_Expenditure_Items_All.document_distribution_id%TYPE;
2239: l_document_payment_id PA_Expenditure_Items_All.document_payment_id%TYPE;
2240: l_distribution_type Xla_Distribution_Links.Source_Distribution_Type%TYPE;
2241: l_payment_dist_lookup_code varchar2(15);
2242: BEGIN
2243:
2244: l_predefined_flag := NULL;

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

2330: WHEN 'RCV' THEN 707
2331: ELSE 0
2332: END;
2333: -- Source Distribution Type is determined based on the acct_source_code value.
2334: -- These values are used in the join with xla_distribution_links. This is
2335: -- overriding the input parameter for distribution_type and is required only
2336: -- in case of 'V' lines.
2337: if l_acct_source_code = 'AP_PAY' then
2338: l_distribution_type := 'AP_PMT_DIST';

Line 2401: FROM xla_distribution_links xdl,

2397: END IF;
2398:
2399: SELECT code_combination_id
2400: into l_Ccid
2401: FROM xla_distribution_links xdl,
2402: xla_ae_headers aeh,
2403: xla_ae_lines ael,
2404: xla_acct_class_assgns xaca,
2405: xla_assignment_defns_b xad,

Line 2458: ,P_Distribution_Type XLA_Distribution_Links.SOURCE_DISTRIBUTION_TYPE%TYPE

2454: */
2455: FUNCTION Get_Sla_Ccid( P_Application_Id NUMBER
2456: ,P_Distribution_Id_1 NUMBER
2457: ,P_Distribution_Id_2 NUMBER
2458: ,P_Distribution_Type XLA_Distribution_Links.SOURCE_DISTRIBUTION_TYPE%TYPE
2459: ,P_Account_Type VARCHAR2
2460: ,P_Ledger_Id NUMBER
2461: )
2462: RETURN NUMBER

Line 2476: FROM XLA_Distribution_Links xdl,

2472: END IF;
2473:
2474: SELECT code_combination_id
2475: into l_ccid
2476: FROM XLA_Distribution_Links xdl,
2477: XLA_Ae_Headers aeh,
2478: XLA_Ae_Lines ael,
2479: XLA_Acct_Class_Assgns xaca,
2480: XLA_Assignment_Defns_b xad,