APPS.FA_BOOKS_PKG dependencies on FA_BOOKS_MRC_V

Line 128: CURSOR C_bk_mc IS SELECT rowid FROM fa_books_mrc_v

124: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
125: CURSOR C_bk IS SELECT rowid FROM fa_books
126: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;
127:
128: CURSOR C_bk_mc IS SELECT rowid FROM fa_books_mrc_v
129: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;
130:
131: BEGIN
132:

Line 134: INSERT INTO fa_books_mrc_v(

130:
131: BEGIN
132:
133: if (X_mrc_sob_type_code = 'R') then
134: INSERT INTO fa_books_mrc_v(
135: book_type_code,
136: asset_id,
137: date_placed_in_service,
138: date_effective,

Line 1009: UPDATE fa_books_mrc_v

1005: BEGIN
1006:
1007: if (X_mrc_sob_type_code = 'R') then
1008: if X_Rowid is not null then
1009: UPDATE fa_books_mrc_v
1010: SET
1011: book_type_code = decode(X_Book_Type_Code,
1012: NULL, book_type_code,
1013: FND_API.G_MISS_CHAR, NULL,

Line 1340: UPDATE fa_books_mrc_v

1336: FND_API.G_MISS_CHAR, NULL,
1337: X_Formula_Factor)
1338: WHERE rowid = X_Rowid;
1339: else
1340: UPDATE fa_books_mrc_v
1341: SET
1342: book_type_code = decode(X_Book_Type_Code,
1343: NULL, book_type_code,
1344: FND_API.G_MISS_CHAR, NULL,

Line 2355: DELETE FROM fa_books_mrc_v

2351: BEGIN
2352:
2353: if (X_mrc_sob_type_code = 'R') then
2354: if X_Rowid is not null then
2355: DELETE FROM fa_books_mrc_v
2356: WHERE rowid = X_Rowid;
2357: elsif X_Transaction_Header_Id_In is not null then
2358: DELETE FROM fa_books_mrc_v
2359: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;

Line 2358: DELETE FROM fa_books_mrc_v

2354: if X_Rowid is not null then
2355: DELETE FROM fa_books_mrc_v
2356: WHERE rowid = X_Rowid;
2357: elsif X_Transaction_Header_Id_In is not null then
2358: DELETE FROM fa_books_mrc_v
2359: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;
2360: elsif X_Asset_Id is not null then
2361: DELETE FROM fa_books_mrc_v
2362: WHERE asset_id = X_Asset_Id;

Line 2361: DELETE FROM fa_books_mrc_v

2357: elsif X_Transaction_Header_Id_In is not null then
2358: DELETE FROM fa_books_mrc_v
2359: WHERE transaction_header_id_in = X_Transaction_Header_Id_In;
2360: elsif X_Asset_Id is not null then
2361: DELETE FROM fa_books_mrc_v
2362: WHERE asset_id = X_Asset_Id;
2363: else
2364: -- print some error message
2365: null;

Line 2403: UPDATE fa_books_mrc_v

2399:
2400: BEGIN
2401:
2402: if (X_mrc_sob_type_code = 'R') then
2403: UPDATE fa_books_mrc_v
2404: SET period_counter_fully_retired = null,
2405: date_ineffective = null,
2406: transaction_header_id_out = null,
2407: retirement_id = null

Line 2442: UPDATE fa_books_mrc_v

2438:
2439: BEGIN
2440:
2441: if (X_mrc_sob_type_code = 'R') then
2442: UPDATE fa_books_mrc_v
2443: SET date_ineffective = X_date_ineffective,
2444: last_update_date = X_date_ineffective,
2445: transaction_header_id_out = X_transaction_header_id_out
2446: WHERE asset_id = X_Asset_Id