[Home] [Help]
PACKAGE: APPS.PA_ROLE_STATUS_MENU_PVT
Source
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,
10 P_STATUS_CODE IN VARCHAR2,
11 P_MENU_ID IN NUMBER,
12 P_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
13 P_LAST_UPDATE_DATE IN DATE,
14 P_LAST_UPDATED_BY IN NUMBER,
15 P_CREATION_DATE IN DATE,
16 P_CREATED_BY IN NUMBER,
17 P_LAST_UPDATE_LOGIN IN NUMBER,
18 p_return_status OUT NOCOPY varchar2,
19 p_msg_count out NOCOPY number,
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,
29 p_msg_count out NOCOPY number,
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,
39 P_STATUS_CODE IN VARCHAR2,
40 P_MENU_ID IN NUMBER,
41 P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
42 P_LAST_UPDATE_DATE IN DATE,
43 P_LAST_UPDATED_BY IN NUMBER,
44 P_CREATION_DATE IN DATE,
45 P_CREATED_BY IN NUMBER,
46 P_LAST_UPDATE_LOGIN IN NUMBER,
47 p_return_status OUT NOCOPY varchar2,
48 p_msg_count out NOCOPY number,
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,
58 p_msg_count out NOCOPY number,
59 p_msg_data out NOCOPY varchar2
60 );
61
62 end PA_ROLE_STATUS_MENU_PVT;