APPS.WMS_PAGE_TEMPLATES_PKG dependencies on WMS_PAGE_TEMPLATES_TL

Line 106: insert into WMS_PAGE_TEMPLATES_TL (

102: X_LAST_UPDATED_BY,
103: X_LAST_UPDATE_LOGIN
104: );
105:
106: insert into WMS_PAGE_TEMPLATES_TL (
107: PAGE_ID,
108: TEMPLATE_ID,
109: USER_TEMPLATE_NAME,
110: TEMPLATE_DESCRIPTION,

Line 134: from WMS_PAGE_TEMPLATES_TL T

130: from FND_LANGUAGES L
131: where L.INSTALLED_FLAG in ('I', 'B')
132: and not exists
133: (select NULL
134: from WMS_PAGE_TEMPLATES_TL T
135: where T.TEMPLATE_ID = X_TEMPLATE_ID
136: and T.LANGUAGE = L.LANGUAGE_CODE);
137:
138: open c;

Line 209: from WMS_PAGE_TEMPLATES_TL

205: cursor c1 is select
206: USER_TEMPLATE_NAME,
207: TEMPLATE_DESCRIPTION,
208: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
209: from WMS_PAGE_TEMPLATES_TL
210: where TEMPLATE_ID = X_TEMPLATE_ID
211: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
212: for update of TEMPLATE_ID nowait;
213: begin

Line 353: update WMS_PAGE_TEMPLATES_TL set

349: if (sql%notfound) then
350: raise no_data_found;
351: end if;
352:
353: update WMS_PAGE_TEMPLATES_TL set
354: USER_TEMPLATE_NAME = X_USER_TEMPLATE_NAME,
355: TEMPLATE_DESCRIPTION = X_TEMPLATE_DESCRIPTION,
356: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
357: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 405: update WMS_PAGE_TEMPLATES_TL set

401: -- Test for customization and version
402: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
403: db_ludate, x_custom_mode)) then
404: -- Update translations for this language
405: update WMS_PAGE_TEMPLATES_TL set
406: USER_TEMPLATE_NAME = X_USER_TEMPLATE_NAME,
407: TEMPLATE_DESCRIPTION = nvl(X_TEMPLATE_DESCRIPTION, TEMPLATE_DESCRIPTION),
408: LAST_UPDATE_DATE = f_ludate,
409: LAST_UPDATED_BY = f_luby,

Line 453: l_TEMPLATE_DESCRIPTION WMS_PAGE_TEMPLATES_TL.TEMPLATE_DESCRIPTION%TYPE;

449: x_last_update_date in varchar2,
450: x_custom_mode in varchar2) is
451:
452: l_template_id number;
453: l_TEMPLATE_DESCRIPTION WMS_PAGE_TEMPLATES_TL.TEMPLATE_DESCRIPTION%TYPE;
454: row_id varchar2(64);
455: f_luby number; -- entity owner in file
456: f_ludate date; -- entity update date in file
457: db_luby number; -- entity owner in db

Line 573: delete from WMS_PAGE_TEMPLATES_TL

569:
570: delete from WMS_PAGE_TEMPLATE_FIELDS
571: where TEMPLATE_ID = X_TEMPLATE_ID;
572:
573: delete from WMS_PAGE_TEMPLATES_TL
574: where TEMPLATE_ID = X_TEMPLATE_ID;
575:
576: if (sql%notfound) then
577: raise no_data_found;

Line 591: delete from WMS_PAGE_TEMPLATES_TL T

587:
588: procedure ADD_LANGUAGE
589: is
590: begin
591: delete from WMS_PAGE_TEMPLATES_TL T
592: where not exists
593: (select NULL
594: from WMS_PAGE_TEMPLATES_B B
595: where B.TEMPLATE_ID = T.TEMPLATE_ID

Line 598: update WMS_PAGE_TEMPLATES_TL T set (

594: from WMS_PAGE_TEMPLATES_B B
595: where B.TEMPLATE_ID = T.TEMPLATE_ID
596: );
597:
598: update WMS_PAGE_TEMPLATES_TL T set (
599: USER_TEMPLATE_NAME,
600: TEMPLATE_DESCRIPTION
601: ) = (select
602: B.USER_TEMPLATE_NAME,

Line 604: from WMS_PAGE_TEMPLATES_TL B

600: TEMPLATE_DESCRIPTION
601: ) = (select
602: B.USER_TEMPLATE_NAME,
603: B.TEMPLATE_DESCRIPTION
604: from WMS_PAGE_TEMPLATES_TL B
605: where B.TEMPLATE_ID = T.TEMPLATE_ID
606: and B.LANGUAGE = T.SOURCE_LANG)
607: where (
608: T.TEMPLATE_ID,

Line 613: from WMS_PAGE_TEMPLATES_TL SUBB, WMS_PAGE_TEMPLATES_TL SUBT

609: T.LANGUAGE
610: ) in (select
611: SUBT.TEMPLATE_ID,
612: SUBT.LANGUAGE
613: from WMS_PAGE_TEMPLATES_TL SUBB, WMS_PAGE_TEMPLATES_TL SUBT
614: where SUBB.TEMPLATE_ID = SUBT.TEMPLATE_ID
615: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
616: and (SUBB.USER_TEMPLATE_NAME <> SUBT.USER_TEMPLATE_NAME
617: or SUBB.TEMPLATE_DESCRIPTION <> SUBT.TEMPLATE_DESCRIPTION

Line 622: insert into WMS_PAGE_TEMPLATES_TL (

618: or (SUBB.TEMPLATE_DESCRIPTION is null and SUBT.TEMPLATE_DESCRIPTION is not null)
619: or (SUBB.TEMPLATE_DESCRIPTION is not null and SUBT.TEMPLATE_DESCRIPTION is null)
620: ));
621:
622: insert into WMS_PAGE_TEMPLATES_TL (
623: PAGE_ID,
624: TEMPLATE_ID,
625: USER_TEMPLATE_NAME,
626: TEMPLATE_DESCRIPTION,

Line 646: from WMS_PAGE_TEMPLATES_TL B, FND_LANGUAGES L

642: B.LAST_UPDATED_BY,
643: B.LAST_UPDATE_LOGIN,
644: L.LANGUAGE_CODE,
645: B.SOURCE_LANG
646: from WMS_PAGE_TEMPLATES_TL B, FND_LANGUAGES L
647: where L.INSTALLED_FLAG in ('I', 'B')
648: and B.LANGUAGE = userenv('LANG')
649: and not exists
650: (select NULL

Line 651: from WMS_PAGE_TEMPLATES_TL T

647: where L.INSTALLED_FLAG in ('I', 'B')
648: and B.LANGUAGE = userenv('LANG')
649: and not exists
650: (select NULL
651: from WMS_PAGE_TEMPLATES_TL T
652: where T.TEMPLATE_ID = B.TEMPLATE_ID
653: and T.LANGUAGE = L.LANGUAGE_CODE);
654: end ADD_LANGUAGE;
655: