[Home] [Help]
351: END Validate_Assignment;
352:
353: /*------------------------------------------------------------------------
354: * Delete_Results
355: * 1) Delete data from FTE_SEL_RESULTS
356: *------------------------------------------------------------------------*/
357:
358: PROCEDURE Delete_Results( p_group_id IN NUMBER,
359: x_return_status OUT NOCOPY VARCHAR2,
361: x_msg_data OUT NOCOPY VARCHAR2) IS
362:
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);
378: END Delete_Results;
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: *------------------------------------------------------------------------*/
391: x_msg_data OUT NOCOPY VARCHAR2) IS
392:
393: BEGIN
394:
395: INSERT INTO FTE_SEL_RESULTS(RESULT_ID, NAME, CREATION_DATE,
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
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,
478: FTE_SEL_RESULT_ASSIGNMENTS_S.NEXTVAL,
479: result_id,
480: name,
481: description,
480: name,
481: description,
482: enabled_flag,
483: rank
484: from fte_sel_results
485: where result_id = x_result_id;
486:
487: cursor c_get_result_assignments(xx_rule_id NUMBER) IS
488: select result_assignment_id,
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: --
600:
878: END IF;
879: END LOOP;
880:
881: --
882: -- 5) FTE_SEL_RESULTS
883: --
884: t_new_result_assignment_id.DELETE;
885: t_resass_result_assignment_id.DELETE;
886: t_resass_rule_id.DELETE;
975: -- Copy the results
976: --
977: IF (tt_result_result_id.COUNT > 0) THEN
978: /*
979: do not create data in FTE_SEL_RESULTS yet
980: it'll be handled by Save_Results as the final step of copy flow
981:
982: FORALL v in tt_result_result_id.FIRST..tt_result_result_id.LAST
983: INSERT INTO fte_sel_results (
979: do not create data in FTE_SEL_RESULTS yet
980: it'll be handled by Save_Results as the final step of copy flow
981:
982: FORALL v in tt_result_result_id.FIRST..tt_result_result_id.LAST
983: INSERT INTO fte_sel_results (
984: RESULT_ID,
985: NAME,
986: DESCRIPTION,
987: ENABLED_FLAG,