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.PV_SELATTVAL_PVT dependencies on PV_ENTY_SELECT_CRITERIA

Line 659: FROM pv_enty_select_criteria

655: )
656: IS
657: CURSOR C_select_criteria_id_Exists (c_select_criteria_id NUMBER) IS
658: SELECT 'X'
659: FROM pv_enty_select_criteria
660: WHERE selection_criteria_id = c_select_criteria_id;
661:
662: l_val VARCHAR2(1);
663:

Line 726: pv_selected_attr_values sav, pv_enty_select_criteria esc

722: --ryellapu duplicated check for criterian
723: cursor lc_criterion_dup_values_check (pc_rule_id number,pc_attribute_id number,pc_attribute_value varchar2,pc_selection_type_code varchar2) is
724: select attribute_value
725: from
726: pv_selected_attr_values sav, pv_enty_select_criteria esc
727: where
728: sav.selection_criteria_id = esc.selection_criteria_id and
729: esc.process_rule_id = pc_rule_id and
730: esc.attribute_id = pc_attribute_id and

Line 795: select process_rule_id,attribute_id,selection_type_code into l_rule_id,l_attribute_id,l_selection_type_code from pv_enty_select_criteria

791: IF (p_validation_level >= AS_UTILITY_PUB.G_VALID_LEVEL_RECORD) THEN
792: -- Hint: Inter-field level validation can be added here
793: -- invoke record level validation procedures
794: -- if p_validation_mode = AS_UTILITY_PVT.G_CREATE then
795: select process_rule_id,attribute_id,selection_type_code into l_rule_id,l_attribute_id,l_selection_type_code from pv_enty_select_criteria
796: where selection_criteria_id = P_SELATTVAL_Rec.selection_criteria_id;
797:
798: open lc_criterion_dup_values_check (pc_rule_id => l_rule_id,
799: pc_attribute_id => l_attribute_id,