19: X_Transaction_Units NUMBER DEFAULT NULL,
20: X_Retirement_Id NUMBER DEFAULT NULL,
21: X_Last_Update_Login NUMBER DEFAULT NULL,
22: X_Calling_Fn VARCHAR2,
23: p_log_level_rec in fa_api_types.log_level_rec_type default null) IS
24: CURSOR C IS SELECT rowid FROM fa_distribution_history
25: WHERE distribution_id = X_Distribution_Id;
26: CURSOR C2 IS SELECT fa_distribution_history_s.nextval FROM sys.dual;
27: BEGIN
106: X_Transaction_Header_Id_Out NUMBER DEFAULT NULL,
107: X_Transaction_Units NUMBER DEFAULT NULL,
108: X_Retirement_Id NUMBER DEFAULT NULL,
109: X_Calling_Fn VARCHAR2,
110: p_log_level_rec in fa_api_types.log_level_rec_type default null) IS
111: CURSOR C IS
112: SELECT *
113: FROM fa_distribution_history
114: WHERE rowid = X_Rowid
177: X_Transaction_Units NUMBER,
178: X_Retirement_Id NUMBER,
179: X_Last_Update_Login NUMBER,
180: X_Calling_Fn VARCHAR2,
181: p_log_level_rec in fa_api_types.log_level_rec_type default null) IS
182: BEGIN
183: if X_Rowid is not null then
184: UPDATE fa_distribution_history
185: SET
242: X_Asset_Id NUMBER DEFAULT NULL,
243: X_Book_Type_Code VARCHAR2 DEFAULT NULL,
244: X_Transaction_Header_Id NUMBER DEFAULT NULL,
245: X_Calling_Fn VARCHAR2,
246: p_log_level_rec in fa_api_types.log_level_rec_type default null) IS
247: BEGIN
248: if X_Rowid is not null then
249: DELETE FROM fa_distribution_history
250: WHERE rowid = X_Rowid;
279: PROCEDURE Reactivate_Row(X_Transaction_Header_Id_Out NUMBER DEFAULT NULL,
280: X_Asset_Id NUMBER,
281: X_Book_Type_Code VARCHAR2,
282: X_Calling_Fn VARCHAR2,
283: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
284: X_Book_Class Varchar2(20);
285: BEGIN
286: -- The update to the Distribution History needs to be done only
287: -- when the Book_Class is Corporate.