APPS.OKE_IMPORT_CONTRACT_PUB dependencies on OKE_K_HEADERS

Line 461: UPDATE OKE_K_HEADERS SET CREATED_BY = p_chr_rec.created_by

457:
458: -- Added code to update who columns. neccessary for security to work after import process.
459:
460: IF p_chr_rec.created_by <> OKE_API.G_MISS_NUM AND p_chr_rec.created_by IS NOT NULL THEN
461: UPDATE OKE_K_HEADERS SET CREATED_BY = p_chr_rec.created_by
462: WHERE K_HEADER_ID = l_out_chr.k_header_id;
463: END IF;
464: IF p_chr_rec.creation_date <> OKE_API.G_MISS_DATE AND p_chr_rec.creation_date IS NOT NULL THEN
465: UPDATE OKE_K_HEADERS SET CREATION_DATE = p_chr_rec.creation_date

Line 465: UPDATE OKE_K_HEADERS SET CREATION_DATE = p_chr_rec.creation_date

461: UPDATE OKE_K_HEADERS SET CREATED_BY = p_chr_rec.created_by
462: WHERE K_HEADER_ID = l_out_chr.k_header_id;
463: END IF;
464: IF p_chr_rec.creation_date <> OKE_API.G_MISS_DATE AND p_chr_rec.creation_date IS NOT NULL THEN
465: UPDATE OKE_K_HEADERS SET CREATION_DATE = p_chr_rec.creation_date
466: WHERE K_HEADER_ID = l_out_chr.k_header_id;
467: END IF;
468: IF p_chr_rec.last_updated_by <> OKE_API.G_MISS_NUM AND p_chr_rec.last_updated_by IS NOT NULL THEN
469: UPDATE OKE_K_HEADERS SET LAST_UPDATED_BY = p_chr_rec.last_updated_by

Line 469: UPDATE OKE_K_HEADERS SET LAST_UPDATED_BY = p_chr_rec.last_updated_by

465: UPDATE OKE_K_HEADERS SET CREATION_DATE = p_chr_rec.creation_date
466: WHERE K_HEADER_ID = l_out_chr.k_header_id;
467: END IF;
468: IF p_chr_rec.last_updated_by <> OKE_API.G_MISS_NUM AND p_chr_rec.last_updated_by IS NOT NULL THEN
469: UPDATE OKE_K_HEADERS SET LAST_UPDATED_BY = p_chr_rec.last_updated_by
470: WHERE K_HEADER_ID = l_out_chr.k_header_id;
471: END IF;
472: IF p_chr_rec.last_update_login <> OKE_API.G_MISS_NUM AND p_chr_rec.last_update_login IS NOT NULL THEN
473: UPDATE OKE_K_HEADERS SET LAST_UPDATE_LOGIN = p_chr_rec.last_update_login

Line 473: UPDATE OKE_K_HEADERS SET LAST_UPDATE_LOGIN = p_chr_rec.last_update_login

469: UPDATE OKE_K_HEADERS SET LAST_UPDATED_BY = p_chr_rec.last_updated_by
470: WHERE K_HEADER_ID = l_out_chr.k_header_id;
471: END IF;
472: IF p_chr_rec.last_update_login <> OKE_API.G_MISS_NUM AND p_chr_rec.last_update_login IS NOT NULL THEN
473: UPDATE OKE_K_HEADERS SET LAST_UPDATE_LOGIN = p_chr_rec.last_update_login
474: WHERE K_HEADER_ID = l_out_chr.k_header_id;
475: END IF;
476: IF p_chr_rec.last_update_date <> OKE_API.G_MISS_DATE AND p_chr_rec.last_update_date IS NOT NULL THEN
477: UPDATE OKE_K_HEADERS SET LAST_UPDATE_DATE = p_chr_rec.last_update_date

Line 477: UPDATE OKE_K_HEADERS SET LAST_UPDATE_DATE = p_chr_rec.last_update_date

473: UPDATE OKE_K_HEADERS SET LAST_UPDATE_LOGIN = p_chr_rec.last_update_login
474: WHERE K_HEADER_ID = l_out_chr.k_header_id;
475: END IF;
476: IF p_chr_rec.last_update_date <> OKE_API.G_MISS_DATE AND p_chr_rec.last_update_date IS NOT NULL THEN
477: UPDATE OKE_K_HEADERS SET LAST_UPDATE_DATE = p_chr_rec.last_update_date
478: WHERE K_HEADER_ID = l_out_chr.k_header_id;
479: END IF;
480:
481: -- Added code to update who columns. neccessary for security to work after import process.

Line 1727: from oke_k_headers

1723: l_default_flag VARCHAR2(1) := '?';
1724:
1725: CURSOR c_k_header_id IS
1726: select 'x'
1727: from oke_k_headers
1728: where k_header_id = p_bill_rec.k_header_id;
1729:
1730: CURSOR c_billing_method_code IS
1731: select 'x'