DBA Data[Home] [Help]

APPS.FA_INVOICE_TRANSACTIONS_PKG dependencies on FA_API_TYPES

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

6: X_Book_Type_Code VARCHAR2,
7: X_Transaction_Type VARCHAR2,
8: X_Date_Effective DATE,
9: X_Calling_Fn VARCHAR2,
10: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
11: CURSOR C IS SELECT rowid FROM fa_invoice_transactions
12: WHERE invoice_transaction_id = X_Invoice_Transaction_Id;
13: CURSOR C2 IS SELECT fa_invoice_transactions_s.nextval FROM sys.dual;
14: BEGIN

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

59: X_Book_Type_Code VARCHAR2,
60: X_Transaction_Type VARCHAR2,
61: X_Date_Effective DATE,
62: X_Calling_Fn VARCHAR2,
63: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
64: CURSOR C IS
65: SELECT *
66: FROM fa_invoice_transactions
67: WHERE rowid = X_Rowid

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

96: X_Book_Type_Code VARCHAR2,
97: X_Transaction_Type VARCHAR2,
98: X_Date_Effective DATE,
99: X_Calling_Fn VARCHAR2,
100: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
101: BEGIN
102: UPDATE fa_invoice_transactions
103: SET
104: invoice_transaction_id = X_Invoice_Transaction_Id,

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

119: END Update_Row;
120:
121: PROCEDURE Delete_Row(X_Rowid VARCHAR2,
122: X_Calling_Fn VARCHAR2,
123: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
124: BEGIN
125: DELETE FROM fa_invoice_transactions
126: WHERE rowid = X_Rowid;
127: