APPS.FUN_GL_ASF_EVENTS_PKG dependencies on FUN_BALANCE_OPTIONS

Line 52: FROM fun_balance_options

48: ELSE
49: DELETE fun_balance_accounts
50: WHERE (dr_bsv = l_bsv OR cr_bsv = l_bsv)
51: AND template_id IN (SELECT template_id
52: FROM fun_balance_options
53: WHERE ledger_id = l_ledger_id);
54:
55: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
56: THEN

Line 138: FROM fun_balance_options

134: ELSE
135: DELETE fun_balance_accounts
136: WHERE (dr_bsv = l_bsv OR cr_bsv = l_bsv)
137: AND template_id IN (SELECT template_id
138: FROM fun_balance_options
139: WHERE le_id = l_le_id);
140:
141: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
142: THEN

Line 240: UPDATE fun_balance_options

236: wf_event.seterrorinfo (p_event, 'WARNING');
237: l_ret_mode := 'WARNING';
238:
239: ELSE
240: UPDATE fun_balance_options
241: SET status_flag = 'N',
242: last_update_date = SYSDATE,
243: last_update_login = FND_GLOBAL.LOGIN_ID,
244: last_updated_by = FND_GLOBAL.USER_ID

Line 252: ' No. of rows disabled in fun_balance_options is ' ||

248: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
249: THEN
250: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
251: 'fun.plsql.fun_gl_asf_events_pkg.ledger_le_remove',
252: ' No. of rows disabled in fun_balance_options is ' ||
253: SQL%ROWCOUNT);
254: END IF;
255:
256: UPDATE fun_inter_accounts

Line 344: FROM fun_balance_options

340:
341: ELSE
342: DELETE FROM fun_balance_accounts
343: WHERE template_id in (SELECT template_id
344: FROM fun_balance_options
345: WHERE ledger_id = l_sec_ledger_id);
346:
347: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
348: THEN

Line 355: DELETE FROM fun_balance_options

351: ' No. of rows deleted in fun_balance_accounts is ' ||
352: SQL%ROWCOUNT);
353: END IF;
354:
355: DELETE FROM fun_balance_options
356: WHERE ledger_id = l_sec_ledger_id;
357:
358: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
359: THEN

Line 362: ' No. of rows deleted in fun_balance_options is ' ||

358: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
359: THEN
360: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
361: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
362: ' No. of rows deleted in fun_balance_options is ' ||
363: SQL%ROWCOUNT);
364: END IF;
365:
366: DELETE FROM fun_inter_accounts

Line 450: FROM fun_balance_options

446:
447: ELSE
448: DELETE FROM fun_balance_accounts
449: WHERE template_id in (SELECT template_id
450: FROM fun_balance_options
451: WHERE ledger_id = l_rep_ledger_id);
452:
453: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
454: THEN

Line 461: DELETE FROM fun_balance_options

457: ' No. of rows deleted in fun_balance_accounts is ' ||
458: SQL%ROWCOUNT);
459: END IF;
460:
461: DELETE FROM fun_balance_options
462: WHERE ledger_id = l_rep_ledger_id;
463:
464: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
465: THEN

Line 468: ' No. of rows deleted in fun_balance_options is ' ||

464: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
465: THEN
466: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
467: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
468: ' No. of rows deleted in fun_balance_options is ' ||
469: SQL%ROWCOUNT);
470: END IF;
471:
472: DELETE FROM fun_inter_accounts