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_ACCOUNTING_PKG dependencies on XLA_AE_HEADERS

Line 3868: xla_ae_headers xh

3864: DELETE FROM xla_distribution_links
3865: WHERE ae_header_id IN
3866: (SELECT /*+ cardinality(XE,10) leading(XE) use_nl(XH) unnest */ xh.ae_header_id
3867: FROM xla_events_gt xe,
3868: xla_ae_headers xh
3869: WHERE xe.process_status_code in ('D','E','R','I')
3870: AND xh.application_id = xe.application_id
3871: AND xh.event_id = xe.event_id
3872: )

Line 3893: xla_ae_headers xh

3889: FROM xla_ae_segment_values
3890: WHERE ae_header_id IN
3891: (SELECT xh.ae_header_id
3892: FROM xla_events_gt xe,
3893: xla_ae_headers xh
3894: WHERE xe.process_status_code in ('D','E','R', 'I')
3895: AND xh.application_id = xe.application_id
3896: AND xh.event_id = xe.event_id
3897: );

Line 3913: ,xla_ae_headers aeh

3909: DELETE FROM xla_ae_line_acs
3910: WHERE ae_header_id IN
3911: (SELECT aeh.ae_header_id
3912: FROM xla_events_gt evt
3913: ,xla_ae_headers aeh
3914: WHERE evt.process_status_code in ('D','E','R','I')
3915: AND aeh.application_id = evt.application_id
3916: AND aeh.event_id = evt.event_id);
3917:

Line 3932: ,xla_ae_headers aeh

3928: DELETE FROM xla_ae_header_acs
3929: WHERE ae_header_id IN
3930: (SELECT aeh.ae_header_id
3931: FROM xla_events_gt evt
3932: ,xla_ae_headers aeh
3933: WHERE evt.process_status_code in ('D','E','R','I')
3934: AND aeh.application_id = evt.application_id
3935: AND aeh.event_id = evt.event_id);
3936:

Line 3952: xla_ae_headers xh

3948: WHERE application_id = g_application_id
3949: AND ae_header_id IN
3950: (SELECT xh.ae_header_id
3951: FROM xla_events_gt xe,
3952: xla_ae_headers xh
3953: WHERE xe.process_status_code in ('D','E','R','I')
3954: AND xh.application_id = xe.application_id
3955: AND xh.event_id = xe.event_id
3956: );

Line 3966: -- Delete from xla_ae_headers

3962: ,p_module => l_log_module);
3963: END IF;
3964:
3965: --
3966: -- Delete from xla_ae_headers
3967: --
3968: DELETE /*+ index(aeh, xla_ae_headers_n2) */
3969: FROM xla_ae_headers aeh
3970: WHERE application_id = g_application_id

Line 3968: DELETE /+ index(aeh, xla_ae_headers_n2) /

