APPS.FA_LOOKUP_TYPES_PKG dependencies on FA_API_TYPES

Line 14: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

10: X_CREATED_BY in NUMBER,
11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER
14: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
15: cursor C is select ROWID from FA_LOOKUP_TYPES_B
16: where LOOKUP_TYPE = X_LOOKUP_TYPE
17: ;
18: begin

Line 84: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

80: X_LOOKUP_TYPE in VARCHAR2,
81: X_USER_MAINTAINABLE in VARCHAR2,
82: X_MEANING in VARCHAR2,
83: X_DESCRIPTION in VARCHAR2
84: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
85: cursor c is select
86: USER_MAINTAINABLE
87: from FA_LOOKUP_TYPES_B
88: where LOOKUP_TYPE = X_LOOKUP_TYPE

Line 140: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

136: X_DESCRIPTION in VARCHAR2,
137: X_LAST_UPDATE_DATE in DATE,
138: X_LAST_UPDATED_BY in NUMBER,
139: X_LAST_UPDATE_LOGIN in NUMBER
140: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
141: begin
142: ad_zd_seed.prepare('FA_LOOKUP_TYPES_B');
143: ad_zd_seed.prepare('FA_LOOKUP_TYPES_TL');
144: update FA_LOOKUP_TYPES_B set

Line 172: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

168: end UPDATE_ROW;
169:
170: procedure DELETE_ROW (
171: X_LOOKUP_TYPE in VARCHAR2
172: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
173: begin
174: ad_zd_seed.prepare('FA_LOOKUP_TYPES_B');
175: ad_zd_seed.prepare('FA_LOOKUP_TYPES_TL');
176: delete from FA_LOOKUP_TYPES_TL

Line 201: procedure ADD_LANGUAGE(p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

197: from FA_LOOKUP_TYPES_B B
198: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
199: );*/
200: /* bug 8355119*/
201: procedure ADD_LANGUAGE(p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
202: is
203: begin
204: delete from FA_LOOKUP_TYPES_TL T
205: where not exists

Line 271: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

267: X_OWNER in VARCHAR2,
268: X_MEANING in VARCHAR2,
269: X_DESCRIPTION in VARCHAR2,
270: X_USER_MAINTAINABLE in VARCHAR2
271: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
272:
273: h_record_exists number(15);
274:
275: user_id number;

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

329: X_LAST_UPDATE_DATE in DATE,
330: X_MEANING in VARCHAR2,
331: X_DESCRIPTION in VARCHAR2,
332: X_USER_MAINTAINABLE in VARCHAR2,
333: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
334:
335: h_record_exists number(15);
336:
337: user_id number;

Line 402: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is

398: X_LOOKUP_TYPE in VARCHAR2,
399: X_OWNER in VARCHAR2,
400: X_MEANING in VARCHAR2,
401: X_DESCRIPTION in VARCHAR2
402: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
403:
404: user_id number;
405:
406: begin

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

437: X_OWNER in VARCHAR2,
438: X_LAST_UPDATE_DATE in DATE,
439: X_MEANING in VARCHAR2,
440: X_DESCRIPTION in VARCHAR2,
441: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
442:
443: user_id number;
444:
445: db_last_updated_by number;