DBA Data[Home] [Help]

APPS.FA_CAPITALIZE_CIP_PKG1 dependencies on FA_METHODS

Line 18: FROM FA_METHODS

14: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
15: )IS
16: CURSOR RATE_DEF IS
17: SELECT DISTINCT RATE_SOURCE_RULE
18: FROM FA_METHODS
19: WHERE METHOD_CODE = h_deprn_method;
20:
21: h_rate_source_rule varchar2(10);
22:

Line 279: from fa_methods

275: rate_source_rule,
276: deprn_basis_rule,
277: stl_method_flag,
278: exclude_salvage_value_flag
279: from fa_methods
280: where method_code = p_deprn_method
281: and nvl(life_in_months,0) = p_lim;
282:
283: CURSOR CHECK_METHOD_EXISTS IS

Line 285: from fa_methods

281: and nvl(life_in_months,0) = p_lim;
282:
283: CURSOR CHECK_METHOD_EXISTS IS
284: select method_code, life_in_months
285: from fa_methods
286: where method_code = h_deprn_method
287: and nvl(life_in_months,0) = h_lim;
288:
289: -- bug 1147151

Line 292: from fa_methods

288:
289: -- bug 1147151
290: CURSOR methodname IS
291: select name
292: from fa_methods
293: where method_code = h_deprn_method
294: order by created_by desc;
295:
296: CURSOR C_FORMULA (p_method_id number) IS

Line 310: h_methodname fa_methods.name%type;

306: h_deprn_basis_rule varchar2(4);
307: h_rowid rowid;
308: h_dummy1 varchar2(12);
309: h_dummy2 number(4);
310: h_methodname fa_methods.name%type;
311:
312: h_method_id_old number;
313: h_stl_method_flag varchar2(3);
314: h_exclude_sal_flag varchar2(3);

Line 341: select FA_METHODS_S.NEXTVAL

337: end if;
338:
339: else /* if not 'TABLE' */
340:
341: select FA_METHODS_S.NEXTVAL
342: into h_method_id
343: from sys.dual;
344:
345: -- need to derive more values to distinguish between

Line 376: FA_METHODS_PKG.Insert_Row(

372: else
373: CLOSE MD_DEF;
374: end if;
375:
376: FA_METHODS_PKG.Insert_Row(
377: X_Rowid => h_rowid,
378: X_Method_Id => h_method_id,
379: X_Method_Code => h_deprn_method,
380: X_Life_In_Months => h_lim,