Tuesday, October 10, 2017

Project UDA - Single Record Script

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;

No comments: