APPS.OKE_DELIVERABLES_PKG dependencies on OKE_DELIVERABLES_TL

Line 125: insert into OKE_DELIVERABLES_TL (

121: X_LAST_UPDATED_BY,
122: X_LAST_UPDATE_LOGIN
123: );
124:
125: insert into OKE_DELIVERABLES_TL (
126: DELIVERABLE_ID,
127: CREATION_DATE,
128: CREATED_BY,
129: LAST_UPDATE_DATE,

Line 151: from OKE_DELIVERABLES_TL T

147: from FND_LANGUAGES L
148: where L.INSTALLED_FLAG in ('I', 'B')
149: and not exists
150: (select NULL
151: from OKE_DELIVERABLES_TL T
152: where T.DELIVERABLE_ID = X_DELIVERABLE_ID
153: and T.LANGUAGE = L.LANGUAGE_CODE);
154:
155: open c;

Line 240: from OKE_DELIVERABLES_TL

236: cursor c1 is select
237: DESCRIPTION,
238: COMMENTS,
239: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
240: from OKE_DELIVERABLES_TL
241: where DELIVERABLE_ID = X_DELIVERABLE_ID
242: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
243: for update of DELIVERABLE_ID nowait;
244: begin

Line 415: update OKE_DELIVERABLES_TL set

411: if (sql%notfound) then
412: raise no_data_found;
413: end if;
414:
415: update OKE_DELIVERABLES_TL set
416: DESCRIPTION = X_DESCRIPTION,
417: COMMENTS = X_COMMENTS,
418: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
419: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 434: delete from OKE_DELIVERABLES_TL

430: procedure DELETE_ROW (
431: X_DELIVERABLE_ID in NUMBER
432: ) is
433: begin
434: delete from OKE_DELIVERABLES_TL
435: where DELIVERABLE_ID = X_DELIVERABLE_ID;
436:
437: if (sql%notfound) then
438: raise no_data_found;

Line 452: delete from OKE_DELIVERABLES_TL T

448:
449: procedure ADD_LANGUAGE
450: is
451: begin
452: delete from OKE_DELIVERABLES_TL T
453: where not exists
454: (select NULL
455: from OKE_DELIVERABLES_B B
456: where B.DELIVERABLE_ID = T.DELIVERABLE_ID

Line 459: update OKE_DELIVERABLES_TL T set (

455: from OKE_DELIVERABLES_B B
456: where B.DELIVERABLE_ID = T.DELIVERABLE_ID
457: );
458:
459: update OKE_DELIVERABLES_TL T set (
460: DESCRIPTION,
461: COMMENTS
462: ) = (select
463: B.DESCRIPTION,

Line 465: from OKE_DELIVERABLES_TL B

461: COMMENTS
462: ) = (select
463: B.DESCRIPTION,
464: B.COMMENTS
465: from OKE_DELIVERABLES_TL B
466: where B.DELIVERABLE_ID = T.DELIVERABLE_ID
467: and B.LANGUAGE = T.SOURCE_LANG)
468: where (
469: T.DELIVERABLE_ID,

Line 474: from OKE_DELIVERABLES_TL SUBB, OKE_DELIVERABLES_TL SUBT

470: T.LANGUAGE
471: ) in (select
472: SUBT.DELIVERABLE_ID,
473: SUBT.LANGUAGE
474: from OKE_DELIVERABLES_TL SUBB, OKE_DELIVERABLES_TL SUBT
475: where SUBB.DELIVERABLE_ID = SUBT.DELIVERABLE_ID
476: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
477: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
478: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 485: insert into OKE_DELIVERABLES_TL (

481: or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)
482: or (SUBB.COMMENTS is not null and SUBT.COMMENTS is null)
483: ));
484:
485: insert into OKE_DELIVERABLES_TL (
486: DELIVERABLE_ID,
487: CREATION_DATE,
488: CREATED_BY,
489: LAST_UPDATE_DATE,

Line 507: from OKE_DELIVERABLES_TL B, FND_LANGUAGES L

503: B.DESCRIPTION,
504: B.COMMENTS,
505: L.LANGUAGE_CODE,
506: B.SOURCE_LANG
507: from OKE_DELIVERABLES_TL B, FND_LANGUAGES L
508: where L.INSTALLED_FLAG in ('I', 'B')
509: and B.LANGUAGE = userenv('LANG')
510: and not exists
511: (select NULL

Line 512: from OKE_DELIVERABLES_TL T

508: where L.INSTALLED_FLAG in ('I', 'B')
509: and B.LANGUAGE = userenv('LANG')
510: and not exists
511: (select NULL
512: from OKE_DELIVERABLES_TL T
513: where T.DELIVERABLE_ID = B.DELIVERABLE_ID
514: and T.LANGUAGE = L.LANGUAGE_CODE);
515: end ADD_LANGUAGE;
516: