DBA Data[Home] [Help]

APPS.FA_PERIOD_MAPS_PKG dependencies on FA_API_TYPES

Line 16: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

12: X_CREATED_BY in NUMBER,
13: X_LAST_UPDATE_DATE in DATE,
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:

Line 69: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

65: X_QTR_FIRST_PERIOD in NUMBER,
66: X_QTR_LAST_PERIOD in NUMBER,
67: X_YEAR_FIRST_PERIOD in NUMBER,
68: X_YEAR_LAST_PERIOD in NUMBER
69: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
70: CURSOR C IS
71: SELECT quarter,
72: qtr_first_period,
73: qtr_last_period,

Line 125: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

121: X_YEAR_LAST_PERIOD in NUMBER,
122: X_LAST_UPDATE_DATE in DATE,
123: X_LAST_UPDATED_BY in NUMBER,
124: X_LAST_UPDATE_LOGIN in NUMBER
125: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
126:
127: begin
128:
129: UPDATE fa_period_maps

Line 154: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

150: end UPDATE_ROW;
151:
152: procedure DELETE_ROW (
153: X_YEAR_LAST_PERIOD in NUMBER
154: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
155:
156: begin
157:
158: DELETE FROM fa_period_maps

Line 180: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

176: X_QTR_FIRST_PERIOD in NUMBER,
177: X_QTR_LAST_PERIOD in NUMBER,
178: X_YEAR_FIRST_PERIOD in NUMBER,
179: X_YEAR_LAST_PERIOD in NUMBER
180: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
181:
182: h_record_exists number(15);
183:
184: user_id number;

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

240: X_QTR_FIRST_PERIOD in NUMBER,
241: X_QTR_LAST_PERIOD in NUMBER,
242: X_YEAR_FIRST_PERIOD in NUMBER,
243: X_YEAR_LAST_PERIOD in NUMBER,
244: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
245:
246: h_record_exists number(15);
247:
248: user_id number;