APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_ACCT_LINE_TYPES_B

Line 756: DELETE FROM xla_acct_line_types_b

752: p_module => l_log_module,
753: p_level => C_LEVEL_STATEMENT);
754: END IF;
755:
756: DELETE FROM xla_acct_line_types_b
757: WHERE application_id = p_application_id
758: AND amb_context_code = p_amb_context_code;
759:
760: -- Bug : 16208537

Line 767: p_encoded_message => '# delete (xla_acct_line_types_b) = '||SQL%ROWCOUNT,

763: p_amb_context_code => p_amb_context_code,
764: p_application_id => p_application_id,
765: p_request_code => 'IMPORT' ,
766: p_log_type_code => 'MERGE',
767: p_encoded_message => '# delete (xla_acct_line_types_b) = '||SQL%ROWCOUNT,
768: p_component_code => 'purge');
769:
770: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
771: trace(p_msg => '# record deleted from xla_acct_line_types_b = '||SQL%ROWCOUNT,

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

767: p_encoded_message => '# delete (xla_acct_line_types_b) = '||SQL%ROWCOUNT,
768: p_component_code => 'purge');
769:
770: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
771: trace(p_msg => '# record deleted from xla_acct_line_types_b = '||SQL%ROWCOUNT,
772: p_module => l_log_module,
773: p_level => C_LEVEL_STATEMENT);
774: END IF;
775:

Line 933: FROM xla_acct_line_types_b

929: FOR UPDATE NOWAIT;
930:
931: CURSOR c_acct_line_types_b IS
932: SELECT *
933: FROM xla_acct_line_types_b
934: WHERE application_id = p_application_id
935: AND amb_context_code = p_amb_context_code
936: FOR UPDATE NOWAIT;
937:

Line 3834: DELETE FROM xla_acct_line_types_b

3830: p_module => l_log_module,
3831: p_level => C_LEVEL_PROCEDURE);
3832: END IF;
3833:
3834: DELETE FROM xla_acct_line_types_b
3835: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3836: AND application_id = p_application_id;
3837:
3838: -- Bug 16208537

Line 3845: p_encoded_message => '# delete (xla_acct_line_types_b) = '||SQL%ROWCOUNT,

3841: p_amb_context_code => p_amb_context_code,
3842: p_application_id => p_application_id,
3843: p_request_code => 'IMPORT' ,
3844: p_log_type_code => 'MERGE',
3845: p_encoded_message => '# delete (xla_acct_line_types_b) = '||SQL%ROWCOUNT,
3846: p_component_code => 'purge_aad');
3847:
3848: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3849: trace(p_msg => '# xla_acct_line_types_b deleted = '||SQL%ROWCOUNT,

Line 3849: trace(p_msg => '# xla_acct_line_types_b deleted = '||SQL%ROWCOUNT,

3845: p_encoded_message => '# delete (xla_acct_line_types_b) = '||SQL%ROWCOUNT,
3846: p_component_code => 'purge_aad');
3847:
3848: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3849: trace(p_msg => '# xla_acct_line_types_b deleted = '||SQL%ROWCOUNT,
3850: p_module => l_log_module,
3851: p_level => C_LEVEL_PROCEDURE);
3852: END IF;
3853: