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_SETUPOPTVALUES_PVT dependencies on OKL_OPT_VALUES_V

Line 4: -- PROCEDURE get_rec for: OKL_OPT_VALUES_V

1: PACKAGE BODY Okl_Setupoptvalues_Pvt AS
2: /* $Header: OKLRSOVB.pls 115.15 2003/10/15 23:26:21 sgorantl noship $ */
3: ---------------------------------------------------------------------------
4: -- PROCEDURE get_rec for: OKL_OPT_VALUES_V
5: ---------------------------------------------------------------------------
6: PROCEDURE get_rec (
7: p_ovev_rec IN ovev_rec_type,
8: x_return_status OUT NOCOPY VARCHAR2,

Line 26: FROM Okl_Opt_Values_V

22: CREATION_DATE,
23: LAST_UPDATED_BY,
24: LAST_UPDATE_DATE,
25: NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN
26: FROM Okl_Opt_Values_V
27: WHERE okl_opt_values_v.id = p_id;
28: l_okl_ovev_pk okl_ovev_pk_csr%ROWTYPE;
29: l_ovev_rec ovev_rec_type;
30: BEGIN

Line 27: WHERE okl_opt_values_v.id = p_id;

23: LAST_UPDATED_BY,
24: LAST_UPDATE_DATE,
25: NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN
26: FROM Okl_Opt_Values_V
27: WHERE okl_opt_values_v.id = p_id;
28: l_okl_ovev_pk okl_ovev_pk_csr%ROWTYPE;
29: l_ovev_rec ovev_rec_type;
30: BEGIN
31: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 228: -- PROCEDURE default_parent_dates for: OKL_OPT_VALUES_V

224: END get_rul_rec;
225:
226:
227: ---------------------------------------------------------------------------
228: -- PROCEDURE default_parent_dates for: OKL_OPT_VALUES_V
229: ---------------------------------------------------------------------------
230:
231: PROCEDURE default_parent_dates(
232: p_ovev_rec IN ovev_rec_type,

Line 275: -- PROCEDURE check_constraints for: OKL_OPT_VALUES_V

271:
272: END default_parent_dates;
273:
274: ---------------------------------------------------------------------------
275: -- PROCEDURE check_constraints for: OKL_OPT_VALUES_V
276: -- To verify whether the dates modification is valid in relation with
277: -- the attached Option Value Rules, Options and Product
278: ---------------------------------------------------------------------------
279: PROCEDURE Check_Constraints (

Line 285: p_from_date IN Okl_Opt_Values_V.from_date%TYPE,

281: x_return_status OUT NOCOPY VARCHAR2,
282: x_valid OUT NOCOPY BOOLEAN
283: ) IS
284: CURSOR okl_ove_opt_fk_csr (p_opt_id IN Okl_Options_V.id%TYPE,
285: p_from_date IN Okl_Opt_Values_V.from_date%TYPE,
286: p_to_date IN Okl_Opt_Values_V.TO_DATE%TYPE
287: ) IS
288: SELECT '1'
289: FROM Okl_Options_V opt

Line 286: p_to_date IN Okl_Opt_Values_V.TO_DATE%TYPE

282: x_valid OUT NOCOPY BOOLEAN
283: ) IS
284: CURSOR okl_ove_opt_fk_csr (p_opt_id IN Okl_Options_V.id%TYPE,
285: p_from_date IN Okl_Opt_Values_V.from_date%TYPE,
286: p_to_date IN Okl_Opt_Values_V.TO_DATE%TYPE
287: ) IS
288: SELECT '1'
289: FROM Okl_Options_V opt
290: WHERE opt.ID = p_opt_id

Line 295: CURSOR okl_ove_ovd_fk_csr (p_ove_id IN Okl_Opt_Values_V.id%TYPE,

291: AND ((opt.FROM_DATE > p_from_date OR
292: p_from_date > NVL(opt.TO_DATE,p_from_date)) OR
293: NVL(opt.TO_DATE, p_to_date) < p_to_date);
294:
295: CURSOR okl_ove_ovd_fk_csr (p_ove_id IN Okl_Opt_Values_V.id%TYPE,
296: p_from_date IN Okl_Opt_Values_V.from_date%TYPE,
297: p_to_date IN Okl_Opt_Values_V.TO_DATE%TYPE
298: ) IS
299: SELECT '1'

Line 296: p_from_date IN Okl_Opt_Values_V.from_date%TYPE,

292: p_from_date > NVL(opt.TO_DATE,p_from_date)) OR
293: NVL(opt.TO_DATE, p_to_date) < p_to_date);
294:
295: CURSOR okl_ove_ovd_fk_csr (p_ove_id IN Okl_Opt_Values_V.id%TYPE,
296: p_from_date IN Okl_Opt_Values_V.from_date%TYPE,
297: p_to_date IN Okl_Opt_Values_V.TO_DATE%TYPE
298: ) IS
299: SELECT '1'
300: FROM Okl_Opv_Rules_V ovd,

