APPS.JTF_TASK_UTL dependencies on JTF_TASK_CONTACTS

Line 306: l_contact_type_code jtf_task_contacts.contact_type_code%TYPE;

302: p_owner_table_name IN VARCHAR2
303: )
304: IS
305: x VARCHAR2(1);
306: l_contact_type_code jtf_task_contacts.contact_type_code%TYPE;
307:
308: l_person_party_id hz_parties.party_id%TYPE;
309: l_rel_party_id hz_parties.party_id%TYPE;
310:

Line 314: jtf_task_contacts tc

310:
311: cursor get_party_ids (p_contact_id Number) Is
312: select pc.party_id, pc.subject_party_id
313: from jtf_party_all_contacts_v pc,
314: jtf_task_contacts tc
315: where tc.task_contact_id = p_contact_id
316: and tc.contact_id IN (pc.party_id, pc.subject_party_id);
317:
318: BEGIN

Line 323: IF p_owner_table_name = 'JTF_TASK_CONTACTS'

319:
320: x_return_status := fnd_api.g_ret_sts_success;
321:
322: --- for backward compatibility, the owner table name is defaulted to p_owner_table_name
323: IF p_owner_table_name = 'JTF_TASK_CONTACTS'
324: OR p_owner_table_name IS NULL
325: THEN
326: --- for backward compatibility, the contact_type_code is assumed to be CUST.
327: SELECT NVL (contact_type_code, 'CUST')

Line 329: FROM jtf_task_contacts

325: THEN
326: --- for backward compatibility, the contact_type_code is assumed to be CUST.
327: SELECT NVL (contact_type_code, 'CUST')
328: INTO l_contact_type_code
329: FROM jtf_task_contacts
330: WHERE task_contact_id = p_contact_id;
331: END IF;
332:
333: IF p_owner_table_name = 'JTF_TASKS_B'

Line 345: IF p_owner_table_name = 'JTF_TASK_CONTACTS'

341: IF l_contact_type_code = 'CUST'
342: THEN
343:
344:
345: IF p_owner_table_name = 'JTF_TASK_CONTACTS'
346: THEN
347:
348: open get_party_ids(p_contact_id);
349: fetch get_party_ids into l_rel_party_id ,l_person_party_id;

Line 383: FROM jtf_task_contacts

379: INTO x
380: FROM per_phones
381: WHERE parent_table = 'PER_ALL_PEOPLE_F'
382: AND parent_id = (SELECT contact_id
383: FROM jtf_task_contacts
384: WHERE task_contact_id = p_contact_id)
385: AND phone_id = p_phone_id;
386: END IF;
387:

Line 529: Select 'Y' From JTF_TASK_CONTACTS

525: p_task_contact_id IN NUMBER DEFAULT NULL,
526: x_return_status OUT NOCOPY VARCHAR2
527: ) IS
528: Cursor c_dup_contact IS
529: Select 'Y' From JTF_TASK_CONTACTS
530: Where task_id = p_task_id
531: And contact_id = p_contact_id
532: And contact_type_code = p_contact_type_code
533: And task_contact_id <> NVL(p_task_contact_id, -99999);

Line 3114: IF p_owner_table_name NOT IN ('JTF_TASKS_B', 'JTF_TASK_CONTACTS')

3110: x_return_status := fnd_api.g_ret_sts_success;
3111:
3112: IF p_owner_table_name IS NOT NULL
3113: THEN
3114: IF p_owner_table_name NOT IN ('JTF_TASKS_B', 'JTF_TASK_CONTACTS')
3115: THEN
3116: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PHONE_TABLE');
3117: fnd_msg_pub.add;
3118: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3938: from jtf_task_contacts

3934: */
3935:
3936: select 'Exists' into l_dummy from hz_relationships
3937: where party_id in (select contact_id id
3938: from jtf_task_contacts
3939: where task_id = p_task_id)
3940: and subject_id = p_object_id;
3941:
3942:

Line 3997: from jtf_task_contacts

3993: */
3994:
3995: select 'Party exists' into l_dummy from hz_parties
3996: where party_id in (select contact_id id
3997: from jtf_task_contacts
3998: where task_id = p_task_id
3999: and contact_id = p_object_id);
4000:
4001: