APPS.CSM_TASK_EVENT_PKG dependencies on CSM_TASKS_ACC

Line 7: g_tasks_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_TASKS_ACC';

3:
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 :=

Line 9: g_tasks_seq_name CONSTANT VARCHAR2(30) := 'CSM_TASKS_ACC_S';

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');
13:

Line 92: l_user_id csm_tasks_acc.USER_ID%TYPE;

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:
96: CURSOR l_purge_tasks_csr

Line 102: FROM csm_tasks_acc acc,

98: SELECT acc.task_id,
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

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 331: FROM csm_tasks_acc acc

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;
333:
334: CURSOR l_del_task_foreachuser_csr(p_task_id jtf_tasks_b.task_id%TYPE)
335: IS

Line 338: csm_tasks_acc acc,

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
342: AND jt.task_id = acc.task_id

Line 472: -- insert into csm_tasks_acc

468: p_userid=>l_task_rec.CREATED_BY,
469: p_error_msg=>l_error_msg,
470: x_return_status=>l_return_status);
471:
472: -- insert into csm_tasks_acc
473: csm_task_event_pkg.acc_insert(p_task_id=>p_task_id,
474: p_user_id=>l_task_rec.CREATED_BY);
475: IF l_task_rec.SOURCE_OBJECT_TYPE_CODE ='TASK' AND l_task_rec.ADDRESS_ID IS NOT NULL THEN
476: --insert party sites

Line 511: FROM csm_tasks_acc acc

507: FROM JTF_TASKS_B jt
508: WHERE jt.TASK_ID = b_task_id
509: AND EXISTS
510: (SELECT 1
511: FROM csm_tasks_acc acc
512: WHERE acc.user_id = jt.created_by
513: AND acc.task_id = jt.task_id);
514:
515: l_task_rec l_task_csr%ROWTYPE;

Line 536: -- delete from csm_tasks_acc

532: p_userid=>l_task_rec.CREATED_BY,
533: p_error_msg=>l_error_msg,
534: x_return_status=>l_return_status);
535:
536: -- delete from csm_tasks_acc
537: csm_task_event_pkg.acc_delete(p_task_id=>p_task_id,
538: p_user_id=>l_task_rec.CREATED_BY);
539:
540: IF l_task_rec.SOURCE_OBJECT_TYPE_CODE ='TASK' AND l_task_rec.ADDRESS_ID IS NOT NULL THEN