APPS.CSF_DEBRIEF_PVT dependencies on CSF_DEBRIEF_PUB

Line 3358: l_debrief_header csf_debrief_pub.debrief_rec_type;

3354: l_task_id number;
3355: l_task_type_rule varchar2(60);
3356: l_any_working_task varchar2(1) := 'N';
3357:
3358: l_debrief_header csf_debrief_pub.debrief_rec_type;
3359: l_debrief_line csf_debrief_pub.debrief_line_tbl_type;
3360:
3361: cursor c_header_id(p_task_assignment_id number) is
3362: select debrief_header_id

Line 3359: l_debrief_line csf_debrief_pub.debrief_line_tbl_type;

3355: l_task_type_rule varchar2(60);
3356: l_any_working_task varchar2(1) := 'N';
3357:
3358: l_debrief_header csf_debrief_pub.debrief_rec_type;
3359: l_debrief_line csf_debrief_pub.debrief_line_tbl_type;
3360:
3361: cursor c_header_id(p_task_assignment_id number) is
3362: select debrief_header_id
3363: from csf_debrief_headers

Line 3533: and csf_debrief_pub.g_auto_debrief then

3529:
3530: log('task_assignment_post_update','profile CSF_DEFAULT_LABOR_DEBRIEF_DATETIME'||
3531: fnd_profile.value('CSF_DEFAULT_LABOR_DEBRIEF_DATETIME'));
3532: if fnd_profile.value('CSF_DEFAULT_LABOR_DEBRIEF_DATETIME') = 'STATUS'
3533: and csf_debrief_pub.g_auto_debrief then
3534: open c_travel_exists(l_task_assignment_id);
3535: fetch c_travel_exists into l_travel_exists;
3536: log('task_assignment_post_update','l_travel_exists: '||l_travel_exists);
3537: close c_travel_exists;

Line 3637: log('task_assignment_post_update','calling csf_debrief_pub.create_debrief');

3633: log('task_assignment_post_update','l_debrief_header_id: '||l_debrief_header_id);
3634: if l_debrief_header_id is null then
3635: l_debrief_header.task_assignment_id := l_task_assignment_id;
3636: l_debrief_header.debrief_date := sysdate;
3637: log('task_assignment_post_update','calling csf_debrief_pub.create_debrief');
3638: csf_debrief_pub.create_debrief_with_dff_vals(
3639: p_api_version_number => 1.0,
3640: p_debrief_rec => l_debrief_header,
3641: p_debrief_line_tbl => l_debrief_line,

Line 3638: csf_debrief_pub.create_debrief_with_dff_vals(

3634: if l_debrief_header_id is null then
3635: l_debrief_header.task_assignment_id := l_task_assignment_id;
3636: l_debrief_header.debrief_date := sysdate;
3637: log('task_assignment_post_update','calling csf_debrief_pub.create_debrief');
3638: csf_debrief_pub.create_debrief_with_dff_vals(
3639: p_api_version_number => 1.0,
3640: p_debrief_rec => l_debrief_header,
3641: p_debrief_line_tbl => l_debrief_line,
3642: x_debrief_header_id => l_debrief_header_id,

Line 3648: log('task_assignment_post_update','Calling csf_debrief_pub.create_debrief_lines');

3644: x_msg_count => l_msg_count,
3645: x_msg_data => l_msg_data);
3646: log('task_assignment_post_update','l_return_status: '||l_return_status);
3647: else
3648: log('task_assignment_post_update','Calling csf_debrief_pub.create_debrief_lines');
3649: csf_debrief_pub.create_debrief_lines(
3650: p_api_version_number => 1.0,
3651: p_debrief_line_tbl => l_debrief_line,
3652: p_debrief_header_id => l_debrief_header_id,

Line 3649: csf_debrief_pub.create_debrief_lines(

3645: x_msg_data => l_msg_data);
3646: log('task_assignment_post_update','l_return_status: '||l_return_status);
3647: else
3648: log('task_assignment_post_update','Calling csf_debrief_pub.create_debrief_lines');
3649: csf_debrief_pub.create_debrief_lines(
3650: p_api_version_number => 1.0,
3651: p_debrief_line_tbl => l_debrief_line,
3652: p_debrief_header_id => l_debrief_header_id,
3653: p_source_object_type_code => null,