Pa Create Project

---- Create the project declare l_orig_project_id number: = 6; l_prj_num varchar2 (240): = 'cxytest001'; l_start_date Date: = sysdate; l_completion_date Date: = sysdate + 5; -- l_organization_name varchar2 (240): = 'hangxin system engineering organization '; Organization number: = 393; -- x_project_id number; x_new_project_number varchar2 (240); x_return_status varchar2 (240 ); x_msg_count number; x_msg_data varchar2 (30000); begin fnd_global.apps_initialize (user_id => 23806, resp_id => 52998, resp_appl_id => 275); mo_global.init ('M '); values (p_api_version => 1.0, p_init_msg_list => null, p_commit => 'F', p_validate_only => 'F', p_validation_level => null, p_calling_module => null, p_debug_mode => null, condition => null, condition => l_orig_project_id, p_project_name => l_prj_num, p_project_number => l_prj_num, p_description => null, p_project_type => null, condition => null, p_project_status_name => null, partition => partition, p_organization_name => l_organization_name, p_start_date => l_start_date, p_completion_date => l_completion_date, partition => null, condition => null, p_project_value => null, condition => null, p_team_template_id => null, p_team_template_name => null, p_country_code => null, p_country_name => null, p_region => null, p_city => null, p_customer_id => null, p_customer_name => null, p_agreement_currency => null, expiration => null, p_agreement_amount => null, expiration => null, p_agreement_org_name => null, response => null, response => null, p_priority_code => null, p_template_flag => null, p_security_level => null, response => null, p_ship_to_customer_id => null, p_bill_to_customer_name => null, condition => null, p_long_name => null, p_project_id => x_project_id, p_new_project_number => condition, x_return_status => x_return_status, x_msg_count => x_msg_count, x_msg_data => x_msg_data ); /* For I in 1 .. x_msg_count loop x_msg_data: = fnd_msg_pub.get; values ('x _ msg_data: '| x_msg_data); End loop; */dbms_output.put_line ('x _ project_id:' | x_project_id ); values ('x _ new_project_number: '| x_new_project_number); dbms_output.put_line ('x _ msg_data:' | x_msg_data); values ('x _ return_status: '| x_return_status ); dbms_output.put_line ('x _ msg_count: '| x_msg_count); end;

Pa Create Project