DBA Data[Home] [Help]

APPS.FEM_FOLDERS_UTL_PKG dependencies on FEM_USER_FOLDERS

Line 72: INSERT INTO fem_user_folders (folder_id, user_id, write_flag,

68: FROM fem_folders_tl t
69: WHERE t.folder_id = p_folder_id
70: AND t.language = l.language_code);
71:
72: INSERT INTO fem_user_folders (folder_id, user_id, write_flag,
73: object_version_number, created_by, creation_date, last_updated_by,
74: last_update_date, last_update_login) VALUES
75: (p_folder_id, p_user_id, 'Y',1, p_user_id, sysdate, p_user_id,
76: sysdate, v_last_update_login);

Line 130: INSERT INTO fem_user_folders (folder_id, user_id, write_flag,

126: x_return_status := G_RET_STS_SUCCESS;
127:
128: -- Assign user to folder. (The select statement serves as a validation
129: -- to ensure that the folder is valid).
130: INSERT INTO fem_user_folders (folder_id, user_id, write_flag,
131: object_version_number, created_by, creation_date, last_updated_by,
132: last_update_date, last_update_login)
133: SELECT
134: folder_id, p_user_id, p_write_flag,