1: package PA_ROLE_STATUS_MENU_PVT AUTHID CURRENT_USER AS
2: /* $Header: PAXRSMVS.pls 115.2 2003/08/21 07:38:30 bvarnasi ship $ */
3:
4: procedure INSERT_ROW (
5: p_commit IN VARCHAR2:=FND_API.G_FALSE,
6: p_debug_mode in varchar2 default 'N',
7: P_ROLE_STATUS_MENU_ID OUT NOCOPY NUMBER,
8: P_ROLE_ID IN NUMBER,
9: P_STATUS_TYPE IN VARCHAR2,
20: p_msg_data out NOCOPY varchar2
21: );
22:
23: procedure LOCK_ROW (
24: p_commit IN VARCHAR2:=FND_API.G_FALSE,
25: p_debug_mode in varchar2 default 'N',
26: P_ROLE_STATUS_MENU_ID IN NUMBER,
27: P_OBJECT_VERSION_NUMBER IN NUMBER,
28: p_return_status OUT NOCOPY varchar2,
30: p_msg_data out NOCOPY varchar2
31: );
32:
33: procedure UPDATE_ROW (
34: p_commit IN VARCHAR2:=FND_API.G_FALSE,
35: p_debug_mode in varchar2 default 'N',
36: P_ROLE_STATUS_MENU_ID IN NUMBER,
37: P_ROLE_ID IN NUMBER,
38: P_STATUS_TYPE IN VARCHAR2,
49: p_msg_data out NOCOPY varchar2
50: );
51:
52: procedure DELETE_ROW (
53: p_commit IN VARCHAR2:=FND_API.G_FALSE,
54: p_debug_mode in varchar2 default 'N',
55: P_ROLE_STATUS_MENU_ID IN NUMBER,
56: P_OBJECT_VERSION_NUMBER IN NUMBER,
57: p_return_status OUT NOCOPY varchar2,