APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_DESCRIPT_DETAILS_B

Line 608: FROM xla_descript_details_b dd

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
610: WHERE dd.description_prio_id = dp.description_prio_id
611: AND dp.application_id = p_application_id
612: AND dp.amb_context_code = p_amb_context_code);

Line 630: DELETE FROM xla_descript_details_b

626: p_module => l_log_module,
627: p_level => C_LEVEL_STATEMENT);
628: END IF;
629:
630: DELETE FROM xla_descript_details_b
631: WHERE description_prio_id IN
632: (SELECT description_prio_id
633: FROM xla_desc_priorities
634: WHERE application_id = p_application_id

Line 644: p_encoded_message => '# delete (xla_descript_details_b) = '||SQL%ROWCOUNT,

640: p_amb_context_code => p_amb_context_code,
641: p_application_id => p_application_id,
642: p_request_code => 'IMPORT' ,
643: p_log_type_code => 'MERGE',
644: p_encoded_message => '# delete (xla_descript_details_b) = '||SQL%ROWCOUNT,
645: p_component_code => 'purge');
646:
647: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
648: trace(p_msg => '# record deleted from xla_descript_details_b = '||SQL%ROWCOUNT,

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

644: p_encoded_message => '# delete (xla_descript_details_b) = '||SQL%ROWCOUNT,
645: p_component_code => 'purge');
646:
647: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
648: trace(p_msg => '# record deleted from xla_descript_details_b = '||SQL%ROWCOUNT,
649: p_module => l_log_module,
650: p_level => C_LEVEL_STATEMENT);
651: END IF;
652:

Line 975: FROM xla_descript_details_b b

971: FOR UPDATE NOWAIT;
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

Line 3709: FROM xla_descript_details_b d

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
3711: WHERE d.description_prio_id = p.description_prio_id
3712: AND p.application_id = p_application_id
3713: AND p.amb_context_code IN (p_amb_context_code, l_staging_context_code));

Line 3731: DELETE FROM xla_descript_details_b

3727: p_module => l_log_module,
3728: p_level => C_LEVEL_PROCEDURE);
3729: END IF;
3730:
3731: DELETE FROM xla_descript_details_b
3732: WHERE description_prio_id IN
3733: (SELECT description_prio_id
3734: FROM xla_desc_priorities
3735: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)

Line 3745: p_encoded_message => '# delete (xla_descript_details_b) = '||SQL%ROWCOUNT,

3741: p_amb_context_code => p_amb_context_code,
3742: p_application_id => p_application_id,
3743: p_request_code => 'IMPORT' ,
3744: p_log_type_code => 'MERGE',
3745: p_encoded_message => '# delete (xla_descript_details_b) = '||SQL%ROWCOUNT,
3746: p_component_code => 'purge_aad');
3747:
3748: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3749: trace(p_msg => '# xla_descript_details_b deleted = '||SQL%ROWCOUNT,

Line 3749: trace(p_msg => '# xla_descript_details_b deleted = '||SQL%ROWCOUNT,

3745: p_encoded_message => '# delete (xla_descript_details_b) = '||SQL%ROWCOUNT,
3746: p_component_code => 'purge_aad');
3747:
3748: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3749: trace(p_msg => '# xla_descript_details_b deleted = '||SQL%ROWCOUNT,
3750: p_module => l_log_module,
3751: p_level => C_LEVEL_PROCEDURE);
3752: END IF;
3753: