APPS.OKC_ARTICLES_GRP dependencies on OKC_FOLDER_CONTENTS

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

1918: END IF;
1919: DELETE FROM OKC_ARTICLE_RELATNS_ALL -- delete all relationships
1920: WHERE source_article_id = p_article_id OR
1921: target_article_id = p_article_id;
1922: DELETE FROM OKC_FOLDER_CONTENTS -- delete all folder contents
1923: WHERE member_id = p_article_id ;
1924: END IF;
1925: END IF;
1926: END IF;

Line 3627: INSERT INTO OKC_FOLDER_CONTENTS

3623: END IF;
3624: --------------------------------------------
3625: END IF;
3626: IF p_copy_folder_assoc_yn = 'Y' THEN
3627: INSERT INTO OKC_FOLDER_CONTENTS
3628: (
3629: MEMBER_ID ,
3630: FOLDER_ID ,
3631: OBJECT_VERSION_NUMBER,

Line 3647: FROM OKC_FOLDER_CONTENTS mem

3643: sysdate,
3644: sysdate,
3645: l_User_Id,
3646: l_login_Id
3647: FROM OKC_FOLDER_CONTENTS mem
3648: WHERE MEMBER_ID = l_p_article_id
3649: AND exists
3650: (select 1 from okc_folders_all_b fold where
3651: fold.org_id = G_CURRENT_ORG_ID