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.8 2009/04/10 07:48:50 deemitta 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) 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', p_log_level_rec => p_log_level_rec);

54:
55: exception
56: when others then
57: fa_srvr_msg.add_sql_error(
58: calling_fn => 'fa_period_maps_pkg.insert_row', p_log_level_rec => p_log_level_rec);
59: raise;
60:
61: end INSERT_ROW;
62:

Line 76: FROM fa_period_maps

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

Line 129: UPDATE fa_period_maps

125: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) 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', p_log_level_rec => p_log_level_rec);

143:
144: exception
145: when others then
146: fa_srvr_msg.add_sql_error(
147: calling_fn => 'fa_period_maps_pkg.update_row', p_log_level_rec => p_log_level_rec);
148: raise;
149:
150: end UPDATE_ROW;
151:

Line 158: DELETE FROM fa_period_maps

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

Line 168: calling_fn => 'fa_period_maps_pkg.delete_row', p_log_level_rec => p_log_level_rec);

164:
165: exception
166: when others then
167: fa_srvr_msg.add_sql_error(
168: calling_fn => 'fa_period_maps_pkg.delete_row', p_log_level_rec => p_log_level_rec);
169: raise;
170:
171: end DELETE_ROW;
172:

Line 197: from fa_period_maps pm

193: end if;
194:
195: select count(*)
196: into h_record_exists
197: from fa_period_maps pm
198: where nvl (pm.year_last_period, -9999) = nvl (X_Year_Last_Period, -9999);
199:
200: if (h_record_exists > 0) then
201: fa_period_maps_pkg.update_row (

Line 201: fa_period_maps_pkg.update_row (

197: from fa_period_maps pm
198: where nvl (pm.year_last_period, -9999) = nvl (X_Year_Last_Period, -9999);
199:
200: if (h_record_exists > 0) then
201: fa_period_maps_pkg.update_row (
202: X_Quarter => X_Quarter,
203: X_Qtr_First_Period => X_Qtr_First_Period,
204: X_Qtr_Last_Period => X_Qtr_Last_Period,
205: X_Year_First_Period => X_Year_First_Period,

Line 212: fa_period_maps_pkg.insert_row (

208: X_Last_Updated_By => user_id,
209: X_Last_Update_Login => 0
210: , p_log_level_rec => p_log_level_rec);
211: else
212: fa_period_maps_pkg.insert_row (
213: X_Rowid => row_id,
214: X_Quarter => X_Quarter,
215: X_Qtr_First_Period => X_Qtr_First_Period,
216: X_Qtr_Last_Period => X_Qtr_Last_Period,

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

226:
227: exception
228: when others then
229: FA_STANDARD_PKG.RAISE_ERROR(
230: CALLED_FN => 'fa_period_maps_pkg.load_row',
231: CALLING_FN => 'upload fa_period_maps', p_log_level_rec => p_log_level_rec);
232:
233: end LOAD_ROW;
234: /*Bug 8355119 overloading function for release specific signatures*/

Line 231: CALLING_FN => 'upload fa_period_maps', p_log_level_rec => p_log_level_rec);

227: exception
228: when others then
229: FA_STANDARD_PKG.RAISE_ERROR(
230: CALLED_FN => 'fa_period_maps_pkg.load_row',
231: CALLING_FN => 'upload fa_period_maps', p_log_level_rec => p_log_level_rec);
232:
233: end LOAD_ROW;
234: /*Bug 8355119 overloading function for release specific signatures*/
235: procedure LOAD_ROW (

Line 260: from fa_period_maps pm

256: user_id := fnd_load_util.owner_id (X_Owner);
257:
258: select count(*)
259: into h_record_exists
260: from fa_period_maps pm
261: where nvl (pm.year_last_period, -9999) = nvl (X_Year_Last_Period, -9999);
262:
263: if (h_record_exists > 0) then
264:

Line 267: from fa_period_maps pm

263: if (h_record_exists > 0) then
264:
265: select last_updated_by, last_update_date
266: into db_last_updated_by, db_last_update_date
267: from fa_period_maps pm
268: where nvl (pm.year_last_period, -9999) = nvl (X_Year_Last_Period, -9999);
269:
270: if (fnd_load_util.upload_test(user_id, x_last_update_date,
271: db_last_updated_by, db_last_update_date,

Line 274: fa_period_maps_pkg.update_row (

270: if (fnd_load_util.upload_test(user_id, x_last_update_date,
271: db_last_updated_by, db_last_update_date,
272: X_CUSTOM_MODE)) then
273:
274: fa_period_maps_pkg.update_row (
275: X_Quarter => X_Quarter,
276: X_Qtr_First_Period => X_Qtr_First_Period,
277: X_Qtr_Last_Period => X_Qtr_Last_Period,
278: X_Year_First_Period => X_Year_First_Period,

Line 286: fa_period_maps_pkg.insert_row (

282: X_Last_Update_Login => 0
283: ,p_log_level_rec => p_log_level_rec);
284: end if;
285: else
286: fa_period_maps_pkg.insert_row (
287: X_Rowid => row_id,
288: X_Quarter => X_Quarter,
289: X_Qtr_First_Period => X_Qtr_First_Period,
290: X_Qtr_Last_Period => X_Qtr_Last_Period,

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

300:
301: exception
302: when others then
303: FA_STANDARD_PKG.RAISE_ERROR(
304: CALLED_FN => 'fa_period_maps_pkg.load_row',
305: CALLING_FN => 'upload fa_period_maps'
306: ,p_log_level_rec => p_log_level_rec);
307:
308: end LOAD_ROW;

Line 305: CALLING_FN => 'upload fa_period_maps'

301: exception
302: when others then
303: FA_STANDARD_PKG.RAISE_ERROR(
304: CALLED_FN => 'fa_period_maps_pkg.load_row',
305: CALLING_FN => 'upload fa_period_maps'
306: ,p_log_level_rec => p_log_level_rec);
307:
308: end LOAD_ROW;
309: /*bug 8355119 adding R12 specific funtion LOAD_SEED_ROW*/

Line 327: fa_period_maps_pkg.LOAD_ROW (

323:
324: if (x_upload_mode = 'NLS') then
325: null;
326: else
327: fa_period_maps_pkg.LOAD_ROW (
328: x_custom_mode => x_custom_mode,
329: x_owner => x_owner,
330: x_last_update_date => x_last_update_date,
331: x_quarter => x_quarter,

Line 341: END FA_PERIOD_MAPS_PKG;

337:
338: END LOAD_SEED_ROW;
339:
340:
341: END FA_PERIOD_MAPS_PKG;