APPS.FA_MC_UPG1_PKG dependencies on FA_MC_CONVERSION_HISTORY

Line 864: This procedure sets the conversion status in fa_mc_conversion_history

860: p_end_pc IN NUMBER,
861: p_fixed_conversion IN VARCHAR2,
862: p_mode IN VARCHAR2) IS
863: /* ************************************************************************
864: This procedure sets the conversion status in fa_mc_conversion_history
865: and fa_mc_book_controls for the Primary Book - Reporting book combination.
866: This procedure is called in different modes - select, running, converted.
867: When called in select mode, inserts a new row into conversion history
868: and sets book controls also to S. This status will then be used in

Line 872: fa_mc_conversion_history and fa_mc_book_controls will be kept in synch.

868: and sets book controls also to S. This status will then be used in
869: transaction approval to prevent transactions in the Primary Book until
870: conversion is completed - status of C. The conversion_status is used to
871: prevent running conversion before selection. The conversion_status in
872: fa_mc_conversion_history and fa_mc_book_controls will be kept in synch.
873: *************************************************************************/
874:
875: BEGIN
876: IF (p_mode = 'S') THEN

Line 879: DELETE FROM fa_mc_conversion_history

875: BEGIN
876: IF (p_mode = 'S') THEN
877:
878: -- delete row from a previous run which is out of date
879: DELETE FROM fa_mc_conversion_history
880: WHERE set_of_books_id = p_rsob_id AND
881: book_type_code = p_book_type_code;
882:
883: INSERT INTO FA_MC_CONVERSION_HISTORY(

Line 883: INSERT INTO FA_MC_CONVERSION_HISTORY(

879: DELETE FROM fa_mc_conversion_history
880: WHERE set_of_books_id = p_rsob_id AND
881: book_type_code = p_book_type_code;
882:
883: INSERT INTO FA_MC_CONVERSION_HISTORY(
884: set_of_books_id,
885: book_type_code,
886: conversion_status,
887: period_counter_selected,

Line 904: UPDATE fa_mc_conversion_history

900: book_type_code = p_book_type_code;
901:
902: ELSIF (p_mode = 'R') THEN
903:
904: UPDATE fa_mc_conversion_history
905: SET conversion_status = p_mode,
906: period_counter_start = p_start_pc,
907: last_update_date = sysdate,
908: fixed_rate_conversion = p_fixed_conversion

Line 927: DELETE FROM fa_mc_conversion_history

923: -- rollback assets that have been inserted into rates table since
924: -- the last commit
925:
926: FND_CONCURRENT.AF_ROLLBACK;
927: DELETE FROM fa_mc_conversion_history
928: WHERE set_of_books_id = p_rsob_id AND
929: book_type_code = p_book_type_code;
930:
931: UPDATE fa_mc_book_controls

Line 940: UPDATE fa_mc_conversion_history

936: ELSIF (p_mode = 'RE') THEN
937: -- called when conversion program ends in error
938: -- set conversion status to Error
939:
940: UPDATE fa_mc_conversion_history
941: SET conversion_status = 'E'
942: WHERE
943: set_of_books_id = p_rsob_id AND
944: book_type_code = p_book_type_code;

Line 953: UPDATE fa_mc_conversion_history

949: book_type_code = p_book_type_code;
950:
951: ELSIF (p_mode = 'C') THEN
952:
953: UPDATE fa_mc_conversion_history
954: SET conversion_status = p_mode,
955: period_counter_converted = p_end_pc,
956: last_update_date = sysdate
957: WHERE

Line 1164: UPDATE fa_mc_conversion_history

1160:
1161: END LOOP;
1162:
1163: -- update history table with number of assets selected
1164: UPDATE fa_mc_conversion_history
1165: SET total_assets = X_total_assets
1166: WHERE book_type_code = p_book_type_code AND
1167: set_of_books_id = p_rsob_id;
1168: FND_CONCURRENT.AF_COMMIT;

Line 1339: FROM fa_mc_conversion_history

1335: CURSOR check_preview IS
1336: SELECT period_counter_selected,
1337: total_assets,
1338: conversion_status
1339: FROM fa_mc_conversion_history
1340: WHERE set_of_books_id = p_rsob_id AND
1341: book_type_code = p_book_type_code AND
1342: conversion_status in ('S', 'E', 'R');
1343: