APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_DESCRIPT_DETAILS_TL

Line 605: DELETE FROM xla_descript_details_tl

601:
602: --
603: -- Delete descriptions
604: --
605: DELETE FROM xla_descript_details_tl
606: WHERE description_detail_id IN
607: (SELECT description_detail_id
608: FROM xla_descript_details_b dd
609: ,xla_desc_priorities dp

Line 621: p_encoded_message => '# delete (xla_descript_details_tl) = '||SQL%ROWCOUNT,

617: p_amb_context_code => p_amb_context_code,
618: p_application_id => p_application_id,
619: p_request_code => 'IMPORT' ,
620: p_log_type_code => 'MERGE',
621: p_encoded_message => '# delete (xla_descript_details_tl) = '||SQL%ROWCOUNT,
622: p_component_code => 'purge');
623:
624: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
625: trace(p_msg => '# record deleted from xla_descript_details_tl = '||SQL%ROWCOUNT,

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

621: p_encoded_message => '# delete (xla_descript_details_tl) = '||SQL%ROWCOUNT,
622: p_component_code => 'purge');
623:
624: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
625: trace(p_msg => '# record deleted from xla_descript_details_tl = '||SQL%ROWCOUNT,
626: p_module => l_log_module,
627: p_level => C_LEVEL_STATEMENT);
628: END IF;
629:

Line 976: ,xla_descript_details_tl t

972:
973: CURSOR c_descript_details_tl IS
974: SELECT *
975: FROM xla_descript_details_b b
976: ,xla_descript_details_tl t
977: ,xla_desc_priorities p
978: WHERE t.description_detail_id = b.description_detail_id
979: AND b.description_prio_id = p.description_prio_id
980: AND p.application_id = p_application_id

Line 3706: DELETE FROM xla_descript_details_tl

3702: p_module => l_log_module,
3703: p_level => C_LEVEL_PROCEDURE);
3704: END IF;
3705:
3706: DELETE FROM xla_descript_details_tl
3707: WHERE description_detail_id IN
3708: (SELECT d.description_detail_id
3709: FROM xla_descript_details_b d
3710: ,xla_desc_priorities p

Line 3722: p_encoded_message => '# delete (xla_descript_details_tl) = '||SQL%ROWCOUNT,

3718: p_amb_context_code => p_amb_context_code,
3719: p_application_id => p_application_id,
3720: p_request_code => 'IMPORT' ,
3721: p_log_type_code => 'MERGE',
3722: p_encoded_message => '# delete (xla_descript_details_tl) = '||SQL%ROWCOUNT,
3723: p_component_code => 'purge_aad');
3724:
3725: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3726: trace(p_msg => '# xla_descript_details_tl deleted = '||SQL%ROWCOUNT,

Line 3726: trace(p_msg => '# xla_descript_details_tl deleted = '||SQL%ROWCOUNT,

3722: p_encoded_message => '# delete (xla_descript_details_tl) = '||SQL%ROWCOUNT,
3723: p_component_code => 'purge_aad');
3724:
3725: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3726: trace(p_msg => '# xla_descript_details_tl deleted = '||SQL%ROWCOUNT,
3727: p_module => l_log_module,
3728: p_level => C_LEVEL_PROCEDURE);
3729: END IF;
3730: