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_CASCADE_DELETE_PUB dependencies on JTF_RS_RESOURCE_VALUES

Line 135: CURSOR csr_jtf_rs_resource_values

131: ( p_middleware_id IN NUMBER
132: , p_commit_flag IN VARCHAR2)
133: IS
134:
135: CURSOR csr_jtf_rs_resource_values
136: is
137: select resource_param_value_id, value_type, object_version_number
138: from jtf_rs_resource_values
139: where value_type = to_char(p_middleware_id);

Line 138: from jtf_rs_resource_values

134:
135: CURSOR csr_jtf_rs_resource_values
136: is
137: select resource_param_value_id, value_type, object_version_number
138: from jtf_rs_resource_values
139: where value_type = to_char(p_middleware_id);
140:
141: l_param_value_id jtf_rs_resource_values.resource_param_value_id%TYPE;
142: l_value_type jtf_rs_resource_values.value_type%TYPE;

Line 141: l_param_value_id jtf_rs_resource_values.resource_param_value_id%TYPE;

137: select resource_param_value_id, value_type, object_version_number
138: from jtf_rs_resource_values
139: where value_type = to_char(p_middleware_id);
140:
141: l_param_value_id jtf_rs_resource_values.resource_param_value_id%TYPE;
142: l_value_type jtf_rs_resource_values.value_type%TYPE;
143: l_obj_ver jtf_rs_resource_values.object_version_number%TYPE;
144: l_return_status varchar2(32);
145: l_msg_count NUMBER;

Line 142: l_value_type jtf_rs_resource_values.value_type%TYPE;

138: from jtf_rs_resource_values
139: where value_type = to_char(p_middleware_id);
140:
141: l_param_value_id jtf_rs_resource_values.resource_param_value_id%TYPE;
142: l_value_type jtf_rs_resource_values.value_type%TYPE;
143: l_obj_ver jtf_rs_resource_values.object_version_number%TYPE;
144: l_return_status varchar2(32);
145: l_msg_count NUMBER;
146: l_msg_data VARCHAR2(32);

Line 143: l_obj_ver jtf_rs_resource_values.object_version_number%TYPE;

139: where value_type = to_char(p_middleware_id);
140:
141: l_param_value_id jtf_rs_resource_values.resource_param_value_id%TYPE;
142: l_value_type jtf_rs_resource_values.value_type%TYPE;
143: l_obj_ver jtf_rs_resource_values.object_version_number%TYPE;
144: l_return_status varchar2(32);
145: l_msg_count NUMBER;
146: l_msg_data VARCHAR2(32);
147:

Line 162: -- delete jtf_rs_resource_values

158:
159: delete cct_middleware_values
160: where middleware_id = p_middleware_id;
161:
162: -- delete jtf_rs_resource_values
163: -- where value_type = to_char(p_middleware_id);
164: BEGIN
165: OPEN csr_jtf_rs_resource_values;
166:

Line 165: OPEN csr_jtf_rs_resource_values;

161:
162: -- delete jtf_rs_resource_values
163: -- where value_type = to_char(p_middleware_id);
164: BEGIN
165: OPEN csr_jtf_rs_resource_values;
166:
167: -- Fixed bug 4676911 dbhagat 10-Nov-2005
168: FETCH csr_jtf_rs_resource_values into l_param_value_id,l_value_type,l_obj_ver ;
169: WHILE (csr_jtf_rs_resource_values%FOUND) LOOP

Line 168: FETCH csr_jtf_rs_resource_values into l_param_value_id,l_value_type,l_obj_ver ;

