APPS.OKS_DEFAULTS_PUB SQL Statements

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

Line: 18

   SELECT id, start_date, end_date
   FROM oks_k_defaults
   WHERE jtot_object_code = p_jtot_object_code
   AND segment_id1 = p_org_or_party_id;

Line: 96

    g_cdtv_rec.last_updated_by       := p_cdtv_rec.last_updated_by;

Line: 97

    g_cdtv_rec.last_update_date      := p_cdtv_rec.last_update_date;

Line: 109

procedure Insert_defaults(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_cdtv_rec	IN	cdtv_rec_type,
                              x_cdtv_rec	OUT NOCOPY	cdtv_rec_type) is

l_api_name                     CONSTANT VARCHAR2(30) := 'Insert_defaults';

Line: 159

  OKS_defaults_PVT.Insert_defaults(p_api_version,
                              p_init_msg_list,
                              x_return_status,
                              x_msg_count,
                              x_msg_data,
                              g_cdtv_rec,
                              x_cdtv_rec);

Line: 207

end Insert_defaults;

Line: 218

procedure Insert_defaults(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_cdtv_tbl	IN	cdtv_tbl_type,
                              x_cdtv_tbl	OUT NOCOPY	cdtv_tbl_type) is
i NUMBER;

Line: 233

	    Insert_defaults(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_cdtv_rec=>p_cdtv_tbl(i),
                              x_cdtv_rec=>x_cdtv_tbl(i));

Line: 252

end Insert_defaults;

Line: 254

procedure update_defaults(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_cdtv_rec	IN	cdtv_rec_type,
                              x_cdtv_rec	OUT NOCOPY	cdtv_rec_type) is

l_api_name                     CONSTANT VARCHAR2(30) := 'update_defaults';

Line: 303

  OKS_defaults_PVT.update_defaults(p_api_version,
                              p_init_msg_list,
                              x_return_status,
                              x_msg_count,
                              x_msg_data,
                              g_cdtv_rec,
                              x_cdtv_rec);

Line: 351

end update_defaults;

Line: 362

procedure update_defaults(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_cdtv_tbl	IN	cdtv_tbl_type,
                              x_cdtv_tbl	OUT NOCOPY	cdtv_tbl_type) is
i NUMBER;

Line: 377

	    update_defaults(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_cdtv_rec=>p_cdtv_tbl(i),
                              x_cdtv_rec=>x_cdtv_tbl(i));

Line: 396

end update_defaults;

Line: 407

procedure delete_defaults(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_cdtv_rec	IN	cdtv_rec_type) is
l_api_name                     CONSTANT VARCHAR2(30) := 'delete_defaults';

Line: 437

  OKS_defaults_PVT.delete_defaults(p_api_version,
                              p_init_msg_list,
                              x_return_status,
                              x_msg_count,
                              x_msg_data,
                              g_cdtv_rec);

Line: 483

end delete_defaults;

Line: 494

procedure delete_defaults(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_cdtv_tbl	IN	cdtv_tbl_type) is
i NUMBER;

Line: 508

	    delete_defaults(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_cdtv_rec=>p_cdtv_tbl(i));

Line: 526

end delete_defaults;