APPS.OKL_SETUP_STRMS_TRANS_PVT 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: 36

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

Line: 77

  END insert_translations;

Line: 79

  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: 109

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

Line: 151

  END update_translations;

Line: 153

  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: 181

	OKL_SGN_TRANSLATIONS_PUB.delete_sgn_translations(p_api_version => l_api_version,
                                                     p_init_msg_list => p_init_msg_list,
                                                     x_return_status => l_return_status,
                                                     x_msg_count => x_msg_count,
                                                     x_msg_data => x_msg_data,
                                                     p_sgnv_tbl => p_sgnv_tbl);

Line: 220

  END delete_translations;