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_DISTRIBUTION_HISTORY_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 1: PACKAGE BODY FA_DISTRIBUTION_HISTORY_PKG as

1: PACKAGE BODY FA_DISTRIBUTION_HISTORY_PKG as
2: /* $Header: faxidhb.pls 120.4 2009/03/27 02:36:25 bridgway ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5:

Line 24: CURSOR C IS SELECT rowid FROM fa_distribution_history

20: X_Retirement_Id NUMBER DEFAULT NULL,
21: X_Last_Update_Login NUMBER DEFAULT NULL,
22: X_Calling_Fn VARCHAR2
23: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
24: CURSOR C IS SELECT rowid FROM fa_distribution_history
25: WHERE distribution_id = X_Distribution_Id;
26: CURSOR C2 IS SELECT fa_distribution_history_s.nextval FROM sys.dual;
27: BEGIN
28: if (X_Distribution_Id is NULL) then

Line 26: CURSOR C2 IS SELECT fa_distribution_history_s.nextval FROM sys.dual;

22: X_Calling_Fn VARCHAR2
23: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
24: CURSOR C IS SELECT rowid FROM fa_distribution_history
25: WHERE distribution_id = X_Distribution_Id;
26: CURSOR C2 IS SELECT fa_distribution_history_s.nextval FROM sys.dual;
27: BEGIN
28: if (X_Distribution_Id is NULL) then
29: OPEN C2;
30: FETCH C2 INTO X_Distribution_Id;

Line 34: INSERT INTO fa_distribution_history(

30: FETCH C2 INTO X_Distribution_Id;
31: CLOSE C2;
32: end if;
33:
34: INSERT INTO fa_distribution_history(
35:
36: distribution_id,
37: book_type_code,
38: asset_id,

Line 84: 'fa_distribution_history_pkg.insert_row', p_log_level_rec => p_log_level_rec);

80:
81: exception
82: when others then
83: fa_srvr_msg.add_sql_error(calling_fn=>
84: 'fa_distribution_history_pkg.insert_row', p_log_level_rec => p_log_level_rec);
85: raise;
86: /* FA_STANDARD_PKG.RAISE_ERROR(
87: CALLED_FN => 'fa_distribution_history_pkg.insert_row',
88: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec); */

Line 87: CALLED_FN => 'fa_distribution_history_pkg.insert_row',

83: fa_srvr_msg.add_sql_error(calling_fn=>
84: 'fa_distribution_history_pkg.insert_row', p_log_level_rec => p_log_level_rec);
85: raise;
86: /* FA_STANDARD_PKG.RAISE_ERROR(
87: CALLED_FN => 'fa_distribution_history_pkg.insert_row',
88: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec); */
89: END Insert_Row;
90:
91:

Line 111: FROM fa_distribution_history

107: X_Calling_Fn VARCHAR2
108: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
109: CURSOR C IS
110: SELECT *
111: FROM fa_distribution_history
112: WHERE rowid = X_Rowid
113: FOR UPDATE of Distribution_Id NOWAIT;
114: Recinfo C%ROWTYPE;
115:

Line 184: UPDATE fa_distribution_history

180:
181: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
182: BEGIN
183: if X_Rowid is not null then
184: UPDATE fa_distribution_history
185: SET
186: distribution_id = X_Distribution_Id,
187: book_type_code = X_Book_Type_Code,
188: asset_id = X_Asset_Id,

Line 203: UPDATE fa_distribution_history

199: retirement_id = X_Retirement_Id,
200: last_update_login = X_Last_Update_Login
201: WHERE rowid = X_Rowid;
202: else
203: UPDATE fa_distribution_history
204: SET
205: distribution_id = X_Distribution_Id,
206: book_type_code = X_Book_Type_Code,
207: asset_id = X_Asset_Id,

Line 231: 'fa_distribution_history_pkg.update_row', p_log_level_rec => p_log_level_rec);

227:
228: exception
229: when others then
230: fa_srvr_msg.add_sql_error(calling_fn=>
231: 'fa_distribution_history_pkg.update_row', p_log_level_rec => p_log_level_rec);
232: raise;
233: /* FA_STANDARD_PKG.RAISE_ERROR(
234: CALLED_FN => 'fa_distribution_history_pkg.update_row',
235: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec); */

Line 234: CALLED_FN => 'fa_distribution_history_pkg.update_row',

230: fa_srvr_msg.add_sql_error(calling_fn=>
231: 'fa_distribution_history_pkg.update_row', p_log_level_rec => p_log_level_rec);
232: raise;
233: /* FA_STANDARD_PKG.RAISE_ERROR(
234: CALLED_FN => 'fa_distribution_history_pkg.update_row',
235: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec); */
236:
237: END Update_Row;
238:

Line 246: DELETE FROM fa_distribution_history

242: X_Transaction_Header_Id NUMBER DEFAULT NULL,
243: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
244: BEGIN
245: if X_Rowid is not null then
246: DELETE FROM fa_distribution_history
247: WHERE rowid = X_Rowid;
248: elsif X_Transaction_Header_Id is not null then
249: DELETE FROM fa_distribution_history
250: WHERE transaction_header_id_in = X_Transaction_Header_Id

Line 249: DELETE FROM fa_distribution_history

245: if X_Rowid is not null then
246: DELETE FROM fa_distribution_history
247: WHERE rowid = X_Rowid;
248: elsif X_Transaction_Header_Id is not null then
249: DELETE FROM fa_distribution_history
250: WHERE transaction_header_id_in = X_Transaction_Header_Id
251: AND asset_id = X_Asset_Id
252: AND book_type_code = X_Book_Type_Code;
253: elsif X_Asset_Id is not null then

Line 254: DELETE FROM fa_distribution_history

250: WHERE transaction_header_id_in = X_Transaction_Header_Id
251: AND asset_id = X_Asset_Id
252: AND book_type_code = X_Book_Type_Code;
253: elsif X_Asset_Id is not null then
254: DELETE FROM fa_distribution_history
255: WHERE asset_id = X_Asset_Id;
256: else
257: -- print some error message
258: null;

Line 267: 'fa_distribution_history_pkg.delete_row', p_log_level_rec => p_log_level_rec);

263:
264: exception
265: when others then
266: fa_srvr_msg.add_sql_error(calling_fn=>
267: 'fa_distribution_history_pkg.delete_row', p_log_level_rec => p_log_level_rec);
268: raise;
269: /* FA_STANDARD_PKG.RAISE_ERROR(
270: CALLED_FN => 'fa_distribution_history_pkg.delete_row',
271: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec); */

Line 270: CALLED_FN => 'fa_distribution_history_pkg.delete_row',

266: fa_srvr_msg.add_sql_error(calling_fn=>
267: 'fa_distribution_history_pkg.delete_row', p_log_level_rec => p_log_level_rec);
268: raise;
269: /* FA_STANDARD_PKG.RAISE_ERROR(
270: CALLED_FN => 'fa_distribution_history_pkg.delete_row',
271: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec); */
272: END Delete_Row;
273:
274: PROCEDURE Reactivate_Row(X_Transaction_Header_Id_Out NUMBER DEFAULT NULL,

Line 293: UPDATE fa_distribution_history

289: End If;
290:
291:
292: if X_Transaction_Header_Id_Out is not null then
293: UPDATE fa_distribution_history
294: SET transaction_units = null,
295: transaction_header_id_out = null,
296: date_ineffective = null,
297: retirement_id = null

Line 302: UPDATE fa_distribution_history

298: WHERE transaction_header_id_out = X_Transaction_Header_Id_Out
299: and asset_id = X_Asset_Id
300: and book_type_code = X_Book_Type_Code;
301: else
302: UPDATE fa_distribution_history
303: set transaction_units = null,
304: retirement_id = null
305: WHERE asset_id = X_Asset_Id
306: and book_type_code = X_Book_Type_Code

Line 317: CALLED_FN => 'fa_distribution_history_pkg.reactivate_row',

313:
314: exception
315: when others then
316: FA_STANDARD_PKG.RAISE_ERROR(
317: CALLED_FN => 'fa_distribution_history_pkg.reactivate_row',
318: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
319: END Reactivate_Row;
320:
321: END FA_DISTRIBUTION_HISTORY_PKG;

Line 321: END FA_DISTRIBUTION_HISTORY_PKG;

317: CALLED_FN => 'fa_distribution_history_pkg.reactivate_row',
318: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
319: END Reactivate_Row;
320:
321: END FA_DISTRIBUTION_HISTORY_PKG;