Line 297: p_to_date IN Okl_Opt_Values_V.TO_DATE%TYPE

293: NVL(opt.TO_DATE, p_to_date) < p_to_date);
294:
295: CURSOR okl_ove_ovd_fk_csr (p_ove_id IN Okl_Opt_Values_V.id%TYPE,
296: p_from_date IN Okl_Opt_Values_V.from_date%TYPE,
297: p_to_date IN Okl_Opt_Values_V.TO_DATE%TYPE
298: ) IS
299: SELECT '1'
300: FROM Okl_Opv_Rules_V ovd,
301: Okl_Opt_Rules_V orl,

Line 318: CURSOR okl_ove_pov_fk_csr (p_ove_id IN Okl_Opt_Values_V.ID%TYPE,

314: AND ((lsr.START_DATE > p_from_date OR
315: P_from_date > NVL(lsr.END_DATE,p_from_date)) OR
316: NVL(lsr.END_DATE, p_to_date) < p_to_date);
317:
318: CURSOR okl_ove_pov_fk_csr (p_ove_id IN Okl_Opt_Values_V.ID%TYPE,
319: p_from_date IN Okl_Opt_Values_V.from_date%TYPE,
320: p_to_date IN Okl_Opt_Values_V.TO_DATE%TYPE
321: ) IS
322: SELECT '1'

Line 319: p_from_date IN Okl_Opt_Values_V.from_date%TYPE,

315: P_from_date > NVL(lsr.END_DATE,p_from_date)) OR
316: NVL(lsr.END_DATE, p_to_date) < p_to_date);
317:
318: CURSOR okl_ove_pov_fk_csr (p_ove_id IN Okl_Opt_Values_V.ID%TYPE,
319: p_from_date IN Okl_Opt_Values_V.from_date%TYPE,
320: p_to_date IN Okl_Opt_Values_V.TO_DATE%TYPE
321: ) IS
322: SELECT '1'
323: FROM Okl_Pdt_Opt_Vals_V pov

Line 320: p_to_date IN Okl_Opt_Values_V.TO_DATE%TYPE

316: NVL(lsr.END_DATE, p_to_date) < p_to_date);
317:
318: CURSOR okl_ove_pov_fk_csr (p_ove_id IN Okl_Opt_Values_V.ID%TYPE,
319: p_from_date IN Okl_Opt_Values_V.from_date%TYPE,
320: p_to_date IN Okl_Opt_Values_V.TO_DATE%TYPE
321: ) IS
322: SELECT '1'
323: FROM Okl_Pdt_Opt_Vals_V pov
324: WHERE pov.OVE_ID = p_ove_id

Line 329: p_unique2 OKL_OPT_VALUES.VALUE%TYPE

325: AND (pov.FROM_DATE < p_from_date OR
326: NVL(pov.TO_DATE, pov.FROM_DATE) > p_to_date);
327:
328: CURSOR okl_ove_values_unique (p_unique1 OKL_OPT_VALUES.OPT_ID%TYPE,
329: p_unique2 OKL_OPT_VALUES.VALUE%TYPE
330: ) IS
331: SELECT '1'
332: FROM OKL_OPT_VALUES_V
333: WHERE OKL_OPT_VALUES_V.OPT_ID = p_unique1 AND

