APPS.OKS_BTL_PRINT_PREVIEW_PVT dependencies on OKS_BTN_PR

Line 639: CURSOR oks_btn_pr_pk_csr (p_id IN NUMBER) IS

635: p_btl_pr_rec IN btl_pr_rec_type,
636: p_db_btl_pr_rec IN btl_pr_rec_type
637: ) RETURN VARCHAR2 IS
638: item_not_found_error EXCEPTION;
639: CURSOR oks_btn_pr_pk_csr (p_id IN NUMBER) IS
640: SELECT 'x'
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;

Line 641: FROM Oks_Btn_Pr

637: ) RETURN VARCHAR2 IS
638: item_not_found_error EXCEPTION;
639: CURSOR oks_btn_pr_pk_csr (p_id IN NUMBER) IS
640: SELECT 'x'
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

Line 642: WHERE oks_btn_pr.id = p_id;

638: item_not_found_error EXCEPTION;
639: CURSOR oks_btn_pr_pk_csr (p_id IN NUMBER) IS
640: SELECT 'x'
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'

Line 643: l_oks_btn_pr_pk oks_btn_pr_pk_csr%ROWTYPE;

639: CURSOR oks_btn_pr_pk_csr (p_id IN NUMBER) IS
640: SELECT 'x'
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

Line 677: OPEN oks_btn_pr_pk_csr (p_btl_pr_rec.BTN_ID);

673: IF ((p_btl_pr_rec.BTN_ID IS NOT NULL)
674: AND
675: (p_btl_pr_rec.BTN_ID <> p_db_btl_pr_rec.BTN_ID))
676: THEN
677: OPEN oks_btn_pr_pk_csr (p_btl_pr_rec.BTN_ID);
678: FETCH oks_btn_pr_pk_csr INTO l_oks_btn_pr_pk;
679: l_row_notfound := oks_btn_pr_pk_csr%NOTFOUND;
680: CLOSE oks_btn_pr_pk_csr;
681: IF (l_row_notfound) THEN

Line 678: FETCH oks_btn_pr_pk_csr INTO l_oks_btn_pr_pk;

674: AND
675: (p_btl_pr_rec.BTN_ID <> p_db_btl_pr_rec.BTN_ID))
676: THEN
677: OPEN oks_btn_pr_pk_csr (p_btl_pr_rec.BTN_ID);
678: FETCH oks_btn_pr_pk_csr INTO l_oks_btn_pr_pk;
679: l_row_notfound := oks_btn_pr_pk_csr%NOTFOUND;
680: CLOSE oks_btn_pr_pk_csr;
681: IF (l_row_notfound) THEN
682: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BTN_ID');

Line 679: l_row_notfound := oks_btn_pr_pk_csr%NOTFOUND;

675: (p_btl_pr_rec.BTN_ID <> p_db_btl_pr_rec.BTN_ID))
676: THEN
677: OPEN oks_btn_pr_pk_csr (p_btl_pr_rec.BTN_ID);
678: FETCH oks_btn_pr_pk_csr INTO l_oks_btn_pr_pk;
679: l_row_notfound := oks_btn_pr_pk_csr%NOTFOUND;
680: CLOSE oks_btn_pr_pk_csr;
681: IF (l_row_notfound) THEN
682: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BTN_ID');
683: RAISE item_not_found_error;

Line 680: CLOSE oks_btn_pr_pk_csr;

676: THEN
677: OPEN oks_btn_pr_pk_csr (p_btl_pr_rec.BTN_ID);
678: FETCH oks_btn_pr_pk_csr INTO l_oks_btn_pr_pk;
679: l_row_notfound := oks_btn_pr_pk_csr%NOTFOUND;
680: CLOSE oks_btn_pr_pk_csr;
681: IF (l_row_notfound) THEN
682: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BTN_ID');
683: RAISE item_not_found_error;
684: END IF;