APPS.OKS_BTL_PRINT_PREVIEW_PVT dependencies on OKS_BCL_PR

Line 645: CURSOR oks_bcl_pr_pk_csr (p_id IN NUMBER) IS

641: FROM Oks_Btn_Pr
642: WHERE oks_btn_pr.id = p_id;
643: l_oks_btn_pr_pk oks_btn_pr_pk_csr%ROWTYPE;
644:
645: CURSOR oks_bcl_pr_pk_csr (p_id IN NUMBER) IS
646: SELECT 'x'
647: FROM Oks_Bcl_Pr
648: WHERE oks_bcl_pr.id = p_id;
649: l_oks_bcl_pr_pk oks_bcl_pr_pk_csr%ROWTYPE;

Line 647: FROM Oks_Bcl_Pr

643: l_oks_btn_pr_pk oks_btn_pr_pk_csr%ROWTYPE;
644:
645: CURSOR oks_bcl_pr_pk_csr (p_id IN NUMBER) IS
646: SELECT 'x'
647: FROM Oks_Bcl_Pr
648: WHERE oks_bcl_pr.id = p_id;
649: l_oks_bcl_pr_pk oks_bcl_pr_pk_csr%ROWTYPE;
650:
651: CURSOR oks_bsl_pr_pk_csr (p_id IN NUMBER) IS

Line 648: WHERE oks_bcl_pr.id = p_id;

644:
645: CURSOR oks_bcl_pr_pk_csr (p_id IN NUMBER) IS
646: SELECT 'x'
647: FROM Oks_Bcl_Pr
648: WHERE oks_bcl_pr.id = p_id;
649: l_oks_bcl_pr_pk oks_bcl_pr_pk_csr%ROWTYPE;
650:
651: CURSOR oks_bsl_pr_pk_csr (p_id IN NUMBER) IS
652: SELECT 'x'

Line 649: l_oks_bcl_pr_pk oks_bcl_pr_pk_csr%ROWTYPE;

645: CURSOR oks_bcl_pr_pk_csr (p_id IN NUMBER) IS
646: SELECT 'x'
647: FROM Oks_Bcl_Pr
648: WHERE oks_bcl_pr.id = p_id;
649: l_oks_bcl_pr_pk oks_bcl_pr_pk_csr%ROWTYPE;
650:
651: CURSOR oks_bsl_pr_pk_csr (p_id IN NUMBER) IS
652: SELECT 'x'
653: FROM Oks_Bsl_Pr

Line 664: OPEN oks_bcl_pr_pk_csr (p_btl_pr_rec.BCL_ID);

660: IF ((p_btl_pr_rec.BCL_ID IS NOT NULL)
661: AND
662: (p_btl_pr_rec.BCL_ID <> p_db_btl_pr_rec.BCL_ID))
663: THEN
664: OPEN oks_bcl_pr_pk_csr (p_btl_pr_rec.BCL_ID);
665: FETCH oks_bcl_pr_pk_csr INTO l_oks_bcl_pr_pk;
666: l_row_notfound := oks_bcl_pr_pk_csr%NOTFOUND;
667: CLOSE oks_bcl_pr_pk_csr;
668: IF (l_row_notfound) THEN

Line 665: FETCH oks_bcl_pr_pk_csr INTO l_oks_bcl_pr_pk;

661: AND
662: (p_btl_pr_rec.BCL_ID <> p_db_btl_pr_rec.BCL_ID))
663: THEN
664: OPEN oks_bcl_pr_pk_csr (p_btl_pr_rec.BCL_ID);
665: FETCH oks_bcl_pr_pk_csr INTO l_oks_bcl_pr_pk;
666: l_row_notfound := oks_bcl_pr_pk_csr%NOTFOUND;
667: CLOSE oks_bcl_pr_pk_csr;
668: IF (l_row_notfound) THEN
669: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BCL_ID');

Line 666: l_row_notfound := oks_bcl_pr_pk_csr%NOTFOUND;

662: (p_btl_pr_rec.BCL_ID <> p_db_btl_pr_rec.BCL_ID))
663: THEN
664: OPEN oks_bcl_pr_pk_csr (p_btl_pr_rec.BCL_ID);
665: FETCH oks_bcl_pr_pk_csr INTO l_oks_bcl_pr_pk;
666: l_row_notfound := oks_bcl_pr_pk_csr%NOTFOUND;
667: CLOSE oks_bcl_pr_pk_csr;
668: IF (l_row_notfound) THEN
669: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BCL_ID');
670: RAISE item_not_found_error;

Line 667: CLOSE oks_bcl_pr_pk_csr;

663: THEN
664: OPEN oks_bcl_pr_pk_csr (p_btl_pr_rec.BCL_ID);
665: FETCH oks_bcl_pr_pk_csr INTO l_oks_bcl_pr_pk;
666: l_row_notfound := oks_bcl_pr_pk_csr%NOTFOUND;
667: CLOSE oks_bcl_pr_pk_csr;
668: IF (l_row_notfound) THEN
669: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BCL_ID');
670: RAISE item_not_found_error;
671: END IF;