Line 332: FROM OKL_OPT_VALUES_V

328: CURSOR okl_ove_values_unique (p_unique1 OKL_OPT_VALUES.OPT_ID%TYPE,
329: p_unique2 OKL_OPT_VALUES.VALUE%TYPE
330: ) IS
331: SELECT '1'
332: FROM OKL_OPT_VALUES_V
333: WHERE OKL_OPT_VALUES_V.OPT_ID = p_unique1 AND
334: OKL_OPT_VALUES_V.VALUE = p_unique2;
335:
336: l_unique_key OKL_OPT_VALUES_V.OPT_ID%TYPE;

Line 333: WHERE OKL_OPT_VALUES_V.OPT_ID = p_unique1 AND

329: p_unique2 OKL_OPT_VALUES.VALUE%TYPE
330: ) IS
331: SELECT '1'
332: FROM OKL_OPT_VALUES_V
333: WHERE OKL_OPT_VALUES_V.OPT_ID = p_unique1 AND
334: OKL_OPT_VALUES_V.VALUE = p_unique2;
335:
336: l_unique_key OKL_OPT_VALUES_V.OPT_ID%TYPE;
337: l_ovev_rec ovev_rec_type;

Line 334: OKL_OPT_VALUES_V.VALUE = p_unique2;

330: ) IS
331: SELECT '1'
332: FROM OKL_OPT_VALUES_V
333: WHERE OKL_OPT_VALUES_V.OPT_ID = p_unique1 AND
334: OKL_OPT_VALUES_V.VALUE = p_unique2;
335:
336: l_unique_key OKL_OPT_VALUES_V.OPT_ID%TYPE;
337: l_ovev_rec ovev_rec_type;
338: l_token_1 VARCHAR2(1999);

Line 336: l_unique_key OKL_OPT_VALUES_V.OPT_ID%TYPE;

332: FROM OKL_OPT_VALUES_V
333: WHERE OKL_OPT_VALUES_V.OPT_ID = p_unique1 AND
334: OKL_OPT_VALUES_V.VALUE = p_unique2;
335:
336: l_unique_key OKL_OPT_VALUES_V.OPT_ID%TYPE;
337: l_ovev_rec ovev_rec_type;
338: l_token_1 VARCHAR2(1999);
339: l_token_2 VARCHAR2(1999);
340: l_token_3 VARCHAR2(1999);

Line 344: l_to_date okl_opt_values_v.TO_DATE%TYPE;

340: l_token_3 VARCHAR2(1999);
341: l_token_4 VARCHAR2(1999);
342: l_check VARCHAR2(1) := '?';
343: l_row_not_found BOOLEAN := FALSE;
344: l_to_date okl_opt_values_v.TO_DATE%TYPE;
345: BEGIN
346: x_valid := TRUE;
347: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
348:

Line 635: -- PROCEDURE check_rule_templates for: OKL_OPT_VALUES_V

631:
632: -----END OF VALIDATE ATTRIBUTES-------------------------
633:
634: ---------------------------------------------------------------------------
635: -- PROCEDURE check_rule_templates for: OKL_OPT_VALUES_V
636: -- To verify whether the dates modification is valid in relation with
637: -- the attached Option Value Rule Templates
638: ---------------------------------------------------------------------------
639: PROCEDURE check_rule_templates (

Line 648: CURSOR okl_ove_ovt_fk_csr (p_ove_id IN Okl_Opt_Values_V.id%TYPE

644: x_msg_count OUT NOCOPY NUMBER,
645: x_msg_data OUT NOCOPY VARCHAR2,
646: x_valid OUT NOCOPY BOOLEAN
647: ) IS
648: CURSOR okl_ove_ovt_fk_csr (p_ove_id IN Okl_Opt_Values_V.id%TYPE
649: ) IS
650: SELECT ovt.RUL_ID RUL_ID,
651: ovd.CONTEXT_INTENT CONTEXT_INTENT,
652: orl.RGR_RGD_CODE RGR_RGD_CODE,

Line 667: p_from_date IN Okl_Opt_Values_V.from_date%TYPE,

663: p_rdf_code IN OKC_Rule_Def_Sources_V.rgr_rdf_code%TYPE,
664: p_buy_or_sell IN OKC_Rule_Def_Sources_V.buy_or_sell%TYPE,
665: p_jtot_object_code IN OKC_Rule_Def_Sources_V.jtot_object_code%TYPE,
666: p_object_id_number IN OKC_Rule_Def_Sources_V.object_id_number%TYPE,
667: p_from_date IN Okl_Opt_Values_V.from_date%TYPE,
668: p_to_date IN Okl_Opt_Values_V.TO_DATE%TYPE
669: ) IS
670: SELECT '1'
671: FROM OKC_Rule_Def_Sources_V rds

