APPS.CAC_SR_PERIODS_PKG dependencies on CAC_SR_PERIODS_TL

Line 70: insert into CAC_SR_PERIODS_TL (

66: X_LAST_UPDATED_BY,
67: X_LAST_UPDATE_LOGIN
68: );
69:
70: insert into CAC_SR_PERIODS_TL (
71: LAST_UPDATED_BY,
72: LAST_UPDATE_DATE,
73: PERIOD_ID,
74: PERIOD_NAME,

Line 96: from CAC_SR_PERIODS_TL T

92: from FND_LANGUAGES L
93: where L.INSTALLED_FLAG in ('I', 'B')
94: and not exists
95: (select NULL
96: from CAC_SR_PERIODS_TL T
97: where T.PERIOD_ID = X_PERIOD_ID
98: and T.LANGUAGE = L.LANGUAGE_CODE);
99:
100: open c;

Line 149: from CAC_SR_PERIODS_TL

145: cursor c1 is select
146: PERIOD_NAME,
147: PERIOD_DESC,
148: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
149: from CAC_SR_PERIODS_TL
150: where PERIOD_ID = X_PERIOD_ID
151: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
152: for update of PERIOD_ID nowait;
153: begin

Line 249: update CAC_SR_PERIODS_TL set

245: if (sql%notfound) then
246: raise no_data_found;
247: end if;
248:
249: update CAC_SR_PERIODS_TL set
250: PERIOD_NAME = X_PERIOD_NAME,
251: PERIOD_DESC = X_PERIOD_DESC,
252: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
253: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 268: delete from CAC_SR_PERIODS_TL

264: procedure DELETE_ROW (
265: X_PERIOD_ID in NUMBER
266: ) is
267: begin
268: delete from CAC_SR_PERIODS_TL
269: where PERIOD_ID = X_PERIOD_ID;
270:
271: if (sql%notfound) then
272: raise no_data_found;

Line 286: delete from CAC_SR_PERIODS_TL T

282:
283: procedure ADD_LANGUAGE
284: is
285: begin
286: delete from CAC_SR_PERIODS_TL T
287: where not exists
288: (select NULL
289: from CAC_SR_PERIODS_B B
290: where B.PERIOD_ID = T.PERIOD_ID

Line 293: update CAC_SR_PERIODS_TL T set (

289: from CAC_SR_PERIODS_B B
290: where B.PERIOD_ID = T.PERIOD_ID
291: );
292:
293: update CAC_SR_PERIODS_TL T set (
294: PERIOD_NAME,
295: PERIOD_DESC
296: ) = (select
297: B.PERIOD_NAME,

Line 299: from CAC_SR_PERIODS_TL B

295: PERIOD_DESC
296: ) = (select
297: B.PERIOD_NAME,
298: B.PERIOD_DESC
299: from CAC_SR_PERIODS_TL B
300: where B.PERIOD_ID = T.PERIOD_ID
301: and B.LANGUAGE = T.SOURCE_LANG)
302: where (
303: T.PERIOD_ID,

Line 308: from CAC_SR_PERIODS_TL SUBB, CAC_SR_PERIODS_TL SUBT

304: T.LANGUAGE
305: ) in (select
306: SUBT.PERIOD_ID,
307: SUBT.LANGUAGE
308: from CAC_SR_PERIODS_TL SUBB, CAC_SR_PERIODS_TL SUBT
309: where SUBB.PERIOD_ID = SUBT.PERIOD_ID
310: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
311: and (SUBB.PERIOD_NAME <> SUBT.PERIOD_NAME
312: or SUBB.PERIOD_DESC <> SUBT.PERIOD_DESC

Line 317: insert into CAC_SR_PERIODS_TL (

313: or (SUBB.PERIOD_DESC is null and SUBT.PERIOD_DESC is not null)
314: or (SUBB.PERIOD_DESC is not null and SUBT.PERIOD_DESC is null)
315: ));
316:
317: insert into CAC_SR_PERIODS_TL (
318: LAST_UPDATED_BY,
319: LAST_UPDATE_DATE,
320: PERIOD_ID,
321: PERIOD_NAME,

Line 339: from CAC_SR_PERIODS_TL B, FND_LANGUAGES L

335: B.CREATION_DATE,
336: B.LAST_UPDATE_LOGIN,
337: L.LANGUAGE_CODE,
338: B.SOURCE_LANG
339: from CAC_SR_PERIODS_TL B, FND_LANGUAGES L
340: where L.INSTALLED_FLAG in ('I', 'B')
341: and B.LANGUAGE = userenv('LANG')
342: and not exists
343: (select NULL

Line 344: from CAC_SR_PERIODS_TL T

340: where L.INSTALLED_FLAG in ('I', 'B')
341: and B.LANGUAGE = userenv('LANG')
342: and not exists
343: (select NULL
344: from CAC_SR_PERIODS_TL T
345: where T.PERIOD_ID = B.PERIOD_ID
346: and T.LANGUAGE = L.LANGUAGE_CODE);
347: end ADD_LANGUAGE;
348: