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.3 2005/07/25 10:01:32 yyoon 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 default null) 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 default null) 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'

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

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

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

Line 113: FROM fa_distribution_history

109: X_Calling_Fn VARCHAR2,
110: p_log_level_rec in fa_api_types.log_level_rec_type default null) IS
111: CURSOR C IS
112: SELECT *
113: FROM fa_distribution_history
114: WHERE rowid = X_Rowid
115: FOR UPDATE of Distribution_Id NOWAIT;
116: Recinfo C%ROWTYPE;
117:

Line 184: UPDATE fa_distribution_history

180: X_Calling_Fn VARCHAR2,
181: p_log_level_rec in fa_api_types.log_level_rec_type default null) 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'

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

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

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

Line 249: DELETE FROM fa_distribution_history

245: X_Calling_Fn VARCHAR2,
246: p_log_level_rec in fa_api_types.log_level_rec_type default null) IS
247: BEGIN
248: if X_Rowid is not null then
249: DELETE FROM fa_distribution_history
250: WHERE rowid = X_Rowid;
251: elsif X_Transaction_Header_Id is not null then
252: DELETE FROM fa_distribution_history
253: WHERE transaction_header_id_in = X_Transaction_Header_Id

Line 252: DELETE FROM fa_distribution_history

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

Line 257: DELETE FROM fa_distribution_history

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

Line 270: 'fa_distribution_history_pkg.delete_row'

266:
267: exception
268: when others then
269: fa_srvr_msg.add_sql_error(calling_fn=>
270: 'fa_distribution_history_pkg.delete_row'
271: ,p_log_level_rec => p_log_level_rec);
272: raise;
273: /* FA_STANDARD_PKG.RAISE_ERROR(
274: CALLED_FN => 'fa_distribution_history_pkg.delete_row',

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

270: 'fa_distribution_history_pkg.delete_row'
271: ,p_log_level_rec => p_log_level_rec);
272: raise;
273: /* FA_STANDARD_PKG.RAISE_ERROR(
274: CALLED_FN => 'fa_distribution_history_pkg.delete_row',
275: CALLING_FN => X_Calling_Fn
276: ,p_log_level_rec => p_log_level_rec); */
277: END Delete_Row;
278:

Line 299: UPDATE fa_distribution_history

295: End If;
296:
297:
298: if X_Transaction_Header_Id_Out is not null then
299: UPDATE fa_distribution_history
300: SET transaction_units = null,
301: transaction_header_id_out = null,
302: date_ineffective = null,
303: retirement_id = null

Line 308: UPDATE fa_distribution_history

304: WHERE transaction_header_id_out = X_Transaction_Header_Id_Out
305: and asset_id = X_Asset_Id
306: and book_type_code = X_Book_Type_Code;
307: else
308: UPDATE fa_distribution_history
309: set transaction_units = null,
310: retirement_id = null
311: WHERE asset_id = X_Asset_Id
312: and book_type_code = X_Book_Type_Code

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

319:
320: exception
321: when others then
322: FA_STANDARD_PKG.RAISE_ERROR(
323: CALLED_FN => 'fa_distribution_history_pkg.reactivate_row',
324: CALLING_FN => X_Calling_Fn
325: ,p_log_level_rec => p_log_level_rec);
326: END Reactivate_Row;
327:

Line 328: END FA_DISTRIBUTION_HISTORY_PKG;

324: CALLING_FN => X_Calling_Fn
325: ,p_log_level_rec => p_log_level_rec);
326: END Reactivate_Row;
327:
328: END FA_DISTRIBUTION_HISTORY_PKG;