APPS.XLA_JOURNAL_ENTRIES_PKG dependencies on XLA_AE_LINE_ACS

Line 1356: DELETE FROM xla_ae_line_acs

1352: END IF;
1353: END LOOP;
1354:
1355: FORALL k in 1..j
1356: DELETE FROM xla_ae_line_acs
1357: WHERE ae_header_id = l_ae_header_ids(k);
1358:
1359: FORALL k in 1..j
1360: DELETE FROM xla_ae_header_acs

Line 2664: FROM xla_ae_line_acs ac

2660: FROM gl_code_combinations ccid
2661: WHERE ccid.code_combination_id = l.code_combination_id)
2662: ,analytical_balance_flag =
2663: (SELECT DECODE(count(1),0,NULL,'P')
2664: FROM xla_ae_line_acs ac
2665: WHERE ac.ae_header_id(+) = l.ae_header_id
2666: AND ac.ae_line_num(+) = l.ae_line_num)
2667: ,last_update_date = p_last_update_date
2668: ,last_updated_by = p_last_updated_by

Line 4306: INSERT INTO xla_ae_line_acs(

4302: --
4303: -- Copy the journal entry lines' analytical criteria from the original entry to
4304: -- the reversal entry
4305: --
4306: INSERT INTO xla_ae_line_acs(
4307: ae_header_id
4308: ,ae_line_num
4309: ,analytical_criterion_code
4310: ,analytical_criterion_type_code

Line 4329: FROM xla_ae_line_acs

4325: ,ac3
4326: ,ac4
4327: ,ac5
4328: ,1
4329: FROM xla_ae_line_acs
4330: WHERE ae_header_id = l_mrc_header.ae_header_id;
4331:
4332: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4333: trace(p_msg => 'END of procedure create_mrc_reversal_entry',

Line 4661: INSERT INTO xla_ae_line_acs(

4657: --
4658: -- Copy the journal entry lines' analytical criteria from the original entry to
4659: -- the reversal entry
4660: --
4661: INSERT INTO xla_ae_line_acs(
4662: ae_header_id
4663: ,ae_line_num
4664: ,analytical_criterion_code
4665: ,analytical_criterion_type_code

Line 4684: FROM xla_ae_line_acs

4680: ,ac3
4681: ,ac4
4682: ,ac5
4683: ,1
4684: FROM xla_ae_line_acs
4685: WHERE ae_header_id = p_info.header_id;
4686:
4687: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4688: trace(p_msg => 'END of procedure create_reversal_entry',

Line 5769: INSERT INTO xla_ae_line_acs (

5765: --
5766: -- Copy the journal entry lines' analytical criteria from the original entry to
5767: -- the mrc entry
5768: --
5769: INSERT INTO xla_ae_line_acs (
5770: ae_header_id
5771: ,ae_line_num
5772: ,analytical_criterion_code
5773: ,analytical_criterion_type_code

Line 5792: FROM xla_ae_line_acs

5788: ,ac3
5789: ,ac4
5790: ,ac5
5791: ,1
5792: FROM xla_ae_line_acs
5793: WHERE ae_header_id = p_info.header_id;
5794:
5795: END LOOP;
5796:

Line 5905: DELETE FROM xla_ae_line_acs

5901: p_level => C_LEVEL_EVENT);
5902: END IF;
5903:
5904: FORALL j in 1..i
5905: DELETE FROM xla_ae_line_acs
5906: WHERE ae_header_id = l_header_ids(j);
5907:
5908: FORALL j in 1..i
5909: DELETE FROM xla_ae_header_acs