[Home] [Help]
PACKAGE: APPS.BIS_FND_MENUS_PUB
Source
1 PACKAGE BIS_FND_MENUS_PUB as
2 /* $Header: BISPFMNS.pls 120.0 2005/06/01 18:09:38 appldev noship $ */
3 ----------------------------------------------------------------------------
4 -- PACKAGE: BIS_FND_MENUS_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 -- 03/05/04 nbarik Initial creation --
13 -- 03/01/05 mdamle Added LOCK_ROW, X_MENU_ID In/Out parameter --
14 -- Added validation --
15 -- 19-MAY-2005 visuri GSCC Issues bug 4363854 --
16 ----------------------------------------------------------------------------
17
18 TYPE Fnd_Menu_Rec_Type IS RECORD (
19 menu_name VARCHAR2(30),
20 user_menu_name VARCHAR2(80),
21 type VARCHAR2(30),
22 description VARCHAR2(240)
23 );
24
25 procedure INSERT_ROW (
26 p_MENU_NAME in VARCHAR2
27 ,p_USER_MENU_NAME in VARCHAR2
28 ,p_TYPE in VARCHAR2 := NULL
29 ,p_DESCRIPTION in VARCHAR2 := NULL
30 ,x_MENU_ID in OUT NOCOPY NUMBER
31 ,x_return_status OUT NOCOPY VARCHAR2
32 ,x_msg_count OUT NOCOPY NUMBER
33 ,x_msg_data OUT NOCOPY VARCHAR2
34 );
35
36 procedure UPDATE_ROW (
37 p_MENU_ID in NUMBER
38 ,p_USER_MENU_NAME in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
39 ,p_DESCRIPTION in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
40 ,x_return_status OUT NOCOPY VARCHAR2
41 ,x_msg_count OUT NOCOPY NUMBER
42 ,x_msg_data OUT NOCOPY VARCHAR2
43 );
44
45 PROCEDURE DELETE_ROW (
46 p_MENU_ID in VARCHAR2
47 ,x_return_status OUT NOCOPY VARCHAR2
48 ,x_msg_count OUT NOCOPY NUMBER
49 ,x_msg_data OUT NOCOPY VARCHAR2
50 );
51
52 PROCEDURE DELETE_ROW_MENU_MENUENTRIES (
53 p_MENU_ID in VARCHAR2
54 ,x_return_status OUT NOCOPY VARCHAR2
55 ,x_msg_count OUT NOCOPY NUMBER
56 ,x_msg_data OUT NOCOPY VARCHAR2
57 );
58
59 PROCEDURE LOCK_ROW
60 ( p_menu_id IN NUMBER
61 , p_last_update_date IN DATE
62 );
63
64 END BIS_FND_MENUS_PUB;