DBA Data[Home] [Help]

APPS.FA_RATES_PKG dependencies on FA_API_TYPES

Line 15: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

11: X_CREATED_BY in NUMBER,
12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
16:
17: CURSOR C is SELECT rowid FROM fa_rates
18: where method_id = X_Method_Id
19: and year = X_Year

Line 67: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

63: X_METHOD_ID in NUMBER,
64: X_YEAR in NUMBER,
65: X_PERIOD_PLACED_IN_SERVICE in NUMBER,
66: X_RATE in NUMBER
67: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
68: CURSOR C is
69: SELECT method_id,
70: year,
71: period_placed_in_service,

Line 112: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

108: X_RATE in NUMBER,
109: X_LAST_UPDATE_DATE in DATE,
110: X_LAST_UPDATED_BY in NUMBER,
111: X_LAST_UPDATE_LOGIN in NUMBER
112: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
113:
114: begin
115: ad_zd_seed.prepare('fa_rates');
116: UPDATE fa_rates

Line 140: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

136: procedure DELETE_ROW (
137: X_METHOD_ID in NUMBER,
138: X_YEAR in NUMBER,
139: X_PERIOD_PLACED_IN_SERVICE in NUMBER
140: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
141:
142: begin
143: ad_zd_seed.prepare('fa_rates');
144: DELETE FROM fa_rates

Line 167: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

163: X_OWNER in VARCHAR2,
164: X_YEAR in NUMBER,
165: X_PERIOD_PLACED_IN_SERVICE in NUMBER,
166: X_RATE in NUMBER
167: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
168:
169: h_record_exists number(15);
170: h_rate number;
171:

Line 250: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is

246: X_LAST_UPDATE_DATE in DATE,
247: X_YEAR in NUMBER,
248: X_PERIOD_PLACED_IN_SERVICE in NUMBER,
249: X_RATE in NUMBER,
250: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
251:
252: h_record_exists number(15);
253:
254: user_id number;