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_CONTACTS_PUB dependencies on JTF_TASK_CONTACTS

Line 1: PACKAGE BODY jtf_task_contacts_pub AS

1: PACKAGE BODY jtf_task_contacts_pub AS
2: /* $Header: jtfptkcb.pls 120.3 2006/07/13 11:30:06 sbarat ship $ */
3: PROCEDURE do_unmark_primary_flag_create(
4: p_task_id IN NUMBER
5: ) ;

Line 22: FROM jtf_task_contacts

18: RETURN BOOLEAN
19: IS
20: CURSOR c_task_contact (b_task_id NUMBER) IS
21: SELECT '1'
22: FROM jtf_task_contacts
23: WHERE task_id = b_task_id;
24:
25: l_dummy VARCHAR2(1);
26: l_this_is_first BOOLEAN;

Line 83: l_task_contact_id jtf_task_contacts.task_contact_id%TYPE;

79: l_api_name CONSTANT VARCHAR2(30)
80: := 'CREATE_TASK_CONTACTS';
81: l_rowid ROWID;
82: l_task_id jtf_tasks_b.task_id%TYPE;
83: l_task_contact_id jtf_task_contacts.task_contact_id%TYPE;
84: x CHAR;
85: l_person_id NUMBER;
86:
87: l_primary_flag VARCHAR2(1) := p_primary_flag; -- For fixing a bug 2644132

Line 89: CURSOR c_jtf_task_contacts (l_rowid IN ROWID)

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

Line 92: FROM jtf_task_contacts

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

Line 223: SELECT jtf_task_contacts_s.nextval

219: x_return_status := fnd_api.g_ret_sts_unexp_error;
220: RAISE fnd_api.g_exc_unexpected_error;
221: END IF;
222:
223: SELECT jtf_task_contacts_s.nextval
224: INTO l_task_contact_id
225: FROM dual;
226:
227: --Unmark the previous task id with primary flag = 'Y'.

Line 240: jtf_task_contacts_pkg.insert_row (

236: l_primary_flag := jtf_task_utl.g_yes;
237: END IF;
238: -------------------------------------------
239:
240: jtf_task_contacts_pkg.insert_row (
241: x_rowid => l_rowid,
242: x_task_contact_id => l_task_contact_id,
243: x_attribute4 => p_attribute4,
244: x_attribute5 => p_attribute5,

Line 271: OPEN c_jtf_task_contacts (l_rowid);

267: x_escalation_notify_flag => p_escalation_notify_flag,
268: x_escalation_requester_flag => p_escalation_requester_flag,
269: x_primary_flag => l_primary_flag -- For fixing a bug 2644132
270: );
271: OPEN c_jtf_task_contacts (l_rowid);
272: FETCH c_jtf_task_contacts INTO x;
273:
274: IF c_jtf_task_contacts%NOTFOUND
275: THEN

Line 272: FETCH c_jtf_task_contacts INTO x;

268: x_escalation_requester_flag => p_escalation_requester_flag,
269: x_primary_flag => l_primary_flag -- For fixing a bug 2644132
270: );
271: OPEN c_jtf_task_contacts (l_rowid);
272: FETCH c_jtf_task_contacts INTO x;
273:
274: IF c_jtf_task_contacts%NOTFOUND
275: THEN
276: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 274: IF c_jtf_task_contacts%NOTFOUND

270: );
271: OPEN c_jtf_task_contacts (l_rowid);
272: FETCH c_jtf_task_contacts INTO x;
273:
274: IF c_jtf_task_contacts%NOTFOUND
275: THEN
276: x_return_status := fnd_api.g_ret_sts_unexp_error;
277: fnd_message.set_name ('JTF', 'JTF_TASK_CREATING_CONTACTS');
278: fnd_msg_pub.add;

Line 367: jtf_task_contacts_pkg.lock_row (

363: fnd_msg_pub.initialize;
364: END IF;
365:
366: x_return_status := fnd_api.g_ret_sts_success;
367: jtf_task_contacts_pkg.lock_row (
368: x_task_contact_id => p_task_contact_id,
369: x_object_version_number => p_object_version_number);
370: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
371:

Line 442: l_task_contact_id jtf_task_contacts.task_contact_id%TYPE;

438: IS
439: l_api_version CONSTANT NUMBER := 1.0;
440: l_api_name CONSTANT VARCHAR2(30)
441: := 'UPDATE_TASK_CONTACTS';
442: l_task_contact_id jtf_task_contacts.task_contact_id%TYPE;
443: l_contact_id jtf_task_contacts.contact_id%TYPE;
444: l_task_id jtf_tasks_b.task_id%TYPE;
445: CURSOR c_task_contacts
446: IS

Line 443: l_contact_id jtf_task_contacts.contact_id%TYPE;

439: l_api_version CONSTANT NUMBER := 1.0;
440: l_api_name CONSTANT VARCHAR2(30)
441: := 'UPDATE_TASK_CONTACTS';
442: l_task_contact_id jtf_task_contacts.task_contact_id%TYPE;
443: l_contact_id jtf_task_contacts.contact_id%TYPE;
444: l_task_id jtf_tasks_b.task_id%TYPE;
445: CURSOR c_task_contacts
446: IS
447: SELECT task_contact_id,

Line 554: FROM jtf_task_contacts

550: p_primary_flag,
551: fnd_api.g_miss_char, primary_flag,
552: p_primary_flag
553: ) primary_flag
554: FROM jtf_task_contacts
555: WHERE task_contact_id = p_task_contact_id;
556:
557: task_contacts c_task_contacts%ROWTYPE;
558: x NUMBER;

Line 564: FROM jtf_task_contacts

560: CURSOR con_con_orig (b_task_contact_id IN NUMBER)
561: IS
562: SELECT contact_id,
563: contact_type_code
564: FROM jtf_task_contacts
565: WHERE task_contact_id = b_task_contact_id;
566:
567: l_orig_con_id jtf_task_contacts.contact_id%type;
568: l_orig_type_code jtf_task_contacts.contact_type_code%type;

Line 567: l_orig_con_id jtf_task_contacts.contact_id%type;

563: contact_type_code
564: FROM jtf_task_contacts
565: WHERE task_contact_id = b_task_contact_id;
566:
567: l_orig_con_id jtf_task_contacts.contact_id%type;
568: l_orig_type_code jtf_task_contacts.contact_type_code%type;
569: BEGIN
570: SAVEPOINT update_task_contacts_pub;
571: x_return_status := fnd_api.g_ret_sts_success;

Line 568: l_orig_type_code jtf_task_contacts.contact_type_code%type;

564: FROM jtf_task_contacts
565: WHERE task_contact_id = b_task_contact_id;
566:
567: l_orig_con_id jtf_task_contacts.contact_id%type;
568: l_orig_type_code jtf_task_contacts.contact_type_code%type;
569: BEGIN
570: SAVEPOINT update_task_contacts_pub;
571: x_return_status := fnd_api.g_ret_sts_success;
572:

Line 638: FROM jtf_task_contacts

634:
635: BEGIN
636: SELECT task_id
637: INTO l_task_id
638: FROM jtf_task_contacts
639: WHERE task_contact_id = p_task_contact_id;
640: EXCEPTION
641: WHEN NO_DATA_FOUND
642: THEN

Line 712: jtf_task_contacts_pub.lock_task_contacts (

708: x_return_status := fnd_api.g_ret_sts_unexp_error;
709: RAISE fnd_api.g_exc_unexpected_error;
710: END IF;
711:
712: jtf_task_contacts_pub.lock_task_contacts (
713: p_api_version => 1.0,
714: p_init_msg_list => fnd_api.g_false,
715: p_commit => fnd_api.g_false,
716: p_task_contact_id => p_task_contact_id,

Line 751: jtf_task_contacts_pkg.update_row (

747: RAISE fnd_api.g_exc_unexpected_error;
748: END IF;
749:
750:
751: jtf_task_contacts_pkg.update_row (
752: x_task_contact_id => p_task_contact_id,
753: x_object_version_number => p_object_version_number + 1,
754: x_attribute1 => task_contacts.attribute1,
755: x_attribute2 => task_contacts.attribute2,

Line 868: l_contact_id jtf_task_contacts.contact_id%TYPE;

864: l_api_version CONSTANT NUMBER := 1.0;
865: l_api_name CONSTANT VARCHAR2(30)
866: := 'DELETE_TASK_CONTACTS';
867: l_task_id jtf_tasks_b.task_id%TYPE;
868: l_contact_id jtf_task_contacts.contact_id%TYPE;
869: l_contact_type_code jtf_task_contacts.contact_type_code%TYPE;
870: CURSOR con_con_orig (b_task_contact_id IN NUMBER)
871: IS
872: SELECT contact_id,

Line 869: l_contact_type_code jtf_task_contacts.contact_type_code%TYPE;

865: l_api_name CONSTANT VARCHAR2(30)
866: := 'DELETE_TASK_CONTACTS';
867: l_task_id jtf_tasks_b.task_id%TYPE;
868: l_contact_id jtf_task_contacts.contact_id%TYPE;
869: l_contact_type_code jtf_task_contacts.contact_type_code%TYPE;
870: CURSOR con_con_orig (b_task_contact_id IN NUMBER)
871: IS
872: SELECT contact_id,
873: contact_type_code

Line 874: FROM jtf_task_contacts

870: CURSOR con_con_orig (b_task_contact_id IN NUMBER)
871: IS
872: SELECT contact_id,
873: contact_type_code
874: FROM jtf_task_contacts
875: WHERE task_contact_id = b_task_contact_id;
876: BEGIN
877: x_return_status := fnd_api.g_ret_sts_success;
878: SAVEPOINT delete_task_contacts_pvt;

Line 912: FROM jtf_task_contacts

908:
909: BEGIN
910: SELECT task_id
911: INTO l_task_id
912: FROM jtf_task_contacts
913: WHERE task_contact_id = p_task_contact_id;
914: EXCEPTION
915: WHEN NO_DATA_FOUND
916: THEN

Line 924: jtf_task_contacts_pub.lock_task_contacts (

920: RAISE fnd_api.g_exc_unexpected_error;
921: END;
922:
923:
924: jtf_task_contacts_pub.lock_task_contacts (
925: p_api_version => 1.0,
926: p_init_msg_list => fnd_api.g_false,
927: p_commit => fnd_api.g_false,
928: p_task_contact_id => p_task_contact_id,

Line 961: jtf_task_contacts_pkg.delete_row (

957: THEN
958: RAISE fnd_api.g_exc_unexpected_error;
959: END IF;
960:
961: jtf_task_contacts_pkg.delete_row (
962: x_task_contact_id => p_task_contact_id
963: );
964:
965: -- ------------------------------------------------------------------------

Line 1023: UPDATE jtf_task_contacts

1019: ) IS
1020:
1021: BEGIN
1022: -- unmark previous primary flag
1023: UPDATE jtf_task_contacts
1024: SET primary_flag = 'N'
1025: WHERE task_id = p_task_id
1026: AND primary_flag = 'Y';
1027:

Line 1037: UPDATE jtf_task_contacts

1033: ) IS
1034:
1035: BEGIN
1036: -- unmark previous primary flag
1037: UPDATE jtf_task_contacts
1038: SET primary_flag = 'N'
1039: WHERE task_id = (SELECT task_id FROM jtf_task_contacts
1040: WHERE task_contact_id = p_task_contact_id)
1041: AND primary_flag = 'Y';

Line 1039: WHERE task_id = (SELECT task_id FROM jtf_task_contacts

1035: BEGIN
1036: -- unmark previous primary flag
1037: UPDATE jtf_task_contacts
1038: SET primary_flag = 'N'
1039: WHERE task_id = (SELECT task_id FROM jtf_task_contacts
1040: WHERE task_contact_id = p_task_contact_id)
1041: AND primary_flag = 'Y';
1042:
1043: END;

Line 1056: AND owner_table_name = 'JTF_TASK_CONTACTS';

1052: IS
1053: SELECT task_phone_id
1054: FROM jtf_task_phones
1055: WHERE task_contact_id = p_task_contact_id
1056: AND owner_table_name = 'JTF_TASK_CONTACTS';
1057:
1058: BEGIN
1059: OPEN c_phone_id(p_task_contact_id);
1060: LOOP