DBA Data[Home] [Help]

APPS.FA_RECLASS_UTIL_PVT dependencies on FA_API_TYPES

Line 11: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS

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:

Line 55: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS

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';

Line 110: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS

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);

Line 208: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS

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

Line 258: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean 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

Line 296: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS

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:

Line 337: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS

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';

Line 396: p_trans_rec IN FA_API_TYPES.trans_rec_type,

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

Line 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;

Line 475: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS

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;

Line 627: p_trans_rec IN FA_API_TYPES.trans_rec_type,

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,

Line 628: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_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

Line 629: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,

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:

Line 630: p_dist_rec_old IN FA_API_TYPES.asset_dist_rec_type,

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);

Line 631: px_dist_rec_new IN OUT NOCOPY FA_API_TYPES.asset_dist_rec_type,

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);

Line 632: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS

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;

Line 789: p_trans_rec IN FA_API_TYPES.trans_rec_type,

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,

Line 790: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_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,

Line 791: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,

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

Line 792: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,

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:

Line 793: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,

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

Line 795: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean 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,

Line 832: l_dist_rec_old FA_API_TYPES.asset_dist_rec_type;

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;

Line 833: l_dist_rec_new FA_API_TYPES.asset_dist_rec_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);

Line 967: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

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,

Line 968: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_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,

Line 969: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,

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

Line 970: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

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:

Line 971: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,

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;

Line 973: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS

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;

Line 1267: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS

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;