eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_RELEASE_PVT dependencies on OKC_K_HEADERS_V

Line 519: FUNCTION get_rec_chrv (p_id IN OKC_K_HEADERS_V.ID%TYPE,

515: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
516: RETURN(x_return_status);
517: END get_tasv_rec;
518: -------------------------------------------------------------------------------------------------
519: FUNCTION get_rec_chrv (p_id IN OKC_K_HEADERS_V.ID%TYPE,
520: x_chrv_rec OUT NOCOPY chrv_rec_type)
521: RETURN VARCHAR2 IS
522: CURSOR okc_chrv_pk_csr(p_id OKC_K_HEADERS_V.ID%TYPE) IS
523: SELECT ID,

Line 522: CURSOR okc_chrv_pk_csr(p_id OKC_K_HEADERS_V.ID%TYPE) IS

518: -------------------------------------------------------------------------------------------------
519: FUNCTION get_rec_chrv (p_id IN OKC_K_HEADERS_V.ID%TYPE,
520: x_chrv_rec OUT NOCOPY chrv_rec_type)
521: RETURN VARCHAR2 IS
522: CURSOR okc_chrv_pk_csr(p_id OKC_K_HEADERS_V.ID%TYPE) IS
523: SELECT ID,
524: OBJECT_VERSION_NUMBER,
525: SFWT_FLAG,
526: CHR_ID_RESPONSE,

Line 601: FROM okc_k_headers_v chrv

597: CREATION_DATE,
598: LAST_UPDATED_BY,
599: LAST_UPDATE_DATE,
600: LAST_UPDATE_LOGIN
601: FROM okc_k_headers_v chrv
602: WHERE chrv.id = p_id;
603: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
604: BEGIN
605: OPEN okc_chrv_pk_csr (p_id);

Line 1054: ln_new_chr_id OKC_K_HEADERS_V.ID%TYPE;

1050: x_new_khrv_rec OUT NOCOPY khrv_rec_type) IS
1051: l_api_name CONSTANT VARCHAR2(30) := 'LOCAL_COPY_CONTRACT';
1052: l_chrv_rec chrv_rec_type;
1053: l_khrv_rec khrv_rec_type;
1054: ln_new_chr_id OKC_K_HEADERS_V.ID%TYPE;
1055: ln_new_cle_id OKC_K_LINES_V.ID%TYPE;
1056: lt_klev_tbl_type klev_tbl_type;
1057: ltx_klev_tbl_type klev_tbl_type;
1058: i number := 0;

Line 7866: ln_old_chr_id OKC_K_HEADERS_V.ID%TYPE;

7862: IS
7863: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RELEASE_CONTRACT';
7864: l_chrv_rec chrv_rec_type;
7865: l_khrv_rec khrv_rec_type;
7866: ln_old_chr_id OKC_K_HEADERS_V.ID%TYPE;
7867: ln_new_chr_id OKC_K_HEADERS_V.ID%TYPE;
7868: lv_old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
7869: lv_old_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
7870: ld_old_end_date OKC_K_HEADERS_V.END_DATE%TYPE;

Line 7867: ln_new_chr_id OKC_K_HEADERS_V.ID%TYPE;

7863: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RELEASE_CONTRACT';
7864: l_chrv_rec chrv_rec_type;
7865: l_khrv_rec khrv_rec_type;
7866: ln_old_chr_id OKC_K_HEADERS_V.ID%TYPE;
7867: ln_new_chr_id OKC_K_HEADERS_V.ID%TYPE;
7868: lv_old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
7869: lv_old_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
7870: ld_old_end_date OKC_K_HEADERS_V.END_DATE%TYPE;
7871: ln_old_authoring_org_id OKC_K_HEADERS_V.AUTHORING_ORG_ID%TYPE;

Line 7868: lv_old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;

7864: l_chrv_rec chrv_rec_type;
7865: l_khrv_rec khrv_rec_type;
7866: ln_old_chr_id OKC_K_HEADERS_V.ID%TYPE;
7867: ln_new_chr_id OKC_K_HEADERS_V.ID%TYPE;
7868: lv_old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
7869: lv_old_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
7870: ld_old_end_date OKC_K_HEADERS_V.END_DATE%TYPE;
7871: ln_old_authoring_org_id OKC_K_HEADERS_V.AUTHORING_ORG_ID%TYPE;
7872: lt_top_line_tbl g_top_line_tbl;

Line 7869: lv_old_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

7865: l_khrv_rec khrv_rec_type;
7866: ln_old_chr_id OKC_K_HEADERS_V.ID%TYPE;
7867: ln_new_chr_id OKC_K_HEADERS_V.ID%TYPE;
7868: lv_old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
7869: lv_old_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
7870: ld_old_end_date OKC_K_HEADERS_V.END_DATE%TYPE;
7871: ln_old_authoring_org_id OKC_K_HEADERS_V.AUTHORING_ORG_ID%TYPE;
7872: lt_top_line_tbl g_top_line_tbl;
7873: lt_asset_num_tbl g_asset_num_tbl;

Line 7870: ld_old_end_date OKC_K_HEADERS_V.END_DATE%TYPE;

7866: ln_old_chr_id OKC_K_HEADERS_V.ID%TYPE;
7867: ln_new_chr_id OKC_K_HEADERS_V.ID%TYPE;
7868: lv_old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
7869: lv_old_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
7870: ld_old_end_date OKC_K_HEADERS_V.END_DATE%TYPE;
7871: ln_old_authoring_org_id OKC_K_HEADERS_V.AUTHORING_ORG_ID%TYPE;
7872: lt_top_line_tbl g_top_line_tbl;
7873: lt_asset_num_tbl g_asset_num_tbl;
7874: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

Line 7871: ln_old_authoring_org_id OKC_K_HEADERS_V.AUTHORING_ORG_ID%TYPE;

7867: ln_new_chr_id OKC_K_HEADERS_V.ID%TYPE;
7868: lv_old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
7869: lv_old_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
7870: ld_old_end_date OKC_K_HEADERS_V.END_DATE%TYPE;
7871: ln_old_authoring_org_id OKC_K_HEADERS_V.AUTHORING_ORG_ID%TYPE;
7872: lt_top_line_tbl g_top_line_tbl;
7873: lt_asset_num_tbl g_asset_num_tbl;
7874: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
7875:

Line 8013: p_token1_value => 'OKC_K_HEADERS_V.ID');

8009: IF c_fetch_header_line_id%NOTFOUND THEN
8010: OKL_API.set_message(p_app_name => G_APP_NAME,
8011: p_msg_name => G_NO_MATCHING_RECORD,
8012: p_token1 => G_COL_NAME_TOKEN,
8013: p_token1_value => 'OKC_K_HEADERS_V.ID');
8014:
8015: RAISE OKL_API.G_EXCEPTION_ERROR;
8016: END IF;
8017: FETCH c_fetch_header_line_id INTO ln_old_chr_id,

Line 8545: p_token1_value => 'OKC_K_HEADERS_V.ID');

8541: IF get_orig_sys_code%NOTFOUND THEN
8542: OKL_API.set_message(p_app_name => G_APP_NAME,
8543: p_msg_name => G_NO_MATCHING_RECORD,
8544: p_token1 => G_COL_NAME_TOKEN,
8545: p_token1_value => 'OKC_K_HEADERS_V.ID');
8546: RAISE OKL_API.G_EXCEPTION_ERROR;
8547: END IF;
8548: CLOSE get_orig_sys_code;
8549: IF ln_orig_system_source_code = 'OKL_RELEASE' THEN