DBA Data[Home] [Help]

APPS.OKC_CONTRACT_PARTY_PUB SQL Statements

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

Line: 14

    g_ctcv_rec.last_updated_by       := p_ctcv_rec.last_updated_by;
Line: 15

    g_ctcv_rec.last_update_date      := p_ctcv_rec.last_update_date;
Line: 16

    g_ctcv_rec.last_update_login     := p_ctcv_rec.last_update_login;
Line: 25

    g_cplv_rec.last_updated_by       := p_cplv_rec.last_updated_by;
Line: 26

    g_cplv_rec.last_update_date      := p_cplv_rec.last_update_date;
Line: 27

    g_cplv_rec.last_update_login     := p_cplv_rec.last_update_login;
Line: 174

procedure update_contact(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_ctcv_rec	IN	ctcv_rec_type,
                              x_ctcv_rec	OUT NOCOPY	ctcv_rec_type) is
l_api_name                     CONSTANT VARCHAR2(30) := 'update_contact';
Line: 208

  OKC_CONTRACT_PARTY_PVT.update_contact(p_api_version,
                              p_init_msg_list,
                              x_return_status,
                              x_msg_count,
                              x_msg_data,
                              g_ctcv_rec,
                              x_ctcv_rec);
Line: 256

end update_contact;
Line: 266

procedure update_contact(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_ctcv_tbl	IN	ctcv_tbl_type,
                              x_ctcv_tbl	OUT NOCOPY	ctcv_tbl_type) is
i NUMBER;
Line: 281

	    update_contact(p_api_version=>p_api_version,
                              p_init_msg_list=>OKC_API.G_FALSE,
                              x_return_status=>l_return_status,
                              x_msg_count=>x_msg_count,
                              x_msg_data=>x_msg_data,
                              p_ctcv_rec=>p_ctcv_tbl(i),
                              x_ctcv_rec=>x_ctcv_tbl(i));
Line: 300

end update_contact;
Line: 310

procedure delete_contact(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_ctcv_rec	IN	ctcv_rec_type) is
l_api_name                     CONSTANT VARCHAR2(30) := 'delete_contact';
Line: 343

  OKC_CONTRACT_PARTY_PVT.delete_contact(p_api_version,
                              p_init_msg_list,
                              x_return_status,
                              x_msg_count,
                              x_msg_data,
                              g_ctcv_rec);
Line: 389

end delete_contact;
Line: 399

procedure delete_contact(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_ctcv_tbl	IN	ctcv_tbl_type) is
i NUMBER;
Line: 413

	    delete_contact(p_api_version=>p_api_version,
                              p_init_msg_list=>OKC_API.G_FALSE,
                              x_return_status=>l_return_status,
                              x_msg_count=>x_msg_count,
                              x_msg_data=>x_msg_data,
                              p_ctcv_rec=>p_ctcv_tbl(i));
Line: 431

end delete_contact;
Line: 839

procedure update_k_party_role(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_cplv_rec	IN	cplv_rec_type,
                              x_cplv_rec	OUT NOCOPY	cplv_rec_type) is
l_api_name                     CONSTANT VARCHAR2(30) := 'update_k_party_role';
Line: 873

  OKC_CONTRACT_PARTY_PVT.update_k_party_role(p_api_version,
                              p_init_msg_list,
                              x_return_status,
                              x_msg_count,
                              x_msg_data,
                              g_cplv_rec,
                              x_cplv_rec);
Line: 921

end update_k_party_role;
Line: 931

procedure update_k_party_role(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_cplv_tbl	IN	cplv_tbl_type,
                              x_cplv_tbl	OUT NOCOPY	cplv_tbl_type) is
i NUMBER;
Line: 946

	    update_k_party_role(p_api_version=>p_api_version,
                              p_init_msg_list=>OKC_API.G_FALSE,
                              x_return_status=>l_return_status,
                              x_msg_count=>x_msg_count,
                              x_msg_data=>x_msg_data,
                              p_cplv_rec=>p_cplv_tbl(i),
                              x_cplv_rec=>x_cplv_tbl(i));
Line: 965

end update_k_party_role;
Line: 975

procedure delete_k_party_role(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_cplv_rec	IN	cplv_rec_type) is
l_api_name                     CONSTANT VARCHAR2(30) := 'delete_k_party_role';
Line: 1008

  OKC_CONTRACT_PARTY_PVT.delete_k_party_role(p_api_version,
                              p_init_msg_list,
                              x_return_status,
                              x_msg_count,
                              x_msg_data,
                              g_cplv_rec);
Line: 1054

end delete_k_party_role;
Line: 1064

procedure delete_k_party_role(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_cplv_tbl	IN	cplv_tbl_type) is
i NUMBER;
Line: 1078

	    delete_k_party_role(p_api_version=>p_api_version,
                              p_init_msg_list=>OKC_API.G_FALSE,
                              x_return_status=>l_return_status,
                              x_msg_count=>x_msg_count,
                              x_msg_data=>x_msg_data,
                              p_cplv_rec=>p_cplv_tbl(i));
Line: 1096

end delete_k_party_role;