APPS.FTE_SEL_GROUPS_PKG dependencies on FTE_SEL_RULES

Line 367: from fte_sel_rules r, fte_sel_result_assignments ra

363: BEGIN
364:
365: DELETE FROM FTE_SEL_RESULTS
366: WHERE result_id in (select result_id
367: from fte_sel_rules r, fte_sel_result_assignments ra
368: where r.rule_id = ra.rule_id
369: and r.group_id = p_group_id);
370:
371: x_return_status := 'S';

Line 400: from fte_sel_rules r, fte_sel_result_assignments ra

396: CREATED_BY, LAST_UPDATE_DATE,
397: LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
398: SELECT result_id, to_char(result_id), sysdate,
399: -1, sysdate, -1, -1
400: from fte_sel_rules r, fte_sel_result_assignments ra
401: where r.rule_id = ra.rule_id
402: and r.group_id = p_group_id;
403:
404: FTE_ACS_RULE_UTIL_PKG.SET_RANGE_OVERLAP_FLAG(p_group_id);

Line 455: select FTE_SEL_RULES_S.NEXTVAL,

451: where group_id = x_group_id;
452:
453:
454: cursor c_get_rules(xxx_group_id NUMBER) IS
455: select FTE_SEL_RULES_S.NEXTVAL,
456: rule_id,
457: name,
458: precedence,
459: sequence_number

Line 460: from fte_sel_rules

456: rule_id,
457: name,
458: precedence,
459: sequence_number
460: from fte_sel_rules
461: where group_id = xxx_group_id;
462:
463: cursor c_get_rule_restrictions(x_rule_id NUMBER) IS
464: select rule_attribute_id,

Line 594: -- 3) FTE_SEL_RULES

590: --
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

Line 739: -- 3) FTE_SEL_RULES

735:
736:
737:
738: --
739: -- 3) FTE_SEL_RULES
740: --
741: t_rule_id.DELETE;
742: t_rule_name.DELETE;
743: t_rule_precedence.DELETE;

Line 773: INSERT INTO fte_sel_rules(

769: --
770: IF (t_rule_id.COUNT > 0) THEN
771:
772: FORALL k in t_rule_id.FIRST..t_rule_id.LAST
773: INSERT INTO fte_sel_rules(
774: RULE_ID,
775: NAME,
776: GROUP_ID,
777: PRECEDENCE,