DBA Data[Home] [Help]

APPS.CCT_IKEY_UPG dependencies on CCT_PLSQL_FUNCTION_PARAMS

Line 31: update cct_plsql_function_params set value='PARTY_ID' where value='CustomerID' and nvl(f_deletedflag,'N')<>'D' ;

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';
31: update cct_plsql_function_params set value='PARTY_ID' where value='CustomerID' and nvl(f_deletedflag,'N')<>'D' ;
32:
33: --dbms_output.put_line(' ');
34:
35: END Change_CustomerID;