DBA Data[Home] [Help]

APPS.FA_DISTRIBUTION_HISTORY_PKG dependencies on FA_API_TYPES

Line 23: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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) 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

Line 108: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

104: X_Transaction_Header_Id_Out NUMBER DEFAULT NULL,
105: X_Transaction_Units NUMBER DEFAULT NULL,
106: X_Retirement_Id NUMBER DEFAULT NULL,
107: X_Calling_Fn VARCHAR2
108: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
109: CURSOR C IS
110: SELECT *
111: FROM fa_distribution_history
112: WHERE rowid = X_Rowid

Line 181: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

177: X_Retirement_Id NUMBER,
178: X_Last_Update_Login NUMBER,
179: X_Calling_Fn VARCHAR2
180:
181: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
182: BEGIN
183: if X_Rowid is not null then
184: UPDATE fa_distribution_history
185: SET

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

239: PROCEDURE Delete_Row(X_Rowid VARCHAR2 DEFAULT NULL,
240: X_Asset_Id NUMBER DEFAULT NULL,
241: X_Book_Type_Code VARCHAR2 DEFAULT NULL,
242: X_Transaction_Header_Id NUMBER DEFAULT NULL,
243: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
244: BEGIN
245: if X_Rowid is not null then
246: DELETE FROM fa_distribution_history
247: WHERE rowid = X_Rowid;

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

273:
274: PROCEDURE Reactivate_Row(X_Transaction_Header_Id_Out NUMBER DEFAULT NULL,
275: X_Asset_Id NUMBER,
276: X_Book_Type_Code VARCHAR2,
277: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
278: X_Book_Class Varchar2(20);
279: BEGIN
280: -- The update to the Distribution History needs to be done only
281: -- when the Book_Class is Corporate.