APPS.JTF_TASK_UTL dependencies on JTF_TASK_REFERENCES_B

Line 30: FROM jtf_task_references_b

26: INTO
27: l_owner
28: FROM jtf_tasks_b esc
29: WHERE task_id IN (SELECT task_id
30: FROM jtf_task_references_b
31: WHERE object_id = p_task_id
32: AND object_type_code = 'TASK'
33: AND reference_code = 'ESC')
34: AND task_type_id = 22;

Line 51: FROM jtf_task_references_b

47: SELECT lookups.meaning
48: INTO l_meaning
49: FROM jtf_tasks_b, fnd_lookups lookups
50: WHERE task_id IN (SELECT task_id
51: FROM jtf_task_references_b
52: WHERE object_id = p_task_id
53: AND object_type_code = 'TASK'
54: AND reference_code = 'ESC')
55: AND task_type_id = 22

Line 3826: p_object_type_code jtf_task_references_b.object_type_code%type)

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:
3830: x_count NUMBER := 0;

Line 3836: FROM JTF_TASK_REFERENCES_b

3832:
3833: begin
3834: select count(object_id)
3835: INTO x_count
3836: FROM JTF_TASK_REFERENCES_b
3837: WHERE task_id = p_task_id
3838: AND object_id = p_object_id
3839: AND object_type_code = p_object_type_code
3840: AND rownum = 1;

Line 4123: l_reference_id jtf_task_references_b.task_reference_id%type;

4119: ---
4120:
4121: IS
4122:
4123: l_reference_id jtf_task_references_b.task_reference_id%type;
4124: l_object_id hz_parties.party_id%type;
4125: l_subject_id hz_parties.party_id%type;
4126: l_party_name hz_parties.party_name%type;
4127: l_party_type hz_parties.party_type%type;

Line 4338: l_reference_id jtf_task_references_b.task_reference_id%type;

4334: x_msg_data OUT NOCOPY varchar2,
4335: x_return_status OUT NOCOPY varchar2)
4336: IS
4337:
4338: l_reference_id jtf_task_references_b.task_reference_id%type;
4339: l_object_version jtf_task_references_b.object_version_number%type;
4340: l_object_id hz_parties.party_id%type;
4341: l_subject_id hz_parties.party_id%type;
4342: l_party_type hz_parties.party_type%type;

Line 4339: l_object_version jtf_task_references_b.object_version_number%type;

4335: x_return_status OUT NOCOPY varchar2)
4336: IS
4337:
4338: l_reference_id jtf_task_references_b.task_reference_id%type;
4339: l_object_version jtf_task_references_b.object_version_number%type;
4340: l_object_id hz_parties.party_id%type;
4341: l_subject_id hz_parties.party_id%type;
4342: l_party_type hz_parties.party_type%type;
4343: l_task_type jtf_tasks_b.task_type_id%type;

Line 4367: from jtf_task_references_b

4363: cursor c_reference (b_task_id jtf_tasks_b.task_id%type,
4364: b_party_id hz_parties.party_id%type) is
4365: select task_reference_id,
4366: object_version_number
4367: from jtf_task_references_b
4368: where task_id = b_task_id
4369: and object_id = b_party_id;
4370:
4371: BEGIN