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.6 2009/03/27 09:00:26 bridgway 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) 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, p_log_level_rec => p_log_level_rec);
154: X_Return_Status := FALSE;
155: else
156: FA_SRVR_MSG.Add_SQL_Error(

Line 157: CALLING_FN => 'FA_TRANSACTION_HEADERS_PKG.Insert_Row', p_log_level_rec => p_log_level_rec);

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

Line 240: FROM fa_transaction_headers

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

Line 400: UPDATE fa_transaction_headers

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

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

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

Line 575: Update fa_transaction_headers

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

Line 584: CALLING_FN => 'FA_TRANSACTION_HEADERS_PKG.Update_Trx_Type', p_log_level_rec => p_log_level_rec);

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

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

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

Line 598: DELETE FROM fa_transaction_headers

594: X_Transaction_Type_Code VARCHAR2 DEFAULT NULL,
595: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
596: BEGIN
597: if X_Rowid is not null then
598: DELETE FROM fa_transaction_headers
599: WHERE rowid = X_Rowid;
600: elsif X_Transaction_Header_Id is not null then
601: DELETE FROM fa_transaction_headers
602: WHERE transaction_header_id = X_Transaction_Header_Id;

Line 601: DELETE FROM fa_transaction_headers

597: if X_Rowid is not null then
598: DELETE FROM fa_transaction_headers
599: WHERE rowid = X_Rowid;
600: elsif X_Transaction_Header_Id is not null then
601: DELETE FROM fa_transaction_headers
602: WHERE transaction_header_id = X_Transaction_Header_Id;
603: elsif X_Asset_Id is not null then
604: DELETE FROM fa_transaction_headers
605: WHERE asset_id = X_Asset_Id

Line 604: DELETE FROM fa_transaction_headers

600: elsif X_Transaction_Header_Id is not null then
601: DELETE FROM fa_transaction_headers
602: WHERE transaction_header_id = X_Transaction_Header_Id;
603: elsif X_Asset_Id is not null then
604: DELETE FROM fa_transaction_headers
605: WHERE asset_id = X_Asset_Id
606: and transaction_type_code =
607: nvl(X_Transaction_Type_Code, transaction_type_code);
608: else

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

615:
616: exception
617: when others then
618: FA_STANDARD_PKG.RAISE_ERROR(
619: CALLED_FN => 'fa_transaction_headers_pkg.delete_row',
620: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
621: END Delete_Row;
622:
623:

Line 624: END FA_TRANSACTION_HEADERS_PKG;

620: CALLING_FN => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
621: END Delete_Row;
622:
623:
624: END FA_TRANSACTION_HEADERS_PKG;