APPS.JTF_TASK_DEPENDS_PKG dependencies on JTF_TASK_DEPENDS

Line 1: PACKAGE body JTF_TASK_DEPENDS_PKG as

1: PACKAGE body JTF_TASK_DEPENDS_PKG as
2: /* $Header: jtftkdeb.pls 120.1 2005/07/02 01:23:51 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_DEPENDENCY_ID in NUMBER,

Line 35: cursor C is select ROWID from JTF_TASK_DEPENDS

31: X_LAST_UPDATE_DATE in DATE,
32: X_LAST_UPDATED_BY in NUMBER,
33: X_LAST_UPDATE_LOGIN in NUMBER
34: ) is
35: cursor C is select ROWID from JTF_TASK_DEPENDS
36: where DEPENDENCY_ID = X_DEPENDENCY_ID
37: ;
38: begin
39: insert into JTF_TASK_DEPENDS (

Line 39: insert into JTF_TASK_DEPENDS (

35: cursor C is select ROWID from JTF_TASK_DEPENDS
36: where DEPENDENCY_ID = X_DEPENDENCY_ID
37: ;
38: begin
39: insert into JTF_TASK_DEPENDS (
40: DEPENDENCY_ID,
41: TASK_ID,
42: DEPENDENT_ON_TASK_ID,
43: CREATED_BY,

Line 118: from JTF_TASK_DEPENDS

114: X_OBJECT_VERSION_NUMBER in NUMBER
115: ) is
116: cursor c1 is select
117: OBJECT_VERSION_NUMBER
118: from JTF_TASK_DEPENDS
119: where DEPENDENCY_ID = X_DEPENDENCY_ID
120: for update of DEPENDENCY_ID nowait;
121: tlinfo c1%rowtype ;
122: begin

Line 174: update JTF_TASK_DEPENDS set

170: X_LAST_UPDATED_BY in NUMBER,
171: X_LAST_UPDATE_LOGIN in NUMBER
172: ) is
173: begin
174: update JTF_TASK_DEPENDS set
175: TASK_ID = X_TASK_ID,
176: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER ,
177: DEPENDENT_ON_TASK_ID = X_DEPENDENT_ON_TASK_ID,
178: ADJUSTMENT_TIME = X_ADJUSTMENT_TIME,

Line 213: delete from JTF_TASK_DEPENDS

209: procedure DELETE_ROW (
210: X_DEPENDENCY_ID in NUMBER
211: ) is
212: begin
213: delete from JTF_TASK_DEPENDS
214: where DEPENDENCY_ID = X_DEPENDENCY_ID ;
215:
216: if (sql%notfound) then
217: raise no_data_found;

Line 222: end JTF_TASK_DEPENDS_PKG;

218: end if;
219:
220: end DELETE_ROW;
221:
222: end JTF_TASK_DEPENDS_PKG;