[Home] [Help]
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;
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;
2412: xla_ae_headers aeh,
2413: xla_ae_lines ael,
2414: xla_acct_class_assgns xaca,
2415: xla_assignment_defns_b xad,
2416: xla_post_acct_progs_b xpap,
2417: gl_ledgers gl
2418: WHERE xdl.source_distribution_id_num_1 = l_Source_Distribution_Id_Num_1
2419: AND NVL(xdl.source_distribution_id_num_2, -99) = to_number(NVL(l_Source_Distribution_Id_Num_2, -99)) /*Added to_number for bug 9407402*/
2420: AND xdl.source_distribution_type = l_distribution_type
2479: ,P_Ledger_Id NUMBER
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
2496: XLA_Ae_Headers aeh,
2497: XLA_Ae_Lines ael,
2498: XLA_Acct_Class_Assgns xaca,
2499: XLA_Assignment_Defns_b xad,
2500: XLA_Post_acct_Progs_b xpap,
2501: gl_ledgers gl
2502: WHERE xdl.source_Distribution_id_num_1 = P_Distribution_Id_1
2503: AND NVL(xdl.source_Distribution_id_num_2, -99) = to_number(NVL(P_Distribution_Id_2 , -99)) /*Added to_number for bug 9407402*/
2504: AND xdl.Source_Distribution_Type = P_Distribution_Type