eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_BOOK_CONTROLS_PKG dependencies on FA_BOOK_CONTROLS

Line 1: PACKAGE BODY FA_BOOK_CONTROLS_PKG as

1: PACKAGE BODY FA_BOOK_CONTROLS_PKG as
2: /* $Header: faxibcb.pls 120.9.12020000.4 2013/03/08 05:03:25 rmandali ship $ */
3:
4:
5: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,

Line 161: CURSOR C_bc IS SELECT rowid FROM fa_book_controls

157: X_Return_Status OUT NOCOPY BOOLEAN,
158: X_Calling_Fn VARCHAR2
159: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) AS
160:
161: CURSOR C_bc IS SELECT rowid FROM fa_book_controls
162: WHERE book_type_code = X_Book_Type_Code;
163:
164: CURSOR C_bc_mc IS SELECT rowid FROM fa_mc_book_controls
165: WHERE book_type_code = X_Book_Type_Code

Line 173: insert into fa_book_controls (

169:
170:
171: if (nvl(X_mrc_sob_type_code, 'P') = 'P') then
172:
173: insert into fa_book_controls (
174: book_type_code,
175: book_type_name,
176: set_of_books_id,
177: initial_date,

Line 485: insert into fa_book_controls_history (

481: Raise NO_DATA_FOUND;
482: end if;
483: CLOSE C_bc;
484:
485: insert into fa_book_controls_history (
486: book_type_code,
487: date_active,
488: date_inactive,
489: book_type_name,

Line 800: calling_fn => 'fa_book_controls_pkg.insert_row', p_log_level_rec => p_log_level_rec);

796:
797: EXCEPTION
798: WHEN OTHERS THEN
799: fa_srvr_msg.add_sql_error(
800: calling_fn => 'fa_book_controls_pkg.insert_row', p_log_level_rec => p_log_level_rec);
801: X_Return_Status := FALSE;
802: raise;
803: END Insert_Row;
804:

Line 975: UPDATE fa_book_controls

971: BEGIN
972:
973: if (nvl(X_mrc_sob_type_code, 'P') = 'P') then
974:
975: UPDATE fa_book_controls
976: SET
977: book_type_name = X_Book_Type_Name,
978: set_of_books_id = X_Set_Of_Books_Id,
979: initial_date = X_Initial_Date,

Line 1134: UPDATE fa_book_controls_history

1130: end if;
1131:
1132: select sysdate into l_sysdate from dual;
1133:
1134: UPDATE fa_book_controls_history
1135: SET date_inactive = l_sysdate
1136: WHERE book_type_code = X_Book_Type_Code
1137: AND date_inactive is null;
1138:

Line 1139: insert into fa_book_controls_history (

1135: SET date_inactive = l_sysdate
1136: WHERE book_type_code = X_Book_Type_Code
1137: AND date_inactive is null;
1138:
1139: insert into fa_book_controls_history (
1140: book_type_code,
1141: date_active,
1142: date_inactive,
1143: book_type_name,

Line 1453: calling_fn => 'FA_BOOK_CONTROLS_PKG.Update_Row', p_log_level_rec => p_log_level_rec);

1449:
1450: EXCEPTION
1451: when others then
1452: fa_srvr_msg.add_sql_error(
1453: calling_fn => 'FA_BOOK_CONTROLS_PKG.Update_Row', p_log_level_rec => p_log_level_rec);
1454:
1455: X_Return_Status := FALSE;
1456:
1457: raise;

Line 1485: from fa_book_controls

1481: where rowid = X_Rowid;
1482: else
1483: select book_type_code
1484: into l_book_type_code
1485: from fa_book_controls
1486: where rowid = X_Rowid;
1487: end if;
1488: else
1489: raise del_error;

Line 1533: DELETE FROM fa_book_controls

1529: else
1530: DELETE FROM fa_deprn_periods
1531: WHERE book_type_code = l_book_type_code;
1532:
1533: DELETE FROM fa_book_controls
1534: WHERE book_type_code = l_book_type_code;
1535:
1536: DELETE FROM fa_book_controls_history
1537: WHERE book_type_code = l_book_type_code;

Line 1536: DELETE FROM fa_book_controls_history

1532:
1533: DELETE FROM fa_book_controls
1534: WHERE book_type_code = l_book_type_code;
1535:
1536: DELETE FROM fa_book_controls_history
1537: WHERE book_type_code = l_book_type_code;
1538:
1539: end if;
1540:

Line 1544: calling_fn => 'fa_book_controls_pkg.delete_row',

1540:
1541: exception
1542: when validation_error then
1543: fa_srvr_msg.add_message (
1544: calling_fn => 'fa_book_controls_pkg.delete_row',
1545: name => 'FA_SHARED_CANT_DEL_USED', p_log_level_rec => p_log_level_rec);
1546: FA_STANDARD_PKG.RAISE_ERROR(
1547: CALLED_FN => 'fa_book_controls_pkg.delete_row',
1548: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);

Line 1547: CALLED_FN => 'fa_book_controls_pkg.delete_row',

1543: fa_srvr_msg.add_message (
1544: calling_fn => 'fa_book_controls_pkg.delete_row',
1545: name => 'FA_SHARED_CANT_DEL_USED', p_log_level_rec => p_log_level_rec);
1546: FA_STANDARD_PKG.RAISE_ERROR(
1547: CALLED_FN => 'fa_book_controls_pkg.delete_row',
1548: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
1549: when del_error then
1550: FA_STANDARD_PKG.RAISE_ERROR(
1551: CALLED_FN => 'fa_book_controls_pkg.delete_row',

Line 1551: CALLED_FN => 'fa_book_controls_pkg.delete_row',

1547: CALLED_FN => 'fa_book_controls_pkg.delete_row',
1548: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
1549: when del_error then
1550: FA_STANDARD_PKG.RAISE_ERROR(
1551: CALLED_FN => 'fa_book_controls_pkg.delete_row',
1552: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
1553: when others then
1554: FA_STANDARD_PKG.RAISE_ERROR(
1555: CALLED_FN => 'fa_book_controls_pkg.delete_row',

Line 1555: CALLED_FN => 'fa_book_controls_pkg.delete_row',

1551: CALLED_FN => 'fa_book_controls_pkg.delete_row',
1552: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
1553: when others then
1554: FA_STANDARD_PKG.RAISE_ERROR(
1555: CALLED_FN => 'fa_book_controls_pkg.delete_row',
1556: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
1557: END Delete_Row;
1558:
1559: END FA_BOOK_CONTROLS_PKG;

Line 1559: END FA_BOOK_CONTROLS_PKG;

1555: CALLED_FN => 'fa_book_controls_pkg.delete_row',
1556: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
1557: END Delete_Row;
1558:
1559: END FA_BOOK_CONTROLS_PKG;