eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CCT_ICJUMPSTART_PUB dependencies on CCT_MW_ROUTE_POINTS

Line 1041: Select CCT_MW_ROUTE_POINTS_S.nextval

1037: )
1038: IS
1039: l_route_point_id Number;
1040: Begin
1041: Select CCT_MW_ROUTE_POINTS_S.nextval
1042: into l_route_point_id
1043: from dual;
1044:
1045: Insert into cct_mw_route_points(mw_route_point_id,middleware_id,route_point_number,description,

Line 1045: Insert into cct_mw_route_points(mw_route_point_id,middleware_id,route_point_number,description,

1041: Select CCT_MW_ROUTE_POINTS_S.nextval
1042: into l_route_point_id
1043: from dual;
1044:
1045: Insert into cct_mw_route_points(mw_route_point_id,middleware_id,route_point_number,description,
1046: object_version_number,creation_date,created_by,last_update_date,last_updated_By)
1047: Select l_route_point_id,p_middleware_id,p_route_point_number,p_route_point_number,
1048: 1,sysdate,1,sysdate,1 from dual
1049: where not exists (Select 1 from cct_mw_route_points

Line 1049: where not exists (Select 1 from cct_mw_route_points

1045: Insert into cct_mw_route_points(mw_route_point_id,middleware_id,route_point_number,description,
1046: object_version_number,creation_date,created_by,last_update_date,last_updated_By)
1047: Select l_route_point_id,p_middleware_id,p_route_point_number,p_route_point_number,
1048: 1,sysdate,1,sysdate,1 from dual
1049: where not exists (Select 1 from cct_mw_route_points
1050: where middleware_id=p_middleware_id and route_point_number=p_route_point_number
1051: and nvl(f_deletedflag,'N')<>'D');
1052: x_route_point_id:=l_route_point_id;
1053: Exception