APPS.OKL_COPY_ASSET_PVT dependencies on OKC_K_HEADERS_B

Line 110: FROM OKC_K_HEADERS_B

106: -----------------------------------------------------------------------------------------------------------
107: --Added by dpsingh for LE uptake
108: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS
109: SELECT contract_number
110: FROM OKC_K_HEADERS_B
111: WHERE id = p_ctr_id1;
112:
113: CURSOR get_chr_id_csr(p_kle_id1 NUMBER) IS
114: SELECT DNZ_CHR_ID

Line 2558: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

2554: l_talv_rec talv_rec_type;
2555:
2556: --Added by dpsingh for LE uptake
2557: l_chr_id NUMBER;
2558: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
2559: l_legal_entity_id NUMBER;
2560:
2561: BEGIN
2562: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2780: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

2776: AND cle.lse_id = lse.id
2777: AND lse.lty_code = G_FA_LINE_LTY_CODE;
2778:
2779: --Added by dpsingh for LE uptake
2780: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
2781: l_legal_entity_id NUMBER;
2782:
2783: BEGIN
2784: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3119: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

3115: AND cle.lse_id = lse.id
3116: AND lse.lty_code = G_FA_LINE_LTY_CODE;
3117:
3118: --Added by dpsingh for LE uptake
3119: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
3120: l_legal_entity_id NUMBER;
3121:
3122: BEGIN
3123: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3311: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

3307: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TXL_ITM_INSTS';
3308:
3309: --Added by dpsingh for LE uptake
3310: l_chr_id NUMBER;
3311: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
3312: l_legal_entity_id NUMBER;
3313:
3314: BEGIN
3315: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3517: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

3513: AND cle.lse_id = lse.id
3514: AND lse.lty_code = G_INST_LINE_LTY_CODE
3515: AND cle.dnz_chr_id = p_dnz_chr_id);
3516: --Added by dpsingh for LE uptake
3517: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
3518: l_legal_entity_id NUMBER;
3519:
3520: BEGIN
3521: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 5771: p_to_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

5767: PROCEDURE copy_service_line_link(
5768: x_return_status OUT NOCOPY VARCHAR2,
5769: x_msg_count OUT NOCOPY NUMBER,
5770: x_msg_data OUT NOCOPY VARCHAR2,
5771: p_to_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
5772: p_from_line_id IN OKC_K_LINES_B.ID%TYPE
5773: ) IS
5774: CURSOR line_style_csr(p_top_line_id OKC_K_LINES_B.ID%TYPE) IS
5775: SELECT lse.lty_code,

Line 5847: l_from_chr_id OKC_K_HEADERS_B.ID%TYPE;

5843: AND dnz_chr_id = p_chr_id;
5844:
5845: copy_service_failed EXCEPTION;
5846: l_lty_code OKC_LINE_STYLES_B.LTY_CODE%TYPE;
5847: l_from_chr_id OKC_K_HEADERS_B.ID%TYPE;
5848: l_h_link_exist VARCHAR2(1) := 'N';
5849: l_to_line_id OKC_K_LINES_V.ID%TYPE;
5850:
5851: l_crjv_rec OKC_K_REL_OBJS_PUB.crjv_rec_type;

Line 5997: ln_old_chr_id OKC_K_HEADERS_B.ID%TYPE;

5993: lsx_cle_id_tbl klev_tbl_type;
5994: j NUMBER := 0;
5995: k NUMBER := 0;
5996: m NUMBER := 0;
5997: ln_old_chr_id OKC_K_HEADERS_B.ID%TYPE;
5998:
5999: CURSOR c_get_lty_code(p_top_line_id OKC_K_LINES_B.ID%TYPE) IS
6000:
6001: SELECT lse.lty_code,

Line 6052: FROM okc_k_headers_b

6048: -- Get contract context
6049: CURSOR h_context_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
6050: SELECT authoring_org_id,
6051: inv_organization_id
6052: FROM okc_k_headers_b
6053: WHERE id = p_chr_id;
6054:
6055: l_auth_org_id OKC_K_HEADERS_V.AUTHORING_ORG_ID%TYPE;
6056: l_inv_org_id OKC_K_HEADERS_V.INV_ORGANIZATION_ID%TYPE;