APPS.XLA_AAD_MERGE_PVT dependencies on XLA_MAPPING_SET_VALUES

Line 5952: DELETE FROM xla_mapping_set_values w

5948: p_encoded_message => '# xla_mapping_sets_tl delete : '||l_num_rows,
5949: p_component_code => 'merge_mapping_sets');
5950:
5951: FORALL i in 1 .. l_ms.count
5952: DELETE FROM xla_mapping_set_values w
5953: WHERE amb_context_code = g_amb_context_code
5954: AND mapping_set_code = l_ms(i);
5955: l_num_rows := SQL%ROWCOUNT;
5956: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 5957: trace(p_msg => '# xla_mapping_set_values delete : '||l_num_rows,

5953: WHERE amb_context_code = g_amb_context_code
5954: AND mapping_set_code = l_ms(i);
5955: l_num_rows := SQL%ROWCOUNT;
5956: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5957: trace(p_msg => '# xla_mapping_set_values delete : '||l_num_rows,
5958: p_module => l_log_module,
5959: p_level => C_LEVEL_STATEMENT);
5960: END IF;
5961: -- Bug : 9923803

Line 5968: p_encoded_message => '# xla_mapping_set_values delete : '||l_num_rows,

5964: p_amb_context_code => g_amb_context_code,
5965: p_application_id => g_application_id,
5966: p_request_code => 'IMPORT' ,
5967: p_log_type_code => 'MERGE',
5968: p_encoded_message => '# xla_mapping_set_values delete : '||l_num_rows,
5969: p_component_code => 'merge_mapping_sets');
5970: END IF;
5971:
5972: -- Move the mapping sets from staging area to working area

Line 6048: UPDATE xla_mapping_set_values

6044: p_encoded_message => '# xla_mapping_sets_tl 2 updated : '||l_num_rows,
6045: p_component_code => 'merge_mapping_sets');
6046:
6047: FORALL i in 1 .. l_ms.count
6048: UPDATE xla_mapping_set_values
6049: SET amb_context_code = g_amb_context_code
6050: WHERE amb_context_code = g_staging_context_code
6051: AND mapping_set_code = l_ms(i);
6052: l_num_rows := SQL%ROWCOUNT;

Line 6054: trace(p_msg => '# xla_mapping_set_values updated : '||l_num_rows,

6050: WHERE amb_context_code = g_staging_context_code
6051: AND mapping_set_code = l_ms(i);
6052: l_num_rows := SQL%ROWCOUNT;
6053: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6054: trace(p_msg => '# xla_mapping_set_values updated : '||l_num_rows,
6055: p_module => l_log_module,
6056: p_level => C_LEVEL_STATEMENT);
6057: END IF;
6058: -- Bug : 9923803

Line 6065: p_encoded_message => '# xla_mapping_set_values updated : '||l_num_rows,

6061: p_amb_context_code => g_amb_context_code,
6062: p_application_id => g_application_id,
6063: p_request_code => 'IMPORT' ,
6064: p_log_type_code => 'MERGE',
6065: p_encoded_message => '# xla_mapping_set_values updated : '||l_num_rows,
6066: p_component_code => 'merge_mapping_sets');
6067:
6068: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
6069: trace(p_msg => 'END of procedure merge_mapping_sets',

Line 6471: DELETE FROM xla_mapping_set_values

6467: p_module => l_log_module,
6468: p_level => C_LEVEL_PROCEDURE);
6469: END IF;
6470:
6471: DELETE FROM xla_mapping_set_values
6472: WHERE amb_context_code = g_staging_context_code;
6473: l_num_rows := SQL%ROWCOUNT;
6474: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6475: trace(p_msg => '# xla_mapping_set_values delete : '||l_num_rows,

Line 6475: trace(p_msg => '# xla_mapping_set_values delete : '||l_num_rows,

6471: DELETE FROM xla_mapping_set_values
6472: WHERE amb_context_code = g_staging_context_code;
6473: l_num_rows := SQL%ROWCOUNT;
6474: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6475: trace(p_msg => '# xla_mapping_set_values delete : '||l_num_rows,
6476: p_module => l_log_module,
6477: p_level => C_LEVEL_STATEMENT);
6478: END IF;
6479: -- Bug : 9923803

Line 6486: p_encoded_message => '# xla_mapping_set_values delete : '||l_num_rows,

6482: p_amb_context_code => g_amb_context_code,
6483: p_application_id => g_application_id,
6484: p_request_code => 'IMPORT' ,
6485: p_log_type_code => 'MERGE',
6486: p_encoded_message => '# xla_mapping_set_values delete : '||l_num_rows,
6487: p_component_code => 'purge_mapping_sets');
6488: DELETE FROM xla_mapping_sets_tl
6489: WHERE amb_context_code = g_staging_context_code;
6490: l_num_rows := SQL%ROWCOUNT;