DBA Data[Home] [Help]

APPS.FA_UTIL_PVT dependencies on FA_API_TYPES

Line 5: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,

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;

Line 6: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

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:

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

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,

Line 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

Line 14: px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,

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;

Line 17: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null

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,

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

Line 22: px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,

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:

Line 24: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type

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,

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

Line 29: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_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;
33:

Line 31: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type

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,

Line 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

Line 36: px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_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
40: (px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,

Line 37: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) 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,
41: p_mrc_sob_type_code IN VARCHAR2,

Line 40: (px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_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,
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;

Line 43: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type DEFAULT NULL

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 |

Line 44: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;

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: -- |

Line 61: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;

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

Line 68: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

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

Line 75: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

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

Line 82: ,x_period_rec out NOCOPY FA_API_TYPES.period_rec_type

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

Line 83: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN;

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

Line 90: (px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type,

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:

Line 93: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN;

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,

Line 99: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean;

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,

Line 105: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);

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,

Line 111: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);

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,

Line 117: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);

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,

Line 123: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return BOOLEAN;

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: */