APPS.CSL_TASK_ASSIGNMENTS_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 8: g_pub_name CONSTANT VARCHAR2(30) := 'CSL_JTF_TASK_ASSIGNMENTS';

4: error EXCEPTION;
5:
6: /*** Globals ***/
7: g_object_name CONSTANT VARCHAR2(30) := 'CSL_TASK_ASSIGNMENTS_PKG';
8: g_pub_name CONSTANT VARCHAR2(30) := 'CSL_JTF_TASK_ASSIGNMENTS';
9: g_debug_level NUMBER; -- debug level
10:
11: CURSOR c_task_ass( b_user_name VARCHAR2, b_tranid NUMBER) is
12: SELECT *

Line 13: FROM CSL_JTF_TASK_ASSIGNMENTS_inq

9: g_debug_level NUMBER; -- debug level
10:
11: CURSOR c_task_ass( b_user_name VARCHAR2, b_tranid NUMBER) is
12: SELECT *
13: FROM CSL_JTF_TASK_ASSIGNMENTS_inq
14: WHERE tranid$$ = b_tranid
15: AND clid$$cs = b_user_name;
16:
17: /***

Line 33: FROM jtf_task_assignments jta

29: )
30: IS
31: SELECT jta.assignment_status_id
32: , jta.object_version_number
33: FROM jtf_task_assignments jta
34: WHERE jta.task_assignment_id = b_task_assignment_id;
35:
36: r_task_assignment c_task_assignment%rowtype;
37:

Line 59: JTF_TASK_ASSIGNMENTS_PUB.create_task_assignment (

55: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
56: END IF;
57:
58: -- Create a Task Assignment
59: JTF_TASK_ASSIGNMENTS_PUB.create_task_assignment (
60: p_api_version => 1.0,
61: p_init_msg_list => FND_API.G_TRUE,
62: p_commit => FND_API.G_FALSE,
63: p_task_assignment_id => p_record.TASK_ASSIGNMENT_ID,

Line 190: FROM jtf_task_assignments jta

186: )
187: IS
188: SELECT jta.assignment_status_id
189: , jta.object_version_number
190: FROM jtf_task_assignments jta
191: WHERE jta.task_assignment_id = b_task_assignment_id;
192:
193: r_task_assignment c_task_assignment%rowtype;
194:

Line 200: from JTF_TASK_ASSIGNMENTS

196: ( b_task_assignment_id NUMBER
197: )
198: is
199: SELECT LAST_UPDATE_DATE, LAST_UPDATED_BY
200: from JTF_TASK_ASSIGNMENTS
201: where task_assignment_id = b_task_assignment_id;
202:
203: r_last_update_date c_last_update_date%ROWTYPE;
204:

Line 305: JTF_TASK_ASSIGNMENTS_PUB.Update_Task_Assignment

301: -- We do not update the status of the task assignment here.
302: -- A special API for that exists.
303:
304: -- Call task assignments public api
305: JTF_TASK_ASSIGNMENTS_PUB.Update_Task_Assignment
306: ( p_api_version => 1.0
307: , p_task_assignment_id => p_record.task_assignment_id
308: , p_object_version_number => l_assignment_obj_version_nr
309: , p_task_id => p_record.task_id

Line 574: This procedure is called by CSL_SERVICEL_WRAPPER_PKG when publication item CSL_JTF_TASK_ASSIGNMENTS

570: x_return_status := FND_API.G_RET_STS_ERROR;
571: END APPLY_RECORD;
572:
573: /***
574: This procedure is called by CSL_SERVICEL_WRAPPER_PKG when publication item CSL_JTF_TASK_ASSIGNMENTS
575: is dirty. This happens when a mobile field service device executed DML on an updatable table and did
576: a fast sync. This procedure will insert the data that came from mobile into the backend tables using
577: public APIs.
578: ***/

Line 608: FROM csf_debrief_headers dh, jtf_task_assignments tas,

604: ( b_task_assignment_id NUMBER
605: ) IS
606: SELECT dh.debrief_header_id, tst.rejected_flag, tst.on_hold_flag,
607: tst.cancelled_flag, tst.closed_flag, tst.completed_flag
608: FROM csf_debrief_headers dh, jtf_task_assignments tas,
609: jtf_task_statuses_b tst
610: WHERE dh.task_assignment_id = tas.task_assignment_id
611: AND tas.assignment_status_id = tst.task_status_id
612: AND tas.task_assignment_id = b_task_assignment_id;

Line 638: /*** loop through CSL_JTF_TASK_ASSIGNMENTS records in inqueue ***/

634: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'
635: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
636: END IF;
637:
638: /*** loop through CSL_JTF_TASK_ASSIGNMENTS records in inqueue ***/
639: FOR r_task_ass IN c_task_ass( p_user_name, p_tranid) LOOP
640:
641: SAVEPOINT save_rec;
642:

Line 799: FROM JTF_TASK_ASSIGNMENTS b, CSL_JTF_TASK_ASSIGNMENTS_INQ a

795: cursor get_user_id(l_tran_id in number,
796: l_user_name in varchar2)
797: IS
798: SELECT b.last_updated_by
799: FROM JTF_TASK_ASSIGNMENTS b, CSL_JTF_TASK_ASSIGNMENTS_INQ a
800: WHERE a.clid$$cs = l_user_name
801: AND tranid$$ = l_tran_id AND a.task_assignment_id = b.task_assignment_id
802: AND a.SEQNO$$ = p_sequence;
803: