APPS.FND_APPFLDR dependencies on FND_DEFAULT_FOLDERS

Line 111: PROCEDURE insert_fnd_default_folders (l_object VARCHAR2,

107: COMMIT;
108: END insert_fnd_folder_columns;
109:
110:
111: PROCEDURE insert_fnd_default_folders (l_object VARCHAR2,
112: l_user_id NUMBER,
113: l_folder_id NUMBER,
114: l_created_by NUMBER,
115: l_last_updated_by NUMBER) IS

Line 118: insert into fnd_default_folders(

114: l_created_by NUMBER,
115: l_last_updated_by NUMBER) IS
116: PRAGMA AUTONOMOUS_TRANSACTION;
117: BEGIN
118: insert into fnd_default_folders(
119: object,
120: user_id,
121: folder_id,
122: creation_date,

Line 138: END insert_fnd_default_folders;

134: l_last_updated_by,
135: null);
136:
137: COMMIT;
138: END insert_fnd_default_folders;
139:
140:
141: PROCEDURE update_fnd_folders (l_folder_id NUMBER,
142: l_name VARCHAR2,

Line 172: PROCEDURE delete_fnd_default_folders(l_object VARCHAR2,

168: COMMIT;
169: END update_fnd_folders;
170:
171:
172: PROCEDURE delete_fnd_default_folders(l_object VARCHAR2,
173: l_user_id NUMBER,
174: l_language VARCHAR2) is
175: PRAGMA AUTONOMOUS_TRANSACTION;
176: BEGIN

Line 177: DELETE from fnd_default_folders fdf

173: l_user_id NUMBER,
174: l_language VARCHAR2) is
175: PRAGMA AUTONOMOUS_TRANSACTION;
176: BEGIN
177: DELETE from fnd_default_folders fdf
178: WHERE object = l_object
179: and user_id = l_user_id
180: and exists (select null
181: from fnd_folders ff

Line 186: END delete_fnd_default_folders;

182: where fdf.folder_id = ff.folder_id
183: and ff.language = l_language);
184:
185: commit;
186: END delete_fnd_default_folders;
187:
188:
189: PROCEDURE delete_fnd_default_folders (l_folder_id NUMBER) is
190: PRAGMA AUTONOMOUS_TRANSACTION;

Line 189: PROCEDURE delete_fnd_default_folders (l_folder_id NUMBER) is

185: commit;
186: END delete_fnd_default_folders;
187:
188:
189: PROCEDURE delete_fnd_default_folders (l_folder_id NUMBER) is
190: PRAGMA AUTONOMOUS_TRANSACTION;
191: BEGIN
192: DELETE from fnd_default_folders
193: WHERE folder_id = l_folder_id;

Line 192: DELETE from fnd_default_folders

188:
189: PROCEDURE delete_fnd_default_folders (l_folder_id NUMBER) is
190: PRAGMA AUTONOMOUS_TRANSACTION;
191: BEGIN
192: DELETE from fnd_default_folders
193: WHERE folder_id = l_folder_id;
194:
195: commit;
196: END delete_fnd_default_folders;

Line 196: END delete_fnd_default_folders;

192: DELETE from fnd_default_folders
193: WHERE folder_id = l_folder_id;
194:
195: commit;
196: END delete_fnd_default_folders;
197:
198:
199: PROCEDURE delete_fnd_folder_columns (l_folder_id NUMBER) is
200: PRAGMA AUTONOMOUS_TRANSACTION;