APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_ACCT_LINE_TYPES_TL

Line 736: DELETE FROM xla_acct_line_types_tl

732: p_module => l_log_module,
733: p_level => C_LEVEL_STATEMENT);
734: END IF;
735:
736: DELETE FROM xla_acct_line_types_tl
737: WHERE application_id = p_application_id
738: AND amb_context_code = p_amb_context_code;
739:
740: -- Bug : 16208537

Line 747: p_encoded_message => '# delete (xla_acct_line_types_tl) = '||SQL%ROWCOUNT,

743: p_amb_context_code => p_amb_context_code,
744: p_application_id => p_application_id,
745: p_request_code => 'IMPORT' ,
746: p_log_type_code => 'MERGE',
747: p_encoded_message => '# delete (xla_acct_line_types_tl) = '||SQL%ROWCOUNT,
748: p_component_code => 'purge');
749:
750: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
751: trace(p_msg => '# record deleted from xla_acct_line_types_tl = '||SQL%ROWCOUNT,

Line 751: trace(p_msg => '# record deleted from xla_acct_line_types_tl = '||SQL%ROWCOUNT,

747: p_encoded_message => '# delete (xla_acct_line_types_tl) = '||SQL%ROWCOUNT,
748: p_component_code => 'purge');
749:
750: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
751: trace(p_msg => '# record deleted from xla_acct_line_types_tl = '||SQL%ROWCOUNT,
752: p_module => l_log_module,
753: p_level => C_LEVEL_STATEMENT);
754: END IF;
755:

Line 940: FROM xla_acct_line_types_tl

936: FOR UPDATE NOWAIT;
937:
938: CURSOR c_acct_line_types_tl IS
939: SELECT *
940: FROM xla_acct_line_types_tl
941: WHERE application_id = p_application_id
942: AND amb_context_code = p_amb_context_code
943: FOR UPDATE NOWAIT;
944:

Line 3814: DELETE FROM xla_acct_line_types_tl

3810: p_module => l_log_module,
3811: p_level => C_LEVEL_PROCEDURE);
3812: END IF;
3813:
3814: DELETE FROM xla_acct_line_types_tl
3815: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3816: AND application_id = p_application_id;
3817:
3818: -- Bug 16208537

Line 3825: p_encoded_message => '# delete (xla_acct_line_types_tl) = '||SQL%ROWCOUNT,

3821: p_amb_context_code => p_amb_context_code,
3822: p_application_id => p_application_id,
3823: p_request_code => 'IMPORT' ,
3824: p_log_type_code => 'MERGE',
3825: p_encoded_message => '# delete (xla_acct_line_types_tl) = '||SQL%ROWCOUNT,
3826: p_component_code => 'purge_aad');
3827:
3828: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3829: trace(p_msg => '# xla_acct_line_types_tl deleted = '||SQL%ROWCOUNT,

Line 3829: trace(p_msg => '# xla_acct_line_types_tl deleted = '||SQL%ROWCOUNT,

3825: p_encoded_message => '# delete (xla_acct_line_types_tl) = '||SQL%ROWCOUNT,
3826: p_component_code => 'purge_aad');
3827:
3828: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3829: trace(p_msg => '# xla_acct_line_types_tl deleted = '||SQL%ROWCOUNT,
3830: p_module => l_log_module,
3831: p_level => C_LEVEL_PROCEDURE);
3832: END IF;
3833: