14: * px_asset_desc_rec.asset_number
15: * pxx_asset_cat_rec_new.category_id
16: * ---------------------------------------------------------------- */
17: FUNCTION do_reclass (
18: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
19: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
20: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
21: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
22: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
15: * pxx_asset_cat_rec_new.category_id
16: * ---------------------------------------------------------------- */
17: FUNCTION do_reclass (
18: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
19: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
20: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
21: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
22: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
23: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
16: * ---------------------------------------------------------------- */
17: FUNCTION do_reclass (
18: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
19: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
20: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
21: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
22: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
23: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
24: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
17: FUNCTION do_reclass (
18: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
19: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
20: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
21: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
22: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
23: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
24: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
25: return boolean IS
18: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
19: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
20: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
21: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
22: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
23: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
24: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
25: return boolean IS
26:
19: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
20: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
21: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
22: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
23: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
24: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
25: return boolean IS
26:
27: l_err_stage varchar2(230);
20: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
21: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
22: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
23: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
24: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
25: return boolean IS
26:
27: l_err_stage varchar2(230);
28: i integer:= 1;
25: return boolean IS
26:
27: l_err_stage varchar2(230);
28: i integer:= 1;
29: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
30: l_trans_rec FA_API_TYPES.trans_rec_type;
31:
32: l_calling_fn varchar2(40) := 'fa_reclass_pvt.do_reclass';
33: call_err EXCEPTION;
26:
27: l_err_stage varchar2(230);
28: i integer:= 1;
29: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
30: l_trans_rec FA_API_TYPES.trans_rec_type;
31:
32: l_calling_fn varchar2(40) := 'fa_reclass_pvt.do_reclass';
33: call_err EXCEPTION;
34:
209: -- ------------------------------------------------------
210:
211: -- ------------------------------------------------------
212: FUNCTION validate_reclass (
213: p_trans_rec IN FA_API_TYPES.trans_rec_type,
214: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
215: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
216: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
217: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
210:
211: -- ------------------------------------------------------
212: FUNCTION validate_reclass (
213: p_trans_rec IN FA_API_TYPES.trans_rec_type,
214: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
215: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
216: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
217: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
218: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is
211: -- ------------------------------------------------------
212: FUNCTION validate_reclass (
213: p_trans_rec IN FA_API_TYPES.trans_rec_type,
214: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
215: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
216: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
217: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
218: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is
219:
212: FUNCTION validate_reclass (
213: p_trans_rec IN FA_API_TYPES.trans_rec_type,
214: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
215: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
216: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
217: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
218: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is
219:
220: l_err_stage varchar2(100);
213: p_trans_rec IN FA_API_TYPES.trans_rec_type,
214: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
215: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
216: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
217: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
218: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is
219:
220: l_err_stage varchar2(100);
221: l_calling_fn varchar2(40) := 'fa_reclass_pvt.validate_reclass';
214: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
215: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
216: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
217: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
218: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean is
219:
220: l_err_stage varchar2(100);
221: l_calling_fn varchar2(40) := 'fa_reclass_pvt.validate_reclass';
222: call_err EXCEPTION;
313:
314: -- ----------------------------------------------------
315:
316: FUNCTION validate_redefault(
317: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
318: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
319: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
320: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
321: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
314: -- ----------------------------------------------------
315:
316: FUNCTION validate_redefault(
317: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
318: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
319: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
320: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
321: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
322: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
315:
316: FUNCTION validate_redefault(
317: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
318: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
319: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
320: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
321: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
322: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
323: p_mass_request_id IN NUMBER DEFAULT null , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
316: FUNCTION validate_redefault(
317: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
318: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
319: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
320: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
321: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
322: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
323: p_mass_request_id IN NUMBER DEFAULT null , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
324:
317: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
318: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
319: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
320: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
321: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
322: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
323: p_mass_request_id IN NUMBER DEFAULT null , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
324:
325:
318: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
319: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
320: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
321: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
322: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
323: p_mass_request_id IN NUMBER DEFAULT null , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
324:
325:
326: BEGIN
319: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
320: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
321: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
322: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
323: p_mass_request_id IN NUMBER DEFAULT null , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
324:
325:
326: BEGIN
327: null;
336: *
337: *
338: * ---------------------------------------------------------------------- */
339: FUNCTION do_redefault(
340: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
341: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
342: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
343: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
344: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
337: *
338: * ---------------------------------------------------------------------- */
339: FUNCTION do_redefault(
340: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
341: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
342: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
343: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
344: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
345: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
338: * ---------------------------------------------------------------------- */
339: FUNCTION do_redefault(
340: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
341: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
342: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
343: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
344: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
345: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
346: p_mass_request_id IN NUMBER DEFAULT null , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
339: FUNCTION do_redefault(
340: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
341: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
342: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
343: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
344: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
345: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
346: p_mass_request_id IN NUMBER DEFAULT null , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
347:
340: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
341: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
342: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
343: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
344: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
345: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
346: p_mass_request_id IN NUMBER DEFAULT null , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
347:
348: CURSOR book_cr( p_asset_id number ) IS
341: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
342: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
343: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
344: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
345: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
346: p_mass_request_id IN NUMBER DEFAULT null , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
347:
348: CURSOR book_cr( p_asset_id number ) IS
349: SELECT TH.book_type_code
342: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
343: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
344: px_asset_cat_rec_old IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
345: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
346: p_mass_request_id IN NUMBER DEFAULT null , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
347:
348: CURSOR book_cr( p_asset_id number ) IS
349: SELECT TH.book_type_code
350: FROM FA_BOOK_CONTROLS BC,
384: l_rate_source_rules VARCHAR2(10);
385: l_deprn_basis_rule VARCHAR2(10);
386: l_prorate_date date;
387:
388: l_trans_rec FA_API_TYPES.trans_rec_type;
389: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
390: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
391: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
392: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
385: l_deprn_basis_rule VARCHAR2(10);
386: l_prorate_date date;
387:
388: l_trans_rec FA_API_TYPES.trans_rec_type;
389: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
390: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
391: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
392: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
393: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
386: l_prorate_date date;
387:
388: l_trans_rec FA_API_TYPES.trans_rec_type;
389: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
390: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
391: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
392: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
393: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
394: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
387:
388: l_trans_rec FA_API_TYPES.trans_rec_type;
389: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
390: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
391: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
392: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
393: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
394: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
395: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
388: l_trans_rec FA_API_TYPES.trans_rec_type;
389: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
390: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
391: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
392: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
393: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
394: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
395: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
396: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
389: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
390: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
391: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
392: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
393: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
394: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
395: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
396: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
397: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
390: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
391: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
392: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
393: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
394: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
395: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
396: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
397: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
398: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
391: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
392: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
393: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
394: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
395: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
396: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
397: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
398: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
399: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
392: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
393: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
394: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
395: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
396: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
397: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
398: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
399: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
400:
393: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
394: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
395: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
396: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
397: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
398: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
399: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
400:
401: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
394: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
395: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
396: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
397: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
398: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
399: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
400:
401: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
402: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
395: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
396: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
397: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
398: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
399: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
400:
401: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
402: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
403: l_inv_trans_rec_dummy FA_API_TYPES.inv_trans_rec_type;
397: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
398: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
399: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
400:
401: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
402: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
403: l_inv_trans_rec_dummy FA_API_TYPES.inv_trans_rec_type;
404: l_inv_tbl_dummy FA_API_TYPES.inv_tbl_type;
405: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
398: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
399: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
400:
401: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
402: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
403: l_inv_trans_rec_dummy FA_API_TYPES.inv_trans_rec_type;
404: l_inv_tbl_dummy FA_API_TYPES.inv_tbl_type;
405: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
406:
399: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
400:
401: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
402: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
403: l_inv_trans_rec_dummy FA_API_TYPES.inv_trans_rec_type;
404: l_inv_tbl_dummy FA_API_TYPES.inv_tbl_type;
405: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
406:
407: l_return_status VARCHAR2(1);
400:
401: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
402: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
403: l_inv_trans_rec_dummy FA_API_TYPES.inv_trans_rec_type;
404: l_inv_tbl_dummy FA_API_TYPES.inv_tbl_type;
405: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
406:
407: l_return_status VARCHAR2(1);
408: l_mesg_count NUMBER;
401: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
402: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
403: l_inv_trans_rec_dummy FA_API_TYPES.inv_trans_rec_type;
404: l_inv_tbl_dummy FA_API_TYPES.inv_tbl_type;
405: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
406:
407: l_return_status VARCHAR2(1);
408: l_mesg_count NUMBER;
409: l_mesg_data VARCHAR2(2000);
700: END do_redefault;
701:
702:
703: FUNCTION populate_adjust_info (
704: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
705: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
706: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
707: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
708: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
701:
702:
703: FUNCTION populate_adjust_info (
704: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
705: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
706: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
707: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
708: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
709: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
702:
703: FUNCTION populate_adjust_info (
704: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
705: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
706: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
707: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
708: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
709: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
710: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
703: FUNCTION populate_adjust_info (
704: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
705: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
706: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
707: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
708: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
709: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
710: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
711: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
704: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
705: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
706: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
707: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
708: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
709: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
710: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
711: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
712: px_asset_deprn_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
705: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
706: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
707: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
708: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
709: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
710: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
711: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
712: px_asset_deprn_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
713: p_old_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
706: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
707: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
708: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
709: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
710: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
711: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
712: px_asset_deprn_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
713: p_old_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
714: p_new_rules IN FA_LOAD_TBL_PKG.asset_deprn_info
707: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
708: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
709: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
710: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
711: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
712: px_asset_deprn_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
713: p_old_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
714: p_new_rules IN FA_LOAD_TBL_PKG.asset_deprn_info
715: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
708: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
709: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
710: px_asset_fin_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
711: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
712: px_asset_deprn_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
713: p_old_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
714: p_new_rules IN FA_LOAD_TBL_PKG.asset_deprn_info
715: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
716:
711: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
712: px_asset_deprn_rec_adj IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
713: p_old_rules IN FA_LOAD_TBL_PKG.asset_deprn_info,
714: p_new_rules IN FA_LOAD_TBL_PKG.asset_deprn_info
715: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
716:
717: CURSOR get_prorate_date(p_dpis date) IS
718: SELECT conv.prorate_date
719: FROM FA_CONVENTIONS conv
723: l_use_deprn_limits_flag VARCHAR2(3) := 'NO';
724: l_prorate_date date;
725: l_status boolean;
726: l_fiscal_year_name varchar2(30);
727: l_period_rec FA_API_TYPES.period_rec_type;
728:
729: l_calling_fn varchar2(40) := 'fa_reclass_pvt.populate_adjust_info';
730: call_err EXCEPTION;
731: BEGIN