164: BEGIN
165: OPEN csr_jtf_rs_resource_values;
166:
167: -- Fixed bug 4676911 dbhagat 10-Nov-2005
168: FETCH csr_jtf_rs_resource_values into l_param_value_id,l_value_type,l_obj_ver ;
169: WHILE (csr_jtf_rs_resource_values%FOUND) LOOP
170: jtf_rs_resource_values_pub.delete_rs_resource_values
171: (
172: p_api_version => 1

Line 169: WHILE (csr_jtf_rs_resource_values%FOUND) LOOP

165: OPEN csr_jtf_rs_resource_values;
166:
167: -- Fixed bug 4676911 dbhagat 10-Nov-2005
168: FETCH csr_jtf_rs_resource_values into l_param_value_id,l_value_type,l_obj_ver ;
169: WHILE (csr_jtf_rs_resource_values%FOUND) LOOP
170: jtf_rs_resource_values_pub.delete_rs_resource_values
171: (
172: p_api_version => 1
173: ,p_commit => fnd_api.g_true

Line 170: jtf_rs_resource_values_pub.delete_rs_resource_values

166:
167: -- Fixed bug 4676911 dbhagat 10-Nov-2005
168: FETCH csr_jtf_rs_resource_values into l_param_value_id,l_value_type,l_obj_ver ;
169: WHILE (csr_jtf_rs_resource_values%FOUND) LOOP
170: jtf_rs_resource_values_pub.delete_rs_resource_values
171: (
172: p_api_version => 1
173: ,p_commit => fnd_api.g_true
174: ,p_resource_param_value_id => l_param_value_id

Line 181: FETCH csr_jtf_rs_resource_values into l_param_value_id,l_value_type,l_obj_ver ;

177: ,x_msg_count => l_msg_count
178: ,x_msg_data => l_msg_data
179: );
180:
181: FETCH csr_jtf_rs_resource_values into l_param_value_id,l_value_type,l_obj_ver ;
182: END LOOP;
183: CLOSE csr_jtf_rs_resource_values;
184: --LOOP
185: -- FETCH csr_jtf_rs_resource_values into l_param_value_id,l_value_type,l_obj_ver ;

Line 183: CLOSE csr_jtf_rs_resource_values;

179: );
180:
181: FETCH csr_jtf_rs_resource_values into l_param_value_id,l_value_type,l_obj_ver ;
182: END LOOP;
183: CLOSE csr_jtf_rs_resource_values;
184: --LOOP
185: -- FETCH csr_jtf_rs_resource_values into l_param_value_id,l_value_type,l_obj_ver ;
186: -- IF csr_jtf_rs_resource_values%NOTFOUND THEN
187: -- CLOSE csr_jtf_rs_resource_values;

Line 185: -- FETCH csr_jtf_rs_resource_values into l_param_value_id,l_value_type,l_obj_ver ;

181: FETCH csr_jtf_rs_resource_values into l_param_value_id,l_value_type,l_obj_ver ;
182: END LOOP;
183: CLOSE csr_jtf_rs_resource_values;
184: --LOOP
185: -- FETCH csr_jtf_rs_resource_values into l_param_value_id,l_value_type,l_obj_ver ;
186: -- IF csr_jtf_rs_resource_values%NOTFOUND THEN
187: -- CLOSE csr_jtf_rs_resource_values;
188: -- ELSE
189: -- jtf_rs_resource_values_pub.delete_rs_resource_values

Line 186: -- IF csr_jtf_rs_resource_values%NOTFOUND THEN

182: END LOOP;
183: CLOSE csr_jtf_rs_resource_values;
184: --LOOP
185: -- FETCH csr_jtf_rs_resource_values into l_param_value_id,l_value_type,l_obj_ver ;
186: -- IF csr_jtf_rs_resource_values%NOTFOUND THEN
187: -- CLOSE csr_jtf_rs_resource_values;
188: -- ELSE
189: -- jtf_rs_resource_values_pub.delete_rs_resource_values
190: -- (

Line 187: -- CLOSE csr_jtf_rs_resource_values;

183: CLOSE csr_jtf_rs_resource_values;
184: --LOOP
185: -- FETCH csr_jtf_rs_resource_values into l_param_value_id,l_value_type,l_obj_ver ;
186: -- IF csr_jtf_rs_resource_values%NOTFOUND THEN
187: -- CLOSE csr_jtf_rs_resource_values;
188: -- ELSE
189: -- jtf_rs_resource_values_pub.delete_rs_resource_values
190: -- (
191: -- p_api_version => 1

Line 189: -- jtf_rs_resource_values_pub.delete_rs_resource_values

185: -- FETCH csr_jtf_rs_resource_values into l_param_value_id,l_value_type,l_obj_ver ;
186: -- IF csr_jtf_rs_resource_values%NOTFOUND THEN
187: -- CLOSE csr_jtf_rs_resource_values;
188: -- ELSE
189: -- jtf_rs_resource_values_pub.delete_rs_resource_values
190: -- (
191: -- p_api_version => 1
192: -- ,p_commit => fnd_api.g_true
193: -- ,p_resource_param_value_id => l_param_value_id