APPS.CAC_SR_SCHEDULES_PKG dependencies on CAC_SR_SCHEDULES_TL

Line 55: insert into CAC_SR_SCHEDULES_TL (

51: X_LAST_UPDATED_BY,
52: X_LAST_UPDATE_LOGIN
53: );
54:
55: insert into CAC_SR_SCHEDULES_TL (
56: SCHEDULE_ID,
57: SCHEDULE_NAME,
58: SCHEDULE_DESC,
59: CREATED_BY,

Line 81: from CAC_SR_SCHEDULES_TL T

77: from FND_LANGUAGES L
78: where L.INSTALLED_FLAG in ('I', 'B')
79: and not exists
80: (select NULL
81: from CAC_SR_SCHEDULES_TL T
82: where T.SCHEDULE_ID = X_SCHEDULE_ID
83: and T.LANGUAGE = L.LANGUAGE_CODE);
84:
85: open c;

Line 124: from CAC_SR_SCHEDULES_TL

120: cursor c1 is select
121: SCHEDULE_NAME,
122: SCHEDULE_DESC,
123: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
124: from CAC_SR_SCHEDULES_TL
125: where SCHEDULE_ID = X_SCHEDULE_ID
126: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
127: for update of SCHEDULE_ID nowait;
128: begin

Line 201: update CAC_SR_SCHEDULES_TL set

197: if (sql%notfound) then
198: raise no_data_found;
199: end if;
200:
201: update CAC_SR_SCHEDULES_TL set
202: SCHEDULE_NAME = X_SCHEDULE_NAME,
203: SCHEDULE_DESC = X_SCHEDULE_DESC,
204: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
205: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 220: delete from CAC_SR_SCHEDULES_TL

216: procedure DELETE_ROW (
217: X_SCHEDULE_ID in NUMBER
218: ) is
219: begin
220: delete from CAC_SR_SCHEDULES_TL
221: where SCHEDULE_ID = X_SCHEDULE_ID;
222:
223: if (sql%notfound) then
224: raise no_data_found;

Line 238: delete from CAC_SR_SCHEDULES_TL T

234:
235: procedure ADD_LANGUAGE
236: is
237: begin
238: delete from CAC_SR_SCHEDULES_TL T
239: where not exists
240: (select NULL
241: from CAC_SR_SCHEDULES_B B
242: where B.SCHEDULE_ID = T.SCHEDULE_ID

Line 245: update CAC_SR_SCHEDULES_TL T set (

241: from CAC_SR_SCHEDULES_B B
242: where B.SCHEDULE_ID = T.SCHEDULE_ID
243: );
244:
245: update CAC_SR_SCHEDULES_TL T set (
246: SCHEDULE_NAME,
247: SCHEDULE_DESC
248: ) = (select
249: B.SCHEDULE_NAME,

Line 251: from CAC_SR_SCHEDULES_TL B

247: SCHEDULE_DESC
248: ) = (select
249: B.SCHEDULE_NAME,
250: B.SCHEDULE_DESC
251: from CAC_SR_SCHEDULES_TL B
252: where B.SCHEDULE_ID = T.SCHEDULE_ID
253: and B.LANGUAGE = T.SOURCE_LANG)
254: where (
255: T.SCHEDULE_ID,

Line 260: from CAC_SR_SCHEDULES_TL SUBB, CAC_SR_SCHEDULES_TL SUBT

256: T.LANGUAGE
257: ) in (select
258: SUBT.SCHEDULE_ID,
259: SUBT.LANGUAGE
260: from CAC_SR_SCHEDULES_TL SUBB, CAC_SR_SCHEDULES_TL SUBT
261: where SUBB.SCHEDULE_ID = SUBT.SCHEDULE_ID
262: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
263: and (SUBB.SCHEDULE_NAME <> SUBT.SCHEDULE_NAME
264: or SUBB.SCHEDULE_DESC <> SUBT.SCHEDULE_DESC

Line 269: insert into CAC_SR_SCHEDULES_TL (

265: or (SUBB.SCHEDULE_DESC is null and SUBT.SCHEDULE_DESC is not null)
266: or (SUBB.SCHEDULE_DESC is not null and SUBT.SCHEDULE_DESC is null)
267: ));
268:
269: insert into CAC_SR_SCHEDULES_TL (
270: SCHEDULE_ID,
271: SCHEDULE_NAME,
272: SCHEDULE_DESC,
273: CREATED_BY,

Line 291: from CAC_SR_SCHEDULES_TL B, FND_LANGUAGES L

287: B.LAST_UPDATE_DATE,
288: B.LAST_UPDATE_LOGIN,
289: L.LANGUAGE_CODE,
290: B.SOURCE_LANG
291: from CAC_SR_SCHEDULES_TL B, FND_LANGUAGES L
292: where L.INSTALLED_FLAG in ('I', 'B')
293: and B.LANGUAGE = userenv('LANG')
294: and not exists
295: (select NULL

Line 296: from CAC_SR_SCHEDULES_TL T

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