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_SETUPOVDTEMPLATES_PVT dependencies on OKC_RULE_DEF_SOURCES_V

Line 150: CURSOR okl_ovt_rds_fk_csr (p_rgd_code IN Okc_Rule_Def_Sources_V.rgr_rgd_code%TYPE,

146: WHERE ovd.ID = p_ovd_id
147: AND orl.ID = ovd.ORL_ID
148: AND ove.ID = ovd.OVE_ID;
149:
150: CURSOR okl_ovt_rds_fk_csr (p_rgd_code IN Okc_Rule_Def_Sources_V.rgr_rgd_code%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,

Line 151: p_rdf_code IN Okc_Rule_Def_Sources_V.rgr_rdf_code%TYPE,

147: AND orl.ID = ovd.ORL_ID
148: AND ove.ID = ovd.OVE_ID;
149:
150: CURSOR okl_ovt_rds_fk_csr (p_rgd_code IN Okc_Rule_Def_Sources_V.rgr_rgd_code%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,

Line 152: p_buy_or_sell IN Okc_Rule_Def_Sources_V.buy_or_sell%TYPE,

148: AND ove.ID = ovd.OVE_ID;
149:
150: CURSOR okl_ovt_rds_fk_csr (p_rgd_code IN Okc_Rule_Def_Sources_V.rgr_rgd_code%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

Line 153: p_jtot_object_code IN Okc_Rule_Def_Sources_V.jtot_object_code%TYPE,

149:
150: CURSOR okl_ovt_rds_fk_csr (p_rgd_code IN Okc_Rule_Def_Sources_V.rgr_rgd_code%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

Line 154: p_object_id_number IN Okc_Rule_Def_Sources_V.object_id_number%TYPE,

150: CURSOR okl_ovt_rds_fk_csr (p_rgd_code IN Okc_Rule_Def_Sources_V.rgr_rgd_code%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'

Line 159: FROM Okc_Rule_Def_Sources_V rds

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
161: AND rds.RGR_RDF_CODE = p_rdf_code
162: AND rds.OBJECT_ID_NUMBER = p_object_id_number
163: AND rds.JTOT_OBJECT_CODE = p_jtot_object_code

Line 361: p_token2_value => 'Okc_Rule_Def_Sources_V');

357: p_msg_name => G_DATES_MISMATCH,
358: p_token1 => G_PARENT_TABLE_TOKEN,
359: p_token1_value => 'Okl_Ovd_Rul_Tmls_V',
360: p_token2 => G_CHILD_TABLE_TOKEN,
361: p_token2_value => 'Okc_Rule_Def_Sources_V');
362: x_valid := FALSE;
363: x_return_status := Okl_Api.G_RET_STS_ERROR;
364: RAISE G_EXCEPTION_HALT_PROCESSING;
365: END IF;