APPS.FTE_SEL_GROUPS_PKG dependencies on FTE_SEL_RULE_RESTRICTIONS

Line 473: from fte_sel_rule_restrictions

469: attribute_value_from_number,
470: attribute_value_to_number,
471: data_type,
472: grouping_number
473: from fte_sel_rule_restrictions
474: where rule_id = x_rule_id;
475:
476: cursor c_get_results(x_result_id NUMBER) IS
477: select FTE_SEL_RESULTS_S.NEXTVAL,

Line 595: -- 4) FTE_SEL_RULE_RESTRICTIONS

591: -- Copy group:
592: -- 1) FTE_SEL_GROUPS
593: -- 2) FTE_SEL_GROUP_ATTRIBUTES
594: -- 3) FTE_SEL_RULES
595: -- 4) FTE_SEL_RULE_RESTRICTIONS
596: -- 5) FTE_SEL_RESULTS
597: -- 5a) FTE_SEL_RESULT_ASSIGNMENTS
598: -- 5b) FTE_SEL_RESULT_ATTRIBUTES
599: --

Line 804: -- 4) FTE_SEL_RULE_RESTRICTIONS

800:
801:
802:
803: --
804: -- 4) FTE_SEL_RULE_RESTRICTIONS
805: --
806: t_rest_rule_attribute_id.DELETE;
807: t_rest_rule_id.DELETE;
808: t_rest_attribute_name.DELETE;

Line 843: INSERT INTO fte_sel_rule_restrictions(

839: -- Copy the rules
840: --
841: IF (t_rest_rule_attribute_id.COUNT > 0) THEN
842: FORALL o in t_rest_rule_attribute_id.FIRST..t_rest_rule_attribute_id.LAST
843: INSERT INTO fte_sel_rule_restrictions(
844: RULE_ATTRIBUTE_ID,
845: RULE_ID,
846: ATTRIBUTE_NAME,
847: ATTRIBUTE_VALUE_FROM,

Line 859: VALUES (FTE_SEL_RULE_RESTRICTIONS_S.NEXTVAL,

855: LAST_UPDATE_DATE,
856: LAST_UPDATED_BY,
857: LAST_UPDATE_LOGIN,
858: GROUP_ID)
859: VALUES (FTE_SEL_RULE_RESTRICTIONS_S.NEXTVAL,
860: t_new_rule_id(l),
861: t_rest_attribute_name(o),
862: t_rest_attribute_value_from(o),
863: t_rest_attribute_value_to(o),

Line 1166: FROM fte_sel_rule_restrictions

1162:
1163:
1164: CURSOR get_region_cursor IS
1165: SELECT attribute_value_from_number
1166: FROM fte_sel_rule_restrictions
1167: WHERE group_id = p_group_id
1168: AND attribute_name like '%REGION_ID';
1169:
1170: all_valid VARCHAR2(1);