APPS.AS_SALES_LEAD_QUALS_PKG dependencies on AS_SALES_LEAD_QUALS_TL

Line 52: insert into AS_SALES_LEAD_QUALS_TL (

48: X_LAST_UPDATED_BY,
49: X_LAST_UPDATE_LOGIN
50: );
51:
52: insert into AS_SALES_LEAD_QUALS_TL (
53: SEED_QUAL_ID,
54: LAST_UPDATE_DATE,
55: LAST_UPDATED_BY,
56: CREATION_DATE,

Line 78: from AS_SALES_LEAD_QUALS_TL T

74: from FND_LANGUAGES L
75: where L.INSTALLED_FLAG in ('I', 'B')
76: and not exists
77: (select NULL
78: from AS_SALES_LEAD_QUALS_TL T
79: where T.SEED_QUAL_ID = X_SEED_QUAL_ID
80: and T.LANGUAGE = L.LANGUAGE_CODE);
81:
82: open c;

Line 119: from AS_SALES_LEAD_QUALS_TL

115: cursor c1 is select
116: MEANING,
117: DESCRIPTION,
118: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
119: from AS_SALES_LEAD_QUALS_TL
120: where SEED_QUAL_ID = X_SEED_QUAL_ID
121: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
122: for update of SEED_QUAL_ID nowait;
123: begin

Line 194: update AS_SALES_LEAD_QUALS_TL set

190: if (sql%notfound) then
191: raise no_data_found;
192: end if;
193:
194: update AS_SALES_LEAD_QUALS_TL set
195: MEANING = X_MEANING,
196: DESCRIPTION = X_DESCRIPTION,
197: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
198: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 213: delete from AS_SALES_LEAD_QUALS_TL

209: procedure DELETE_ROW (
210: X_SEED_QUAL_ID in NUMBER
211: ) is
212: begin
213: delete from AS_SALES_LEAD_QUALS_TL
214: where SEED_QUAL_ID = X_SEED_QUAL_ID;
215:
216: if (sql%notfound) then
217: raise no_data_found;

Line 305: delete from AS_SALES_LEAD_QUALS_TL T

301:
302: procedure ADD_LANGUAGE
303: is
304: begin
305: delete from AS_SALES_LEAD_QUALS_TL T
306: where not exists
307: (select NULL
308: from AS_SALES_LEAD_QUALS_B B
309: where B.SEED_QUAL_ID = T.SEED_QUAL_ID

Line 312: update AS_SALES_LEAD_QUALS_TL T set (

308: from AS_SALES_LEAD_QUALS_B B
309: where B.SEED_QUAL_ID = T.SEED_QUAL_ID
310: );
311:
312: update AS_SALES_LEAD_QUALS_TL T set (
313: MEANING,
314: DESCRIPTION
315: ) = (select
316: B.MEANING,

Line 318: from AS_SALES_LEAD_QUALS_TL B

314: DESCRIPTION
315: ) = (select
316: B.MEANING,
317: B.DESCRIPTION
318: from AS_SALES_LEAD_QUALS_TL B
319: where B.SEED_QUAL_ID = T.SEED_QUAL_ID
320: and B.LANGUAGE = T.SOURCE_LANG)
321: where (
322: T.SEED_QUAL_ID,

Line 327: from AS_SALES_LEAD_QUALS_TL SUBB, AS_SALES_LEAD_QUALS_TL SUBT

323: T.LANGUAGE
324: ) in (select
325: SUBT.SEED_QUAL_ID,
326: SUBT.LANGUAGE
327: from AS_SALES_LEAD_QUALS_TL SUBB, AS_SALES_LEAD_QUALS_TL SUBT
328: where SUBB.SEED_QUAL_ID = SUBT.SEED_QUAL_ID
329: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
330: and (SUBB.MEANING <> SUBT.MEANING
331: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 336: insert into AS_SALES_LEAD_QUALS_TL (

332: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
333: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
334: ));
335:
336: insert into AS_SALES_LEAD_QUALS_TL (
337: SEED_QUAL_ID,
338: LAST_UPDATE_DATE,
339: LAST_UPDATED_BY,
340: CREATION_DATE,

Line 358: from AS_SALES_LEAD_QUALS_TL B, FND_LANGUAGES L

354: B.MEANING,
355: B.DESCRIPTION,
356: L.LANGUAGE_CODE,
357: B.SOURCE_LANG
358: from AS_SALES_LEAD_QUALS_TL B, FND_LANGUAGES L
359: where L.INSTALLED_FLAG in ('I', 'B')
360: and B.LANGUAGE = userenv('LANG')
361: and not exists
362: (select NULL

Line 363: from AS_SALES_LEAD_QUALS_TL T

359: where L.INSTALLED_FLAG in ('I', 'B')
360: and B.LANGUAGE = userenv('LANG')
361: and not exists
362: (select NULL
363: from AS_SALES_LEAD_QUALS_TL T
364: where T.SEED_QUAL_ID = B.SEED_QUAL_ID
365: and T.LANGUAGE = L.LANGUAGE_CODE);
366: end ADD_LANGUAGE;
367:

Line 376: update AS_SALES_LEAD_QUALS_TL

372: X_OWNER in VARCHAR2)
373: IS
374: begin
375: -- only update rows that have not been altered by user
376: update AS_SALES_LEAD_QUALS_TL
377: set description = X_DESCRIPTION,
378: meaning = X_MEANING,
379: source_lang = userenv('LANG'),
380: last_update_date = sysdate,