APPS.OKC_ROLE_SOURCE_PUB SQL Statements

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

Line: 17

    g_rscv_rec.last_updated_by       := p_rscv_rec.last_updated_by;

Line: 18

    g_rscv_rec.last_update_date      := p_rscv_rec.last_update_date;

Line: 19

    g_rscv_rec.last_update_login     := p_rscv_rec.last_update_login;

Line: 32

    g_csov_rec.last_updated_by       := p_csov_rec.last_updated_by;

Line: 33

    g_csov_rec.last_update_date      := p_csov_rec.last_update_date;

Line: 34

    g_csov_rec.last_update_login     := p_csov_rec.last_update_login;

Line: 49

  select meaning
  from fnd_lookups
  where lookup_type = 'OKC_CONTACT_ROLE'
    and lookup_code = p_cro_code;

Line: 72

  select name
  from jtf_objects_vl
  where object_code = p_jtot_object_code;

Line: 97

  select START_DATE+0.5
  from okc_role_sources
  where RLE_CODE = p_rle_code AND p_rle_code is not null
  and nvl(end_date,sysdate)>=sysdate
  UNION ALL
  select START_DATE+0.5
  from okc_role_sources
  where p_rle_code is null
  and nvl(end_date,sysdate)>=sysdate;

Line: 113

  select count(start_date)
    from okc_role_sources
   where RLE_CODE = p_rle_code AND p_rle_code is not null
     and d1 between start_date and NVL(end_date,d1)
  group by RLE_CODE, buy_or_sell
  having count(start_date) > 1
  UNION ALL
  select count(start_date)
    from okc_role_sources
   where p_rle_code is null
     and d1 between start_date and NVL(end_date,d1)
  group by RLE_CODE, buy_or_sell
  having count(start_date) > 1;

Line: 167

  select START_DATE+0.5
    from okc_contact_sources
   where RLE_CODE = p_rle_code AND p_rle_code is not null
     and nvl(end_date,sysdate)>=sysdate
  UNION ALL
  select START_DATE+0.5
    from okc_contact_sources
   where p_rle_code is null
     and nvl(end_date,sysdate)>=sysdate;

Line: 183

select count(start_date)
    from okc_contact_sources
   where RLE_CODE = p_rle_code and p_rle_code is not null
     and d1 between start_date and NVL(end_date,d1)
   group by RLE_CODE, CRO_CODE, buy_or_sell
   having count(start_date) > 1
  UNION ALL
  select count(start_date)
    from okc_contact_sources
   where p_rle_code is null
     and d1 between start_date and NVL(end_date,d1)
   group by RLE_CODE, CRO_CODE, buy_or_sell
   having count(start_date) > 1;

Line: 360

procedure update_role_source(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_rscv_rec	IN	rscv_rec_type,
                              x_rscv_rec	OUT NOCOPY	rscv_rec_type) is
l_api_name                     CONSTANT VARCHAR2(30) := 'update_role_source';

Line: 394

  OKC_ROLE_SOURCE_PVT.update_role_source(p_api_version,
                              p_init_msg_list,
                              x_return_status,
                              x_msg_count,
                              x_msg_data,
                              g_rscv_rec,
                              x_rscv_rec);

Line: 442

end update_role_source;

Line: 453

procedure update_role_source(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_rscv_tbl	IN	rscv_tbl_type,
                              x_rscv_tbl	OUT NOCOPY	rscv_tbl_type) is
i NUMBER;

Line: 468

	    update_role_source(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_rscv_rec=>p_rscv_tbl(i),
                              x_rscv_rec=>x_rscv_tbl(i));

Line: 487

end update_role_source;

Line: 902

procedure update_contact_source(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_csov_rec	IN	csov_rec_type,
                              x_csov_rec	OUT NOCOPY	csov_rec_type) is
l_api_name                     CONSTANT VARCHAR2(30) := 'update_contact_source';

Line: 936

  OKC_ROLE_SOURCE_PVT.update_contact_source(p_api_version,
                              p_init_msg_list,
                              x_return_status,
                              x_msg_count,
                              x_msg_data,
                              g_csov_rec,
                              x_csov_rec);

Line: 984

end update_contact_source;

Line: 995

procedure update_contact_source(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_csov_tbl	IN	csov_tbl_type,
                              x_csov_tbl	OUT NOCOPY	csov_tbl_type) is
i NUMBER;

Line: 1010

	    update_contact_source(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_csov_rec=>p_csov_tbl(i),
                              x_csov_rec=>x_csov_tbl(i));

Line: 1029

end update_contact_source;