1 PACKAGE BIS_MENU_ENTRIES_PUB as
2 /* $Header: BISPMNES.pls 120.1 2005/11/03 01:26:55 rpenneru noship $ */
3 ----------------------------------------------------------------------------
4 -- PACKAGE: BIS_MENU_ENTRIES_PUB --
5 -- --
6 -- DESCRIPTION: Private package that calls the FND packages to --
7 -- insert records in the FND tables. --
8 --
9 -- --
10 -- MODIFICATIONS --
11 -- Date User Modification
12 -- XX-XXX-XX XXXXXXXX Modifications made, which procedures changed & --
13 -- list bug number, if fixing a bug. --
14 -- --
15 -- 11/21/01 mdamle Initial creation --
16 -- 12/25/03 mdamle Added a generic routine to attach function to --
17 -- menus --
18 -- 06/24/04 bewong Added a procedure to update the prompt of --
19 -- the function
20 -- 07/14/04 ppalpart Added a procedures to delete roles --
21 -- 07/19/04 ppalpart Added a procedure to delete roles taking --
22 -- only Menu_Id --
23 -- 03/01/05 mdamle Added UPDATE_ROW, LOCK_ROW --
24 -- 11/03/05 rpenneru Added SUBMIT_COMPILE --
25 ----------------------------------------------------------------------------
26
27 procedure INSERT_ROW (
28 X_ROWID in out NOCOPY VARCHAR2,
29 X_USER_ID in NUMBER,
30 X_MENU_ID in NUMBER,
31 X_FUNCTION_ID in NUMBER,
32 X_PROMPT in VARCHAR2,
33 X_DESCRIPTION in VARCHAR2);
34
35 procedure INSERT_ROW (
36 X_MENU_ID in NUMBER,
37 X_ENTRY_SEQUENCE in NUMBER,
38 X_SUB_MENU_ID in NUMBER,
39 X_FUNCTION_ID in NUMBER,
40 X_GRANT_FLAG in VARCHAR2,
41 X_PROMPT in VARCHAR2,
42 X_DESCRIPTION in VARCHAR2,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2);
46
47 procedure UPDATE_ROW (
48 X_MENU_ID in NUMBER,
49 X_ENTRY_SEQUENCE in NUMBER,
50 X_SUB_MENU_ID in NUMBER,
51 X_FUNCTION_ID in NUMBER,
52 X_GRANT_FLAG in VARCHAR2,
53 X_PROMPT in VARCHAR2,
54 X_DESCRIPTION in VARCHAR2,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2);
58
59 procedure UPDATE_PROMPT (
60 X_USER_ID in NUMBER,
61 X_MENU_ID in NUMBER,
62 X_OLD_ENTRY_SEQUENCE in NUMBER,
63 X_FUNCTION_ID in NUMBER,
64 X_PROMPT in VARCHAR2);
65
66 procedure DELETE_ROW (
67 X_MENU_ID in NUMBER,
68 X_ENTRY_SEQUENCE in NUMBER,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2);
72
73 procedure DELETE_ROW (
74 X_MENU_ID in NUMBER,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2);
78
79 procedure AttachFunctionToMenus(
80 p_function_id IN NUMBER
81 ,p_menu_ids IN FND_TABLE_OF_NUMBER
82 ,x_return_status OUT NOCOPY VARCHAR2
83 ,x_msg_count OUT NOCOPY NUMBER
84 ,x_msg_data OUT NOCOPY VARCHAR2
85 );
86
87 procedure AttachFunctionsToMenu(
88 p_menu_id IN NUMBER
89 ,p_function_ids IN FND_TABLE_OF_NUMBER
90 ,x_return_status OUT NOCOPY VARCHAR2
91 ,x_msg_count OUT NOCOPY NUMBER
92 ,x_msg_data OUT NOCOPY VARCHAR2
93 );
94
95 procedure DeleteFunctionsFromMenu(
96 p_menu_id IN NUMBER
97 ,p_function_ids IN FND_TABLE_OF_NUMBER
98 ,x_return_status OUT NOCOPY VARCHAR2
99 ,x_msg_count OUT NOCOPY NUMBER
100 ,x_msg_data OUT NOCOPY VARCHAR2
101 );
102
103 procedure DeleteFunctionFromMenus(
104 p_function_id IN NUMBER
105 ,p_menu_ids IN FND_TABLE_OF_NUMBER
106 ,x_return_status OUT NOCOPY VARCHAR2
107 ,x_msg_count OUT NOCOPY NUMBER
108 ,x_msg_data OUT NOCOPY VARCHAR2
109 );
110
111 PROCEDURE LOCK_ROW
112 ( p_menu_id IN NUMBER
113 , p_entry_sequence IN NUMBER
114 , p_last_update_date IN DATE
115 );
116
117 FUNCTION submit_compile RETURN VARCHAR2;
118
119 END BIS_MENU_ENTRIES_PUB;