APPS.FA_BOOKS_SUMMARY_PKG dependencies on FA_BOOKS_SUMMARY

Line 1: PACKAGE BODY FA_BOOKS_SUMMARY_PKG as

1: PACKAGE BODY FA_BOOKS_SUMMARY_PKG as
2: /* $Header: faxibsb.pls 120.5 2009/04/15 14:29:35 bridgway ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Book_Type_Code VARCHAR2,

Line 112: FROM fa_books_summary

108: X_Calling_Fn VARCHAR2
109: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
110:
111: CURSOR C_bs IS SELECT rowid
112: FROM fa_books_summary
113: WHERE asset_id = X_Asset_ID
114: AND book_type_code = X_Book_Type_Code
115: AND period_counter = X_Period_Counter;
116:

Line 343: INSERT INTO fa_books_summary(

339: CLOSE C_bs_mc;
340:
341: else
342:
343: INSERT INTO fa_books_summary(
344: book_type_code,
345: asset_id,
346: period_counter,
347: fiscal_year,

Line 562: calling_fn => 'fa_books_summary_pkg.insert_row', p_log_level_rec => p_log_level_rec);

558:
559: EXCEPTION
560: WHEN OTHERS THEN
561: fa_srvr_msg.add_sql_error(
562: calling_fn => 'fa_books_summary_pkg.insert_row', p_log_level_rec => p_log_level_rec);
563: X_Return_Status := FALSE;
564: raise;
565: END Insert_Row;
566:

Line 758: FROM fa_books_summary

754: last_updated_by,
755: last_update_login,
756: change_in_eofy_reserve,
757: switch_code
758: FROM fa_books_summary
759: WHERE rowid = X_Rowid
760: FOR UPDATE of Asset_Id, Book_Type_Code, Period_Counter NOWAIT;
761:
762: Recinfo C%ROWTYPE;

Line 1308: UPDATE fa_books_summary

1304: AND set_of_books_id = X_set_of_books_id;
1305: end if;
1306: else
1307: if X_Rowid is not null then
1308: UPDATE fa_books_summary
1309: SET
1310: book_type_code = decode(X_Book_Type_Code,
1311: NULL, book_type_code,
1312: FND_API.G_MISS_CHAR, NULL,

Line 1718: calling_fn => 'fa_books_summary_pkg.update_row', p_log_level_rec => p_log_level_rec);

1714:
1715: EXCEPTION
1716: WHEN OTHERS THEN
1717: fa_srvr_msg.add_sql_error(
1718: calling_fn => 'fa_books_summary_pkg.update_row', p_log_level_rec => p_log_level_rec);
1719: raise;
1720: END Update_Row;
1721:
1722: PROCEDURE Delete_Row(X_Rowid VARCHAR2 DEFAULT NULL,

Line 1755: DELETE FROM fa_books_summary

1751: null;
1752: end if;
1753: else
1754: if (X_Rowid is not null) then
1755: DELETE FROM fa_books_summary
1756: WHERE rowid = X_Rowid;
1757: elsif ((X_Asset_ID is not null) AND
1758: (X_Book_Type_Code is not null) AND
1759: (X_Period_Counter is not null)) then

Line 1760: DELETE FROM fa_books_summary

1756: WHERE rowid = X_Rowid;
1757: elsif ((X_Asset_ID is not null) AND
1758: (X_Book_Type_Code is not null) AND
1759: (X_Period_Counter is not null)) then
1760: DELETE FROM fa_books_summary
1761: WHERE asset_id = X_Asset_ID
1762: AND book_type_code = X_Book_Type_Code
1763: AND period_counter = X_Period_Counter;
1764: elsif (X_Asset_Id is not null) then

Line 1765: DELETE FROM fa_books_summary

1761: WHERE asset_id = X_Asset_ID
1762: AND book_type_code = X_Book_Type_Code
1763: AND period_counter = X_Period_Counter;
1764: elsif (X_Asset_Id is not null) then
1765: DELETE FROM fa_books_summary
1766: WHERE asset_id = X_Asset_Id;
1767: else
1768: -- print some error message
1769: null;

Line 1780: CALLED_FN => 'fa_books_summary_pkg.delete_row',

1776:
1777: EXCEPTION
1778: WHEN OTHERS THEN
1779: FA_STANDARD_PKG.RAISE_ERROR(
1780: CALLED_FN => 'fa_books_summary_pkg.delete_row',
1781: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
1782: END Delete_Row;
1783:
1784: END FA_BOOKS_SUMMARY_PKG;

Line 1784: END FA_BOOKS_SUMMARY_PKG;

1780: CALLED_FN => 'fa_books_summary_pkg.delete_row',
1781: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
1782: END Delete_Row;
1783:
1784: END FA_BOOKS_SUMMARY_PKG;