APPS.OKC_NUMBER_SCHEMES_PVT dependencies on OKC_NUMBER_SCHEMES_TL

Line 46: insert into OKC_NUMBER_SCHEMES_TL (

42: X_LAST_UPDATED_BY,
43: X_LAST_UPDATE_LOGIN
44: );
45:
46: insert into OKC_NUMBER_SCHEMES_TL (
47: DESCRIPTION,
48: NUM_SCHEME_ID,
49: SCHEME_NAME,
50: CREATED_BY,

Line 72: from OKC_NUMBER_SCHEMES_TL T

68: from FND_LANGUAGES L
69: where L.INSTALLED_FLAG in ('I', 'B')
70: and not exists
71: (select NULL
72: from OKC_NUMBER_SCHEMES_TL T
73: where T.NUM_SCHEME_ID = X_NUM_SCHEME_ID
74: and T.LANGUAGE = L.LANGUAGE_CODE);
75:
76: open c;

Line 120: from OKC_NUMBER_SCHEMES_TL

116: cursor c1 is select
117: SCHEME_NAME,
118: DESCRIPTION,
119: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
120: from OKC_NUMBER_SCHEMES_TL
121: where NUM_SCHEME_ID = X_NUM_SCHEME_ID
122: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
123: for update of NUM_SCHEME_ID nowait;
124: begin

Line 185: update OKC_NUMBER_SCHEMES_TL set

181: if (sql%notfound) then
182: raise no_data_found;
183: end if;
184:
185: update OKC_NUMBER_SCHEMES_TL set
186: SCHEME_NAME = X_SCHEME_NAME,
187: DESCRIPTION = X_DESCRIPTION,
188: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
189: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 224: delete from OKC_NUMBER_SCHEMES_TL

220: procedure DELETE_ROW (
221: X_NUM_SCHEME_ID in NUMBER
222: ) is
223: begin
224: delete from OKC_NUMBER_SCHEMES_TL
225: where NUM_SCHEME_ID = X_NUM_SCHEME_ID;
226:
227: if (sql%notfound) then
228: raise no_data_found;

Line 246: delete from OKC_NUMBER_SCHEMES_TL T

242:
243: procedure ADD_LANGUAGE
244: is
245: begin
246: delete from OKC_NUMBER_SCHEMES_TL T
247: where not exists
248: (select NULL
249: from OKC_NUMBER_SCHEMES_B B
250: where B.NUM_SCHEME_ID = T.NUM_SCHEME_ID

Line 253: update OKC_NUMBER_SCHEMES_TL T set (

249: from OKC_NUMBER_SCHEMES_B B
250: where B.NUM_SCHEME_ID = T.NUM_SCHEME_ID
251: );
252:
253: update OKC_NUMBER_SCHEMES_TL T set (
254: SCHEME_NAME,
255: DESCRIPTION
256: ) = (select
257: B.SCHEME_NAME,

Line 259: from OKC_NUMBER_SCHEMES_TL B

255: DESCRIPTION
256: ) = (select
257: B.SCHEME_NAME,
258: B.DESCRIPTION
259: from OKC_NUMBER_SCHEMES_TL B
260: where B.NUM_SCHEME_ID = T.NUM_SCHEME_ID
261: and B.LANGUAGE = T.SOURCE_LANG)
262: where (
263: T.NUM_SCHEME_ID,

Line 268: from OKC_NUMBER_SCHEMES_TL SUBB, OKC_NUMBER_SCHEMES_TL SUBT

264: T.LANGUAGE
265: ) in (select
266: SUBT.NUM_SCHEME_ID,
267: SUBT.LANGUAGE
268: from OKC_NUMBER_SCHEMES_TL SUBB, OKC_NUMBER_SCHEMES_TL SUBT
269: where SUBB.NUM_SCHEME_ID = SUBT.NUM_SCHEME_ID
270: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
271: and (SUBB.SCHEME_NAME <> SUBT.SCHEME_NAME
272: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 277: insert into OKC_NUMBER_SCHEMES_TL (

273: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
274: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
275: ));
276:
277: insert into OKC_NUMBER_SCHEMES_TL (
278: DESCRIPTION,
279: NUM_SCHEME_ID,
280: SCHEME_NAME,
281: CREATED_BY,

Line 299: from OKC_NUMBER_SCHEMES_TL B, FND_LANGUAGES L

295: B.LAST_UPDATE_DATE,
296: B.LAST_UPDATE_LOGIN,
297: L.LANGUAGE_CODE,
298: B.SOURCE_LANG
299: from OKC_NUMBER_SCHEMES_TL B, FND_LANGUAGES L
300: where L.INSTALLED_FLAG in ('I', 'B')
301: and B.LANGUAGE = userenv('LANG')
302: and not exists
303: (select NULL

Line 304: from OKC_NUMBER_SCHEMES_TL T

300: where L.INSTALLED_FLAG in ('I', 'B')
301: and B.LANGUAGE = userenv('LANG')
302: and not exists
303: (select NULL
304: from OKC_NUMBER_SCHEMES_TL T
305: where T.NUM_SCHEME_ID = B.NUM_SCHEME_ID
306: and T.LANGUAGE = L.LANGUAGE_CODE);
307: end ADD_LANGUAGE;
308: