DECLARE
lc_return_status_gi VARCHAR2 (15);
lc_return_message_gi VARCHAR2 (4000);
l_debug_mode VARCHAR2 (200) := 'N';
l_debug_level NUMBER := 0;
l_failed_row_id_list VARCHAR2 (200);
x_errorcode NUMBER;
l_init_msg_list VARCHAR2 (200) := fnd_api.g_false;
l_ext_attr_data_table pa_project_pub.pa_ext_attr_table_type;
g_api_version_number CONSTANT NUMBER := 1.0;
g_commit CONSTANT VARCHAR2 (1) := 'T';
x_msg_count NUMBER;
x_msg_data VARCHAR2 (2000);
x_return_status VARCHAR2 (2000);
BEGIN
pa_project_pub.init_project;
fnd_msg_pub.initialize;
l_ext_attr_data_table (1).proj_element_id := NULL;
l_ext_attr_data_table (1).attr_group_id :=;
l_ext_attr_data_table (1).row_identifier :=;
l_ext_attr_data_table (1).attr_int_name := '';
l_ext_attr_data_table (1).attr_disp_value := '';
pa_user_attr_pub.process_user_attrs_data
(p_api_version => g_api_version_number,
p_object_name => 'PA_PROJECTS',
p_ext_attr_data_table => l_ext_attr_data_table,
p_project_id => :PROJECT_ID,
p_structure_type => 'WORKPLAN',
p_debug_mode => l_debug_mode,
p_debug_level => l_debug_level,
p_init_msg_list => l_init_msg_list,
p_log_errors => 'Y',
p_write_to_concurrent_log => 'Y',
p_commit => g_commit,
x_failed_row_id_list => l_failed_row_id_list,
x_return_status => x_return_status,
x_errorcode => x_errorcode,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
DBMS_OUTPUT.put_line (x_return_status);
DBMS_OUTPUT.put_line (x_msg_data);
END;
lc_return_status_gi VARCHAR2 (15);
lc_return_message_gi VARCHAR2 (4000);
l_debug_mode VARCHAR2 (200) := 'N';
l_debug_level NUMBER := 0;
l_failed_row_id_list VARCHAR2 (200);
x_errorcode NUMBER;
l_init_msg_list VARCHAR2 (200) := fnd_api.g_false;
l_ext_attr_data_table pa_project_pub.pa_ext_attr_table_type;
g_api_version_number CONSTANT NUMBER := 1.0;
g_commit CONSTANT VARCHAR2 (1) := 'T';
x_msg_count NUMBER;
x_msg_data VARCHAR2 (2000);
x_return_status VARCHAR2 (2000);
BEGIN
pa_project_pub.init_project;
fnd_msg_pub.initialize;
l_ext_attr_data_table (1).proj_element_id := NULL;
l_ext_attr_data_table (1).attr_group_id :=
l_ext_attr_data_table (1).row_identifier :=
l_ext_attr_data_table (1).attr_int_name := '
l_ext_attr_data_table (1).attr_disp_value := '
pa_user_attr_pub.process_user_attrs_data
(p_api_version => g_api_version_number,
p_object_name => 'PA_PROJECTS',
p_ext_attr_data_table => l_ext_attr_data_table,
p_project_id => :PROJECT_ID,
p_structure_type => 'WORKPLAN',
p_debug_mode => l_debug_mode,
p_debug_level => l_debug_level,
p_init_msg_list => l_init_msg_list,
p_log_errors => 'Y',
p_write_to_concurrent_log => 'Y',
p_commit => g_commit,
x_failed_row_id_list => l_failed_row_id_list,
x_return_status => x_return_status,
x_errorcode => x_errorcode,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
DBMS_OUTPUT.put_line (x_return_status);
DBMS_OUTPUT.put_line (x_msg_data);
END;
No comments:
Post a Comment