DBA Data[Home] [Help]

APPS.OKC_CONTRACT_GROUP_PUB SQL Statements

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

Line: 14

    l_cgpv_rec.last_updated_by       := p_cgpv_rec1.last_updated_by;
Line: 15

    l_cgpv_rec.last_update_date      := p_cgpv_rec1.last_update_date;
Line: 17

    l_cgpv_rec.last_update_login     := p_cgpv_rec1.last_update_login;
Line: 76

    l_cgcv_rec.last_updated_by       := p_cgcv_rec1.last_updated_by;
Line: 77

    l_cgcv_rec.last_update_date      := p_cgcv_rec1.last_update_date;
Line: 78

    l_cgcv_rec.last_update_login     := p_cgcv_rec1.last_update_login;
Line: 138

  PROCEDURE update_ctr_group(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cgpv_rec                     IN cgpv_rec_type,
    x_cgpv_rec                     OUT NOCOPY cgpv_rec_type,
    p_cgcv_tbl                     IN cgcv_tbl_type,
    x_cgcv_tbl                     OUT NOCOPY cgcv_tbl_type) IS
  BEGIN
    okc_contract_group_pvt.update_ctr_group(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_cgpv_rec,
	    x_cgpv_rec,
	    p_cgcv_tbl,
	    x_cgcv_tbl);
Line: 159

  END update_ctr_group;
Line: 309

  PROCEDURE update_contract_group(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cgpv_rec                     IN cgpv_rec_type,
    x_cgpv_rec                     OUT NOCOPY cgpv_rec_type) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'update_contract_group';
Line: 340

    okc_contract_group_pvt.update_contract_group(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    l_cgpv_rec,
	    x_cgpv_rec);
Line: 388

  END update_contract_group;
Line: 390

  PROCEDURE update_contract_group(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cgpv_tbl                     IN cgpv_tbl_type,
    x_cgpv_tbl                     OUT NOCOPY cgpv_tbl_type) IS
    i				   NUMBER := 0;
Line: 405

        update_contract_group(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_cgpv_tbl(i),
	    x_cgpv_tbl(i));
Line: 436

  END update_contract_group;
Line: 438

  PROCEDURE delete_contract_group(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cgpv_rec                     IN cgpv_rec_type) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_contract_group';
Line: 467

    okc_contract_group_pvt.delete_contract_group(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_cgpv_rec);
Line: 513

  END delete_contract_group;
Line: 515

  PROCEDURE delete_contract_group(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cgpv_tbl                     IN cgpv_tbl_type) IS
    i				   NUMBER := 0;
Line: 529

        delete_contract_group(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_cgpv_tbl(i));
Line: 559

  END delete_contract_group;
Line: 876

  PROCEDURE update_contract_grpngs(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cgcv_rec                     IN cgcv_rec_type,
    x_cgcv_rec                     OUT NOCOPY cgcv_rec_type) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'update_contract_grpngs';
Line: 907

    okc_contract_group_pvt.update_contract_grpngs(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    l_cgcv_rec,
	    x_cgcv_rec);
Line: 955

  END update_contract_grpngs;
Line: 957

  PROCEDURE update_contract_grpngs(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cgcv_tbl                     IN cgcv_tbl_type,
    x_cgcv_tbl                     OUT NOCOPY cgcv_tbl_type) IS
    i				   NUMBER := 0;
Line: 972

        update_contract_grpngs(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_cgcv_tbl(i),
	    x_cgcv_tbl(i));
Line: 1003

  END update_contract_grpngs;
Line: 1005

  PROCEDURE delete_contract_grpngs(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cgcv_rec                     IN cgcv_rec_type) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_contract_grpngs';
Line: 1034

    okc_contract_group_pvt.delete_contract_grpngs(
	    p_api_version,
	    p_init_msg_list,
	    x_return_status,
	    x_msg_count,
	    x_msg_data,
	    l_cgcv_rec);
Line: 1080

  END delete_contract_grpngs;
Line: 1082

  PROCEDURE delete_contract_grpngs(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cgcv_tbl                     IN cgcv_tbl_type) IS
    i				   NUMBER := 0;
Line: 1096

        delete_contract_grpngs(
	    p_api_version,
	    p_init_msg_list,
	    l_return_status,
	    x_msg_count,
	    x_msg_data,
	    p_cgcv_tbl(i));
Line: 1126

  END delete_contract_grpngs;