APPS.FA_MC_UPG1_PKG dependencies on FA_MC_BOOK_CONTROLS

Line 25: from fa_mc_book_controls

21: l_converted_flag varchar2(1);
22: BEGIN
23: select mrc_converted_flag
24: into l_converted_flag
25: from fa_mc_book_controls
26: where book_type_code = p_book_type_code AND
27: set_of_books_id = p_rsob_id
28: for update of
29: mrc_converted_flag

Line 91: 'drop index FA_MC_BOOK_CONTROLS_U1','INDEX');

87: 'drop index FA_MC_BOOKS_RATES_U1','INDEX');
88:
89: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
90: ad_ddl.drop_index,
91: 'drop index FA_MC_BOOK_CONTROLS_U1','INDEX');
92:
93: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
94: ad_ddl.drop_index,
95: 'drop index FA_MC_DEFERRED_DEPRN_N1','INDEX');

Line 223: 'create unique index FA_MC_BOOK_CONTROLS_U1 ON

219: INVOICE_TRANSACTION_ID)', 'INDEX');
220:
221: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
222: ad_ddl.create_index,
223: 'create unique index FA_MC_BOOK_CONTROLS_U1 ON
224: FA_MC_BOOK_CONTROLS(
225: SET_OF_BOOKS_ID,
226: BOOK_TYPE_CODE)', 'INDEX');
227:

Line 224: FA_MC_BOOK_CONTROLS(

220:
221: ad_ddl.do_ddl(out_oracle_schema, 'OFA',
222: ad_ddl.create_index,
223: 'create unique index FA_MC_BOOK_CONTROLS_U1 ON
224: FA_MC_BOOK_CONTROLS(
225: SET_OF_BOOKS_ID,
226: BOOK_TYPE_CODE)', 'INDEX');
227:
228: ad_ddl.do_ddl(out_oracle_schema, 'OFA',

Line 385: fa_mc_book_controls mcbc,

381: mcbc.mrc_converted_flag,
382: mcbc.enabled_flag,
383: nvl(bc.mc_source_flag,'N')
384: FROM
385: fa_mc_book_controls mcbc,
386: gl_sets_of_books glsob,
387: fa_book_controls bc
388: WHERE
389: bc.book_type_code = p_book_type_code AND

Line 865: and fa_mc_book_controls for the Primary Book - Reporting book combination.

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
869: transaction approval to prevent transactions in the Primary Book until

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 896: UPDATE fa_mc_book_controls

892: p_mode,
893: p_end_pc,
894: sysdate);
895:
896: UPDATE fa_mc_book_controls
897: SET conversion_status = p_mode
898: WHERE
899: set_of_books_id = p_rsob_id AND
900: book_type_code = p_book_type_code;

Line 913: UPDATE fa_mc_book_controls

909: WHERE
910: set_of_books_id = p_rsob_id AND
911: book_type_code = p_book_type_code;
912:
913: UPDATE fa_mc_book_controls
914: SET conversion_status = p_mode
915: WHERE
916: set_of_books_id = p_rsob_id AND
917: book_type_code = p_book_type_code;

Line 931: UPDATE fa_mc_book_controls

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
932: SET conversion_status = NULL
933: WHERE set_of_books_id = p_rsob_id AND
934: book_type_code = p_book_type_code;
935:

Line 946: UPDATE fa_mc_book_controls

942: WHERE
943: set_of_books_id = p_rsob_id AND
944: book_type_code = p_book_type_code;
945:
946: UPDATE fa_mc_book_controls
947: SET conversion_status = 'E'
948: WHERE set_of_books_id = p_rsob_id AND
949: book_type_code = p_book_type_code;
950:

Line 961: UPDATE fa_mc_book_controls

957: WHERE
958: set_of_books_id = p_rsob_id AND
959: book_type_code = p_book_type_code;
960:
961: UPDATE fa_mc_book_controls
962: SET mrc_converted_flag = 'Y',
963: last_period_counter = p_end_pc - 1,
964: conversion_status = p_mode
965: WHERE