APPS.XLA_AAD_MERGE_PVT dependencies on XLA_MAPPING_SETS_B

Line 5873: FROM xla_mapping_sets_b s

5869: IS
5870: -- Retrieve the mapping sets to be merged
5871: CURSOR c_ms IS
5872: SELECT s.mapping_set_code
5873: FROM xla_mapping_sets_b s
5874: , xla_mapping_sets_b w
5875: WHERE s.amb_context_code = g_staging_context_code
5876: AND w.amb_context_code(+) = g_amb_context_code
5877: AND s.mapping_set_code = w.mapping_set_code(+)

Line 5874: , xla_mapping_sets_b w

5870: -- Retrieve the mapping sets to be merged
5871: CURSOR c_ms IS
5872: SELECT s.mapping_set_code
5873: FROM xla_mapping_sets_b s
5874: , xla_mapping_sets_b w
5875: WHERE s.amb_context_code = g_staging_context_code
5876: AND w.amb_context_code(+) = g_amb_context_code
5877: AND s.mapping_set_code = w.mapping_set_code(+)
5878: AND s.version_num >= w.version_num(+);

Line 5907: DELETE FROM xla_mapping_sets_b w

5903: CLOSE c_ms;
5904:
5905: -- Delete the MSs from the working area to be merged
5906: FORALL i in 1 .. l_ms.count
5907: DELETE FROM xla_mapping_sets_b w
5908: WHERE amb_context_code = g_amb_context_code
5909: AND mapping_set_code = l_ms(i);
5910: l_num_rows := SQL%ROWCOUNT;
5911: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 5912: trace(p_msg => '# xla_mapping_sets_b delete : '||l_num_rows,

5908: WHERE amb_context_code = g_amb_context_code
5909: AND mapping_set_code = l_ms(i);
5910: l_num_rows := SQL%ROWCOUNT;
5911: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5912: trace(p_msg => '# xla_mapping_sets_b delete : '||l_num_rows,
5913: p_module => l_log_module,
5914: p_level => C_LEVEL_STATEMENT);
5915: END IF;
5916: -- Bug : 9923803

Line 5974: UPDATE xla_mapping_sets_b

5970: END IF;
5971:
5972: -- Move the mapping sets from staging area to working area
5973: FORALL i in 1 .. l_ms.count
5974: UPDATE xla_mapping_sets_b
5975: SET amb_context_code = g_amb_context_code
5976: WHERE amb_context_code = g_staging_context_code
5977: AND mapping_set_code = l_ms(i);
5978: l_num_rows := SQL%ROWCOUNT;

Line 5980: trace(p_msg => '# xla_mapping_sets_b updated : '||l_num_rows,

5976: WHERE amb_context_code = g_staging_context_code
5977: AND mapping_set_code = l_ms(i);
5978: l_num_rows := SQL%ROWCOUNT;
5979: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5980: trace(p_msg => '# xla_mapping_sets_b updated : '||l_num_rows,
5981: p_module => l_log_module,
5982: p_level => C_LEVEL_STATEMENT);
5983: END IF;
5984: -- Bug : 9923803

Line 5991: p_encoded_message => '# xla_mapping_sets_b updated : '||l_num_rows,

5987: p_amb_context_code => g_amb_context_code,
5988: p_application_id => g_application_id,
5989: p_request_code => 'IMPORT' ,
5990: p_log_type_code => 'MERGE',
5991: p_encoded_message => '# xla_mapping_sets_b updated : '||l_num_rows,
5992: p_component_code => 'merge_mapping_sets');
5993:
5994: FORALL i in 1 .. l_ms.count
5995: UPDATE xla_mapping_sets_tl s

Line 6505: DELETE FROM xla_mapping_sets_b

6501: p_request_code => 'IMPORT' ,
6502: p_log_type_code => 'MERGE',
6503: p_encoded_message => '# xla_mapping_sets_tl delete : '||l_num_rows,
6504: p_component_code => 'purge_mapping_sets');
6505: DELETE FROM xla_mapping_sets_b
6506: WHERE amb_context_code = g_staging_context_code;
6507: l_num_rows := SQL%ROWCOUNT;
6508: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6509: trace(p_msg => '# xla_mapping_sets_b delete : '||l_num_rows,

Line 6509: trace(p_msg => '# xla_mapping_sets_b delete : '||l_num_rows,

6505: DELETE FROM xla_mapping_sets_b
6506: WHERE amb_context_code = g_staging_context_code;
6507: l_num_rows := SQL%ROWCOUNT;
6508: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6509: trace(p_msg => '# xla_mapping_sets_b delete : '||l_num_rows,
6510: p_module => l_log_module,
6511: p_level => C_LEVEL_STATEMENT);
6512: END IF;
6513: -- Bug : 9923803

Line 6520: p_encoded_message => '# xla_mapping_sets_b delete : '||l_num_rows,

6516: p_amb_context_code => g_amb_context_code,
6517: p_application_id => g_application_id,
6518: p_request_code => 'IMPORT' ,
6519: p_log_type_code => 'MERGE',
6520: p_encoded_message => '# xla_mapping_sets_b delete : '||l_num_rows,
6521: p_component_code => 'purge_mapping_sets');
6522: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
6523: trace(p_msg => 'END of procedure purge_mapping_sets',
6524: p_module => l_log_module,