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) 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) 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 61: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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

Line 99: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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

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

116: raise;
117: END Update_Row;
118:
119: PROCEDURE Delete_Row(X_Rowid VARCHAR2,
120: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
121: BEGIN
122: DELETE FROM fa_invoice_transactions
123: WHERE rowid = X_Rowid;
124: