eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_PERIOD_MAPS_PKG dependencies on FA_PERIOD_MAPS

Line 1: PACKAGE BODY FA_PERIOD_MAPS_PKG as

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,

Line 18: CURSOR C is SELECT rowid FROM fa_period_maps

14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER,
16: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
17:
18: CURSOR C is SELECT rowid FROM fa_period_maps
19: WHERE nvl (year_last_period, -9999) = nvl (X_Year_Last_Period, -9999);
20:
21: begin
22:

Line 23: INSERT INTO fa_period_maps (

19: WHERE nvl (year_last_period, -9999) = nvl (X_Year_Last_Period, -9999);
20:
21: begin
22:
23: INSERT INTO fa_period_maps (
24: quarter,
25: qtr_first_period,
26: qtr_last_period,
27: year_first_period,

Line 58: calling_fn => 'fa_period_maps_pkg.insert_row'

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;

Line 77: FROM fa_period_maps

73: qtr_first_period,
74: qtr_last_period,
75: year_first_period,
76: year_last_period
77: FROM fa_period_maps
78: WHERE nvl (year_last_period, -9999) = nvl (X_Year_Last_Period, -9999)
79: FOR UPDATE of year_last_period NOWAIT;
80: Recinfo C%ROWTYPE;
81:

Line 129: UPDATE fa_period_maps

125: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
126:
127: begin
128:
129: UPDATE fa_period_maps
130: SET quarter = X_Quarter,
131: qtr_first_period = X_Qtr_First_Period,
132: qtr_last_period = X_Qtr_Last_Period,
133: year_first_period = X_Year_First_Period,

Line 147: calling_fn => 'fa_period_maps_pkg.update_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;

Line 159: DELETE FROM fa_period_maps

155: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
156:
157: begin
158:
159: DELETE FROM fa_period_maps
160: WHERE nvl (year_last_period, -9999) = nvl (X_Year_Last_Period, -9999);
161:
162: if (SQL%NOTFOUND) then
163: Raise NO_DATA_FOUND;

Line 169: calling_fn => 'fa_period_maps_pkg.delete_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;

Line 200: from fa_period_maps pm

196: user_id := fnd_load_util.owner_id (X_Owner);
197:
198: select count(*)
199: into h_record_exists
200: from fa_period_maps pm
201: where nvl (pm.year_last_period, -9999) = nvl (X_Year_Last_Period, -9999);
202:
203: if (h_record_exists > 0) then
204:

Line 207: from fa_period_maps pm

203: if (h_record_exists > 0) then
204:
205: select last_updated_by, last_update_date
206: into db_last_updated_by, db_last_update_date
207: from fa_period_maps pm
208: where nvl (pm.year_last_period, -9999) = nvl (X_Year_Last_Period, -9999);
209:
210: if (fnd_load_util.upload_test(user_id, x_last_update_date,
211: db_last_updated_by, db_last_update_date,

Line 214: fa_period_maps_pkg.update_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,

Line 226: fa_period_maps_pkg.insert_row (

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,

Line 244: CALLED_FN => 'fa_period_maps_pkg.load_row',

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;

Line 245: CALLING_FN => 'upload fa_period_maps'

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

Line 267: fa_period_maps_pkg.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,

Line 280: END FA_PERIOD_MAPS_PKG;

276: end if;
277:
278: END LOAD_SEED_ROW;
279:
280: END FA_PERIOD_MAPS_PKG;