APPS.XLA_JOURNAL_ENTRIES_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 1340: DELETE FROM xla_distribution_links

1336:
1337: DELETE FROM xla_accounting_errors
1338: WHERE event_id = p_event_id;
1339:
1340: DELETE FROM xla_distribution_links
1341: WHERE application_id = p_application_id
1342: AND ae_header_id IN (SELECT ae_header_id
1343: FROM xla_ae_headers
1344: WHERE application_id = p_application_id

Line 6132: DELETE xla_distribution_links

6128: DELETE FROM xla_ae_header_acs
6129: WHERE ae_header_id = l_header_ids(j);
6130:
6131: FORALL j IN 1..i
6132: DELETE xla_distribution_links
6133: WHERE ae_header_id = l_header_ids(j)
6134: AND application_id = p_application_id;
6135:
6136: FORALL j in 1..i

Line 8394: INSERT INTO xla_distribution_links

8390: p_level => C_LEVEL_STATEMENT);
8391:
8392: END IF;
8393:
8394: INSERT INTO xla_distribution_links
8395: (application_id
8396: ,event_id
8397: ,ae_header_id
8398: ,ae_line_num

Line 8492: DELETE xla_distribution_links

8488: p_level => C_LEVEL_STATEMENT);
8489:
8490: END IF;
8491:
8492: DELETE xla_distribution_links
8493: WHERE application_id = p_application_id
8494: AND ref_ae_header_id = p_ref_ae_header_id
8495: AND temp_line_num = p_temp_line_num
8496: AND ae_header_id = p_ae_header_id;

Line 8578: UPDATE xla_distribution_links

8574: p_level => C_LEVEL_STATEMENT);
8575:
8576: END IF;
8577:
8578: UPDATE xla_distribution_links
8579: SET unrounded_entered_dr = p_unrounded_entered_dr
8580: ,unrounded_entered_cr = p_unrounded_entered_cr
8581: ,unrounded_accounted_dr = p_unrounded_accounted_dr
8582: ,unrounded_accounted_cr = p_undournde_accounted_cr

Line 8663: INSERT INTO xla_distribution_links

8659: AND ae_header_id = p_ref_ae_header_id;
8660:
8661: END IF;
8662:
8663: INSERT INTO xla_distribution_links
8664: (application_id
8665: ,event_id
8666: ,ae_header_id
8667: ,ae_line_num

Line 8758: FROM xla_distribution_links

8754: END IF;
8755:
8756: SELECT COUNT(1)
8757: INTO l_cnt
8758: FROM xla_distribution_links
8759: WHERE application_id = p_application_id
8760: AND ae_header_id = p_ae_header_id
8761: AND temp_line_num = -1 * p_temp_line_num
8762: AND ROWNUM <=1;

Line 8849: FROM xla_distribution_links

8845: ,temp_line_num
8846: INTO l_ref_ae_header_id
8847: ,l_ref_event_id
8848: ,l_temp_line_num
8849: FROM xla_distribution_links
8850: WHERE application_id = p_application_id
8851: AND ae_header_id = p_ae_header_id
8852: AND temp_line_num = -1 * p_temp_line_num
8853: AND ROWNUM <= 1;

Line 8963: FROM xla_distribution_links

8959: INTO l_ref_ae_header_id
8960: ,l_ref_event_id
8961: ,l_temp_line_num
8962: ,l_ref_temp_line_num
8963: FROM xla_distribution_links
8964: WHERE event_id =
8965: (SELECT ref_event_id
8966: FROM xla_distribution_links
8967: WHERE application_id = p_application_id -- non mrc

Line 8966: FROM xla_distribution_links

8962: ,l_ref_temp_line_num
8963: FROM xla_distribution_links
8964: WHERE event_id =
8965: (SELECT ref_event_id
8966: FROM xla_distribution_links
8967: WHERE application_id = p_application_id -- non mrc
8968: AND ae_header_id = p_ae_header_id -- non mrc
8969: AND temp_line_num = -1 * p_temp_line_num -- non mrc
8970: AND ROWNUM <= 1)

Line 8973: FROM xla_distribution_links

8969: AND temp_line_num = -1 * p_temp_line_num -- non mrc
8970: AND ROWNUM <= 1)
8971: AND ae_header_id <>
8972: (SELECT ref_ae_header_id
8973: FROM xla_distribution_links
8974: WHERE application_id = p_application_id -- non mrc
8975: AND ae_header_id = p_ae_header_id -- non mrc
8976: AND temp_line_num = -1 * p_temp_line_num -- non mrc
8977: AND ROWNUM <= 1)

Line 9025: from xla_distribution_links

9021: IS
9022:
9023: cursor c_reversible is
9024: select 'Y'
9025: from xla_distribution_links
9026: where ae_header_id = ref_ae_header_id
9027: and ref_temp_line_num is null
9028: and ae_header_id= p_ae_header_id
9029: and application_id=p_application_id

Line 9032: from xla_distribution_links

9028: and ae_header_id= p_ae_header_id
9029: and application_id=p_application_id
9030: and not exists (
9031: select 1
9032: from xla_distribution_links
9033: where ae_header_id<>ref_ae_header_id
9034: and ref_ae_header_id=p_ae_header_id
9035: and application_id=p_application_id
9036: );