APPS.JTF_TASK_UTL dependencies on HZ_RELATIONSHIPS

Line 3825: p_object_id hz_relationships.object_id%type,

3821: -------------
3822: -------------
3823: -- Function added for Enhancement # 2102281
3824: FUNCTION check_duplicate_reference (p_task_id jtf_tasks_b.task_id%type,
3825: p_object_id hz_relationships.object_id%type,
3826: p_object_type_code jtf_task_references_b.object_type_code%type)
3827: return boolean
3828: is
3829:

Line 3856: p_object_id hz_relationships.object_id%type)

3852: -------------
3853: -------------
3854: -- Function added for Enhancement # 2102281
3855: FUNCTION check_reference_delete (p_task_id jtf_tasks_b.task_id%type,
3856: p_object_id hz_relationships.object_id%type)
3857: return boolean
3858: is
3859:
3860: l_delete_status boolean := true;

Line 3877: select 'Exists' into l_dummy from hz_relationships

3873: */
3874:
3875: begin
3876:
3877: select 'Exists' into l_dummy from hz_relationships
3878: where party_id in (select customer_id id
3879: from jtf_tasks_b
3880: where task_id = p_task_id)
3881: and subject_id = p_object_id;

Line 3906: select 'Exists' into l_dummy from hz_relationships

3902: ** any of the subject of the assignment(s)
3903: ** for the incoming task
3904: */
3905:
3906: select 'Exists' into l_dummy from hz_relationships
3907: where party_id in (select resource_id id
3908: from jtf_task_assignments
3909: where task_id = p_task_id)
3910: and subject_id = p_object_id;

Line 3936: select 'Exists' into l_dummy from hz_relationships

3932: ** any of the subject of the contact(s)
3933: ** for the incoming task
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;

Line 3966: select 'Exists' into l_dummy from hz_relationships

3962: ** the Source
3963: ** for the incoming task
3964: */
3965:
3966: select 'Exists' into l_dummy from hz_relationships
3967: where party_id in (select source_object_id
3968: from jtf_tasks_b
3969: where task_id = p_task_id)
3970: and subject_id = p_object_id;

Line 4145: from hz_relationships

4141:
4142: cursor c_relation (b_relation_id hz_parties.party_id%type) is
4143: select object_id,
4144: subject_id
4145: from hz_relationships
4146: where party_id = b_relation_id
4147: and directional_flag = 'F' ;
4148:
4149:

Line 4359: from hz_relationships

4355:
4356: cursor c_relation (b_relation_id hz_parties.party_id%type) is
4357: select object_id,
4358: subject_id
4359: from hz_relationships
4360: where party_id = b_relation_id
4361: and directional_flag = 'F' ;
4362:
4363: cursor c_reference (b_task_id jtf_tasks_b.task_id%type,