APPS.OKL_SETUPOVDTEMPLATES_PVT dependencies on OKL_OPT_VALUES_V

Line 145: Okl_Opt_Values_V ove

141: ove.FROM_DATE FROM_DATE,
142: NVL(ove.TO_DATE, Okl_Api.G_MISS_DATE) TO_DATE
143: FROM Okl_Opv_Rules_V ovd,
144: Okl_Opt_Rules_V orl,
145: Okl_Opt_Values_V ove
146: WHERE ovd.ID = p_ovd_id
147: AND orl.ID = ovd.ORL_ID
148: AND ove.ID = ovd.OVE_ID;
149:

Line 155: p_from_date IN Okl_Opt_Values_V.from_date%TYPE,

151: p_rdf_code IN Okc_Rule_Def_Sources_V.rgr_rdf_code%TYPE,
152: p_buy_or_sell IN Okc_Rule_Def_Sources_V.buy_or_sell%TYPE,
153: p_jtot_object_code IN Okc_Rule_Def_Sources_V.jtot_object_code%TYPE,
154: p_object_id_number IN Okc_Rule_Def_Sources_V.object_id_number%TYPE,
155: p_from_date IN Okl_Opt_Values_V.from_date%TYPE,
156: p_to_date IN Okl_Opt_Values_V.TO_DATE%TYPE
157: ) IS
158: SELECT '1'
159: FROM Okc_Rule_Def_Sources_V rds

Line 156: p_to_date IN Okl_Opt_Values_V.TO_DATE%TYPE

152: p_buy_or_sell IN Okc_Rule_Def_Sources_V.buy_or_sell%TYPE,
153: p_jtot_object_code IN Okc_Rule_Def_Sources_V.jtot_object_code%TYPE,
154: p_object_id_number IN Okc_Rule_Def_Sources_V.object_id_number%TYPE,
155: p_from_date IN Okl_Opt_Values_V.from_date%TYPE,
156: p_to_date IN Okl_Opt_Values_V.TO_DATE%TYPE
157: ) IS
158: SELECT '1'
159: FROM Okc_Rule_Def_Sources_V rds
160: WHERE rds.RGR_RGD_CODE = p_rgd_code

Line 334: p_token1_value => 'Okl_Opt_Values_V',

330: l_from_date > l_to_date) THEN
331: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
332: p_msg_name => G_DATES_MISMATCH,
333: p_token1 => G_PARENT_TABLE_TOKEN,
334: p_token1_value => 'Okl_Opt_Values_V',
335: p_token2 => G_CHILD_TABLE_TOKEN,
336: p_token2_value => 'Okc_Rules_b');
337: x_valid := FALSE;
338: x_return_status := Okl_Api.G_RET_STS_ERROR;