APPS.JTF_TASK_PHONES_PKG dependencies on JTF_TASK_PHONES

Line 1: PACKAGE BODY jtf_task_phones_pkg AS

1: PACKAGE BODY jtf_task_phones_pkg AS
2: /* $Header: jtftkphb.pls 115.20 2002/12/04 21:49:07 cjang ship $ */
3: PROCEDURE insert_row (
4: x_rowid IN OUT NOCOPY VARCHAR2,
5: x_task_phone_id IN NUMBER,

Line 36: FROM jtf_task_phones

32: IS
33: CURSOR c
34: IS
35: SELECT ROWID
36: FROM jtf_task_phones
37: WHERE task_phone_id = x_task_phone_id;
38: BEGIN
39: INSERT INTO jtf_task_phones (
40: attribute5,

Line 39: INSERT INTO jtf_task_phones (

35: SELECT ROWID
36: FROM jtf_task_phones
37: WHERE task_phone_id = x_task_phone_id;
38: BEGIN
39: INSERT INTO jtf_task_phones (
40: attribute5,
41: attribute6,
42: attribute7,
43: attribute8,

Line 117: FROM jtf_task_phones

113: IS
114: CURSOR c1
115: IS
116: SELECT object_version_number
117: FROM jtf_task_phones
118: WHERE task_phone_id = x_task_phone_id
119: FOR UPDATE OF task_phone_id NOWAIT;
120:
121: tlinfo c1%ROWTYPE;

Line 173: UPDATE jtf_task_phones

169: x_primary_flag IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
170: )
171: IS
172: BEGIN
173: UPDATE jtf_task_phones
174: SET object_version_number = x_object_version_number,
175: attribute5 = x_attribute5,
176: attribute6 = x_attribute6,
177: attribute7 = x_attribute7,

Line 210: FROM jtf_task_phones

206: PROCEDURE delete_row (x_task_phone_id IN NUMBER)
207: IS
208: BEGIN
209: DELETE
210: FROM jtf_task_phones
211: WHERE task_phone_id = x_task_phone_id;
212:
213: IF (SQL%NOTFOUND)
214: THEN

Line 218: END jtf_task_phones_pkg;

214: THEN
215: RAISE NO_DATA_FOUND;
216: END IF;
217: END delete_row;
218: END jtf_task_phones_pkg;