APPS.OKL_VERSION_PVT dependencies on OKL_K_LINES

Line 512: p_token1_value => 'OKL_K_LINES_H');

508: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
509: OKL_API.set_message(p_app_name => G_APP_NAME,
510: p_msg_name => G_CREATE_VER_ERROR,
511: p_token1 => G_COL_NAME_TOKEN,
512: p_token1_value => 'OKL_K_LINES_H');
513: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
514: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
515: OKL_API.set_message(p_app_name => G_APP_NAME,
516: p_msg_name => G_CREATE_VER_ERROR,

Line 518: p_token1_value => 'OKL_K_LINES_H');

514: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
515: OKL_API.set_message(p_app_name => G_APP_NAME,
516: p_msg_name => G_CREATE_VER_ERROR,
517: p_token1 => G_COL_NAME_TOKEN,
518: p_token1_value => 'OKL_K_LINES_H');
519: RAISE OKL_API.G_EXCEPTION_ERROR;
520: END IF;
521: --version Supplier Invoice Details
522: x_return_status:=OKL_SID_PVT.Create_Version(p_chr_id,

Line 764: p_token1_value => 'OKL_K_LINES_H');

760: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
761: OKL_API.set_message(p_app_name => G_APP_NAME,
762: p_msg_name => G_RESTORE_VER_ERROR,
763: p_token1 => G_COL_NAME_TOKEN,
764: p_token1_value => 'OKL_K_LINES_H');
765: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
766: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
767: OKL_API.set_message(p_app_name => G_APP_NAME,
768: p_msg_name => G_RESTORE_VER_ERROR,

Line 770: p_token1_value => 'OKL_K_LINES_H');

766: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
767: OKL_API.set_message(p_app_name => G_APP_NAME,
768: p_msg_name => G_RESTORE_VER_ERROR,
769: p_token1 => G_COL_NAME_TOKEN,
770: p_token1_value => 'OKL_K_LINES_H');
771: RAISE OKL_API.G_EXCEPTION_ERROR;
772: END IF;
773: x_return_status:=OKL_SID_PVT.Restore_Version(p_chr_id,
774: p_major_version);

Line 924: DELETE FROM OKL_K_LINES

920: -- Deleting the Header
921: DELETE FROM OKL_K_HEADERS
922: WHERE id = p_chr_id;
923: -- Deleting the Lines
924: DELETE FROM OKL_K_LINES
925: WHERE id IN (SELECT id
926: FROM OKC_K_LINES_B
927: WHERE dnz_chr_id = p_chr_id);
928: -- Deleting the supplier Invoice Details

Line 1007: DELETE FROM OKL_K_LINES_H

1003: (p_called_from = 'RESTORE_VERSION'
1004: AND (major_version >= l_major_version OR
1005: major_version = -1)));
1006: -- Deleting the Lines
1007: DELETE FROM OKL_K_LINES_H
1008: WHERE ID in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id)
1009: AND ((MAJOR_VERSION = -1
1010: AND p_called_from = 'ERASE_SAVED_VERSION') OR
1011: (p_called_from = 'RESTORE_VERSION'