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 default null) 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 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:

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

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

Line 125: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) 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 default null) is
126:
127: begin
128:
129: UPDATE fa_period_maps

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

151: end UPDATE_ROW;
152:
153: procedure DELETE_ROW (
154: X_YEAR_LAST_PERIOD in NUMBER,
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

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

180: X_QTR_FIRST_PERIOD in NUMBER,
181: X_QTR_LAST_PERIOD in NUMBER,
182: X_YEAR_FIRST_PERIOD in NUMBER,
183: X_YEAR_LAST_PERIOD in NUMBER,
184: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
185:
186: h_record_exists number(15);
187:
188: user_id number;