DBA Data[Home] [Help]

APPS.OKL_VERSION_PVT dependencies on OKL_K_HEADERS

Line 495: p_token1_value => 'OKL_K_HEADERS_H');

491: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
492: OKL_API.set_message(p_app_name => G_APP_NAME,
493: p_msg_name => G_CREATE_VER_ERROR,
494: p_token1 => G_COL_NAME_TOKEN,
495: p_token1_value => 'OKL_K_HEADERS_H');
496: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
497: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
498: OKL_API.set_message(p_app_name => G_APP_NAME,
499: p_msg_name => G_CREATE_VER_ERROR,

Line 501: p_token1_value => 'OKL_K_HEADERS_H');

497: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
498: OKL_API.set_message(p_app_name => G_APP_NAME,
499: p_msg_name => G_CREATE_VER_ERROR,
500: p_token1 => G_COL_NAME_TOKEN,
501: p_token1_value => 'OKL_K_HEADERS_H');
502: RAISE OKL_API.G_EXCEPTION_ERROR;
503: END IF;
504: --version contract lines
505: x_return_status:=OKL_KLE_PVT.Create_Version(p_chr_id,

Line 747: p_token1_value => 'OKL_K_HEADERS_H');

743: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
744: OKL_API.set_message(p_app_name => G_APP_NAME,
745: p_msg_name => G_RESTORE_VER_ERROR,
746: p_token1 => G_COL_NAME_TOKEN,
747: p_token1_value => 'OKL_K_HEADERS_H');
748: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
749: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
750: OKL_API.set_message(p_app_name => G_APP_NAME,
751: p_msg_name => G_RESTORE_VER_ERROR,

Line 753: p_token1_value => 'OKL_K_HEADERS_H');

749: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
750: OKL_API.set_message(p_app_name => G_APP_NAME,
751: p_msg_name => G_RESTORE_VER_ERROR,
752: p_token1 => G_COL_NAME_TOKEN,
753: p_token1_value => 'OKL_K_HEADERS_H');
754: RAISE OKL_API.G_EXCEPTION_ERROR;
755: END IF;
756: --version contract lines
757: x_return_status:=OKL_KLE_PVT.Restore_Version(p_chr_id,

Line 921: DELETE FROM OKL_K_HEADERS

917: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
918: RAISE OKL_API.G_EXCEPTION_ERROR;
919: END IF;
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

Line 999: DELETE FROM OKL_K_HEADERS_H

995: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
996: RAISE OKL_API.G_EXCEPTION_ERROR;
997: END IF;
998: -- Deleting the Header
999: DELETE FROM OKL_K_HEADERS_H
1000: WHERE id= p_chr_id
1001: AND ((MAJOR_VERSION = -1
1002: AND p_called_from = 'ERASE_SAVED_VERSION') OR
1003: (p_called_from = 'RESTORE_VERSION'