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 DUAL

Line 30: l_role_resource_type VARCHAR2(32):='RS_INDIVIDUAL';

26: p_sql_result Number;
27: l_date DATE;
28: l_sales_credit_type_id Number;
29: l_user_password VARCHAR2(32):='WELCOME';
30: l_role_resource_type VARCHAR2(32):='RS_INDIVIDUAL';
31: l_role_type_code VARCHAR2(32):='CALLCENTER';
32: l_role_name VARCHAR2(32):='Call Center Agent';
33: l_role_id Number;
34: l_middleware_type_id Number;

Line 180: from dual;

176:
177: -- Get the current date
178: Select trunc(sysdate)
179: into l_date
180: from dual;
181:
182: -- Get a default Sales_credit_type
183: Select sales_credit_Type_id
184: into l_sales_credit_type_id

Line 537: from dual;

533: Exception
534: When No_data_found then
535: Select IEO_SVR_GROUPS_S1.nextval
536: into l_server_Group_id
537: from dual;
538: Insert into IEO_SVR_GROUPS
539: (Server_group_id,Group_name,Location,Description
540: ,created_by,Creation_Date,last_updateD_by,last_update_date)
541: values(l_server_Group_id,p_server_group_name,p_server_group_name,p_server_group_name

Line 603: sysdate,1,sysdate,1 from dual

599: (Server_id,type_id,server_name,member_Svr_group_id,description,
600: creation_date,created_By,last_update_date,last_updated_by)
601: Select v_server.server_id,v_server.type_id,l_server_group_name||v_server.type_name
602: ,p_server_group_id,v_server.type_description,
603: sysdate,1,sysdate,1 from dual
604: where not exists (Select 1 from ieo_Svr_servers where
605: member_svr_group_id=p_server_group_id
606: and type_id=v_server.type_id);
607: l_result:=CCT_COLLECTION_UTIL_PUB.PUT(l_SERVERTYPEID_SERVERID,v_server.type_id,v_server.server_id);

Line 662: from dual;

658: -- rem dbms_output.put_line('Inserting Server Param='||l_param||' value='||l_value||' for server_id='||to_char(p_server_id));
659:
660: Select ieo_svr_values_s1.nextval
661: into l_value_id
662: from dual;
663:
664: Insert into ieo_svr_values(value_id,server_id,param_id,value,value_index
665: ,creation_date,created_by,last_update_date,last_updated_by)
666: Select l_value_id,p_server_id,l_param_id,l_value,0

Line 667: ,sysdate,1,sysdate,1 from dual

663:
664: Insert into ieo_svr_values(value_id,server_id,param_id,value,value_index
665: ,creation_date,created_by,last_update_date,last_updated_by)
666: Select l_value_id,p_server_id,l_param_id,l_value,0
667: ,sysdate,1,sysdate,1 from dual
668: where not exists (Select 1 from ieo_svr_values
669: where server_id=p_server_id and param_id=l_param_id);
670: Exception
671: When others then

Line 715: from dual;

711: where server_group_id=p_server_Group_id;
712:
713: Select CCT_MIDDLEWARES_S.nextval
714: into x_middleware_id
715: from dual;
716:
717: Insert into CCT_Middlewares
718: (Middleware_id,Config_Name,Server_Group_id,middleware_type_id
719: ,creation_Date,created_by,last_update_date,last_updated_by)

Line 721: ,sysdate,1,sysdate,1 from dual

717: Insert into CCT_Middlewares
718: (Middleware_id,Config_Name,Server_Group_id,middleware_type_id
719: ,creation_Date,created_by,last_update_date,last_updated_by)
720: Select x_middleware_id,l_config_name,p_server_group_id,l_middleware_type_id
721: ,sysdate,1,sysdate,1 from dual
722: where not exists (Select 1 from cct_middlewares
723: where server_group_id=p_server_Group_id and config_name=l_config_name);
724: Exception
725: When No_Data_Found then

Line 902: from dual;

898: end if;
899: For l_counter in 1..p_number_of_Telesets Loop
900: Select CCT_Telesets_s.nextval
901: into l_teleset_id
902: from dual;
903: -- rem dbms_output.put_line('Creating Teleset='||to_char(l_teleset_hardware_number));
904: Insert into CCT_TELESETS(TELESET_ID,Teleset_type_id,Teleset_Name,Teleset_hardwarE_number,Middleware_id,server_group_id
905: ,creation_date,created_by,last_update_date,last_updated_by)
906: Select l_teleset_id,l_teleset_type_id,l_teleset_hardware_number,l_teleset_hardware_number,p_middleware_id,l_server_group_id

Line 908: from dual where not exists (Select 1 from cct_telesets where teleset_type_id=l_teleset_type_id

904: Insert into CCT_TELESETS(TELESET_ID,Teleset_type_id,Teleset_Name,Teleset_hardwarE_number,Middleware_id,server_group_id
905: ,creation_date,created_by,last_update_date,last_updated_by)
906: Select l_teleset_id,l_teleset_type_id,l_teleset_hardware_number,l_teleset_hardware_number,p_middleware_id,l_server_group_id
907: ,sysdate,1,sysdate,1
908: from dual where not exists (Select 1 from cct_telesets where teleset_type_id=l_teleset_type_id
909: and teleset_hardware_number=l_teleset_hardware_number and middlewarE_id=p_middleware_id);
910:
911: If (upper(p_teleset_type)='LUCENT') THEN
912: For l_counter in 1..l_num_of_lines Loop

Line 915: from dual;

911: If (upper(p_teleset_type)='LUCENT') THEN
912: For l_counter in 1..l_num_of_lines Loop
913: Select cct_lines_s.nextval
914: into l_line_id
915: from dual;
916: Insert into CCT_LINES(Line_id,Line_index,extension,teleset_id,
917: creation_date,created_by,last_update_date,last_updated_by)
918: Select l_line_id,l_counter,l_teleset_hardware_number,l_teleset_id,
919: sysdate,1,sysdate,1 from dual

Line 919: sysdate,1,sysdate,1 from dual

915: from dual;
916: Insert into CCT_LINES(Line_id,Line_index,extension,teleset_id,
917: creation_date,created_by,last_update_date,last_updated_by)
918: Select l_line_id,l_counter,l_teleset_hardware_number,l_teleset_id,
919: sysdate,1,sysdate,1 from dual
920: where not exists (Select 1 from cct_lines where teleset_id=l_teleset_id
921: and line_index=l_counter);
922: End Loop;
923:

Line 928: sysdate,1,sysdate,1 from dual

924: ELSIf (upper(p_teleset_type)='NORTEL') THEN
925: Insert into CCT_LINES(Line_id,Line_index,extension,teleset_id,
926: creation_date,created_by,last_update_date,last_updated_by)
927: Select CCT_LINES_S.nextval,1,l_line1,l_teleset_id,
928: sysdate,1,sysdate,1 from dual
929: where not exists (Select 1 from cct_lines where teleset_id=l_teleset_id
930: and line_index=1);
931: Insert into CCT_LINES(Line_id,Line_index,extension,teleset_id,
932: creation_date,created_by,last_update_date,last_updated_by)

Line 934: sysdate,1,sysdate,1 from dual

930: and line_index=1);
931: Insert into CCT_LINES(Line_id,Line_index,extension,teleset_id,
932: creation_date,created_by,last_update_date,last_updated_by)
933: Select CCT_LINES_S.nextval,2,l_line2,l_teleset_id,
934: sysdate,1,sysdate,1 from dual
935: where not exists (Select 1 from cct_lines where teleset_id=l_teleset_id
936: and line_index=2);
937: Insert into CCT_LINES(Line_id,Line_index,extension,teleset_id,
938: creation_date,created_by,last_update_date,last_updated_by)

Line 940: sysdate,1,sysdate,1 from dual

936: and line_index=2);
937: Insert into CCT_LINES(Line_id,Line_index,extension,teleset_id,
938: creation_date,created_by,last_update_date,last_updated_by)
939: Select CCT_LINES_S.nextval,3,l_line3,l_teleset_id,
940: sysdate,1,sysdate,1 from dual
941: where not exists (Select 1 from cct_lines where teleset_id=l_teleset_id
942: and line_index=3);
943: l_line1:=l_line1+p_skip_by;
944: l_line2:=l_line2+p_skip_by;

