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 OKC_RULE_DEF_SOURCES_V

Line 662: CURSOR okl_ove_rds_fk_csr (p_rgd_code IN OKC_Rule_Def_Sources_V.rgr_rgd_code%TYPE,

658: WHERE ovd.OVE_ID = p_ove_id
659: AND orl.ID = ovd.ORL_ID
660: AND ovt.OVD_ID = ovd.ID;
661:
662: CURSOR okl_ove_rds_fk_csr (p_rgd_code IN OKC_Rule_Def_Sources_V.rgr_rgd_code%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,

Line 663: p_rdf_code IN OKC_Rule_Def_Sources_V.rgr_rdf_code%TYPE,

659: AND orl.ID = ovd.ORL_ID
660: AND ovt.OVD_ID = ovd.ID;
661:
662: CURSOR okl_ove_rds_fk_csr (p_rgd_code IN OKC_Rule_Def_Sources_V.rgr_rgd_code%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,

Line 664: p_buy_or_sell IN OKC_Rule_Def_Sources_V.buy_or_sell%TYPE,

660: AND ovt.OVD_ID = ovd.ID;
661:
662: CURSOR okl_ove_rds_fk_csr (p_rgd_code IN OKC_Rule_Def_Sources_V.rgr_rgd_code%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

Line 665: p_jtot_object_code IN OKC_Rule_Def_Sources_V.jtot_object_code%TYPE,

661:
662: CURSOR okl_ove_rds_fk_csr (p_rgd_code IN OKC_Rule_Def_Sources_V.rgr_rgd_code%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

Line 666: p_object_id_number IN OKC_Rule_Def_Sources_V.object_id_number%TYPE,

662: CURSOR okl_ove_rds_fk_csr (p_rgd_code IN OKC_Rule_Def_Sources_V.rgr_rgd_code%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'

Line 671: FROM OKC_Rule_Def_Sources_V rds

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
673: AND rds.RGR_RDF_CODE = p_rdf_code
674: AND rds.OBJECT_ID_NUMBER = p_object_id_number
675: AND rds.JTOT_OBJECT_CODE = p_jtot_object_code

Line 774: p_token2_value => 'OKC_Rule_Def_Sources_V');

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;
777: RAISE G_EXCEPTION_HALT_PROCESSING;
778: END IF;