2: /* $Header: FAVRVLB.pls 120.7.12010000.1 2008/07/28 13:19:01 appldev ship $ */
3:
4:
5: FUNCTION do_reval
6: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
7: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
8: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
9: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
10: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
3:
4:
5: FUNCTION do_reval
6: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
7: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
8: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
9: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
10: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
11: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
4:
5: FUNCTION do_reval
6: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
7: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
8: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
9: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
10: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
11: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
5: FUNCTION do_reval
6: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
7: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
8: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
9: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
10: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
11: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
13: p_period_rec IN FA_API_TYPES.period_rec_type,
6: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
7: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
8: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
9: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
10: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
11: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
13: p_period_rec IN FA_API_TYPES.period_rec_type,
14: p_mrc_sob_type_code IN VARCHAR2,
7: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
8: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
9: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
10: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
11: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
13: p_period_rec IN FA_API_TYPES.period_rec_type,
14: p_mrc_sob_type_code IN VARCHAR2,
15: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
8: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
9: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
10: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
11: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
13: p_period_rec IN FA_API_TYPES.period_rec_type,
14: p_mrc_sob_type_code IN VARCHAR2,
15: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
16: p_calling_fn IN VARCHAR2,
9: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
10: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
11: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
13: p_period_rec IN FA_API_TYPES.period_rec_type,
14: p_mrc_sob_type_code IN VARCHAR2,
15: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
16: p_calling_fn IN VARCHAR2,
17: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
11: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
13: p_period_rec IN FA_API_TYPES.period_rec_type,
14: p_mrc_sob_type_code IN VARCHAR2,
15: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
16: p_calling_fn IN VARCHAR2,
17: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
18:
19: l_th_rowid varchar2(30);
13: p_period_rec IN FA_API_TYPES.period_rec_type,
14: p_mrc_sob_type_code IN VARCHAR2,
15: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
16: p_calling_fn IN VARCHAR2,
17: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
18:
19: l_th_rowid varchar2(30);
20: l_bks_rowid varchar2(30);
21: l_status boolean;
19: l_th_rowid varchar2(30);
20: l_bks_rowid varchar2(30);
21: l_status boolean;
22:
23: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
24: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
25:
26: l_reval_out_rec FA_STD_TYPES.reval_out_struct;
27:
20: l_bks_rowid varchar2(30);
21: l_status boolean;
22:
23: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
24: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
25:
26: l_reval_out_rec FA_STD_TYPES.reval_out_struct;
27:
28: -- rx columns
525:
526: -- this function contains validation for reval on an asset
527:
528: FUNCTION validate_reval
529: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
530: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
531: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
532: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
533: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
526: -- this function contains validation for reval on an asset
527:
528: FUNCTION validate_reval
529: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
530: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
531: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
532: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
533: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
534: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
527:
528: FUNCTION validate_reval
529: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
530: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
531: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
532: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
533: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
534: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
535: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
528: FUNCTION validate_reval
529: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
530: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
531: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
532: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
533: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
534: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
535: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
536: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
529: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
530: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
531: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
532: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
533: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
534: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
535: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
536: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
537: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
530: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
531: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
532: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
533: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
534: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
535: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
536: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
537: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
538:
531: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
532: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
533: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
534: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
535: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
536: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
537: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
538:
539: l_calling_fn varchar2(35) := 'do_adjustment_pvt.validate_adj';
532: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
533: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
534: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
535: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
536: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
537: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
538:
539: l_calling_fn varchar2(35) := 'do_adjustment_pvt.validate_adj';
540:
533: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
534: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
535: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
536: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
537: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
538:
539: l_calling_fn varchar2(35) := 'do_adjustment_pvt.validate_adj';
540:
541: BEGIN
552:
553: END validate_reval;
554:
555: FUNCTION fareven
556: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
557: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
558: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
559: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
560: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
553: END validate_reval;
554:
555: FUNCTION fareven
556: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
557: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
558: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
559: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
560: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
561: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
554:
555: FUNCTION fareven
556: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
557: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
558: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
559: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
560: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
561: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
562: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
555: FUNCTION fareven
556: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
557: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
558: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
559: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
560: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
561: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
562: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
563: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
556: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
557: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
558: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
559: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
560: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
561: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
562: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
563: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
564: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
557: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
558: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
559: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
560: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
561: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
562: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
563: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
564: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
565: p_period_rec IN FA_API_TYPES.period_rec_type,
558: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
559: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
560: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
561: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
562: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
563: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
564: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
565: p_period_rec IN FA_API_TYPES.period_rec_type,
566: p_mrc_sob_type_code IN VARCHAR2,
559: p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
560: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
561: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
562: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
563: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
564: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
565: p_period_rec IN FA_API_TYPES.period_rec_type,
566: p_mrc_sob_type_code IN VARCHAR2,
567: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
560: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
561: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
562: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
563: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
564: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
565: p_period_rec IN FA_API_TYPES.period_rec_type,
566: p_mrc_sob_type_code IN VARCHAR2,
567: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
568: x_reval_out OUT NOCOPY FA_STD_TYPES.reval_out_struct,
561: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
562: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
563: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
564: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
565: p_period_rec IN FA_API_TYPES.period_rec_type,
566: p_mrc_sob_type_code IN VARCHAR2,
567: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
568: x_reval_out OUT NOCOPY FA_STD_TYPES.reval_out_struct,
569: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
563: p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type,
564: px_asset_deprn_rec_new IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
565: p_period_rec IN FA_API_TYPES.period_rec_type,
566: p_mrc_sob_type_code IN VARCHAR2,
567: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
568: x_reval_out OUT NOCOPY FA_STD_TYPES.reval_out_struct,
569: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
570: RETURN BOOLEAN IS
571:
565: p_period_rec IN FA_API_TYPES.period_rec_type,
566: p_mrc_sob_type_code IN VARCHAR2,
567: p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
568: x_reval_out OUT NOCOPY FA_STD_TYPES.reval_out_struct,
569: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
570: RETURN BOOLEAN IS
571:
572: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
573:
568: x_reval_out OUT NOCOPY FA_STD_TYPES.reval_out_struct,
569: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
570: RETURN BOOLEAN IS
571:
572: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
573:
574: l_reval_rate number;
575: l_life_extension_factor number;
576: l_life_extension_ceiling number;