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_TRANSACTION_HEADERS_PKG dependencies on FA_TRANSACTION_HEADERS

Line 1: PACKAGE BODY FA_TRANSACTION_HEADERS_PKG as

1: PACKAGE BODY FA_TRANSACTION_HEADERS_PKG as
2: /* $Header: faxithb.pls 120.5 2005/07/25 10:00:39 yyoon ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Transaction_Header_Id IN OUT NOCOPY NUMBER,

Line 46: CURSOR C IS SELECT rowid FROM fa_transaction_headers

42: X_Return_Status OUT NOCOPY BOOLEAN,
43: X_Calling_Fn VARCHAR2,
44: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
45:
46: CURSOR C IS SELECT rowid FROM fa_transaction_headers
47: WHERE transaction_header_id = X_Transaction_Header_Id;
48:
49: CURSOR C2 IS SELECT fa_transaction_headers_s.nextval FROM dual;
50:

Line 49: CURSOR C2 IS SELECT fa_transaction_headers_s.nextval FROM dual;

45:
46: CURSOR C IS SELECT rowid FROM fa_transaction_headers
47: WHERE transaction_header_id = X_Transaction_Header_Id;
48:
49: CURSOR C2 IS SELECT fa_transaction_headers_s.nextval FROM dual;
50:
51: BEGIN
52: if (X_Transaction_Header_Id is NULL) then
53: OPEN C2;

Line 58: INSERT INTO fa_transaction_headers(

54: FETCH C2 INTO X_Transaction_Header_Id;
55: CLOSE C2;
56: end if;
57:
58: INSERT INTO fa_transaction_headers(
59: transaction_header_id,
60: book_type_code,
61: asset_id,
62: transaction_type_code,

Line 152: CALLED_FN => 'fa_transaction_headers_pkg.insert_row',

148: if (X_Calling_Fn = 'fa_unp_dep_pkg.on_insert') then
149: -- Unplanned depreciation is called from form, not from
150: -- transaction engine.
151: FA_STANDARD_PKG.RAISE_ERROR(
152: CALLED_FN => 'fa_transaction_headers_pkg.insert_row',
153: CALLING_FN => X_Calling_Fn
154: ,p_log_level_rec => p_log_level_rec);
155: X_Return_Status := FALSE;
156: else

Line 158: CALLING_FN => 'FA_TRANSACTION_HEADERS_PKG.Insert_Row'

154: ,p_log_level_rec => p_log_level_rec);
155: X_Return_Status := FALSE;
156: else
157: FA_SRVR_MSG.Add_SQL_Error(
158: CALLING_FN => 'FA_TRANSACTION_HEADERS_PKG.Insert_Row'
159: ,p_log_level_rec => p_log_level_rec);
160: X_Return_Status := FALSE;
161: raise; -- BUG# 2020254
162: end if;

Line 242: FROM fa_transaction_headers

238: mass_transaction_id,
239: member_transaction_header_id,
240: trx_reference_id,
241: event_id
242: FROM fa_transaction_headers
243: WHERE rowid = X_Rowid
244: FOR UPDATE of Transaction_Header_Id NOWAIT;
245: Recinfo C%ROWTYPE;
246:

Line 401: UPDATE fa_transaction_headers

397: X_Event_id NUMBER DEFAULT NULL,
398: X_Calling_Fn VARCHAR2,
399: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
400: BEGIN
401: UPDATE fa_transaction_headers
402: SET
403: transaction_header_id
404: = decode(X_Transaction_Header_Id,
405: NULL, transaction_header_id,

Line 564: CALLED_FN => 'fa_transaction_headers_pkg.update_row',

560:
561: exception
562: when others then
563: FA_STANDARD_PKG.RAISE_ERROR(
564: CALLED_FN => 'fa_transaction_headers_pkg.update_row',
565: CALLING_FN => X_Calling_Fn
566: ,p_log_level_rec => p_log_level_rec);
567: END Update_Row;
568:

Line 578: Update fa_transaction_headers

574: X_Return_Status OUT NOCOPY BOOLEAN,
575: X_Calling_Fn VARCHAR2,
576: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
577: BEGIN
578: Update fa_transaction_headers
579: set transaction_type_code = X_New_Transaction_Type
580: where asset_id = X_Asset_Id
581: and book_type_code = X_Book_Type_Code
582: and transaction_type_code = X_Transaction_Type_Code;

Line 587: CALLING_FN => 'FA_TRANSACTION_HEADERS_PKG.Update_Trx_Type'

583: X_Return_Status := TRUE;
584: exception
585: when others then
586: FA_SRVR_MSG.Add_SQL_Error(
587: CALLING_FN => 'FA_TRANSACTION_HEADERS_PKG.Update_Trx_Type'
588: ,p_log_level_rec => p_log_level_rec);
589: -- FA_STANDARD_PKG.RAISE_ERROR(
590: -- CALLED_FN => 'fa_transaction_headers_pkg.update_trx_type',
591: -- CALLING_FN => X_Calling_Fn);

Line 590: -- CALLED_FN => 'fa_transaction_headers_pkg.update_trx_type',

586: FA_SRVR_MSG.Add_SQL_Error(
587: CALLING_FN => 'FA_TRANSACTION_HEADERS_PKG.Update_Trx_Type'
588: ,p_log_level_rec => p_log_level_rec);
589: -- FA_STANDARD_PKG.RAISE_ERROR(
590: -- CALLED_FN => 'fa_transaction_headers_pkg.update_trx_type',
591: -- CALLING_FN => X_Calling_Fn);
592: X_Return_Status := FALSE;
593: END Update_Trx_Type;
594: --

Line 603: DELETE FROM fa_transaction_headers

599: X_Calling_Fn VARCHAR2,
600: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
601: BEGIN
602: if X_Rowid is not null then
603: DELETE FROM fa_transaction_headers
604: WHERE rowid = X_Rowid;
605: elsif X_Transaction_Header_Id is not null then
606: DELETE FROM fa_transaction_headers
607: WHERE transaction_header_id = X_Transaction_Header_Id;

Line 606: DELETE FROM fa_transaction_headers

602: if X_Rowid is not null then
603: DELETE FROM fa_transaction_headers
604: WHERE rowid = X_Rowid;
605: elsif X_Transaction_Header_Id is not null then
606: DELETE FROM fa_transaction_headers
607: WHERE transaction_header_id = X_Transaction_Header_Id;
608: elsif X_Asset_Id is not null then
609: DELETE FROM fa_transaction_headers
610: WHERE asset_id = X_Asset_Id

Line 609: DELETE FROM fa_transaction_headers

605: elsif X_Transaction_Header_Id is not null then
606: DELETE FROM fa_transaction_headers
607: WHERE transaction_header_id = X_Transaction_Header_Id;
608: elsif X_Asset_Id is not null then
609: DELETE FROM fa_transaction_headers
610: WHERE asset_id = X_Asset_Id
611: and transaction_type_code =
612: nvl(X_Transaction_Type_Code, transaction_type_code);
613: else

Line 624: CALLED_FN => 'fa_transaction_headers_pkg.delete_row',

620:
621: exception
622: when others then
623: FA_STANDARD_PKG.RAISE_ERROR(
624: CALLED_FN => 'fa_transaction_headers_pkg.delete_row',
625: CALLING_FN => X_Calling_Fn
626: ,p_log_level_rec => p_log_level_rec);
627: END Delete_Row;
628:

Line 630: END FA_TRANSACTION_HEADERS_PKG;

626: ,p_log_level_rec => p_log_level_rec);
627: END Delete_Row;
628:
629:
630: END FA_TRANSACTION_HEADERS_PKG;