APPS.FA_TRX_REFERENCES_PKG dependencies on FA_TRX_REFERENCES

Line 1: PACKAGE BODY FA_TRX_REFERENCES_PKG as

1: PACKAGE BODY FA_TRX_REFERENCES_PKG as
2: /* $Header: faxitrb.pls 120.4 2005/07/25 10:00:33 yyoon noship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Trx_Reference_Id IN OUT NOCOPY NUMBER,

Line 34: CURSOR C IS SELECT rowid FROM fa_trx_references

30: X_Return_Status OUT NOCOPY BOOLEAN,
31: X_Calling_Fn VARCHAR2,
32: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
33:
34: CURSOR C IS SELECT rowid FROM fa_trx_references
35: WHERE trx_reference_id = X_Trx_Reference_Id;
36:
37: CURSOR C2 IS SELECT fa_trx_references_s.nextval FROM dual;
38:

Line 37: CURSOR C2 IS SELECT fa_trx_references_s.nextval FROM dual;

33:
34: CURSOR C IS SELECT rowid FROM fa_trx_references
35: WHERE trx_reference_id = X_Trx_Reference_Id;
36:
37: CURSOR C2 IS SELECT fa_trx_references_s.nextval FROM dual;
38:
39: BEGIN
40: if (X_Trx_Reference_Id is NULL) then
41: OPEN C2;

Line 46: INSERT INTO fa_trx_references(

42: FETCH C2 INTO X_Trx_Reference_Id;
43: CLOSE C2;
44: end if;
45:
46: INSERT INTO fa_trx_references(
47: trx_reference_id,
48: book_type_code,
49: src_asset_id,
50: src_transaction_header_id,

Line 113: CALLING_FN => 'FA_TRX_REFERENCES_PKG.Insert_Row'

109:
110: exception
111: when others then
112: FA_SRVR_MSG.Add_SQL_Error(
113: CALLING_FN => 'FA_TRX_REFERENCES_PKG.Insert_Row'
114: ,p_log_level_rec => p_log_level_rec);
115: X_Return_Status := FALSE;
116: raise;
117:

Line 132: END FA_TRX_REFERENCES_PKG;

128:
129: */
130:
131:
132: END FA_TRX_REFERENCES_PKG;