APPS.OKC_SCN_PVT dependencies on OKC_SECTIONS_TLH

Line 575: DELETE FROM OKC_SECTIONS_TLH T

571: FROM OKC_SECTIONS_TL T
572: WHERE T.ID = B.ID
573: AND T.LANGUAGE = L.LANGUAGE_CODE
574: );
575: DELETE FROM OKC_SECTIONS_TLH T
576: WHERE NOT EXISTS (
577: SELECT NULL
578: FROM OKC_SECTIONS_BH B
579: WHERE B.ID = T.ID

Line 583: UPDATE OKC_SECTIONS_TLH T SET (

579: WHERE B.ID = T.ID
580: AND B.MAJOR_VERSION = T.MAJOR_VERSION
581: );
582:
583: UPDATE OKC_SECTIONS_TLH T SET (
584: HEADING) = (SELECT
585: B.HEADING
586: FROM OKC_SECTIONS_TLH B
587: WHERE B.ID = T.ID

Line 586: FROM OKC_SECTIONS_TLH B

582:
583: UPDATE OKC_SECTIONS_TLH T SET (
584: HEADING) = (SELECT
585: B.HEADING
586: FROM OKC_SECTIONS_TLH B
587: WHERE B.ID = T.ID
588: AND B.MAJOR_VERSION = T.MAJOR_VERSION
589: AND B.LANGUAGE = T.SOURCE_LANG)
590: WHERE (

Line 598: FROM OKC_SECTIONS_TLH SUBB, OKC_SECTIONS_TLH SUBT

594: IN (SELECT
595: SUBT.ID,
596: SUBT.MAJOR_VERSION,
597: SUBT.LANGUAGE
598: FROM OKC_SECTIONS_TLH SUBB, OKC_SECTIONS_TLH SUBT
599: WHERE SUBB.ID = SUBT.ID
600: AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
601: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
602: AND (SUBB.HEADING <> SUBT.HEADING

Line 607: INSERT INTO OKC_SECTIONS_TLH (

603: OR (SUBB.HEADING IS NULL AND SUBT.HEADING IS NOT NULL)
604: OR (SUBB.HEADING IS NOT NULL AND SUBT.HEADING IS NULL)
605: ));
606:
607: INSERT INTO OKC_SECTIONS_TLH (
608: ID,
609: LANGUAGE,
610: MAJOR_VERSION,
611: SOURCE_LANG,

Line 631: FROM OKC_SECTIONS_TLH B, FND_LANGUAGES L

627: B.CREATION_DATE,
628: B.LAST_UPDATED_BY,
629: B.LAST_UPDATE_DATE,
630: B.LAST_UPDATE_LOGIN
631: FROM OKC_SECTIONS_TLH B, FND_LANGUAGES L
632: WHERE L.INSTALLED_FLAG IN ('I', 'B')
633: AND B.LANGUAGE = USERENV('LANG')
634: AND NOT EXISTS(
635: SELECT NULL

Line 636: FROM OKC_SECTIONS_TLH T

632: WHERE L.INSTALLED_FLAG IN ('I', 'B')
633: AND B.LANGUAGE = USERENV('LANG')
634: AND NOT EXISTS(
635: SELECT NULL
636: FROM OKC_SECTIONS_TLH T
637: WHERE T.ID = B.ID
638: AND T.MAJOR_VERSION = B.MAJOR_VERSION
639: AND T.LANGUAGE = L.LANGUAGE_CODE
640: );

Line 4215: INSERT INTO okc_sections_tlh

4211: --------------------------
4212: -- Versioning TL Table
4213: --------------------------
4214:
4215: INSERT INTO okc_sections_tlh
4216: (
4217: major_version,
4218: id,
4219: language,

Line 4319: FROM okc_sections_tlh

4315: creation_date,
4316: last_updated_by,
4317: last_update_date,
4318: last_update_login
4319: FROM okc_sections_tlh
4320: WHERE id in (SELECT id
4321: FROM okc_sections_bh
4322: WHERE chr_id = p_chr_id)
4323: AND major_version = p_major_version;