DBA Data[Home] [Help]

APPS.OKL_OKC_MIGRATION_A_PVT SQL Statements

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

Line: 48

    p_to.last_updated_by := p_from.last_updated_by;
Line: 49

    p_to.last_update_date := p_from.last_update_date;
Line: 50

    p_to.last_update_login := p_from.last_update_login;
Line: 91

    p_to.last_updated_by := p_from.last_updated_by;
Line: 92

    p_to.last_update_date := p_from.last_update_date;
Line: 93

    p_to.last_update_login := p_from.last_update_login;
Line: 132

    p_to.last_updated_by := p_from.last_updated_by;
Line: 133

    p_to.last_update_date := p_from.last_update_date;
Line: 134

    p_to.last_update_login := p_from.last_update_login;
Line: 171

    p_to.last_updated_by := p_from.last_updated_by;
Line: 172

    p_to.last_update_date := p_from.last_update_date;
Line: 173

    p_to.last_update_login := p_from.last_update_login;
Line: 207

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_catv_rec                     IN  catv_rec_type,
    x_catv_rec                     OUT NOCOPY  catv_rec_type) IS

    l_catv_rec		   catv_rec_type;
Line: 298

END insert_row;
Line: 303

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_catv_rec                     IN  catv_rec_type,
    x_catv_rec                     OUT NOCOPY  catv_rec_type) IS

    l_catv_rec		   catv_rec_type;
Line: 316

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_K_ARTICLE';
Line: 344

    OKC_K_ARTICLE_PUB.update_k_article(
	 p_api_version		=> p_api_version,
	 p_init_msg_list	=> p_init_msg_list,
      x_return_status 	=> x_return_status,
      x_msg_count     	=> x_msg_count,
      x_msg_data      	=> x_msg_data,
      p_catv_rec		=> l_okc_catv_rec_in,
      x_catv_rec		=> l_okc_catv_rec_out);
Line: 394

END update_row;
Line: 399

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_catv_rec                     IN  catv_rec_type) IS

    l_catv_rec		   catv_rec_type;
Line: 411

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_K_ARTICLE';
Line: 439

    OKC_K_ARTICLE_PUB.delete_k_article(
	 p_api_version		=> p_api_version,
	 p_init_msg_list	=> p_init_msg_list,
      x_return_status 	=> x_return_status,
      x_msg_count     	=> x_msg_count,
      x_msg_data      	=> x_msg_data,
      p_catv_rec		=> l_okc_catv_rec_in);
Line: 485

END delete_row;
Line: 491

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rgpv_rec                     IN  rgpv_rec_type,
    x_rgpv_rec                     OUT NOCOPY  rgpv_rec_type) IS

    l_rgpv_rec		   rgpv_rec_type;
Line: 504

    l_api_name		CONSTANT VARCHAR2(30) := 'INSERT_ROW';
Line: 582

END insert_row;
Line: 586

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rgpv_rec                     IN  rgpv_rec_type,
    x_rgpv_rec                     OUT NOCOPY  rgpv_rec_type) IS

    l_rgpv_rec		   rgpv_rec_type;
Line: 599

    l_api_name		CONSTANT VARCHAR2(30) := 'UPDATE_ROW';
Line: 627

    OKC_RULE_PUB.update_rule_group(
	 p_api_version		=> p_api_version,
	 p_init_msg_list	=> p_init_msg_list,
      x_return_status 	=> x_return_status,
      x_msg_count     	=> x_msg_count,
      x_msg_data      	=> x_msg_data,
      p_rgpv_rec		=> l_okc_rgpv_rec_in,
      x_rgpv_rec		=> l_okc_rgpv_rec_out);
Line: 677

END update_row;
Line: 682

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rgpv_rec                     IN  rgpv_rec_type) IS

    l_rgpv_rec		   rgpv_rec_type;
Line: 694

    l_api_name		CONSTANT VARCHAR2(30) := 'DELETE_ROW';
Line: 722

    OKC_RULE_PUB.delete_rule_group(
	 p_api_version		=> p_api_version,
	 p_init_msg_list	=> p_init_msg_list,
      x_return_status 	=> x_return_status,
      x_msg_count     	=> x_msg_count,
      x_msg_data      	=> x_msg_data,
      p_rgpv_rec		=> l_okc_rgpv_rec_in);
Line: 768

END delete_row;
Line: 876

  FUNCTION Update_Allowed(p_chr_id IN NUMBER) RETURN VARCHAR2 Is
	l_sts_code	OKC_ASSENTS.STS_CODE%TYPE;
Line: 882

		SELECT sts_code, scs_code
		FROM OKC_K_HEADERS_B
		WHERE id = p_chr_id;
Line: 887

		SELECT upper(substr(allowed_yn,1,1))
		FROM okc_assents
		WHERE sts_code = l_sts_code
		AND scs_code = l_scs_code
		AND opn_code = 'UPDATE';
Line: 920

  END Update_Allowed;