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 255: FROM xla_aad_loader_defns_t

251: , DECODE(table_name
252: ,'XLA_ANALYTICAL_HDRS' ,analytical_criterion_code)
253: , analytical_criterion_code
254: , count(*)
255: FROM xla_aad_loader_defns_t
256: WHERE staging_amb_context_code = p_staging_context_code
257: AND table_name IN ('XLA_ANALYTICAL_HDRS')
258: GROUP BY
259: table_name

Line 276: FROM xla_aad_loader_defns_t

272: , analytical_criterion_type_code
273: , analytical_criterion_code
274: , event_class_code
275: , count(*)
276: FROM xla_aad_loader_defns_t
277: WHERE staging_amb_context_code = p_staging_context_code
278: AND table_name IN ('XLA_ANALYTICAL_SOURCES')
279: GROUP BY
280: table_name

Line 309: FROM xla_aad_loader_defns_t

305: analytical_criterion_code
306: ,'XLA_MAPPING_SETS' ,NULL)
307: , name
308: , count(*)
309: FROM xla_aad_loader_defns_t
310: WHERE staging_amb_context_code = p_staging_context_code
311: AND name IS NOT NULL
312: AND table_name IN ('XLA_PRODUCT_RULES'
313: ,'XLA_LINE_DEFINITIONS'

Line 363: FROM xla_aad_loader_defns_t

359: ,'XLA_ANALYTICAL_HDRS' ,analytical_criterion_code
360: ,'XLA_ANALYTICAL_DTLS' ,analytical_detail_code
361: ,'XLA_MAPPING_SETS' ,mapping_set_code) code
362: , count(*)
363: FROM xla_aad_loader_defns_t
364: WHERE staging_amb_context_code = p_staging_context_code
365: AND table_name IN ('XLA_PRODUCT_RULES'
366: ,'XLA_LINE_DEFINITIONS'
367: ,'XLA_ACCT_LINE_TYPES'

Line 401: FROM xla_aad_loader_defns_t xal

397: HAVING count(*) > 1;
398:
399: CURSOR c_invalid_coa IS
400: SELECT xal.value_ccid_id_flex_struct_code id_flex_struct_code
401: FROM xla_aad_loader_defns_t xal
402: LEFT OUTER JOIN fnd_id_flex_structures fif
403: ON fif.application_id = 101
404: AND fif.id_flex_code = 'GL#'
405: AND fif.id_flex_structure_code = xal.value_ccid_id_flex_struct_code

Line 411: FROM xla_aad_loader_defns_t xal

407: AND xal.value_ccid_id_flex_struct_code IS NOT NULL
408: AND fif.id_flex_structure_code IS NULL
409: UNION
410: SELECT xal.trans_coa_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.trans_coa_id_flex_struct_code

Line 421: FROM xla_aad_loader_defns_t xal

417: AND xal.trans_coa_id_flex_struct_code IS NOT NULL
418: AND fif.id_flex_structure_code IS NULL
419: UNION
420: SELECT xal.acct_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.acct_coa_id_flex_struct_code

Line 432: FROM xla_aad_loader_defns_t xal

428: AND fif.id_flex_structure_code IS NULL;
429:
430: CURSOR c_invalid_value_set IS
431: SELECT xal.flex_value_set_name
432: FROM xla_aad_loader_defns_t xal
433: LEFT OUTER JOIN fnd_flex_value_sets val
434: ON val.flex_value_set_name = xal.flex_value_set_name
435: WHERE xal.staging_amb_context_code = p_staging_context_code
436: AND xal.flex_value_set_name IS NOT NULL

Line 441: FROM xla_aad_loader_defns_t xal

437: AND val.flex_value_set_id IS NULL;
438:
439: CURSOR c_invalid_app_short_name IS
440: SELECT xal.source_app_short_name app_short_name
441: FROM xla_aad_loader_defns_t xal
442: LEFT OUTER JOIN fnd_application fap
443: ON fap.application_short_name = xal.source_app_short_name
444: WHERE xal.staging_amb_context_code = p_staging_context_code
445: AND xal.source_app_short_name IS NOT NULL

Line 449: FROM xla_aad_loader_defns_t xal

445: AND xal.source_app_short_name IS NOT NULL
446: AND fap.application_id IS NULL
447: UNION
448: SELECT xal.value_source_app_short_name
449: FROM xla_aad_loader_defns_t xal
450: LEFT OUTER JOIN fnd_application fap
451: ON fap.application_short_name = xal.value_source_app_short_name
452: WHERE xal.staging_amb_context_code = p_staging_context_code
453: AND xal.value_source_app_short_name IS NOT NULL

Line 457: FROM xla_aad_loader_defns_t xal

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

Line 465: FROM xla_aad_loader_defns_t xal

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

Line 473: FROM xla_aad_loader_defns_t xal

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

Line 481: FROM xla_aad_loader_defns_t xal

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

Line 561: DELETE FROM xla_aad_loader_defns_t

557: -- krsankar - Opening 2 new cursors added as part of P1 Bug 6975482.
558:
559: FOR i IN c_del_dup_name LOOP
560:
561: DELETE FROM xla_aad_loader_defns_t
562: WHERE staging_amb_context_code = p_staging_context_code
563: AND upper(table_name) = ('XLA_ANALYTICAL_HDRS')
564: AND analytical_criterion_code = i.analytical_criterion_code
565: AND rowid NOT IN (select max(rowid) from xla_aad_loader_defns_t

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

561: DELETE FROM xla_aad_loader_defns_t
562: WHERE staging_amb_context_code = p_staging_context_code
563: AND upper(table_name) = ('XLA_ANALYTICAL_HDRS')
564: AND analytical_criterion_code = i.analytical_criterion_code
565: AND rowid NOT IN (select max(rowid) from xla_aad_loader_defns_t
566: where staging_amb_context_code = p_staging_context_code
567: and upper(table_name) = ('XLA_ANALYTICAL_HDRS')
568: and analytical_criterion_code=i.analytical_criterion_code
569: group by analytical_criterion_code);

Line 576: DELETE FROM xla_aad_loader_defns_t

572:
573:
574: FOR i IN c_del_dup_name_anal_sources LOOP
575:
576: DELETE FROM xla_aad_loader_defns_t
577: WHERE staging_amb_context_code = p_staging_context_code
578: AND upper(table_name) = ('XLA_ANALYTICAL_SOURCES')
579: AND analytical_criterion_type_code = i.analytical_criterion_type_code
580: AND analytical_criterion_code = i.analytical_criterion_code

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

578: AND upper(table_name) = ('XLA_ANALYTICAL_SOURCES')
579: AND analytical_criterion_type_code = i.analytical_criterion_type_code
580: AND analytical_criterion_code = i.analytical_criterion_code
581: AND event_class_code = i.event_class_code
582: AND rowid NOT IN (select max(rowid) from xla_aad_loader_defns_t
583: where staging_amb_context_code = p_staging_context_code
584: and upper(table_name) = ('XLA_ANALYTICAL_SOURCES')
585: and analytical_criterion_type_code=i.analytical_criterion_type_code
586: and analytical_criterion_code = i.analytical_criterion_code

Line 807: FROM xla_aad_loader_defns_t i

803: ,fnd_load_util.owner_id(owner)
804: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
805: ,fnd_load_util.owner_id(owner)
806: ,0
807: FROM xla_aad_loader_defns_t i
808: ,fnd_id_flex_structures flex
809: WHERE flex.application_id(+) = 101
810: AND flex.id_flex_code(+) = 'GL#'
811: AND flex.id_flex_structure_code(+) = trans_coa_id_flex_struct_code

Line 849: FROM xla_aad_loader_defns_t xal

845: ,fnd_load_util.owner_id(owner)
846: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
847: ,fnd_load_util.owner_id(owner)
848: ,0
849: FROM xla_aad_loader_defns_t xal
850: ,fnd_languages fl
851: WHERE xal.table_name = 'XLA_DESCRIPTIONS'
852: AND xal.staging_amb_context_code = p_staging_context_code
853: AND fl.installed_flag IN ('I', 'B');

Line 885: FROM xla_aad_loader_defns_t

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

Line 927: FROM xla_aad_loader_defns_t xal

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

Line 967: FROM xla_aad_loader_defns_t xal

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

Line 1038: FROM xla_aad_loader_defns_t xal

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

Line 1124: FROM xla_aad_loader_defns_t xal

1120: ,xal.value_ccid_segment27
1121: ,xal.value_ccid_segment28
1122: ,xal.value_ccid_segment29
1123: ,xal.value_ccid_segment30
1124: FROM xla_aad_loader_defns_t xal
1125: ,fnd_id_flex_structures fif
1126: WHERE xal.table_name = 'XLA_MAPPING_SET_VALUES'
1127: AND xal.staging_amb_context_code = p_staging_context_code
1128: AND fif.application_id = 101

Line 1189: FROM xla_aad_loader_defns_t xal

1185: ,fnd_load_util.owner_id(owner)
1186: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1187: ,fnd_load_util.owner_id(owner)
1188: ,0
1189: FROM xla_aad_loader_defns_t xal
1190: ,fnd_application fap
1191: ,fnd_id_flex_structures flex
1192: ,fnd_flex_value_sets val
1193: WHERE fap.application_short_name(+) = xal.view_app_short_name

Line 1235: FROM xla_aad_loader_defns_t xal

1231: ,fnd_load_util.owner_id(owner)
1232: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1233: ,fnd_load_util.owner_id(owner)
1234: ,0
1235: FROM xla_aad_loader_defns_t xal
1236: ,fnd_languages fl
1237: WHERE xal.table_name = 'XLA_MAPPING_SETS'
1238: AND xal.staging_amb_context_code = p_staging_context_code
1239: AND fl.installed_flag IN ('I', 'B');

Line 1312: UPDATE xla_aad_loader_defns_t

1308: ,p_token_1 => 'MAPPING_SET'
1309: ,p_value_1 => l_mapping_set_name);
1310: l_error_found := TRUE;
1311: ELSE
1312: UPDATE xla_aad_loader_defns_t
1313: SET value_code_combination_id = l_code_combination_id
1314: WHERE staging_amb_context_code = p_staging_context_code
1315: AND mapping_set_code = l_ccid.mapping_set_code
1316: AND value_ccid_id_flex_struct_code = l_ccid.id_flex_structure_code

Line 1388: FROM xla_aad_loader_defns_t xal

1384: ,fnd_load_util.owner_id(owner)
1385: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1386: ,fnd_load_util.owner_id(owner)
1387: ,0
1388: FROM xla_aad_loader_defns_t xal
1389: WHERE table_name = 'XLA_MAPPING_SET_VALUES'
1390: AND staging_amb_context_code = p_staging_context_code;
1391:
1392: IF (C_LEVEL_EVENT >= g_log_level) THEN

Line 1493: FROM xla_aad_loader_defns_t xal

1489: ,fnd_load_util.owner_id(owner)
1490: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1491: ,fnd_load_util.owner_id(owner)
1492: ,0
1493: FROM xla_aad_loader_defns_t xal
1494: ,fnd_application fap
1495: WHERE fap.application_short_name(+) = xal.application_short_name
1496: AND table_name = 'XLA_ANALYTICAL_HDRS'
1497: AND staging_amb_context_code = p_staging_context_code;

Line 1534: FROM xla_aad_loader_defns_t xal

1530: ,fnd_load_util.owner_id(owner)
1531: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1532: ,fnd_load_util.owner_id(owner)
1533: ,0
1534: FROM xla_aad_loader_defns_t xal
1535: ,fnd_languages fl
1536: WHERE xal.table_name = 'XLA_ANALYTICAL_HDRS'
1537: AND xal.staging_amb_context_code = p_staging_context_code
1538: AND fl.installed_flag IN ('I', 'B');

Line 1571: FROM xla_aad_loader_defns_t xal

1567: ,fnd_load_util.owner_id(owner)
1568: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1569: ,fnd_load_util.owner_id(owner)
1570: ,0
1571: FROM xla_aad_loader_defns_t xal
1572: WHERE table_name = 'XLA_ANALYTICAL_DTLS'
1573: AND staging_amb_context_code = p_staging_context_code;
1574:
1575: l_num_rows := SQL%ROWCOUNT;

Line 1612: FROM xla_aad_loader_defns_t xal

1608: ,fnd_load_util.owner_id(owner)
1609: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1610: ,fnd_load_util.owner_id(owner)
1611: ,0
1612: FROM xla_aad_loader_defns_t xal
1613: ,fnd_languages fl
1614: WHERE xal.table_name = 'XLA_ANALYTICAL_DTLS'
1615: AND xal.staging_amb_context_code = p_staging_context_code
1616: AND fl.installed_flag IN ('I', 'B');

Line 1656: FROM xla_aad_loader_defns_t xal

1652: ,fnd_load_util.owner_id(owner)
1653: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1654: ,fnd_load_util.owner_id(owner)
1655: ,0
1656: FROM xla_aad_loader_defns_t xal
1657: ,fnd_application fap
1658: ,fnd_application fap2
1659: WHERE fap.application_short_name = xal.application_short_name
1660: AND fap2.application_short_name = xal.source_app_short_name

Line 1740: FROM xla_aad_loader_defns_t xal

1736: ,xal.value_ccid_segment27
1737: ,xal.value_ccid_segment28
1738: ,xal.value_ccid_segment29
1739: ,xal.value_ccid_segment30
1740: FROM xla_aad_loader_defns_t xal
1741: ,fnd_id_flex_structures fif
1742: WHERE xal.table_name = 'XLA_SEG_RULE_DETAILS'
1743: AND xal.staging_amb_context_code = p_staging_context_code
1744: AND fif.application_id = 101

Line 1818: FROM xla_aad_loader_defns_t xal

1814: ,fnd_load_util.owner_id(owner)
1815: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1816: ,fnd_load_util.owner_id(owner)
1817: ,0
1818: FROM xla_aad_loader_defns_t xal
1819: ,fnd_id_flex_structures fift
1820: ,fnd_id_flex_structures fifa
1821: ,fnd_flex_value_sets val
1822: WHERE fift.application_id(+) = 101

Line 1866: FROM xla_aad_loader_defns_t xal

1862: ,fnd_load_util.owner_id(owner)
1863: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1864: ,fnd_load_util.owner_id(owner)
1865: ,0
1866: FROM xla_aad_loader_defns_t xal
1867: ,fnd_languages fl
1868: WHERE xal.table_name = 'XLA_SEG_RULES'
1869: AND xal.staging_amb_context_code = p_staging_context_code
1870: AND fl.installed_flag IN ('I', 'B');

Line 1933: FROM xla_aad_loader_defns_t xal

1929: ,fnd_load_util.owner_id(owner)
1930: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
1931: ,fnd_load_util.owner_id(owner)
1932: ,0
1933: FROM xla_aad_loader_defns_t xal
1934: LEFT OUTER JOIN fnd_application fap
1935: ON fap.application_short_name = xal.value_source_app_short_name
1936: LEFT OUTER JOIN fnd_application fap2
1937: ON fap2.application_short_name = xal.input_source_app_short_name

Line 2096: FROM xla_aad_loader_defns_t xal

2092: ,fnd_load_util.owner_id(owner)
2093: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2094: ,fnd_load_util.owner_id(owner)
2095: ,0
2096: FROM xla_aad_loader_defns_t xal
2097: ,xla_seg_rule_details d
2098: ,fnd_application fap
2099: ,fnd_application fap2
2100: WHERE fap.application_short_name(+) = xal.source_app_short_name

Line 2224: FROM xla_aad_loader_defns_t xal

2220: ,fnd_load_util.owner_id(xal.owner)
2221: ,nvl(to_date(xal.orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2222: ,fnd_load_util.owner_id(xal.owner)
2223: ,0
2224: FROM xla_aad_loader_defns_t xal
2225: ,fnd_id_flex_structures flex
2226: ,gl_encumbrance_types get
2227: WHERE flex.application_id(+) = 101
2228: AND flex.id_flex_code(+) = 'GL#'

Line 2272: FROM xla_aad_loader_defns_t xal

2268: ,fnd_load_util.owner_id(owner)
2269: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2270: ,fnd_load_util.owner_id(owner)
2271: ,0
2272: FROM xla_aad_loader_defns_t xal
2273: ,fnd_languages fl
2274: WHERE xal.table_name = 'XLA_ACCT_LINE_TYPES'
2275: AND xal.staging_amb_context_code = p_staging_context_code
2276: AND fl.installed_flag IN ('I', 'B');

Line 2316: FROM xla_aad_loader_defns_t xal

2312: ,fnd_load_util.owner_id(owner)
2313: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2314: ,fnd_load_util.owner_id(owner)
2315: ,0
2316: FROM xla_aad_loader_defns_t xal
2317: ,fnd_application fap
2318: WHERE fap.application_short_name(+) = xal.source_app_short_name
2319: AND table_name = 'XLA_JLT_ACCT_ATTRS'
2320: AND staging_amb_context_code = p_staging_context_code;

Line 2384: FROM xla_aad_loader_defns_t xal

2380: ,fnd_load_util.owner_id(owner)
2381: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2382: ,fnd_load_util.owner_id(owner)
2383: ,0
2384: FROM xla_aad_loader_defns_t xal
2385: ,fnd_application fap
2386: ,fnd_application fap2
2387: WHERE fap.application_short_name(+) = xal.source_app_short_name
2388: AND fap2.application_short_name(+)= xal.value_source_app_short_name

Line 2476: FROM xla_aad_loader_defns_t xal

2472: ,fnd_load_util.owner_id(owner)
2473: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2474: ,fnd_load_util.owner_id(owner)
2475: ,0
2476: FROM xla_aad_loader_defns_t xal
2477: ,fnd_id_flex_structures fift
2478: ,fnd_id_flex_structures fifa
2479: WHERE fift.application_id(+) = 101
2480: AND fift.id_flex_code(+) = 'GL#'

Line 2528: FROM xla_aad_loader_defns_t xal

2524: ,fnd_load_util.owner_id(owner)
2525: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2526: ,fnd_load_util.owner_id(owner)
2527: ,0
2528: FROM xla_aad_loader_defns_t xal
2529: ,fnd_languages fl
2530: WHERE xal.table_name = 'XLA_LINE_DEFINITIONS'
2531: AND xal.staging_amb_context_code = p_staging_context_code
2532: AND fl.installed_flag IN ('I', 'B');

Line 2588: FROM xla_aad_loader_defns_t

2584: ,fnd_load_util.owner_id(owner)
2585: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2586: ,fnd_load_util.owner_id(owner)
2587: ,0
2588: FROM xla_aad_loader_defns_t
2589: WHERE table_name = 'XLA_LINE_DEFN_JLT_ASSGNS'
2590: AND staging_amb_context_code = p_staging_context_code;
2591:
2592: IF (C_LEVEL_EVENT >= g_log_level) THEN

Line 2645: FROM xla_aad_loader_defns_t xal

2641: ,fnd_load_util.owner_id(owner)
2642: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2643: ,fnd_load_util.owner_id(owner)
2644: ,0
2645: FROM xla_aad_loader_defns_t xal
2646: ,fnd_application fap
2647: WHERE fap.application_short_name(+) = xal.segment_rule_appl_sn
2648: AND xal.table_name = 'XLA_LINE_DEFN_ADR_ASSGNS'
2649: AND xal.staging_amb_context_code = p_staging_context_code;

Line 2691: FROM xla_aad_loader_defns_t

2687: ,fnd_load_util.owner_id(owner)
2688: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2689: ,fnd_load_util.owner_id(owner)
2690: ,0
2691: FROM xla_aad_loader_defns_t
2692: WHERE table_name = 'XLA_LINE_DEFN_AC_ASSGNS'
2693: AND staging_amb_context_code = p_staging_context_code;
2694:
2695: IF (C_LEVEL_EVENT >= g_log_level) THEN

Line 2735: FROM xla_aad_loader_defns_t

2731: ,fnd_load_util.owner_id(owner)
2732: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2733: ,fnd_load_util.owner_id(owner)
2734: ,0
2735: FROM xla_aad_loader_defns_t
2736: WHERE table_name = 'XLA_MPA_HEADER_AC_ASSGNS'
2737: AND staging_amb_context_code = p_staging_context_code;
2738:
2739: IF (C_LEVEL_EVENT >= g_log_level) THEN

Line 2785: FROM xla_aad_loader_defns_t

2781: ,fnd_load_util.owner_id(owner)
2782: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2783: ,fnd_load_util.owner_id(owner)
2784: ,0
2785: FROM xla_aad_loader_defns_t
2786: WHERE table_name = 'XLA_MPA_JLT_ASSGNS'
2787: AND staging_amb_context_code = p_staging_context_code;
2788:
2789: IF (C_LEVEL_EVENT >= g_log_level) THEN

Line 2835: FROM xla_aad_loader_defns_t

2831: ,fnd_load_util.owner_id(owner)
2832: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2833: ,fnd_load_util.owner_id(owner)
2834: ,0
2835: FROM xla_aad_loader_defns_t
2836: WHERE table_name = 'XLA_MPA_JLT_AC_ASSGNS'
2837: AND staging_amb_context_code = p_staging_context_code;
2838:
2839: IF (C_LEVEL_EVENT >= g_log_level) THEN

Line 2889: FROM xla_aad_loader_defns_t xal

2885: ,fnd_load_util.owner_id(owner)
2886: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2887: ,fnd_load_util.owner_id(owner)
2888: ,0
2889: FROM xla_aad_loader_defns_t xal
2890: , fnd_application fap
2891: WHERE fap.application_short_name(+) = xal.segment_rule_appl_sn
2892: AND table_name = 'XLA_MPA_JLT_ADR_ASSGNS'
2893: AND staging_amb_context_code = p_staging_context_code;

Line 2982: FROM xla_aad_loader_defns_t xal

2978: ,fnd_load_util.owner_id(xal.owner)
2979: ,nvl(to_date(xal.orig_last_update_date, 'YYYY/MM/DD'), sysdate)
2980: ,fnd_load_util.owner_id(xal.owner)
2981: ,0
2982: FROM xla_aad_loader_defns_t xal
2983: ,xla_product_rules_b xpr
2984: ,fnd_id_flex_structures fift
2985: ,fnd_id_flex_structures fifa
2986: WHERE fift.application_id(+) = 101

Line 3033: FROM xla_aad_loader_defns_t xal

3029: ,fnd_load_util.owner_id(owner)
3030: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3031: ,fnd_load_util.owner_id(owner)
3032: ,0
3033: FROM xla_aad_loader_defns_t xal
3034: ,fnd_languages fl
3035: WHERE xal.table_name = 'XLA_PRODUCT_RULES'
3036: AND xal.staging_amb_context_code = p_staging_context_code
3037: AND fl.installed_flag IN ('I', 'B');

Line 3081: FROM xla_aad_loader_defns_t

3077: ,fnd_load_util.owner_id(owner)
3078: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3079: ,fnd_load_util.owner_id(owner)
3080: ,0
3081: FROM xla_aad_loader_defns_t
3082: WHERE table_name = 'XLA_PROD_ACCT_HEADERS'
3083: AND staging_amb_context_code = p_staging_context_code;
3084:
3085: IF (C_LEVEL_EVENT >= g_log_level) THEN

Line 3125: FROM xla_aad_loader_defns_t xal

3121: ,fnd_load_util.owner_id(owner)
3122: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3123: ,fnd_load_util.owner_id(owner)
3124: ,0
3125: FROM xla_aad_loader_defns_t xal
3126: ,fnd_application fap
3127: WHERE fap.application_short_name(+) = xal.source_app_short_name
3128: AND table_name = 'XLA_AAD_HDR_ACCT_ATTRS'
3129: AND staging_amb_context_code = p_staging_context_code;

Line 3167: FROM xla_aad_loader_defns_t

3163: ,fnd_load_util.owner_id(owner)
3164: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3165: ,fnd_load_util.owner_id(owner)
3166: ,0
3167: FROM xla_aad_loader_defns_t
3168: WHERE table_name = 'XLA_AAD_LINE_DEFN_ASSGNS'
3169: AND staging_amb_context_code = p_staging_context_code;
3170:
3171: IF (C_LEVEL_EVENT >= g_log_level) THEN

Line 3207: FROM xla_aad_loader_defns_t

3203: ,fnd_load_util.owner_id(owner)
3204: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3205: ,fnd_load_util.owner_id(owner)
3206: ,0
3207: FROM xla_aad_loader_defns_t
3208: WHERE table_name = 'XLA_AAD_HEADER_AC_ASSGNS'
3209: AND staging_amb_context_code = p_staging_context_code;
3210:
3211: IF (C_LEVEL_EVENT >= g_log_level) THEN

Line 3289: FROM xla_aad_loader_defns_t xal

3285: ,fnd_load_util.owner_id(owner)
3286: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3287: ,fnd_load_util.owner_id(owner)
3288: ,0
3289: FROM xla_aad_loader_defns_t xal
3290: ,fnd_id_flex_structures fift
3291: ,fnd_id_flex_structures fifa
3292: WHERE fift.application_id(+) = 101
3293: AND fift.id_flex_code(+) = 'GL#'

Line 3337: FROM xla_aad_loader_defns_t

3333: ,fnd_load_util.owner_id(owner)
3334: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3335: ,fnd_load_util.owner_id(owner)
3336: ,0
3337: FROM xla_aad_loader_defns_t
3338: WHERE table_name = 'XLA_ACCTG_METHOD_RULES'
3339: AND staging_amb_context_code = p_staging_context_code;
3340:
3341: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 3416: FROM xla_aad_loader_defns_t xal

3412: ,fnd_load_util.owner_id(owner)
3413: ,nvl(to_date(orig_last_update_date, 'YYYY/MM/DD'), sysdate)
3414: ,fnd_load_util.owner_id(owner)
3415: ,0
3416: FROM xla_aad_loader_defns_t xal
3417: ,fnd_application fap
3418: WHERE fap.application_short_name(+) = xal.application_short_name
3419: AND table_name = 'XLA_STAGING_COMPONENTS_H'
3420: AND staging_amb_context_code = p_staging_context_code;