eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_DEBRIEF_PVT dependencies on JTF_TASK_ASSIGNMENTS_PUB

Line 3284: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;

3280: l_debrief_header_id number := null;
3281: begin
3282: x_return_status := FND_API.G_RET_STS_SUCCESS;
3283: l_task_assignment_id :=
3284: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
3285: l_new_resource_id :=
3286: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
3287: l_new_resource_type :=
3288: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;

Line 3286: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;

3282: x_return_status := FND_API.G_RET_STS_SUCCESS;
3283: l_task_assignment_id :=
3284: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
3285: l_new_resource_id :=
3286: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
3287: l_new_resource_type :=
3288: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
3289:
3290: select cdh.debrief_header_id,resource_type_code,resource_id

Line 3288: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;

3284: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
3285: l_new_resource_id :=
3286: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
3287: l_new_resource_type :=
3288: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
3289:
3290: select cdh.debrief_header_id,resource_type_code,resource_id
3291: into l_debrief_header_id,l_old_resource_type,l_old_resource_id
3292: from csf_debrief_headers cdh,jtf_task_assignments jta,csf_debrief_lines cdl

Line 3317: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;

3313: l_task_assignment_id number := null;
3314: l_debrief_header_id number := null;
3315: begin
3316: x_return_status := FND_API.G_RET_STS_SUCCESS;
3317: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
3318: select debrief_header_id
3319: into l_debrief_header_id
3320: from csf_debrief_headers
3321: where task_assignment_id = l_task_assignment_id;

Line 3448: log('task_assignment_post_update','task_assignment_id: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id);

3444:
3445: l_assignee_role varchar2(100);
3446:
3447: begin
3448: log('task_assignment_post_update','task_assignment_id: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id);
3449: log('task_assignment_post_update','hook assignee role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role);
3450: open
3451: c_assignee_role(jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id);
3452: fetch c_assignee_role into l_assignee_role;

Line 3449: log('task_assignment_post_update','hook assignee role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role);

3445: l_assignee_role varchar2(100);
3446:
3447: begin
3448: log('task_assignment_post_update','task_assignment_id: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id);
3449: log('task_assignment_post_update','hook assignee role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role);
3450: open
3451: c_assignee_role(jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id);
3452: fetch c_assignee_role into l_assignee_role;
3453: close c_assignee_role;

Line 3451: c_assignee_role(jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id);

3447: begin
3448: log('task_assignment_post_update','task_assignment_id: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id);
3449: log('task_assignment_post_update','hook assignee role: '||jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role);
3450: open
3451: c_assignee_role(jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id);
3452: fetch c_assignee_role into l_assignee_role;
3453: close c_assignee_role;
3454: log('task_assignment_post_update','l_assignee_role: '||l_assignee_role);
3455: if nvl(l_assignee_role,'OWNER') = 'ASSIGNEE' then

Line 3457: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;

3453: close c_assignee_role;
3454: log('task_assignment_post_update','l_assignee_role: '||l_assignee_role);
3455: if nvl(l_assignee_role,'OWNER') = 'ASSIGNEE' then
3456: l_task_id :=
3457: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
3458: log('task_assignment_post_update','l_task_id: '||l_task_id);
3459: open c_task_type_rule;
3460: fetch c_task_type_rule into l_task_type_rule;
3461: log('task_assignment_post_update','l_task_type_rule: '||l_task_type_rule);

Line 3465: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;

3461: log('task_assignment_post_update','l_task_type_rule: '||l_task_type_rule);
3462: close c_task_type_rule;
3463: if l_task_type_rule = 'DISPATCH' then
3464: l_task_assignment_id :=
3465: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
3466: log('task_assignment_post_update','l_task_assignment_id: '||l_task_assignment_id);
3467: l_resource_type_code :=
3468: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
3469: log('task_assignment_post_update','l_resource_type_code: '||l_resource_type_code);

Line 3468: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;

3464: l_task_assignment_id :=
3465: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
3466: log('task_assignment_post_update','l_task_assignment_id: '||l_task_assignment_id);
3467: l_resource_type_code :=
3468: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
3469: log('task_assignment_post_update','l_resource_type_code: '||l_resource_type_code);
3470: l_resource_id :=
3471: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
3472: log('task_assignment_post_update','l_resource_id: '||l_resource_id);

Line 3471: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;

3467: l_resource_type_code :=
3468: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
3469: log('task_assignment_post_update','l_resource_type_code: '||l_resource_type_code);
3470: l_resource_id :=
3471: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
3472: log('task_assignment_post_update','l_resource_id: '||l_resource_id);
3473: l_assignment_status_id :=
3474: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignment_status_id;
3475: log('task_assignment_post_update','l_assignment_status_id: '||l_assignment_status_id);

Line 3474: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignment_status_id;

3470: l_resource_id :=
3471: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
3472: log('task_assignment_post_update','l_resource_id: '||l_resource_id);
3473: l_assignment_status_id :=
3474: JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignment_status_id;
3475: log('task_assignment_post_update','l_assignment_status_id: '||l_assignment_status_id);
3476:
3477: open c_working_flag;
3478: fetch c_working_flag into l_working_flag,l_travel_flag;