1 PACKAGE pa_role_status_menu_pkg AUTHID CURRENT_USER AS
2 /* $Header: PAXRSMTS.pls 120.1 2005/08/19 17:19:30 mwasowic noship $ */
3
4 PROCEDURE INSERT_ROW (
5 --P_ROWID IN OUT VARCHAR2,
6 P_ROLE_STATUS_MENU_ID OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
7 P_ROLE_ID IN NUMBER,
8 P_STATUS_TYPE IN VARCHAR2,
9 P_STATUS_CODE IN VARCHAR2,
10 P_MENU_ID IN NUMBER,
11 P_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
12 P_LAST_UPDATE_DATE IN DATE,
13 P_LAST_UPDATED_BY IN NUMBER,
14 P_CREATION_DATE IN DATE,
15 P_CREATED_BY IN NUMBER,
16 P_LAST_UPDATE_LOGIN IN NUMBER
17 );
18
19 PROCEDURE LOCK_ROW (
20 P_ROLE_STATUS_MENU_ID IN NUMBER,
21 P_OBJECT_VERSION_NUMBER IN NUMBER
22 );
23
24
25 PROCEDURE UPDATE_ROW (
26 --P_ROWID IN OUT VARCHAR2,
27 P_ROLE_STATUS_MENU_ID IN NUMBER,
28 P_ROLE_ID IN NUMBER,
29 P_STATUS_TYPE IN VARCHAR2,
30 P_STATUS_CODE IN VARCHAR2,
31 P_MENU_ID IN NUMBER,
32 P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
33 P_LAST_UPDATE_DATE IN DATE,
34 P_LAST_UPDATED_BY IN NUMBER,
35 P_CREATION_DATE IN DATE,
36 P_CREATED_BY IN NUMBER,
37 P_LAST_UPDATE_LOGIN IN NUMBER
38 );
39
40 PROCEDURE DELETE_ROW (
41 P_ROLE_STATUS_MENU_ID IN NUMBER,
42 P_OBJECT_VERSION_NUMBER IN NUMBER);
43
44 END pa_role_status_menu_pkg ;