62: return l_folder_id;
63: END insert_fnd_folders;
64:
65:
66: PROCEDURE insert_fnd_folder_columns (l_folder_id NUMBER,
67: l_display_mode VARCHAR2,
68: l_item_name VARCHAR2,
69: l_sequence NUMBER,
70: l_created_by NUMBER,
74: l_x_position NUMBER,
75: l_y_position NUMBER) IS
76: PRAGMA AUTONOMOUS_TRANSACTION;
77: BEGIN
78: insert into fnd_folder_columns(
79: folder_id,
80: display_mode,
81: item_name,
82: sequence,
104: l_x_position,
105: l_y_position);
106:
107: COMMIT;
108: END insert_fnd_folder_columns;
109:
110:
111: PROCEDURE insert_fnd_default_folders (l_object VARCHAR2,
112: l_user_id NUMBER,
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;
201: BEGIN
202: DELETE from fnd_folder_columns
203: WHERE folder_id = l_folder_id;
198:
199: PROCEDURE delete_fnd_folder_columns (l_folder_id NUMBER) is
200: PRAGMA AUTONOMOUS_TRANSACTION;
201: BEGIN
202: DELETE from fnd_folder_columns
203: WHERE folder_id = l_folder_id;
204:
205: commit;
206: END delete_fnd_folder_columns;
202: DELETE from fnd_folder_columns
203: WHERE folder_id = l_folder_id;
204:
205: commit;
206: END delete_fnd_folder_columns;
207:
208:
209: PROCEDURE delete_fnd_folders (l_folder_id NUMBER) is
210: PRAGMA AUTONOMOUS_TRANSACTION;