[Home] [Help]
36: * may be out of sequence.
37: * Chetan Nagar 10/20/1999 B1043070
38: * UTF issues resolved.
39: * 05-Nov-1999 Rajesh Seshadri Bug 1039469 - Performance enhancement
40: * The gmf_gl_get_balances package is redesigned to fill a table with
41: * the code combinations and then select from this table. The queries
42: * were also rewritten to enhance their performance.
43: * Wrapped all calls to fnd_file inside a procedure and included
44: * trace messages throughout for easier debugging
60: * 31-Aug-2009 Parag Kanetkar Bug 9931797 Delete allocations for only those codes
61: * for which process is being run.
62: * 14-Jul-2011 Pramod B.H. Bug#12600219
63: * (i)Modified procedure put_alloc_expenses(). Now passing new out parameter
64: * X_to_segment_ccid in the call to gmf_gl_get_balances.proc_gl_get_balances().
65: * This account Id is now used to create record in gl_aloc_inp.
66: * (ii)Now printing few existing debug messages (debug level 3) into
67: * the logfile itself instead of the output file.
68: * Bug 14178149 Prasad marad. Added a ref cursor object to the argument of
998: l_period_type VARCHAR2(15);
999: x_ledger_id NUMBER := P_fiscal_plcy.ledger_id;
1000: X_account_type VARCHAR2(4);
1001: l_new_x_to_segment VARCHAR2(4000); --Bug 9241807
1002: X_cur_gl_get_balances GMF_GL_GET_BALANCES.cur_gl_get_balances_rc; /* Bug 14178149 */
1003:
1004: BEGIN
1005: l_previous_module := g_calling_module;
1006: g_calling_module := g_calling_module||l_local_module;
1114: X_row_to_fetch || ' , ' ||
1115: X_error_status
1116: , 3, C_LOG_FILE );
1117:
1118: gmf_gl_get_balances.proc_gl_get_balances(
1119: X_ledger_id,
1120: g_chart_of_accounts_id,
1121: g_periodyear,
1122: g_periodnumber,