3964:
3965: --
3966: -- Delete from xla_ae_headers
3967: --
3968: DELETE /*+ index(aeh, xla_ae_headers_n2) */
3969: FROM xla_ae_headers aeh
3970: WHERE application_id = g_application_id
3971: AND event_id IN (SELECT event_id
3972: FROM xla_events_gt

Line 3969: FROM xla_ae_headers aeh

3965: --
3966: -- Delete from xla_ae_headers
3967: --
3968: DELETE /*+ index(aeh, xla_ae_headers_n2) */
3969: FROM xla_ae_headers aeh
3970: WHERE application_id = g_application_id
3971: AND event_id IN (SELECT event_id
3972: FROM xla_events_gt
3973: WHERE process_status_code IN ('D','E','R','I'));

Line 6688: l_xla_seq_entity VARCHAR2(30) := 'XLA_AE_HEADERS';

6684: --=============================================================================
6685: PROCEDURE sequencing_batch_init
6686: (p_seq_enabled_flag IN OUT NOCOPY VARCHAR2) IS
6687: l_xla_application_id NUMBER := 602;
6688: l_xla_seq_entity VARCHAR2(30) := 'XLA_AE_HEADERS';
6689: l_seq_event_code VARCHAR2(30) := 'COMPLETION';
6690: l_seq_context_value fun_seq_batch.context_value_tbl_type;
6691:
6692: l_seq_status VARCHAR2(30);

Line 6953: DELETE FROM XLA_AE_HEADERS_GT;

6949: (p_msg => '# rows deleted XLA_AE_LINES_GT = '||SQL%ROWCOUNT
6950: ,p_level => C_LEVEL_PROCEDURE
6951: ,p_module => l_log_module);
6952: END IF;
6953: DELETE FROM XLA_AE_HEADERS_GT;
6954: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
6955: trace
6956: (p_msg => '# rows deleted XLA_AE_HEADERS_GT = '||SQL%ROWCOUNT
6957: ,p_level => C_LEVEL_PROCEDURE

Line 6956: (p_msg => '# rows deleted XLA_AE_HEADERS_GT = '||SQL%ROWCOUNT

6952: END IF;
6953: DELETE FROM XLA_AE_HEADERS_GT;
6954: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
6955: trace
6956: (p_msg => '# rows deleted XLA_AE_HEADERS_GT = '||SQL%ROWCOUNT
6957: ,p_level => C_LEVEL_PROCEDURE
6958: ,p_module => l_log_module);
6959: END IF;
6960: DELETE FROM XLA_VALIDATION_LINES_GT;

Line 7178: FROM xla_ae_headers xah

7174:
7175: CURSOR c_headers IS
7176: SELECT /*+ LEADING (XAP) USE_NL (XAP XE XAH) */
7177: xah.ae_header_id
7178: FROM xla_ae_headers xah
7179: , xla_events xe
7180: , xla_acct_prog_events_gt xap
7181: WHERE xah.application_id = xe.application_id
7182: AND xah.event_id = xe.event_id

Line 7345: DELETE FROM xla_ae_headers

7341: ,p_module => l_log_module);
7342: END IF;
7343:
7344: FORALL i IN 1..l_array_header_id.COUNT
7345: DELETE FROM xla_ae_headers
7346: WHERE application_id = g_application_id
7347: AND ae_header_id = l_array_header_id(i);
7348:
7349: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 7350: trace(p_msg => '# xla_ae_headers deleted = '||SQL%ROWCOUNT

7346: WHERE application_id = g_application_id
7347: AND ae_header_id = l_array_header_id(i);
7348:
7349: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
7350: trace(p_msg => '# xla_ae_headers deleted = '||SQL%ROWCOUNT
7351: ,p_level => C_LEVEL_STATEMENT
7352: ,p_module => l_log_module);
7353: END IF;
7354: END IF;

Line 7415: l_xla_seq_entity VARCHAR2(30) := 'XLA_AE_HEADERS';

7411: l_array_assignment_id t_array_number;
7412: l_array_error_code t_array_char;
7413:
7414: l_xla_application_id NUMBER := 602;
7415: l_xla_seq_entity VARCHAR2(30) := 'XLA_AE_HEADERS';
7416: l_seq_event_code VARCHAR2(30) := 'COMPLETION';
7417: l_control_attribute_rec fun_seq.control_attribute_rec_type;
7418: l_control_date_tbl fun_seq.control_date_tbl_type;
7419:

Line 7515: FOR c1 IN (SELECT /+ leading(xsl,xeg,aeh) use_nl(aeh) index(xla_ae_headers_n2) /

7511: END;
7512: ELSIF g_processing_mode = 'DOCUMENT' THEN
7513: print_logfile(to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Calling sequencing get_sequence_number');
7514:
7515: FOR c1 IN (SELECT /*+ leading(xsl,xeg,aeh) use_nl(aeh) index(xla_ae_headers_n2) */
7516: aeh.ae_header_id ae_header_id
7517: ,aeh.ledger_id ledger_id
7518: ,aeh.balance_type_code balance_type_code
7519: ,xsl.je_source_name je_source_name

Line 7526: FROM xla_ae_headers aeh

7522: ,aeh.event_type_code accounting_event_type_code
7523: ,aeh.accounting_entry_type_code accounting_entry_type_code
7524: ,aeh.accounting_date gl_date
7525: ,aeh.completed_date completion_date
7526: FROM xla_ae_headers aeh
7527: ,xla_events_gt xeg
7528: ,xla_subledgers xsl
7529: WHERE aeh.application_id = xeg.application_id
7530: AND aeh.event_id = xeg.event_id

Line 7619: UPDATE xla_ae_headers aeh

7615: END;
7616: END LOOP;
7617:
7618: FORALL i IN 1..l_array_ae_header_id.COUNT
7619: UPDATE xla_ae_headers aeh
7620: SET aeh.completed_date = l_array_completion_date(i)
7621: ,aeh.completion_acct_seq_assign_id = l_array_assignment_id(i)
7622: ,aeh.completion_acct_seq_version_id = l_array_seq_version_id(i)
7623: ,aeh.completion_acct_seq_value = l_array_sequence_number(i)