APPS.FEM_CHECK_BR_DIS_MBRS_PKG dependencies on FEM_BR_VALID_STATUS_GT

Line 625: -- validation routine, it inserts a row in FEM_BR_VALID_STATUS_GT

621: -- Wrapper routine that calls the individual validation routines specific
622: -- to each rule type. Before it validates a rule, it first checks to
623: -- see if it the rule has been validated before. If yes, then just
624: -- return the results from the previous run. After a call to a
625: -- validation routine, it inserts a row in FEM_BR_VALID_STATUS_GT
626: -- to record the validation result for the rule being checked.
627: --
628: -------------------------------------------------------------------------------
629: PROCEDURE Validate_Rule_Wrapper (

Line 657: FROM fem_br_valid_status_gt

653: -- If yes, then just return the previous results.
654: BEGIN
655: SELECT valid_flag
656: INTO x_this_is_valid
657: FROM fem_br_valid_status_gt
658: WHERE object_definition_id = p_obj_def_id;
659: EXCEPTION
660: WHEN others THEN NULL;
661: END;

Line 765: -- Insert validation status into FEM_BR_VALID_STATUS_GT

761:
762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
763: END IF; -- IF (v_rule_type = 'MAPPING_RULE') THEN
764:
765: -- Insert validation status into FEM_BR_VALID_STATUS_GT
766: INSERT INTO fem_br_valid_status_gt (object_definition_id, valid_flag)
767: VALUES (p_obj_def_id, v_this_rule_is_valid);
768:
769: x_this_is_valid := v_this_rule_is_valid;

Line 766: INSERT INTO fem_br_valid_status_gt (object_definition_id, valid_flag)

762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
763: END IF; -- IF (v_rule_type = 'MAPPING_RULE') THEN
764:
765: -- Insert validation status into FEM_BR_VALID_STATUS_GT
766: INSERT INTO fem_br_valid_status_gt (object_definition_id, valid_flag)
767: VALUES (p_obj_def_id, v_this_rule_is_valid);
768:
769: x_this_is_valid := v_this_rule_is_valid;
770: --