Line 668: p_to_date IN Okl_Opt_Values_V.TO_DATE%TYPE

664: p_buy_or_sell IN OKC_Rule_Def_Sources_V.buy_or_sell%TYPE,
665: p_jtot_object_code IN OKC_Rule_Def_Sources_V.jtot_object_code%TYPE,
666: p_object_id_number IN OKC_Rule_Def_Sources_V.object_id_number%TYPE,
667: p_from_date IN Okl_Opt_Values_V.from_date%TYPE,
668: p_to_date IN Okl_Opt_Values_V.TO_DATE%TYPE
669: ) IS
670: SELECT '1'
671: FROM OKC_Rule_Def_Sources_V rds
672: WHERE rds.RGR_RGD_CODE = p_rgd_code

Line 747: p_token1_value => 'Okl_Opt_Values_V',

743: p_ovev_rec.from_date > p_ovev_rec.TO_DATE) THEN
744: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
745: p_msg_name => G_DATES_MISMATCH,
746: p_token1 => G_PARENT_TABLE_TOKEN,
747: p_token1_value => 'Okl_Opt_Values_V',
748: p_token2 => G_CHILD_TABLE_TOKEN,
749: p_token2_value => 'OKC_Rules_V');
750: x_valid := FALSE;
751: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 772: p_token1_value => 'Okl_Opt_Values_V',

768: IF l_no_data_found = FALSE THEN
769: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
770: p_msg_name => G_DATES_MISMATCH,
771: p_token1 => G_PARENT_TABLE_TOKEN,
772: p_token1_value => 'Okl_Opt_Values_V',
773: p_token2 => G_CHILD_TABLE_TOKEN,
774: p_token2_value => 'OKC_Rule_Def_Sources_V');
775: x_valid := FALSE;
776: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 978: -- PROCEDURE determine_action for: OKL_OPT_VALUES_V

974:
975: END check_updates;
976:
977: ---------------------------------------------------------------------------
978: -- PROCEDURE determine_action for: OKL_OPT_VALUES_V
979: -- This function helps in determining the various checks to be performed
980: -- for the new/updated record and also helps in determining whether a new
981: -- version is required or not
982: ---------------------------------------------------------------------------

Line 1003: -- PROCEDURE insert_optvalues for: OKL_OPT_VALUES_V

999: RETURN(l_action);
1000: END determine_action;
1001:
1002: ---------------------------------------------------------------------------
1003: -- PROCEDURE insert_optvalues for: OKL_OPT_VALUES_V
1004: ---------------------------------------------------------------------------
1005: PROCEDURE insert_optvalues(p_api_version IN NUMBER,
1006: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1007: x_return_status OUT NOCOPY VARCHAR2,

Line 1132: -- PROCEDURE update_optvalues for: OKL_OPT_VALUES_V

1128:
1129: END insert_optvalues;
1130:
1131: ---------------------------------------------------------------------------
1132: -- PROCEDURE update_optvalues for: OKL_OPT_VALUES_V
1133: ---------------------------------------------------------------------------
1134: PROCEDURE update_optvalues(p_api_version IN NUMBER,
1135: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
1136: x_return_status OUT NOCOPY VARCHAR2,