eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SETUPPOVALUES_PVT dependencies on OKL_PDT_OPT_VALS

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 222: OPEN okl_pdt_opt_vals_unique (p_povv_rec.ove_id, p_povv_rec.pon_id);

218: END IF;
219:
220: --CHECK FOR UNIQUENESS
221: IF p_povv_rec.id = Okl_Api.G_MISS_NUM THEN
222: OPEN okl_pdt_opt_vals_unique (p_povv_rec.ove_id, p_povv_rec.pon_id);
223: FETCH okl_pdt_opt_vals_unique INTO l_unique_key;
224: IF okl_pdt_opt_vals_unique%FOUND THEN
225: --Okl_Api.set_message(G_APP_NAME,G_UNQS, G_TABLE_TOKEN,l_token_1);
226: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 223: FETCH okl_pdt_opt_vals_unique INTO l_unique_key;

219:
220: --CHECK FOR UNIQUENESS
221: IF p_povv_rec.id = Okl_Api.G_MISS_NUM THEN
222: OPEN okl_pdt_opt_vals_unique (p_povv_rec.ove_id, p_povv_rec.pon_id);
223: FETCH okl_pdt_opt_vals_unique INTO l_unique_key;
224: IF okl_pdt_opt_vals_unique%FOUND THEN
225: --Okl_Api.set_message(G_APP_NAME,G_UNQS, G_TABLE_TOKEN,l_token_1);
226: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
227: p_msg_name => 'OKL_COLUMN_NOT_UNIQUE',

Line 224: IF okl_pdt_opt_vals_unique%FOUND THEN

220: --CHECK FOR UNIQUENESS
221: IF p_povv_rec.id = Okl_Api.G_MISS_NUM THEN
222: OPEN okl_pdt_opt_vals_unique (p_povv_rec.ove_id, p_povv_rec.pon_id);
223: FETCH okl_pdt_opt_vals_unique INTO l_unique_key;
224: IF okl_pdt_opt_vals_unique%FOUND THEN
225: --Okl_Api.set_message(G_APP_NAME,G_UNQS, G_TABLE_TOKEN,l_token_1);
226: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
227: p_msg_name => 'OKL_COLUMN_NOT_UNIQUE',
228: p_token1 => G_TABLE_TOKEN,

Line 238: CLOSE okl_pdt_opt_vals_unique;

234: RAISE G_EXCEPTION_HALT_PROCESSING;
235: ELSE
236: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
237: END IF;
238: CLOSE okl_pdt_opt_vals_unique;
239: END IF;
240:
241: -- Check if the product to which the option values are added is not
242: -- in the past

Line 308: IF (okl_pdt_opt_vals_unique%ISOPEN) THEN

304: IF (okl_pov_constraints_csr%ISOPEN) THEN
305: CLOSE okl_pov_constraints_csr;
306: END IF;
307:
308: IF (okl_pdt_opt_vals_unique%ISOPEN) THEN
309: CLOSE okl_pdt_opt_vals_unique;
310: END IF;
311:
312: END Check_Constraints;

Line 309: CLOSE okl_pdt_opt_vals_unique;

305: CLOSE okl_pov_constraints_csr;
306: END IF;
307:
308: IF (okl_pdt_opt_vals_unique%ISOPEN) THEN
309: CLOSE okl_pdt_opt_vals_unique;
310: END IF;
311:
312: END Check_Constraints;
313:

Line 332: CURSOR okl_pdt_opt_vals_foreign1 (p_foreign OKL_PDT_OPT_VALS.OVE_ID%TYPE) IS

328: p_povv_rec IN povv_rec_type,
329: x_return_status OUT NOCOPY VARCHAR2
330: ) IS
331: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
332: CURSOR okl_pdt_opt_vals_foreign1 (p_foreign OKL_PDT_OPT_VALS.OVE_ID%TYPE) IS
333: SELECT ID
334: FROM OKL_OPT_VALUES_V
335: WHERE OKL_OPT_VALUES_V.ID = p_foreign;
336:

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 358: OPEN okl_pdt_opt_vals_foreign1 (p_povv_rec.ove_id);

354: RAISE G_ITEM_NOT_FOUND_ERROR;
355: END IF;
356:
357: IF p_povv_rec.ove_id IS NOT NULL THEN
358: OPEN okl_pdt_opt_vals_foreign1 (p_povv_rec.ove_id);
359: FETCH okl_pdt_opt_vals_foreign1 INTO l_foreign_key;
360: IF okl_pdt_opt_vals_foreign1%NOTFOUND THEN
361: Okc_Api.set_message(Okl_Pov_Pvt.G_APP_NAME, Okl_Pov_Pvt.G_INVALID_KEY,Okl_Pov_Pvt.G_COL_NAME_TOKEN,l_token_1);
362: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 359: FETCH okl_pdt_opt_vals_foreign1 INTO l_foreign_key;

355: END IF;
356:
357: IF p_povv_rec.ove_id IS NOT NULL THEN
358: OPEN okl_pdt_opt_vals_foreign1 (p_povv_rec.ove_id);
359: FETCH okl_pdt_opt_vals_foreign1 INTO l_foreign_key;
360: IF okl_pdt_opt_vals_foreign1%NOTFOUND THEN
361: Okc_Api.set_message(Okl_Pov_Pvt.G_APP_NAME, Okl_Pov_Pvt.G_INVALID_KEY,Okl_Pov_Pvt.G_COL_NAME_TOKEN,l_token_1);
362: x_return_status := Okl_Api.G_RET_STS_ERROR;
363: RAISE G_ITEM_NOT_FOUND_ERROR;

Line 360: IF okl_pdt_opt_vals_foreign1%NOTFOUND THEN

356:
357: IF p_povv_rec.ove_id IS NOT NULL THEN
358: OPEN okl_pdt_opt_vals_foreign1 (p_povv_rec.ove_id);
359: FETCH okl_pdt_opt_vals_foreign1 INTO l_foreign_key;
360: IF okl_pdt_opt_vals_foreign1%NOTFOUND THEN
361: Okc_Api.set_message(Okl_Pov_Pvt.G_APP_NAME, Okl_Pov_Pvt.G_INVALID_KEY,Okl_Pov_Pvt.G_COL_NAME_TOKEN,l_token_1);
362: x_return_status := Okl_Api.G_RET_STS_ERROR;
363: RAISE G_ITEM_NOT_FOUND_ERROR;
364: ELSE

Line 367: CLOSE okl_pdt_opt_vals_foreign1;

363: RAISE G_ITEM_NOT_FOUND_ERROR;
364: ELSE
365: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
366: END IF;
367: CLOSE okl_pdt_opt_vals_foreign1;
368: END IF;
369: EXCEPTION
370: WHEN G_ITEM_NOT_FOUND_ERROR THEN
371: NULL;

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 527: Okl_Pdt_Opt_Vals_Pub.insert_pdt_opt_vals(p_api_version => p_api_version,

523: END IF;
524:
525: /* public api to insert povalues */
526:
527: Okl_Pdt_Opt_Vals_Pub.insert_pdt_opt_vals(p_api_version => p_api_version,
528: p_init_msg_list => p_init_msg_list,
529: x_return_status => l_return_status,
530: x_msg_count => x_msg_count,
531: x_msg_data => x_msg_data,

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

Line 643: Okl_Pdt_Opt_Vals_Pub.delete_pdt_opt_vals(p_api_version => p_api_version,

639: END LOOP;
640: END IF;
641:
642: /* delete product option values */
643: Okl_Pdt_Opt_Vals_Pub.delete_pdt_opt_vals(p_api_version => p_api_version,
644: p_init_msg_list => p_init_msg_list,
645: x_return_status => l_return_status,
646: x_msg_count => x_msg_count,
647: x_msg_data => x_msg_data,