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 PA_COST_DISTRIBUTION_LINES_ALL

Line 653: from pa_cost_distribution_lines_all cdl,

649: 'N', decode(pts.posted_flag,
650: 'N', 'PA', 'EXT'),
651: pts.acct_source_code) pts_source,
652: cdl.cr_code_combination_id orig_cr_ccid
653: from pa_cost_distribution_lines_all cdl,
654: pa_expenditure_items_all exp,
655: pa_transaction_sources pts
656: where exp.expenditure_item_id = cdl.expenditure_item_id
657: and exp.transaction_source = pts.transaction_source(+)

Line 696: from pa_cost_distribution_lines_all cdl,

692: 'N', 'PA',
693: 'EXT'),
694: pts.acct_source_code) pts_source,
695: cd.cr_code_combination_id orig_cr_ccid
696: from pa_cost_distribution_lines_all cdl,
697: pa_expenditure_items_all exp,
698: pa_expenditure_items_all pe,
699: pa_cost_distribution_lines_all cd,
700: pa_transaction_sources pts

Line 699: pa_cost_distribution_lines_all cd,

695: cd.cr_code_combination_id orig_cr_ccid
696: from pa_cost_distribution_lines_all cdl,
697: pa_expenditure_items_all exp,
698: pa_expenditure_items_all pe,
699: pa_cost_distribution_lines_all cd,
700: pa_transaction_sources pts
701: where exp.expenditure_item_id = cdl.expenditure_item_id
702: and pe.transaction_source = pts.transaction_source(+)
703: and cdl.request_id = g_data_set_id

Line 740: from pa_cost_distribution_lines_all cdl,

736: 'N', 'PA',
737: 'EXT'),
738: pts.acct_source_code) pts_source,
739: cd.cr_code_combination_id orig_cr_ccid
740: from pa_cost_distribution_lines_all cdl,
741: pa_expenditure_items_all exp,
742: pa_cost_distribution_lines_all cd,
743: pa_transaction_sources pts
744: where exp.expenditure_item_id = cdl.expenditure_item_id

Line 742: pa_cost_distribution_lines_all cd,

738: pts.acct_source_code) pts_source,
739: cd.cr_code_combination_id orig_cr_ccid
740: from pa_cost_distribution_lines_all cdl,
741: pa_expenditure_items_all exp,
742: pa_cost_distribution_lines_all cd,
743: pa_transaction_sources pts
744: where exp.expenditure_item_id = cdl.expenditure_item_id
745: and exp.transaction_source = pts.transaction_source(+)
746: and cdl.request_id = g_data_set_id

Line 864: update pa_cost_distribution_lines_all

860: IF g_calling_module in ('Cost', 'LAB', 'USG', 'INV', 'WIP',
861: 'BTC', 'TBC', 'PJ', 'SUPP') THEN
862:
863: FORALL i in t_entity_id.first..t_entity_id.last
864: update pa_cost_distribution_lines_all
865: set acct_event_id = decode(t_tsc(i), 'R', NULL, t_event_id(i)),
866: acct_source_code = decode(t_tsc(i), 'R', NULL, t_acct_source(i)),
867: transfer_status_code = decode(t_tsc(i), 'G', 'G', 'R', 'R', 'A'),
868: transfer_rejection_reason = decode(t_tsc(i),

Line 905: update pa_cost_distribution_lines_all

901: -- because of some data inconsistency.
902:
903: if g_calling_module in ('Cost', 'LAB', 'USG', 'INV', 'WIP', 'BTC', 'TBC',
904: 'PJ', 'SUPP') then
905: update pa_cost_distribution_lines_all
906: set transfer_status_code = 'R',
907: transfer_rejection_reason = 'Create Events API did not pick this line'
908: where transfer_status_code = 'X'
909: and request_id = g_data_set_id;

Line 2215: P_Acct_Event_Id IN PA_Cost_Distribution_Lines_All.Acct_Event_Id%TYPE

2211: * The following API is to be used by Post Accounting Programs.
2212: */
2213:
2214: FUNCTION Get_Post_Acc_Sla_Ccid(
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

Line 2216: ,P_Transfer_Status_Code IN PA_Cost_Distribution_Lines_All.Transfer_Status_Code%TYPE

2212: */
2213:
2214: FUNCTION Get_Post_Acc_Sla_Ccid(
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

Line 2222: ,P_Ccid IN PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE DEFAULT NULL

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
2225: )
2226: RETURN NUMBER

Line 2229: l_ccid PA_Cost_Distribution_Lines_All.Dr_Code_Combination_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;
2233: l_acct_source_code PA_Transaction_Sources.Acct_Source_Code%TYPE;

Line 2236: l_transfer_status_code PA_Cost_Distribution_Lines_All.transfer_status_code%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;
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;

Line 2237: l_sys_ref5 PA_Cost_Distribution_Lines_All.system_reference5%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;
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);

Line 2271: from pa_cost_distribution_lines_all cd,

2267: l_ccid,
2268: l_sys_ref5,
2269: l_document_distribution_id,
2270: l_document_payment_id
2271: from pa_cost_distribution_lines_all cd,
2272: pa_expenditure_items_all pe
2273: where cd.expenditure_item_id = pe.expenditure_item_id
2274: and cd.expenditure_item_id = p_distribution_id_1
2275: and cd.line_num = p_distribution_id_2;

Line 2465: l_ccid PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE;

2461: )
2462: RETURN NUMBER
2463: IS
2464: l_Program_Code Xla_Post_Acct_Progs_b.Program_Code%TYPE;
2465: l_ccid PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE;
2466: BEGIN
2467: IF ( P_Account_Type = 'DEBIT' )
2468: THEN
2469: l_program_code := 'PA_POSTACCOUNTING_DEBIT';