APPS.AHL_WARRANTY_TEMPLATES_PKG dependencies on AHL_WARRANTY_TEMPLATES_TL

Line 124: insert into AHL_WARRANTY_TEMPLATES_TL (

120: X_LAST_UPDATED_BY,
121: X_LAST_UPDATE_LOGIN
122: );
123:
124: insert into AHL_WARRANTY_TEMPLATES_TL (
125: WARRANTY_TEMPLATE_ID,
126: DESCRIPTION,
127: TERMS_AND_CONDITIONS,
128: REACTION_AND_RESOL_TIME,

Line 156: from AHL_WARRANTY_TEMPLATES_TL T

152: from FND_LANGUAGES L
153: where L.INSTALLED_FLAG in ('I', 'B')
154: and not exists
155: (select NULL
156: from AHL_WARRANTY_TEMPLATES_TL T
157: where T.WARRANTY_TEMPLATE_ID = X_WARRANTY_TEMPLATE_ID
158: and T.LANGUAGE = L.LANGUAGE_CODE);
159:
160: open c;

Line 249: from AHL_WARRANTY_TEMPLATES_TL

245: REACTION_AND_RESOL_TIME,
246: SERVICE_LEVEL_AGREEMENT,
247: REMARKS,
248: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
249: from AHL_WARRANTY_TEMPLATES_TL
250: where WARRANTY_TEMPLATE_ID = X_WARRANTY_TEMPLATE_ID
251: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
252: for update of WARRANTY_TEMPLATE_ID nowait;
253: begin

Line 424: update AHL_WARRANTY_TEMPLATES_TL set

420: if (sql%notfound) then
421: raise no_data_found;
422: end if;
423:
424: update AHL_WARRANTY_TEMPLATES_TL set
425: DESCRIPTION = X_DESCRIPTION,
426: TERMS_AND_CONDITIONS = X_TERMS_AND_CONDITIONS,
427: REACTION_AND_RESOL_TIME = X_REACTION_AND_RESOL_TIME,
428: SERVICE_LEVEL_AGREEMENT = X_SERVICE_LEVEL_AGREEMENT,

Line 446: delete from AHL_WARRANTY_TEMPLATES_TL

442: procedure DELETE_ROW (
443: X_WARRANTY_TEMPLATE_ID in NUMBER
444: ) is
445: begin
446: delete from AHL_WARRANTY_TEMPLATES_TL
447: where WARRANTY_TEMPLATE_ID = X_WARRANTY_TEMPLATE_ID;
448:
449: if (sql%notfound) then
450: raise no_data_found;

Line 464: delete from AHL_WARRANTY_TEMPLATES_TL T

460:
461: procedure ADD_LANGUAGE
462: is
463: begin
464: delete from AHL_WARRANTY_TEMPLATES_TL T
465: where not exists
466: (select NULL
467: from AHL_WARRANTY_TEMPLATES_B B
468: where B.WARRANTY_TEMPLATE_ID = T.WARRANTY_TEMPLATE_ID

Line 471: update AHL_WARRANTY_TEMPLATES_TL T set (

467: from AHL_WARRANTY_TEMPLATES_B B
468: where B.WARRANTY_TEMPLATE_ID = T.WARRANTY_TEMPLATE_ID
469: );
470:
471: update AHL_WARRANTY_TEMPLATES_TL T set (
472: DESCRIPTION,
473: TERMS_AND_CONDITIONS,
474: REACTION_AND_RESOL_TIME,
475: SERVICE_LEVEL_AGREEMENT,

Line 483: from AHL_WARRANTY_TEMPLATES_TL B

479: B.TERMS_AND_CONDITIONS,
480: B.REACTION_AND_RESOL_TIME,
481: B.SERVICE_LEVEL_AGREEMENT,
482: B.REMARKS
483: from AHL_WARRANTY_TEMPLATES_TL B
484: where B.WARRANTY_TEMPLATE_ID = T.WARRANTY_TEMPLATE_ID
485: and B.LANGUAGE = T.SOURCE_LANG)
486: where (
487: T.WARRANTY_TEMPLATE_ID,

Line 492: from AHL_WARRANTY_TEMPLATES_TL SUBB, AHL_WARRANTY_TEMPLATES_TL SUBT

488: T.LANGUAGE
489: ) in (select
490: SUBT.WARRANTY_TEMPLATE_ID,
491: SUBT.LANGUAGE
492: from AHL_WARRANTY_TEMPLATES_TL SUBB, AHL_WARRANTY_TEMPLATES_TL SUBT
493: where SUBB.WARRANTY_TEMPLATE_ID = SUBT.WARRANTY_TEMPLATE_ID
494: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
495: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
496: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 512: insert into AHL_WARRANTY_TEMPLATES_TL (

508: or (SUBB.REMARKS is null and SUBT.REMARKS is not null)
509: or (SUBB.REMARKS is not null and SUBT.REMARKS is null)
510: ));
511:
512: insert into AHL_WARRANTY_TEMPLATES_TL (
513: WARRANTY_TEMPLATE_ID,
514: DESCRIPTION,
515: TERMS_AND_CONDITIONS,
516: REACTION_AND_RESOL_TIME,

Line 540: from AHL_WARRANTY_TEMPLATES_TL B, FND_LANGUAGES L

536: B.CREATED_BY,
537: B.LAST_UPDATE_LOGIN,
538: L.LANGUAGE_CODE,
539: B.SOURCE_LANG
540: from AHL_WARRANTY_TEMPLATES_TL B, FND_LANGUAGES L
541: where L.INSTALLED_FLAG in ('I', 'B')
542: and B.LANGUAGE = userenv('LANG')
543: and not exists
544: (select NULL

Line 545: from AHL_WARRANTY_TEMPLATES_TL T

541: where L.INSTALLED_FLAG in ('I', 'B')
542: and B.LANGUAGE = userenv('LANG')
543: and not exists
544: (select NULL
545: from AHL_WARRANTY_TEMPLATES_TL T
546: where T.WARRANTY_TEMPLATE_ID = B.WARRANTY_TEMPLATE_ID
547: and T.LANGUAGE = L.LANGUAGE_CODE);
548: end ADD_LANGUAGE;
549: