APPS.JTF_TASK_CONTACTS_PKG dependencies on JTF_TASK_CONTACTS

Line 1: PACKAGE body JTF_TASK_CONTACTS_PKG as

1: PACKAGE body JTF_TASK_CONTACTS_PKG as
2: /* $Header: jtftkcob.pls 115.17 2002/12/06 02:02:20 sachoudh ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_TASK_CONTACT_ID in NUMBER,

Line 34: cursor C is select ROWID from JTF_TASK_CONTACTS

30: X_ESCALATION_NOTIFY_FLAG in VARCHAR2,
31: X_ESCALATION_REQUESTER_FLAG in VARCHAR2,
32: X_PRIMARY_FLAG in VARCHAR2 default null
33: ) is
34: cursor C is select ROWID from JTF_TASK_CONTACTS
35: where TASK_CONTACT_ID = X_TASK_CONTACT_ID
36: ;
37: begin
38: insert into JTF_TASK_CONTACTS (

Line 38: insert into JTF_TASK_CONTACTS (

34: cursor C is select ROWID from JTF_TASK_CONTACTS
35: where TASK_CONTACT_ID = X_TASK_CONTACT_ID
36: ;
37: begin
38: insert into JTF_TASK_CONTACTS (
39: ATTRIBUTE4,
40: ATTRIBUTE5,
41: ATTRIBUTE6,
42: ATTRIBUTE7,

Line 116: from JTF_TASK_CONTACTS

112: X_OBJECT_VERSION_NUMBER in NUMBER
113: ) is
114: cursor c1 is select
115: OBJECT_VERSION_NUMBER
116: from JTF_TASK_CONTACTS
117: where TASK_CONTACT_ID = X_TASK_CONTACT_ID
118: for update of TASK_CONTACT_ID nowait;
119:
120: tlinfo c1%rowtype ;

Line 171: update JTF_TASK_CONTACTS set

167: X_ESCALATION_REQUESTER_FLAG in VARCHAR2,
168: X_PRIMARY_FLAG in VARCHAR2 default null
169: ) is
170: begin
171: update JTF_TASK_CONTACTS set
172: ATTRIBUTE4 = X_ATTRIBUTE4,
173: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
174: ATTRIBUTE5 = X_ATTRIBUTE5,
175: ATTRIBUTE6 = X_ATTRIBUTE6,

Line 209: delete from JTF_TASK_CONTACTS

205: procedure DELETE_ROW (
206: X_TASK_CONTACT_ID in NUMBER
207: ) is
208: begin
209: delete from JTF_TASK_CONTACTS
210: where TASK_CONTACT_ID = X_TASK_CONTACT_ID ;
211:
212: if (sql%notfound) then
213: raise no_data_found;

Line 219: end JTF_TASK_CONTACTS_PKG;

215:
216: end DELETE_ROW;
217:
218:
219: end JTF_TASK_CONTACTS_PKG;