PACKAGE: APPS.PA_ROLE_LISTS_PVT

Source

1 package PA_ROLE_LISTS_PVT AUTHID CURRENT_USER AS
2  /* $Header: PARLTPVS.pls 120.1 2005/08/19 16:55:57 mwasowic noship $ */
3 ------------------------------------------------------------------------------
4 procedure INSERT_ROW (
5   P_ROWID in out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6   P_ROLE_LIST_ID NUMBER,
7   P_NAME VARCHAR2,
8   P_START_DATE_ACTIVE DATE,
9   P_END_DATE_ACTIVE DATE,
10   P_DESCRIPTION VARCHAR2,
11   P_ATTRIBUTE_CATEGORY VARCHAR2,
12   P_ATTRIBUTE1 VARCHAR2,
13   P_ATTRIBUTE2 VARCHAR2,
14   P_ATTRIBUTE3 VARCHAR2,
15   P_ATTRIBUTE4 VARCHAR2,
16   P_ATTRIBUTE5 VARCHAR2,
17   P_ATTRIBUTE6 VARCHAR2,
18   P_ATTRIBUTE7 VARCHAR2,
19   P_ATTRIBUTE8 VARCHAR2,
20   P_ATTRIBUTE9 VARCHAR2,
21   P_ATTRIBUTE10 VARCHAR2,
22   P_ATTRIBUTE11 VARCHAR2,
23   P_ATTRIBUTE12 VARCHAR2,
24   P_ATTRIBUTE13 VARCHAR2,
25   P_ATTRIBUTE14 VARCHAR2,
26   P_ATTRIBUTE15 VARCHAR2,
27   P_CREATION_DATE DATE,
28   P_CREATED_BY NUMBER,
29   P_LAST_UPDATE_DATE DATE,
30   P_LAST_UPDATED_BY NUMBER,
31   P_LAST_UPDATE_LOGIN NUMBER,
32   X_RETURN_STATUS out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
33   X_MSG_COUNT out NOCOPY NUMBER, --File.Sql.39 bug 4440895
34   X_MSG_DATA out NOCOPY VARCHAR2  --File.Sql.39 bug 4440895
35 );
36 ------------------------------------------------------------------------------
37 procedure LOCK_ROW (
38   P_ROWID in out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
39   P_RECORD_VERSION_NUMBER NUMBER,
40   X_RETURN_STATUS out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
41   X_MSG_COUNT out NOCOPY NUMBER, --File.Sql.39 bug 4440895
42   X_MSG_DATA out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
43 );
44 ------------------------------------------------------------------------------
45 procedure UPDATE_ROW (
46   P_ROWID in out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
47   P_ROLE_LIST_ID NUMBER,
48   P_NAME VARCHAR2,
49   P_START_DATE_ACTIVE DATE,
50   P_END_DATE_ACTIVE DATE,
51   P_DESCRIPTION VARCHAR2,
52   P_ATTRIBUTE_CATEGORY VARCHAR2,
53   P_ATTRIBUTE1 VARCHAR2,
54   P_ATTRIBUTE2 VARCHAR2,
55   P_ATTRIBUTE3 VARCHAR2,
56   P_ATTRIBUTE4 VARCHAR2,
57   P_ATTRIBUTE5 VARCHAR2,
58   P_ATTRIBUTE6 VARCHAR2,
59   P_ATTRIBUTE7 VARCHAR2,
60   P_ATTRIBUTE8 VARCHAR2,
61   P_ATTRIBUTE9 VARCHAR2,
62   P_ATTRIBUTE10 VARCHAR2,
63   P_ATTRIBUTE11 VARCHAR2,
64   P_ATTRIBUTE12 VARCHAR2,
65   P_ATTRIBUTE13 VARCHAR2,
66   P_ATTRIBUTE14 VARCHAR2,
67   P_ATTRIBUTE15 VARCHAR2,
68   P_CREATION_DATE DATE,
69   P_CREATED_BY NUMBER,
70   P_LAST_UPDATE_DATE DATE,
71   P_LAST_UPDATED_BY NUMBER,
72   P_LAST_UPDATE_LOGIN NUMBER,
73   X_RETURN_STATUS out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
74   X_MSG_COUNT out NOCOPY NUMBER, --File.Sql.39 bug 4440895
75   X_MSG_DATA out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
76 );
77 ------------------------------------------------------------------------------
78 procedure DELETE_ROW (
79   P_ROWID VARCHAR2,
80   X_RETURN_STATUS out NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
81   X_MSG_COUNT out NOCOPY NUMBER, --File.Sql.39 bug 4440895
82   X_MSG_DATA out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
83 );
84 
85 end PA_ROLE_LISTS_PVT;