APPS.CAC_SR_PERIOD_DTL_TYPES_PKG dependencies on CAC_SR_PERIOD_DTL_TYPES_TL

Line 37: insert into CAC_SR_PERIOD_DTL_TYPES_TL (

33: X_LAST_UPDATED_BY,
34: X_LAST_UPDATE_LOGIN
35: );
36:
37: insert into CAC_SR_PERIOD_DTL_TYPES_TL (
38: PERIOD_DTL_TYPE_ID,
39: PERIOD_DTL_TYPE_NAME,
40: PERIOD_DTL_TYPE_DESC,
41: CREATED_BY,

Line 63: from CAC_SR_PERIOD_DTL_TYPES_TL T

59: from FND_LANGUAGES L
60: where L.INSTALLED_FLAG in ('I', 'B')
61: and not exists
62: (select NULL
63: from CAC_SR_PERIOD_DTL_TYPES_TL T
64: where T.PERIOD_DTL_TYPE_ID = X_PERIOD_DTL_TYPE_ID
65: and T.LANGUAGE = L.LANGUAGE_CODE);
66:
67: open c;

Line 94: from CAC_SR_PERIOD_DTL_TYPES_TL

90: cursor c1 is select
91: PERIOD_DTL_TYPE_NAME,
92: PERIOD_DTL_TYPE_DESC,
93: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
94: from CAC_SR_PERIOD_DTL_TYPES_TL
95: where PERIOD_DTL_TYPE_ID = X_PERIOD_DTL_TYPE_ID
96: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
97: for update of PERIOD_DTL_TYPE_ID nowait;
98: begin

Line 152: update CAC_SR_PERIOD_DTL_TYPES_TL set

148: if (sql%notfound) then
149: raise no_data_found;
150: end if;
151:
152: update CAC_SR_PERIOD_DTL_TYPES_TL set
153: PERIOD_DTL_TYPE_NAME = X_PERIOD_DTL_TYPE_NAME,
154: PERIOD_DTL_TYPE_DESC = X_PERIOD_DTL_TYPE_DESC,
155: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
156: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 171: delete from CAC_SR_PERIOD_DTL_TYPES_TL

167: procedure DELETE_ROW (
168: X_PERIOD_DTL_TYPE_ID in NUMBER
169: ) is
170: begin
171: delete from CAC_SR_PERIOD_DTL_TYPES_TL
172: where PERIOD_DTL_TYPE_ID = X_PERIOD_DTL_TYPE_ID;
173:
174: if (sql%notfound) then
175: raise no_data_found;

Line 189: delete from CAC_SR_PERIOD_DTL_TYPES_TL T

185:
186: procedure ADD_LANGUAGE
187: is
188: begin
189: delete from CAC_SR_PERIOD_DTL_TYPES_TL T
190: where not exists
191: (select NULL
192: from CAC_SR_PERIOD_DTL_TYPES_B B
193: where B.PERIOD_DTL_TYPE_ID = T.PERIOD_DTL_TYPE_ID

Line 196: update CAC_SR_PERIOD_DTL_TYPES_TL T set (

192: from CAC_SR_PERIOD_DTL_TYPES_B B
193: where B.PERIOD_DTL_TYPE_ID = T.PERIOD_DTL_TYPE_ID
194: );
195:
196: update CAC_SR_PERIOD_DTL_TYPES_TL T set (
197: PERIOD_DTL_TYPE_NAME,
198: PERIOD_DTL_TYPE_DESC
199: ) = (select
200: B.PERIOD_DTL_TYPE_NAME,

Line 202: from CAC_SR_PERIOD_DTL_TYPES_TL B

198: PERIOD_DTL_TYPE_DESC
199: ) = (select
200: B.PERIOD_DTL_TYPE_NAME,
201: B.PERIOD_DTL_TYPE_DESC
202: from CAC_SR_PERIOD_DTL_TYPES_TL B
203: where B.PERIOD_DTL_TYPE_ID = T.PERIOD_DTL_TYPE_ID
204: and B.LANGUAGE = T.SOURCE_LANG)
205: where (
206: T.PERIOD_DTL_TYPE_ID,

Line 211: from CAC_SR_PERIOD_DTL_TYPES_TL SUBB, CAC_SR_PERIOD_DTL_TYPES_TL SUBT

207: T.LANGUAGE
208: ) in (select
209: SUBT.PERIOD_DTL_TYPE_ID,
210: SUBT.LANGUAGE
211: from CAC_SR_PERIOD_DTL_TYPES_TL SUBB, CAC_SR_PERIOD_DTL_TYPES_TL SUBT
212: where SUBB.PERIOD_DTL_TYPE_ID = SUBT.PERIOD_DTL_TYPE_ID
213: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
214: and (SUBB.PERIOD_DTL_TYPE_NAME <> SUBT.PERIOD_DTL_TYPE_NAME
215: or SUBB.PERIOD_DTL_TYPE_DESC <> SUBT.PERIOD_DTL_TYPE_DESC

Line 220: insert into CAC_SR_PERIOD_DTL_TYPES_TL (

216: or (SUBB.PERIOD_DTL_TYPE_DESC is null and SUBT.PERIOD_DTL_TYPE_DESC is not null)
217: or (SUBB.PERIOD_DTL_TYPE_DESC is not null and SUBT.PERIOD_DTL_TYPE_DESC is null)
218: ));
219:
220: insert into CAC_SR_PERIOD_DTL_TYPES_TL (
221: PERIOD_DTL_TYPE_ID,
222: PERIOD_DTL_TYPE_NAME,
223: PERIOD_DTL_TYPE_DESC,
224: CREATED_BY,

Line 242: from CAC_SR_PERIOD_DTL_TYPES_TL B, FND_LANGUAGES L

238: B.LAST_UPDATE_DATE,
239: B.LAST_UPDATE_LOGIN,
240: L.LANGUAGE_CODE,
241: B.SOURCE_LANG
242: from CAC_SR_PERIOD_DTL_TYPES_TL B, FND_LANGUAGES L
243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL

Line 247: from CAC_SR_PERIOD_DTL_TYPES_TL T

243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL
247: from CAC_SR_PERIOD_DTL_TYPES_TL T
248: where T.PERIOD_DTL_TYPE_ID = B.PERIOD_DTL_TYPE_ID
249: and T.LANGUAGE = L.LANGUAGE_CODE);
250: end ADD_LANGUAGE;
251:

Line 266: UPDATE cac_sr_period_dtl_types_tl

262: THEN
263: l_user_id := 1;
264: END IF;
265:
266: UPDATE cac_sr_period_dtl_types_tl
267: SET period_dtl_type_name = NVL(X_PERIOD_DTL_TYPE_NAME, period_dtl_type_name ) ,
268: period_dtl_type_desc = NVL(X_PERIOD_DTL_TYPE_DESC, period_dtl_type_desc),
269: last_updated_by = l_user_id,
270: last_update_date = sysdate,

Line 316: UPDATE cac_sr_period_dtl_types_tl

312: last_update_date = sysdate,
313: last_update_login = 0
314: WHERE period_dtl_type_id = l_period_dtl_type_id;
315:
316: UPDATE cac_sr_period_dtl_types_tl
317: SET period_dtl_type_name = x_period_dtl_type_name,
318: period_dtl_type_desc = x_period_dtl_type_desc,
319: last_updated_by = l_user_id,
320: last_update_date = sysdate,