APPS.CSM_TASK_ASSIGNMENTS_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 48: FROM jtf_task_assignments jta

44: ( b_task_assignment_id number
45: )
46: IS
47: SELECT jta.object_version_number
48: FROM jtf_task_assignments jta
49: WHERE jta.task_assignment_id = b_task_assignment_id;
50:
51: l_ovn NUMBER;
52: l_task_object_version_number number;

Line 62: JTF_TASK_ASSIGNMENTS_PUB.create_task_assignment (

58: CSM_UTIL_PKG.LOG('Entering CSM_TASK_ASSIGNMENTS_PKG.APPLY_INSERT for task_assignment_id ' || p_record.task_assignment_id ,
59: 'CSM_TASK_ASSIGNMENTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
60:
61: -- Create a Task Assignment
62: JTF_TASK_ASSIGNMENTS_PUB.create_task_assignment (
63: p_api_version => 1.0,
64: p_init_msg_list => FND_API.G_TRUE,
65: p_commit => FND_API.G_FALSE,
66: p_task_assignment_id => p_record.TASK_ASSIGNMENT_ID,

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

94: THEN
95:
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
98: || ' ROOT ERROR: JTF_TASK_ASSIGNMENTS_PUB.create_task_assignment'
99: || ' for PK ' || p_record.TASK_ASSIGNMENT_ID,
100: g_object_name || '.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
101: RETURN ;
102: END IF;

Line 171: FROM jtf_task_assignments jta

167: SELECT jta.task_id
168: , jta.object_version_number
169: , jta.last_update_date
170: , jta.last_updated_by
171: FROM jtf_task_assignments jta
172: WHERE jta.task_assignment_id = b_task_assignment_id;
173:
174: r_task_assignment c_task_assignment%ROWTYPE;
175: l_ovn NUMBER;

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

199: IF(l_profile_value = csm_profile_pkg.g_SERVER_WINS AND
200: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_pub_name, p_record.seqno$$) <> FND_API.G_TRUE)
201: THEN
202: 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
203: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST For JTF_TASK_ASSIGNMENTS: CSM_TASK_ASSIGNMENTS_PKG.APPLY_UPDATE: P_KEY = '
204: || p_record.task_assignment_id;
205: x_return_status := FND_API.G_RET_STS_ERROR;
206: csm_util_pkg.log(p_error_msg,
207: g_object_name || '.APPLY_UPDATE',

Line 412: FROM csf_debrief_headers dh, jtf_task_assignments tas,

408: )
409: IS
410: SELECT dh.debrief_header_id, tst.rejected_flag, tst.on_hold_flag,
411: tst.cancelled_flag, tst.closed_flag, tst.completed_flag
412: FROM csf_debrief_headers dh, jtf_task_assignments tas,
413: jtf_task_statuses_b tst
414: WHERE dh.task_assignment_id = tas.task_assignment_id
415: AND tas.assignment_status_id = tst.task_status_id
416: AND tas.task_assignment_id = p_task_assignment_id;

Line 556: FROM JTF_TASK_ASSIGNMENTS b,

552: l_user_name in varchar2,
553: l_sequence in number)
554: IS
555: SELECT b.last_updated_by
556: FROM JTF_TASK_ASSIGNMENTS b,
557: CSM_TASK_ASSIGNMENTS_INQ a
558: WHERE a.clid$$cs = l_user_name
559: AND tranid$$ = l_tran_id
560: AND seqno$$ = l_sequence