1: PACKAGE FA_UTIL_PVT AUTHID CURRENT_USER as
2: /* $Header: FAVUTILS.pls 120.9 2010/08/25 17:52:25 dvjoshi ship $ */
3:
4: FUNCTION get_asset_fin_rec
5: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7: p_transaction_header_id IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE DEFAULT NULL,
8: p_mrc_sob_type_code IN VARCHAR2
9: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null ) RETURN BOOLEAN;
2: /* $Header: FAVUTILS.pls 120.9 2010/08/25 17:52:25 dvjoshi ship $ */
3:
4: FUNCTION get_asset_fin_rec
5: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7: p_transaction_header_id IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE DEFAULT NULL,
8: p_mrc_sob_type_code IN VARCHAR2
9: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null ) RETURN BOOLEAN;
10:
5: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7: p_transaction_header_id IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE DEFAULT NULL,
8: p_mrc_sob_type_code IN VARCHAR2
9: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null ) RETURN BOOLEAN;
10:
11:
12: FUNCTION get_asset_deprn_rec
13: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
9: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null ) RETURN BOOLEAN;
10:
11:
12: FUNCTION get_asset_deprn_rec
13: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
15: p_period_counter IN FA_DEPRN_SUMMARY.period_counter%TYPE DEFAULT NULL,
16: p_mrc_sob_type_code IN VARCHAR2
17: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
10:
11:
12: FUNCTION get_asset_deprn_rec
13: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
15: p_period_counter IN FA_DEPRN_SUMMARY.period_counter%TYPE DEFAULT NULL,
16: p_mrc_sob_type_code IN VARCHAR2
17: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
18: ) RETURN BOOLEAN;
13: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
14: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
15: p_period_counter IN FA_DEPRN_SUMMARY.period_counter%TYPE DEFAULT NULL,
16: p_mrc_sob_type_code IN VARCHAR2
17: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
18: ) RETURN BOOLEAN;
19:
20: FUNCTION get_asset_cat_rec
21: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
17: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
18: ) RETURN BOOLEAN;
19:
20: FUNCTION get_asset_cat_rec
21: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
22: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
23: p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL
24: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type
25: ) RETURN BOOLEAN;
18: ) RETURN BOOLEAN;
19:
20: FUNCTION get_asset_cat_rec
21: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
22: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
23: p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL
24: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type
25: ) RETURN BOOLEAN;
26:
20: FUNCTION get_asset_cat_rec
21: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
22: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
23: p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL
24: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type
25: ) RETURN BOOLEAN;
26:
27: FUNCTION get_asset_type_rec
28: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
24: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type
25: ) RETURN BOOLEAN;
26:
27: FUNCTION get_asset_type_rec
28: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
29: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
30: p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL
31: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type
32: ) RETURN BOOLEAN;
25: ) RETURN BOOLEAN;
26:
27: FUNCTION get_asset_type_rec
28: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
29: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
30: p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL
31: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type
32: ) RETURN BOOLEAN;
33:
27: FUNCTION get_asset_type_rec
28: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
29: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
30: p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL
31: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type
32: ) RETURN BOOLEAN;
33:
34: FUNCTION get_asset_desc_rec
35: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
31: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type
32: ) RETURN BOOLEAN;
33:
34: FUNCTION get_asset_desc_rec
35: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
36: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type
37: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
38:
39: FUNCTION get_inv_rec
32: ) RETURN BOOLEAN;
33:
34: FUNCTION get_asset_desc_rec
35: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
36: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type
37: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
38:
39: FUNCTION get_inv_rec
40: (px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
33:
34: FUNCTION get_asset_desc_rec
35: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
36: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type
37: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
38:
39: FUNCTION get_inv_rec
40: (px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
41: p_mrc_sob_type_code IN VARCHAR2,
36: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type
37: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
38:
39: FUNCTION get_inv_rec
40: (px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
41: p_mrc_sob_type_code IN VARCHAR2,
42: p_set_of_books_id IN NUMBER,
43: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type DEFAULT NULL
44: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
39: FUNCTION get_inv_rec
40: (px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
41: p_mrc_sob_type_code IN VARCHAR2,
42: p_set_of_books_id IN NUMBER,
43: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type DEFAULT NULL
44: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
45:
46: -----------------------------------------------------------------------------
47: -- NAME check_asset_key_req |
40: (px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
41: p_mrc_sob_type_code IN VARCHAR2,
42: p_set_of_books_id IN NUMBER,
43: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type DEFAULT NULL
44: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
45:
46: -----------------------------------------------------------------------------
47: -- NAME check_asset_key_req |
48: -- |
57: FUNCTION check_asset_key_req
58: (p_asset_key_chart_id IN NUMBER,
59: p_asset_key_required OUT NOCOPY BOOLEAN,
60: p_calling_fn IN VARCHAR2
61: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
62:
63: -- Added for Retirement API
64: FUNCTION get_current_units
65: (p_calling_fn in VARCHAR2
64: FUNCTION get_current_units
65: (p_calling_fn in VARCHAR2
66: ,p_asset_id in NUMBER
67: ,x_current_units out NOCOPY NUMBER
68: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
69:
70: FUNCTION get_latest_trans_date
71: (p_calling_fn in VARCHAR2
72: ,p_asset_id in NUMBER
71: (p_calling_fn in VARCHAR2
72: ,p_asset_id in NUMBER
73: ,p_book in VARCHAR2
74: ,x_latest_trans_date out NOCOPY DATE
75: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
76:
77: -- This can be used by other APIs if necessary
78: FUNCTION get_period_rec
79: (p_book in varchar2
78: FUNCTION get_period_rec
79: (p_book in varchar2
80: ,p_period_counter in number default null
81: ,p_effective_date in date default null
82: ,x_period_rec out NOCOPY FA_API_TYPES.period_rec_type
83: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN;
84:
85: -- This populates retirement info.
86: -- Need to set set_of_books id first
79: (p_book in varchar2
80: ,p_period_counter in number default null
81: ,p_effective_date in date default null
82: ,x_period_rec out NOCOPY FA_API_TYPES.period_rec_type
83: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN;
84:
85: -- This populates retirement info.
86: -- Need to set set_of_books id first
87: -- Input: retirement_id is required before calling this
86: -- Need to set set_of_books id first
87: -- Input: retirement_id is required before calling this
88:
89: FUNCTION get_asset_retire_rec
90: (px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type,
91: p_mrc_sob_type_code IN VARCHAR2,
92: p_set_of_books_id IN NUMBER
93: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN;
94:
89: FUNCTION get_asset_retire_rec
90: (px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type,
91: p_mrc_sob_type_code IN VARCHAR2,
92: p_set_of_books_id IN NUMBER
93: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN;
94:
95: -- End of Retirement API
96:
97: FUNCTION get_corp_book( p_asset_id IN NUMBER,
95: -- End of Retirement API
96:
97: FUNCTION get_corp_book( p_asset_id IN NUMBER,
98: p_corp_book IN OUT NOCOPY VARCHAR2
99: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean;
100:
101: PROCEDURE load_char_value
102: (p_char_old IN VARCHAR2,
103: p_char_adj IN VARCHAR2,
101: PROCEDURE load_char_value
102: (p_char_old IN VARCHAR2,
103: p_char_adj IN VARCHAR2,
104: x_char_new IN OUT NOCOPY VARCHAR2
105: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
106:
107: PROCEDURE load_date_value
108: (p_date_old IN VARCHAR2,
109: p_date_adj IN VARCHAR2,
107: PROCEDURE load_date_value
108: (p_date_old IN VARCHAR2,
109: p_date_adj IN VARCHAR2,
110: x_date_new IN OUT NOCOPY VARCHAR2
111: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
112:
113: PROCEDURE load_num_value
114: (p_num_old IN VARCHAR2,
115: p_num_adj IN VARCHAR2,
113: PROCEDURE load_num_value
114: (p_num_old IN VARCHAR2,
115: p_num_adj IN VARCHAR2,
116: x_num_new IN OUT NOCOPY VARCHAR2
117: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
118:
119: FUNCTION check_deprn_run
120: (X_book IN VARCHAR2,
121: X_asset_id IN NUMBER DEFAULT 0,
119: FUNCTION check_deprn_run
120: (X_book IN VARCHAR2,
121: X_asset_id IN NUMBER DEFAULT 0,
122: X_deprn_amount OUT NOCOPY NUMBER,
123: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN;
124:
125: /* Added for bug 9891692. See BCT for details.
126: Use this functions in PL-SQL only after initialization of cache.
127: */