[Home] [Help]
2: /* $Header: FAVVALB.pls 120.69.12010000.6 2009/02/05 09:20:04 mswetha ship $ */
3:
4:
5: FUNCTION validate
6: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
7: p_asset_hdr_rec IN 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 validate
6: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
7: p_asset_hdr_rec IN 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 IN FA_API_TYPES.asset_fin_rec_type,
4:
5: FUNCTION validate
6: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
7: p_asset_hdr_rec IN 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 IN FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
5: FUNCTION validate
6: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
7: p_asset_hdr_rec IN 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 IN FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
13: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
6: (p_trans_rec IN FA_API_TYPES.trans_rec_type,
7: p_asset_hdr_rec IN 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 IN FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
13: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
14: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
7: p_asset_hdr_rec IN 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 IN FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
13: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
14: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
15: p_calling_fn IN VARCHAR2,
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 IN FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
13: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
14: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
15: p_calling_fn IN VARCHAR2,
16: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
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 IN FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
13: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
14: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
15: p_calling_fn IN VARCHAR2,
16: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
17: ) RETURN boolean IS
10: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
11: p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
12: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
13: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
14: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
15: p_calling_fn IN VARCHAR2,
16: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
17: ) RETURN boolean IS
18:
12: p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
13: p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
14: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
15: p_calling_fn IN VARCHAR2,
16: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
17: ) RETURN boolean IS
18:
19: l_distribution_count number;
20: val_err exception;
17: ) RETURN boolean IS
18:
19: l_distribution_count number;
20: val_err exception;
21: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
22:
23: l_curr_index number;
24:
25: BEGIN
260: (p_transaction_type_code IN VARCHAR2,
261: p_asset_number IN VARCHAR2,
262: p_asset_id IN NUMBER DEFAULT NULL,
263: p_calling_fn IN VARCHAR2,
264: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
265: ) RETURN BOOLEAN IS
266:
267: l_count number;
268: l_asset_number number(15) := 0;
388: FUNCTION validate_owned_leased
389: (p_transaction_type_code IN VARCHAR2,
390: p_owned_leased IN VARCHAR2,
391: p_calling_fn IN VARCHAR2,
392: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
393: ) RETURN BOOLEAN IS
394:
395: BEGIN
396:
412: (p_transaction_type_code IN VARCHAR2,
413: p_category_id IN NUMBER,
414: p_book_type_code IN VARCHAR2 DEFAULT NULL,
415: p_calling_fn IN VARCHAR2,
416: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
417: ) RETURN BOOLEAN IS
418:
419: BEGIN
420: -- Check that the category exists.
493:
494:
495: FUNCTION validate_category_df
496: (p_transaction_type_code IN VARCHAR2,
497: p_cat_desc_flex IN FA_API_TYPES.desc_flex_rec_type,
498: p_calling_fn IN VARCHAR2,
499: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
500: ) RETURN BOOLEAN IS
501:
495: FUNCTION validate_category_df
496: (p_transaction_type_code IN VARCHAR2,
497: p_cat_desc_flex IN FA_API_TYPES.desc_flex_rec_type,
498: p_calling_fn IN VARCHAR2,
499: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
500: ) RETURN BOOLEAN IS
501:
502: BEGIN
503: -- Check that the flexfield value is valid.
508: FUNCTION validate_serial_number
509: (p_transaction_type_code IN VARCHAR2,
510: p_serial_number IN VARCHAR2,
511: p_calling_fn IN VARCHAR2,
512: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
513: ) RETURN BOOLEAN IS
514:
515: BEGIN
516: -- CRL check?
521: FUNCTION validate_asset_key
522: (p_transaction_type_code IN VARCHAR2,
523: p_asset_key_ccid IN NUMBER,
524: p_calling_fn IN VARCHAR2,
525: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
526: ) RETURN BOOLEAN IS
527:
528: l_required number;
529: l_is_asset_key_valid number;
594: p_asset_type IN VARCHAR2,
595: p_book_type_code IN VARCHAR2,
596: p_category_id IN NUMBER,
597: p_calling_fn IN VARCHAR2,
598: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
599: ) RETURN BOOLEAN IS
600:
601: l_capitalize_flag varchar2(3);
602:
662:
663: FUNCTION validate_depreciate_flag
664: (p_depreciate_flag IN VARCHAR2,
665: p_calling_fn IN VARCHAR2,
666: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
667: ) RETURN BOOLEAN IS
668:
669: BEGIN
670:
683:
684: FUNCTION validate_supplier_name
685: (p_transaction_type_code IN VARCHAR2,
686: p_calling_fn IN VARCHAR2,
687: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
688: ) RETURN BOOLEAN IS
689:
690: BEGIN
691: -- From vendor_name_q lov in asset workbench.
699:
700: FUNCTION validate_supplier_number
701: (p_transaction_type_code IN VARCHAR2,
702: p_calling_fn IN VARCHAR2,
703: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
704: ) RETURN BOOLEAN IS
705:
706: BEGIN
707: -- From vendor_number_q lov in asset workbench.
717: (p_transaction_type_code IN VARCHAR2,
718: p_book_type_code IN VARCHAR2,
719: p_asset_id IN NUMBER,
720: p_calling_fn IN VARCHAR2,
721: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
722: ) RETURN BOOLEAN IS
723:
724: l_exists number;
725:
817: p_cost IN NUMBER,
818: p_asset_type IN VARCHAR2,
819: p_num_invoices IN NUMBER DEFAULT 0,
820: p_calling_fn IN VARCHAR2,
821: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
822: ) RETURN BOOLEAN IS
823:
824: BEGIN
825: -- If asset type is CIP, cost should be zero.
846: (p_transaction_type_code IN VARCHAR2,
847: p_assigned_to IN NUMBER,
848: p_date IN DATE DEFAULT sysdate,
849: p_calling_fn IN VARCHAR2,
850: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
851: ) RETURN BOOLEAN IS
852:
853: l_rowcount number;
854:
884: FUNCTION validate_location_ccid
885: (p_transaction_type_code IN VARCHAR2,
886: p_location_ccid IN NUMBER,
887: p_calling_fn IN VARCHAR2,
888: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
889: ) RETURN BOOLEAN IS
890:
891: l_is_location_valid number;
892:
931: p_db_rule_name IN VARCHAR2 DEFAULT NULL, -- ENERGY
932: p_rate_source_rule IN VARCHAR2 DEFAULT NULL, -- ENERGY
933: p_calling_interface IN VARCHAR2 DEFAULT NULL,
934: p_calling_fn IN VARCHAR2,
935: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null,
936: p_transaction_subtype IN VARCHAR2 DEFAULT 'EXPENSED',
937: p_asset_type IN VARCHAR2 DEFAULT NULL
938: ) RETURN BOOLEAN IS
939: --
990: l_start_jdate number;
991:
992: l_earliest_dpis date;
993: l_count number;
994: l_period_rec FA_API_TYPES.period_rec_type;
995:
996: l_prorate_date date;
997: l_check_prorate_date varchar2(1);
998: l_temp_num number;
1214: (p_transaction_type_code IN VARCHAR2,
1215: p_recoverable_cost IN NUMBER,
1216: p_deprn_reserve IN NUMBER,
1217: p_calling_fn IN VARCHAR2,
1218: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1219: ) RETURN BOOLEAN IS
1220:
1221: BEGIN
1222:
1237: FUNCTION validate_adj_rec_cost
1238: (p_adjusted_recoverable_cost IN NUMBER,
1239: p_deprn_reserve IN NUMBER,
1240: p_calling_fn IN VARCHAR2,
1241: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1242: ) RETURN BOOLEAN IS
1243:
1244: BEGIN
1245:
1267: p_reval_reserve IN NUMBER,
1268: p_ytd_reval_deprn_expense IN NUMBER,
1269: p_reval_amortization_basis IN NUMBER,
1270: p_fully_rsvd_revals_counter IN NUMBER,
1271: p_period_rec IN FA_API_TYPES.period_rec_type,
1272: p_calling_fn IN VARCHAR2,
1273: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1274: ) return boolean IS
1275:
1269: p_reval_amortization_basis IN NUMBER,
1270: p_fully_rsvd_revals_counter IN NUMBER,
1271: p_period_rec IN FA_API_TYPES.period_rec_type,
1272: p_calling_fn IN VARCHAR2,
1273: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1274: ) return boolean IS
1275:
1276: l_current_fiscal_year FA_BOOK_CONTROLS.current_fiscal_year%TYPE;
1277: l_fiscal_year_name FA_BOOK_CONTROLS.fiscal_year_name%TYPE;
1367: px_orig_deprn_start_date IN OUT NOCOPY DATE,
1368: p_date_placed_in_service IN DATE,
1369: p_ytd_deprn IN NUMBER,
1370: p_deprn_reserve IN NUMBER,
1371: p_period_rec IN FA_API_TYPES.period_rec_type,
1372: p_calling_fn IN VARCHAR2,
1373: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1374: ) RETURN BOOLEAN IS
1375:
1369: p_ytd_deprn IN NUMBER,
1370: p_deprn_reserve IN NUMBER,
1371: p_period_rec IN FA_API_TYPES.period_rec_type,
1372: p_calling_fn IN VARCHAR2,
1373: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1374: ) RETURN BOOLEAN IS
1375:
1376: l_abs_ytd_deprn number;
1377: l_abs_deprn_reserve number;
1470: FUNCTION validate_trx_date_entered
1471: (p_transaction_type_code IN VARCHAR2,
1472: p_book_type_code IN VARCHAR2,
1473: p_transaction_date_entered IN DATE,
1474: p_period_rec IN FA_API_TYPES.period_rec_type,
1475: p_calling_fn IN VARCHAR2,
1476: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1477: ) RETURN BOOLEAN IS
1478:
1472: p_book_type_code IN VARCHAR2,
1473: p_transaction_date_entered IN DATE,
1474: p_period_rec IN FA_API_TYPES.period_rec_type,
1475: p_calling_fn IN VARCHAR2,
1476: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1477: ) RETURN BOOLEAN IS
1478:
1479: begin
1480:
1495: p_asset_id IN NUMBER,
1496: p_book_type_code IN VARCHAR2,
1497: p_date_placed_in_service IN DATE DEFAULT NULL,
1498: p_conversion_date IN DATE DEFAULT NULL,
1499: p_period_rec IN FA_API_TYPES.period_rec_type,
1500: p_amortization_start_date IN DATE,
1501: p_db_rule_name IN VARCHAR2 DEFAULT NULL, -- ENERGY
1502: p_rate_source_rule IN VARCHAR2 DEFAULT NULL, -- ENERGY
1503: p_transaction_key IN VARCHAR2 DEFAULT 'XX',
1503: p_transaction_key IN VARCHAR2 DEFAULT 'XX',
1504: x_amortization_start_date OUT NOCOPY DATE,
1505: x_trxs_exist OUT NOCOPY VARCHAR2,
1506: p_calling_fn IN VARCHAR2,
1507: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1508: ) RETURN BOOLEAN IS
1509:
1510: l_transaction_date date;
1511: l_period_close_date date;
1523: l_amort_per_num number;
1524: l_fy_name varchar2(45);
1525: l_cal_type varchar2(15);
1526: l_start_jdate number;
1527: l_period_rec FA_API_TYPES.period_rec_type;
1528: l_calling_fn varchar2(40) := 'fa_asset_val_pvt.val_amort_date';
1529: error_found exception;
1530:
1531: begin
1717: p_user_id IN NUMBER,
1718: p_curr_date IN DATE,
1719: px_new_life IN OUT NOCOPY NUMBER,
1720: p_calling_fn IN VARCHAR2,
1721: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1722: ) RETURN BOOLEAN IS
1723:
1724: l_method_id number;
1725: l_rowid rowid;
1931: FUNCTION validate_payables_ccid
1932: (px_payables_ccid IN OUT NOCOPY NUMBER,
1933: p_gl_chart_id IN NUMBER,
1934: p_calling_fn IN VARCHAR2,
1935: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1936: ) RETURN BOOLEAN IS
1937:
1938: l_is_valid_payables_ccid number;
1939:
1975: FUNCTION validate_expense_ccid
1976: (p_expense_ccid IN NUMBER,
1977: p_gl_chart_id IN NUMBER,
1978: p_calling_fn IN VARCHAR2,
1979: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
1980: ) RETURN BOOLEAN IS
1981:
1982: l_is_valid_expense_ccid number;
1983:
2017:
2018: FUNCTION validate_fixed_assets_cost
2019: (p_fixed_assets_cost IN NUMBER,
2020: p_calling_fn IN VARCHAR2,
2021: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2022: ) RETURN BOOLEAN IS
2023:
2024: BEGIN
2025:
2037:
2038: FUNCTION validate_fixed_assets_units
2039: (p_fixed_assets_units IN NUMBER,
2040: p_calling_fn IN VARCHAR2,
2041: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2042: ) RETURN BOOLEAN IS
2043:
2044: BEGIN
2045:
2066:
2067: FUNCTION validate_payables_cost
2068: (p_payables_cost IN NUMBER,
2069: p_calling_fn IN VARCHAR2,
2070: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2071: ) RETURN BOOLEAN IS
2072:
2073: BEGIN
2074:
2086:
2087: FUNCTION validate_payables_units
2088: (p_payables_units IN NUMBER,
2089: p_calling_fn IN VARCHAR2,
2090: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2091: ) RETURN BOOLEAN IS
2092:
2093: BEGIN
2094:
2106:
2107: FUNCTION validate_po_vendor_id
2108: (p_po_vendor_id IN NUMBER,
2109: p_calling_fn IN VARCHAR2,
2110: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2111: ) RETURN BOOLEAN IS
2112:
2113: l_is_valid_vendor_id number;
2114:
2136:
2137: FUNCTION validate_unit_of_measure
2138: (p_unit_of_measure IN VARCHAR2,
2139: p_calling_fn IN VARCHAR2,
2140: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2141: ) RETURN BOOLEAN IS
2142:
2143: l_is_valid_uom number;
2144:
2168: FUNCTION validate_salvage_value
2169: (p_salvage_value IN NUMBER,
2170: p_cost IN NUMBER,
2171: p_calling_fn IN VARCHAR2,
2172: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2173: ) RETURN BOOLEAN IS
2174:
2175: l_abs_salvage_value number;
2176: l_abs_cost number;
2199: FUNCTION validate_tag_number
2200: (p_tag_number IN VARCHAR2,
2201: p_mass_addition_id IN NUMBER DEFAULT NULL,
2202: p_calling_fn IN VARCHAR2,
2203: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2204: ) RETURN BOOLEAN IS
2205:
2206: l_tag_number_count number;
2207:
2257:
2258: FUNCTION validate_split_merged_code
2259: (p_split_merged_code IN VARCHAR2,
2260: p_calling_fn IN VARCHAR2,
2261: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2262: ) RETURN BOOLEAN IS
2263:
2264: BEGIN
2265:
2279: FUNCTION validate_exp_after_amort
2280: (p_asset_id IN number,
2281: p_book IN varchar2,
2282: p_extended_flag IN BOOLEAN DEFAULT FALSE,
2283: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2284: ) RETURN BOOLEAN IS
2285:
2286: l_count number;
2287:
2361:
2362: FUNCTION validate_unplanned_exists
2363: (p_asset_id IN number,
2364: p_book IN varchar2,
2365: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2366: ) RETURN BOOLEAN IS
2367:
2368: l_count number;
2369:
2392: (p_asset_id IN number,
2393: p_book IN varchar2,
2394: p_mode IN varchar2 DEFAULT 'ABSOLUTE',
2395: px_period_of_addition IN OUT NOCOPY varchar2,
2396: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2397: ) RETURN BOOLEAN IS
2398:
2399: l_last_pc number;
2400: l_count number;
2397: ) RETURN BOOLEAN IS
2398:
2399: l_last_pc number;
2400: l_count number;
2401: l_period_rec FA_API_TYPES.period_rec_type;
2402:
2403: BEGIN
2404:
2405: -- no need to load book controls cache here as it's loaded
2466:
2467: FUNCTION validate_fully_retired
2468: (p_asset_id IN number,
2469: p_book IN varchar2,
2470: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2471: ) RETURN BOOLEAN IS
2472:
2473: l_count number;
2474:
2500:
2501: FUNCTION validate_add_to_asset_pending
2502: (p_asset_id in number
2503: ,p_book in varchar2,
2504: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2505: ) return BOOLEAN IS
2506:
2507: l_count number;
2508:
2532:
2533:
2534: FUNCTION validate_asset_id_exist
2535: (p_asset_id in number,
2536: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2537: ) return BOOLEAN IS
2538:
2539: l_count number;
2540:
2562:
2563: FUNCTION validate_ret_rst_pending
2564: (p_asset_id in number
2565: ,p_book in varchar2 ,
2566: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2567: ) return BOOLEAN IS
2568:
2569: l_count number;
2570:
2595:
2596: FUNCTION validate_fa_lookup_code
2597: (p_lookup_type in varchar2
2598: ,p_lookup_code in varchar2,
2599: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2600: ) return BOOLEAN IS
2601:
2602: l_count number;
2603:
2630: FUNCTION validate_dist_id
2631: (p_asset_id in number
2632: -- ,p_book in varchar2
2633: ,p_dist_id in number,
2634: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2635: ) return BOOLEAN IS
2636:
2637: l_count number;
2638:
2665: FUNCTION validate_corp_pending_ret
2666: (p_asset_id in number
2667: ,p_book in varchar2
2668: ,p_transaction_header_id_in in number,
2669: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2670: ) RETURN BOOLEAN IS
2671:
2672: l_count1 number := 0;
2673: l_count2 number := 0;
2747:
2748: FUNCTION validate_parent_asset(
2749: p_parent_asset_id IN number,
2750: p_asset_id IN number,
2751: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null ) return boolean IS
2752: l_count number:=0;
2753: l_corp_book varchar2(15);
2754: BEGIN
2755: -- always do this check for corp book
2781: FUNCTION validate_warranty (
2782: p_warranty_id IN NUMBER,
2783: p_date_placed_in_service IN DATE,
2784: p_book_type_code IN VARCHAR2,
2785: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2786: ) return boolean IS
2787:
2788: l_count number := 0;
2789:
2830:
2831: FUNCTION validate_lease(
2832: p_asset_id IN number,
2833: p_lease_id IN number,
2834: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null ) return boolean IS
2835:
2836: CURSOR get_cat_type IS
2837: select category_type
2838: from fa_categories_b
2903:
2904: END validate_lease;
2905:
2906: FUNCTION validate_property_type(p_property_type_code in VARCHAR2,
2907: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
2908: l_count number:= 0;
2909: BEGIN
2910: if p_property_type_code is not null then
2911: select count(1)
2927: END validate_property_type;
2928:
2929:
2930: FUNCTION validate_1245_1250_code(p_1245_1250_code in VARCHAR2,
2931: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean IS
2932: l_count number:= 0;
2933: BEGIN
2934: if p_1245_1250_code is not null then
2935: select count(1)
2953: FUNCTION validate_group_asset
2954: (p_group_asset_id in NUMBER,
2955: p_book_type_code in VARCHAR2,
2956: p_asset_type in VARCHAR2,
2957: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
2958: ) return boolean is
2959:
2960: l_count number;
2961:
3008: (p_group_asset_id in NUMBER,
3009: p_book_type_code in VARCHAR2,
3010: p_old_flag IN VARCHAR2,
3011: p_new_flag IN VARCHAR2,
3012: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3013: ) return boolean is
3014:
3015: l_calling_fn varchar2(40) :='fa_asset_val_pvt.validate_disabled_flag';
3016:
3046: FUNCTION validate_group_info
3047: (p_group_asset_id in NUMBER,
3048: p_book_type_code in VARCHAR2,
3049: p_calling_fn in VARCHAR2,
3050: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3051: ) return boolean is
3052:
3053: l_has_members number;
3054: l_disabled number;
3094:
3095: END validate_group_info; -- End HH.
3096:
3097: FUNCTION validate_over_depreciate
3098: (p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
3099: p_asset_type VARCHAR2,
3100: p_over_depreciate_option VARCHAR2 default null,
3101: p_adjusted_recoverable_cost NUMBER default null,
3102: p_recoverable_cost NUMBER default null,
3104: p_rate_source_rule VARCHAR2 default null,
3105: p_deprn_basis_rule VARCHAR2 default null,
3106: p_recapture_reserve_flag VARCHAR2 default null,
3107: p_deprn_limit_type VARCHAR2 default null,
3108: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3109: ) return boolean is
3110:
3111: l_calling_fn varchar2(50) := 'fa_asset_val_pvt.validate_over_depreciate';
3112:
3220: p_deprn_limit_amount number default 0,
3221: p_deprn_limit_amount_adj number default 0,
3222: p_mrc_sob_type_code varchar2,
3223: p_over_depreciate_option varchar2,
3224: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3225: ) return boolean is
3226:
3227: l_calling_fn varchar2(50) := 'fa_asset_val_pvt.validate_cost_change';
3228:
3441: -- to check for duplicates
3442:
3443: FUNCTION validate_duplicate_dist (
3444: p_transaction_type_code IN VARCHAR2,
3445: p_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
3446: p_curr_index IN NUMBER,
3447: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null ) return boolean IS
3448:
3449: l_high_bound number;
3443: FUNCTION validate_duplicate_dist (
3444: p_transaction_type_code IN VARCHAR2,
3445: p_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
3446: p_curr_index IN NUMBER,
3447: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null ) return boolean IS
3448:
3449: l_high_bound number;
3450: dup_err exception;
3451: l_calling_fn varchar2(50) := 'fa_asset_val_pvt.validate_duplicate_dist';
3508: IN DATE DEFAULT NULL,
3509: p_ytd_deprn IN NUMBER DEFAULT NULL,
3510: p_deprn_reserve IN NUMBER DEFAULT NULL,
3511: p_calling_fn IN VARCHAR2,
3512: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3513: ) RETURN BOOLEAN AS
3514:
3515: l_deprn_basis_rule varchar2(80);
3516: l_polish_rule number;
3663: p_book_type_code IN VARCHAR2,
3664: p_old_super_group_id IN NUMBER,
3665: p_new_super_group_id IN NUMBER,
3666: p_calling_fn IN VARCHAR2,
3667: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
3668:
3669: l_calling_fn varchar2(40) := 'fa_asset_val_pvt.validate_super_group';
3670:
3671: CURSOR c_check_used is
3728: (p_book_type_code IN VARCHAR2,
3729: p_date_placed_in_service IN DATE,
3730: p_group_asset_Id IN NUMBER,
3731: p_calling_fn IN VARCHAR2,
3732: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3733: ) RETURN BOOLEAN IS
3734:
3735: CURSOR c_group_dpis (p_group_asset_id NUMBER,
3736: p_book_type_code VARCHAR2) is
3773: p_transaction_key IN VARCHAR2,
3774: p_rate_source_rule IN VARCHAR2,
3775: p_rule_name IN VARCHAR2,
3776: p_calling_fn IN VARCHAR2,
3777: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
3778:
3779: l_calling_fn varchar2(50) := 'FA_ASSET_VAL_PVT.validate_egy_prod_date';
3780:
3781: BEGIN
3811: FUNCTION validate_reval_exists (
3812: p_book_type_code IN VARCHAR2,
3813: p_asset_Id IN NUMBER,
3814: p_calling_fn IN VARCHAR2,
3815: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3816: ) RETURN BOOLEAN IS
3817:
3818: CURSOR c_reval_exists (l_asset_id NUMBER,
3819: l_book_type_code VARCHAR2) is
3854: END validate_reval_exists;
3855:
3856: /* Japan Tax Phase3 -- Prevent transactions on assets in extended depreciation */
3857: FUNCTION validate_extended_asset (
3858: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3859: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3860: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3861: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3862: ) RETURN BOOLEAN IS
3855:
3856: /* Japan Tax Phase3 -- Prevent transactions on assets in extended depreciation */
3857: FUNCTION validate_extended_asset (
3858: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3859: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3860: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3861: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3862: ) RETURN BOOLEAN IS
3863:
3856: /* Japan Tax Phase3 -- Prevent transactions on assets in extended depreciation */
3857: FUNCTION validate_extended_asset (
3858: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3859: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3860: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3861: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3862: ) RETURN BOOLEAN IS
3863:
3864: l_calling_fn varchar2(50) := 'FA_ASSET_VAL_PVT.validate_extended_asset';
3857: FUNCTION validate_extended_asset (
3858: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3859: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3860: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3861: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3862: ) RETURN BOOLEAN IS
3863:
3864: l_calling_fn varchar2(50) := 'FA_ASSET_VAL_PVT.validate_extended_asset';
3865: l_mrc_count number := 0;
3956: END validate_extended_asset;
3957:
3958: /* Bug#7693266- To validate change of salvage_type or deprn_limit_type of group asset */
3959: FUNCTION validate_sal_deprn_sum (
3960: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3961: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3962: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3963: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3964: ) RETURN BOOLEAN IS
3957:
3958: /* Bug#7693266- To validate change of salvage_type or deprn_limit_type of group asset */
3959: FUNCTION validate_sal_deprn_sum (
3960: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3961: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3962: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3963: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3964: ) RETURN BOOLEAN IS
3965:
3958: /* Bug#7693266- To validate change of salvage_type or deprn_limit_type of group asset */
3959: FUNCTION validate_sal_deprn_sum (
3960: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3961: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3962: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3963: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3964: ) RETURN BOOLEAN IS
3965:
3966: CURSOR c_mem_exists IS
3959: FUNCTION validate_sal_deprn_sum (
3960: p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
3961: p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
3962: p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
3963: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
3964: ) RETURN BOOLEAN IS
3965:
3966: CURSOR c_mem_exists IS
3967: select 1