APPS.OKC_ARTICLES_GRP dependencies on OKC_FOLDER_CONTENTS

Line 1964: DELETE FROM OKC_FOLDER_CONTENTS -- delete all folder contents

1960: END IF;
1961: DELETE FROM OKC_ARTICLE_RELATNS_ALL -- delete all relationships
1962: WHERE source_article_id = p_article_id OR
1963: target_article_id = p_article_id;
1964: DELETE FROM OKC_FOLDER_CONTENTS -- delete all folder contents
1965: WHERE member_id = p_article_id ;
1966: END IF;
1967: END IF;
1968: END IF;

Line 3753: INSERT INTO OKC_FOLDER_CONTENTS

3749: END IF;
3750: --------------------------------------------
3751: END IF;
3752: IF p_copy_folder_assoc_yn = 'Y' THEN
3753: INSERT INTO OKC_FOLDER_CONTENTS
3754: (
3755: MEMBER_ID ,
3756: FOLDER_ID ,
3757: OBJECT_VERSION_NUMBER,

Line 3773: FROM OKC_FOLDER_CONTENTS mem

3769: sysdate,
3770: sysdate,
3771: l_User_Id,
3772: l_login_Id
3773: FROM OKC_FOLDER_CONTENTS mem
3774: WHERE MEMBER_ID = l_p_article_id
3775: AND exists
3776: (select 1 from okc_folders_all_b fold where
3777: fold.org_id = G_CURRENT_ORG_ID