eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_AAD_UPLOAD_PVT dependencies on XLA_AAD_LOADER_DEFNS_T

Line 92: DELETE FROM xla_aad_loader_defns_t

88: p_module => l_log_module,
89: p_level => C_LEVEL_PROCEDURE);
90: END IF;
91:
92: DELETE FROM xla_aad_loader_defns_t
93: WHERE staging_amb_context_code = p_staging_context_code;
94:
95: OPEN c_app_short_name;
96: FETCH c_app_short_name INTO l_app_short_name;

Line 229: FROM xla_aad_loader_defns_t xal

225: RETURN VARCHAR2
226: IS
227: CURSOR c_file_size IS
228: SELECT count(*)
229: FROM xla_aad_loader_defns_t xal
230: WHERE xal.staging_amb_context_code = p_staging_context_code
231: AND xal.table_name = 'XLA_PRODUCT_RULES'
232: AND ROWNUM = 1;
233:

Line 237: FROM xla_aad_loader_defns_t xal

233:
234: CURSOR c_invalid_app IS
235: SELECT fa.application_name file_app_name
236: , fa2.application_name resp_app_name
237: FROM xla_aad_loader_defns_t xal
238: , fnd_application_vl fa
239: , fnd_application_vl fa2
240: WHERE xal.staging_amb_context_code = p_staging_context_code
241: AND xal.table_name = 'XLA_AAD'

Line 256: FROM xla_aad_loader_defns_t

252: ,'XLA_ANALYTICAL_HDRS' ,analytical_criterion_code)
253: , analytical_criterion_code
254: , analytical_criterion_type_code -- Added for bug 8268819
255: , count(*)
256: FROM xla_aad_loader_defns_t
257: WHERE staging_amb_context_code = p_staging_context_code
258: AND table_name IN ('XLA_ANALYTICAL_HDRS')
259: GROUP BY
260: table_name

Line 282: FROM xla_aad_loader_defns_t

278: , event_class_code
279: , source_code
280: , source_type_code
281: , count(*)
282: FROM xla_aad_loader_defns_t
283: WHERE staging_amb_context_code = p_staging_context_code
284: AND table_name IN ('XLA_ANALYTICAL_SOURCES')
285: GROUP BY
286: table_name

Line 319: FROM xla_aad_loader_defns_t

