[Home] [Help]
879: p_denominator_rate IN NUMBER,
880: p_mau IN NUMBER,
881: p_precision IN NUMBER) IS
882: /* ************************************************************************
883: This procedure will convert all rows in fa_adjustments in the fiscal
884: being converted and all rows in prior fiscal years related to balance
885: sheet accounts for the candidate assets. The first insert will insert
886: all rows in the fiscal year being converted and the second insert
887: inserts all prior years rows.
889:
890: BEGIN
891: if (g_print_debug) then
892: fa_debug_pkg.add('convert_assets',
893: 'Converting FA_ADJUSTMENTS records',
894: 'start');
895: end if;
896:
897:
894: 'start');
895: end if;
896:
897:
898: -- convert everything in fa_adjustments in the fiscal year being
899: -- converted
900:
901: INSERT INTO fa_mc_adjustments(
902: set_of_books_id,
1034: aj.global_attribute19,
1035: aj.global_attribute20,
1036: aj.global_attribute_category,
1037: 'Y',
1038: fa_adjustments_s.nextval,
1039: aj.deprn_override_flag,
1040: aj.track_member_flag,
1041: aj.source_line_id,
1042: aj.source_dest_code
1040: aj.track_member_flag,
1041: aj.source_line_id,
1042: aj.source_dest_code
1043: FROM
1044: fa_adjustments aj,
1045: fa_mc_conversion_rates cr
1046:
1047: WHERE
1048: cr.set_of_books_id = p_rsob_id AND
1191: aj.global_attribute19,
1192: aj.global_attribute20,
1193: aj.global_attribute_category,
1194: 'Y',
1195: fa_adjustments_s.nextval,
1196: aj.deprn_override_flag,
1197: aj.track_member_flag,
1198: aj.source_line_id,
1199: aj.source_dest_code
1197: aj.track_member_flag,
1198: aj.source_line_id,
1199: aj.source_dest_code
1200: FROM
1201: fa_adjustments aj,
1202: fa_mc_conversion_rates cr
1203: WHERE
1204: cr.set_of_books_id = p_rsob_id AND
1205: cr.book_type_code = p_book_type_code AND
1219: cr.status = 'S';
1220:
1221: if (g_print_debug) then
1222: fa_debug_pkg.add('convert_assets',
1223: 'Converted FA_ADJUSTMENTS records',
1224: 'success');
1225: end if;
1226:
1227: