DBA Data[Home] [Help]

APPS.FA_SORP_UPG_PKG dependencies on FA_API_TYPES

Line 5: function fa_sorp_upg_mc_flag(p_book_type_code varchar2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

1: PACKAGE BODY fa_sorp_upg_pkg AS
2: /* $Header: FAVSRUB.pls 120.4.12020000.2 2012/09/10 08:53:11 gigupta ship $ */
3:
4: -- this fucntion determines if a book to be upgraded is MRC enabled or not
5: function fa_sorp_upg_mc_flag(p_book_type_code varchar2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
6: return boolean
7: is
8: v_mc_source_flag varchar2(5);
9: cursor c_mc_cur is

Line 25: FUNCTION get_ccid (p_acct_flex_struct NUMBER, p_account VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

21: end if;
22:
23: end fa_sorp_upg_mc_flag;
24:
25: FUNCTION get_ccid (p_acct_flex_struct NUMBER, p_account VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
26: RETURN NUMBER
27: IS
28: CURSOR c_ccid_cur
29: IS

Line 47: FUNCTION get_account_seg (p_acct_flex_struct NUMBER, p_ccid NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

43:
44: RETURN v_ccid;
45: END get_ccid;
46:
47: FUNCTION get_account_seg (p_acct_flex_struct NUMBER, p_ccid NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
48: RETURN VARCHAR2
49: IS
50: CURSOR c_acct_seg_cur
51: IS

Line 85: FUNCTION get_flex_struct (p_flex_name VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

81:
82: RETURN v_acct;
83: END get_account_seg;
84:
85: FUNCTION get_flex_struct (p_flex_name VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
86: RETURN NUMBER
87: IS
88: v_cat_struct_id NUMBER;
89: BEGIN

Line 100: FUNCTION get_cat_flex (p_category_id NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

96: RETURN (v_cat_struct_id);
97: END IF;
98: END get_flex_struct;
99:
100: FUNCTION get_cat_flex (p_category_id NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
101: RETURN VARCHAR2
102: IS
103: v_category_name VARCHAR2 (1000);
104:

Line 129: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN

125: p_period_counter IN NUMBER,
126: p_mode varchar2,
127: px_capital_adj IN OUT NOCOPY NUMBER,
128: px_general_fund IN OUT NOCOPY NUMBER
129: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN
130: IS
131: cursor c_deprn_detail_cur is
132: select itf.asset_id,
133: itf.impairment_id,

Line 243: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN

239: p_mode varchar2,
240: px_capital_adj IN OUT NOCOPY NUMBER,
241: px_general_fund IN OUT NOCOPY NUMBER,
242: p_set_of_books_id IN NUMBER
243: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN
244: IS
245: cursor c_deprn_detail_cur is
246: select itf.asset_id,
247: itf.impairment_id,

Line 357: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN

353: p_dist_id IN NUMBER,
354: p_period_counter IN NUMBER,
355: px_capital_adj IN OUT NOCOPY NUMBER,
356: px_general_fund IN OUT NOCOPY NUMBER
357: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN
358: IS
359: l_reval_reserve_ca NUMBER;
360: l_nbv_retired_ca NUMBER;
361: l_nbv_retired_gf NUMBER;

Line 474: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN

470: p_period_counter IN NUMBER,
471: px_capital_adj IN OUT NOCOPY NUMBER,
472: px_general_fund IN OUT NOCOPY NUMBER,
473: p_set_of_books_id IN NUMBER
474: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN
475: IS
476: l_reval_reserve_ca NUMBER;
477: l_nbv_retired_ca NUMBER;
478: l_nbv_retired_gf NUMBER;

Line 805: FUNCTION fa_sorp_reval_chk_fn (p_book_type_code VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

801: p_status_msg := SQLERRM;
802: RETURN FALSE;
803: END fa_category_impl;
804:
805: FUNCTION fa_sorp_reval_chk_fn (p_book_type_code VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
806: RETURN BOOLEAN
807: IS
808: v_period_counter NUMBER;
809: v_period_name VARCHAR2 (30);

Line 959: FUNCTION fa_sorp_upg_cagf_mc_fn (p_book_type_code VARCHAR2, p_mode VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

955: ROLLBACK;
956: RETURN FALSE;
957: END fa_sorp_reval_chk_fn;
958:
959: FUNCTION fa_sorp_upg_cagf_mc_fn (p_book_type_code VARCHAR2, p_mode VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
960: RETURN BOOLEAN
961: IS
962: l_deprn_rsv NUMBER;
963: l_impairment_rsv NUMBER;

Line 1381: FUNCTION fa_sorp_upg_cagf_fn (p_book_type_code VARCHAR2, p_mode VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

1377: ROLLBACK;
1378: RETURN FALSE;
1379: END fa_sorp_upg_cagf_mc_fn;
1380:
1381: FUNCTION fa_sorp_upg_cagf_fn (p_book_type_code VARCHAR2, p_mode VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1382: RETURN BOOLEAN
1383: IS
1384: l_deprn_rsv NUMBER;
1385: l_impairment_rsv NUMBER;

Line 1814: FUNCTION fa_sorp_upg_impreval_mc_fn(p_book VARCHAR2, p_mode VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

1810: ROLLBACK;
1811: RETURN FALSE;
1812: END fa_sorp_upg_cagf_fn;
1813:
1814: FUNCTION fa_sorp_upg_impreval_mc_fn(p_book VARCHAR2, p_mode VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1815: RETURN BOOLEAN
1816: IS
1817: v_impairment_id NUMBER;
1818: v_mass_reval_id NUMBER;

Line 2358: FUNCTION fa_sorp_upg_impreval_fn(p_book VARCHAR2, p_mode VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

2354: ROLLBACK;
2355: RETURN FALSE;
2356: END fa_sorp_upg_impreval_mc_fn;
2357:
2358: FUNCTION fa_sorp_upg_impreval_fn(p_book VARCHAR2, p_mode VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
2359: RETURN BOOLEAN
2360: IS
2361: v_impairment_id NUMBER;
2362: v_mass_reval_id NUMBER;