APPS.CS_QKMENU_DML_PKG dependencies on CS_QM_USER_FOLDERS

Line 29: FROM cs_qm_user_folders

25:
26: -- find out if the folder exists, if so, update it, if not, insert it
27: SELECT NVL(COUNT(*), 0)
28: INTO record_exist
29: FROM cs_qm_user_folders
30: WHERE folder_name = l_folder_name
31: AND user_id = l_user_id;
32:
33: SELECT CS_QM_USER_FOLDERS_S.NextVal

Line 33: SELECT CS_QM_USER_FOLDERS_S.NextVal

29: FROM cs_qm_user_folders
30: WHERE folder_name = l_folder_name
31: AND user_id = l_user_id;
32:
33: SELECT CS_QM_USER_FOLDERS_S.NextVal
34: INTO next_sequence
35: FROM dual;
36:
37: IF (record_exist > 0) THEN

Line 38: UPDATE cs_qm_user_folders

34: INTO next_sequence
35: FROM dual;
36:
37: IF (record_exist > 0) THEN
38: UPDATE cs_qm_user_folders
39: SET description = l_description
40: WHERE folder_name = l_folder_name
41: AND user_id = l_user_id;
42: COMMIT;

Line 44: INSERT INTO cs_qm_user_folders

40: WHERE folder_name = l_folder_name
41: AND user_id = l_user_id;
42: COMMIT;
43: ELSE
44: INSERT INTO cs_qm_user_folders
45: (user_folder_id, last_update_date, last_updated_by, creation_date,
46: created_by, user_id, folder_name, description, default_flag,
47: active_flag, object_version_number)
48: VALUES

Line 61: UPDATE cs_qm_user_folders

57: -- clean up the older default_flag and set the new default_flag
58: IF (l_default_flag = 'N') THEN
59: RETURN;
60: ELSE
61: UPDATE cs_qm_user_folders
62: SET default_flag = 'N'
63: WHERE default_flag = 'Y';
64: COMMIT;
65:

Line 67: UPDATE cs_qm_user_folders

63: WHERE default_flag = 'Y';
64: COMMIT;
65:
66: IF (record_exist > 0) THEN
67: UPDATE cs_qm_user_folders
68: SET default_flag = 'Y'
69: WHERE folder_name = l_folder_name
70: AND user_id = l_user_id;
71: COMMIT;

Line 73: UPDATE cs_qm_user_folders

69: WHERE folder_name = l_folder_name
70: AND user_id = l_user_id;
71: COMMIT;
72: ELSE
73: UPDATE cs_qm_user_folders
74: SET default_flag = 'Y'
75: WHERE user_folder_id = next_sequence
76: AND user_id = l_user_id;
77: COMMIT;

Line 141: FROM cs_qm_user_folders

137: BEGIN
138:
139: SELECT user_folder_id
140: INTO l_user_folder_id
141: FROM cs_qm_user_folders
142: WHERE user_id = l_user_id
143: AND folder_name = l_folder_name;
144:
145: FOR filter_item in filter_rec LOOP

Line 172: SELECT CS_QM_USER_FOLDERS_s.NextVal

168: next_sequence NUMBER;
169:
170: BEGIN
171:
172: SELECT CS_QM_USER_FOLDERS_s.NextVal
173: INTO next_sequence
174: FROM dual;
175:
176: INSERT INTO cs_qm_user_folders

Line 176: INSERT INTO cs_qm_user_folders

172: SELECT CS_QM_USER_FOLDERS_s.NextVal
173: INTO next_sequence
174: FROM dual;
175:
176: INSERT INTO cs_qm_user_folders
177: (user_folder_id, last_update_date, last_updated_by, creation_date,
178: created_by, user_id, folder_name, description, default_flag,
179: active_flag, object_version_number)
180: VALUES

Line 198: UPDATE cs_qm_user_folders

194:
195: IF (l_default_flag = 'N') THEN
196: RETURN;
197: ELSE
198: UPDATE cs_qm_user_folders
199: SET default_flag = 'N'
200: WHERE default_flag = 'Y'
201: AND user_id = l_user_id;
202: COMMIT;

Line 204: UPDATE cs_qm_user_folders

200: WHERE default_flag = 'Y'
201: AND user_id = l_user_id;
202: COMMIT;
203:
204: UPDATE cs_qm_user_folders
205: SET default_flag = 'Y'
206: WHERE folder_name = l_folder_name
207: AND user_id = l_user_id;
208: COMMIT;