[Home] [Help]
PACKAGE: APPS.PA_ROLE_JOB_BG_PVT
Source
1 package PA_ROLE_JOB_BG_PVT AUTHID CURRENT_USER AS
2 /* $Header: PAXRJBVS.pls 115.1 2003/08/25 19:01:53 ramurthy 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_JOB_BG_ID OUT NOCOPY NUMBER,
8 P_PROJECT_ROLE_ID IN NUMBER,
9 P_BUSINESS_GROUP_ID IN NUMBER,
10 P_JOB_ID IN NUMBER,
11 P_MIN_JOB_LEVEL IN NUMBER,
12 P_MAX_JOB_LEVEL IN NUMBER,
13 P_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
14 P_LAST_UPDATE_DATE IN DATE,
15 P_LAST_UPDATED_BY IN NUMBER,
16 P_CREATION_DATE IN DATE,
17 P_CREATED_BY IN NUMBER,
18 P_LAST_UPDATE_LOGIN IN NUMBER,
19 p_return_status OUT NOCOPY VARCHAR2,
20 p_msg_count OUT NOCOPY NUMBER,
21 p_msg_data OUT NOCOPY VARCHAR2
22 );
23
24 procedure LOCK_ROW (
25 p_commit IN VARCHAR2:=FND_API.G_FALSE,
26 p_debug_mode IN VARCHAR2 DEFAULT 'N',
27 P_ROLE_JOB_BG_ID IN NUMBER,
28 P_OBJECT_VERSION_NUMBER IN NUMBER,
29 p_return_status OUT NOCOPY VARCHAR2,
30 p_msg_count OUT NOCOPY NUMBER,
31 p_msg_data OUT NOCOPY VARCHAR2
32 );
33
34 procedure UPDATE_ROW (
35 p_commit IN VARCHAR2:=FND_API.G_FALSE,
36 p_debug_mode IN VARCHAR2 DEFAULT 'N',
37 P_ROLE_JOB_BG_ID IN NUMBER,
38 P_PROJECT_ROLE_ID IN NUMBER,
39 P_BUSINESS_GROUP_ID IN NUMBER,
40 P_JOB_ID IN NUMBER,
41 P_MIN_JOB_LEVEL IN NUMBER,
42 P_MAX_JOB_LEVEL IN NUMBER,
43 P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
44 P_LAST_UPDATE_DATE IN DATE,
45 P_LAST_UPDATED_BY IN NUMBER,
46 P_CREATION_DATE IN DATE,
47 P_CREATED_BY IN NUMBER,
48 P_LAST_UPDATE_LOGIN IN NUMBER,
49 p_return_status OUT NOCOPY VARCHAR2,
50 p_msg_count OUT NOCOPY NUMBER,
51 p_msg_data OUT NOCOPY VARCHAR2
52 );
53
54 procedure DELETE_ROW (
55 p_commit IN VARCHAR2:=FND_API.G_FALSE,
56 p_debug_mode IN VARCHAR2 DEFAULT 'N',
57 P_ROLE_JOB_BG_ID IN NUMBER,
58 P_OBJECT_VERSION_NUMBER IN NUMBER,
59 p_return_status OUT NOCOPY VARCHAR2,
60 p_msg_count OUT NOCOPY NUMBER,
61 p_msg_data OUT NOCOPY VARCHAR2
62 );
63
64 end PA_ROLE_JOB_BG_PVT;