APPS.CCT_ICJUMPSTART_PUB dependencies on CCT_MW_ROUTE_POINT_VALUES

Line 1096: Select cct_mw_route_point_values_s.nextval

1092:
1093: l_value:=CCT_COLLECTION_UTIL_PUB.GET(p_param_value,l_param,l_return_status);
1094:
1095: -- rem dbms_output.put_line('Inserting Route Point Param='||l_param||' value='||l_value);
1096: Select cct_mw_route_point_values_s.nextval
1097: into l_value_id
1098: from dual;
1099:
1100: Insert into ccT_mw_route_point_values(mw_route_point_value_id,mw_route_point_id,mw_route_point_param_id,value

Line 1100: Insert into ccT_mw_route_point_values(mw_route_point_value_id,mw_route_point_id,mw_route_point_param_id,value

1096: Select cct_mw_route_point_values_s.nextval
1097: into l_value_id
1098: from dual;
1099:
1100: Insert into ccT_mw_route_point_values(mw_route_point_value_id,mw_route_point_id,mw_route_point_param_id,value
1101: ,object_version_number,creation_date,created_by,last_update_date,last_updated_by)
1102: Select l_value_id,p_route_point_id,l_param_id,l_value
1103: ,1,sysdate,1,sysdate,1 from dual
1104: where not exists (Select 1 from cct_mw_route_point_values

Line 1104: where not exists (Select 1 from cct_mw_route_point_values

1100: Insert into ccT_mw_route_point_values(mw_route_point_value_id,mw_route_point_id,mw_route_point_param_id,value
1101: ,object_version_number,creation_date,created_by,last_update_date,last_updated_by)
1102: Select l_value_id,p_route_point_id,l_param_id,l_value
1103: ,1,sysdate,1,sysdate,1 from dual
1104: where not exists (Select 1 from cct_mw_route_point_values
1105: where mw_route_point_id=p_route_point_id and mw_route_point_param_id=l_param_id
1106: and nvl(f_deletedflag,'N')<>'D');
1107: Exception
1108: When others then