APPS.JTF_AM_SKILL_RULES_PKG dependencies on JTF_AM_SKILL_RULES

Line 1: package body JTF_AM_SKILL_RULES_PKG as

1: package body JTF_AM_SKILL_RULES_PKG as
2: /* $Header: jtfamtrb.pls 115.0 2003/01/30 23:54:34 nsinghai noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_RULE_ID in NUMBER,

Line 36: cursor C is select ROWID from JTF_AM_SKILL_RULES

32: X_LAST_UPDATE_DATE in DATE,
33: X_LAST_UPDATED_BY in NUMBER,
34: X_LAST_UPDATE_LOGIN in NUMBER
35: ) is
36: cursor C is select ROWID from JTF_AM_SKILL_RULES
37: where RULE_ID = X_RULE_ID
38: ;
39: begin
40: insert into JTF_AM_SKILL_RULES (

Line 40: insert into JTF_AM_SKILL_RULES (

36: cursor C is select ROWID from JTF_AM_SKILL_RULES
37: where RULE_ID = X_RULE_ID
38: ;
39: begin
40: insert into JTF_AM_SKILL_RULES (
41: RULE_ID,
42: DOCUMENT_TYPE,
43: PRODUCT_ID_PASSED,
44: CATEGORY_ID_PASSED,

Line 167: from JTF_AM_SKILL_RULES

163: ATTRIBUTE14,
164: ATTRIBUTE15,
165: SECURITY_GROUP_ID,
166: RULE_ID
167: from JTF_AM_SKILL_RULES
168: where RULE_ID = X_RULE_ID
169: for update of RULE_ID nowait;
170: begin
171: for tlinfo in c1 loop

Line 255: update JTF_AM_SKILL_RULES set

251: X_LAST_UPDATED_BY in NUMBER,
252: X_LAST_UPDATE_LOGIN in NUMBER
253: ) is
254: begin
255: update JTF_AM_SKILL_RULES set
256: DOCUMENT_TYPE = X_DOCUMENT_TYPE,
257: PRODUCT_ID_PASSED = X_PRODUCT_ID_PASSED,
258: CATEGORY_ID_PASSED = X_CATEGORY_ID_PASSED,
259: PROBLEM_CODE_PASSED = X_PROBLEM_CODE_PASSED,

Line 294: delete from JTF_AM_SKILL_RULES

290: procedure DELETE_ROW (
291: X_RULE_ID in NUMBER
292: ) is
293: begin
294: delete from JTF_AM_SKILL_RULES
295: where RULE_ID = X_RULE_ID;
296:
297: if (sql%notfound) then
298: raise no_data_found;

Line 339: from JTF_AM_SKILL_RULES

335:
336: CURSOR c_last_updated IS
337: SELECT last_updated_by,
338: object_version_number
339: from JTF_AM_SKILL_RULES
340: WHERE rule_id = x_rule_id;
341:
342: begin
343: if (X_OWNER = 'SEED') then

Line 353: jtf_am_skill_rules_pkg.insert_row(

349: OPEN c_last_updated;
350: FETCH c_last_updated into l_last_updated_by, l_object_version_number ;
351: IF c_last_updated%NOTFOUND THEN
352: l_object_version_number := 1;
353: jtf_am_skill_rules_pkg.insert_row(
354: X_ROWID => l_row_id ,
355: X_RULE_ID => X_RULE_ID,
356: X_DOCUMENT_TYPE => X_DOCUMENT_TYPE,
357: X_PRODUCT_ID_PASSED => X_PRODUCT_ID_PASSED,

Line 388: jtf_am_skill_rules_pkg.update_row(

384: X_LAST_UPDATE_LOGIN => 0 );
385: ELSIF c_last_updated%FOUND THEN
386: IF l_last_updated_by IN (1,0) THEN
387: l_object_version_number := l_object_version_number + 1;
388: jtf_am_skill_rules_pkg.update_row(
389: X_RULE_ID => X_RULE_ID,
390: X_DOCUMENT_TYPE => X_DOCUMENT_TYPE,
391: X_PRODUCT_ID_PASSED => X_PRODUCT_ID_PASSED,
392: X_CATEGORY_ID_PASSED => X_CATEGORY_ID_PASSED,

Line 423: end JTF_AM_SKILL_RULES_PKG;

419: CLOSE c_last_updated;
420:
421: end LOAD_ROW;
422:
423: end JTF_AM_SKILL_RULES_PKG;