APPS.FA_BEGIN_MASS_TRX_PKG dependencies on FA_BOOK_CONTROLS

Line 96: * updating the request ID in fa_book_controls to the request_id

92: /* All checks completed, update book_controls with mass request id */
93:
94: /*
95: * Ensure this is the only request running against the book by
96: * updating the request ID in fa_book_controls to the request_id
97: * of the running request
98: */
99:
100: if (h_mrc_sob_type_code = 'R') then

Line 101: UPDATE fa_book_controls_mrc_v

97: * of the running request
98: */
99:
100: if (h_mrc_sob_type_code = 'R') then
101: UPDATE fa_book_controls_mrc_v
102: SET mass_request_id = X_request_id
103: WHERE book_type_code = X_book;
104: else
105: UPDATE fa_book_controls

Line 105: UPDATE fa_book_controls

101: UPDATE fa_book_controls_mrc_v
102: SET mass_request_id = X_request_id
103: WHERE book_type_code = X_book;
104: else
105: UPDATE fa_book_controls
106: SET mass_request_id = X_request_id
107: WHERE book_type_code = X_book;
108: end if;
109:

Line 154: UPDATE fa_book_controls_mrc_v

150: return(FALSE);
151: end if;
152:
153: if (h_mrc_sob_type_code = 'R') then
154: UPDATE fa_book_controls_mrc_v
155: SET mass_request_id = NULL
156: WHERE book_type_code = X_book
157: AND mass_request_id = X_request_id;
158: else

Line 159: UPDATE fa_book_controls

155: SET mass_request_id = NULL
156: WHERE book_type_code = X_book
157: AND mass_request_id = X_request_id;
158: else
159: UPDATE fa_book_controls
160: SET mass_request_id = NULL
161: WHERE book_type_code = X_book
162: AND mass_request_id = X_request_id;
163: end if;