DBA Data[Home] [Help]

APPS.FUN_GL_ASF_EVENTS_PKG dependencies on FUN_INTER_ACCOUNTS

Line 150: UPDATE fun_inter_accounts

146: SQL%ROWCOUNT);
147: END IF;
148:
149:
150: UPDATE fun_inter_accounts
151: SET end_date = SYSDATE,
152: last_update_date = SYSDATE,
153: last_update_login = FND_GLOBAL.LOGIN_ID,
154: last_updated_by = FND_GLOBAL.USER_ID

Line 162: ' No. of rows terminated in fun_inter_accounts is ' ||

158: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
159: THEN
160: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
161: 'fun.plsql.fun_gl_asf_events_pkg.le_bsv_remove',
162: ' No. of rows terminated in fun_inter_accounts is ' ||
163: SQL%ROWCOUNT);
164: END IF;
165:
166:

Line 256: UPDATE fun_inter_accounts

252: ' No. of rows disabled in fun_balance_options is ' ||
253: SQL%ROWCOUNT);
254: END IF;
255:
256: UPDATE fun_inter_accounts
257: SET end_date = SYSDATE,
258: last_update_date = SYSDATE,
259: last_update_login = FND_GLOBAL.LOGIN_ID,
260: last_updated_by = FND_GLOBAL.USER_ID

Line 268: ' No. of rows terminated in fun_inter_accounts is ' ||

264: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
265: THEN
266: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
267: 'fun.plsql.fun_gl_asf_events_pkg.ledger_le_remove',
268: ' No. of rows terminated in fun_inter_accounts is ' ||
269: SQL%ROWCOUNT);
270: END IF;
271:
272: END IF; -- Ledger and LE passed

Line 366: DELETE FROM fun_inter_accounts

362: ' No. of rows deleted in fun_balance_options is ' ||
363: SQL%ROWCOUNT);
364: END IF;
365:
366: DELETE FROM fun_inter_accounts
367: WHERE ledger_id = l_sec_ledger_id;
368:
369: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
370: THEN

Line 373: ' No. of rows deleted in fun_inter_accounts is ' ||

369: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
370: THEN
371: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
372: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
373: ' No. of rows deleted in fun_inter_accounts is ' ||
374: SQL%ROWCOUNT);
375: END IF;
376:
377:

Line 472: DELETE FROM fun_inter_accounts

468: ' No. of rows deleted in fun_balance_options is ' ||
469: SQL%ROWCOUNT);
470: END IF;
471:
472: DELETE FROM fun_inter_accounts
473: WHERE ledger_id = l_rep_ledger_id;
474:
475: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
476: THEN

Line 479: ' No. of rows deleted in fun_inter_accounts is ' ||

475: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
476: THEN
477: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
478: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
479: ' No. of rows deleted in fun_inter_accounts is ' ||
480: SQL%ROWCOUNT);
481: END IF;
482:
483: