APPS.OKL_SETUPPQYVALUES_PVT dependencies on OKL_PDT_QUALITYS_V

Line 72: -- PROCEDURE default_parent_dates for: OKL_PDT_QUALITYS_V

68: END get_rec;
69:
70:
71: ---------------------------------------------------------------------------
72: -- PROCEDURE default_parent_dates for: OKL_PDT_QUALITYS_V
73: ---------------------------------------------------------------------------
74:
75: PROCEDURE default_parent_dates(
76: p_qvev_rec IN qvev_rec_type,

Line 84: FROM Okl_pdt_qualitys_V pqy

80: ) IS
81: CURSOR okl_pqyv_pk_csr (p_pqy_id IN NUMBER) IS
82: SELECT FROM_DATE,
83: TO_DATE
84: FROM Okl_pdt_qualitys_V pqy
85: WHERE pqy.id = p_pqy_id;
86: l_okl_pqyv_pk okl_pqyv_pk_csr%ROWTYPE;
87: l_pqyv_rec pqyv_rec_type;
88: BEGIN

Line 134: FROM okl_pdt_qualitys_v pqyv

130: p_from_date DATE,
131: p_to_date DATE
132: ) IS
133: SELECT '1'
134: FROM okl_pdt_qualitys_v pqyv
135: WHERE pqyv.ID = p_pqy_id
136: AND ((pqyv.FROM_DATE > p_from_date OR
137: p_from_date > NVL(pqyv.TO_DATE,p_from_date))
138: OR

Line 589: -- PROCEDURE determine_action for: Okl_pdt_Qualitys_v

585: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
586: END check_updates;
587:
588: ---------------------------------------------------------------------------
589: -- PROCEDURE determine_action for: Okl_pdt_Qualitys_v
590: -- This function helps in determining the various checks to be performed
591: -- for the new/updated record.
592: ---------------------------------------------------------------------------
593: FUNCTION determine_action (