APPS.FA_RETIREMENTS_PKG dependencies on FA_RETIREMENTS

Line 1: PACKAGE BODY FA_RETIREMENTS_PKG as

1: PACKAGE BODY FA_RETIREMENTS_PKG as
2: /* $Header: faxirtb.pls 120.8 2009/04/15 14:51:56 bridgway ship $ */
3: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
4: X_Retirement_Id IN OUT NOCOPY NUMBER,
5: X_Book_Type_Code VARCHAR2,

Line 64: CURSOR C_ret IS SELECT rowid FROM fa_retirements

60: X_mrc_sob_type_code VARCHAR2 DEFAULT 'P',
61: X_set_of_books_id NUMBER ,
62: X_Calling_Fn VARCHAR2
63: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
64: CURSOR C_ret IS SELECT rowid FROM fa_retirements
65: WHERE retirement_id = X_Retirement_Id;
66: CURSOR C_ret_mc IS SELECT rowid FROM fa_mc_retirements
67: WHERE retirement_id = X_Retirement_Id
68: AND set_of_books_id = X_set_of_books_id;

Line 70: CURSOR C2 IS SELECT fa_retirements_s.nextval FROM sys.dual;

66: CURSOR C_ret_mc IS SELECT rowid FROM fa_mc_retirements
67: WHERE retirement_id = X_Retirement_Id
68: AND set_of_books_id = X_set_of_books_id;
69:
70: CURSOR C2 IS SELECT fa_retirements_s.nextval FROM sys.dual;
71:
72: BEGIN
73:
74: if (X_mrc_sob_type_code = 'R') then

Line 210: INSERT INTO fa_retirements(

206: FETCH C2 INTO X_Retirement_Id;
207: CLOSE C2;
208: end if;
209:
210: INSERT INTO fa_retirements(
211: retirement_id,
212: book_type_code,
213: asset_id,
214: transaction_header_id_in,

Line 339: CALLING_FN => 'FA_RETIREMENTS_PKG.insert_row', p_log_level_rec => p_log_level_rec);

335:
336: EXCEPTION
337: WHEN Others THEN
338: fa_srvr_msg.add_sql_error(
339: CALLING_FN => 'FA_RETIREMENTS_PKG.insert_row', p_log_level_rec => p_log_level_rec);
340: raise;
341: END Insert_Row;
342:
343:

Line 455: FROM fa_retirements

451: reserve_retired,
452: eofy_reserve,
453: reduction_rate,
454: recapture_amount
455: FROM fa_retirements
456: WHERE rowid = X_Rowid
457: FOR UPDATE of Retirement_Id NOWAIT;
458: Recinfo C%ROWTYPE;
459: BEGIN

Line 925: from fa_retirements

921:
922: if (X_Rowid is null) then
923: select rowid
924: into l_rowid
925: from fa_retirements
926: where retirement_id = X_Retirement_Id;
927: else
928: l_rowid := X_Rowid;
929: end if;

Line 931: UPDATE fa_retirements

927: else
928: l_rowid := X_Rowid;
929: end if;
930:
931: UPDATE fa_retirements
932: SET
933: retirement_id = decode(X_Retirement_Id,
934: FND_API.G_MISS_NUM, NULL,
935: NULL, retirement_id,

Line 1159: CALLING_FN => 'FA_RETIREMENTS_PKG.UPDATE_ROW', p_log_level_rec => p_log_level_rec);

1155: end if;
1156: EXCEPTION
1157: WHEN Others THEN
1158: fa_srvr_msg.add_sql_error(
1159: CALLING_FN => 'FA_RETIREMENTS_PKG.UPDATE_ROW', p_log_level_rec => p_log_level_rec);
1160: raise;
1161: END Update_Row;
1162:
1163: --

Line 1176: DELETE FROM fa_retirements

1172: if (X_mrc_sob_type_code = 'R') then
1173: DELETE FROM fa_mc_retirements
1174: WHERE rowid = X_Rowid;
1175: else
1176: DELETE FROM fa_retirements
1177: WHERE rowid = X_Rowid;
1178: end if;
1179:
1180: if (SQL%NOTFOUND) then

Line 1186: CALLING_FN => 'FA_RETIREMENTS_PKG.DELETE_ROW', p_log_level_rec => p_log_level_rec);

1182: end if;
1183: EXCEPTION
1184: WHEN Others THEN
1185: fa_srvr_msg.add_sql_error(
1186: CALLING_FN => 'FA_RETIREMENTS_PKG.DELETE_ROW', p_log_level_rec => p_log_level_rec);
1187: raise;
1188: END Delete_Row;
1189: --
1190: END FA_RETIREMENTS_PKG;

Line 1190: END FA_RETIREMENTS_PKG;

1186: CALLING_FN => 'FA_RETIREMENTS_PKG.DELETE_ROW', p_log_level_rec => p_log_level_rec);
1187: raise;
1188: END Delete_Row;
1189: --
1190: END FA_RETIREMENTS_PKG;