APPS.XLA_AAD_MERGE_PVT dependencies on XLA_DESCRIPT_DETAILS_TL

Line 1346: DELETE FROM xla_descript_details_tl w

1342: p_encoded_message => '# xla_prod_acct_headers clear description = '||l_num_rows,
1343: p_component_code => 'clean_oracle_descriptions');
1344:
1345: FORALL i IN 1..l_codes.COUNT
1346: DELETE FROM xla_descript_details_tl w
1347: WHERE description_detail_id IN
1348: (SELECT description_detail_id
1349: FROM xla_descript_details_b d
1350: , xla_desc_priorities p

Line 1358: trace(p_msg => '# xla_descript_details_tl deleted = '||l_num_rows,

1354: AND p.description_type_code = C_OWNER_SYSTEM
1355: AND p.description_code = l_codes(i));
1356: l_num_rows := SQL%ROWCOUNT;
1357: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1358: trace(p_msg => '# xla_descript_details_tl deleted = '||l_num_rows,
1359: p_module => l_log_module,
1360: p_level => C_LEVEL_STATEMENT);
1361: END IF;
1362: -- Bug : 9923803

Line 1369: p_encoded_message => '# xla_descript_details_tl deleted = '||l_num_rows,

1365: p_amb_context_code => g_amb_context_code,
1366: p_application_id => g_application_id,
1367: p_request_code => 'IMPORT' ,
1368: p_log_type_code => 'MERGE',
1369: p_encoded_message => '# xla_descript_details_tl deleted = '||l_num_rows,
1370: p_component_code => 'clean_oracle_descriptions');
1371:
1372: FORALL i IN 1..l_codes.COUNT
1373: DELETE FROM xla_descript_details_b w

Line 4624: DELETE FROM xla_descript_details_tl w

4620: p_log_type_code => 'MERGE',
4621: p_encoded_message => '# xla_descript_details_b delete : '||l_num_rows,
4622: p_component_code => 'merge_descriptions');
4623:
4624: DELETE FROM xla_descript_details_tl w
4625: WHERE description_detail_id IN
4626: (SELECT description_detail_id
4627: FROM xla_descript_details_b d
4628: , xla_desc_priorities w

Line 4639: trace(p_msg => '# xla_descript_details_tl delete : '||l_num_rows,

4635: AND w.description_type_code = s.description_type_code
4636: AND w.description_code = s.description_code);
4637: l_num_rows := SQL%ROWCOUNT;
4638: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4639: trace(p_msg => '# xla_descript_details_tl delete : '||l_num_rows,
4640: p_module => l_log_module,
4641: p_level => C_LEVEL_STATEMENT);
4642: END IF;
4643: -- Bug : 9923803

Line 4650: p_encoded_message => '# xla_descript_details_tl delete : '||l_num_rows,

4646: p_amb_context_code => g_amb_context_code,
4647: p_application_id => g_application_id,
4648: p_request_code => 'IMPORT' ,
4649: p_log_type_code => 'MERGE',
4650: p_encoded_message => '# xla_descript_details_tl delete : '||l_num_rows,
4651: p_component_code => 'merge_descriptions');
4652: END IF;
4653:
4654: -- Move the descriptions from staging area to working area

Line 4790: UPDATE xla_descript_details_tl

4786: p_log_type_code => 'MERGE',
4787: p_encoded_message => '# xla_descript_details_b updated : '||l_num_rows,
4788: p_component_code => 'merge_descriptions');
4789:
4790: UPDATE xla_descript_details_tl
4791: SET amb_context_code = g_amb_context_code
4792: WHERE amb_context_code = g_staging_context_code;
4793: l_num_rows := SQL%ROWCOUNT;
4794: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 4795: trace(p_msg => '# xla_descript_details_tl updated : '||l_num_rows,

4791: SET amb_context_code = g_amb_context_code
4792: WHERE amb_context_code = g_staging_context_code;
4793: l_num_rows := SQL%ROWCOUNT;
4794: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4795: trace(p_msg => '# xla_descript_details_tl updated : '||l_num_rows,
4796: p_module => l_log_module,
4797: p_level => C_LEVEL_STATEMENT);
4798: END IF;
4799: -- Bug : 9923803

Line 4806: p_encoded_message => '# xla_descript_details_tl updated : '||l_num_rows,

4802: p_amb_context_code => g_amb_context_code,
4803: p_application_id => g_application_id,
4804: p_request_code => 'IMPORT' ,
4805: p_log_type_code => 'MERGE',
4806: p_encoded_message => '# xla_descript_details_tl updated : '||l_num_rows,
4807: p_component_code => 'merge_descriptions');
4808: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4809: trace(p_msg => 'END of procedure merge_descriptions',
4810: p_module => l_log_module,