[Home] [Help]
218: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
219: , x_eam_request_tbl => l_out_eam_request_tbl
220: , x_return_status => x_return_status
221: , x_msg_count => x_msg_count
222: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')
223: , p_debug_filename => 'addexistwo.log'
224: , p_output_dir => l_output_dir
225: , p_commit => 'N'
226: , p_debug_file_mode => 'w'
1507: x_return_status := FND_API.G_RET_STS_ERROR;
1508: end if;
1509:
1510: -- set profile values to be used by PJM Views. Bug#4384541
1511: fnd_profile.put('MFG_ORGANIZATION_ID',p_organization_id );
1512:
1513: if p_project_number is not null and p_task_number is null then
1514: select count(*) into l_count
1515: from pjm_projects_v ppv,
1990: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
1991: , x_eam_request_tbl => l_out_eam_request_tbl
1992: , x_return_status => l_return_status
1993: , x_msg_count => l_msg_count
1994: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')
1995: , p_debug_filename => 'updatewoss.log'
1996: , p_output_dir =>l_output_dir
1997: , p_commit => 'N'
1998: , p_debug_file_mode => 'w'
2313: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
2314: , x_eam_request_tbl => l_out_eam_request_tbl
2315: , x_return_status => l_return_status
2316: , x_msg_count => l_msg_count
2317: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')
2318: , p_debug_filename => 'createwoss.log'
2319: , p_output_dir => l_output_dir
2320: , p_commit => 'N'
2321: , p_debug_file_mode => 'w'
2470: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
2471: , x_eam_request_tbl => l_out_eam_request_tbl
2472: , x_return_status => l_return_status
2473: , x_msg_count => l_msg_count
2474: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')
2475: , p_debug_filename => 'createrelss.log'
2476: , p_output_dir => l_output_dir
2477: , p_commit => 'N'
2478: , p_debug_file_mode => 'w'
2853: x_end_date := l_max_op_end_date;
2854: end if;
2855:
2856: --ER EAM_ACTUAL_WORK_COMPLETION_DATE_PREFERENCE Options(1 : Scheduled Completion Date 2:System Date)
2857: l_actual_comp_date_preference := nvl(fnd_profile.value('EAM_ACTUAL_WORK_COMPLETION_DATE_PREFERENCE'),'1');
2858:
2859: if(l_actual_comp_date_preference = '2') then
2860: x_start_date := sysdate - (x_end_date - x_start_date);
2861: x_end_date := sysdate;
3057: , x_return_status => l_return_status
3058: , x_msg_count => l_msg_count
3059: -- , x_error_msg_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.error_tbl_type
3060: , p_commit => FND_API.G_TRUE
3061: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')
3062: , p_debug_filename => 'adddepen.log'
3063: , p_output_dir => l_output_dir
3064: , p_debug_file_mode => 'W'
3065: );
3252: , x_return_status => l_return_status
3253: , x_msg_count => l_msg_count
3254: -- , x_error_msg_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.error_tbl_type
3255: , p_commit => p_commit
3256: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')
3257: , p_debug_filename => 'deldepen.log'
3258: , p_output_dir => l_output_dir
3259: , p_debug_file_mode => 'W'
3260: );
3520: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
3521: , x_eam_request_tbl => l_out_eam_request_tbl
3522: , x_return_status => x_return_status
3523: , x_msg_count => x_msg_count
3524: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')
3525: , p_debug_filename => 'deletecosthier.log'
3526: , p_output_dir => l_output_dir
3527: , p_commit => p_commit
3528: , p_debug_file_mode => 'A'
3598: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
3599: , x_eam_request_tbl => l_out_eam_request_tbl
3600: , x_return_status => x_return_status
3601: , x_msg_count => x_msg_count
3602: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')
3603: , p_debug_filename =>'createcosthier.log'
3604: , p_output_dir => l_output_dir
3605: , p_commit => p_commit
3606: , p_debug_file_mode => 'A'