1 package FND_MENUS_PKG AUTHID CURRENT_USER as
2 /* $Header: AFMNMNUS.pls 120.2 2005/10/05 06:26:20 stadepal ship $ */
3 /*#
4 * Table Handler to insert or update data in FND_MENUS table.
5 * @rep:scope public
6 * @rep:product FND
7 * @rep:displayname Menu
8 * @rep:lifecycle active
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY FND_MENU
11 * @rep:ihelp FND/@o_funcsec#o_funcsec See the related online help
12 */
13
14 procedure INSERT_ROW (
15 X_ROWID in out nocopy VARCHAR2,
16 X_MENU_ID in NUMBER,
17 X_MENU_NAME in VARCHAR2,
18 X_USER_MENU_NAME in VARCHAR2,
19 X_MENU_TYPE in VARCHAR2,
20 X_DESCRIPTION in VARCHAR2,
21 X_CREATION_DATE in DATE,
22 X_CREATED_BY in NUMBER,
23 X_LAST_UPDATE_DATE in DATE,
24 X_LAST_UPDATED_BY in NUMBER,
25 X_LAST_UPDATE_LOGIN in NUMBER);
26 procedure LOCK_ROW (
27 X_MENU_ID in NUMBER,
28 X_MENU_NAME in VARCHAR2,
29 X_USER_MENU_NAME in VARCHAR2,
30 X_MENU_TYPE in VARCHAR2,
31 X_DESCRIPTION in VARCHAR2
32 );
33 procedure UPDATE_ROW (
34 X_MENU_ID in NUMBER,
35 X_MENU_NAME in VARCHAR2,
36 X_USER_MENU_NAME in VARCHAR2,
37 X_MENU_TYPE in VARCHAR2,
38 X_DESCRIPTION in VARCHAR2,
39 X_LAST_UPDATE_DATE in DATE,
40 X_LAST_UPDATED_BY in NUMBER,
41 X_LAST_UPDATE_LOGIN in NUMBER
42 );
43 /* Overloaded version below */
44 procedure LOAD_ROW (
45 X_MENU_NAME in VARCHAR2,
46 X_MENU_TYPE in VARCHAR2,
47 X_USER_MENU_NAME in VARCHAR2,
48 X_DESCRIPTION in VARCHAR2,
49 X_OWNER in VARCHAR2,
50 X_CUSTOM_MODE in VARCHAR2
51 );
52 procedure DELETE_ROW (
53 X_MENU_ID in NUMBER
54 );
55 procedure ADD_LANGUAGE;
56
57 /* Overloaded version below */
58 procedure TRANSLATE_ROW (
59 X_MENU_ID in NUMBER,
60 X_USER_MENU_NAME in VARCHAR2,
61 X_DESCRIPTION in VARCHAR2,
62 X_OWNER in VARCHAR2,
63 X_CUSTOM_MODE in VARCHAR2
64 );
65
66 procedure SET_NEW_MENU;
67
68 function NEXT_ENTRY_SEQUENCE return number;
69
70 currentryseq number := 0;
71
72 function VALIDATE_MENU_TYPE(X_MENU_TYPE in VARCHAR2) return boolean;
73
74 /* Overloaded version above */
75 /*#
76 * Creates or updates Menu data as appropriate
77 * @param x_menu_name Menu Name
78 * @param x_menu_type Menu Type
79 * @param x_user_menu_name User Menu Name
80 * @param x_description Description
81 * @param x_owner Owner Name
82 * @param x_custom_mode Custom Mode
83 * @param x_last_update_date Insert/Update Date
84 * @rep:scope public
85 * @rep:lifecycle active
86 * @rep:displayname Create/Update Menu
87 * @rep:compatibility S
88 * @rep:ihelp FND/@dev_p_funcworks#dev_p_funcworks See the related online help
89 */
90 procedure LOAD_ROW (
91 X_MENU_NAME in VARCHAR2,
92 X_MENU_TYPE in VARCHAR2,
93 X_USER_MENU_NAME in VARCHAR2,
94 X_DESCRIPTION in VARCHAR2,
95 X_OWNER in VARCHAR2,
96 X_CUSTOM_MODE in VARCHAR2,
97 X_LAST_UPDATE_DATE in VARCHAR2
98 );
99 /* Overloaded version above */
100 procedure TRANSLATE_ROW (
101 X_MENU_ID in NUMBER,
102 X_USER_MENU_NAME in VARCHAR2,
103 X_DESCRIPTION in VARCHAR2,
104 X_OWNER in VARCHAR2,
105 X_CUSTOM_MODE in VARCHAR2,
106 X_LAST_UPDATE_DATE in VARCHAR2
107 );
108 end FND_MENUS_PKG;