APPS.CCT_CLASS_ENGINE_UPG dependencies on CCT_PLSQL_FUNCTION_PARAMS

Line 102: insert into cct_plsql_function_params (function_param_id,function_id,param,datatype,direction,

98: where a.classification_id = l_record.classification_id;
99: END LOOP;
100:
101: --dbms_output.put_line(' Populate cct_classifications table with PL/SQL Function ids');
102: insert into cct_plsql_function_params (function_param_id,function_id,param,datatype,direction,
103: sequence,value,LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)
104: select cct_plsql_function_params_s.nextval,b.classification_value_id,a.param,
105: a.datatype,a.direction, a.sequence,a.value, TO_DATE ('01/01/1951', 'DD/MM/YYYY'),
106: 1,TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1

Line 104: select cct_plsql_function_params_s.nextval,b.classification_value_id,a.param,

100:
101: --dbms_output.put_line(' Populate cct_classifications table with PL/SQL Function ids');
102: insert into cct_plsql_function_params (function_param_id,function_id,param,datatype,direction,
103: sequence,value,LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY)
104: select cct_plsql_function_params_s.nextval,b.classification_value_id,a.param,
105: a.datatype,a.direction, a.sequence,a.value, TO_DATE ('01/01/1951', 'DD/MM/YYYY'),
106: 1,TO_DATE ('01/01/1951', 'DD/MM/YYYY'), 1
107: from cct_route_params a, cct_classifications b
108: where a.classification_id=b.classification_id AND upper(b.type)='DBPROC'