APPS.CAC_SR_PERIOD_CATS_PKG dependencies on CAC_SR_PERIOD_CATS_TL

Line 43: insert into CAC_SR_PERIOD_CATS_TL (

39: X_LAST_UPDATED_BY,
40: X_LAST_UPDATE_LOGIN
41: );
42:
43: insert into CAC_SR_PERIOD_CATS_TL (
44: PERIOD_CATEGORY_ID,
45: PERIOD_CATEGORY_NAME,
46: PERIOD_CATEGORY_DESC,
47: CREATED_BY,

Line 69: from CAC_SR_PERIOD_CATS_TL T

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

Line 104: from CAC_SR_PERIOD_CATS_TL

100: cursor c1 is select
101: PERIOD_CATEGORY_NAME,
102: PERIOD_CATEGORY_DESC,
103: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
104: from CAC_SR_PERIOD_CATS_TL
105: where PERIOD_CATEGORY_ID = X_PERIOD_CATEGORY_ID
106: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
107: for update of PERIOD_CATEGORY_ID nowait;
108: begin

Line 168: update CAC_SR_PERIOD_CATS_TL set

164: if (sql%notfound) then
165: raise no_data_found;
166: end if;
167:
168: update CAC_SR_PERIOD_CATS_TL set
169: PERIOD_CATEGORY_NAME = X_PERIOD_CATEGORY_NAME,
170: PERIOD_CATEGORY_DESC = X_PERIOD_CATEGORY_DESC,
171: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
172: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 187: delete from CAC_SR_PERIOD_CATS_TL

183: procedure DELETE_ROW (
184: X_PERIOD_CATEGORY_ID in NUMBER
185: ) is
186: begin
187: delete from CAC_SR_PERIOD_CATS_TL
188: where PERIOD_CATEGORY_ID = X_PERIOD_CATEGORY_ID;
189:
190: if (sql%notfound) then
191: raise no_data_found;

Line 205: delete from CAC_SR_PERIOD_CATS_TL T

201:
202: procedure ADD_LANGUAGE
203: is
204: begin
205: delete from CAC_SR_PERIOD_CATS_TL T
206: where not exists
207: (select NULL
208: from CAC_SR_PERIOD_CATS_B B
209: where B.PERIOD_CATEGORY_ID = T.PERIOD_CATEGORY_ID

Line 212: update CAC_SR_PERIOD_CATS_TL T set (

208: from CAC_SR_PERIOD_CATS_B B
209: where B.PERIOD_CATEGORY_ID = T.PERIOD_CATEGORY_ID
210: );
211:
212: update CAC_SR_PERIOD_CATS_TL T set (
213: PERIOD_CATEGORY_NAME,
214: PERIOD_CATEGORY_DESC
215: ) = (select
216: B.PERIOD_CATEGORY_NAME,

Line 218: from CAC_SR_PERIOD_CATS_TL B

214: PERIOD_CATEGORY_DESC
215: ) = (select
216: B.PERIOD_CATEGORY_NAME,
217: B.PERIOD_CATEGORY_DESC
218: from CAC_SR_PERIOD_CATS_TL B
219: where B.PERIOD_CATEGORY_ID = T.PERIOD_CATEGORY_ID
220: and B.LANGUAGE = T.SOURCE_LANG)
221: where (
222: T.PERIOD_CATEGORY_ID,

Line 227: from CAC_SR_PERIOD_CATS_TL SUBB, CAC_SR_PERIOD_CATS_TL SUBT

223: T.LANGUAGE
224: ) in (select
225: SUBT.PERIOD_CATEGORY_ID,
226: SUBT.LANGUAGE
227: from CAC_SR_PERIOD_CATS_TL SUBB, CAC_SR_PERIOD_CATS_TL SUBT
228: where SUBB.PERIOD_CATEGORY_ID = SUBT.PERIOD_CATEGORY_ID
229: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
230: and (SUBB.PERIOD_CATEGORY_NAME <> SUBT.PERIOD_CATEGORY_NAME
231: or SUBB.PERIOD_CATEGORY_DESC <> SUBT.PERIOD_CATEGORY_DESC

Line 236: insert into CAC_SR_PERIOD_CATS_TL (

232: or (SUBB.PERIOD_CATEGORY_DESC is null and SUBT.PERIOD_CATEGORY_DESC is not null)
233: or (SUBB.PERIOD_CATEGORY_DESC is not null and SUBT.PERIOD_CATEGORY_DESC is null)
234: ));
235:
236: insert into CAC_SR_PERIOD_CATS_TL (
237: PERIOD_CATEGORY_ID,
238: PERIOD_CATEGORY_NAME,
239: PERIOD_CATEGORY_DESC,
240: CREATED_BY,

Line 258: from CAC_SR_PERIOD_CATS_TL B, FND_LANGUAGES L

254: B.LAST_UPDATE_DATE,
255: B.LAST_UPDATE_LOGIN,
256: L.LANGUAGE_CODE,
257: B.SOURCE_LANG
258: from CAC_SR_PERIOD_CATS_TL B, FND_LANGUAGES L
259: where L.INSTALLED_FLAG in ('I', 'B')
260: and B.LANGUAGE = userenv('LANG')
261: and not exists
262: (select NULL

Line 263: from CAC_SR_PERIOD_CATS_TL T

259: where L.INSTALLED_FLAG in ('I', 'B')
260: and B.LANGUAGE = userenv('LANG')
261: and not exists
262: (select NULL
263: from CAC_SR_PERIOD_CATS_TL T
264: where T.PERIOD_CATEGORY_ID = B.PERIOD_CATEGORY_ID
265: and T.LANGUAGE = L.LANGUAGE_CODE);
266: end ADD_LANGUAGE;
267:

Line 282: UPDATE cac_sr_period_cats_tl

278: THEN
279: l_user_id := 1;
280: END IF;
281:
282: UPDATE cac_sr_period_cats_tl
283: SET period_category_name = NVL(X_PERIOD_CATEGORY_NAME, period_category_name ) ,
284: period_category_desc = NVL(X_PERIOD_CATEGORY_DESC, period_category_desc),
285: last_updated_by = l_user_id,
286: last_update_date = sysdate,

Line 336: UPDATE cac_sr_period_cats_tl

332: last_update_date = sysdate,
333: last_update_login = 0
334: WHERE period_category_id = l_period_category_id;
335:
336: UPDATE cac_sr_period_cats_tl
337: SET period_category_name = x_period_category_name,
338: period_category_desc = x_period_category_desc,
339: last_updated_by = l_user_id,
340: last_update_date = sysdate,