APPS.OKL_SETUPPOVALUES_PVT dependencies on OKL_PDT_OPT_VALS_V

Line 9: -- PROCEDURE get_rec for: OKL_PDT_OPT_VALS_V

5: G_COLUMN_TOKEN CONSTANT VARCHAR2(100) := 'COLUMN';
6: G_ITEM_NOT_FOUND_ERROR EXCEPTION;
7:
8: ---------------------------------------------------------------------------
9: -- PROCEDURE get_rec for: OKL_PDT_OPT_VALS_V
10: ---------------------------------------------------------------------------
11: PROCEDURE get_rec (
12: p_povv_rec IN povv_rec_type,
13: x_no_data_found OUT NOCOPY BOOLEAN,

Line 30: FROM Okl_Pdt_Opt_Vals_V

26: CREATION_DATE,
27: LAST_UPDATED_BY,
28: LAST_UPDATE_DATE,
29: LAST_UPDATE_LOGIN
30: FROM Okl_Pdt_Opt_Vals_V
31: WHERE okl_pdt_opt_vals_v.id = p_id;
32: l_okl_povv_pk okl_povv_pk_csr%ROWTYPE;
33: l_povv_rec povv_rec_type;
34: BEGIN

Line 31: WHERE okl_pdt_opt_vals_v.id = p_id;

27: LAST_UPDATED_BY,
28: LAST_UPDATE_DATE,
29: LAST_UPDATE_LOGIN
30: FROM Okl_Pdt_Opt_Vals_V
31: WHERE okl_pdt_opt_vals_v.id = p_id;
32: l_okl_povv_pk okl_povv_pk_csr%ROWTYPE;
33: l_povv_rec povv_rec_type;
34: BEGIN
35: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 121: -- PROCEDURE check_constraints for: OKL_PDT_OPT_VALS_V

117:
118: END get_parent_dates;
119:
120: -----------------------------------------------------------------------------
121: -- PROCEDURE check_constraints for: OKL_PDT_OPT_VALS_V
122: -----------------------------------------------------------------------------
123:
124: PROCEDURE Check_Constraints (
125: p_api_version IN NUMBER,

Line 162: CURSOR okl_pdt_opt_vals_unique (p_unique1 OKL_PDT_OPT_VALS_V.OVE_ID%TYPE, p_unique2 OKL_PDT_OPT_VALS_V.PON_ID%TYPE) IS

158: AND ((ove.FROM_DATE > p_from_date OR
159: p_from_date > NVL(ove.TO_DATE,p_from_date)) OR
160: NVL(ove.TO_DATE, p_to_date) < p_to_date);
161:
162: CURSOR okl_pdt_opt_vals_unique (p_unique1 OKL_PDT_OPT_VALS_V.OVE_ID%TYPE, p_unique2 OKL_PDT_OPT_VALS_V.PON_ID%TYPE) IS
163: SELECT '1'
164: FROM OKL_PDT_OPT_VALS_V
165: WHERE OKL_PDT_OPT_VALS_V.OVE_ID = p_unique1 AND
166: OKL_PDT_OPT_VALS_V.PON_ID = p_unique2 AND

Line 164: FROM OKL_PDT_OPT_VALS_V

160: NVL(ove.TO_DATE, p_to_date) < p_to_date);
161:
162: CURSOR okl_pdt_opt_vals_unique (p_unique1 OKL_PDT_OPT_VALS_V.OVE_ID%TYPE, p_unique2 OKL_PDT_OPT_VALS_V.PON_ID%TYPE) IS
163: SELECT '1'
164: FROM OKL_PDT_OPT_VALS_V
165: WHERE OKL_PDT_OPT_VALS_V.OVE_ID = p_unique1 AND
166: OKL_PDT_OPT_VALS_V.PON_ID = p_unique2 AND
167: OKL_PDT_OPT_VALS_V.ID <> NVL(p_povv_rec.id,-9999);
168:

Line 165: WHERE OKL_PDT_OPT_VALS_V.OVE_ID = p_unique1 AND

161:
162: CURSOR okl_pdt_opt_vals_unique (p_unique1 OKL_PDT_OPT_VALS_V.OVE_ID%TYPE, p_unique2 OKL_PDT_OPT_VALS_V.PON_ID%TYPE) IS
163: SELECT '1'
164: FROM OKL_PDT_OPT_VALS_V
165: WHERE OKL_PDT_OPT_VALS_V.OVE_ID = p_unique1 AND
166: OKL_PDT_OPT_VALS_V.PON_ID = p_unique2 AND
167: OKL_PDT_OPT_VALS_V.ID <> NVL(p_povv_rec.id,-9999);
168:
169: l_unique_key VARCHAR2(1);

Line 166: OKL_PDT_OPT_VALS_V.PON_ID = p_unique2 AND

162: CURSOR okl_pdt_opt_vals_unique (p_unique1 OKL_PDT_OPT_VALS_V.OVE_ID%TYPE, p_unique2 OKL_PDT_OPT_VALS_V.PON_ID%TYPE) IS
163: SELECT '1'
164: FROM OKL_PDT_OPT_VALS_V
165: WHERE OKL_PDT_OPT_VALS_V.OVE_ID = p_unique1 AND
166: OKL_PDT_OPT_VALS_V.PON_ID = p_unique2 AND
167: OKL_PDT_OPT_VALS_V.ID <> NVL(p_povv_rec.id,-9999);
168:
169: l_unique_key VARCHAR2(1);
170: l_check VARCHAR2(1) := '?';

Line 167: OKL_PDT_OPT_VALS_V.ID <> NVL(p_povv_rec.id,-9999);

163: SELECT '1'
164: FROM OKL_PDT_OPT_VALS_V
165: WHERE OKL_PDT_OPT_VALS_V.OVE_ID = p_unique1 AND
166: OKL_PDT_OPT_VALS_V.PON_ID = p_unique2 AND
167: OKL_PDT_OPT_VALS_V.ID <> NVL(p_povv_rec.id,-9999);
168:
169: l_unique_key VARCHAR2(1);
170: l_check VARCHAR2(1) := '?';
171: l_row_not_found BOOLEAN := FALSE;

Line 337: l_foreign_key OKL_PDT_OPT_VALS_V.OVE_ID%TYPE;

333: SELECT ID
334: FROM OKL_OPT_VALUES_V
335: WHERE OKL_OPT_VALUES_V.ID = p_foreign;
336:
337: l_foreign_key OKL_PDT_OPT_VALS_V.OVE_ID%TYPE;
338: l_token_1 VARCHAR2(1999);
339:
340:
341: BEGIN

Line 437: -- PROCEDURE insert_povalues for: Okl_Pdt_opt_vals_V

433: -----END OF VALIDATE ATTRIBUTES-------------------------
434:
435:
436: ---------------------------------------------------------------------------
437: -- PROCEDURE insert_povalues for: Okl_Pdt_opt_vals_V
438: ---------------------------------------------------------------------------
439:
440: PROCEDURE insert_povalues(p_api_version IN NUMBER,
441: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

Line 570: -- PROCEDURE delete_povalues for: Okl_Pdt_opt_vals_V

566:
567: END insert_povalues;
568:
569: ---------------------------------------------------------------------------
570: -- PROCEDURE delete_povalues for: Okl_Pdt_opt_vals_V
571: -- This allows the user to delete table of records
572: ---------------------------------------------------------------------------
573: PROCEDURE delete_povalues(
574: p_api_version IN NUMBER