DBA Data[Home] [Help]

APPS.XLA_JE_VALIDATION_PKG dependencies on FUN_BAL_HEADERS_GT

Line 7038: INSERT INTO fun_bal_headers_gt (

7034: -- balancing API
7035: --
7036: IF (l_bal_count>0) THEN
7037: FORALL j IN 1..l_bal_count
7038: INSERT INTO fun_bal_headers_gt (
7039: group_id
7040: ,ledger_id
7041: ,je_source_name
7042: ,je_category_name

Line 7054: trace(p_msg => '# rows inserted into fun_bal_headers_gt: '||SQL%ROWCOUNT,

7050: ,l_accounting_dates(j)
7051: ,'OK');
7052:
7053: IF (C_LEVEL_EVENT >= g_log_level) THEN
7054: trace(p_msg => '# rows inserted into fun_bal_headers_gt: '||SQL%ROWCOUNT,
7055: p_module => l_log_module,
7056: p_level => C_LEVEL_EVENT);
7057: END IF;
7058:

Line 7084: ,fun_bal_headers_gt h

7080: ,l.unrounded_accounted_dr
7081: ,l.unrounded_accounted_cr
7082: ,'N'
7083: FROM xla_validation_lines_gt l
7084: ,fun_bal_headers_gt h
7085: WHERE l.balancing_line_type = C_LINE_TYPE_PROCESS
7086: AND l.ae_header_id = h.group_id
7087: AND EXISTS (select 1 from xla_distribution_links xdl
7088: where xdl.ae_header_id= l.ae_header_id

Line 7124: ,fun_bal_headers_gt h

7120: ,l.unrounded_accounted_cr
7121: ,l.unrounded_accounted_dr
7122: ,'N'
7123: FROM xla_validation_lines_gt l
7124: ,fun_bal_headers_gt h
7125: WHERE l.balancing_line_type = C_LINE_TYPE_PROCESS
7126: AND l.ae_header_id = h.group_id
7127: AND EXISTS (select 1 from xla_distribution_links xdl
7128: where xdl.ae_header_id= l.ae_header_id