eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TASK_PHONES_PUB dependencies on JTF_TASK_PHONES

Line 1: PACKAGE BODY jtf_task_phones_pub AS

1: PACKAGE BODY jtf_task_phones_pub AS
2: /* $Header: jtfptkpb.pls 115.26 2002/12/04 21:04:09 cjang ship $ */
3: g_pkg_name VARCHAR2(30) := 'JTF_TASK_PHONES_PUB';
4:
5: PROCEDURE do_unmark_primary_flag_create (

Line 3: g_pkg_name VARCHAR2(30) := 'JTF_TASK_PHONES_PUB';

1: PACKAGE BODY jtf_task_phones_pub AS
2: /* $Header: jtfptkpb.pls 115.26 2002/12/04 21:04:09 cjang ship $ */
3: g_pkg_name VARCHAR2(30) := 'JTF_TASK_PHONES_PUB';
4:
5: PROCEDURE do_unmark_primary_flag_create (
6: p_task_contact_id IN NUMBER,
7: p_phone_id IN NUMBER,

Line 25: FROM jtf_task_phones

21: RETURN BOOLEAN
22: IS
23: CURSOR c_task_phone (b_task_contact_id NUMBER, b_owner_table_name VARCHAR2) IS
24: SELECT '1'
25: FROM jtf_task_phones
26: WHERE task_contact_id = b_task_contact_id
27: AND owner_table_name = b_owner_table_name;
28:
29: l_dummy VARCHAR2(1);

Line 84: l_task_phone_id jtf_task_phones.task_phone_id%TYPE;

80: := 'CREATE_TASK_PHONES';
81: l_rowid ROWID;
82: l_task_id jtf_tasks_b.task_id%TYPE;
83: l_contact_id jtf_task_contacts.contact_id%TYPE;
84: l_task_phone_id jtf_task_phones.task_phone_id%TYPE;
85: x CHAR;
86:
87: l_primary_flag VARCHAR2(1) := p_primary_flag; -- For fixing a bug 2644132
88:

Line 89: CURSOR c_jtf_task_phones (l_rowid IN ROWID)

85: x CHAR;
86:
87: l_primary_flag VARCHAR2(1) := p_primary_flag; -- For fixing a bug 2644132
88:
89: CURSOR c_jtf_task_phones (l_rowid IN ROWID)
90: IS
91: SELECT 1
92: FROM jtf_task_phones
93: WHERE ROWID = l_rowid;

Line 92: FROM jtf_task_phones

88:
89: CURSOR c_jtf_task_phones (l_rowid IN ROWID)
90: IS
91: SELECT 1
92: FROM jtf_task_phones
93: WHERE ROWID = l_rowid;
94: BEGIN
95: SAVEPOINT create_task_phones_pub;
96: x_return_status := fnd_api.g_ret_sts_success;

Line 174: SELECT jtf_task_phones_s.nextval

170: x_return_status := fnd_api.g_ret_sts_unexp_error;
171: RAISE fnd_api.g_exc_unexpected_error;
172: END IF;
173:
174: SELECT jtf_task_phones_s.nextval
175: INTO l_task_phone_id
176: FROM dual;
177:
178: --Unmark the previous contact points with primary flag = 'Y'.

Line 196: jtf_task_phones_pkg.insert_row (

192: l_primary_flag := jtf_task_utl.g_yes;
193: END IF;
194: -------------------------------------------
195:
196: jtf_task_phones_pkg.insert_row (
197: x_rowid => l_rowid,
198: x_task_phone_id => l_task_phone_id,
199: x_task_contact_id => p_task_contact_id,
200: x_attribute1 => p_attribute1,

Line 225: OPEN c_jtf_task_phones (l_rowid);

221: x_last_update_login => jtf_task_utl.login_id,
222: x_owner_table_name => p_owner_table_name,
223: x_primary_flag => l_primary_flag -- For fixing a bug 2644132
224: );
225: OPEN c_jtf_task_phones (l_rowid);
226: FETCH c_jtf_task_phones INTO x;
227:
228: IF c_jtf_task_phones%NOTFOUND
229: THEN

Line 226: FETCH c_jtf_task_phones INTO x;

222: x_owner_table_name => p_owner_table_name,
223: x_primary_flag => l_primary_flag -- For fixing a bug 2644132
224: );
225: OPEN c_jtf_task_phones (l_rowid);
226: FETCH c_jtf_task_phones INTO x;
227:
228: IF c_jtf_task_phones%NOTFOUND
229: THEN
230: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 228: IF c_jtf_task_phones%NOTFOUND

224: );
225: OPEN c_jtf_task_phones (l_rowid);
226: FETCH c_jtf_task_phones INTO x;
227:
228: IF c_jtf_task_phones%NOTFOUND
229: THEN
230: x_return_status := fnd_api.g_ret_sts_unexp_error;
231: fnd_message.set_name ('JTF', 'JTF_TASK_CREATING_PHONE');
232: fnd_msg_pub.add;

Line 301: jtf_task_phones_pkg.lock_row (

297: fnd_msg_pub.initialize;
298: END IF;
299:
300: x_return_status := fnd_api.g_ret_sts_success;
301: jtf_task_phones_pkg.lock_row (
302: x_task_phone_id => p_task_phone_id,
303: x_object_version_number => p_object_version_number
304: );
305: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 464: FROM jtf_task_phones

460: fnd_api.g_miss_char, primary_flag,
461: p_primary_flag
462: ) primary_flag,
463: owner_table_name
464: FROM jtf_task_phones
465: WHERE task_phone_id = p_task_phone_id;
466:
467: task_phones c_task_phones%ROWTYPE;
468: l_owner_table_name VARCHAR2(30);

Line 502: FROM jtf_task_phones

498: SELECT task_contact_id,
499: NVL (owner_table_name, 'JTF_TASK_CONTACTS')
500: INTO l_task_contact_id,
501: l_owner_table_name
502: FROM jtf_task_phones
503: WHERE task_phone_id = p_task_phone_id;
504: EXCEPTION
505: WHEN NO_DATA_FOUND
506: THEN

Line 570: FROM jtf_task_phones

566:
567: BEGIN
568: SELECT 1
569: INTO x
570: FROM jtf_task_phones
571: WHERE task_phone_id = p_task_phone_id;
572: EXCEPTION
573: WHEN NO_DATA_FOUND
574: THEN

Line 581: jtf_task_phones_pub.lock_task_phones (

577: fnd_msg_pub.add;
578: RAISE fnd_api.g_exc_unexpected_error;
579: END;
580:
581: jtf_task_phones_pub.lock_task_phones (
582: p_api_version => 1.0,
583: p_init_msg_list => fnd_api.g_false,
584: p_commit => fnd_api.g_false,
585: p_task_phone_id => p_task_phone_id,

Line 623: jtf_task_phones_pkg.update_row (

619: l_contact_id
620: );
621: END IF;
622:
623: jtf_task_phones_pkg.update_row (
624: x_task_phone_id => p_task_phone_id,
625: x_task_contact_id => l_task_contact_id,
626: x_object_version_number => p_object_version_number + 1,
627: x_attribute1 => task_phones.attribute1,

Line 697: CURSOR c_jtf_task_phones

693: l_api_version CONSTANT NUMBER := 1.0;
694: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK_PHONES';
695: x CHAR;
696:
697: CURSOR c_jtf_task_phones
698: IS
699: SELECT 1
700: FROM jtf_task_phones
701: WHERE task_phone_id = p_task_phone_id;

Line 700: FROM jtf_task_phones

696:
697: CURSOR c_jtf_task_phones
698: IS
699: SELECT 1
700: FROM jtf_task_phones
701: WHERE task_phone_id = p_task_phone_id;
702: BEGIN
703: SAVEPOINT delete_task_phones_pub;
704: x_return_status := fnd_api.g_ret_sts_success;

Line 721: jtf_task_phones_pub.lock_task_phones (

717: THEN
718: fnd_msg_pub.initialize;
719: END IF;
720:
721: jtf_task_phones_pub.lock_task_phones (
722: p_api_version => 1.0,
723: p_init_msg_list => fnd_api.g_false,
724: p_commit => fnd_api.g_false,
725: p_task_phone_id => p_task_phone_id,

Line 738: jtf_task_phones_pkg.delete_row (x_task_phone_id => p_task_phone_id);

734: x_return_status := fnd_api.g_ret_sts_unexp_error;
735: RAISE fnd_api.g_exc_unexpected_error;
736: END IF;
737:
738: jtf_task_phones_pkg.delete_row (x_task_phone_id => p_task_phone_id);
739: OPEN c_jtf_task_phones;
740: FETCH c_jtf_task_phones INTO x;
741:
742: IF c_jtf_task_phones%FOUND

Line 739: OPEN c_jtf_task_phones;

735: RAISE fnd_api.g_exc_unexpected_error;
736: END IF;
737:
738: jtf_task_phones_pkg.delete_row (x_task_phone_id => p_task_phone_id);
739: OPEN c_jtf_task_phones;
740: FETCH c_jtf_task_phones INTO x;
741:
742: IF c_jtf_task_phones%FOUND
743: THEN

Line 740: FETCH c_jtf_task_phones INTO x;

736: END IF;
737:
738: jtf_task_phones_pkg.delete_row (x_task_phone_id => p_task_phone_id);
739: OPEN c_jtf_task_phones;
740: FETCH c_jtf_task_phones INTO x;
741:
742: IF c_jtf_task_phones%FOUND
743: THEN
744: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 742: IF c_jtf_task_phones%FOUND

738: jtf_task_phones_pkg.delete_row (x_task_phone_id => p_task_phone_id);
739: OPEN c_jtf_task_phones;
740: FETCH c_jtf_task_phones INTO x;
741:
742: IF c_jtf_task_phones%FOUND
743: THEN
744: x_return_status := fnd_api.g_ret_sts_unexp_error;
745: fnd_message.set_name ('JTF', 'JTF_TASK_DELETING_PHONES');
746: fnd_msg_pub.add;

Line 788: UPDATE jtf_task_phones

784: BEGIN
785: -- select contact points of the same type and unmark the primary flag
786: IF p_owner_table_name = 'JTF_TASK_CONTACTS'
787: THEN
788: UPDATE jtf_task_phones
789: SET primary_flag = 'N'
790: WHERE task_contact_id = p_task_contact_id
791: AND phone_id IN
792: ( SELECT contact_point_id

Line 810: UPDATE jtf_task_phones

806: WHERE task_contact_id = p_task_contact_id))
807: AND primary_flag = 'Y';
808: ELSE
809: -- select contact points of the same type and unmark the primary flag
810: UPDATE jtf_task_phones
811: SET primary_flag = 'N'
812: WHERE task_contact_id = p_task_contact_id
813: AND phone_id IN
814: ( SELECT contact_point_id

Line 844: UPDATE jtf_task_phones

840: l_contact_id IN NUMBER
841: )
842: IS
843: BEGIN
844: UPDATE jtf_task_phones
845: SET primary_flag = 'N'
846: WHERE task_contact_id = (SELECT task_contact_id
847: FROM jtf_task_phones
848: WHERE task_phone_id = p_task_phone_id)

Line 847: FROM jtf_task_phones

843: BEGIN
844: UPDATE jtf_task_phones
845: SET primary_flag = 'N'
846: WHERE task_contact_id = (SELECT task_contact_id
847: FROM jtf_task_phones
848: WHERE task_phone_id = p_task_phone_id)
849: AND phone_id IN
850: ( SELECT contact_point_id
851: FROM hz_contact_points