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 659: from pa_cost_distribution_lines_all cdl,

655: 'N', 'PA', 'EXT'),
656: decode(pts.posted_flag,
657: 'N', 'PA',pts.acct_source_code)) pts_source, /* Added posted_flag to derive PA if it is 'N' for bug 13254338*/
658: cdl.cr_code_combination_id orig_cr_ccid
659: from pa_cost_distribution_lines_all cdl,
660: pa_expenditure_items_all exp,
661: pa_transaction_sources pts
662: where exp.expenditure_item_id = cdl.expenditure_item_id
663: and exp.transaction_source = pts.transaction_source(+)

Line 703: from pa_cost_distribution_lines_all cdl,

699: 'EXT'),
700: decode(pts.posted_flag,
701: 'N', 'PA',pts.acct_source_code)) pts_source, /* Added posted_flag to derive PA if it is 'N' for bug 13254338*/
702: cd.cr_code_combination_id orig_cr_ccid
703: from pa_cost_distribution_lines_all cdl,
704: pa_expenditure_items_all exp,
705: pa_expenditure_items_all pe,
706: pa_cost_distribution_lines_all cd,
707: pa_transaction_sources pts

Line 706: pa_cost_distribution_lines_all cd,

702: cd.cr_code_combination_id orig_cr_ccid
703: from pa_cost_distribution_lines_all cdl,
704: pa_expenditure_items_all exp,
705: pa_expenditure_items_all pe,
706: pa_cost_distribution_lines_all cd,
707: pa_transaction_sources pts
708: where exp.expenditure_item_id = cdl.expenditure_item_id
709: and pe.transaction_source = pts.transaction_source(+)
710: and cdl.request_id = g_data_set_id

Line 748: from pa_cost_distribution_lines_all cdl,

744: 'EXT'),
745: decode(pts.posted_flag,
746: 'N', 'PA',pts.acct_source_code)) pts_source, /* Added posted_flag to derive PA if it is 'N' for bug 13254338*/
747: cd.cr_code_combination_id orig_cr_ccid
748: from pa_cost_distribution_lines_all cdl,
749: pa_expenditure_items_all exp,
750: pa_cost_distribution_lines_all cd,
751: pa_transaction_sources pts
752: where exp.expenditure_item_id = cdl.expenditure_item_id

Line 750: pa_cost_distribution_lines_all cd,

746: 'N', 'PA',pts.acct_source_code)) pts_source, /* Added posted_flag to derive PA if it is 'N' for bug 13254338*/
747: cd.cr_code_combination_id orig_cr_ccid
748: from pa_cost_distribution_lines_all cdl,
749: pa_expenditure_items_all exp,
750: pa_cost_distribution_lines_all cd,
751: pa_transaction_sources pts
752: where exp.expenditure_item_id = cdl.expenditure_item_id
753: and exp.transaction_source = pts.transaction_source(+)
754: and cdl.request_id = g_data_set_id

Line 872: update pa_cost_distribution_lines_all

868: IF g_calling_module in ('Cost', 'LAB', 'USG', 'INV', 'WIP',
869: 'BTC', 'TBC', 'PJ', 'SUPP') THEN
870:
871: FORALL i in t_entity_id.first..t_entity_id.last
872: update pa_cost_distribution_lines_all
873: set acct_event_id = decode(t_tsc(i), 'R', NULL, t_event_id(i)),
874: acct_source_code = decode(t_tsc(i), 'R', NULL, t_acct_source(i)),
875: transfer_status_code = decode(t_tsc(i), 'G', 'G', 'R', 'R', 'A'),
876: transfer_rejection_reason = decode(t_tsc(i),

Line 913: update pa_cost_distribution_lines_all

909: -- because of some data inconsistency.
910:
911: if g_calling_module in ('Cost', 'LAB', 'USG', 'INV', 'WIP', 'BTC', 'TBC',
912: 'PJ', 'SUPP') then
913: update pa_cost_distribution_lines_all
914: set transfer_status_code = 'R',
915: transfer_rejection_reason = 'Create Events API did not pick this line'
916: where transfer_status_code = 'X'
917: and request_id = g_data_set_id;

Line 2225: P_Acct_Event_Id IN PA_Cost_Distribution_Lines_All.Acct_Event_Id%TYPE

2221: * The following API is to be used by Post Accounting Programs.
2222: */
2223:
2224: FUNCTION Get_Post_Acc_Sla_Ccid(
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

Line 2226: ,P_Transfer_Status_Code IN PA_Cost_Distribution_Lines_All.Transfer_Status_Code%TYPE

2222: */
2223:
2224: FUNCTION Get_Post_Acc_Sla_Ccid(
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

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

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
2235: )
2236: RETURN NUMBER

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

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

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

Line 2281: from pa_cost_distribution_lines_all cd,

2277: l_ccid,
2278: l_sys_ref5,
2279: l_document_distribution_id,
2280: l_document_payment_id
2281: from pa_cost_distribution_lines_all cd,
2282: pa_expenditure_items_all pe
2283: where cd.expenditure_item_id = pe.expenditure_item_id
2284: and cd.expenditure_item_id = p_distribution_id_1
2285: and cd.line_num = p_distribution_id_2;

Line 2484: l_ccid PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE;

2480: )
2481: RETURN NUMBER
2482: IS
2483: l_Program_Code Xla_Post_Acct_Progs_b.Program_Code%TYPE;
2484: l_ccid PA_Cost_Distribution_Lines_All.Dr_Code_Combination_Id%TYPE;
2485: BEGIN
2486: IF ( P_Account_Type = 'DEBIT' )
2487: THEN
2488: l_program_code := 'PA_POSTACCOUNTING_DEBIT';