APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_DESC_PRIORITIES

Line 609: ,xla_desc_priorities dp

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);
613:

Line 633: FROM xla_desc_priorities

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
635: AND amb_context_code = p_amb_context_code);
636:
637: -- Bug : 16208537

Line 653: DELETE FROM xla_desc_priorities

649: p_module => l_log_module,
650: p_level => C_LEVEL_STATEMENT);
651: END IF;
652:
653: DELETE FROM xla_desc_priorities
654: WHERE application_id = p_application_id
655: AND amb_context_code = p_amb_context_code;
656:
657: -- Bug : 16208537

Line 664: p_encoded_message => '# delete (xla_desc_priorities) = '||SQL%ROWCOUNT,

660: p_amb_context_code => p_amb_context_code,
661: p_application_id => p_application_id,
662: p_request_code => 'IMPORT' ,
663: p_log_type_code => 'MERGE',
664: p_encoded_message => '# delete (xla_desc_priorities) = '||SQL%ROWCOUNT,
665: p_component_code => 'purge');
666:
667: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
668: trace(p_msg => '# record deleted from xla_desc_priorities = '||SQL%ROWCOUNT,

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

664: p_encoded_message => '# delete (xla_desc_priorities) = '||SQL%ROWCOUNT,
665: p_component_code => 'purge');
666:
667: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
668: trace(p_msg => '# record deleted from xla_desc_priorities = '||SQL%ROWCOUNT,
669: p_module => l_log_module,
670: p_level => C_LEVEL_STATEMENT);
671: END IF;
672:

Line 968: FROM xla_desc_priorities

964: FOR UPDATE NOWAIT;
965:
966: CURSOR c_desc_priorities IS
967: SELECT *
968: FROM xla_desc_priorities
969: WHERE application_id = p_application_id
970: AND amb_context_code = p_amb_context_code
971: FOR UPDATE NOWAIT;
972:

Line 977: ,xla_desc_priorities p

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
981: AND p.amb_context_code = p_amb_context_code

Line 3710: ,xla_desc_priorities p

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));
3714:

Line 3734: FROM xla_desc_priorities

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)
3736: AND application_id = p_application_id);
3737:
3738: -- Bug 16208537

Line 3754: DELETE FROM xla_desc_priorities

3750: p_module => l_log_module,
3751: p_level => C_LEVEL_PROCEDURE);
3752: END IF;
3753:
3754: DELETE FROM xla_desc_priorities
3755: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3756: AND application_id = p_application_id;
3757:
3758: -- Bug 16208537

Line 3765: p_encoded_message => '# delete (xla_desc_priorities) = '||SQL%ROWCOUNT,

3761: p_amb_context_code => p_amb_context_code,
3762: p_application_id => p_application_id,
3763: p_request_code => 'IMPORT' ,
3764: p_log_type_code => 'MERGE',
3765: p_encoded_message => '# delete (xla_desc_priorities) = '||SQL%ROWCOUNT,
3766: p_component_code => 'purge_aad');
3767:
3768: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3769: trace(p_msg => '# xla_desc_priorities deleted = '||SQL%ROWCOUNT,

Line 3769: trace(p_msg => '# xla_desc_priorities deleted = '||SQL%ROWCOUNT,

3765: p_encoded_message => '# delete (xla_desc_priorities) = '||SQL%ROWCOUNT,
3766: p_component_code => 'purge_aad');
3767:
3768: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3769: trace(p_msg => '# xla_desc_priorities deleted = '||SQL%ROWCOUNT,
3770: p_module => l_log_module,
3771: p_level => C_LEVEL_PROCEDURE);
3772: END IF;
3773: