APPS.FA_LOOKUP_TYPES_PKG dependencies on FA_LOOKUP_TYPES_B

Line 15: cursor C is select ROWID from FA_LOOKUP_TYPES_B

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 default null) is
15: cursor C is select ROWID from FA_LOOKUP_TYPES_B
16: where LOOKUP_TYPE = X_LOOKUP_TYPE
17: ;
18: begin
19: insert into FA_LOOKUP_TYPES_B (

Line 19: insert into FA_LOOKUP_TYPES_B (

15: cursor C is select ROWID from FA_LOOKUP_TYPES_B
16: where LOOKUP_TYPE = X_LOOKUP_TYPE
17: ;
18: begin
19: insert into FA_LOOKUP_TYPES_B (
20: LOOKUP_TYPE,
21: USER_MAINTAINABLE,
22: CREATION_DATE,
23: CREATED_BY,

Line 85: from FA_LOOKUP_TYPES_B

81: X_DESCRIPTION in VARCHAR2,
82: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
83: cursor c is select
84: USER_MAINTAINABLE
85: from FA_LOOKUP_TYPES_B
86: where LOOKUP_TYPE = X_LOOKUP_TYPE
87: for update of LOOKUP_TYPE nowait;
88: recinfo c%rowtype;
89:

Line 138: update FA_LOOKUP_TYPES_B set

134: X_LAST_UPDATED_BY in NUMBER,
135: X_LAST_UPDATE_LOGIN in NUMBER,
136: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
137: begin
138: update FA_LOOKUP_TYPES_B set
139: USER_MAINTAINABLE = X_USER_MAINTAINABLE,
140: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
141: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
142: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 175: delete from FA_LOOKUP_TYPES_B

171: if (sql%notfound) then
172: raise no_data_found;
173: end if;
174:
175: delete from FA_LOOKUP_TYPES_B
176: where LOOKUP_TYPE = X_LOOKUP_TYPE;
177:
178: if (sql%notfound) then
179: raise no_data_found;

Line 189: from FA_LOOKUP_TYPES_B B

185: begin
186: delete from FA_LOOKUP_TYPES_TL T
187: where not exists
188: (select NULL
189: from FA_LOOKUP_TYPES_B B
190: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
191: );
192:
193: update FA_LOOKUP_TYPES_TL T set (