APPS.OKE_HOLD_STATUSES_PKG dependencies on OKE_HOLD_STATUSES_TL

Line 94: insert into OKE_HOLD_STATUSES_TL (

90: , X_ATTRIBUTE14
91: , X_ATTRIBUTE15
92: );
93:
94: insert into OKE_HOLD_STATUSES_TL (
95: HOLD_STATUS_CODE
96: , LANGUAGE
97: , CREATION_DATE
98: , CREATED_BY

Line 120: from OKE_HOLD_STATUSES_TL T

116: from FND_LANGUAGES L
117: where L.INSTALLED_FLAG in ('I', 'B')
118: and not exists
119: (select NULL
120: from OKE_HOLD_STATUSES_TL T
121: where T.HOLD_STATUS_CODE = X_HOLD_STATUS_CODE
122: and T.LANGUAGE = L.LANGUAGE_CODE)
123: ;
124:

Line 191: from OKE_HOLD_STATUSES_TL

187: cursor c1 is select
188: HOLD_STATUS_NAME
189: ,DESCRIPTION
190: ,decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
191: from OKE_HOLD_STATUSES_TL
192: where HOLD_STATUS_CODE= X_HOLD_STATUS_CODE
193: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
194: for update of HOLD_STATUS_CODE nowait;
195: tlinfo c1%rowtype;

Line 333: update OKE_HOLD_STATUSES_TL set

329: if (sql%notfound) then
330: raise no_data_found;
331: end if;
332:
333: update OKE_HOLD_STATUSES_TL set
334: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
335: , LAST_UPDATED_BY = X_LAST_UPDATED_BY
336: , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
337: , HOLD_STATUS_NAME = X_HOLD_STATUS_NAME

Line 352: delete from OKE_HOLD_STATUSES_TL T

348:
349: procedure ADD_LANGUAGE
350: is
351: begin
352: delete from OKE_HOLD_STATUSES_TL T
353: where not exists
354: (select NULL
355: from OKE_HOLD_STATUSES_B B
356: where B.HOLD_STATUS_CODE = T.HOLD_STATUS_CODE

Line 359: update OKE_HOLD_STATUSES_TL T set (

355: from OKE_HOLD_STATUSES_B B
356: where B.HOLD_STATUS_CODE = T.HOLD_STATUS_CODE
357: );
358:
359: update OKE_HOLD_STATUSES_TL T set (
360: HOLD_STATUS_NAME,
361: DESCRIPTION
362: ) = (select
363: B.HOLD_STATUS_NAME,

Line 365: from OKE_HOLD_STATUSES_TL B

361: DESCRIPTION
362: ) = (select
363: B.HOLD_STATUS_NAME,
364: B.DESCRIPTION
365: from OKE_HOLD_STATUSES_TL B
366: where B.HOLD_STATUS_CODE = T.HOLD_STATUS_CODE
367: and B.LANGUAGE = T.SOURCE_LANG)
368: where (
369: T.HOLD_STATUS_CODE,

Line 374: from OKE_HOLD_STATUSES_TL SUBB, OKE_HOLD_STATUSES_TL SUBT

370: T.LANGUAGE
371: ) in (select
372: SUBT.HOLD_STATUS_CODE,
373: SUBT.LANGUAGE
374: from OKE_HOLD_STATUSES_TL SUBB, OKE_HOLD_STATUSES_TL SUBT
375: where SUBB.HOLD_STATUS_CODE = SUBT.HOLD_STATUS_CODE
376: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
377: and (SUBB.HOLD_STATUS_NAME <> SUBT.HOLD_STATUS_NAME
378: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 383: insert into OKE_HOLD_STATUSES_TL (

379: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
380: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
381: ));
382:
383: insert into OKE_HOLD_STATUSES_TL (
384: HOLD_STATUS_CODE,
385: CREATION_DATE,
386: CREATED_BY,
387: LAST_UPDATE_DATE,

Line 405: from OKE_HOLD_STATUSES_TL B, FND_LANGUAGES L

401: B.HOLD_STATUS_NAME,
402: B.DESCRIPTION,
403: L.LANGUAGE_CODE,
404: B.SOURCE_LANG
405: from OKE_HOLD_STATUSES_TL B, FND_LANGUAGES L
406: where L.INSTALLED_FLAG in ('I', 'B')
407: and B.LANGUAGE = userenv('LANG')
408: and not exists
409: (select NULL

Line 410: from OKE_HOLD_STATUSES_TL T

406: where L.INSTALLED_FLAG in ('I', 'B')
407: and B.LANGUAGE = userenv('LANG')
408: and not exists
409: (select NULL
410: from OKE_HOLD_STATUSES_TL T
411: where T.HOLD_STATUS_CODE = B.HOLD_STATUS_CODE
412: and T.LANGUAGE = L.LANGUAGE_CODE);
413: end ADD_LANGUAGE;
414: