DBA Data[Home] [Help]

APPS.FA_TRANSACTION_HEADERS_PKG dependencies on FA_API_TYPES

Line 44: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

40: X_Trx_Reference_Id NUMBER DEFAULT NULL,
41: X_Event_Id NUMBER DEFAULT NULL,
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:

Line 201: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

197: X_Member_Transaction_Header_Id NUMBER DEFAULT NULL,
198: X_Trx_Reference_Id NUMBER DEFAULT NULL,
199: X_Event_Id NUMBER DEFAULT NULL,
200: X_Calling_Fn VARCHAR2
201: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
202: CURSOR C IS
203: SELECT transaction_header_id,
204: book_type_code,
205: asset_id,

Line 398: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

394: X_Member_Transaction_Header_Id NUMBER DEFAULT NULL,
395: X_Trx_Reference_Id NUMBER DEFAULT NULL,
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

Line 573: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

569: X_Asset_Id NUMBER,
570: X_Transaction_Type_Code VARCHAR2,
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

Line 595: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

591: PROCEDURE Delete_Row(X_Rowid VARCHAR2 DEFAULT NULL,
592: X_Transaction_Header_Id NUMBER DEFAULT NULL,
593: X_Asset_Id NUMBER DEFAULT NULL,
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;