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 9107: INSERT INTO okc_k_headers_tlh

9103: --------------------------------
9104: -- Versioning TL Table
9105: --------------------------------
9106:
9107: INSERT INTO okc_k_headers_tlh
9108: (
9109: major_version,
9110: id,
9111: language,

Line 9233: FROM okc_k_headers_tlh

9229: creation_date,
9230: last_updated_by,
9231: last_update_date,
9232: last_update_login
9233: FROM okc_k_headers_tlh
9234: WHERE id = p_chr_id
9235: AND major_version = p_major_version;
9236:
9237: --------------------------------------