Line 1001: from dual;

997: l_value:=CCT_COLLECTION_UTIL_PUB.GET(p_param_value,l_param,l_return_status);
998: -- rem dbms_output.put_line('Inserting Middleware Param='||l_param||' value='||l_value);
999: Select cct_middleware_values_s.nextval
1000: into l_value_id
1001: from dual;
1002:
1003: Insert into ccT_middleware_values(middleware_value_id,middleware_id,middleware_param_id,value
1004: ,creation_date,created_by,last_update_date,last_updated_by)
1005: Select l_value_id,p_middleware_id,l_middleware_param_id,l_value

Line 1006: ,sysdate,1,sysdate,1 from dual

1002:
1003: Insert into ccT_middleware_values(middleware_value_id,middleware_id,middleware_param_id,value
1004: ,creation_date,created_by,last_update_date,last_updated_by)
1005: Select l_value_id,p_middleware_id,l_middleware_param_id,l_value
1006: ,sysdate,1,sysdate,1 from dual
1007: where not exists (Select 1 from cct_middleware_values
1008: where middleware_id=p_middleware_id and middleware_param_id=l_middleware_param_id
1009: and nvl(f_deletedflag,'N')<>'D');
1010: Exception

Line 1043: from dual;

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,
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,

Line 1048: 1,sysdate,1,sysdate,1 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
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;

Line 1098: from dual;

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
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

Line 1103: ,1,sysdate,1,sysdate,1 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
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