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_EC_PUB dependencies on JTF_TASK_REFERENCES_B

Line 237: l_escalation_contact_id jtf_task_references_b.task_reference_id%TYPE;

233: l_escalation_number jtf_tasks_b.task_number%TYPE := p_esc_number;
234: l_return_status varchar2(1) := 'x';
235: l_api_name varchar2(30) := 'Create_Esc_Contacts';
236: l_task_phone_id jtf_task_phones.task_phone_id%TYPE := NULL;
237: l_escalation_contact_id jtf_task_references_b.task_reference_id%TYPE;
238:
239: BEGIN
240:
241: SAVEPOINT Create_Esc_Contacts;

Line 386: l_task_ref_id jtf_task_references_b.task_reference_id%TYPE := NULL; --esc id where ref doc is escalated

382: l_reference_documents Esc_Ref_Docs_Rec_Type := p_reference_documents_rec;
383: l_escalation_id jtf_tasks_b.task_id%TYPE := p_esc_id;
384: l_escalation_number jtf_tasks_b.task_number%TYPE := p_esc_number;
385: l_return_status varchar2(1) := 'x';
386: l_task_ref_id jtf_task_references_b.task_reference_id%TYPE := NULL; --esc id where ref doc is escalated
387: l_api_name varchar2(30) := 'Create_Esc_Reference';
388: l_escalation_reference_id jtf_task_references_b.task_reference_id%TYPE;
389:
390: BEGIN

Line 388: l_escalation_reference_id jtf_task_references_b.task_reference_id%TYPE;

384: l_escalation_number jtf_tasks_b.task_number%TYPE := p_esc_number;
385: l_return_status varchar2(1) := 'x';
386: l_task_ref_id jtf_task_references_b.task_reference_id%TYPE := NULL; --esc id where ref doc is escalated
387: l_api_name varchar2(30) := 'Create_Esc_Reference';
388: l_escalation_reference_id jtf_task_references_b.task_reference_id%TYPE;
389:
390: BEGIN
391:
392: SAVEPOINT Create_Esc_Reference;

Line 573: l_escalation_reference_id jtf_task_references_b.task_reference_id%TYPE;

569: l_return_status varchar2(1) := 'x';
570: l_owner_id jtf_tasks_b.owner_id%TYPE:=NULL;
571: l_req_count NUMBER := 0;
572: l_escalation_contact_id jtf_task_contacts.task_contact_id%TYPE;
573: l_escalation_reference_id jtf_task_references_b.task_reference_id%TYPE;
574: l_temp VARCHAR2(10);
575: l_esc_status_id jtf_tasks_b.task_status_id%TYPE;
576: l_task_phone_id jtf_task_phones.task_phone_id%TYPE := NULL;
577: l_user_id NUMBER := p_user_id;

Line 1238: l_task_ref_id jtf_task_references_b.task_reference_id%TYPE;

1234: l_return_status varchar2(1) := 'x';
1235: l_closed_flag varchar2(1) := 'N';
1236: l_esc_close_date jtf_tasks_b.actual_end_date%TYPE;
1237: l_esc_task_id jtf_tasks_b.task_id%TYPE := NULL; --esc id where ref doc is escalated
1238: l_task_ref_id jtf_task_references_b.task_reference_id%TYPE;
1239: l_escalation_reference_id jtf_task_references_b.task_reference_id%TYPE;
1240: l_escalation_contact_id jtf_task_references_b.task_reference_id%TYPE;
1241: l_task_phone_id jtf_task_phones.task_phone_id%TYPE := NULL;
1242: l_owner_changed VARCHAR2(1) := 'N';

Line 1239: l_escalation_reference_id jtf_task_references_b.task_reference_id%TYPE;

1235: l_closed_flag varchar2(1) := 'N';
1236: l_esc_close_date jtf_tasks_b.actual_end_date%TYPE;
1237: l_esc_task_id jtf_tasks_b.task_id%TYPE := NULL; --esc id where ref doc is escalated
1238: l_task_ref_id jtf_task_references_b.task_reference_id%TYPE;
1239: l_escalation_reference_id jtf_task_references_b.task_reference_id%TYPE;
1240: l_escalation_contact_id jtf_task_references_b.task_reference_id%TYPE;
1241: l_task_phone_id jtf_task_phones.task_phone_id%TYPE := NULL;
1242: l_owner_changed VARCHAR2(1) := 'N';
1243: l_level_changed VARCHAR2(1) := 'N';

Line 1240: l_escalation_contact_id jtf_task_references_b.task_reference_id%TYPE;

1236: l_esc_close_date jtf_tasks_b.actual_end_date%TYPE;
1237: l_esc_task_id jtf_tasks_b.task_id%TYPE := NULL; --esc id where ref doc is escalated
1238: l_task_ref_id jtf_task_references_b.task_reference_id%TYPE;
1239: l_escalation_reference_id jtf_task_references_b.task_reference_id%TYPE;
1240: l_escalation_contact_id jtf_task_references_b.task_reference_id%TYPE;
1241: l_task_phone_id jtf_task_phones.task_phone_id%TYPE := NULL;
1242: l_owner_changed VARCHAR2(1) := 'N';
1243: l_level_changed VARCHAR2(1) := 'N';
1244: l_status_changed VARCHAR2(1) := 'N';

Line 1252: l_object_name jtf_task_references_b.object_name%TYPE;

1248: l_old_escalation_level jtf_tasks_b.escalation_level%TYPE;
1249: l_old_target_date jtf_tasks_b.planned_end_date%TYPE;
1250: l_notif_not_sent VARCHAR2(2000);
1251: l_wf_process_id NUMBER;
1252: l_object_name jtf_task_references_b.object_name%TYPE;
1253: l_object_id jtf_task_references_b.object_id%TYPE;
1254: l_object_type_code jtf_task_references_b.object_type_code%TYPE;
1255:
1256: cursor c_cont_phone_id (p_task_contact_id NUMBER) is

Line 1253: l_object_id jtf_task_references_b.object_id%TYPE;

1249: l_old_target_date jtf_tasks_b.planned_end_date%TYPE;
1250: l_notif_not_sent VARCHAR2(2000);
1251: l_wf_process_id NUMBER;
1252: l_object_name jtf_task_references_b.object_name%TYPE;
1253: l_object_id jtf_task_references_b.object_id%TYPE;
1254: l_object_type_code jtf_task_references_b.object_type_code%TYPE;
1255:
1256: cursor c_cont_phone_id (p_task_contact_id NUMBER) is
1257: select task_phone_id, object_version_number

Line 1254: l_object_type_code jtf_task_references_b.object_type_code%TYPE;

1250: l_notif_not_sent VARCHAR2(2000);
1251: l_wf_process_id NUMBER;
1252: l_object_name jtf_task_references_b.object_name%TYPE;
1253: l_object_id jtf_task_references_b.object_id%TYPE;
1254: l_object_type_code jtf_task_references_b.object_type_code%TYPE;
1255:
1256: cursor c_cont_phone_id (p_task_contact_id NUMBER) is
1257: select task_phone_id, object_version_number
1258: from jtf_task_phones

Line 1270: from jtf_task_references_b

1266: cursor c_get_ref_details(p_task_ref_id NUMBER) Is
1267: Select object_type_code,
1268: object_id,
1269: object_name
1270: from jtf_task_references_b
1271: where task_reference_id = p_task_ref_id;
1272:
1273: BEGIN
1274: