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_HIST_LEDGER_UPG_PKG dependencies on XLA_HISTORIC_CONTROL

Line 267: -- possible committed status in xla_historic_control: no row, PHASE-DATA-START, SUCCESS

263: g_batch_size := NVL(p_batch_size , 1000);
264: g_num_workers := NVL(p_num_workers, 1);
265:
266: -- possible status during run: PHASE-RATE, PHASE-DATA-START, SUCCESS
267: -- possible committed status in xla_historic_control: no row, PHASE-DATA-START, SUCCESS
268: -- possible p_mode values: V (validation), F (final), R (recovery)
269:
270: -- added this to show meaning in the logfile rather than the code.
271: SELECT meaning

Line 287: INSERT INTO xla_historic_control(primary_ledger,

283:
284: retrieve_validate();
285: validate_final_mode();
286:
287: INSERT INTO xla_historic_control(primary_ledger,
288: secondary_alc_ledger,
289: application_id,
290: upgrade_id,
291: relationship_id,

Line 386: INSERT INTO xla_historic_control(primary_ledger,

382: c) if second+ run, end date is min start date - 1 of all previously upgraded start dates
383: d) start should be less than end date retrieved
384: no commit! */
385:
386: INSERT INTO xla_historic_control(primary_ledger,
387: secondary_alc_ledger,
388: application_id,
389: upgrade_id,
390: relationship_id,

Line 471: UPDATE xla_historic_control

467:
468: populate_rates(); /* for different date-range runs, rates will be re-inserted with same
469: relationship id same but different upgrade id */
470:
471: UPDATE xla_historic_control
472: SET status = 'PHASE-DATA-START'
473: WHERE primary_ledger = g_primary_ledger_id
474: AND secondary_alc_ledger = g_secondary_alc_ledger_id
475: AND application_id = g_application_id

Line 486: (p_msg => 'xla_historic_control updated to PHASE-DATA-START, commit executed'

482:
483:
484: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
485: trace
486: (p_msg => 'xla_historic_control updated to PHASE-DATA-START, commit executed'
487: ,p_level => C_LEVEL_PROCEDURE
488: ,p_module => l_log_module);
489: END IF;
490:

Line 615: -- these sqls are called before current run row is inserted into xla_historic_control

611: END IF;
612: fnd_file.put_line(fnd_file.log,'validate_recovery_mode procedure start time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
613:
614:
615: -- these sqls are called before current run row is inserted into xla_historic_control
616:
617: SELECT COUNT(*)
618: INTO g_recovery_failed_runs
619: FROM xla_historic_control

Line 619: FROM xla_historic_control

615: -- these sqls are called before current run row is inserted into xla_historic_control
616:
617: SELECT COUNT(*)
618: INTO g_recovery_failed_runs
619: FROM xla_historic_control
620: WHERE primary_ledger = g_primary_ledger_id
621: AND secondary_alc_ledger = g_secondary_alc_ledger_id
622: AND application_id = g_application_id
623: AND status <> 'SUCCESS';

Line 679: FROM xla_historic_control

675: ,g_upgrade_id
676: ,g_script_name
677: ,g_batch_size
678: ,g_num_workers
679: FROM xla_historic_control
680: WHERE primary_ledger = g_primary_ledger_id
681: AND secondary_alc_ledger = g_secondary_alc_ledger_id
682: AND application_id = g_application_id
683: AND status = 'PHASE-DATA-START';

Line 721: -- these sqls are called before current run row is inserted into xla_historic_control

717: END IF;
718: fnd_file.put_line(fnd_file.log,'validate_final_mode procedure start time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
719:
720:
721: -- these sqls are called before current run row is inserted into xla_historic_control
722:
723: SELECT COUNT(*)
724: INTO g_failed_runs
725: FROM xla_historic_control

Line 725: FROM xla_historic_control

721: -- these sqls are called before current run row is inserted into xla_historic_control
722:
723: SELECT COUNT(*)
724: INTO g_failed_runs
725: FROM xla_historic_control
726: WHERE primary_ledger = g_primary_ledger_id
727: AND secondary_alc_ledger = g_secondary_alc_ledger_id
728: AND application_id = g_application_id
729: AND relationship_id = g_relationship_id

Line 735: FROM xla_historic_control

731:
732:
733: SELECT COUNT(*)
734: INTO g_success_runs
735: FROM xla_historic_control
736: WHERE primary_ledger = g_primary_ledger_id
737: AND secondary_alc_ledger = g_secondary_alc_ledger_id
738: AND application_id = g_application_id
739: AND relationship_id = g_relationship_id

Line 798: FROM xla_historic_control

794: --current run is the 2nd or higher run, set end date to start date less one of last run
795:
796: SELECT min(start_date-1) , min(sec_alc_min_acctng_batch_id)
797: INTO g_sec_alc_end_date , g_sec_alc_min_acctng_batch_id
798: FROM xla_historic_control
799: WHERE primary_ledger = g_primary_ledger_id
800: AND secondary_alc_ledger = g_secondary_alc_ledger_id
801: AND application_id = g_application_id
802: AND relationship_id = g_relationship_id

Line 1296: xla_historic_control XHC,

1292: CURSOR c_entered_currencies
1293: IS
1294: SELECT /*+ parallel(xah) parallel(xal) leading(xah) */ distinct(XAL.currency_code)
1295: FROM xla_ae_headers XAH,
1296: xla_historic_control XHC,
1297: xla_ae_lines XAL
1298: WHERE XHC.primary_ledger = g_primary_ledger_id
1299: AND XHC.secondary_alc_ledger = g_secondary_alc_ledger_id
1300: AND XHC.upgrade_id = g_upgrade_id

Line 1678: FROM xla_historic_control

1674: g_calendar_convert,
1675: g_dynamic_flag,
1676: g_mapping_rel_id,
1677: g_coa_map_name
1678: FROM xla_historic_control
1679: WHERE primary_ledger = p_primary_ledger_id
1680: AND secondary_alc_ledger = p_sec_alc_ledger_id
1681: AND application_id = p_application_id
1682: AND relationship_id = p_relationship_id

Line 1860: UPDATE xla_historic_control

1856: -- run status remains PHASE-DATA-START even if rollback
1857:
1858: ELSE
1859:
1860: UPDATE xla_historic_control
1861: SET status = 'SUCCESS'
1862: WHERE primary_ledger = p_primary_ledger_id
1863: AND secondary_alc_ledger = p_sec_alc_ledger_id
1864: AND application_id = p_application_id

Line 2259: xla_historic_control XHC

2255: , XAH.PARENT_AE_LINE_NUM
2256: , XAH.ACCRUAL_REVERSAL_FLAG
2257: , XAH.MERGE_EVENT_ID
2258: FROM xla_ae_headers XAH,
2259: xla_historic_control XHC
2260: WHERE XHC.primary_ledger = p_primary_ledger_id -- worker input
2261: AND XHC.secondary_alc_ledger = p_sec_alc_ledger_id -- worker input
2262: AND XHC.upgrade_id = p_ugprade_id -- worker input
2263: AND XHC.application_id = p_application_id -- worker input

Line 2301: xla_historic_control XHC,

2297: INSERT INTO xla_historic_mapping_gt(primary_header_id, new_header_id)
2298: SELECT /*+ rowid(xah) leading(xah) index(xahnew xla_ae_headers_n2)*/
2299: XAH.ae_header_id, XAHNEW.ae_header_id
2300: FROM xla_ae_headers XAH,
2301: xla_historic_control XHC,
2302: xla_ae_headers XAHNEW
2303: WHERE XHC.primary_ledger = p_primary_ledger_id -- worker input
2304: AND XHC.secondary_alc_ledger = p_sec_alc_ledger_id -- worker input
2305: AND XHC.upgrade_id = p_ugprade_id -- worker input

Line 2572: FROM xla_historic_control XHC,

2568: , XDL.ALLOC_TO_DIST_ID_CHAR_3
2569: , XDL.ALLOC_TO_DIST_ID_CHAR_4
2570: , XDL.ALLOC_TO_DIST_ID_CHAR_5
2571: , GAIN_OR_LOSS_REF
2572: FROM xla_historic_control XHC,
2573: xla_historic_mapping_gt XMAP,
2574: xla_ae_lines XAL,
2575: xla_distribution_links XDL,
2576: xla_rc_upgrade_rates XRUR

Line 2810: FROM xla_historic_control XHC,

2806: , XHC.secondary_alc_ledger
2807: , XAL.SOURCE_TABLE
2808: , XAL.SOURCE_ID
2809: , XAL.ACCOUNT_OVERLAY_SOURCE_ID
2810: FROM xla_historic_control XHC,
2811: xla_historic_mapping_gt XMAP,
2812: xla_ae_lines XAL,
2813: xla_rc_upgrade_rates XRUR
2814: WHERE XHC.primary_ledger = p_primary_ledger_id -- worker input