APPS.CCT_INTERACTION_KEY_UPG dependencies on CCT_INTERACTION_KEYS

Line 12: FROM cct_interaction_keys

8: l_operation varchar2(20) := 'EQUAL';
9: BEGIN
10: BEGIN
11: SELECT Count(*) INTO l_upgraded
12: FROM cct_interaction_keys
13: WHERE (interaction_key='AccountCode' and data_type='STRING') OR
14: (interaction_key='ContractNum' and data_type='STRING') OR
15: (interaction_key='AccountNum' and data_type='STRING') ;
16: EXCEPTION

Line 71: update cct_interaction_keys set data_type='STRING'

67: AND nvl(f_deletedflag,'N')<>'D' ;
68:
69: END IF;
70: END LOOP;
71: update cct_interaction_keys set data_type='STRING'
72: where (interaction_key='AccountCode' or interaction_key='ContractNum'
73: or interaction_key='AccountNum');
74:
75:

Line 76: --dbms_output.put_line(' Populate cct_interaction_keys table ');

72: where (interaction_key='AccountCode' or interaction_key='ContractNum'
73: or interaction_key='AccountNum');
74:
75:
76: --dbms_output.put_line(' Populate cct_interaction_keys table ');
77:
78: END Upgrade_Interaction_Keys;
79: END CCT_INTERACTION_KEY_UPG;