APPS.CSM_TASK_ASSIGNMENTS_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 55: FROM jtf_task_assignments jta

51: ( b_task_assignment_id number
52: )
53: IS
54: SELECT jta.object_version_number
55: FROM jtf_task_assignments jta
56: WHERE jta.task_assignment_id = b_task_assignment_id;
57:
58:
59: BEGIN

Line 114: || ' ROOT ERROR: JTF_TASK_ASSIGNMENTS_PUB.create_task_assignment'

110: THEN
111:
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
114: || ' ROOT ERROR: JTF_TASK_ASSIGNMENTS_PUB.create_task_assignment'
115: || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,
116: g_object_name || '.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
117: RETURN ;
118: END IF;

Line 394: FROM jtf_task_assignments jta

390: SELECT jta.task_id
391: , jta.object_version_number
392: , jta.last_update_date
393: , jta.last_updated_by
394: FROM jtf_task_assignments jta
395: WHERE jta.task_assignment_id = b_task_assignment_id;
396:
397: r_task_assignment c_task_assignment%ROWTYPE;
398: l_ovn NUMBER;

Line 425: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST For JTF_TASK_ASSIGNMENTS: CSM_TASK_ASSIGNMENTS_PKG.APPLY_UPDATE: P_KEY = '

421: IF(l_profile_value = csm_profile_pkg.g_SERVER_WINS AND
422: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_pub_name, p_record.seqno$$) <> FND_API.G_TRUE)
423: THEN
424: IF(r_task_assignment.last_update_date <> p_record.server_last_update_date AND r_task_assignment.last_updated_by <> asg_base.get_user_id(p_record.clid$$cs)) THEN
425: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST For JTF_TASK_ASSIGNMENTS: CSM_TASK_ASSIGNMENTS_PKG.APPLY_UPDATE: P_KEY = '
426: || p_record.task_assignment_id;
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: csm_util_pkg.log(p_error_msg,
429: g_object_name || '.APPLY_UPDATE',

Line 669: FROM csf_debrief_headers dh, jtf_task_assignments tas,

665: CURSOR c_chk_task_status( p_task_assignment_id NUMBER)
666: IS
667: SELECT dh.debrief_header_id, tst.rejected_flag, tst.on_hold_flag,
668: tst.cancelled_flag, tst.closed_flag, tst.completed_flag
669: FROM csf_debrief_headers dh, jtf_task_assignments tas,
670: jtf_task_statuses_b tst
671: WHERE dh.task_assignment_id = tas.task_assignment_id
672: AND tas.assignment_status_id = tst.task_status_id
673: AND tas.task_assignment_id = p_task_assignment_id;

Line 870: FROM JTF_TASK_ASSIGNMENTS b,

866: l_user_name in varchar2,
867: l_sequence in number)
868: IS
869: SELECT b.last_updated_by
870: FROM JTF_TASK_ASSIGNMENTS b,
871: CSM_TASK_ASSIGNMENTS_INQ a
872: WHERE a.clid$$cs = l_user_name
873: AND tranid$$ = l_tran_id
874: AND seqno$$ = l_sequence