APPS.FTE_SEL_GROUPS_PKG dependencies on FTE_SEL_RESULT_ASSIGNMENTS

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 383: * based on what are in FTE_SEL_RESULT_ASSIGNMENTS

379:
380: /*------------------------------------------------------------------------
381: * Save_Results
382: * 1) Insert data into FTE_SEL_RESULTS
383: * based on what are in FTE_SEL_RESULT_ASSIGNMENTS
384: * 2) Call FTE_ACS_RULE_UTIL_PKG.SET_RANGE_OVERLAP_FLAG
385: * to set the range_overlap_flag of each rule attribute
386: *------------------------------------------------------------------------*/
387:

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 478: FTE_SEL_RESULT_ASSIGNMENTS_S.NEXTVAL,

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,
478: FTE_SEL_RESULT_ASSIGNMENTS_S.NEXTVAL,
479: result_id,
480: name,
481: description,
482: enabled_flag,

Line 491: from fte_sel_result_assignments

487: cursor c_get_result_assignments(xx_rule_id NUMBER) IS
488: select result_assignment_id,
489: rule_id,
490: result_id
491: from fte_sel_result_assignments
492: where rule_id = xx_rule_id;
493:
494: cursor c_get_result_attributes(xx_result_id NUMBER) IS
495: select FTE_SEL_RESULT_ATTRIBUTES_S.NEXTVAL,

Line 597: -- 5a) FTE_SEL_RESULT_ASSIGNMENTS

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: --
600:
601:

Line 1012: INSERT INTO fte_sel_result_assignments (

1008: -- copy the asssignments
1009: --
1010: IF (tt_result_result_id.COUNT > 0) THEN
1011: FORALL w in tt_result_result_id.FIRST..tt_result_result_id.LAST
1012: INSERT INTO fte_sel_result_assignments (
1013: RESULT_ASSIGNMENT_ID,
1014: RULE_ID,
1015: RESULT_ID,
1016: CREATION_DATE,