APPS.OKS_BCL_PRINT_PREVIEW_PVT dependencies on OKS_BTN_PR

Line 660: CURSOR oks_btn_pr_pk_csr (p_id IN NUMBER) IS

656: FROM Okc_K_Lines_B
657: WHERE okc_k_lines_b.id = p_id;
658: l_okc_k_lines_b_pk okc_k_lines_b_pk_csr%ROWTYPE;
659:
660: CURSOR oks_btn_pr_pk_csr (p_id IN NUMBER) IS
661: SELECT 'x'
662: FROM Oks_Btn_Pr
663: WHERE oks_btn_pr.id = p_id;
664: l_oks_btn_pr_pk oks_btn_pr_pk_csr%ROWTYPE;

Line 662: FROM Oks_Btn_Pr

658: l_okc_k_lines_b_pk okc_k_lines_b_pk_csr%ROWTYPE;
659:
660: CURSOR oks_btn_pr_pk_csr (p_id IN NUMBER) IS
661: SELECT 'x'
662: FROM Oks_Btn_Pr
663: WHERE oks_btn_pr.id = p_id;
664: l_oks_btn_pr_pk oks_btn_pr_pk_csr%ROWTYPE;
665:
666: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 663: WHERE oks_btn_pr.id = p_id;

659:
660: CURSOR oks_btn_pr_pk_csr (p_id IN NUMBER) IS
661: SELECT 'x'
662: FROM Oks_Btn_Pr
663: WHERE oks_btn_pr.id = p_id;
664: l_oks_btn_pr_pk oks_btn_pr_pk_csr%ROWTYPE;
665:
666: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
667: l_row_notfound BOOLEAN := TRUE;

Line 664: l_oks_btn_pr_pk oks_btn_pr_pk_csr%ROWTYPE;

660: CURSOR oks_btn_pr_pk_csr (p_id IN NUMBER) IS
661: SELECT 'x'
662: FROM Oks_Btn_Pr
663: WHERE oks_btn_pr.id = p_id;
664: l_oks_btn_pr_pk oks_btn_pr_pk_csr%ROWTYPE;
665:
666: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
667: l_row_notfound BOOLEAN := TRUE;
668: BEGIN

Line 673: OPEN oks_btn_pr_pk_csr (p_bcl_pr_rec.BTN_ID);

669: IF ((p_bcl_pr_rec.BTN_ID IS NOT NULL)
670: AND
671: (p_bcl_pr_rec.BTN_ID <> p_db_bcl_pr_rec.BTN_ID))
672: THEN
673: OPEN oks_btn_pr_pk_csr (p_bcl_pr_rec.BTN_ID);
674: FETCH oks_btn_pr_pk_csr INTO l_oks_btn_pr_pk;
675: l_row_notfound := oks_btn_pr_pk_csr%NOTFOUND;
676: CLOSE oks_btn_pr_pk_csr;
677: IF (l_row_notfound) THEN

Line 674: FETCH oks_btn_pr_pk_csr INTO l_oks_btn_pr_pk;

670: AND
671: (p_bcl_pr_rec.BTN_ID <> p_db_bcl_pr_rec.BTN_ID))
672: THEN
673: OPEN oks_btn_pr_pk_csr (p_bcl_pr_rec.BTN_ID);
674: FETCH oks_btn_pr_pk_csr INTO l_oks_btn_pr_pk;
675: l_row_notfound := oks_btn_pr_pk_csr%NOTFOUND;
676: CLOSE oks_btn_pr_pk_csr;
677: IF (l_row_notfound) THEN
678: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BTN_ID');

Line 675: l_row_notfound := oks_btn_pr_pk_csr%NOTFOUND;

671: (p_bcl_pr_rec.BTN_ID <> p_db_bcl_pr_rec.BTN_ID))
672: THEN
673: OPEN oks_btn_pr_pk_csr (p_bcl_pr_rec.BTN_ID);
674: FETCH oks_btn_pr_pk_csr INTO l_oks_btn_pr_pk;
675: l_row_notfound := oks_btn_pr_pk_csr%NOTFOUND;
676: CLOSE oks_btn_pr_pk_csr;
677: IF (l_row_notfound) THEN
678: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BTN_ID');
679: RAISE item_not_found_error;

Line 676: CLOSE oks_btn_pr_pk_csr;

672: THEN
673: OPEN oks_btn_pr_pk_csr (p_bcl_pr_rec.BTN_ID);
674: FETCH oks_btn_pr_pk_csr INTO l_oks_btn_pr_pk;
675: l_row_notfound := oks_btn_pr_pk_csr%NOTFOUND;
676: CLOSE oks_btn_pr_pk_csr;
677: IF (l_row_notfound) THEN
678: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BTN_ID');
679: RAISE item_not_found_error;
680: END IF;