APPS.FA_BOOK_CONTROLS_PKG dependencies on FA_BOOK_CONTROLS_MRC_V

Line 157: CURSOR C_bc_mc IS SELECT rowid FROM fa_book_controls_mrc_v

153:
154: CURSOR C_bc IS SELECT rowid FROM fa_book_controls
155: WHERE book_type_code = X_Book_Type_Code;
156:
157: CURSOR C_bc_mc IS SELECT rowid FROM fa_book_controls_mrc_v
158: WHERE book_type_code = X_Book_Type_Code;
159:
160: BEGIN
161:

Line 164: insert into fa_book_controls_mrc_v (

160: BEGIN
161:
162: if (X_mrc_sob_type_code = 'R') then
163:
164: insert into fa_book_controls_mrc_v (
165: book_type_code,
166: book_type_name,
167: set_of_books_id,
168: initial_date,

Line 1226: UPDATE fa_book_controls_mrc_v

1222: BEGIN
1223:
1224: if (X_mrc_sob_type_code = 'R') then
1225:
1226: UPDATE fa_book_controls_mrc_v
1227: SET
1228: book_type_name = X_Book_Type_Name,
1229: set_of_books_id = X_Set_Of_Books_Id,
1230: initial_date = X_Initial_Date,

Line 1863: from fa_book_controls_mrc_v

1859: if (X_Rowid is not null) then
1860: if (X_mrc_sob_type_code = 'R') then
1861: select book_type_code
1862: into l_book_type_code
1863: from fa_book_controls_mrc_v
1864: where rowid = X_Rowid;
1865: else
1866: select book_type_code
1867: into l_book_type_code

Line 1909: DELETE FROM fa_book_controls_mrc_v

1905: if (X_mrc_sob_type_code = 'R') then
1906: DELETE FROM fa_deprn_periods_mrc_v
1907: WHERE book_type_code = l_book_type_code;
1908:
1909: DELETE FROM fa_book_controls_mrc_v
1910: WHERE book_type_code = l_book_type_code;
1911:
1912: else
1913: DELETE FROM fa_deprn_periods