DBA Data[Home] [Help]

APPS.CCT_IKEY_UPG dependencies on CCT_CLASSIFICATION_RULES

Line 26: update CCT_CLASSIFICATION_RULES set key='PARTY_ID' where nvl(f_deletedflag,'N')<>'D' and key='CustomerID';

22: return;
23: END IF;
24:
25: update cct_interaction_keys set interaction_key='PARTY_ID' where interaction_key_id = 7;
26: update CCT_CLASSIFICATION_RULES set key='PARTY_ID' where nvl(f_deletedflag,'N')<>'D' and key='CustomerID';
27: --Since cct_route_params also stores dynamic route's plsql param, "sequence is not null" determines
28: --that we are updating plsql params only.
29: update cct_route_params set value='PARTY_ID' where value='CustomerID' and sequence is not null and nvl(f_deletedflag,'N')<>'D';
30: update cct_route_params set param='PARTY_ID' where param='CustomerID' and sequence is not null and nvl(f_deletedflag,'N')<>'D';