APPS.XLA_AAD_UPLOAD_PVT dependencies on XLA_DESC_PRIORITIES

Line 861: INSERT INTO xla_desc_priorities

857: p_module => l_log_module,
858: p_level => C_LEVEL_EVENT);
859: END IF;
860:
861: INSERT INTO xla_desc_priorities
862: (application_id
863: ,amb_context_code
864: ,description_type_code
865: ,description_code

Line 878: ,xla_desc_priorities_s.nextval

874: p_application_id
875: ,p_staging_context_code
876: ,description_type_code
877: ,description_code
878: ,xla_desc_priorities_s.nextval
879: ,priority_num
880: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
881: ,fnd_load_util.owner_id(owner)
882: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)

Line 886: WHERE table_name = 'XLA_DESC_PRIORITIES'

882: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
883: ,fnd_load_util.owner_id(owner)
884: ,0
885: FROM xla_aad_loader_defns_t
886: WHERE table_name = 'XLA_DESC_PRIORITIES'
887: AND staging_amb_context_code = p_staging_context_code;
888:
889: IF (C_LEVEL_EVENT >= g_log_level) THEN
890: trace(p_msg => '# insert (XLA_DESC_PRIORITIES) = '||SQL%ROWCOUNT,

Line 890: trace(p_msg => '# insert (XLA_DESC_PRIORITIES) = '||SQL%ROWCOUNT,

886: WHERE table_name = 'XLA_DESC_PRIORITIES'
887: AND staging_amb_context_code = p_staging_context_code;
888:
889: IF (C_LEVEL_EVENT >= g_log_level) THEN
890: trace(p_msg => '# insert (XLA_DESC_PRIORITIES) = '||SQL%ROWCOUNT,
891: p_module => l_log_module,
892: p_level => C_LEVEL_EVENT);
893: END IF;
894:

Line 928: ,xla_desc_priorities p

924: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
925: ,fnd_load_util.owner_id(owner)
926: ,0
927: FROM xla_aad_loader_defns_t xal
928: ,xla_desc_priorities p
929: ,fnd_application fap
930: WHERE fap.application_short_name(+) = xal.source_app_short_name
931: AND p.user_sequence = xal.priority_num
932: AND p.description_type_code = xal.description_type_code

Line 969: ,xla_desc_priorities xdp

965: ,fnd_load_util.owner_id(owner)
966: ,0
967: FROM xla_aad_loader_defns_t xal
968: ,xla_descript_details_b xdd
969: ,xla_desc_priorities xdp
970: ,fnd_languages fl
971: WHERE xdd.description_prio_id = xdp.description_prio_id
972: AND xdd.user_sequence = xal.user_sequence
973: AND xdp.user_sequence = xal.priority_num

Line 1039: ,xla_desc_priorities p

1035: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1036: ,fnd_load_util.owner_id(owner)
1037: ,0
1038: FROM xla_aad_loader_defns_t xal
1039: ,xla_desc_priorities p
1040: ,fnd_application fap
1041: ,fnd_application fap2
1042: WHERE fap.application_short_name(+) = xal.source_app_short_name
1043: AND fap2.application_short_name(+)= xal.value_source_app_short_name