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;
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
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'
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
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
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');
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;
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;