APPS.CAC_SR_TEMPLATES_PKG dependencies on CAC_SR_TEMPLATES_TL

Line 52: insert into CAC_SR_TEMPLATES_TL (

48: X_LAST_UPDATED_BY,
49: X_LAST_UPDATE_LOGIN
50: );
51:
52: insert into CAC_SR_TEMPLATES_TL (
53: TEMPLATE_NAME,
54: TEMPLATE_DESC,
55: CREATED_BY,
56: CREATION_DATE,

Line 78: from CAC_SR_TEMPLATES_TL T

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

Line 119: from CAC_SR_TEMPLATES_TL

115: cursor c1 is select
116: TEMPLATE_NAME,
117: TEMPLATE_DESC,
118: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
119: from CAC_SR_TEMPLATES_TL
120: where TEMPLATE_ID = X_TEMPLATE_ID
121: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
122: for update of TEMPLATE_ID nowait;
123: begin

Line 195: update CAC_SR_TEMPLATES_TL set

191: if (sql%notfound) then
192: raise no_data_found;
193: end if;
194:
195: update CAC_SR_TEMPLATES_TL set
196: TEMPLATE_NAME = X_TEMPLATE_NAME,
197: TEMPLATE_DESC = X_TEMPLATE_DESC,
198: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
199: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 214: delete from CAC_SR_TEMPLATES_TL

210: procedure DELETE_ROW (
211: X_TEMPLATE_ID in NUMBER
212: ) is
213: begin
214: delete from CAC_SR_TEMPLATES_TL
215: where TEMPLATE_ID = X_TEMPLATE_ID;
216:
217: if (sql%notfound) then
218: raise no_data_found;

Line 232: delete from CAC_SR_TEMPLATES_TL T

228:
229: procedure ADD_LANGUAGE
230: is
231: begin
232: delete from CAC_SR_TEMPLATES_TL T
233: where not exists
234: (select NULL
235: from CAC_SR_TEMPLATES_B B
236: where B.TEMPLATE_ID = T.TEMPLATE_ID

Line 239: update CAC_SR_TEMPLATES_TL T set (

235: from CAC_SR_TEMPLATES_B B
236: where B.TEMPLATE_ID = T.TEMPLATE_ID
237: );
238:
239: update CAC_SR_TEMPLATES_TL T set (
240: TEMPLATE_NAME,
241: TEMPLATE_DESC
242: ) = (select
243: B.TEMPLATE_NAME,

Line 245: from CAC_SR_TEMPLATES_TL B

241: TEMPLATE_DESC
242: ) = (select
243: B.TEMPLATE_NAME,
244: B.TEMPLATE_DESC
245: from CAC_SR_TEMPLATES_TL B
246: where B.TEMPLATE_ID = T.TEMPLATE_ID
247: and B.LANGUAGE = T.SOURCE_LANG)
248: where (
249: T.TEMPLATE_ID,

Line 254: from CAC_SR_TEMPLATES_TL SUBB, CAC_SR_TEMPLATES_TL SUBT

250: T.LANGUAGE
251: ) in (select
252: SUBT.TEMPLATE_ID,
253: SUBT.LANGUAGE
254: from CAC_SR_TEMPLATES_TL SUBB, CAC_SR_TEMPLATES_TL SUBT
255: where SUBB.TEMPLATE_ID = SUBT.TEMPLATE_ID
256: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
257: and (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
258: or SUBB.TEMPLATE_DESC <> SUBT.TEMPLATE_DESC

Line 263: insert into CAC_SR_TEMPLATES_TL (

259: or (SUBB.TEMPLATE_DESC is null and SUBT.TEMPLATE_DESC is not null)
260: or (SUBB.TEMPLATE_DESC is not null and SUBT.TEMPLATE_DESC is null)
261: ));
262:
263: insert into CAC_SR_TEMPLATES_TL (
264: TEMPLATE_NAME,
265: TEMPLATE_DESC,
266: CREATED_BY,
267: CREATION_DATE,

Line 285: from CAC_SR_TEMPLATES_TL B, FND_LANGUAGES L

281: B.LAST_UPDATE_LOGIN,
282: B.TEMPLATE_ID,
283: L.LANGUAGE_CODE,
284: B.SOURCE_LANG
285: from CAC_SR_TEMPLATES_TL B, FND_LANGUAGES L
286: where L.INSTALLED_FLAG in ('I', 'B')
287: and B.LANGUAGE = userenv('LANG')
288: and not exists
289: (select NULL

Line 290: from CAC_SR_TEMPLATES_TL T

286: where L.INSTALLED_FLAG in ('I', 'B')
287: and B.LANGUAGE = userenv('LANG')
288: and not exists
289: (select NULL
290: from CAC_SR_TEMPLATES_TL T
291: where T.TEMPLATE_ID = B.TEMPLATE_ID
292: and T.LANGUAGE = L.LANGUAGE_CODE);
293: end ADD_LANGUAGE;
294: