APPS.OKL_SETUPPQYVALUES_PVT dependencies on OKL_PQY_VALUES_V

Line 5: -- PROCEDURE get_rec for: okl_pqy_values_v

1: PACKAGE BODY Okl_Setuppqyvalues_Pvt AS
2: /* $Header: OKLRSQVB.pls 115.22 2004/04/01 00:39:19 sgorantl noship $ */
3:
4: ---------------------------------------------------------------------------
5: -- PROCEDURE get_rec for: okl_pqy_values_v
6: ---------------------------------------------------------------------------
7: PROCEDURE get_rec (
8: p_qvev_rec IN qvev_rec_type,
9: x_no_data_found OUT NOCOPY BOOLEAN,

Line 27: FROM Okl_Pqy_Values_V

23: CREATION_DATE,
24: LAST_UPDATED_BY,
25: LAST_UPDATE_DATE,
26: LAST_UPDATE_LOGIN
27: FROM Okl_Pqy_Values_V
28: WHERE okl_pqy_values_v.id = p_id;
29: l_okl_qvev_pk okl_qvev_pk_csr%ROWTYPE;
30: l_qvev_rec qvev_rec_type;
31: BEGIN

Line 28: WHERE okl_pqy_values_v.id = p_id;

24: LAST_UPDATED_BY,
25: LAST_UPDATE_DATE,
26: LAST_UPDATE_LOGIN
27: FROM Okl_Pqy_Values_V
28: WHERE okl_pqy_values_v.id = p_id;
29: l_okl_qvev_pk okl_qvev_pk_csr%ROWTYPE;
30: l_qvev_rec qvev_rec_type;
31: BEGIN
32: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 151: CURSOR okl_pqy_values_unique (p_unique1 OKL_PQY_VALUES.VALUE%TYPE,

147: WHERE pqvv.qve_id = p_qve_id
148: AND (pqvv.FROM_DATE < p_from_date OR
149: NVL(pqvv.TO_DATE, pqvv.FROM_DATE) > p_to_date);
150:
151: CURSOR okl_pqy_values_unique (p_unique1 OKL_PQY_VALUES.VALUE%TYPE,
152: P_unique2 OKL_PQY_VALUES.PQY_ID%TYPE
153: ) IS
154: SELECT '1'
155: FROM OKL_PQY_VALUES_V

Line 155: FROM OKL_PQY_VALUES_V

151: CURSOR okl_pqy_values_unique (p_unique1 OKL_PQY_VALUES.VALUE%TYPE,
152: P_unique2 OKL_PQY_VALUES.PQY_ID%TYPE
153: ) IS
154: SELECT '1'
155: FROM OKL_PQY_VALUES_V
156: WHERE OKL_PQY_VALUES_V.VALUE = p_unique1 AND
157: OKL_PQY_VALUES_V.PQY_ID = p_unique2;
158: -- AND
159: -- OKL_PQY_VALUES_V.ID <> NVL(p_qvev_rec.id,-9999);

Line 156: WHERE OKL_PQY_VALUES_V.VALUE = p_unique1 AND

152: P_unique2 OKL_PQY_VALUES.PQY_ID%TYPE
153: ) IS
154: SELECT '1'
155: FROM OKL_PQY_VALUES_V
156: WHERE OKL_PQY_VALUES_V.VALUE = p_unique1 AND
157: OKL_PQY_VALUES_V.PQY_ID = p_unique2;
158: -- AND
159: -- OKL_PQY_VALUES_V.ID <> NVL(p_qvev_rec.id,-9999);
160:

Line 157: OKL_PQY_VALUES_V.PQY_ID = p_unique2;

153: ) IS
154: SELECT '1'
155: FROM OKL_PQY_VALUES_V
156: WHERE OKL_PQY_VALUES_V.VALUE = p_unique1 AND
157: OKL_PQY_VALUES_V.PQY_ID = p_unique2;
158: -- AND
159: -- OKL_PQY_VALUES_V.ID <> NVL(p_qvev_rec.id,-9999);
160:
161: l_token_1 VARCHAR2(1999);

Line 159: -- OKL_PQY_VALUES_V.ID <> NVL(p_qvev_rec.id,-9999);

155: FROM OKL_PQY_VALUES_V
156: WHERE OKL_PQY_VALUES_V.VALUE = p_unique1 AND
157: OKL_PQY_VALUES_V.PQY_ID = p_unique2;
158: -- AND
159: -- OKL_PQY_VALUES_V.ID <> NVL(p_qvev_rec.id,-9999);
160:
161: l_token_1 VARCHAR2(1999);
162: l_token_2 VARCHAR2(1999);
163: l_token_3 VARCHAR2(1999);

Line 164: l_unique_key OKL_PQY_VALUES_V.VALUE%TYPE;

160:
161: l_token_1 VARCHAR2(1999);
162: l_token_2 VARCHAR2(1999);
163: l_token_3 VARCHAR2(1999);
164: l_unique_key OKL_PQY_VALUES_V.VALUE%TYPE;
165: l_unique_key2 OKL_PQY_VALUES_V.PQY_ID%TYPE;
166: l_check VARCHAR2(1) := '?';
167: l_row_not_found BOOLEAN := FALSE;
168:

Line 165: l_unique_key2 OKL_PQY_VALUES_V.PQY_ID%TYPE;

161: l_token_1 VARCHAR2(1999);
162: l_token_2 VARCHAR2(1999);
163: l_token_3 VARCHAR2(1999);
164: l_unique_key OKL_PQY_VALUES_V.VALUE%TYPE;
165: l_unique_key2 OKL_PQY_VALUES_V.PQY_ID%TYPE;
166: l_check VARCHAR2(1) := '?';
167: l_row_not_found BOOLEAN := FALSE;
168:
169: BEGIN

Line 613: -- PROCEDURE insert_pqyvalues for: okl_pqy_values_v

609: RETURN(l_action);
610: END determine_action;
611:
612: ---------------------------------------------------------------------------
613: -- PROCEDURE insert_pqyvalues for: okl_pqy_values_v
614: ---------------------------------------------------------------------------
615: PROCEDURE insert_pqyvalues(
616: p_api_version IN NUMBER,
617: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,