APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_PDT_PQY_VALS

Line 136: -- PROCEDURE delete_pdt_pqy_vals for: OKL_PDT_PQY_VALS

132:
133: END get_rec;
134:
135: ---------------------------------------------------------------------------
136: -- PROCEDURE delete_pdt_pqy_vals for: OKL_PDT_PQY_VALS
137: -- Private procedure called from delete_pqvalues.
138: ---------------------------------------------------------------------------
139:
140: PROCEDURE delete_pdt_pqy_vals(

Line 153: FROM okl_pdt_pqy_vals_v pqvv

149: l_del_pqvv_tbl OKL_PQY_VALUES_PUB.pqvv_tbl_type;
150:
151: CURSOR pqv_csr IS
152: SELECT pqvv.id
153: FROM okl_pdt_pqy_vals_v pqvv
154: WHERE pqvv.pdt_id = p_pdtv_rec.id;
155:
156: BEGIN
157:

Line 216: -- PROCEDURE delete_pdt_psy_vals for: OKL_PDT_PQY_VALS

212: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
213: END delete_pdt_pqy_vals;
214:
215: ---------------------------------------------------------------------------
216: -- PROCEDURE delete_pdt_psy_vals for: OKL_PDT_PQY_VALS
217: -- Private procedure called from delete_pqvalues.
218: ---------------------------------------------------------------------------
219:
220: PROCEDURE delete_pdt_psys(

Line 324: Okl_Pdt_Pqy_Vals_V pqv

320: p_to_date IN Okl_Products_V.TO_DATE%TYPE
321: ) IS
322: SELECT '1'
323: FROM Okl_Pqy_Values_V qve,
324: Okl_Pdt_Pqy_Vals_V pqv
325: WHERE pqv.PDT_ID = p_pdt_id
326: AND qve.ID = pqv.QVE_ID
327: AND ((qve.FROM_DATE > p_from_date OR
328: p_from_date > NVL(qve.TO_DATE,p_from_date)) OR

Line 609: okl_pdt_pqy_vals pqv

605: INTO l_pdt_ptl_changed
606: FROM okl_pqy_values_v qve,
607: okl_pdt_qualitys pqy,
608: okl_pdt_pqys_v pdq,
609: okl_pdt_pqy_vals pqv
610: WHERE qve.pqy_id = pqy.id
611: AND pqv.qve_id = qve.id
612: AND pqv.pdq_id = pdq.id
613: AND pdq.ptl_id = p_db_pdtv_rec.ptl_id

Line 1685: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,

1681: AND a.deal_type = c.deal_type
1682: AND a.id = p_pdt_id;
1683:
1684: /*
1685: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
1686: p_aes_id okl_products_v.aes_id%TYPE)
1687: IS
1688: SELECT DISTINCT C.deal_type
1689: FROM okl_products_v a,

Line 1702: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,

1698: select DEAL_TYPE from okl_product_parameters_v ppar
1699: where ppar.id = p_pdt_id;
1700:
1701:
1702: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
1703: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
1704: IS
1705: SELECT DISTINCT C.deal_type
1706: FROM okl_products_v a,

Line 1703: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)

1699: where ppar.id = p_pdt_id;
1700:
1701:
1702: cursor chk_deal_type(p_pdt_id okl_pdt_pqy_vals_v.pdt_id%TYPE,
1703: p_qve_id okl_pdt_pqy_vals_v.qve_id%TYPE)
1704: IS
1705: SELECT DISTINCT C.deal_type
1706: FROM okl_products_v a,
1707: okl_ae_tmpt_sets_v b,

Line 3360: CURSOR okl_pqvv_fk_csr (p_pdt_id IN Okl_Pdt_Pqy_Vals_V.pdt_id%TYPE) IS

3356: x_return_status OUT NOCOPY VARCHAR2,
3357: x_count OUT NOCOPY NUMBER,
3358: x_pqvv_tbl OUT NOCOPY pqvv_tbl_type
3359: ) IS
3360: CURSOR okl_pqvv_fk_csr (p_pdt_id IN Okl_Pdt_Pqy_Vals_V.pdt_id%TYPE) IS
3361: SELECT ID,
3362: PDQ_ID,
3363: QVE_ID,
3364: FROM_DATE,

Line 3366: FROM Okl_pdt_pqy_vals_V pqv

3362: PDQ_ID,
3363: QVE_ID,
3364: FROM_DATE,
3365: TO_DATE
3366: FROM Okl_pdt_pqy_vals_V pqv
3367: WHERE pqv.PDT_ID = p_pdt_id;
3368:
3369: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
3370: l_count NUMBER := 0;