10: p_transaction_type_code IN VARCHAR2,
11: p_book_type_code IN VARCHAR2,
12: p_asset_type IN VARCHAR2,
13: p_category_id IN VARCHAR2,
14: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
15:
16: v_count number;
17: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.validate_cip_accts';
18:
51: FUNCTION check_cat_book_setup(
52: p_transaction_type_code IN VARCHAR2,
53: p_new_category_id IN NUMBER,
54: p_asset_id IN NUMBER,
55: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
56:
57: l_count1 number;
58: l_count2 number;
59: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.check_cat_book_setup';
103: p_old_cat_id IN NUMBER,
104: p_new_cat_id IN NUMBER,
105: p_lease_id IN NUMBER,
106: p_asset_id IN NUMBER,
107: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
108: v_new_cap_flag varchar2(3);
109: v_new_cat_type varchar2(30);
110:
111: v_old_cap_flag varchar2(3);
196:
197: FUNCTION validate_units(
198: p_transaction_type_code IN VARCHAR2,
199: p_asset_id IN NUMBER,
200: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
201: v_ah_units number;
202: v_dh_units number;
203:
204: CURSOR get_ah_units IS
243: ------------------------------------------------------
244: FUNCTION validate_pending_retire(
245: p_transaction_type_code IN VARCHAR2,
246: p_asset_id IN NUMBER,
247: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
248:
249: v_count number:= 0;
250: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.validate_pending_ret';
251: BEGIN
278: -----------------------------------------------------
279: FUNCTION validate_fully_retired(
280: p_transaction_type_code IN VARCHAR2,
281: p_asset_id IN NUMBER,
282: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
283:
284: v_count NUMBER := 0;
285: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.validate_fully_ret';
286:
316: FUNCTION validate_prior_per_add (
317: p_transaction_type_code IN VARCHAR2,
318: p_asset_id IN NUMBER,
319: p_book IN VARCHAR2,
320: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
321:
322:
323: v_is_prior_period NUMBER :=0;
324: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.val_prior_per_add';
374: END validate_prior_per_add;
375:
376: ---------------------------------------------------------------
377: FUNCTION validate_transaction_date(
378: p_trans_rec IN FA_API_TYPES.trans_rec_type,
379: p_asset_id IN NUMBER,
380: p_book IN VARCHAR2,
381: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
382:
377: FUNCTION validate_transaction_date(
378: p_trans_rec IN FA_API_TYPES.trans_rec_type,
379: p_asset_id IN NUMBER,
380: p_book IN VARCHAR2,
381: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
382:
383: l_prior_trans_date DATE;
384: l_prior_date_effective DATE;
385: l_check_another_trans NUMBER := 0;
448: p_transaction_type_code IN VARCHAR2,
449: p_asset_id IN NUMBER,
450: p_book_type_code IN VARCHAR2,
451: p_amortize_flag IN VARCHAR2,
452: p_mr_req_id IN NUMBER := -1 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
453:
454: check_flag VARCHAR2(3);
455: prior_transaction_date DATE;
456: prior_date_effective DATE;
591:
592:
593: -------------------------------------------------------------
594: FUNCTION get_new_ccid(
595: p_trans_rec IN FA_API_TYPES.trans_rec_type,
596: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
597: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
598: p_dist_rec_old IN FA_API_TYPES.asset_dist_rec_type,
599: px_dist_rec_new IN OUT NOCOPY FA_API_TYPES.asset_dist_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
592:
593: -------------------------------------------------------------
594: FUNCTION get_new_ccid(
595: p_trans_rec IN FA_API_TYPES.trans_rec_type,
596: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
597: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
598: p_dist_rec_old IN FA_API_TYPES.asset_dist_rec_type,
599: px_dist_rec_new IN OUT NOCOPY FA_API_TYPES.asset_dist_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
600:
593: -------------------------------------------------------------
594: FUNCTION get_new_ccid(
595: p_trans_rec IN FA_API_TYPES.trans_rec_type,
596: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
597: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
598: p_dist_rec_old IN FA_API_TYPES.asset_dist_rec_type,
599: px_dist_rec_new IN OUT NOCOPY FA_API_TYPES.asset_dist_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
600:
601: h_mesg_name VARCHAR2(30);
594: FUNCTION get_new_ccid(
595: p_trans_rec IN FA_API_TYPES.trans_rec_type,
596: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
597: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
598: p_dist_rec_old IN FA_API_TYPES.asset_dist_rec_type,
599: px_dist_rec_new IN OUT NOCOPY FA_API_TYPES.asset_dist_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
600:
601: h_mesg_name VARCHAR2(30);
602: h_new_deprn_exp_acct VARCHAR2(26);
595: p_trans_rec IN FA_API_TYPES.trans_rec_type,
596: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
597: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
598: p_dist_rec_old IN FA_API_TYPES.asset_dist_rec_type,
599: px_dist_rec_new IN OUT NOCOPY FA_API_TYPES.asset_dist_rec_type , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
600:
601: h_mesg_name VARCHAR2(30);
602: h_new_deprn_exp_acct VARCHAR2(26);
603: -- h_new_ccid NUMBER(15) := 0;
750:
751:
752: --
753: FUNCTION get_asset_distribution(
754: p_trans_rec IN FA_API_TYPES.trans_rec_type,
755: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
756: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
757: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
758: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
751:
752: --
753: FUNCTION get_asset_distribution(
754: p_trans_rec IN FA_API_TYPES.trans_rec_type,
755: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
756: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
757: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
758: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
759: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
752: --
753: FUNCTION get_asset_distribution(
754: p_trans_rec IN FA_API_TYPES.trans_rec_type,
755: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
756: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
757: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
758: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
759: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
760:
753: FUNCTION get_asset_distribution(
754: p_trans_rec IN FA_API_TYPES.trans_rec_type,
755: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
756: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
757: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
758: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
759: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
760:
761: CURSOR dh_csr IS
754: p_trans_rec IN FA_API_TYPES.trans_rec_type,
755: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
756: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
757: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
758: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
759: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
760:
761: CURSOR dh_csr IS
762: Select dh.distribution_id,
755: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
756: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
757: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
758: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
759: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
760:
761: CURSOR dh_csr IS
762: Select dh.distribution_id,
763: dh.code_combination_id,
792:
793: i integer:= 0;
794: j integer:= 0;
795: l_rowcount number;
796: l_dist_rec_old FA_API_TYPES.asset_dist_rec_type;
797: l_dist_rec_new FA_API_TYPES.asset_dist_rec_type;
798:
799: l_new_deprn_exp_acct fa_category_books.deprn_expense_acct%type;
800: l_old_deprn_exp_acct fa_category_books.deprn_expense_acct%type;
793: i integer:= 0;
794: j integer:= 0;
795: l_rowcount number;
796: l_dist_rec_old FA_API_TYPES.asset_dist_rec_type;
797: l_dist_rec_new FA_API_TYPES.asset_dist_rec_type;
798:
799: l_new_deprn_exp_acct fa_category_books.deprn_expense_acct%type;
800: l_old_deprn_exp_acct fa_category_books.deprn_expense_acct%type;
801: l_err_stage varchar2(250);
934:
935: -- ------------------------------------------------------
936:
937: FUNCTION get_cat_desc_flex(
938: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
939: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
940: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
941: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
942: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,
935: -- ------------------------------------------------------
936:
937: FUNCTION get_cat_desc_flex(
938: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
939: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
940: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
941: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
942: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,
943: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
936:
937: FUNCTION get_cat_desc_flex(
938: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
939: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
940: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
941: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
942: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,
943: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
944:
937: FUNCTION get_cat_desc_flex(
938: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
939: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
940: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
941: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
942: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,
943: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
944:
945: l_cat_struct number;
938: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
939: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
940: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
941: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
942: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,
943: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
944:
945: l_cat_struct number;
946: l_concat_cat varchar2(210);
939: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
940: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
941: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
942: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,
943: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
944:
945: l_cat_struct number;
946: l_concat_cat varchar2(210);
947: l_cat_segs fa_rx_shared_pkg.Seg_Array;
1230: ----------------------------------------------------
1231: FUNCTION check_bal_seg_equal(
1232: p_old_category_id IN NUMBER,
1233: p_new_category_id IN NUMBER,
1234: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS
1235:
1236: CURSOR get_cat_flex_struct IS
1237: SELECT category_flex_structure
1238: FROM FA_SYSTEM_CONTROLS;