315: analytical_criterion_code
316: ,'XLA_MAPPING_SETS' ,NULL)
317: , name
318: , count(*)
319: FROM xla_aad_loader_defns_t
320: WHERE staging_amb_context_code = p_staging_context_code
321: AND name IS NOT NULL
322: AND table_name IN ('XLA_PRODUCT_RULES'
323: ,'XLA_LINE_DEFINITIONS'

Line 373: FROM xla_aad_loader_defns_t

369: ,'XLA_ANALYTICAL_HDRS' ,analytical_criterion_code
370: ,'XLA_ANALYTICAL_DTLS' ,analytical_detail_code
371: ,'XLA_MAPPING_SETS' ,mapping_set_code) code
372: , count(*)
373: FROM xla_aad_loader_defns_t
374: WHERE staging_amb_context_code = p_staging_context_code
375: AND table_name IN ('XLA_PRODUCT_RULES'
376: ,'XLA_LINE_DEFINITIONS'
377: ,'XLA_ACCT_LINE_TYPES'

Line 411: FROM xla_aad_loader_defns_t xal

407: HAVING count(*) > 1;
408:
409: CURSOR c_invalid_coa IS
410: SELECT xal.value_ccid_id_flex_struct_code id_flex_struct_code
411: FROM xla_aad_loader_defns_t xal
412: LEFT OUTER JOIN fnd_id_flex_structures fif
413: ON fif.application_id = 101
414: AND fif.id_flex_code = 'GL#'
415: AND fif.id_flex_structure_code = xal.value_ccid_id_flex_struct_code

Line 421: FROM xla_aad_loader_defns_t xal

417: AND xal.value_ccid_id_flex_struct_code IS NOT NULL
418: AND fif.id_flex_structure_code IS NULL
419: UNION
420: SELECT xal.trans_coa_id_flex_struct_code
421: FROM xla_aad_loader_defns_t xal
422: LEFT OUTER JOIN fnd_id_flex_structures fif
423: ON fif.application_id = 101
424: AND fif.id_flex_code = 'GL#'
425: AND fif.id_flex_structure_code = xal.trans_coa_id_flex_struct_code

Line 431: FROM xla_aad_loader_defns_t xal

427: AND xal.trans_coa_id_flex_struct_code IS NOT NULL
428: AND fif.id_flex_structure_code IS NULL
429: UNION
430: SELECT xal.acct_coa_id_flex_struct_code
431: FROM xla_aad_loader_defns_t xal
432: LEFT OUTER JOIN fnd_id_flex_structures fif
433: ON fif.application_id = 101
434: AND fif.id_flex_code = 'GL#'
435: AND fif.id_flex_structure_code = xal.acct_coa_id_flex_struct_code

Line 442: FROM xla_aad_loader_defns_t xal

438: AND fif.id_flex_structure_code IS NULL;
439:
440: CURSOR c_invalid_value_set IS
441: SELECT xal.flex_value_set_name
442: FROM xla_aad_loader_defns_t xal
443: LEFT OUTER JOIN fnd_flex_value_sets val
444: ON val.flex_value_set_name = xal.flex_value_set_name
445: WHERE xal.staging_amb_context_code = p_staging_context_code
446: AND xal.flex_value_set_name IS NOT NULL

Line 451: FROM xla_aad_loader_defns_t xal

447: AND val.flex_value_set_id IS NULL;
448:
449: CURSOR c_invalid_app_short_name IS
450: SELECT xal.source_app_short_name app_short_name
451: FROM xla_aad_loader_defns_t xal
452: LEFT OUTER JOIN fnd_application fap
453: ON fap.application_short_name = xal.source_app_short_name
454: WHERE xal.staging_amb_context_code = p_staging_context_code
455: AND xal.source_app_short_name IS NOT NULL

Line 459: FROM xla_aad_loader_defns_t xal

455: AND xal.source_app_short_name IS NOT NULL
456: AND fap.application_id IS NULL
457: UNION
458: SELECT xal.value_source_app_short_name
459: FROM xla_aad_loader_defns_t xal
460: LEFT OUTER JOIN fnd_application fap
461: ON fap.application_short_name = xal.value_source_app_short_name
462: WHERE xal.staging_amb_context_code = p_staging_context_code
463: AND xal.value_source_app_short_name IS NOT NULL

Line 467: FROM xla_aad_loader_defns_t xal

463: AND xal.value_source_app_short_name IS NOT NULL
464: AND fap.application_id IS NULL
465: UNION
466: SELECT xal.view_app_short_name
467: FROM xla_aad_loader_defns_t xal
468: LEFT OUTER JOIN fnd_application fap
469: ON fap.application_short_name = xal.view_app_short_name
470: WHERE xal.staging_amb_context_code = p_staging_context_code
471: AND xal.view_app_short_name IS NOT NULL

Line 475: FROM xla_aad_loader_defns_t xal

471: AND xal.view_app_short_name IS NOT NULL
472: AND fap.application_id IS NULL
473: UNION
474: SELECT xal.application_short_name
475: FROM xla_aad_loader_defns_t xal
476: LEFT OUTER JOIN fnd_application fap
477: ON fap.application_short_name = xal.application_short_name
478: WHERE xal.staging_amb_context_code = p_staging_context_code
479: AND xal.application_short_name IS NOT NULL

Line 483: FROM xla_aad_loader_defns_t xal

479: AND xal.application_short_name IS NOT NULL
480: AND fap.application_id IS NULL
481: UNION
482: SELECT xal.input_source_app_short_name
483: FROM xla_aad_loader_defns_t xal
484: LEFT OUTER JOIN fnd_application fap
485: ON fap.application_short_name = xal.input_source_app_short_name
486: WHERE xal.staging_amb_context_code = p_staging_context_code
487: AND xal.input_source_app_short_name IS NOT NULL

Line 491: FROM xla_aad_loader_defns_t xal

487: AND xal.input_source_app_short_name IS NOT NULL
488: AND fap.application_id IS NULL
489: UNION
490: SELECT xal.value_segment_rule_appl_sn
491: FROM xla_aad_loader_defns_t xal
492: LEFT OUTER JOIN fnd_application fap
493: ON fap.application_short_name = xal.value_segment_rule_appl_sn
494: WHERE xal.staging_amb_context_code = p_staging_context_code
495: AND xal.value_segment_rule_appl_sn IS NOT NULL

Line 578: DELETE FROM xla_aad_loader_defns_t

574: END IF;
575:
576: FOR i IN c_del_dup_name LOOP
577:
578: DELETE FROM xla_aad_loader_defns_t
579: WHERE staging_amb_context_code = p_staging_context_code
580: AND upper(table_name) = ('XLA_ANALYTICAL_HDRS')
581: AND analytical_criterion_code = i.analytical_criterion_code
582: AND analytical_criterion_type_code = i.analytical_criterion_type_code --Added for bug 8268819

Line 583: AND rowid NOT IN (select max(rowid) from xla_aad_loader_defns_t

579: WHERE staging_amb_context_code = p_staging_context_code
580: AND upper(table_name) = ('XLA_ANALYTICAL_HDRS')
581: AND analytical_criterion_code = i.analytical_criterion_code
582: AND analytical_criterion_type_code = i.analytical_criterion_type_code --Added for bug 8268819
583: AND rowid NOT IN (select max(rowid) from xla_aad_loader_defns_t
584: where staging_amb_context_code = p_staging_context_code
585: and upper(table_name) = ('XLA_ANALYTICAL_HDRS')
586: and analytical_criterion_code=i.analytical_criterion_code
587: and analytical_criterion_type_code = i.analytical_criterion_type_code --Added for bug 8268819

Line 597: p_encoded_message => '# delete using c_del_dup_name from (xla_aad_loader_defns_t) = '||SQL%ROWCOUNT,

593: p_amb_context_code => p_staging_context_code,
594: p_application_id => p_application_id,
595: p_request_code => 'IMPORT' ,
596: p_log_type_code => 'UPLOAD',
597: p_encoded_message => '# delete using c_del_dup_name from (xla_aad_loader_defns_t) = '||SQL%ROWCOUNT,
598: p_component_code => 'validation');
599:
600: IF (C_LEVEL_EVENT >= g_log_level) THEN
601: trace(p_msg => 'LOOP: c_del_dup_name : Rows Deleted - '||SQL%ROWCOUNT,

Line 626: DELETE FROM xla_aad_loader_defns_t

622:
623: FOR i IN c_del_dup_name_anal_sources LOOP
624:
625:
626: DELETE FROM xla_aad_loader_defns_t
627: WHERE staging_amb_context_code = p_staging_context_code
628: AND upper(table_name) = ('XLA_ANALYTICAL_SOURCES')
629: AND analytical_criterion_type_code = i.analytical_criterion_type_code
630: AND analytical_criterion_code = i.analytical_criterion_code

Line 636: AND rowid NOT IN (select max(rowid) from xla_aad_loader_defns_t

632: AND entity_code = i.entity_code
633: AND event_class_code = i.event_class_code
634: AND source_code = i.source_code
635: AND source_type_code = i.source_type_code
636: AND rowid NOT IN (select max(rowid) from xla_aad_loader_defns_t
637: WHERE staging_amb_context_code = p_staging_context_code
638: AND upper(table_name) = ('XLA_ANALYTICAL_SOURCES')
639: AND analytical_criterion_type_code = i.analytical_criterion_type_code
640: AND analytical_criterion_code = i.analytical_criterion_code

Line 656: p_encoded_message => '# delete using c_del_dup_name_anal_sources from (xla_aad_loader_defns_t) = '||SQL%ROWCOUNT,

652: p_amb_context_code => p_staging_context_code,
653: p_application_id => p_application_id,
654: p_request_code => 'IMPORT' ,
655: p_log_type_code => 'UPLOAD',
656: p_encoded_message => '# delete using c_del_dup_name_anal_sources from (xla_aad_loader_defns_t) = '||SQL%ROWCOUNT,
657: p_component_code => 'validation');
658:
659:
660: IF (C_LEVEL_EVENT >= g_log_level) THEN

Line 913: FROM xla_aad_loader_defns_t i

909: ,fnd_load_util.owner_id(owner)
910: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
911: ,fnd_load_util.owner_id(owner)
912: ,0
913: FROM xla_aad_loader_defns_t i
914: ,fnd_id_flex_structures flex
915: WHERE flex.application_id(+) = 101
916: AND flex.id_flex_code(+) = 'GL#'
917: AND flex.id_flex_structure_code(+) = trans_coa_id_flex_struct_code

Line 965: FROM xla_aad_loader_defns_t xal

961: ,fnd_load_util.owner_id(owner)
962: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
963: ,fnd_load_util.owner_id(owner)
964: ,0
965: FROM xla_aad_loader_defns_t xal
966: ,fnd_languages fl
967: WHERE xal.table_name = 'XLA_DESCRIPTIONS'
968: AND xal.staging_amb_context_code = p_staging_context_code
969: AND fl.installed_flag IN ('I', 'B');

Line 1013: FROM xla_aad_loader_defns_t

1009: ,fnd_load_util.owner_id(owner)
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;

Line 1067: FROM xla_aad_loader_defns_t xal

1063: ,fnd_load_util.owner_id(owner)
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

Line 1119: FROM xla_aad_loader_defns_t xal

1115: ,fnd_load_util.owner_id(owner)
1116: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
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

Line 1202: FROM xla_aad_loader_defns_t xal

1198: ,fnd_load_util.owner_id(owner)
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

Line 1317: FROM xla_aad_loader_defns_t xal

1313: ,xal.value_ccid_segment27
1314: ,xal.value_ccid_segment28
1315: ,xal.value_ccid_segment29
1316: ,xal.value_ccid_segment30
1317: FROM xla_aad_loader_defns_t xal
1318: ,fnd_id_flex_structures fif
1319: WHERE xal.table_name = 'XLA_MAPPING_SET_VALUES'
1320: AND xal.staging_amb_context_code = p_staging_context_code
1321: AND fif.application_id = 101

Line 1386: FROM xla_aad_loader_defns_t xal

1382: ,fnd_load_util.owner_id(owner)
1383: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1384: ,fnd_load_util.owner_id(owner)
1385: ,0
1386: FROM xla_aad_loader_defns_t xal
1387: ,fnd_application fap
1388: ,fnd_id_flex_structures flex
1389: ,fnd_flex_value_sets val
1390: ,fnd_flex_value_sets oval -- Added for ER 9395160

Line 1444: FROM xla_aad_loader_defns_t xal

1440: ,fnd_load_util.owner_id(owner)
1441: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1442: ,fnd_load_util.owner_id(owner)
1443: ,0
1444: FROM xla_aad_loader_defns_t xal
1445: ,fnd_languages fl
1446: WHERE xal.table_name = 'XLA_MAPPING_SETS'
1447: AND xal.staging_amb_context_code = p_staging_context_code
1448: AND fl.installed_flag IN ('I', 'B');

Line 1533: UPDATE xla_aad_loader_defns_t

1529: ,p_token_1 => 'MAPPING_SET'
1530: ,p_value_1 => l_mapping_set_name);
1531: l_error_found := TRUE;
1532: ELSE
1533: UPDATE xla_aad_loader_defns_t
1534: SET value_code_combination_id = l_code_combination_id
1535: WHERE staging_amb_context_code = p_staging_context_code
1536: AND mapping_set_code = l_ccid.mapping_set_code
1537: AND value_ccid_id_flex_struct_code = l_ccid.id_flex_structure_code

Line 1609: FROM xla_aad_loader_defns_t xal

1605: ,fnd_load_util.owner_id(owner)
1606: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1607: ,fnd_load_util.owner_id(owner)
1608: ,0
1609: FROM xla_aad_loader_defns_t xal
1610: WHERE table_name = 'XLA_MAPPING_SET_VALUES'
1611: AND staging_amb_context_code = p_staging_context_code;
1612:
1613: l_num_rows := SQL%ROWCOUNT;

Line 1744: FROM xla_aad_loader_defns_t xal

1740: ,fnd_load_util.owner_id(owner)
1741: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1742: ,fnd_load_util.owner_id(owner)
1743: ,0
1744: FROM xla_aad_loader_defns_t xal
1745: ,fnd_application fap
1746: WHERE fap.application_short_name(+) = xal.application_short_name
1747: AND table_name = 'XLA_ANALYTICAL_HDRS'
1748: AND staging_amb_context_code = p_staging_context_code;

Line 1795: FROM xla_aad_loader_defns_t xal

1791: ,fnd_load_util.owner_id(owner)
1792: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1793: ,fnd_load_util.owner_id(owner)
1794: ,0
1795: FROM xla_aad_loader_defns_t xal
1796: ,fnd_languages fl
1797: WHERE xal.table_name = 'XLA_ANALYTICAL_HDRS'
1798: AND xal.staging_amb_context_code = p_staging_context_code
1799: AND fl.installed_flag IN ('I', 'B');

Line 1846: FROM xla_aad_loader_defns_t xal

1842: ,fnd_load_util.owner_id(owner)
1843: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1844: ,fnd_load_util.owner_id(owner)
1845: ,0
1846: FROM xla_aad_loader_defns_t xal
1847: WHERE table_name = 'XLA_ANALYTICAL_DTLS'
1848: AND staging_amb_context_code = p_staging_context_code;
1849:
1850: l_num_rows := SQL%ROWCOUNT;

Line 1897: FROM xla_aad_loader_defns_t xal

1893: ,fnd_load_util.owner_id(owner)
1894: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1895: ,fnd_load_util.owner_id(owner)
1896: ,0
1897: FROM xla_aad_loader_defns_t xal
1898: ,fnd_languages fl
1899: WHERE xal.table_name = 'XLA_ANALYTICAL_DTLS'
1900: AND xal.staging_amb_context_code = p_staging_context_code
1901: AND fl.installed_flag IN ('I', 'B');

Line 1952: FROM xla_aad_loader_defns_t xal

1948: ,fnd_load_util.owner_id(owner)
1949: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1950: ,fnd_load_util.owner_id(owner)
1951: ,0
1952: FROM xla_aad_loader_defns_t xal
1953: ,fnd_application fap
1954: ,fnd_application fap2
1955: WHERE fap.application_short_name = xal.application_short_name
1956: AND fap2.application_short_name = xal.source_app_short_name

Line 2066: FROM xla_aad_loader_defns_t xal

2062: ,xal.value_ccid_segment27
2063: ,xal.value_ccid_segment28
2064: ,xal.value_ccid_segment29
2065: ,xal.value_ccid_segment30
2066: FROM xla_aad_loader_defns_t xal
2067: ,fnd_id_flex_structures fif
2068: WHERE xal.table_name = 'XLA_SEG_RULE_DETAILS'
2069: AND xal.staging_amb_context_code = p_staging_context_code
2070: AND fif.application_id = 101

Line 2147: FROM xla_aad_loader_defns_t xal

2143: ,fnd_load_util.owner_id(owner)
2144: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2145: ,fnd_load_util.owner_id(owner)
2146: ,0
2147: FROM xla_aad_loader_defns_t xal
2148: ,fnd_id_flex_structures fift
2149: ,fnd_id_flex_structures fifa
2150: ,fnd_flex_value_sets val
2151: WHERE fift.application_id(+) = 101

Line 2207: FROM xla_aad_loader_defns_t xal

2203: ,fnd_load_util.owner_id(owner)
2204: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2205: ,fnd_load_util.owner_id(owner)
2206: ,0
2207: FROM xla_aad_loader_defns_t xal
2208: ,fnd_languages fl
2209: WHERE xal.table_name = 'XLA_SEG_RULES'
2210: AND xal.staging_amb_context_code = p_staging_context_code
2211: AND fl.installed_flag IN ('I', 'B');

Line 2286: FROM xla_aad_loader_defns_t xal

2282: ,fnd_load_util.owner_id(owner)
2283: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2284: ,fnd_load_util.owner_id(owner)
2285: ,0
2286: FROM xla_aad_loader_defns_t xal
2287: LEFT OUTER JOIN fnd_application fap
2288: ON fap.application_short_name = xal.value_source_app_short_name
2289: LEFT OUTER JOIN fnd_application fap2
2290: ON fap2.application_short_name = xal.input_source_app_short_name

Line 2459: FROM xla_aad_loader_defns_t xal

2455: ,fnd_load_util.owner_id(owner)
2456: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2457: ,fnd_load_util.owner_id(owner)
2458: ,0
2459: FROM xla_aad_loader_defns_t xal
2460: ,xla_seg_rule_details d
2461: ,fnd_application fap
2462: ,fnd_application fap2
2463: WHERE fap.application_short_name(+) = xal.source_app_short_name

Line 2617: FROM xla_aad_loader_defns_t xal

2613: ,fnd_load_util.owner_id(xal.owner)
2614: ,nvl(to_date(xal.orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2615: ,fnd_load_util.owner_id(xal.owner)
2616: ,0
2617: FROM xla_aad_loader_defns_t xal
2618: ,fnd_id_flex_structures flex
2619: ,gl_encumbrance_types get
2620: WHERE flex.application_id(+) = 101
2621: AND flex.id_flex_code(+) = 'GL#'

Line 2677: FROM xla_aad_loader_defns_t xal

2673: ,fnd_load_util.owner_id(owner)
2674: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2675: ,fnd_load_util.owner_id(owner)
2676: ,0
2677: FROM xla_aad_loader_defns_t xal
2678: ,fnd_languages fl
2679: WHERE xal.table_name = 'XLA_ACCT_LINE_TYPES'
2680: AND xal.staging_amb_context_code = p_staging_context_code
2681: AND fl.installed_flag IN ('I', 'B');

Line 2733: FROM xla_aad_loader_defns_t xal

2729: ,fnd_load_util.owner_id(owner)
2730: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2731: ,fnd_load_util.owner_id(owner)
2732: ,0
2733: FROM xla_aad_loader_defns_t xal
2734: ,fnd_application fap
2735: WHERE fap.application_short_name(+) = xal.source_app_short_name
2736: AND table_name = 'XLA_JLT_ACCT_ATTRS'
2737: AND staging_amb_context_code = p_staging_context_code;

Line 2813: FROM xla_aad_loader_defns_t xal

2809: ,fnd_load_util.owner_id(owner)
2810: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2811: ,fnd_load_util.owner_id(owner)
2812: ,0
2813: FROM xla_aad_loader_defns_t xal
2814: ,fnd_application fap
2815: ,fnd_application fap2
2816: WHERE fap.application_short_name(+) = xal.source_app_short_name
2817: AND fap2.application_short_name(+)= xal.value_source_app_short_name

Line 2936: FROM xla_aad_loader_defns_t xal

2932: ,fnd_load_util.owner_id(owner)
2933: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2934: ,fnd_load_util.owner_id(owner)
2935: ,0
2936: FROM xla_aad_loader_defns_t xal
2937: ,fnd_id_flex_structures fift
2938: ,fnd_id_flex_structures fifa
2939: WHERE fift.application_id(+) = 101
2940: AND fift.id_flex_code(+) = 'GL#'

Line 2999: FROM xla_aad_loader_defns_t xal

2995: ,fnd_load_util.owner_id(owner)
2996: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2997: ,fnd_load_util.owner_id(owner)
2998: ,0
2999: FROM xla_aad_loader_defns_t xal
3000: ,fnd_languages fl
3001: WHERE xal.table_name = 'XLA_LINE_DEFINITIONS'
3002: AND xal.staging_amb_context_code = p_staging_context_code
3003: AND fl.installed_flag IN ('I', 'B');

Line 3071: FROM xla_aad_loader_defns_t

3067: ,fnd_load_util.owner_id(owner)
3068: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3069: ,fnd_load_util.owner_id(owner)
3070: ,0
3071: FROM xla_aad_loader_defns_t
3072: WHERE table_name = 'XLA_LINE_DEFN_JLT_ASSGNS'
3073: AND staging_amb_context_code = p_staging_context_code;
3074:
3075: l_num_rows := SQL%ROWCOUNT;

Line 3140: FROM xla_aad_loader_defns_t xal

3136: ,fnd_load_util.owner_id(owner)
3137: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3138: ,fnd_load_util.owner_id(owner)
3139: ,0
3140: FROM xla_aad_loader_defns_t xal
3141: ,fnd_application fap
3142: WHERE fap.application_short_name(+) = xal.segment_rule_appl_sn
3143: AND xal.table_name = 'XLA_LINE_DEFN_ADR_ASSGNS'
3144: AND xal.staging_amb_context_code = p_staging_context_code;

Line 3197: FROM xla_aad_loader_defns_t

3193: ,fnd_load_util.owner_id(owner)
3194: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3195: ,fnd_load_util.owner_id(owner)
3196: ,0
3197: FROM xla_aad_loader_defns_t
3198: WHERE table_name = 'XLA_LINE_DEFN_AC_ASSGNS'
3199: AND staging_amb_context_code = p_staging_context_code;
3200:
3201: l_num_rows := SQL%ROWCOUNT;

Line 3253: FROM xla_aad_loader_defns_t

3249: ,fnd_load_util.owner_id(owner)
3250: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3251: ,fnd_load_util.owner_id(owner)
3252: ,0
3253: FROM xla_aad_loader_defns_t
3254: WHERE table_name = 'XLA_MPA_HEADER_AC_ASSGNS'
3255: AND staging_amb_context_code = p_staging_context_code;
3256:
3257: l_num_rows := SQL%ROWCOUNT;

Line 3314: FROM xla_aad_loader_defns_t

3310: ,fnd_load_util.owner_id(owner)
3311: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3312: ,fnd_load_util.owner_id(owner)
3313: ,0
3314: FROM xla_aad_loader_defns_t
3315: WHERE table_name = 'XLA_MPA_JLT_ASSGNS'
3316: AND staging_amb_context_code = p_staging_context_code;
3317:
3318: l_num_rows := SQL%ROWCOUNT;

Line 3374: FROM xla_aad_loader_defns_t

3370: ,fnd_load_util.owner_id(owner)
3371: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3372: ,fnd_load_util.owner_id(owner)
3373: ,0
3374: FROM xla_aad_loader_defns_t
3375: WHERE table_name = 'XLA_MPA_JLT_AC_ASSGNS'
3376: AND staging_amb_context_code = p_staging_context_code;
3377: l_num_rows := SQL%ROWCOUNT;
3378: IF (C_LEVEL_EVENT >= g_log_level) THEN

Line 3436: FROM xla_aad_loader_defns_t xal

3432: ,fnd_load_util.owner_id(owner)
3433: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3434: ,fnd_load_util.owner_id(owner)
3435: ,0
3436: FROM xla_aad_loader_defns_t xal
3437: , fnd_application fap
3438: WHERE fap.application_short_name(+) = xal.segment_rule_appl_sn
3439: AND table_name = 'XLA_MPA_JLT_ADR_ASSGNS'
3440: AND staging_amb_context_code = p_staging_context_code;

Line 3556: FROM xla_aad_loader_defns_t xal

3552: ,fnd_load_util.owner_id(xal.owner)
3553: ,nvl(to_date(xal.orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3554: ,fnd_load_util.owner_id(xal.owner)
3555: ,0
3556: FROM xla_aad_loader_defns_t xal
3557: ,xla_product_rules_b xpr
3558: ,fnd_id_flex_structures fift
3559: ,fnd_id_flex_structures fifa
3560: WHERE fift.application_id(+) = 101

Line 3618: FROM xla_aad_loader_defns_t xal

3614: ,fnd_load_util.owner_id(owner)
3615: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3616: ,fnd_load_util.owner_id(owner)
3617: ,0
3618: FROM xla_aad_loader_defns_t xal
3619: ,fnd_languages fl
3620: WHERE xal.table_name = 'XLA_PRODUCT_RULES'
3621: AND xal.staging_amb_context_code = p_staging_context_code
3622: AND fl.installed_flag IN ('I', 'B');

Line 3678: FROM xla_aad_loader_defns_t

3674: ,fnd_load_util.owner_id(owner)
3675: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3676: ,fnd_load_util.owner_id(owner)
3677: ,0
3678: FROM xla_aad_loader_defns_t
3679: WHERE table_name = 'XLA_PROD_ACCT_HEADERS'
3680: AND staging_amb_context_code = p_staging_context_code;
3681:
3682: l_num_rows := SQL%ROWCOUNT;

Line 3733: FROM xla_aad_loader_defns_t xal

3729: ,fnd_load_util.owner_id(owner)
3730: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3731: ,fnd_load_util.owner_id(owner)
3732: ,0
3733: FROM xla_aad_loader_defns_t xal
3734: ,fnd_application fap
3735: WHERE fap.application_short_name(+) = xal.source_app_short_name
3736: AND table_name = 'XLA_AAD_HDR_ACCT_ATTRS'
3737: AND staging_amb_context_code = p_staging_context_code;

Line 3786: FROM xla_aad_loader_defns_t

3782: ,fnd_load_util.owner_id(owner)
3783: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3784: ,fnd_load_util.owner_id(owner)
3785: ,0
3786: FROM xla_aad_loader_defns_t
3787: WHERE table_name = 'XLA_AAD_LINE_DEFN_ASSGNS'
3788: AND staging_amb_context_code = p_staging_context_code;
3789: l_num_rows := SQL%ROWCOUNT;
3790: IF (C_LEVEL_EVENT >= g_log_level) THEN

Line 3835: FROM xla_aad_loader_defns_t

3831: ,fnd_load_util.owner_id(owner)
3832: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3833: ,fnd_load_util.owner_id(owner)
3834: ,0
3835: FROM xla_aad_loader_defns_t
3836: WHERE table_name = 'XLA_AAD_HEADER_AC_ASSGNS'
3837: AND staging_amb_context_code = p_staging_context_code;
3838:
3839: l_num_rows := SQL%ROWCOUNT;

Line 3947: FROM xla_aad_loader_defns_t xal

3943: ,fnd_load_util.owner_id(owner)
3944: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3945: ,fnd_load_util.owner_id(owner)
3946: ,0
3947: FROM xla_aad_loader_defns_t xal
3948: ,fnd_id_flex_structures fift
3949: ,fnd_id_flex_structures fifa
3950: WHERE fift.application_id(+) = 101
3951: AND fift.id_flex_code(+) = 'GL#'

Line 4005: FROM xla_aad_loader_defns_t

4001: ,fnd_load_util.owner_id(owner)
4002: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
4003: ,fnd_load_util.owner_id(owner)
4004: ,0
4005: FROM xla_aad_loader_defns_t
4006: WHERE table_name = 'XLA_ACCTG_METHOD_RULES'
4007: AND staging_amb_context_code = p_staging_context_code;
4008:
4009: l_num_rows := SQL%ROWCOUNT;

Line 4116: FROM xla_aad_loader_defns_t xal

4112: ,fnd_load_util.owner_id(owner)
4113: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
4114: ,fnd_load_util.owner_id(owner)
4115: ,0
4116: FROM xla_aad_loader_defns_t xal
4117: ,fnd_application fap
4118: WHERE fap.application_short_name(+) = xal.application_short_name
4119: AND table_name = 'XLA_STAGING_COMPONENTS_H'
4120: AND staging_amb_context_code = p_staging_context_code;