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