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.FA_UPGHARNESS_PKG dependencies on FA_DEPRN_PERIODS

Line 60: update fa_deprn_periods dp

56: if (l_workers_num < 1) then
57: raise nothing_to_run;
58: end if;
59:
60: update fa_deprn_periods dp
61: set dp.xla_conversion_status = 'H'
62: where dp.xla_conversion_status is not null
63: and dp.xla_conversion_status not like 'U%'
64: and exists

Line 145: from fa_deprn_periods

141:
142: -- Check to see if all periods were upgraded successfully.
143: select count(*)
144: into l_errors
145: from fa_deprn_periods
146: where nvl(xla_conversion_status, 'UA') not in ('UT', 'UD', 'UA', 'H');
147:
148: if (l_errors > 0) then
149:

Line 440: update fa_deprn_periods dp

436: l_period_name_tbl
437: limit 100;
438:
439: forall i in 1..l_book_type_code_tbl.count
440: update fa_deprn_periods dp
441: set dp.xla_conversion_status =
442: decode (substr(dp.xla_conversion_status, 1, 1),
443: 'H', '1',
444: 'E', '1',

Line 488: update fa_deprn_periods dp

484: if (p_worker_id <> 1) then return; end if;
485:
486: -- If all of the workers completed successfully, mark the period as
487: -- successful.
488: update fa_deprn_periods dp
489: set dp.xla_conversion_status = 'UT'
490: where dp.xla_conversion_status = to_char (p_workers_num)
491: and exists
492: (

Line 504: update fa_deprn_periods dp

500: and ps.period_name = dp.period_name
501: );
502:
503: -- Mark as error any periods where the workers did not complete.
504: update fa_deprn_periods dp
505: set dp.xla_conversion_status = 'ET'
506: where dp.xla_conversion_status <> to_char (p_workers_num)
507: and dp.xla_conversion_status not in ('UA', 'UT')
508: and dp.xla_conversion_status is not null

Line 577: from fa_deprn_periods dp

573: if (p_mode = 'downtime') then
574:
575: select count(*)
576: into l_deprn_run
577: from fa_deprn_periods dp
578: where dp.period_close_date is null
579: and dp.deprn_run = 'Y'
580: and dp.xla_conversion_status is not null
581: and dp.xla_conversion_status not in ('UA', 'UD')

Line 710: update fa_deprn_periods dp

706: end if;
707:
708: if (p_mode = 'downtime') then
709:
710: update fa_deprn_periods dp
711: set dp.xla_conversion_status =
712: decode (substr(dp.xla_conversion_status, 1, 1),
713: 'U', '1',
714: 'E', '1',

Line 743: update fa_deprn_periods dp

739: l_period_name_tbl
740: limit 100;
741:
742: forall i in 1..l_book_type_code_tbl.count
743: update fa_deprn_periods dp
744: set dp.xla_conversion_status =
745: decode (substr(dp.xla_conversion_status, 1, 1),
746: 'U', '1',
747: 'E', '1',

Line 792: update fa_deprn_periods dp

788: if (p_worker_id <> 1) then return; end if;
789:
790: -- If all of the workers completed successfully, mark the period as
791: -- successful.
792: update fa_deprn_periods dp
793: set dp.xla_conversion_status = 'UA'
794: where dp.xla_conversion_status = to_char (p_workers_num)
795: and exists
796: (

Line 810: update fa_deprn_periods dp

806:
807: COMMIT;
808:
809: -- Mark as error any periods where the workers did not complete.
810: update fa_deprn_periods dp
811: set dp.xla_conversion_status = 'ED'
812: where dp.xla_conversion_status <> to_char (p_workers_num)
813: and dp.xla_conversion_status not in ('UA', 'UT', 'UD')
814: and dp.xla_conversion_status is not null

Line 841: from fa_deprn_periods dp,

837: and application_id = 101
838: and (ledger_id, period_name) in
839: (
840: select bc.set_of_books_id, dp.period_name
841: from fa_deprn_periods dp,
842: fa_book_controls bc
843: where dp.xla_conversion_status in ('UA', 'UD', 'UT')
844: and bc.book_type_code = dp.book_type_code
845: union all

Line 847: from fa_deprn_periods dp,

843: where dp.xla_conversion_status in ('UA', 'UD', 'UT')
844: and bc.book_type_code = dp.book_type_code
845: union all
846: select bc.set_of_books_id, dp.period_name
847: from fa_deprn_periods dp,
848: fa_mc_book_controls bc
849: where dp.xla_conversion_status in ('UA', 'UD', 'UT')
850: and bc.book_type_code = dp.book_type_code
851: and bc.enabled_flag = 'Y'

Line 865: from fa_deprn_periods dp,

861: and ps.application_id = 101
862: and not exists
863: (
864: select 'x'
865: from fa_deprn_periods dp,
866: fa_book_controls bc
867: where bc.book_type_code = dp.book_type_code
868: and bc.set_of_books_id = ps.ledger_id
869: and dp.period_name = ps.period_name

Line 872: from fa_deprn_periods dp,

868: and bc.set_of_books_id = ps.ledger_id
869: and dp.period_name = ps.period_name
870: union all
871: select 'x'
872: from fa_deprn_periods dp,
873: fa_mc_book_controls bc
874: where bc.book_type_code = dp.book_type_code
875: and bc.enabled_flag = 'Y'
876: and bc.set_of_books_id = ps.ledger_id

Line 887: from fa_deprn_periods dp,

883: and ps.application_id = 101
884: and exists
885: (
886: select 'x'
887: from fa_deprn_periods dp,
888: fa_book_controls bc
889: where bc.book_type_code = dp.book_type_code
890: and bc.set_of_books_id = ps.ledger_id
891: and dp.period_name = ps.period_name

Line 895: from fa_deprn_periods dp,

891: and dp.period_name = ps.period_name
892: and dp.xla_conversion_status is null
893: union all
894: select 'x'
895: from fa_deprn_periods dp,
896: fa_mc_book_controls bc
897: where bc.book_type_code = dp.book_type_code
898: and bc.enabled_flag = 'Y'
899: and bc.set_of_books_id = ps.ledger_id