APPS.OKL_SETUP_STRMS_TRANS_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

  PROCEDURE insert_translations (p_api_version        IN     NUMBER
                                ,p_init_msg_list      IN     VARCHAR2
								,p_sgnv_tbl           IN     sgnv_tbl_type
        	                    ,x_sgnv_tbl           OUT    NOCOPY sgnv_tbl_type
                                ,x_return_status      OUT    NOCOPY VARCHAR2
                                ,x_msg_count          OUT    NOCOPY NUMBER
                                ,x_msg_data           OUT    NOCOPY VARCHAR2
  ) IS
	l_api_name VARCHAR2(20):= 'insert_translations';

Line: 32

    OKL_SETUP_STRMS_TRANS_PVT.insert_translations (p_api_version      => l_api_version
                                                  ,p_init_msg_list    => p_init_msg_list
                                                  ,p_sgnv_tbl         => p_sgnv_tbl
                                                  ,x_sgnv_tbl         => x_sgnv_tbl
                                                  ,x_return_status    => l_return_status
                                                  ,x_msg_count        => x_msg_count
                                                  ,x_msg_data         => x_msg_data);

Line: 75

  END insert_translations;

Line: 77

  PROCEDURE update_translations (p_api_version        IN     NUMBER
                                ,p_init_msg_list      IN     VARCHAR2
								,p_sgnv_tbl           IN     sgnv_tbl_type
        	                    ,x_sgnv_tbl           OUT    NOCOPY sgnv_tbl_type
                                ,x_return_status      OUT    NOCOPY VARCHAR2
                                ,x_msg_count          OUT    NOCOPY NUMBER
                                ,x_msg_data           OUT    NOCOPY VARCHAR2
  ) IS
	l_api_name VARCHAR2(20):= 'update_translations';

Line: 105

    OKL_SETUP_STRMS_TRANS_PVT.update_translations (p_api_version        => l_api_version
                                                  ,p_init_msg_list    => p_init_msg_list
                                                  ,p_sgnv_tbl         => p_sgnv_tbl
                                                  ,x_sgnv_tbl         => x_sgnv_tbl
                                                  ,x_return_status    => x_return_status
                                                  ,x_msg_count        => x_msg_count
                                                  ,x_msg_data         => x_msg_data);

Line: 154

  END update_translations;

Line: 156

  PROCEDURE delete_translations (p_api_version        IN     NUMBER
                                ,p_init_msg_list      IN     VARCHAR2
        	                    ,p_sgnv_tbl           IN     sgnv_tbl_type
                                ,x_return_status      OUT    NOCOPY VARCHAR2
                                ,x_msg_count          OUT    NOCOPY NUMBER
                                ,x_msg_data           OUT    NOCOPY VARCHAR2
  ) IS
	l_api_name VARCHAR2(20):= 'delete_translations';

Line: 183

    OKL_SETUP_STRMS_TRANS_PVT.delete_translations (p_api_version        => l_api_version
                                                  ,p_init_msg_list      => p_init_msg_list
                                                  ,p_sgnv_tbl           => p_sgnv_tbl
                                                  ,x_return_status      => x_return_status
                                                  ,x_msg_count          => x_msg_count
                                                  ,x_msg_data           => x_msg_data);

Line: 225

  END delete_translations;