DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT dependencies on OKC_K_HEADERS_V

Line 16120: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE

16116: PROCEDURE version_contract(
16117: x_return_status OUT NOCOPY VARCHAR2,
16118: x_msg_count OUT NOCOPY NUMBER,
16119: x_msg_data OUT NOCOPY VARCHAR2,
16120: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE
16121: ) IS
16122:
16123: l_proc_name VARCHAR2(35) := 'VERSION_CONTRACT';
16124: l_cvmv_rec okl_okc_migration_pvt.cvmv_rec_type;

Line 16244: FROM OKC_K_HEADERS_V chr,

16240: --Bug# 5946411: ER
16241: CURSOR c_get_sts_code(p_chr_id NUMBER)
16242: IS
16243: SELECT st.ste_code
16244: FROM OKC_K_HEADERS_V chr,
16245: okc_statuses_b st
16246: WHERE chr.id = p_chr_id
16247: and st.code = chr.sts_code;
16248: lv_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;

Line 16248: lv_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;

16244: FROM OKC_K_HEADERS_V chr,
16245: okc_statuses_b st
16246: WHERE chr.id = p_chr_id
16247: and st.code = chr.sts_code;
16248: lv_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
16249: --Bug# 5946411: ER end
16250: /*
16251: -- mvasudev, 08/23/2004
16252: -- Added PROCEDURE to enable Business Event