DBA Data[Home] [Help]

APPS.FA_RECLASS_UTIL_PVT dependencies on FA_API_TYPES

Line 14: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

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:

Line 55: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

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

Line 107: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

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

Line 200: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

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

Line 247: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean 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

Line 282: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

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:

Line 320: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

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

Line 378: p_trans_rec IN FA_API_TYPES.trans_rec_type,

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:

Line 381: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

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;

Line 452: p_mr_req_id IN NUMBER := -1 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

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;

Line 595: p_trans_rec IN FA_API_TYPES.trans_rec_type,

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

Line 596: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

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:

Line 597: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,

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

Line 598: p_dist_rec_old IN FA_API_TYPES.asset_dist_rec_type,

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

Line 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

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;

Line 754: p_trans_rec IN FA_API_TYPES.trans_rec_type,

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,

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

Line 756: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,

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:

Line 757: p_asset_cat_rec_new IN FA_API_TYPES.asset_cat_rec_type,

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

Line 758: px_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,

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,

Line 759: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

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,

Line 796: l_dist_rec_old FA_API_TYPES.asset_dist_rec_type;

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;

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

Line 938: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

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,

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

Line 940: p_asset_cat_rec_old IN FA_API_TYPES.asset_cat_rec_type,

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:

Line 941: px_asset_cat_rec_new IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

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;

Line 942: p_recl_opt_rec IN FA_API_TYPES.reclass_options_rec_type,

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

Line 943: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

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;

Line 1234: p_calling_fn IN VARCHAR2 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean IS

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;