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 default null) 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 default null) IS
45:
46: CURSOR C IS SELECT rowid FROM fa_transaction_headers
47: WHERE transaction_header_id = X_Transaction_Header_Id;
48:

Line 203: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

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

Line 399: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

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

Line 576: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

572: X_Transaction_Type_Code VARCHAR2,
573: X_New_Transaction_Type VARCHAR2,
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

Line 600: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

596: X_Transaction_Header_Id NUMBER DEFAULT NULL,
597: X_Asset_Id NUMBER DEFAULT NULL,
598: X_Transaction_Type_Code VARCHAR2 DEFAULT NULL,
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;