[Home] [Help]
PACKAGE BODY: APPS.JTF_RS_JOB_ROLES_PKG
Source
1 package body JTF_RS_JOB_ROLES_PKG as
2 /* $Header: jtfrstjb.pls 120.0 2005/05/11 08:22:18 appldev ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_JOB_ROLE_ID in NUMBER,
6 X_JOB_ID in NUMBER,
7 X_ROLE_ID in NUMBER,
8 X_ATTRIBUTE2 in VARCHAR2,
9 X_ATTRIBUTE3 in VARCHAR2,
10 X_ATTRIBUTE4 in VARCHAR2,
11 X_ATTRIBUTE5 in VARCHAR2,
12 X_ATTRIBUTE6 in VARCHAR2,
13 X_ATTRIBUTE7 in VARCHAR2,
14 X_ATTRIBUTE8 in VARCHAR2,
15 X_ATTRIBUTE9 in VARCHAR2,
16 X_ATTRIBUTE10 in VARCHAR2,
17 X_ATTRIBUTE11 in VARCHAR2,
18 X_ATTRIBUTE12 in VARCHAR2,
19 X_ATTRIBUTE13 in VARCHAR2,
20 X_ATTRIBUTE14 in VARCHAR2,
21 X_ATTRIBUTE15 in VARCHAR2,
22 X_ATTRIBUTE_CATEGORY in VARCHAR2,
23 X_ATTRIBUTE1 in VARCHAR2,
24 X_CREATION_DATE in DATE,
25 X_CREATED_BY in NUMBER,
26 X_LAST_UPDATE_DATE in DATE,
27 X_LAST_UPDATED_BY in NUMBER,
28 X_LAST_UPDATE_LOGIN in NUMBER
29 ) is
30 cursor C is select ROWID from JTF_RS_JOB_ROLES
31 where JOB_ROLE_ID = X_JOB_ROLE_ID
32 ;
33 begin
34 insert into JTF_RS_JOB_ROLES (
35 JOB_ROLE_ID,
36 JOB_ID,
37 ROLE_ID,
38 OBJECT_VERSION_NUMBER,
39 CREATED_BY,
40 CREATION_DATE,
41 LAST_UPDATED_BY,
42 LAST_UPDATE_DATE,
43 LAST_UPDATE_LOGIN,
44 ATTRIBUTE1,
45 ATTRIBUTE2,
46 ATTRIBUTE3,
47 ATTRIBUTE4,
48 ATTRIBUTE5,
49 ATTRIBUTE6,
50 ATTRIBUTE7,
51 ATTRIBUTE8,
52 ATTRIBUTE9,
53 ATTRIBUTE10,
54 ATTRIBUTE11,
55 ATTRIBUTE12,
56 ATTRIBUTE13,
57 ATTRIBUTE14,
58 ATTRIBUTE15,
59 ATTRIBUTE_CATEGORY
60 ) values (
61 X_JOB_ROLE_ID,
62 X_JOB_ID,
63 X_ROLE_ID,
64 1,
65 X_CREATED_BY,
66 X_CREATION_DATE,
67 X_LAST_UPDATED_BY,
68 X_LAST_UPDATE_DATE,
69 X_LAST_UPDATE_LOGIN,
70 X_ATTRIBUTE1,
71 X_ATTRIBUTE2,
72 X_ATTRIBUTE3,
73 X_ATTRIBUTE4,
74 X_ATTRIBUTE5,
75 X_ATTRIBUTE6,
76 X_ATTRIBUTE7,
77 X_ATTRIBUTE8,
78 X_ATTRIBUTE9,
79 X_ATTRIBUTE10,
80 X_ATTRIBUTE11,
81 X_ATTRIBUTE12,
82 X_ATTRIBUTE13,
83 X_ATTRIBUTE14,
84 X_ATTRIBUTE15,
85 X_ATTRIBUTE_CATEGORY);
86
87 open c;
88 fetch c into X_ROWID;
89 if (c%notfound) then
90 close c;
91 raise no_data_found;
92 end if;
93 close c;
94
95 end INSERT_ROW;
96
97 procedure LOCK_ROW (
98 X_JOB_ROLE_ID in NUMBER,
99 X_OBJECT_VERSION_NUMBER in NUMBER
100 ) is
101 cursor c1 is select
102 OBJECT_VERSION_NUMBER
103 from JTF_RS_JOB_ROLES
104 where JOB_ROLE_ID = X_JOB_ROLE_ID
105 for update of JOB_ROLE_ID nowait;
106 tlinfo c1%rowtype ;
107 begin
108 open c1;
109 fetch c1 into tlinfo;
110 if (c1%notfound) then
111 close c1;
112 fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
113 app_exception.raise_exception;
114 end if;
115 close c1;
116
117 if (tlinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
118 then
119 null;
120 else
121 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
122 app_exception.raise_exception;
123 end if;
124
125 end LOCK_ROW;
126
127 procedure UPDATE_ROW (
128 X_JOB_ROLE_ID in NUMBER,
129 X_JOB_ID in NUMBER,
130 X_ROLE_ID in NUMBER,
131 X_OBJECT_VERSION_NUMBER in NUMBER,
132 X_ATTRIBUTE2 in VARCHAR2,
133 X_ATTRIBUTE3 in VARCHAR2,
134 X_ATTRIBUTE4 in VARCHAR2,
135 X_ATTRIBUTE5 in VARCHAR2,
136 X_ATTRIBUTE6 in VARCHAR2,
137 X_ATTRIBUTE7 in VARCHAR2,
138 X_ATTRIBUTE8 in VARCHAR2,
139 X_ATTRIBUTE9 in VARCHAR2,
140 X_ATTRIBUTE10 in VARCHAR2,
141 X_ATTRIBUTE11 in VARCHAR2,
142 X_ATTRIBUTE12 in VARCHAR2,
143 X_ATTRIBUTE13 in VARCHAR2,
144 X_ATTRIBUTE14 in VARCHAR2,
145 X_ATTRIBUTE15 in VARCHAR2,
146 X_ATTRIBUTE_CATEGORY in VARCHAR2,
147 X_ATTRIBUTE1 in VARCHAR2,
148 X_LAST_UPDATE_DATE in DATE,
149 X_LAST_UPDATED_BY in NUMBER,
150 X_LAST_UPDATE_LOGIN in NUMBER
151 ) is
152 begin
153 update JTF_RS_JOB_ROLES set
154 JOB_ID = X_JOB_ID,
155 ROLE_ID = X_ROLE_ID,
156 OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
157 ATTRIBUTE2 = X_ATTRIBUTE2,
158 ATTRIBUTE3 = X_ATTRIBUTE3,
159 ATTRIBUTE4 = X_ATTRIBUTE4,
160 ATTRIBUTE5 = X_ATTRIBUTE5,
161 ATTRIBUTE6 = X_ATTRIBUTE6,
162 ATTRIBUTE7 = X_ATTRIBUTE7,
163 ATTRIBUTE8 = X_ATTRIBUTE8,
164 ATTRIBUTE9 = X_ATTRIBUTE9,
165 ATTRIBUTE10 = X_ATTRIBUTE10,
166 ATTRIBUTE11 = X_ATTRIBUTE11,
167 ATTRIBUTE12 = X_ATTRIBUTE12,
168 ATTRIBUTE13 = X_ATTRIBUTE13,
169 ATTRIBUTE14 = X_ATTRIBUTE14,
170 ATTRIBUTE15 = X_ATTRIBUTE15,
171 ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
172 ATTRIBUTE1 = X_ATTRIBUTE1,
173 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
174 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
175 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
176 where JOB_ROLE_ID = X_JOB_ROLE_ID;
177
178 if (sql%notfound) then
179 raise no_data_found;
180 end if;
181 end UPDATE_ROW;
182
183 procedure DELETE_ROW (
184 X_JOB_ROLE_ID in NUMBER
185 ) is
186 begin
187 delete from JTF_RS_JOB_ROLES
188 where JOB_ROLE_ID = X_JOB_ROLE_ID;
189
190 if (sql%notfound) then
191 raise no_data_found;
192 end if;
193
194 end DELETE_ROW;
195
196 end JTF_RS_JOB_ROLES_PKG;