7: p_book_type_code IN VARCHAR2,
8: p_asset_type IN VARCHAR2,
9: p_category_id IN VARCHAR2,
10: p_calling_fn IN VARCHAR2,
11: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
12:
13: v_count number;
14: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.validate_cip_accts';
15:
51: p_transaction_type_code IN VARCHAR2,
52: p_new_category_id IN NUMBER,
53: p_asset_id IN NUMBER,
54: p_calling_fn IN VARCHAR2,
55: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) 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';
106: p_new_cat_id IN NUMBER,
107: p_lease_id IN NUMBER,
108: p_asset_id IN NUMBER,
109: p_calling_fn IN VARCHAR2,
110: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
111: v_new_cap_flag varchar2(3);
112: v_new_cat_type varchar2(30);
113:
114: v_old_cap_flag varchar2(3);
204: FUNCTION validate_units(
205: p_transaction_type_code IN VARCHAR2,
206: p_asset_id IN NUMBER,
207: p_calling_fn IN VARCHAR2,
208: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
209: v_ah_units number;
210: v_dh_units number;
211:
212: CURSOR get_ah_units IS
254: FUNCTION validate_pending_retire(
255: p_transaction_type_code IN VARCHAR2,
256: p_asset_id IN NUMBER,
257: p_calling_fn IN VARCHAR2,
258: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
259:
260: v_count number:= 0;
261: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.validate_pending_ret';
262: BEGIN
292: FUNCTION validate_fully_retired(
293: p_transaction_type_code IN VARCHAR2,
294: p_asset_id IN NUMBER,
295: p_calling_fn IN VARCHAR2,
296: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
297:
298: v_count NUMBER := 0;
299: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.validate_fully_ret';
300:
333: p_transaction_type_code IN VARCHAR2,
334: p_asset_id IN NUMBER,
335: p_book IN VARCHAR2,
336: p_calling_fn IN VARCHAR2,
337: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
338:
339:
340: v_is_prior_period NUMBER :=0;
341: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.val_prior_per_add';
392: END validate_prior_per_add;
393:
394: ---------------------------------------------------------------
395: FUNCTION validate_transaction_date(
396: p_trans_rec IN FA_API_TYPES.trans_rec_type,
397: p_asset_id IN NUMBER,
398: p_book IN VARCHAR2,
399: p_calling_fn IN VARCHAR2,
400: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
396: p_trans_rec IN FA_API_TYPES.trans_rec_type,
397: p_asset_id IN NUMBER,
398: p_book IN VARCHAR2,
399: p_calling_fn IN VARCHAR2,
400: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
401:
402: l_prior_trans_date DATE;
403: l_prior_date_effective DATE;
404: l_check_another_trans NUMBER := 0;
471: p_asset_id IN NUMBER,
472: p_book_type_code IN VARCHAR2,
473: p_amortize_flag IN VARCHAR2,
474: p_mr_req_id IN NUMBER := -1,
475: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
476:
477: check_flag VARCHAR2(3);
478: prior_transaction_date DATE;
479: prior_date_effective DATE;
623:
624:
625: -------------------------------------------------------------
626: FUNCTION get_new_ccid(
627: p_trans_rec IN FA_API_TYPES.trans_rec_type,
628: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
629: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
630: p_dist_rec_old IN FA_API_TYPES.asset_dist_rec_type,
631: px_dist_rec_new IN OUT NOCOPY FA_API_TYPES.asset_dist_rec_type,
624:
625: -------------------------------------------------------------
626: FUNCTION get_new_ccid(
627: p_trans_rec IN FA_API_TYPES.trans_rec_type,
628: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
629: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
630: p_dist_rec_old IN FA_API_TYPES.asset_dist_rec_type,
631: px_dist_rec_new IN OUT NOCOPY FA_API_TYPES.asset_dist_rec_type,
632: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
625: -------------------------------------------------------------
626: FUNCTION get_new_ccid(
627: p_trans_rec IN FA_API_TYPES.trans_rec_type,
628: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
629: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
630: p_dist_rec_old IN FA_API_TYPES.asset_dist_rec_type,
631: px_dist_rec_new IN OUT NOCOPY FA_API_TYPES.asset_dist_rec_type,
632: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
633:
626: FUNCTION get_new_ccid(
627: p_trans_rec IN FA_API_TYPES.trans_rec_type,
628: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
629: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
630: p_dist_rec_old IN FA_API_TYPES.asset_dist_rec_type,
631: px_dist_rec_new IN OUT NOCOPY FA_API_TYPES.asset_dist_rec_type,
632: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
633:
634: h_mesg_name VARCHAR2(30);
627: p_trans_rec IN FA_API_TYPES.trans_rec_type,
628: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
629: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
630: p_dist_rec_old IN FA_API_TYPES.asset_dist_rec_type,
631: px_dist_rec_new IN OUT NOCOPY FA_API_TYPES.asset_dist_rec_type,
632: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
633:
634: h_mesg_name VARCHAR2(30);
635: h_new_deprn_exp_acct VARCHAR2(26);
628: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
629: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
630: p_dist_rec_old IN FA_API_TYPES.asset_dist_rec_type,
631: px_dist_rec_new IN OUT NOCOPY FA_API_TYPES.asset_dist_rec_type,
632: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
633:
634: h_mesg_name VARCHAR2(30);
635: h_new_deprn_exp_acct VARCHAR2(26);
636: -- h_new_ccid NUMBER(15) := 0;
785:
786:
787: --
788: FUNCTION get_asset_distribution(
789: p_trans_rec IN FA_API_TYPES.trans_rec_type,
790: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
791: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
792: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
793: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
786:
787: --
788: FUNCTION get_asset_distribution(
789: p_trans_rec IN FA_API_TYPES.trans_rec_type,
790: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
791: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
792: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
793: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
794: p_calling_fn IN VARCHAR2,
787: --
788: FUNCTION get_asset_distribution(
789: p_trans_rec IN FA_API_TYPES.trans_rec_type,
790: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
791: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
792: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
793: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
794: p_calling_fn IN VARCHAR2,
795: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
788: FUNCTION get_asset_distribution(
789: p_trans_rec IN FA_API_TYPES.trans_rec_type,
790: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
791: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
792: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
793: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
794: p_calling_fn IN VARCHAR2,
795: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
796:
789: p_trans_rec IN FA_API_TYPES.trans_rec_type,
790: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
791: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
792: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
793: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
794: p_calling_fn IN VARCHAR2,
795: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
796:
797: CURSOR dh_csr IS
791: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
792: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,
793: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
794: p_calling_fn IN VARCHAR2,
795: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
796:
797: CURSOR dh_csr IS
798: Select dh.distribution_id,
799: dh.code_combination_id,
828:
829: i integer:= 0;
830: j integer:= 0;
831: l_rowcount number;
832: l_dist_rec_old FA_API_TYPES.asset_dist_rec_type;
833: l_dist_rec_new FA_API_TYPES.asset_dist_rec_type;
834:
835: l_new_deprn_exp_acct fa_category_books.deprn_expense_acct%type;
836: l_old_deprn_exp_acct fa_category_books.deprn_expense_acct%type;
829: i integer:= 0;
830: j integer:= 0;
831: l_rowcount number;
832: l_dist_rec_old FA_API_TYPES.asset_dist_rec_type;
833: l_dist_rec_new FA_API_TYPES.asset_dist_rec_type;
834:
835: l_new_deprn_exp_acct fa_category_books.deprn_expense_acct%type;
836: l_old_deprn_exp_acct fa_category_books.deprn_expense_acct%type;
837: l_err_stage varchar2(250);
963:
964: -- ------------------------------------------------------
965:
966: FUNCTION get_cat_desc_flex(
967: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
968: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
969: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
970: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
971: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,
964: -- ------------------------------------------------------
965:
966: FUNCTION get_cat_desc_flex(
967: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
968: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
969: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
970: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
971: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,
972: p_calling_fn IN VARCHAR2,
965:
966: FUNCTION get_cat_desc_flex(
967: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
968: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
969: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
970: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
971: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,
972: p_calling_fn IN VARCHAR2,
973: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
966: FUNCTION get_cat_desc_flex(
967: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
968: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
969: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
970: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
971: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,
972: p_calling_fn IN VARCHAR2,
973: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
974:
967: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
968: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
969: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
970: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
971: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,
972: p_calling_fn IN VARCHAR2,
973: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
974:
975: l_cat_struct number;
969: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,
970: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
971: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,
972: p_calling_fn IN VARCHAR2,
973: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
974:
975: l_cat_struct number;
976: l_concat_cat varchar2(210);
977: l_cat_segs fa_rx_shared_pkg.Seg_Array;
1263: FUNCTION check_bal_seg_equal(
1264: p_old_category_id IN NUMBER,
1265: p_new_category_id IN NUMBER,
1266: p_calling_fn IN VARCHAR2,
1267: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
1268:
1269: CURSOR get_cat_flex_struct IS
1270: SELECT category_flex_structure
1271: FROM FA_SYSTEM_CONTROLS;