APPS.CSL_JTF_TASKS_ACC_PKG dependencies on JTF_TASKS_B

Line 24: FROM JTF_TASKS_B

20: RETURN BOOLEAN
21: IS
22: CURSOR c_task (b_task_id NUMBER) IS
23: SELECT *
24: FROM JTF_TASKS_B
25: WHERE task_id = b_task_id;
26: r_task c_task%ROWTYPE;
27:
28: CURSOR c_task_status (b_task_status_id NUMBER) IS

Line 193: FROM jtf_tasks_b

189: RETURN NUMBER
190: IS
191: CURSOR c_parent( b_task_id NUMBER ) IS
192: SELECT source_object_id
193: FROM jtf_tasks_b
194: WHERE source_object_type_code = 'SR'
195: AND task_id = b_task_id;
196: r_parent c_parent%ROWTYPE;
197: BEGIN

Line 218: FROM JTF_TASKS_B

214: l_return BOOLEAN;
215:
216: CURSOR c_task( b_task_id NUMBER ) IS
217: SELECT *
218: FROM JTF_TASKS_B
219: WHERE TASK_ID = b_task_id;
220:
221: r_task c_task%ROWTYPE;
222:

Line 345: FROM JTF_TASKS_B

341: )
342: IS
343: CURSOR c_task( b_task_id NUMBER ) IS
344: SELECT *
345: FROM JTF_TASKS_B
346: WHERE TASK_ID = b_task_id;
347:
348: r_task c_task%ROWTYPE;
349:

Line 403: /*CSL_LOBS_ACC_PKG.DELETE_ATTACHMENTS ( p_entity_name => 'JTF_TASKS_B',

399: END IF;
400:
401: --Bug 3724142
402: --ATTACHMENTS
403: /*CSL_LOBS_ACC_PKG.DELETE_ATTACHMENTS ( p_entity_name => 'JTF_TASKS_B',
404: p_primary_key => p_task_id,
405: p_resource_id => p_resource_id);*/
406:
407: END IF;

Line 561: FROM JTF_TASKS_B tk

557: l_task_id NUMBER;
558: CURSOR c_task( b_task_id NUMBER ) IS
559: SELECT tk.SOURCE_OBJECT_TYPE_CODE
560: , au.RESOURCE_ID
561: FROM JTF_TASKS_B tk
562: , ASG_USER au
563: WHERE tk.TASK_ID = b_task_id
564: AND tk.CREATED_BY = au.USER_ID;
565: r_task c_task%ROWTYPE;

Line 631: FROM JTF_TASKS_B

627: l_task_id NUMBER;
628: l_enabled_flag VARCHAR2(30);
629: CURSOR c_task_address( b_task_id NUMBER ) IS
630: SELECT ADDRESS_ID
631: FROM JTF_TASKS_B
632: WHERE TASK_ID = b_task_id;
633: BEGIN
634: l_enabled_flag := JTM_PROFILE_UTL_PKG.GET_ENABLE_FLAG_AT_RESP( P_APP_SHORT_NAME => 'CSL');
635: IF l_enabled_flag <> 'Y' THEN

Line 698: FROM JTF_TASKS_B

694: r_task_assignment c_task_assignment%ROWTYPE;
695:
696: CURSOR c_task_address( b_task_id NUMBER ) IS
697: SELECT ADDRESS_ID
698: FROM JTF_TASKS_B
699: WHERE TASK_ID = b_task_id;
700:
701: l_address_id NUMBER;
702: l_address_changed BOOLEAN := FALSE;

Line 896: FROM JTF_TASKS_B tk

892: , x_return_status OUT NOCOPY VARCHAR2 ) IS
893:
894: CURSOR c_task( b_resource_id NUMBER ) IS
895: SELECT tk.task_id
896: FROM JTF_TASKS_B tk
897: , ASG_USER au
898: WHERE tk.SOURCE_OBJECT_TYPE_CODE = 'SR'
899: AND tk.CREATED_BY = au.USER_ID
900: AND au.RESOURCE_ID = b_resource_id;

Line 950: jtf_tasks_b jt,

946:
947: CURSOR lcur_purge_tasks IS
948: SELECT acc.task_id, acc.resource_id
949: FROM csl_jtf_tasks_acc acc,
950: jtf_tasks_b jt,
951: jtf_task_statuses_b jts
952: WHERE acc.task_id = jt.task_id
953: AND jts.task_status_id = jt.task_status_id
954: AND (NVL(jt.scheduled_start_date, SYSDATE) < (SYSDATE - TO_NUMBER(FND_PROFILE.Value('CSL_APPL_HISTORY_IN_DAYS'))))