APPS.CCT_RELATION_ENGINE dependencies on CCT_INTERACTION_KEYS

Line 9: l_code CCT_INTERACTION_KEYS.INTERACTION_KEY%TYPE;

5: ( p_interaction_key_id IN NUMBER, p_user_id IN NUMBER)
6: IS
7: -- Enter the procedure variables here. As shown below
8: -- variable_name datatype NOT NULL DEFAULT default_value;
9: l_code CCT_INTERACTION_KEYS.INTERACTION_KEY%TYPE;
10: BEGIN
11: -- Standard Start of API savepoint
12: SAVEPOINT delete_interaction_keys_pt;
13:

Line 16: delete cct_interaction_keys

12: SAVEPOINT delete_interaction_keys_pt;
13:
14: l_code := get_interaction_key_code(p_interaction_key_id);
15:
16: delete cct_interaction_keys
17: where interaction_key_id = p_interaction_key_id;
18:
19: -- delete data from related tables
20: delete_class_rule_ikeys(p_interaction_key_id, p_user_id, l_code);

Line 38: l_code CCT_INTERACTION_KEYS.INTERACTION_KEY%TYPE;

34: ( p_interaction_key_id IN NUMBER, p_user_id IN NUMBER)
35: IS
36: -- Enter the procedure variables here. As shown below
37: -- variable_name datatype NOT NULL DEFAULT default_value;
38: l_code CCT_INTERACTION_KEYS.INTERACTION_KEY%TYPE;
39: BEGIN
40: -- Standard Start of API savepoint
41: SAVEPOINT delete_rt_class_ikeys_pt;
42:

Line 60: l_code CCT_INTERACTION_KEYS.INTERACTION_KEY%TYPE;

56: FUNCTION get_interaction_key_code
57: ( p_interaction_key_id IN NUMBER)
58: RETURN VARCHAR2
59: IS
60: l_code CCT_INTERACTION_KEYS.INTERACTION_KEY%TYPE;
61: BEGIN
62:
63: select interaction_key into l_code
64: from cct_interaction_keys

Line 64: from cct_interaction_keys

60: l_code CCT_INTERACTION_KEYS.INTERACTION_KEY%TYPE;
61: BEGIN
62:
63: select interaction_key into l_code
64: from cct_interaction_keys
65: where interaction_key_id = p_interaction_key_id;
66:
67: RETURN l_code;
68: END get_interaction_key_code;

Line 74: l_code CCT_INTERACTION_KEYS.INTERACTION_KEY%TYPE;

70:
71: PROCEDURE delete_class_rule_ikeys
72: ( p_interaction_key_id IN NUMBER, p_user_id IN NUMBER)
73: IS
74: l_code CCT_INTERACTION_KEYS.INTERACTION_KEY%TYPE;
75: BEGIN
76:
77: l_code := get_interaction_key_code(p_interaction_key_id);
78: delete_class_rule_ikeys(p_interaction_key_id, p_user_id, l_code);

Line 97: l_code CCT_INTERACTION_KEYS.INTERACTION_KEY%TYPE;

93:
94: PROCEDURE delete_route_param_ikeys
95: ( p_interaction_key_id IN NUMBER, p_user_id IN NUMBER)
96: IS
97: l_code CCT_INTERACTION_KEYS.INTERACTION_KEY%TYPE;
98: BEGIN
99: l_code := get_interaction_key_code(p_interaction_key_id);
100: delete_route_param_ikeys(p_interaction_key_id, p_user_id, l_code);
101: END delete_route_param_ikeys;

Line 118: l_code CCT_INTERACTION_KEYS.INTERACTION_KEY%TYPE;

114:
115: PROCEDURE delete_ivr_ikeys
116: ( p_interaction_key_id IN NUMBER, p_user_id IN NUMBER)
117: IS
118: l_code CCT_INTERACTION_KEYS.INTERACTION_KEY%TYPE;
119: BEGIN
120: l_code := get_interaction_key_code(p_interaction_key_id);
121: delete_ivr_ikeys(p_interaction_key_id, p_user_id, l_code);
122: END delete_ivr_ikeys;

Line 139: l_code CCT_INTERACTION_KEYS.INTERACTION_KEY%TYPE;

135:
136: PROCEDURE delete_softphone_ikeys
137: ( p_interaction_key_id IN NUMBER, p_user_id IN NUMBER)
138: IS
139: l_code CCT_INTERACTION_KEYS.INTERACTION_KEY%TYPE;
140: BEGIN
141: l_code := get_interaction_key_code(p_interaction_key_id);
142: delete_softphone_ikeys(p_interaction_key_id, p_user_id, l_code);
143: END delete_softphone_ikeys;