APPS.FA_LOOKUPS_PKG dependencies on FA_LOOKUPS_B

Line 34: cursor C is select ROWID from FA_LOOKUPS_B

30: X_LAST_UPDATE_DATE in DATE,
31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER,
33: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
34: cursor C is select ROWID from FA_LOOKUPS_B
35: where LOOKUP_TYPE = X_LOOKUP_TYPE
36: and LOOKUP_CODE = X_LOOKUP_CODE
37: ;
38: begin

Line 39: insert into FA_LOOKUPS_B (

35: where LOOKUP_TYPE = X_LOOKUP_TYPE
36: and LOOKUP_CODE = X_LOOKUP_CODE
37: ;
38: begin
39: insert into FA_LOOKUPS_B (
40: LOOKUP_TYPE,
41: LOOKUP_CODE,
42: ENABLED_FLAG,
43: START_DATE_ACTIVE,

Line 183: from FA_LOOKUPS_B

179: ATTRIBUTE13,
180: ATTRIBUTE14,
181: ATTRIBUTE15,
182: ATTRIBUTE_CATEGORY_CODE
183: from FA_LOOKUPS_B
184: where LOOKUP_TYPE = X_LOOKUP_TYPE
185: and LOOKUP_CODE = X_LOOKUP_CODE
186: for update of LOOKUP_TYPE nowait;
187: recinfo c%rowtype;

Line 294: update FA_LOOKUPS_B set

290: X_LAST_UPDATED_BY in NUMBER,
291: X_LAST_UPDATE_LOGIN in NUMBER,
292: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
293: begin
294: update FA_LOOKUPS_B set
295: ENABLED_FLAG = X_ENABLED_FLAG,
296: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
297: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
298: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 353: delete from FA_LOOKUPS_B

349: if (sql%notfound) then
350: raise no_data_found;
351: end if;
352:
353: delete from FA_LOOKUPS_B
354: where LOOKUP_TYPE = X_LOOKUP_TYPE
355: and LOOKUP_CODE = X_LOOKUP_CODE;
356:
357: if (sql%notfound) then

Line 368: from FA_LOOKUPS_B B

364: begin
365: delete from FA_LOOKUPS_TL T
366: where not exists
367: (select NULL
368: from FA_LOOKUPS_B B
369: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
370: and B.LOOKUP_CODE = T.LOOKUP_CODE
371: );
372: