APPS.CCT_ICJUMPSTART_PUB dependencies on CCT_MIDDLEWARE_VALUES

Line 761: from cct_middleware_params p,cct_middleware_values v

757:
758: Cursor c_param_value(p_middleware_id Number)
759: is
760: Select p.name,v.value
761: from cct_middleware_params p,cct_middleware_values v
762: where v.middleware_id=p_middleware_id
763: and nvl(v.f_deletedflag,'N')<>'D'
764: and v.middleware_param_id=p.middleware_param_id;
765: Begin

Line 999: Select cct_middleware_values_s.nextval

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;
1002:
1003: Insert into ccT_middleware_values(middleware_value_id,middleware_id,middleware_param_id,value

Line 1003: Insert into ccT_middleware_values(middleware_value_id,middleware_id,middleware_param_id,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
1006: ,sysdate,1,sysdate,1 from dual
1007: where not exists (Select 1 from cct_middleware_values

Line 1007: where not exists (Select 1 from cct_middleware_values

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
1011: When others then