PACKAGE: APPS.CS_QKMENU_DML_PKG

Source

1 PACKAGE CS_QKMENU_DML_PKG AUTHID CURRENT_USER as
2 /* $Header: csqkmens.pls 115.3 2002/12/17 05:09:43 bhroy ship $ */
3 -- 12-17-2002	bhroy 	added WHENEVER OSERROR EXIT FAILURE ROLLBACK
4 
5 
6   PROCEDURE SAVE_FOLDER_INTO_DB(l_user_id         IN  NUMBER,
7 						  l_description     IN  VARCHAR2,
8 						  l_folder_name     IN  VARCHAR2, /*save as name*/
9 						  l_default_flag    IN  VARCHAR2);
10 
11 
12   PROCEDURE insert_holder(l_user_folder_id        NUMBER,
13                           l_function_filter_id    NUMBER,
14                           l_user_id               NUMBER,
15                           l_filter_value          VARCHAR2,
16                           l_filter_value_id       NUMBER := null
17                           );
18 
19 
20   PROCEDURE update_holder(l_user_folder_id        NUMBER,
21                           l_function_filter_id    NUMBER,
22                           l_user_id               NUMBER,
23                           l_filter_value          VARCHAR2,
24                           l_filter_value_id       NUMBER := null
25                           );
26 
27   PROCEDURE insert_empty_folder(l_user_id     NUMBER,
28                                 l_folder_name VARCHAR2);
29 
30 
31   PROCEDURE new_folder(l_user_id      NUMBER,
32                        folder_name    VARCHAR2,
33                        description    VARCHAR2);
34 
35   PROCEDURE update_default_flag(l_user_id      NUMBER,
36                                 l_folder_name  VARCHAR2,
37                                 l_default_flag VARCHAR2);
38 
39 
40 END CS_QKMENU_DML_PKG;
41