APPS.OKC_CHR_PVT dependencies on OKC_K_HEADERS_TLH

Line 2551: DELETE FROM OKC_K_HEADERS_TLH T

2547:
2548:
2549: /* Commenting delete and update for bug 3723874 */
2550: /*
2551: DELETE FROM OKC_K_HEADERS_TLH T
2552: WHERE NOT EXISTS (
2553: SELECT NULL
2554: FROM OKC_K_HEADERS_BH B
2555: WHERE B.ID = T.ID

Line 2559: UPDATE OKC_K_HEADERS_TLH T SET (

2555: WHERE B.ID = T.ID
2556: AND B.MAJOR_VERSION = T.MAJOR_VERSION
2557: );
2558:
2559: UPDATE OKC_K_HEADERS_TLH T SET (
2560: SHORT_DESCRIPTION,
2561: COMMENTS,
2562: DESCRIPTION,
2563: COGNOMEN,

Line 2574: FROM OKC_K_HEADERS_TLH B

2570: B.COGNOMEN,
2571: B.NON_RESPONSE_REASON,
2572: B.NON_RESPONSE_EXPLAIN,
2573: B.SET_ASIDE_REASON
2574: FROM OKC_K_HEADERS_TLH B
2575: WHERE B.ID = T.ID
2576: AND B.MAJOR_VERSION = T.MAJOR_VERSION
2577: AND B.LANGUAGE = T.SOURCE_LANG)
2578: WHERE (

Line 2586: FROM OKC_K_HEADERS_TLH SUBB, OKC_K_HEADERS_TLH SUBT

2582: IN (SELECT
2583: SUBT.ID,
2584: SUBT.MAJOR_VERSION,
2585: SUBT.LANGUAGE
2586: FROM OKC_K_HEADERS_TLH SUBB, OKC_K_HEADERS_TLH SUBT
2587: WHERE SUBB.ID = SUBT.ID
2588: AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
2589: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
2590: AND (SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION

Line 2615: INSERT /*+ append parallel(tt) */ INTO OKC_K_HEADERS_TLH tt(

2611: ));
2612:
2613: */
2614: /* Modifying Insert as per performance guidelines given in bug 3723874 */
2615: INSERT /*+ append parallel(tt) */ INTO OKC_K_HEADERS_TLH tt(
2616: ID,
2617: LANGUAGE,
2618: MAJOR_VERSION,
2619: SOURCE_LANG,

Line 2652: FROM OKC_K_HEADERS_TLH B, FND_LANGUAGES L

2648: B.CREATION_DATE,
2649: B.LAST_UPDATED_BY,
2650: B.LAST_UPDATE_DATE,
2651: B.LAST_UPDATE_LOGIN
2652: FROM OKC_K_HEADERS_TLH B, FND_LANGUAGES L
2653: WHERE L.INSTALLED_FLAG IN ('I', 'B')
2654: AND B.LANGUAGE = USERENV('LANG')
2655: ) v, OKC_K_HEADERS_TLH t
2656: WHERE T.ID( + ) = v.ID

Line 2655: ) v, OKC_K_HEADERS_TLH t

2651: B.LAST_UPDATE_LOGIN
2652: FROM OKC_K_HEADERS_TLH B, FND_LANGUAGES L
2653: WHERE L.INSTALLED_FLAG IN ('I', 'B')
2654: AND B.LANGUAGE = USERENV('LANG')
2655: ) v, OKC_K_HEADERS_TLH t
2656: WHERE T.ID( + ) = v.ID
2657: AND T.MAJOR_VERSION( + ) = v.MAJOR_VERSION
2658: AND T.LANGUAGE( + ) = v.LANGUAGE_CODE
2659: AND t.id IS NULL;

Line 9091: INSERT INTO okc_k_headers_tlh

9087: --------------------------------
9088: -- Versioning TL Table
9089: --------------------------------
9090:
9091: INSERT INTO okc_k_headers_tlh
9092: (
9093: major_version,
9094: id,
9095: language,

Line 9217: FROM okc_k_headers_tlh

9213: creation_date,
9214: last_updated_by,
9215: last_update_date,
9216: last_update_login
9217: FROM okc_k_headers_tlh
9218: WHERE id = p_chr_id
9219: AND major_version = p_major_version;
9220:
9221: --------------------------------------