APPS.OKC_ARTICLES_MIGRATE_GRP dependencies on OKC_FOLDERS_ALL_B

Line 706: INSERT INTO OKC_FOLDERS_ALL_B (

702: i := 0;
703: -- Migrate all folders from article sets
704: BEGIN
705: FORALL i in l_org_id_tbl.FIRST .. l_org_id_tbl.LAST
706: INSERT INTO OKC_FOLDERS_ALL_B (
707: FOLDER_ID,
708: OBJECT_VERSION_NUMBER,
709: ORG_ID,
710: SAT_CODE,

Line 734: OKC_FOLDERS_ALL_B_S1.NEXTVAL,

730: LAST_UPDATED_BY,
731: LAST_UPDATE_LOGIN
732: )
733: SELECT
734: OKC_FOLDERS_ALL_B_S1.NEXTVAL,
735: 1,
736: l_org_id_tbl(i),
737: LOOKUP_CODE,
738: ATTRIBUTE_CATEGORY,

Line 764: 1 FROM OKC_FOLDERS_ALL_B FLD

760: WHERE LOOKUP_TYPE = 'OKC_ARTICLE_SET'
761: AND LANGUAGE = USERENV('LANG')
762: AND NOT EXISTS
763: (SELECT /*+ NO_UNNEST */
764: 1 FROM OKC_FOLDERS_ALL_B FLD
765: WHERE FLD.SAT_CODE = LKU.LOOKUP_CODE
766: AND ORG_ID = l_org_id_tbl(i));
767: EXCEPTION
768: WHEN OTHERS THEN

Line 807: FROM FND_LOOKUP_VALUES LKU , OKC_FOLDERS_ALL_B FLD

803: LKU.LAST_UPDATE_LOGIN,
804: FLD.FOLDER_ID,
805: LKU.LANGUAGE,
806: LKU.LANGUAGE
807: FROM FND_LOOKUP_VALUES LKU , OKC_FOLDERS_ALL_B FLD
808: WHERE LOOKUP_CODE = SAT_CODE
809: AND LOOKUP_TYPE = 'OKC_ARTICLE_SET'
810: AND NOT EXISTS
811: (SELECT /*+ NO_UNNEST */

Line 1860: FROM OKC_STD_ART_SET_MEMS SM, OKC_FOLDERS_ALL_B FLD

1856: SM.CREATION_DATE,
1857: SM.LAST_UPDATED_BY,
1858: SM.LAST_UPDATE_LOGIN,
1859: SM.LAST_UPDATE_DATE
1860: FROM OKC_STD_ART_SET_MEMS SM, OKC_FOLDERS_ALL_B FLD
1861: WHERE FLD.SAT_CODE = SM.SAT_CODE
1862: AND SAE_ID = art_system_reference_id1_tbl(i)
1863: AND system_reference_code_tbl(i) = 'OKCMIGORIG'
1864: AND art_process_status_tbl(i) = 'S'