APPS.JTF_TASK_DATES_PKG dependencies on JTF_TASK_DATES

Line 1: PACKAGE body JTF_TASK_DATES_PKG as

1: PACKAGE body JTF_TASK_DATES_PKG as
2: /* $Header: jtftkdab.pls 115.16 2002/12/06 02:02:44 sachoudh ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_TASK_DATE_ID in NUMBER,

Line 31: cursor C is select ROWID from JTF_TASK_DATES

27: X_LAST_UPDATE_DATE in DATE,
28: X_LAST_UPDATED_BY in NUMBER,
29: X_LAST_UPDATE_LOGIN in NUMBER
30: ) is
31: cursor C is select ROWID from JTF_TASK_DATES
32: where TASK_DATE_ID = X_TASK_DATE_ID
33: ;
34: begin
35: insert into JTF_TASK_DATES (

Line 35: insert into JTF_TASK_DATES (

31: cursor C is select ROWID from JTF_TASK_DATES
32: where TASK_DATE_ID = X_TASK_DATE_ID
33: ;
34: begin
35: insert into JTF_TASK_DATES (
36: TASK_DATE_ID,
37: TASK_ID,
38: DATE_TYPE_ID,
39: CREATED_BY,

Line 106: from JTF_TASK_DATES

102: X_OBJECT_VERSION_NUMBER in NUMBER
103: ) is
104: cursor c1 is select
105: OBJECT_VERSION_NUMBER
106: from JTF_TASK_DATES
107: where TASK_DATE_ID = X_TASK_DATE_ID
108: and OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
109: for update of TASK_DATE_ID nowait;
110: tlinfo c1%rowtype ;

Line 159: update JTF_TASK_DATES set

155: X_LAST_UPDATED_BY in NUMBER,
156: X_LAST_UPDATE_LOGIN in NUMBER
157: ) is
158: begin
159: update JTF_TASK_DATES set
160: TASK_ID = X_TASK_ID,
161: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
162: DATE_TYPE_ID = X_DATE_TYPE_ID,
163: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 194: delete from JTF_TASK_DATES

190: procedure DELETE_ROW (
191: X_TASK_DATE_ID in NUMBER
192: ) is
193: begin
194: delete from JTF_TASK_DATES
195: where TASK_DATE_ID = X_TASK_DATE_ID ;
196:
197: if (sql%notfound) then
198: raise no_data_found;

Line 203: end JTF_TASK_DATES_PKG;

199: end if;
200:
201: end DELETE_ROW;
202:
203: end JTF_TASK_DATES_PKG;