DBA Data[Home] [Help]

APPS.OKL_SPLIT_CONTRACT_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 1578: FROM OKL_TXL_CNTRCT_LNS

1574: AND representation_type = 'PRIMARY';
1575:
1576: CURSOR c_get_source_id(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1577: SELECT id
1578: FROM OKL_TXL_CNTRCT_LNS
1579: WHERE khr_id = p_khr_id;
1580:
1581: CURSOR c_get_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1582: SELECT cle.id top_line

Line 1699: p_source_table => 'OKL_TXL_CNTRCT_LNS');

1695: x_return_status => x_return_status,
1696: x_msg_count => x_msg_count,
1697: x_msg_data => x_msg_data,
1698: p_source_id => r_get_source_id.id,
1699: p_source_table => 'OKL_TXL_CNTRCT_LNS');
1700: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1701: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1702: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1703: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);

Line 4534: FROM OKL_TXL_CNTRCT_LNS

4530: WHERE b.khr_id = p_khr_id);
4531:
4532: CURSOR c_get_source_id(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4533: SELECT id
4534: FROM OKL_TXL_CNTRCT_LNS
4535: WHERE khr_id = p_khr_id;
4536:
4537: CURSOR c_org_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
4538: SELECT authoring_org_id

Line 5289: p_source_table => 'OKL_TXL_CNTRCT_LNS');

5285: x_return_status => x_return_status,
5286: x_msg_count => x_msg_count,
5287: x_msg_data => x_msg_data,
5288: p_source_id => r_get_source_id.id,
5289: p_source_table => 'OKL_TXL_CNTRCT_LNS');
5290: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5291: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
5292: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5293: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);

Line 5319: p_source_table => 'OKL_TXL_CNTRCT_LNS');

5315: x_return_status => x_return_status,
5316: x_msg_count => x_msg_count,
5317: x_msg_data => x_msg_data,
5318: p_source_id => r_get_source_id.id,
5319: p_source_table => 'OKL_TXL_CNTRCT_LNS');
5320: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5321: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
5322: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5323: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);