APPS.JTF_AM_SKILL_RULE_DTLS_PKG dependencies on JTF_AM_SKILL_RULE_DTLS

Line 1: package body JTF_AM_SKILL_RULE_DTLS_PKG as

1: package body JTF_AM_SKILL_RULE_DTLS_PKG as
2: /* $Header: jtfamtdb.pls 115.0 2003/01/30 23:58:25 nsinghai noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_DETAIL_ID in NUMBER,

Line 37: cursor C is select ROWID from JTF_AM_SKILL_RULE_DTLS

33: X_LAST_UPDATE_DATE in DATE,
34: X_LAST_UPDATED_BY in NUMBER,
35: X_LAST_UPDATE_LOGIN in NUMBER
36: ) is
37: cursor C is select ROWID from JTF_AM_SKILL_RULE_DTLS
38: where DETAIL_ID = X_DETAIL_ID
39: ;
40: begin
41: insert into JTF_AM_SKILL_RULE_DTLS (

Line 41: insert into JTF_AM_SKILL_RULE_DTLS (

37: cursor C is select ROWID from JTF_AM_SKILL_RULE_DTLS
38: where DETAIL_ID = X_DETAIL_ID
39: ;
40: begin
41: insert into JTF_AM_SKILL_RULE_DTLS (
42: ATTRIBUTE6,
43: ATTRIBUTE12,
44: DETAIL_ID,
45: RULE_ID,

Line 172: from JTF_AM_SKILL_RULE_DTLS

168: ATTRIBUTE10,
169: ATTRIBUTE11,
170: ATTRIBUTE14,
171: DETAIL_ID
172: from JTF_AM_SKILL_RULE_DTLS
173: where DETAIL_ID = X_DETAIL_ID
174: for update of DETAIL_ID nowait;
175: begin
176: for tlinfo in c1 loop

Line 262: update JTF_AM_SKILL_RULE_DTLS set

258: X_LAST_UPDATED_BY in NUMBER,
259: X_LAST_UPDATE_LOGIN in NUMBER
260: ) is
261: begin
262: update JTF_AM_SKILL_RULE_DTLS set
263: ATTRIBUTE6 = X_ATTRIBUTE6,
264: ATTRIBUTE12 = X_ATTRIBUTE12,
265: RULE_ID = X_RULE_ID,
266: RANK = X_RANK,

Line 303: delete from JTF_AM_SKILL_RULE_DTLS

299: procedure DELETE_ROW (
300: X_DETAIL_ID in NUMBER
301: ) is
302: begin
303: delete from JTF_AM_SKILL_RULE_DTLS
304: where DETAIL_ID = X_DETAIL_ID;
305:
306: if (sql%notfound) then
307: raise no_data_found;

Line 349: from JTF_AM_SKILL_RULE_DTLS

345:
346: CURSOR c_last_updated IS
347: SELECT last_updated_by,
348: object_version_number
349: from JTF_AM_SKILL_RULE_DTLS
350: WHERE detail_id = x_detail_id;
351:
352: begin
353: if (X_OWNER = 'SEED') then

Line 363: jtf_am_skill_rule_dtls_pkg.insert_row(

359: OPEN c_last_updated;
360: FETCH c_last_updated into l_last_updated_by, l_object_version_number ;
361: IF c_last_updated%NOTFOUND THEN
362: l_object_version_number := 1;
363: jtf_am_skill_rule_dtls_pkg.insert_row(
364: X_ROWID => l_row_id ,
365: X_DETAIL_ID => X_DETAIL_ID,
366: X_RULE_ID => X_RULE_ID,
367: X_RANK => X_RANK,

Line 399: jtf_am_skill_rule_dtls_pkg.update_row(

395: X_LAST_UPDATE_LOGIN => 0 );
396: ELSIF c_last_updated%FOUND THEN
397: IF l_last_updated_by IN (1,0) THEN
398: l_object_version_number := l_object_version_number + 1;
399: jtf_am_skill_rule_dtls_pkg.update_row(
400: X_DETAIL_ID => X_DETAIL_ID,
401: X_RULE_ID => X_RULE_ID,
402: X_RANK => X_RANK,
403: X_CHECK_PRODUCT_ID => X_CHECK_PRODUCT_ID,

Line 435: end JTF_AM_SKILL_RULE_DTLS_PKG;

431: CLOSE c_last_updated;
432:
433: end LOAD_ROW;
434:
435: end JTF_AM_SKILL_RULE_DTLS_PKG;