DBA Data[Home] [Help]

APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_AAD_LOADER_DEFNS_T

Line 2986: DELETE FROM xla_aad_loader_defns_t

2982: p_level => C_LEVEL_PROCEDURE);
2983: END IF;
2984:
2985: IF (l_staging_context_code IS NOT NULL) THEN
2986: DELETE FROM xla_aad_loader_defns_t
2987: WHERE staging_amb_context_code = l_staging_context_code;
2988:
2989: -- Bug 16208537
2990: -- API Call to Insert messages into AAD Loader Log Table.

Line 2996: p_encoded_message => '# delete (xla_aad_loader_defns_t) = '||SQL%ROWCOUNT,

2992: p_amb_context_code => l_staging_context_code,
2993: p_application_id => p_application_id,
2994: p_request_code => 'IMPORT' ,
2995: p_log_type_code => 'MERGE',
2996: p_encoded_message => '# delete (xla_aad_loader_defns_t) = '||SQL%ROWCOUNT,
2997: p_component_code => 'purge_aad');
2998:
2999: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3000: trace(p_msg => '# xla_aad_loader_defns_t deleted = '||SQL%ROWCOUNT,

Line 3000: trace(p_msg => '# xla_aad_loader_defns_t deleted = '||SQL%ROWCOUNT,

2996: p_encoded_message => '# delete (xla_aad_loader_defns_t) = '||SQL%ROWCOUNT,
2997: p_component_code => 'purge_aad');
2998:
2999: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3000: trace(p_msg => '# xla_aad_loader_defns_t deleted = '||SQL%ROWCOUNT,
3001: p_module => l_log_module,
3002: p_level => C_LEVEL_PROCEDURE);
3003: END IF;
3004:

Line 3064: DELETE FROM xla_aad_loader_defns_t

3060: END IF;
3061: ELSE
3062: l_staging_context_code := '';
3063:
3064: DELETE FROM xla_aad_loader_defns_t
3065: WHERE staging_amb_context_code = p_amb_context_code;
3066:
3067: -- Bug 16208537
3068: -- API Call to Insert messages into AAD Loader Log Table.

Line 3074: p_encoded_message => '# delete (xla_aad_loader_defns_t) = '||SQL%ROWCOUNT,

3070: p_amb_context_code => p_amb_context_code,
3071: p_application_id => p_application_id,
3072: p_request_code => 'IMPORT' ,
3073: p_log_type_code => 'MERGE',
3074: p_encoded_message => '# delete (xla_aad_loader_defns_t) = '||SQL%ROWCOUNT,
3075: p_component_code => 'purge_aad');
3076:
3077: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3078: trace(p_msg => '# xla_aad_loader_defns_t deleted = '||SQL%ROWCOUNT,

Line 3078: trace(p_msg => '# xla_aad_loader_defns_t deleted = '||SQL%ROWCOUNT,

3074: p_encoded_message => '# delete (xla_aad_loader_defns_t) = '||SQL%ROWCOUNT,
3075: p_component_code => 'purge_aad');
3076:
3077: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3078: trace(p_msg => '# xla_aad_loader_defns_t deleted = '||SQL%ROWCOUNT,
3079: p_module => l_log_module,
3080: p_level => C_LEVEL_PROCEDURE);
3081: END IF;
3082:

Line 3312: p_encoded_message => '# delete (xla_aad_loader_defns_t) = '||SQL%ROWCOUNT,

3308: p_amb_context_code => p_amb_context_code,
3309: p_application_id => p_application_id,
3310: p_request_code => 'IMPORT' ,
3311: p_log_type_code => 'MERGE',
3312: p_encoded_message => '# delete (xla_aad_loader_defns_t) = '||SQL%ROWCOUNT,
3313: p_component_code => 'purge_aad');
3314:
3315: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3316: trace(p_msg => '# xla_aad_line_defn_assgns deleted = '||SQL%ROWCOUNT,