[Home] [Help]
63: and dp.xla_conversion_status not like 'U%'
64: and exists
65: (
66: select 'x'
67: from gl_period_statuses ps,
68: fa_book_controls bc
69: where ps.application_id = 101
70: and ps.migration_status_code in ('P', 'U')
71: and bc.set_of_books_id = ps.set_of_books_id
294: l_return_status number;
295:
296: cursor c_periods is
297: select bc.book_type_code, ps.period_name
298: from gl_period_statuses ps,
299: fa_book_controls bc
300: where ps.application_id = 101
301: and ps.migration_status_code in ('P', 'U')
302: and bc.set_of_books_id = ps.set_of_books_id;
490: where dp.xla_conversion_status = to_char (p_workers_num)
491: and exists
492: (
493: select 'x'
494: from gl_period_statuses ps,
495: fa_book_controls bc
496: where ps.application_id = 101
497: and ps.migration_status_code in ('P', 'U')
498: and bc.set_of_books_id = ps.set_of_books_id
508: and dp.xla_conversion_status is not null
509: and exists
510: (
511: select 'x'
512: from gl_period_statuses ps,
513: fa_book_controls bc
514: where ps.application_id = 101
515: and ps.migration_status_code in ('P', 'U')
516: and bc.set_of_books_id = ps.set_of_books_id
554: l_return_status number;
555:
556: cursor c_periods is
557: select bc.book_type_code, ps.period_name
558: from gl_period_statuses ps,
559: fa_book_controls bc
560: where ps.application_id = 101
561: and ps.migration_status_code in ('P', 'U')
562: and bc.set_of_books_id = ps.set_of_books_id;
581: and dp.xla_conversion_status not in ('UA', 'UD')
582: and exists
583: (
584: select 'x'
585: from gl_period_statuses ps,
586: fa_book_controls bc
587: where ps.application_id = 101
588: and ps.migration_status_code in ('P', 'U')
589: and bc.set_of_books_id = ps.set_of_books_id
794: where dp.xla_conversion_status = to_char (p_workers_num)
795: and exists
796: (
797: select 'x'
798: from gl_period_statuses ps,
799: fa_book_controls bc
800: where ps.application_id = 101
801: and ps.migration_status_code in ('P', 'U')
802: and bc.set_of_books_id = ps.set_of_books_id
814: and dp.xla_conversion_status is not null
815: and exists
816: (
817: select 'x'
818: from gl_period_statuses ps,
819: fa_book_controls bc
820: where ps.application_id = 101
821: and ps.migration_status_code in ('P', 'U')
822: and bc.set_of_books_id = ps.set_of_books_id
825: );
826:
827: COMMIT;
828:
829: -- Update gl_period_statuses
830: -- Note that we are setting partially upgraded periods (periods that
831: -- have the transactions, but not deprn, upgraded, to U because that is
832: -- the only way that we can make sure that the je_from_sla_flag in
833: -- gl_je_headers is set to Y, which is needed for drilldown to work.
830: -- Note that we are setting partially upgraded periods (periods that
831: -- have the transactions, but not deprn, upgraded, to U because that is
832: -- the only way that we can make sure that the je_from_sla_flag in
833: -- gl_je_headers is set to Y, which is needed for drilldown to work.
834: update gl_period_statuses
835: set migration_status_code = 'U'
836: where migration_status_code = 'P'
837: and application_id = 101
838: and (ledger_id, period_name) in
854: COMMIT;
855:
856: -- Fix for Bug #5596250. Need to update migration_status_code to null
857: -- for any periods that do not exist.
858: update gl_period_statuses ps
859: set ps.migration_status_code = null
860: where ps.migration_status_code = 'P'
861: and ps.application_id = 101
862: and not exists
876: and bc.set_of_books_id = ps.ledger_id
877: and dp.period_name = ps.period_name
878: );
879:
880: update gl_period_statuses ps
881: set ps.migration_status_code = null
882: where ps.migration_status_code = 'P'
883: and ps.application_id = 101
884: and exists