DBA Data[Home] [Help]

APPS.PA_XLA_INTERFACE_PKG dependencies on XLA_POST_ACCT_PROGS_B

Line 2234: l_Program_Code Xla_Post_Acct_Progs_b.Program_Code%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;
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;

Line 2406: xla_post_acct_progs_b xpap,

2402: xla_ae_headers aeh,
2403: xla_ae_lines ael,
2404: xla_acct_class_assgns xaca,
2405: xla_assignment_defns_b xad,
2406: xla_post_acct_progs_b xpap,
2407: gl_ledgers gl
2408: WHERE xdl.source_distribution_id_num_1 = l_Source_Distribution_Id_Num_1
2409: AND NVL(xdl.source_distribution_id_num_2, -99) = NVL(l_Source_Distribution_Id_Num_2, -99)
2410: AND xdl.source_distribution_type = l_distribution_type

Line 2464: l_Program_Code Xla_Post_Acct_Progs_b.Program_Code%TYPE;

2460: ,P_Ledger_Id NUMBER
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

Line 2481: XLA_Post_acct_Progs_b xpap,

2477: XLA_Ae_Headers aeh,
2478: XLA_Ae_Lines ael,
2479: XLA_Acct_Class_Assgns xaca,
2480: XLA_Assignment_Defns_b xad,
2481: XLA_Post_acct_Progs_b xpap,
2482: gl_ledgers gl
2483: WHERE xdl.source_Distribution_id_num_1 = P_Distribution_Id_1
2484: AND NVL(xdl.source_Distribution_id_num_2, -99) = NVL(P_Distribution_Id_2 , -99)
2485: AND xdl.Source_Distribution_Type = P_Distribution_Type