[Home] [Help]
16: X_Basic_Rate_Pct OUT NOCOPY NUMBER,
17: X_Adjusted_Rate_Pct OUT NOCOPY NUMBER,
18: X_Deprn_Limit_Pct OUT NOCOPY NUMBER,
19: X_Salvage_Val_Pct OUT NOCOPY NUMBER
20: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
21: BEGIN
22: IF X_Life_In_Months IS NOT NULL THEN
23: X_Life := lpad(to_char(trunc(X_Life_In_Months/12)), 3)||'.'||
24: substr(to_char(mod(X_Life_In_Months, 12), '00'), 2, 2);
67: | PROCEDURE Load_Conversion_Table |
68: +=====================================================================================*/
69:
70: PROCEDURE Load_Conversion_Table (p_log_level_rec IN
71: FA_API_TYPES.log_level_rec_type) IS
72: load_exc EXCEPTION;
73: h_life_in_months NUMBER(4);
74: h_basic_rate NUMBER;
75: h_adjusted_rate NUMBER;
133: X_Last_Updated_By IN NUMBER,
134: X_Created_By IN NUMBER,
135: X_Creation_Date IN DATE,
136: X_Last_Update_Login IN NUMBER
137: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
138: -- cursor to fetch the meaning for depreciate flag.
139: CURSOR get_deprn_flag IS
140: SELECT nvl(meaning, X_Asset_Rec.depreciate_flag)
141: FROM fa_lookups
244: X_New_Category OUT NOCOPY VARCHAR2,
245: X_Asset_Key OUT NOCOPY VARCHAR2,
246: X_From_Exp_Acct OUT NOCOPY VARCHAR2,
247: X_To_Exp_Acct OUT NOCOPY VARCHAR2
248: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
249:
250: mr_rec mass_reclass_rec;
251: precis NUMBER;
252:
608: X_Category_Id1 IN NUMBER,
609: X_Category_Id2 IN NUMBER,
610: X_Same_Values OUT NOCOPY VARCHAR2,
611: X_Return_Status OUT NOCOPY BOOLEAN
612: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
613: CURSOR get_cat_flex_struct IS
614: SELECT category_flex_structure
615: FROM FA_SYSTEM_CONTROLS;
616: l_cat_flex_struct NUMBER;