APPS.JTF_TASK_UTL_EXT dependencies on JTF_TASK_REFERENCES_B

Line 660: FROM jtf_task_references_b

656: IS
657: CURSOR c_ref (b_task_id jtf_tasks_b.task_id%type,
658: b_source_id hz_parties.party_id%type) IS
659: SELECT task_reference_id, object_version_number
660: FROM jtf_task_references_b
661: WHERE task_id = b_task_id
662: AND object_id = b_source_id;
663:
664: l_task_ref_id NUMBER;

Line 873: p_task_reference_id jtf_task_references_b.task_reference_id%type,

869: Function added for bug #3360228 - extended from
870: jtf_task_utl.check_duplicate_reference.
871: */
872: FUNCTION check_dup_reference_for_update (
873: p_task_reference_id jtf_task_references_b.task_reference_id%type,
874: p_task_id jtf_tasks_b.task_id%type,
875: p_object_id hz_relationships.object_id%type,
876: p_object_type_code jtf_task_references_b.object_type_code%type)
877: return boolean

Line 876: p_object_type_code jtf_task_references_b.object_type_code%type)

872: FUNCTION check_dup_reference_for_update (
873: p_task_reference_id jtf_task_references_b.task_reference_id%type,
874: p_task_id jtf_tasks_b.task_id%type,
875: p_object_id hz_relationships.object_id%type,
876: p_object_type_code jtf_task_references_b.object_type_code%type)
877: return boolean
878: is
879:
880: x_count NUMBER := 0;

Line 894: FROM JTF_TASK_REFERENCES_b

890: */
891:
892: select count(object_id)
893: INTO x_count
894: FROM JTF_TASK_REFERENCES_b
895: WHERE task_reference_id <> p_task_reference_id
896: AND task_id = p_task_id
897: AND object_id = p_object_id
898: AND object_type_code = p_object_type_code