DBA Data[Home] [Help]

APPS.CCT_ICJUMPSTART_PUB dependencies on CCT_COLLECTION_UTIL_PUB

Line 607: l_result:=CCT_COLLECTION_UTIL_PUB.PUT(l_SERVERTYPEID_SERVERID,v_server.type_id,v_server.server_id);

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);
608: END LOOP;
609: x_servertypeid_serverid:=l_SERVERTYPEID_SERVERID;
610: Exception
611: When others then

Line 646: l_keys:=CCT_COLLECTION_UTIL_PUB.GETKEYS(p_param_value);

642: into l_type_id
643: from ieo_svr_servers
644: where server_id=p_server_id;
645:
646: l_keys:=CCT_COLLECTION_UTIL_PUB.GETKEYS(p_param_value);
647:
648: For l_counter in l_keys.FIRST..l_keys.LAST Loop
649: Begin
650: l_param:=l_keys(l_counter);

Line 657: l_value:=CCT_COLLECTION_UTIL_PUB.GET(p_param_value,l_param,l_return_status);

653: from ieo_svr_params
654: where type_id=l_type_id
655: and param_name=l_param;
656:
657: l_value:=CCT_COLLECTION_UTIL_PUB.GET(p_param_value,l_param,l_return_status);
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

Line 833: l_result:=CCT_COLLECTION_UTIL_PUB.PUT(l_paramValue,l_param,l_value);

829: End If;
830: Open c_param_value(p_middleware_id);
831: LOOP
832: Fetch c_param_Value into l_param,l_value;
833: l_result:=CCT_COLLECTION_UTIL_PUB.PUT(l_paramValue,l_param,l_value);
834: Exit When c_param_value%NOTFOUND;
835: End loop;
836: x_param_value:=l_paramValue;
837: Else

Line 986: l_keys:=CCT_COLLECTION_UTIL_PUB.GETKEYS(p_param_value);

982: from cct_middlewares
983: where middlewarE_id=p_middleware_id;
984: -- rem dbms_output.put_line('Creating Middleware Params for Middleware_id='||to_char(p_middleware_id));
985:
986: l_keys:=CCT_COLLECTION_UTIL_PUB.GETKEYS(p_param_value);
987:
988: For l_counter in l_keys.FIRST..l_keys.LAST Loop
989: Begin
990: l_param:=l_keys(l_counter);

Line 997: l_value:=CCT_COLLECTION_UTIL_PUB.GET(p_param_value,l_param,l_return_status);

993: from cct_middleware_params
994: where middleware_type_id=l_middleware_type_id
995: and name=l_param;
996:
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;

Line 1083: l_keys:=CCT_COLLECTION_UTIL_PUB.GETKEYS(p_param_value);

1079: l_keys CCT_KEY_VARR;
1080: l_counter Number;
1081: l_return_status VARCHAR2(32);
1082: Begin
1083: l_keys:=CCT_COLLECTION_UTIL_PUB.GETKEYS(p_param_value);
1084:
1085: For l_counter in l_keys.FIRST..l_keys.LAST Loop
1086: Begin
1087: l_param:=l_keys(l_counter);

Line 1093: l_value:=CCT_COLLECTION_UTIL_PUB.GET(p_param_value,l_param,l_return_status);

1089: into l_param_id
1090: from cct_mw_route_point_params
1091: where name=l_param;
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