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_SETUPOPTIONS_PVT dependencies on OKL_OPTIONS_V

Line 8: -- PROCEDURE get_rec for: OKL_OPTIONS_V

4: SUBTYPE ovev_rec_type IS Okl_Options_Pub.ovev_rec_type;
5: SUBTYPE ovev_tbl_type IS Okl_Options_Pub.ovev_tbl_type;
6:
7: ---------------------------------------------------------------------------
8: -- PROCEDURE get_rec for: OKL_OPTIONS_V
9: ---------------------------------------------------------------------------
10: PROCEDURE get_rec (
11: p_optv_rec IN optv_rec_type,
12: x_return_status OUT NOCOPY VARCHAR2,

Line 45: FROM Okl_Options_V

41: CREATION_DATE,
42: LAST_UPDATED_BY,
43: LAST_UPDATE_DATE,
44: NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN
45: FROM Okl_Options_V
46: WHERE okl_options_v.id = p_id;
47: l_okl_optv_pk okl_optv_pk_csr%ROWTYPE;
48: l_optv_rec optv_rec_type;
49: BEGIN

Line 46: WHERE okl_options_v.id = p_id;

42: LAST_UPDATED_BY,
43: LAST_UPDATE_DATE,
44: NVL(LAST_UPDATE_LOGIN, Okl_Api.G_MISS_NUM) LAST_UPDATE_LOGIN
45: FROM Okl_Options_V
46: WHERE okl_options_v.id = p_id;
47: l_okl_optv_pk okl_optv_pk_csr%ROWTYPE;
48: l_optv_rec optv_rec_type;
49: BEGIN
50: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 105: -- PROCEDURE get_opt_values for: OKL_OPTIONS_V

101:
102: END get_rec;
103:
104: ---------------------------------------------------------------------------
105: -- PROCEDURE get_opt_values for: OKL_OPTIONS_V
106: -- To fetch the valid values for the OPTIONS.
107: ---------------------------------------------------------------------------
108: PROCEDURE get_opt_values (p_upd_optv_rec IN optv_rec_type,
109: x_return_status OUT NOCOPY VARCHAR2,

Line 159: -- PROCEDURE check_constraints for: OKL_OPTIONS_V

155:
156: END get_opt_values;
157:
158: ---------------------------------------------------------------------------
159: -- PROCEDURE check_constraints for: OKL_OPTIONS_V
160: -- To verify whether the dates modification is valid in relation with
161: -- the attached Option Rules, Option Values and Product
162: ---------------------------------------------------------------------------
163: PROCEDURE Check_Constraints (

Line 168: CURSOR okl_opt_orl_fk_csr (p_opt_id IN Okl_Options_V.id%TYPE,

164: p_optv_rec IN optv_rec_type,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_valid OUT NOCOPY BOOLEAN
167: ) IS
168: CURSOR okl_opt_orl_fk_csr (p_opt_id IN Okl_Options_V.id%TYPE,
169: p_from_date IN Okl_Options_V.from_date%TYPE,
170: p_to_date IN Okl_Options_V.TO_DATE%TYPE
171:
172: ) IS

Line 169: p_from_date IN Okl_Options_V.from_date%TYPE,

165: x_return_status OUT NOCOPY VARCHAR2,
166: x_valid OUT NOCOPY BOOLEAN
167: ) IS
168: CURSOR okl_opt_orl_fk_csr (p_opt_id IN Okl_Options_V.id%TYPE,
169: p_from_date IN Okl_Options_V.from_date%TYPE,
170: p_to_date IN Okl_Options_V.TO_DATE%TYPE
171:
172: ) IS
173: SELECT '1'

Line 170: p_to_date IN Okl_Options_V.TO_DATE%TYPE

166: x_valid OUT NOCOPY BOOLEAN
167: ) IS
168: CURSOR okl_opt_orl_fk_csr (p_opt_id IN Okl_Options_V.id%TYPE,
169: p_from_date IN Okl_Options_V.from_date%TYPE,
170: p_to_date IN Okl_Options_V.TO_DATE%TYPE
171:
172: ) IS
173: SELECT '1'
174: FROM Okl_Opt_Rules_V orl,

Line 190: CURSOR okl_opt_ove_fk_csr (p_opt_id IN Okl_Options_V.id%TYPE,

186: AND ((lsr.START_DATE > p_from_date OR
187: P_from_date > NVL(lsr.END_DATE,p_from_date)) OR
188: NVL(lsr.END_DATE, p_to_date) < p_to_date);
189:
190: CURSOR okl_opt_ove_fk_csr (p_opt_id IN Okl_Options_V.id%TYPE,
191: p_from_date IN Okl_Options_V.from_date%TYPE,
192: p_to_date IN Okl_Options_V.TO_DATE%TYPE
193:
194: ) IS

Line 191: p_from_date IN Okl_Options_V.from_date%TYPE,

187: P_from_date > NVL(lsr.END_DATE,p_from_date)) OR
188: NVL(lsr.END_DATE, p_to_date) < p_to_date);
189:
190: CURSOR okl_opt_ove_fk_csr (p_opt_id IN Okl_Options_V.id%TYPE,
191: p_from_date IN Okl_Options_V.from_date%TYPE,
192: p_to_date IN Okl_Options_V.TO_DATE%TYPE
193:
194: ) IS
195: SELECT '1'

Line 192: p_to_date IN Okl_Options_V.TO_DATE%TYPE

188: NVL(lsr.END_DATE, p_to_date) < p_to_date);
189:
190: CURSOR okl_opt_ove_fk_csr (p_opt_id IN Okl_Options_V.id%TYPE,
191: p_from_date IN Okl_Options_V.from_date%TYPE,
192: p_to_date IN Okl_Options_V.TO_DATE%TYPE
193:
194: ) IS
195: SELECT '1'
196: FROM Okl_Opt_Values_V ove

Line 201: CURSOR okl_opt_pon_fk_csr (p_opt_id IN Okl_Options_V.ID%TYPE,

197: WHERE ove.OPT_ID = p_opt_id
198: AND (ove.FROM_DATE < p_from_date OR
199: NVL(ove.TO_DATE, ove.FROM_DATE) > p_to_date);
200:
201: CURSOR okl_opt_pon_fk_csr (p_opt_id IN Okl_Options_V.ID%TYPE,
202: p_from_date IN Okl_Options_V.from_date%TYPE,
203: p_to_date IN Okl_Options_V.TO_DATE%TYPE
204: ) IS
205: SELECT '1'

Line 202: p_from_date IN Okl_Options_V.from_date%TYPE,

198: AND (ove.FROM_DATE < p_from_date OR
199: NVL(ove.TO_DATE, ove.FROM_DATE) > p_to_date);
200:
201: CURSOR okl_opt_pon_fk_csr (p_opt_id IN Okl_Options_V.ID%TYPE,
202: p_from_date IN Okl_Options_V.from_date%TYPE,
203: p_to_date IN Okl_Options_V.TO_DATE%TYPE
204: ) IS
205: SELECT '1'
206: FROM Okl_Pdt_Opts_V pon

Line 203: p_to_date IN Okl_Options_V.TO_DATE%TYPE

199: NVL(ove.TO_DATE, ove.FROM_DATE) > p_to_date);
200:
201: CURSOR okl_opt_pon_fk_csr (p_opt_id IN Okl_Options_V.ID%TYPE,
202: p_from_date IN Okl_Options_V.from_date%TYPE,
203: p_to_date IN Okl_Options_V.TO_DATE%TYPE
204: ) IS
205: SELECT '1'
206: FROM Okl_Pdt_Opts_V pon
207: WHERE pon.OPT_ID = p_opt_id

Line 218: l_to_date okl_options_v.TO_DATE%TYPE;

214: l_token_4 VARCHAR2(1999);
215: l_optv_rec optv_rec_type;
216: l_check VARCHAR2(1) := '?';
217: l_row_not_found BOOLEAN := FALSE;
218: l_to_date okl_options_v.TO_DATE%TYPE;
219: BEGIN
220: x_valid := TRUE;
221: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
222:

Line 757: -- PROCEDURE determine_action for: OKL_OPTIONS_V

753:
754: END check_updates;
755:
756: ---------------------------------------------------------------------------
757: -- PROCEDURE determine_action for: OKL_OPTIONS_V
758: -- This function helps in determining the various checks to be performed
759: -- for the new/updated record and also helps in determining whether a new
760: -- version is required or not
761: ---------------------------------------------------------------------------

Line 782: -- PROCEDURE copy_update_constraints for: OKL_OPTIONS_V

778: RETURN(l_action);
779: END determine_action;
780:
781: ---------------------------------------------------------------------------
782: -- PROCEDURE copy_update_constraints for: OKL_OPTIONS_V
783: ---------------------------------------------------------------------------
784: PROCEDURE copy_update_constraints (p_api_version IN NUMBER,
785: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
786: p_upd_optv_rec IN optv_rec_type,

Line 850: -- PROCEDURE insert_options for: OKL_OPTIONS_V

846:
847: END copy_update_constraints;
848:
849: ---------------------------------------------------------------------------
850: -- PROCEDURE insert_options for: OKL_OPTIONS_V
851: ---------------------------------------------------------------------------
852: PROCEDURE insert_options(p_api_version IN NUMBER,
853: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
854: x_return_status OUT NOCOPY VARCHAR2,

Line 860: CURSOR okl_options_unique (p_unique OKL_OPTIONS_V.NAME%TYPE) IS

856: x_msg_data OUT NOCOPY VARCHAR2,
857: p_optv_rec IN optv_rec_type,
858: x_optv_rec OUT NOCOPY optv_rec_type
859: ) IS
860: CURSOR okl_options_unique (p_unique OKL_OPTIONS_V.NAME%TYPE) IS
861: SELECT '1'
862: FROM OKL_OPTIONS_V
863: WHERE OKL_OPTIONS_V.NAME = p_unique;
864:

Line 862: FROM OKL_OPTIONS_V

858: x_optv_rec OUT NOCOPY optv_rec_type
859: ) IS
860: CURSOR okl_options_unique (p_unique OKL_OPTIONS_V.NAME%TYPE) IS
861: SELECT '1'
862: FROM OKL_OPTIONS_V
863: WHERE OKL_OPTIONS_V.NAME = p_unique;
864:
865: l_unique_key OKL_OPTIONS_V.NAME%TYPE;
866: l_token_1 VARCHAR2(1999);

Line 863: WHERE OKL_OPTIONS_V.NAME = p_unique;

859: ) IS
860: CURSOR okl_options_unique (p_unique OKL_OPTIONS_V.NAME%TYPE) IS
861: SELECT '1'
862: FROM OKL_OPTIONS_V
863: WHERE OKL_OPTIONS_V.NAME = p_unique;
864:
865: l_unique_key OKL_OPTIONS_V.NAME%TYPE;
866: l_token_1 VARCHAR2(1999);
867: l_api_version CONSTANT NUMBER := 1;

Line 865: l_unique_key OKL_OPTIONS_V.NAME%TYPE;

861: SELECT '1'
862: FROM OKL_OPTIONS_V
863: WHERE OKL_OPTIONS_V.NAME = p_unique;
864:
865: l_unique_key OKL_OPTIONS_V.NAME%TYPE;
866: l_token_1 VARCHAR2(1999);
867: l_api_version CONSTANT NUMBER := 1;
868: l_api_name CONSTANT VARCHAR2(30) := 'insert_options';
869: l_valid BOOLEAN := TRUE;

Line 967: -- PROCEDURE update_options for: OKL_OPTIONS_V

963:
964: END insert_options;
965:
966: ---------------------------------------------------------------------------
967: -- PROCEDURE update_options for: OKL_OPTIONS_V
968: ---------------------------------------------------------------------------
969: PROCEDURE update_options(p_api_version IN NUMBER,
970: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
971: x_return_status OUT NOCOPY VARCHAR2,