APPS.OKC_ARTICLES_MIGRATE_GRP dependencies on OKC_STD_ART_VERSIONS_TL

Line 455: FROM OKC_STD_ART_VERSIONS_TL ARTVL,

451: -99 ART_ARTICLE_ID,
452: ARTL.ID ART_SYSTEM_REFERENCE_ID1,
453: ARTVL.LANGUAGE ART_ARTICLE_LANGUAGE,
454: ARTVL.LANGUAGE ARTV_ARTICLE_LANGUAGE
455: FROM OKC_STD_ART_VERSIONS_TL ARTVL,
456: OKC_STD_ARTICLES_TL ARTL
457: WHERE ARTL.LANGUAGE = ARTL.SOURCE_LANG
458: AND ARTL.LANGUAGE = cp_base_language
459: AND ARTVL.LANGUAGE = ARTVL.SOURCE_LANG

Line 484: OKC_STD_ART_VERSIONS_TL ARTVL

480: ARTV.SAV_RELEASE,
481: ARTV.DATE_ACTIVE,
482: ARTVL.TEXT
483: FROM OKC_STD_ART_VERSIONS_B ARTV,
484: OKC_STD_ART_VERSIONS_TL ARTVL
485: WHERE ARTV.SAE_ID = cp_article_id
486: AND ARTVL.LANGUAGE = ARTVL.SOURCE_LANG
487: AND ARTVL.LANGUAGE = cp_language
488: AND ARTVL.SAE_ID = ARTV.SAE_ID

Line 678: UPDATE OKC_STD_ART_VERSIONS_TL

674: RAISE FND_API.G_EXC_ERROR ;
675: END IF;
676:
677: -- Update Article Text with ' ' to be migrated to OKC_ARTICLE_VERSIONS
678: UPDATE OKC_STD_ART_VERSIONS_TL
679: SET TEXT = ' '
680: WHERE TEXT IS NULL;
681:
682:

Line 1411: OKC_STD_ART_VERSIONS_TL T

1407: b.last_updated_by, -- Last Updated By
1408: b.last_update_login, -- Last Update Login
1409: SYSDATE -- Last Update Date
1410: FROM OKC_STD_ART_VERSIONS_B B,
1411: OKC_STD_ART_VERSIONS_TL T
1412: WHERE
1413: B.SAE_ID = t_ver_system_reference_id1_tbl(i)
1414: AND B.SAV_RELEASE = t_artv_sav_release_tbl(i)
1415: AND T.LANGUAGE = t_ver_language_tbl(i)