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.CSM_TASKS_PKG dependencies on JTF_TASKS_B

Line 66: l_task_id jtf_tasks_b.task_id%TYPE;

62:
63: -- Declare OUT parameters
64: l_msg_count NUMBER;
65: l_msg_data VARCHAR2(240);
66: l_task_id jtf_tasks_b.task_id%TYPE;
67:
68: -- Declare default parameters
69: l_task_type jtf_tasks_b.task_type_id%TYPE;
70: l_task_status jtf_tasks_b.task_status_id%TYPE;

Line 69: l_task_type jtf_tasks_b.task_type_id%TYPE;

65: l_msg_data VARCHAR2(240);
66: l_task_id jtf_tasks_b.task_id%TYPE;
67:
68: -- Declare default parameters
69: l_task_type jtf_tasks_b.task_type_id%TYPE;
70: l_task_status jtf_tasks_b.task_status_id%TYPE;
71: l_task_priority jtf_tasks_b.task_priority_id%TYPE;
72: l_task_source_object_name jtf_tasks_b.source_object_name%TYPE;
73: l_address_id JTF_TASKS_B.ADDRESS_ID%TYPE := null;

Line 70: l_task_status jtf_tasks_b.task_status_id%TYPE;

66: l_task_id jtf_tasks_b.task_id%TYPE;
67:
68: -- Declare default parameters
69: l_task_type jtf_tasks_b.task_type_id%TYPE;
70: l_task_status jtf_tasks_b.task_status_id%TYPE;
71: l_task_priority jtf_tasks_b.task_priority_id%TYPE;
72: l_task_source_object_name jtf_tasks_b.source_object_name%TYPE;
73: l_address_id JTF_TASKS_B.ADDRESS_ID%TYPE := null;
74: l_customer_id JTF_TASKS_B.CUSTOMER_ID%TYPE;

Line 71: l_task_priority jtf_tasks_b.task_priority_id%TYPE;

67:
68: -- Declare default parameters
69: l_task_type jtf_tasks_b.task_type_id%TYPE;
70: l_task_status jtf_tasks_b.task_status_id%TYPE;
71: l_task_priority jtf_tasks_b.task_priority_id%TYPE;
72: l_task_source_object_name jtf_tasks_b.source_object_name%TYPE;
73: l_address_id JTF_TASKS_B.ADDRESS_ID%TYPE := null;
74: l_customer_id JTF_TASKS_B.CUSTOMER_ID%TYPE;
75: l_incident_location_type CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_TYPE%TYPE;

Line 72: l_task_source_object_name jtf_tasks_b.source_object_name%TYPE;

68: -- Declare default parameters
69: l_task_type jtf_tasks_b.task_type_id%TYPE;
70: l_task_status jtf_tasks_b.task_status_id%TYPE;
71: l_task_priority jtf_tasks_b.task_priority_id%TYPE;
72: l_task_source_object_name jtf_tasks_b.source_object_name%TYPE;
73: l_address_id JTF_TASKS_B.ADDRESS_ID%TYPE := null;
74: l_customer_id JTF_TASKS_B.CUSTOMER_ID%TYPE;
75: l_incident_location_type CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_TYPE%TYPE;
76: l_incident_location_id CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_ID%TYPE;

Line 73: l_address_id JTF_TASKS_B.ADDRESS_ID%TYPE := null;

69: l_task_type jtf_tasks_b.task_type_id%TYPE;
70: l_task_status jtf_tasks_b.task_status_id%TYPE;
71: l_task_priority jtf_tasks_b.task_priority_id%TYPE;
72: l_task_source_object_name jtf_tasks_b.source_object_name%TYPE;
73: l_address_id JTF_TASKS_B.ADDRESS_ID%TYPE := null;
74: l_customer_id JTF_TASKS_B.CUSTOMER_ID%TYPE;
75: l_incident_location_type CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_TYPE%TYPE;
76: l_incident_location_id CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_ID%TYPE;
77: l_location_id JTF_TASKS_B.LOCATION_ID%TYPE := null;

Line 74: l_customer_id JTF_TASKS_B.CUSTOMER_ID%TYPE;

70: l_task_status jtf_tasks_b.task_status_id%TYPE;
71: l_task_priority jtf_tasks_b.task_priority_id%TYPE;
72: l_task_source_object_name jtf_tasks_b.source_object_name%TYPE;
73: l_address_id JTF_TASKS_B.ADDRESS_ID%TYPE := null;
74: l_customer_id JTF_TASKS_B.CUSTOMER_ID%TYPE;
75: l_incident_location_type CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_TYPE%TYPE;
76: l_incident_location_id CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_ID%TYPE;
77: l_location_id JTF_TASKS_B.LOCATION_ID%TYPE := null;
78: l_owner_id JTF_tasks_b.owner_id%type :=null;

Line 77: l_location_id JTF_TASKS_B.LOCATION_ID%TYPE := null;

73: l_address_id JTF_TASKS_B.ADDRESS_ID%TYPE := null;
74: l_customer_id JTF_TASKS_B.CUSTOMER_ID%TYPE;
75: l_incident_location_type CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_TYPE%TYPE;
76: l_incident_location_id CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_ID%TYPE;
77: l_location_id JTF_TASKS_B.LOCATION_ID%TYPE := null;
78: l_owner_id JTF_tasks_b.owner_id%type :=null;
79: l_owner_type JTF_tasks_b.owner_type_code%type :=null;
80: l_is_private NUMBER;
81: l_sync_resource_id l_owner_id%TYPE;

Line 78: l_owner_id JTF_tasks_b.owner_id%type :=null;

74: l_customer_id JTF_TASKS_B.CUSTOMER_ID%TYPE;
75: l_incident_location_type CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_TYPE%TYPE;
76: l_incident_location_id CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_ID%TYPE;
77: l_location_id JTF_TASKS_B.LOCATION_ID%TYPE := null;
78: l_owner_id JTF_tasks_b.owner_id%type :=null;
79: l_owner_type JTF_tasks_b.owner_type_code%type :=null;
80: l_is_private NUMBER;
81: l_sync_resource_id l_owner_id%TYPE;
82: l_responsibility_id NUMBER;

Line 79: l_owner_type JTF_tasks_b.owner_type_code%type :=null;

75: l_incident_location_type CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_TYPE%TYPE;
76: l_incident_location_id CS_INCIDENTS_ALL_B.INCIDENT_LOCATION_ID%TYPE;
77: l_location_id JTF_TASKS_B.LOCATION_ID%TYPE := null;
78: l_owner_id JTF_tasks_b.owner_id%type :=null;
79: l_owner_type JTF_tasks_b.owner_type_code%type :=null;
80: l_is_private NUMBER;
81: l_sync_resource_id l_owner_id%TYPE;
82: l_responsibility_id NUMBER;
83: l_csm_appl_id NUMBER;

Line 298: FROM jtf_tasks_b

294: )
295: IS
296: CURSOR c_task ( b_task_id NUMBER ) IS
297: SELECT object_version_number
298: FROM jtf_tasks_b
299: WHERE task_id = b_task_id;
300:
301: CURSOR c_last_update_date ( b_task_id NUMBER)
302: IS

Line 305: FROM jtf_tasks_b

301: CURSOR c_last_update_date ( b_task_id NUMBER)
302: IS
303: SELECT LAST_UPDATE_DATE,
304: last_updated_by
305: FROM jtf_tasks_b
306: WHERE task_id = b_task_id;
307:
308: --variable declarations
309: r_task c_task%ROWTYPE;