APPS.FUN_GL_ASF_EVENTS_PKG dependencies on FUN_BALANCE_ACCOUNTS

Line 49: DELETE fun_balance_accounts

45: wf_event.seterrorinfo (p_event, 'WARNING');
46: l_ret_mode := 'WARNING';
47:
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);

Line 59: ' No. of rows deleted from fun_balance_accounts is ' ||

55: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
56: THEN
57: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
58: 'fun.plsql.fun_gl_asf_events_pkg.ledger_bsv_remove',
59: ' No. of rows deleted from fun_balance_accounts is ' ||
60: SQL%ROWCOUNT);
61: END IF;
62:
63:

Line 135: DELETE fun_balance_accounts

131: wf_event.seterrorinfo (p_event, 'WARNING');
132: l_ret_mode := 'WARNING';
133:
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);

Line 145: ' No. of rows deleted from fun_balance_accounts is ' ||

141: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
142: THEN
143: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
144: 'fun.plsql.fun_gl_asf_events_pkg.le_bsv_remove',
145: ' No. of rows deleted from fun_balance_accounts is ' ||
146: SQL%ROWCOUNT);
147: END IF;
148:
149:

Line 342: DELETE FROM fun_balance_accounts

338: wf_event.seterrorinfo (p_event, 'WARNING');
339: l_ret_mode := 'WARNING';
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:

Line 351: ' No. of rows deleted in fun_balance_accounts is ' ||

347: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
348: THEN
349: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
350: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
351: ' No. of rows deleted in fun_balance_accounts is ' ||
352: SQL%ROWCOUNT);
353: END IF;
354:
355: DELETE FROM fun_balance_options

Line 448: DELETE FROM fun_balance_accounts

444: wf_event.seterrorinfo (p_event, 'WARNING');
445: l_ret_mode := 'WARNING';
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:

Line 457: ' No. of rows deleted in fun_balance_accounts is ' ||

453: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
454: THEN
455: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
456: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
457: ' No. of rows deleted in fun_balance_accounts is ' ||
458: SQL%ROWCOUNT);
459: END IF;
460:
461: DELETE FROM fun_balance_options