APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_JLT_ACCT_ATTRS

Line 716: DELETE FROM xla_jlt_acct_attrs

712:
713: --
714: -- Delete journal line types
715: --
716: DELETE FROM xla_jlt_acct_attrs
717: WHERE application_id = p_application_id
718: AND amb_context_code = p_amb_context_code;
719:
720: -- Bug : 16208537

Line 727: p_encoded_message => '# delete (xla_jlt_acct_attrs) = '||SQL%ROWCOUNT,

723: p_amb_context_code => p_amb_context_code,
724: p_application_id => p_application_id,
725: p_request_code => 'IMPORT' ,
726: p_log_type_code => 'MERGE',
727: p_encoded_message => '# delete (xla_jlt_acct_attrs) = '||SQL%ROWCOUNT,
728: p_component_code => 'purge');
729:
730: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
731: trace(p_msg => '# record deleted from xla_jlt_acct_attrs = '||SQL%ROWCOUNT,

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

727: p_encoded_message => '# delete (xla_jlt_acct_attrs) = '||SQL%ROWCOUNT,
728: p_component_code => 'purge');
729:
730: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
731: trace(p_msg => '# record deleted from xla_jlt_acct_attrs = '||SQL%ROWCOUNT,
732: p_module => l_log_module,
733: p_level => C_LEVEL_STATEMENT);
734: END IF;
735:

Line 947: FROM xla_jlt_acct_attrs

943: FOR UPDATE NOWAIT;
944:
945: CURSOR c_jlt_acct_attrs IS
946: SELECT *
947: FROM xla_jlt_acct_attrs
948: WHERE application_id = p_application_id
949: AND amb_context_code = p_amb_context_code
950: FOR UPDATE NOWAIT;
951:

Line 3321: DELETE FROM xla_jlt_acct_attrs

3317: p_module => l_log_module,
3318: p_level => C_LEVEL_PROCEDURE);
3319: END IF;
3320:
3321: DELETE FROM xla_jlt_acct_attrs
3322: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3323: AND application_id = p_application_id;
3324:
3325: -- Bug 16208537

Line 3332: p_encoded_message => '# delete (xla_jlt_acct_attrs) = '||SQL%ROWCOUNT,

3328: p_amb_context_code => p_amb_context_code,
3329: p_application_id => p_application_id,
3330: p_request_code => 'IMPORT' ,
3331: p_log_type_code => 'MERGE',
3332: p_encoded_message => '# delete (xla_jlt_acct_attrs) = '||SQL%ROWCOUNT,
3333: p_component_code => 'purge_aad');
3334:
3335: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3336: trace(p_msg => '# xla_jlt_acct_attrs deleted = '||SQL%ROWCOUNT,

Line 3336: trace(p_msg => '# xla_jlt_acct_attrs deleted = '||SQL%ROWCOUNT,

3332: p_encoded_message => '# delete (xla_jlt_acct_attrs) = '||SQL%ROWCOUNT,
3333: p_component_code => 'purge_aad');
3334:
3335: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3336: trace(p_msg => '# xla_jlt_acct_attrs deleted = '||SQL%ROWCOUNT,
3337: p_module => l_log_module,
3338: p_level => C_LEVEL_PROCEDURE);
3339: END IF;
3340: