eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_JOURNAL_ENTRIES_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 1320: DELETE FROM xla_distribution_links

1316:
1317: DELETE FROM xla_accounting_errors
1318: WHERE event_id = p_event_id;
1319:
1320: DELETE FROM xla_distribution_links
1321: WHERE application_id = p_application_id
1322: AND ae_header_id IN (SELECT ae_header_id
1323: FROM xla_ae_headers
1324: WHERE application_id = p_application_id

Line 5913: DELETE xla_distribution_links

5909: DELETE FROM xla_ae_header_acs
5910: WHERE ae_header_id = l_header_ids(j);
5911:
5912: FORALL j IN 1..i
5913: DELETE xla_distribution_links
5914: WHERE ae_header_id = l_header_ids(j)
5915: AND application_id = p_application_id;
5916:
5917: FORALL j in 1..i

Line 8127: INSERT INTO xla_distribution_links

8123: p_level => C_LEVEL_STATEMENT);
8124:
8125: END IF;
8126:
8127: INSERT INTO xla_distribution_links
8128: (application_id
8129: ,event_id
8130: ,ae_header_id
8131: ,ae_line_num

Line 8225: DELETE xla_distribution_links

8221: p_level => C_LEVEL_STATEMENT);
8222:
8223: END IF;
8224:
8225: DELETE xla_distribution_links
8226: WHERE application_id = p_application_id
8227: AND ref_ae_header_id = p_ref_ae_header_id
8228: AND temp_line_num = p_temp_line_num
8229: AND ae_header_id = p_ae_header_id;

Line 8311: UPDATE xla_distribution_links

8307: p_level => C_LEVEL_STATEMENT);
8308:
8309: END IF;
8310:
8311: UPDATE xla_distribution_links
8312: SET unrounded_entered_dr = p_unrounded_entered_dr
8313: ,unrounded_entered_cr = p_unrounded_entered_cr
8314: ,unrounded_accounted_dr = p_unrounded_accounted_dr
8315: ,unrounded_accounted_cr = p_undournde_accounted_cr

Line 8396: INSERT INTO xla_distribution_links

8392: AND ae_header_id = p_ref_ae_header_id;
8393:
8394: END IF;
8395:
8396: INSERT INTO xla_distribution_links
8397: (application_id
8398: ,event_id
8399: ,ae_header_id
8400: ,ae_line_num

Line 8491: FROM xla_distribution_links

8487: END IF;
8488:
8489: SELECT COUNT(1)
8490: INTO l_cnt
8491: FROM xla_distribution_links
8492: WHERE application_id = p_application_id
8493: AND ae_header_id = p_ae_header_id
8494: AND temp_line_num = -1 * p_temp_line_num
8495: AND ROWNUM <=1;

Line 8582: FROM xla_distribution_links

8578: ,temp_line_num
8579: INTO l_ref_ae_header_id
8580: ,l_ref_event_id
8581: ,l_temp_line_num
8582: FROM xla_distribution_links
8583: WHERE application_id = p_application_id
8584: AND ae_header_id = p_ae_header_id
8585: AND temp_line_num = -1 * p_temp_line_num
8586: AND ROWNUM <= 1;

Line 8696: FROM xla_distribution_links

8692: INTO l_ref_ae_header_id
8693: ,l_ref_event_id
8694: ,l_temp_line_num
8695: ,l_ref_temp_line_num
8696: FROM xla_distribution_links
8697: WHERE event_id =
8698: (SELECT ref_event_id
8699: FROM xla_distribution_links
8700: WHERE application_id = p_application_id -- non mrc

Line 8699: FROM xla_distribution_links

8695: ,l_ref_temp_line_num
8696: FROM xla_distribution_links
8697: WHERE event_id =
8698: (SELECT ref_event_id
8699: FROM xla_distribution_links
8700: WHERE application_id = p_application_id -- non mrc
8701: AND ae_header_id = p_ae_header_id -- non mrc
8702: AND temp_line_num = -1 * p_temp_line_num -- non mrc
8703: AND ROWNUM <= 1)

Line 8706: FROM xla_distribution_links

8702: AND temp_line_num = -1 * p_temp_line_num -- non mrc
8703: AND ROWNUM <= 1)
8704: AND ae_header_id <>
8705: (SELECT ref_ae_header_id
8706: FROM xla_distribution_links
8707: WHERE application_id = p_application_id -- non mrc
8708: AND ae_header_id = p_ae_header_id -- non mrc
8709: AND temp_line_num = -1 * p_temp_line_num -- non mrc
8710: AND ROWNUM <= 1)