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_TASK_EVENT_PKG dependencies on JTF_TASKS_B

Line 8: g_tasks_table_name CONSTANT VARCHAR2(30) := 'JTF_TASKS_B';

4: l_markdirty_failed EXCEPTION;
5:
6: /*** Globals ***/
7: g_tasks_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_TASKS_ACC';
8: g_tasks_table_name CONSTANT VARCHAR2(30) := 'JTF_TASKS_B';
9: g_tasks_seq_name CONSTANT VARCHAR2(30) := 'CSM_TASKS_ACC_S';
10: g_tasks_pk1_name CONSTANT VARCHAR2(30) := 'TASK_ID';
11: g_tasks_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
12: CSM_ACC_PKG.t_publication_item_list('CSM_TASKS');

Line 16: p_task_id jtf_tasks_b.task_id%TYPE)

12: CSM_ACC_PKG.t_publication_item_list('CSM_TASKS');
13:
14: /** to be called from csm_task_assignment_event_pkg.task_assignments_acc_processor **/
15: PROCEDURE ACC_INSERT (p_user_id in fnd_user.user_id%TYPE,
16: p_task_id jtf_tasks_b.task_id%TYPE)
17: IS
18: l_sqlerrno VARCHAR2(20);
19: l_sqlerrmsg VARCHAR2(4000);
20: l_error_msg VARCHAR2(4000);

Line 52: p_task_id jtf_tasks_b.task_id%TYPE)

48:
49:
50: /** to be called from csm_task_assignment_event_pkg.task_assignments_acc_d **/
51: PROCEDURE ACC_DELETE (p_user_id in fnd_user.user_id%TYPE,
52: p_task_id jtf_tasks_b.task_id%TYPE)
53: IS
54: l_sqlerrno VARCHAR2(20);
55: l_sqlerrmsg VARCHAR2(4000);
56: l_error_msg VARCHAR2(4000);

Line 91: l_task_id jtf_tasks_b.task_id%TYPE;

87: **/
88: PROCEDURE PURGE_TASKS_CONC(p_status OUT NOCOPY VARCHAR2, p_message OUT NOCOPY VARCHAR2)
89: IS
90: PRAGMA AUTONOMOUS_TRANSACTION;
91: l_task_id jtf_tasks_b.task_id%TYPE;
92: l_user_id csm_tasks_acc.USER_ID%TYPE;
93: l_last_run_date date;
94: l_dummy NUMBER;
95:

Line 103: jtf_tasks_b jt

99: acc.USER_ID,
100: acc.COUNTER,
101: jt.source_object_type_code
102: FROM csm_tasks_acc acc,
103: jtf_tasks_b jt
104: WHERE jt.task_id = acc.task_id
105: AND jt.created_by = acc.user_id -- task is created by the user
106: AND jt.creation_date
107: < (SYSDATE - csm_profile_pkg.get_task_history_days(acc.user_id))

Line 135: TYPE l_task_src_type_tbl_type IS TABLE OF jtf_tasks_b.source_object_type_code%TYPE INDEX BY BINARY_INTEGER;

131: TYPE l_userid_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
132: l_userid_tbl l_userid_tbl_type;
133: TYPE l_counter_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
134: l_counter_tbl l_counter_tbl_type;
135: TYPE l_task_src_type_tbl_type IS TABLE OF jtf_tasks_b.source_object_type_code%TYPE INDEX BY BINARY_INTEGER;
136: l_task_src_type_tbl l_task_src_type_tbl_type;
137:
138: l_tsk_counter NUMBER;
139: l_tas_counter NUMBER;

Line 240: FROM jtf_task_references_b ref, CSM_TASKS_ACC acc, JTF_TASKS_B esc

236:
237: CURSOR c_check_esc_tasks (b_last_run_date DATE)
238: IS
239: SELECT acc.TASK_ID
240: FROM jtf_task_references_b ref, CSM_TASKS_ACC acc, JTF_TASKS_B esc
241: WHERE ref.OBJECT_ID = acc.TASK_ID
242: AND ref.object_type_code = 'TASK'
243: AND ref.reference_code = 'ESC'
244: AND ref.task_id = esc.task_id

Line 259: l_task_id JTF_TASKS_B.TASK_ID%TYPE;

255: FOR UPDATE OF last_run_date NOWAIT;
256:
257: l_upd_last_run_date DATE;
258: l_last_run_date DATE;
259: l_task_id JTF_TASKS_B.TASK_ID%TYPE;
260: l_sqlerrno VARCHAR2(20);
261: l_sqlerrmsg VARCHAR2(4000);
262: l_error_msg VARCHAR2(4000);
263: l_return_status VARCHAR2(2000);

Line 323: l_task_id jtf_tasks_b.task_id%TYPE;

319: l_accesslist asg_download.access_list;
320: l_resourcelist asg_download.user_list;
321: l_publicationitemname VARCHAR2(50);
322: l_access_count NUMBER;
323: l_task_id jtf_tasks_b.task_id%TYPE;
324: l_sqlerrmsg VARCHAR2(4000);
325: l_error_msg VARCHAR2(4000);
326: l_return_status VARCHAR2(2000);
327:

Line 328: CURSOR l_upd_task_foreachuser_csr (p_task_id jtf_tasks_b.task_id%TYPE)

324: l_sqlerrmsg VARCHAR2(4000);
325: l_error_msg VARCHAR2(4000);
326: l_return_status VARCHAR2(2000);
327:
328: CURSOR l_upd_task_foreachuser_csr (p_task_id jtf_tasks_b.task_id%TYPE)
329: IS
330: SELECT acc.user_id, acc.access_id
331: FROM csm_tasks_acc acc
332: WHERE acc.task_id = p_task_id;

Line 334: CURSOR l_del_task_foreachuser_csr(p_task_id jtf_tasks_b.task_id%TYPE)

330: SELECT acc.user_id, acc.access_id
331: FROM csm_tasks_acc acc
332: WHERE acc.task_id = p_task_id;
333:
334: CURSOR l_del_task_foreachuser_csr(p_task_id jtf_tasks_b.task_id%TYPE)
335: IS
336: SELECT acc.user_id, jta.task_assignment_id
337: FROM jtf_tasks_b jt,
338: csm_tasks_acc acc,

Line 337: FROM jtf_tasks_b jt,

333:
334: CURSOR l_del_task_foreachuser_csr(p_task_id jtf_tasks_b.task_id%TYPE)
335: IS
336: SELECT acc.user_id, jta.task_assignment_id
337: FROM jtf_tasks_b jt,
338: csm_tasks_acc acc,
339: jtf_task_statuses_b jts,
340: jtf_task_assignments jta
341: WHERE acc.task_id = p_task_id

Line 437: FROM JTF_TASKS_B jt,

433: l_return_status VARCHAR2(2000);
434:
435: CURSOR l_task_csr (b_task_id NUMBER) IS
436: SELECT jt.CREATED_BY, jtt.private_flag, jt.source_object_type_code -- 22 means Escalation task
437: FROM JTF_TASKS_B jt,
438: jtf_task_types_b jtt
439: WHERE jt.TASK_ID = b_task_id
440: AND jtt.task_type_id = jt.task_type_id;
441:

Line 493: FROM JTF_TASKS_B jt

489: l_return_status VARCHAR2(2000);
490:
491: CURSOR l_task_csr (b_task_id NUMBER) IS
492: SELECT jt.CREATED_BY
493: FROM JTF_TASKS_B jt
494: WHERE jt.TASK_ID = b_task_id
495: AND EXISTS
496: (SELECT 1
497: FROM csm_tasks_acc acc