APPS.OKL_VERSION_PVT dependencies on OKL_SUPP_INVOICE_DTLS_H

Line 529: p_token1_value => 'OKL_SUPP_INVOICE_DTLS_H');

525: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
526: OKL_API.set_message(p_app_name => G_APP_NAME,
527: p_msg_name => G_CREATE_VER_ERROR,
528: p_token1 => G_COL_NAME_TOKEN,
529: p_token1_value => 'OKL_SUPP_INVOICE_DTLS_H');
530: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
531: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
532: OKL_API.set_message(p_app_name => G_APP_NAME,
533: p_msg_name => G_CREATE_VER_ERROR,

Line 535: p_token1_value => 'OKL_SUPP_INVOICE_DTLS_H');

531: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
532: OKL_API.set_message(p_app_name => G_APP_NAME,
533: p_msg_name => G_CREATE_VER_ERROR,
534: p_token1 => G_COL_NAME_TOKEN,
535: p_token1_value => 'OKL_SUPP_INVOICE_DTLS_H');
536: RAISE OKL_API.G_EXCEPTION_ERROR;
537: END IF;
538:
539: --Version Party Payment Hdr, fmiao

Line 780: p_token1_value => 'OKL_SUPP_INVOICE_DTLS_H');

776: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
777: OKL_API.set_message(p_app_name => G_APP_NAME,
778: p_msg_name => G_RESTORE_VER_ERROR,
779: p_token1 => G_COL_NAME_TOKEN,
780: p_token1_value => 'OKL_SUPP_INVOICE_DTLS_H');
781: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
782: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
783: OKL_API.set_message(p_app_name => G_APP_NAME,
784: p_msg_name => G_RESTORE_VER_ERROR,

Line 786: p_token1_value => 'OKL_SUPP_INVOICE_DTLS_H');

782: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
783: OKL_API.set_message(p_app_name => G_APP_NAME,
784: p_msg_name => G_RESTORE_VER_ERROR,
785: p_token1 => G_COL_NAME_TOKEN,
786: p_token1_value => 'OKL_SUPP_INVOICE_DTLS_H');
787: RAISE OKL_API.G_EXCEPTION_ERROR;
788: END IF;
789: -------------
790: --version party payment hdr,fmiao

Line 929: DELETE FROM OKL_SUPP_INVOICE_DTLS_H

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
929: DELETE FROM OKL_SUPP_INVOICE_DTLS_H
930: WHERE cle_id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id);
931: -- Deleting the FA Version
932: DELETE FROM OKL_CONTRACT_ASSET_H
933: WHERE DNZ_CHR_ID = p_chr_id;

Line 1015: DELETE FROM OKL_SUPP_INVOICE_DTLS_H

1011: (p_called_from = 'RESTORE_VERSION'
1012: AND (major_version >= l_major_version OR
1013: major_version = -1)));
1014: -- Deleting the supplier Invoice Details
1015: DELETE FROM OKL_SUPP_INVOICE_DTLS_H
1016: WHERE cle_id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id)
1017: AND ((MAJOR_VERSION = -1
1018: AND p_called_from = 'ERASE_SAVED_VERSION') OR
1019: (p_called_from = 'RESTORE_VERSION'