APPS.OKL_SETUPTQYVALUES_PVT dependencies on OKL_PTQ_VALUES_V

Line 4: -- PROCEDURE get_rec for: OKL_PTQ_VALUES_V

1: PACKAGE BODY Okl_Setuptqyvalues_Pvt AS
2: /* $Header: OKLRSEVB.pls 115.17 2003/07/23 18:32:17 sgorantl noship $ */
3: ---------------------------------------------------------------------------
4: -- PROCEDURE get_rec for: OKL_PTQ_VALUES_V
5: ---------------------------------------------------------------------------
6: PROCEDURE get_rec (
7: p_ptvv_rec IN ptvv_rec_type,
8: x_no_data_found OUT NOCOPY BOOLEAN,

Line 26: FROM Okl_Ptq_Values_V

22: CREATION_DATE,
23: LAST_UPDATED_BY,
24: LAST_UPDATE_DATE,
25: LAST_UPDATE_LOGIN
26: FROM Okl_Ptq_Values_V
27: WHERE okl_ptq_values_v.id = p_id;
28: l_okl_ptvv_pk okl_ptvv_pk_csr%ROWTYPE;
29: l_ptvv_rec ptvv_rec_type;
30: BEGIN

Line 27: WHERE okl_ptq_values_v.id = p_id;

23: LAST_UPDATED_BY,
24: LAST_UPDATE_DATE,
25: LAST_UPDATE_LOGIN
26: FROM Okl_Ptq_Values_V
27: WHERE okl_ptq_values_v.id = p_id;
28: l_okl_ptvv_pk okl_ptvv_pk_csr%ROWTYPE;
29: l_ptvv_rec ptvv_rec_type;
30: BEGIN
31: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 71: -- PROCEDURE default_parent_dates for: OKL_PTQ_VALUES_V

67: END get_rec;
68:
69:
70: ---------------------------------------------------------------------------
71: -- PROCEDURE default_parent_dates for: OKL_PTQ_VALUES_V
72: ---------------------------------------------------------------------------
73:
74: PROCEDURE default_parent_dates(
75: p_ptvv_rec IN ptvv_rec_type,

Line 117: -- PROCEDURE validate_Pkeys for: OKL_PTQ_VALUES_V

113:
114: END default_parent_dates;
115:
116: ---------------------------------------------------------------------------
117: -- PROCEDURE validate_Pkeys for: OKL_PTQ_VALUES_V
118: -- To verify whether the dates are valid for PRODUCT TEMPLATE QUALITY
119: ---------------------------------------------------------------------------
120:
121: PROCEDURE Check_Constraints (

Line 148: CURSOR c1(p_value okl_ptq_values_v.value%TYPE,

144: WHERE pmvv.ptv_id = p_ptv_id
145: AND (pmvv.FROM_DATE < p_from_date OR
146: NVL(pmvv.TO_DATE, pmvv.FROM_DATE) > p_to_date);
147:
148: CURSOR c1(p_value okl_ptq_values_v.value%TYPE,
149: p_ptq_id okl_ptq_values_v.ptq_id%TYPE
150: ) IS
151: SELECT '1'
152: FROM okl_ptq_values_v

Line 149: p_ptq_id okl_ptq_values_v.ptq_id%TYPE

145: AND (pmvv.FROM_DATE < p_from_date OR
146: NVL(pmvv.TO_DATE, pmvv.FROM_DATE) > p_to_date);
147:
148: CURSOR c1(p_value okl_ptq_values_v.value%TYPE,
149: p_ptq_id okl_ptq_values_v.ptq_id%TYPE
150: ) IS
151: SELECT '1'
152: FROM okl_ptq_values_v
153: WHERE value = p_value

Line 152: FROM okl_ptq_values_v

148: CURSOR c1(p_value okl_ptq_values_v.value%TYPE,
149: p_ptq_id okl_ptq_values_v.ptq_id%TYPE
150: ) IS
151: SELECT '1'
152: FROM okl_ptq_values_v
153: WHERE value = p_value
154: AND ptq_id = p_ptq_id;
155: -- AND id <> NVL(p_ptvv_rec.id,-9999);
156:

Line 744: -- PROCEDURE update_PQYVALUES for: OKL_PTQ_VALUES_V

740:
741: END insert_tqyvalues;
742:
743: ---------------------------------------------------------------------------
744: -- PROCEDURE update_PQYVALUES for: OKL_PTQ_VALUES_V
745: ---------------------------------------------------------------------------
746: PROCEDURE update_tqyvalues(p_api_version IN NUMBER,
747: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
748: x_return_status OUT NOCOPY VARCHAR2,