DBA Data[Home] [Help]

APPS.CCT_RELATION_ENGINE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

  PROCEDURE delete_interaction_keys
     ( p_interaction_key_id IN NUMBER, p_user_id IN NUMBER)
    IS
      -- Enter the procedure variables here. As shown below
      --  variable_name        datatype  NOT NULL DEFAULT default_value;
Line: 12

        SAVEPOINT  delete_interaction_keys_pt;
Line: 16

        delete cct_interaction_keys
        where interaction_key_id = p_interaction_key_id;
Line: 20

        delete_class_rule_ikeys(p_interaction_key_id, p_user_id, l_code);
Line: 22

        delete_ivr_ikeys(p_interaction_key_id, p_user_id, l_code);
Line: 24

        delete_route_param_ikeys(p_interaction_key_id, p_user_id, l_code);
Line: 26

        delete_softphone_ikeys(p_interaction_key_id, p_user_id, l_code);
Line: 30

          ROLLBACK TO delete_interaction_keys_pt;
Line: 31

   END delete_interaction_keys;
Line: 33

   PROCEDURE delete_rt_class_ikeys
     ( p_interaction_key_id IN NUMBER, p_user_id IN NUMBER)
   IS
      -- Enter the procedure variables here. As shown below
      --  variable_name        datatype  NOT NULL DEFAULT default_value;
Line: 41

        SAVEPOINT  delete_rt_class_ikeys_pt;
Line: 46

        delete_class_rule_ikeys(p_interaction_key_id, p_user_id, l_code);
Line: 48

        delete_route_param_ikeys(p_interaction_key_id, p_user_id, l_code);
Line: 52

          ROLLBACK TO delete_rt_class_ikeys_pt;
Line: 53

   END delete_rt_class_ikeys;
Line: 63

        select interaction_key into l_code
        from cct_interaction_keys
        where interaction_key_id = p_interaction_key_id;
Line: 71

   PROCEDURE delete_class_rule_ikeys
     ( p_interaction_key_id IN NUMBER, p_user_id IN NUMBER)
   IS
     l_code CCT_INTERACTION_KEYS.INTERACTION_KEY%TYPE;
Line: 78

     delete_class_rule_ikeys(p_interaction_key_id, p_user_id, l_code);
Line: 79

   END   delete_class_rule_ikeys;
Line: 82

   PROCEDURE delete_class_rule_ikeys
     ( p_interaction_key_id IN NUMBER, p_user_id IN NUMBER, p_interaction_key_code IN VARCHAR2)
   IS
   BEGIN

        update cct_classification_rules
        set f_deletedflag ='D', last_updated_by = p_user_id, last_update_date = sysdate
        where key = p_interaction_key_code;
Line: 92

   END  delete_class_rule_ikeys;
Line: 94

   PROCEDURE delete_route_param_ikeys
     ( p_interaction_key_id IN NUMBER, p_user_id IN NUMBER)
   IS
     l_code CCT_INTERACTION_KEYS.INTERACTION_KEY%TYPE;
Line: 100

     delete_route_param_ikeys(p_interaction_key_id, p_user_id, l_code);
Line: 101

   END delete_route_param_ikeys;
Line: 103

   PROCEDURE delete_route_param_ikeys
     ( p_interaction_key_id IN NUMBER, p_user_id IN NUMBER, p_interaction_key_code IN VARCHAR2)
   IS
   BEGIN

        update cct_route_params
        set f_deletedflag = 'D', last_updated_by = p_user_id, last_update_date = sysdate
        where param = p_interaction_key_code
        and sequence is null;
Line: 113

   END delete_route_param_ikeys;
Line: 115

   PROCEDURE delete_ivr_ikeys
     ( p_interaction_key_id IN NUMBER, p_user_id IN NUMBER)
   IS
     l_code CCT_INTERACTION_KEYS.INTERACTION_KEY%TYPE;
Line: 121

     delete_ivr_ikeys(p_interaction_key_id, p_user_id, l_code);
Line: 122

   END delete_ivr_ikeys;
Line: 124

   PROCEDURE delete_ivr_ikeys
     ( p_interaction_key_id IN NUMBER, p_user_id IN NUMBER, p_interaction_key_code IN VARCHAR2)
   IS
   BEGIN

        update cct_ivr_maps
        set f_deletedflag = 'D', last_updated_by = p_user_id, last_update_date = sysdate
        where interaction_key_id = p_interaction_key_id;
Line: 133

   END delete_ivr_ikeys;
Line: 136

   PROCEDURE delete_softphone_ikeys
     ( p_interaction_key_id IN NUMBER, p_user_id IN NUMBER)
   IS
     l_code CCT_INTERACTION_KEYS.INTERACTION_KEY%TYPE;
Line: 142

     delete_softphone_ikeys(p_interaction_key_id, p_user_id, l_code);
Line: 143

   END delete_softphone_ikeys;
Line: 145

   PROCEDURE delete_softphone_ikeys
     ( p_interaction_key_id IN NUMBER, p_user_id IN NUMBER, p_interaction_key_code IN VARCHAR2)
   IS
   BEGIN
    null;
Line: 151

        update cct_ivr_maps
        set f_deletedflag = 'D', last_updated_by = p_user_id, last_update_date = sysdate
        where interaction_key_id = p_interaction_key_id;
Line: 155

   END delete_softphone_ikeys;