APPS.ICX_NONCAT_TEMPLATES_PKG dependencies on POR_NONCAT_TEMPLATES_ALL_TL

Line 42: insert into POR_NONCAT_TEMPLATES_ALL_TL (

38: 'N',
39: 'Y'
40: );
41:
42: insert into POR_NONCAT_TEMPLATES_ALL_TL (
43: TEMPLATE_ID,
44: TEMPLATE_NAME,
45: ITEM_DESCRIPTION,
46: CREATION_DATE,

Line 68: from POR_NONCAT_TEMPLATES_ALL_TL T

64: from FND_LANGUAGES L
65: where L.INSTALLED_FLAG in ('I', 'B')
66: and not exists
67: (select NULL
68: from POR_NONCAT_TEMPLATES_ALL_TL T
69: where T.TEMPLATE_ID = X_TEMPLATE_ID
70: and T.LANGUAGE = L.LANGUAGE_CODE);
71:
72: open c;

Line 103: update POR_NONCAT_TEMPLATES_ALL_TL set

99: if (sql%notfound) then
100: raise no_data_found;
101: end if;
102:
103: update POR_NONCAT_TEMPLATES_ALL_TL set
104: TEMPLATE_NAME = X_TEMPLATE_NAME,
105: ITEM_DESCRIPTION = X_ITEM_DESCRIPTION,
106: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
107: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 114: insert into POR_NONCAT_TEMPLATES_ALL_TL (

110: where TEMPLATE_ID = X_TEMPLATE_ID
111: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
112:
113: if (sql%notfound) then
114: insert into POR_NONCAT_TEMPLATES_ALL_TL (
115: TEMPLATE_ID,
116: TEMPLATE_NAME,
117: ITEM_DESCRIPTION,
118: CREATION_DATE,

Line 159: from POR_NONCAT_TEMPLATES_ALL_TL

155: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
156:
157: select LAST_UPDATED_BY, LAST_UPDATE_DATE
158: into db_luby, db_ludate
159: from POR_NONCAT_TEMPLATES_ALL_TL
160: where LANGUAGE = userenv('LANG')
161: and TEMPLATE_ID = to_number(X_TEMPLATE_ID);
162:
163: -- Update record, honoring customization mode.

Line 175: update POR_NONCAT_TEMPLATES_ALL_TL set

171: p_db_id => db_luby,
172: p_db_lud => db_ludate,
173: p_custom_mode => X_CUSTOM_MODE))
174: then
175: update POR_NONCAT_TEMPLATES_ALL_TL set
176: TEMPLATE_NAME = nvl(X_TEMPLATE_NAME, TEMPLATE_NAME),
177: ITEM_DESCRIPTION = nvl(X_ITEM_DESCRIPTION, ITEM_DESCRIPTION),
178: last_update_date = f_ludate,
179: last_updated_by = f_luby,

Line 214: from POR_NONCAT_TEMPLATES_ALL_TL

210: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
211:
212: select LAST_UPDATED_BY, LAST_UPDATE_DATE
213: into db_luby, db_ludate
214: from POR_NONCAT_TEMPLATES_ALL_TL
215: where LANGUAGE = userenv('LANG')
216: and TEMPLATE_ID = to_number(X_TEMPLATE_ID);
217:
218: -- Update record, honoring customization mode.

Line 260: delete from POR_NONCAT_TEMPLATES_ALL_TL T

256:
257: procedure ADD_LANGUAGE
258: is
259: begin
260: delete from POR_NONCAT_TEMPLATES_ALL_TL T
261: where not exists
262: (select NULL
263: from POR_NONCAT_TEMPLATES_ALL_B B
264: where B.TEMPLATE_ID = T.TEMPLATE_ID

Line 267: insert into POR_NONCAT_TEMPLATES_ALL_TL (

263: from POR_NONCAT_TEMPLATES_ALL_B B
264: where B.TEMPLATE_ID = T.TEMPLATE_ID
265: );
266:
267: insert into POR_NONCAT_TEMPLATES_ALL_TL (
268: LAST_UPDATE_LOGIN,
269: LAST_UPDATE_DATE,
270: LAST_UPDATED_BY,
271: CREATION_DATE,

Line 289: from POR_NONCAT_TEMPLATES_ALL_TL B, FND_LANGUAGES L

285: B.TEMPLATE_NAME,
286: B.ITEM_DESCRIPTION,
287: L.LANGUAGE_CODE,
288: B.SOURCE_LANG
289: from POR_NONCAT_TEMPLATES_ALL_TL B, FND_LANGUAGES L
290: where L.INSTALLED_FLAG in ('I', 'B')
291: and B.LANGUAGE = userenv('LANG')
292: and not exists
293: (select NULL

Line 294: from POR_NONCAT_TEMPLATES_ALL_TL T

290: where L.INSTALLED_FLAG in ('I', 'B')
291: and B.LANGUAGE = userenv('LANG')
292: and not exists
293: (select NULL
294: from POR_NONCAT_TEMPLATES_ALL_TL T
295: where T.TEMPLATE_ID = B.TEMPLATE_ID
296: and T.LANGUAGE = L.LANGUAGE_CODE);
297: end ADD_LANGUAGE;
298: