DBA Data[Home] [Help]

APPS.OKE_IMPORT_CONTRACT_PUB SQL Statements

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

Line: 12

  G_FORM_RECORD_DELETED 	CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
Line: 16

  G_RECORD_LOGICALLY_DELETED	CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
Line: 38

select 'x'
from hr_all_organization_units hr , mtl_parameters mp
where mp.organization_id = hr.organization_id
and mp.master_organization_id = mp.organization_id
and hr.organization_id = p_chr_rec.inv_organization_id;
Line: 45

select 'x'
from hr_operating_units
where organization_id = p_chr_rec.authoring_org_id;
Line: 152

select 'x'
FROM Okc_Statuses_B
WHERE okc_statuses_b.code  = p_cle_rec.sts_code;
Line: 332

  l_oke_chr_rec.last_updated_by   	:= p_chr_rec.last_updated_by;
Line: 333

  l_oke_chr_rec.last_update_login 	:= p_chr_rec.last_update_login;
Line: 334

  l_oke_chr_rec.last_update_date  	:= p_chr_rec.last_update_date;
Line: 354

    l_okc_chrv_rec.deleted_yn                     := p_chr_rec.deleted_yn;
Line: 413

    l_okc_chrv_rec.last_updated_by                := p_chr_rec.last_updated_by;
Line: 414

    l_okc_chrv_rec.last_update_date               := p_chr_rec.last_update_date;
Line: 415

    l_okc_chrv_rec.last_update_login              := p_chr_rec.last_update_login;
Line: 433

	l_okc_chrv_rec.deleted_yn  := 'N';
Line: 461

  UPDATE OKE_K_HEADERS SET CREATED_BY = p_chr_rec.created_by
  WHERE K_HEADER_ID = l_out_chr.k_header_id;
Line: 465

  UPDATE OKE_K_HEADERS SET CREATION_DATE = p_chr_rec.creation_date
  WHERE K_HEADER_ID = l_out_chr.k_header_id;
Line: 468

IF p_chr_rec.last_updated_by <> OKE_API.G_MISS_NUM AND p_chr_rec.last_updated_by IS NOT NULL THEN
  UPDATE OKE_K_HEADERS SET LAST_UPDATED_BY = p_chr_rec.last_updated_by
  WHERE K_HEADER_ID = l_out_chr.k_header_id;
Line: 472

IF p_chr_rec.last_update_login <> OKE_API.G_MISS_NUM AND p_chr_rec.last_update_login IS NOT NULL THEN
  UPDATE OKE_K_HEADERS SET LAST_UPDATE_LOGIN = p_chr_rec.last_update_login
  WHERE K_HEADER_ID = l_out_chr.k_header_id;
Line: 476

IF p_chr_rec.last_update_date <> OKE_API.G_MISS_DATE AND p_chr_rec.last_update_date IS NOT NULL THEN
  UPDATE OKE_K_HEADERS SET LAST_UPDATE_DATE = p_chr_rec.last_update_date
  WHERE K_HEADER_ID = l_out_chr.k_header_id;
Line: 548

  x_chr_rec.last_updated_by   		:= l_out_chr.last_updated_by;
Line: 549

  x_chr_rec.last_update_login 		:= l_out_chr.last_update_login;
Line: 550

  x_chr_rec.last_update_date  		:= l_out_chr.last_update_date;
Line: 574

    x_chr_rec.deleted_yn                     := l_out_chrv.deleted_yn;
Line: 633

    x_chr_rec.last_updated_by                := l_out_chrv.last_updated_by;
Line: 634

    x_chr_rec.last_update_date               := l_out_chrv.last_update_date;
Line: 635

    x_chr_rec.last_update_login              := l_out_chrv.last_update_login;
Line: 699

    SELECT inv_organization_id
    FROM OKC_K_HEADERS_B
    WHERE ID = p_chr;
Line: 819

  l_oke_cle_rec.last_updated_by		:= p_cle_rec.last_updated_by;
Line: 820

  l_oke_cle_rec.last_update_login	:= p_cle_rec.last_update_login;
Line: 821

  l_oke_cle_rec.last_update_date      	:= p_cle_rec.last_update_date;
Line: 879

    l_okc_clev_rec.last_updated_by              := p_cle_rec.last_updated_by;
Line: 880

    l_okc_clev_rec.last_update_date             := p_cle_rec.last_update_date;
Line: 884

    l_okc_clev_rec.last_update_login            := p_cle_rec.last_update_login;
Line: 1009

  x_cle_rec.last_updated_by		:= l_out_cle.last_updated_by;
Line: 1010

  x_cle_rec.last_update_login		:= l_out_cle.last_update_login;
Line: 1011

  x_cle_rec.last_update_date      	:= l_out_cle.last_update_date;
Line: 1071

    x_cle_rec.last_updated_by              	:= l_out_clev.last_updated_by;
Line: 1072

    x_cle_rec.last_update_date             	:= l_out_clev.last_update_date;
Line: 1076

    x_cle_rec.last_update_login            	:= l_out_clev.last_update_login;
Line: 1098

	l_cimv_rec.LAST_UPDATED_BY := x_cle_rec.LAST_UPDATED_BY;
Line: 1099

	l_cimv_rec.LAST_UPDATE_DATE := x_cle_rec.LAST_UPDATE_DATE;
Line: 1100

	l_cimv_rec.LAST_UPDATE_LOGIN := x_cle_rec.LAST_UPDATE_LOGIN;
Line: 1174

    SELECT INV_ORGANIZATION_ID
    FROM OKC_K_HEADERS_B
    WHERE ID = p_del_rec.k_header_id;
Line: 1179

    SELECT BUY_OR_SELL
    FROM OKC_K_HEADERS_B
    WHERE ID = p_del_rec.k_header_id;
Line: 1471

    IF	l_del_rec.LAST_UPDATED_BY = OKE_API.G_MISS_NUM THEN
	l_del_rec.LAST_UPDATED_BY := NULL;
Line: 1475

    IF	l_del_rec.LAST_UPDATE_LOGIN = OKE_API.G_MISS_NUM THEN
	l_del_rec.LAST_UPDATE_LOGIN := NULL;
Line: 1479

    IF	l_del_rec.LAST_UPDATE_DATE = OKE_API.G_MISS_DATE THEN
	l_del_rec.LAST_UPDATE_DATE := NULL;
Line: 1726

select 'x'
from oke_k_headers
where k_header_id = p_bill_rec.k_header_id;
Line: 1731

select 'x'
from oke_billing_methods_vl
where billing_method_code = p_bill_rec.billing_method_code;
Line: 1838

	insert into oke_k_billing_methods
	(
	k_header_id,
	billing_method_code,
	creation_date,
	created_by,
	last_update_date,
	last_updated_by,
	last_update_login,
	default_flag,
	attribute_category,
	attribute1,
	attribute2,
	attribute3,
	attribute4,
	attribute5,
	attribute6,
	attribute7,
	attribute8,
	attribute9,
	attribute10,
	attribute11,
	attribute12,
	attribute13,
	attribute14,
	attribute15
	)
	values
	(
	p_bill_tbl(i).k_header_id,
	p_bill_tbl(i).billing_method_code,
	sysdate,
	fnd_global.user_id,
	sysdate,
	fnd_global.user_id,
	fnd_global.login_id,
	p_bill_tbl(i).default_flag,
	p_bill_tbl(i).attribute_category,
	p_bill_tbl(i).attribute1,
	p_bill_tbl(i).attribute2,
	p_bill_tbl(i).attribute3,
	p_bill_tbl(i).attribute4,
	p_bill_tbl(i).attribute5,
	p_bill_tbl(i).attribute6,
	p_bill_tbl(i).attribute7,
	p_bill_tbl(i).attribute8,
	p_bill_tbl(i).attribute9,
	p_bill_tbl(i).attribute10,
	p_bill_tbl(i).attribute11,
	p_bill_tbl(i).attribute12,
	p_bill_tbl(i).attribute13,
	p_bill_tbl(i).attribute14,
	p_bill_tbl(i).attribute15
);
Line: 1949

    select 'x' from oke_k_lines_v
    where billing_method_code = p_code
    and header_id = p_header_id;
Line: 2006

	  delete from oke_k_billing_methods
	  where k_header_id = p_bill_tbl(i).k_header_id
	  and billing_method_code = p_bill_tbl(i).billing_method_code;
Line: 2100

    l_cimv_tbl_in(1).LAST_UPDATED_BY := p_cimv_rec.LAST_UPDATED_BY;
Line: 2101

    l_cimv_tbl_in(1).LAST_UPDATE_DATE := p_cimv_rec.LAST_UPDATE_DATE;
Line: 2102

    l_cimv_tbl_in(1).LAST_UPDATE_LOGIN := p_cimv_rec.LAST_UPDATE_LOGIN;
Line: 2137

    x_cimv_rec.LAST_UPDATED_BY := l_cimv_tbl_out(1).LAST_UPDATED_BY;
Line: 2138

    x_cimv_rec.LAST_UPDATE_DATE := l_cimv_tbl_out(1).LAST_UPDATE_DATE;
Line: 2139

    x_cimv_rec.LAST_UPDATE_LOGIN := l_cimv_tbl_out(1).LAST_UPDATE_LOGIN;