APPS.AHL_WARRANTY_TMPL_CTR_PKG dependencies on AHL_WARRANTY_TMPL_CTR_TL

Line 96: insert into AHL_WARRANTY_TMPL_CTR_TL (

92: X_LAST_UPDATED_BY,
93: X_LAST_UPDATE_LOGIN
94: );
95:
96: insert into AHL_WARRANTY_TMPL_CTR_TL (
97: WARRANTY_TMPL_COUNTER_ID,
98: TERMS_AND_CONDITIONS,
99: REACTION_AND_RESOL_TIME,
100: SERVICE_LEVEL_AGREEMENT,

Line 126: from AHL_WARRANTY_TMPL_CTR_TL T

122: from FND_LANGUAGES L
123: where L.INSTALLED_FLAG in ('I', 'B')
124: and not exists
125: (select NULL
126: from AHL_WARRANTY_TMPL_CTR_TL T
127: where T.WARRANTY_TMPL_COUNTER_ID = X_WARRANTY_TMPL_COUNTER_ID
128: and T.LANGUAGE = L.LANGUAGE_CODE);
129:
130: open c;

Line 199: from AHL_WARRANTY_TMPL_CTR_TL

195: REACTION_AND_RESOL_TIME,
196: SERVICE_LEVEL_AGREEMENT,
197: REMARKS,
198: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
199: from AHL_WARRANTY_TMPL_CTR_TL
200: where WARRANTY_TMPL_COUNTER_ID = X_WARRANTY_TMPL_COUNTER_ID
201: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
202: for update of WARRANTY_TMPL_COUNTER_ID nowait;
203: begin

Line 337: update AHL_WARRANTY_TMPL_CTR_TL set

333: if (sql%notfound) then
334: raise no_data_found;
335: end if;
336:
337: update AHL_WARRANTY_TMPL_CTR_TL set
338: TERMS_AND_CONDITIONS = X_TERMS_AND_CONDITIONS,
339: REACTION_AND_RESOL_TIME = X_REACTION_AND_RESOL_TIME,
340: SERVICE_LEVEL_AGREEMENT = X_SERVICE_LEVEL_AGREEMENT,
341: REMARKS = X_REMARKS,

Line 358: delete from AHL_WARRANTY_TMPL_CTR_TL

354: procedure DELETE_ROW (
355: X_WARRANTY_TMPL_COUNTER_ID in NUMBER
356: ) is
357: begin
358: delete from AHL_WARRANTY_TMPL_CTR_TL
359: where WARRANTY_TMPL_COUNTER_ID = X_WARRANTY_TMPL_COUNTER_ID;
360:
361: if (sql%notfound) then
362: raise no_data_found;

Line 376: delete from AHL_WARRANTY_TMPL_CTR_TL T

372:
373: procedure ADD_LANGUAGE
374: is
375: begin
376: delete from AHL_WARRANTY_TMPL_CTR_TL T
377: where not exists
378: (select NULL
379: from AHL_WARRANTY_TMPL_CTR_B B
380: where B.WARRANTY_TMPL_COUNTER_ID = T.WARRANTY_TMPL_COUNTER_ID

Line 383: update AHL_WARRANTY_TMPL_CTR_TL T set (

379: from AHL_WARRANTY_TMPL_CTR_B B
380: where B.WARRANTY_TMPL_COUNTER_ID = T.WARRANTY_TMPL_COUNTER_ID
381: );
382:
383: update AHL_WARRANTY_TMPL_CTR_TL T set (
384: TERMS_AND_CONDITIONS,
385: REACTION_AND_RESOL_TIME,
386: SERVICE_LEVEL_AGREEMENT,
387: REMARKS

Line 393: from AHL_WARRANTY_TMPL_CTR_TL B

389: B.TERMS_AND_CONDITIONS,
390: B.REACTION_AND_RESOL_TIME,
391: B.SERVICE_LEVEL_AGREEMENT,
392: B.REMARKS
393: from AHL_WARRANTY_TMPL_CTR_TL B
394: where B.WARRANTY_TMPL_COUNTER_ID = T.WARRANTY_TMPL_COUNTER_ID
395: and B.LANGUAGE = T.SOURCE_LANG)
396: where (
397: T.WARRANTY_TMPL_COUNTER_ID,

Line 402: from AHL_WARRANTY_TMPL_CTR_TL SUBB, AHL_WARRANTY_TMPL_CTR_TL SUBT

398: T.LANGUAGE
399: ) in (select
400: SUBT.WARRANTY_TMPL_COUNTER_ID,
401: SUBT.LANGUAGE
402: from AHL_WARRANTY_TMPL_CTR_TL SUBB, AHL_WARRANTY_TMPL_CTR_TL SUBT
403: where SUBB.WARRANTY_TMPL_COUNTER_ID = SUBT.WARRANTY_TMPL_COUNTER_ID
404: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
405: and (SUBB.TERMS_AND_CONDITIONS <> SUBT.TERMS_AND_CONDITIONS
406: or (SUBB.TERMS_AND_CONDITIONS is null and SUBT.TERMS_AND_CONDITIONS is not null)

Line 419: insert into AHL_WARRANTY_TMPL_CTR_TL (

415: or (SUBB.REMARKS is null and SUBT.REMARKS is not null)
416: or (SUBB.REMARKS is not null and SUBT.REMARKS is null)
417: ));
418:
419: insert into AHL_WARRANTY_TMPL_CTR_TL (
420: WARRANTY_TMPL_COUNTER_ID,
421: TERMS_AND_CONDITIONS,
422: REACTION_AND_RESOL_TIME,
423: SERVICE_LEVEL_AGREEMENT,

Line 445: from AHL_WARRANTY_TMPL_CTR_TL B, FND_LANGUAGES L

441: B.CREATED_BY,
442: B.LAST_UPDATE_LOGIN,
443: L.LANGUAGE_CODE,
444: B.SOURCE_LANG
445: from AHL_WARRANTY_TMPL_CTR_TL B, FND_LANGUAGES L
446: where L.INSTALLED_FLAG in ('I', 'B')
447: and B.LANGUAGE = userenv('LANG')
448: and not exists
449: (select NULL

Line 450: from AHL_WARRANTY_TMPL_CTR_TL T

446: where L.INSTALLED_FLAG in ('I', 'B')
447: and B.LANGUAGE = userenv('LANG')
448: and not exists
449: (select NULL
450: from AHL_WARRANTY_TMPL_CTR_TL T
451: where T.WARRANTY_TMPL_COUNTER_ID = B.WARRANTY_TMPL_COUNTER_ID
452: and T.LANGUAGE = L.LANGUAGE_CODE);
453: end ADD_LANGUAGE;
454: