APPS.XLA_AAD_UPLOAD_PVT dependencies on XLA_DESC_PRIORITIES

Line 989: INSERT INTO xla_desc_priorities

985: p_log_type_code => 'UPLOAD',
986: p_encoded_message => '# insert (XLA_DESCRIPTIONS_TL) = '|| l_num_rows,
987: p_component_code => 'populate_descriptions');
988:
989: INSERT INTO xla_desc_priorities
990: (application_id
991: ,amb_context_code
992: ,description_type_code
993: ,description_code

Line 1006: ,xla_desc_priorities_s.nextval

1002: p_application_id
1003: ,p_staging_context_code
1004: ,description_type_code
1005: ,description_code
1006: ,xla_desc_priorities_s.nextval
1007: ,priority_num
1008: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1009: ,fnd_load_util.owner_id(owner)
1010: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)

Line 1014: WHERE table_name = 'XLA_DESC_PRIORITIES'

1010: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1011: ,fnd_load_util.owner_id(owner)
1012: ,0
1013: FROM xla_aad_loader_defns_t
1014: WHERE table_name = 'XLA_DESC_PRIORITIES'
1015: AND staging_amb_context_code = p_staging_context_code;
1016:
1017: l_num_rows := SQL%ROWCOUNT;
1018:

Line 1020: trace(p_msg => '# insert (XLA_DESC_PRIORITIES) = '||l_num_rows,

1016:
1017: l_num_rows := SQL%ROWCOUNT;
1018:
1019: IF (C_LEVEL_EVENT >= g_log_level) THEN
1020: trace(p_msg => '# insert (XLA_DESC_PRIORITIES) = '||l_num_rows,
1021: p_module => l_log_module,
1022: p_level => C_LEVEL_EVENT);
1023: END IF;
1024:

Line 1032: p_encoded_message => '# insert (XLA_DESC_PRIORITIES) = '||l_num_rows,

1028: p_amb_context_code => p_staging_context_code,
1029: p_application_id => p_application_id,
1030: p_request_code => 'IMPORT' ,
1031: p_log_type_code => 'UPLOAD',
1032: p_encoded_message => '# insert (XLA_DESC_PRIORITIES) = '||l_num_rows,
1033: p_component_code => 'populate_descriptions');
1034:
1035: INSERT INTO xla_descript_details_b
1036: (amb_context_code

Line 1068: ,xla_desc_priorities p

1064: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1065: ,fnd_load_util.owner_id(owner)
1066: ,0
1067: FROM xla_aad_loader_defns_t xal
1068: ,xla_desc_priorities p
1069: ,fnd_application fap
1070: WHERE fap.application_short_name(+) = xal.source_app_short_name
1071: AND p.user_sequence = xal.priority_num
1072: AND p.description_type_code = xal.description_type_code

Line 1121: ,xla_desc_priorities xdp

1117: ,fnd_load_util.owner_id(owner)
1118: ,0
1119: FROM xla_aad_loader_defns_t xal
1120: ,xla_descript_details_b xdd
1121: ,xla_desc_priorities xdp
1122: ,fnd_languages fl
1123: WHERE xdd.description_prio_id = xdp.description_prio_id
1124: AND xdd.user_sequence = xal.user_sequence
1125: AND xdp.user_sequence = xal.priority_num

Line 1203: ,xla_desc_priorities p

1199: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1200: ,fnd_load_util.owner_id(owner)
1201: ,0
1202: FROM xla_aad_loader_defns_t xal
1203: ,xla_desc_priorities p
1204: ,fnd_application fap
1205: ,fnd_application fap2
1206: WHERE fap.application_short_name(+) = xal.source_app_short_name
1207: AND fap2.application_short_name(+)= xal.value_source_app_short_name

Line 4187: AD_ZD_SEED.PREPARE('XLA_DESC_PRIORITIES');

4183: END IF;
4184:
4185: AD_ZD_SEED.PREPARE('XLA_DESCRIPTIONS_B');
4186: AD_ZD_SEED.PREPARE('XLA_DESCRIPTIONS_TL');
4187: AD_ZD_SEED.PREPARE('XLA_DESC_PRIORITIES');
4188: AD_ZD_SEED.PREPARE('XLA_DESCRIPT_DETAILS_B');
4189: AD_ZD_SEED.PREPARE('XLA_DESCRIPT_DETAILS_TL');
4190: AD_ZD_SEED.PREPARE('XLA_CONDITIONS');
4191: AD_ZD_SEED.PREPARE('XLA_MAPPING_SETS_B');