1: PACKAGE BODY FA_PERIOD_MAPS_PKG as
2: /* $Header: faxipdmb.pls 120.6 2005/07/28 00:20:01 tkawamur ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,
54:
55: exception
56: when others then
57: fa_srvr_msg.add_sql_error(
58: calling_fn => 'fa_period_maps_pkg.insert_row'
59: ,p_log_level_rec => p_log_level_rec);
60: raise;
61:
62: end INSERT_ROW;
143:
144: exception
145: when others then
146: fa_srvr_msg.add_sql_error(
147: calling_fn => 'fa_period_maps_pkg.update_row'
148: ,p_log_level_rec => p_log_level_rec);
149: raise;
150:
151: end UPDATE_ROW;
165:
166: exception
167: when others then
168: fa_srvr_msg.add_sql_error(
169: calling_fn => 'fa_period_maps_pkg.delete_row'
170: ,p_log_level_rec => p_log_level_rec);
171: raise;
172:
173: end DELETE_ROW;
210: if (fnd_load_util.upload_test(user_id, x_last_update_date,
211: db_last_updated_by, db_last_update_date,
212: X_CUSTOM_MODE)) then
213:
214: fa_period_maps_pkg.update_row (
215: X_Quarter => X_Quarter,
216: X_Qtr_First_Period => X_Qtr_First_Period,
217: X_Qtr_Last_Period => X_Qtr_Last_Period,
218: X_Year_First_Period => X_Year_First_Period,
222: X_Last_Update_Login => 0
223: ,p_log_level_rec => p_log_level_rec);
224: end if;
225: else
226: fa_period_maps_pkg.insert_row (
227: X_Rowid => row_id,
228: X_Quarter => X_Quarter,
229: X_Qtr_First_Period => X_Qtr_First_Period,
230: X_Qtr_Last_Period => X_Qtr_Last_Period,
240:
241: exception
242: when others then
243: FA_STANDARD_PKG.RAISE_ERROR(
244: CALLED_FN => 'fa_period_maps_pkg.load_row',
245: CALLING_FN => 'upload fa_period_maps'
246: ,p_log_level_rec => p_log_level_rec);
247:
248: end LOAD_ROW;
263:
264: if (x_upload_mode = 'NLS') then
265: null;
266: else
267: fa_period_maps_pkg.LOAD_ROW (
268: x_custom_mode => x_custom_mode,
269: x_owner => x_owner,
270: x_last_update_date => x_last_update_date,
271: x_quarter => x_quarter,
276: end if;
277:
278: END LOAD_SEED_ROW;
279:
280: END FA_PERIOD_MAPS_PKG;