APPS.FA_BOOKS_PKG dependencies on FA_MC_BOOKS

Line 141: CURSOR C_bk_mc IS SELECT rowid FROM fa_mc_books

137: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type ) IS
138: CURSOR C_bk IS SELECT rowid FROM fa_books
139: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;
140:
141: CURSOR C_bk_mc IS SELECT rowid FROM fa_mc_books
142: WHERE transaction_header_id_in = X_Transaction_Header_Id_In
143: AND set_of_books_id = X_set_of_books_id;
144:
145: BEGIN

Line 148: INSERT INTO fa_mc_books(

144:
145: BEGIN
146:
147: if (X_mrc_sob_type_code = 'R') then
148: INSERT INTO fa_mc_books(
149: set_of_books_id,
150: book_type_code,
151: asset_id,
152: date_placed_in_service,

Line 1067: UPDATE fa_mc_books

1063: BEGIN
1064:
1065: if (X_mrc_sob_type_code = 'R') then
1066: if X_Rowid is not null then
1067: UPDATE fa_mc_books
1068: SET
1069: book_type_code = decode(X_Book_Type_Code,
1070: NULL, book_type_code,
1071: FND_API.G_MISS_CHAR, NULL,

Line 1402: UPDATE fa_mc_books

1398: FND_API.G_MISS_NUM, NULL,
1399: X_Formula_Factor)
1400: WHERE rowid = X_Rowid;
1401: else
1402: UPDATE fa_mc_books
1403: SET
1404: book_type_code = decode(X_Book_Type_Code,
1405: NULL, book_type_code,
1406: FND_API.G_MISS_CHAR, NULL,

Line 2471: DELETE FROM fa_mc_books

2467: BEGIN
2468:
2469: if (X_mrc_sob_type_code = 'R') then
2470: if X_Rowid is not null then
2471: DELETE FROM fa_mc_books
2472: WHERE rowid = X_Rowid;
2473: elsif X_Transaction_Header_Id_In is not null then
2474: DELETE FROM fa_mc_books
2475: WHERE transaction_header_id_in = X_Transaction_Header_Id_In

Line 2474: DELETE FROM fa_mc_books

2470: if X_Rowid is not null then
2471: DELETE FROM fa_mc_books
2472: WHERE rowid = X_Rowid;
2473: elsif X_Transaction_Header_Id_In is not null then
2474: DELETE FROM fa_mc_books
2475: WHERE transaction_header_id_in = X_Transaction_Header_Id_In
2476: AND set_of_books_id = X_set_of_books_id;
2477: elsif X_Asset_Id is not null then
2478: DELETE FROM fa_mc_books

Line 2478: DELETE FROM fa_mc_books

2474: DELETE FROM fa_mc_books
2475: WHERE transaction_header_id_in = X_Transaction_Header_Id_In
2476: AND set_of_books_id = X_set_of_books_id;
2477: elsif X_Asset_Id is not null then
2478: DELETE FROM fa_mc_books
2479: WHERE asset_id = X_Asset_Id
2480: AND set_of_books_id = X_set_of_books_id;
2481: else
2482: -- print some error message

Line 2520: UPDATE fa_mc_books

2516:
2517: BEGIN
2518:
2519: if (X_mrc_sob_type_code = 'R') then
2520: UPDATE fa_mc_books
2521: SET period_counter_fully_retired = null,
2522: date_ineffective = null,
2523: transaction_header_id_out = null,
2524: retirement_id = null

Line 2559: UPDATE fa_mc_books

2555:
2556: BEGIN
2557:
2558: if (X_mrc_sob_type_code = 'R') then
2559: UPDATE fa_mc_books
2560: SET date_ineffective = X_date_ineffective,
2561: last_update_date = X_date_ineffective,
2562: transaction_header_id_out = X_transaction_header_id_out
2563: WHERE asset_id = X_Asset_Id