[Home] [Help]
PACKAGE: APPS.PA_ROLE_CONTROLS_PVT
Source
1 PACKAGE pa_role_controls_pvt AS
2 /* $Header: PARPRCVS.pls 120.1 2005/08/19 16:58:53 mwasowic noship $ */
3
4 --
5 -- PROCEDURE
6 -- Insert_Row
7 -- PURPOSE
8 -- This procedure inserts a row into the pa_role_controls table.
9 --
10 -- HISTORY
11 -- 08-AUG-00 jwhite Created
12 --
13
14 PROCEDURE INSERT_ROW (
15 P_ROWID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
16 P_ROLE_CONTROL_CODE IN VARCHAR2,
17 P_PROJECT_ROLE_ID IN NUMBER,
18 P_LAST_UPDATE_DATE IN DATE,
19 P_LAST_UPDATED_BY IN NUMBER,
20 P_CREATION_DATE IN DATE,
21 P_CREATED_BY IN NUMBER,
22 P_LAST_UPDATE_LOGIN IN NUMBER,
23 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
24 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
25 X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
26 );
27
28 --
29 -- PROCEDURE
30 -- Lock_Row
31 -- PURPOSE
32 -- This procedure determines if a row in the pa_role_controls table can
33 -- be locked. If a row can be locked, this API returns (S)uccess for
34 -- x_return_status.
35 --
36 -- HISTORY
37 -- 08-AUG-00 jwhite Created
38 --
39
40 PROCEDURE LOCK_ROW (
41 P_ROWID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
42 P_RECORD_VERSION_NUMBER IN NUMBER,
43 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
44 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
45 X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
46 );
47
48
49 --
50 -- PROCEDURE
51 -- Update_Row
52 -- PURPOSE
53 -- This procedure updates a row in the pa_role_controls table.
54 --
55 -- HISTORY
56 -- 08-AUG-00 jwhite Created
57 --
58
59 PROCEDURE UPDATE_ROW (
60 P_ROWID IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
61 P_ROLE_CONTROL_CODE IN VARCHAR2,
62 P_PROJECT_ROLE_ID IN NUMBER,
63 P_LAST_UPDATE_DATE IN DATE,
64 P_LAST_UPDATED_BY IN NUMBER,
65 P_CREATION_DATE IN DATE,
66 P_CREATED_BY IN NUMBER,
67 P_LAST_UPDATE_LOGIN IN NUMBER,
68 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
69 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
70 X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
71 );
72
73 --
74 -- PROCEDURE
75 -- Delete_Row
76 -- PURPOSE
77 -- This procedure deletes a row in the pa_role_controls table.
78 -- If a row is deleted, this API returns (S)uccess for the
79 -- x_return_status.
80 --
81 -- HISTORY
82 -- 08-AUG-00 jwhite Created
83 --
84
85 PROCEDURE DELETE_ROW (
86 P_Rowid IN VARCHAR2,
87 X_RETURN_STATUS OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
88 X_MSG_COUNT OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
89 X_MSG_DATA OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
90 );
91
92
93 END pa_role_controls_pvt;