APPS.IBE_DSPMGRVALIDATION_GRP dependencies on IBE_DSP_CONTEXT_B

Line 154: SELECT context_type_code FROM IBE_DSP_CONTEXT_B WHERE

150: IS
151: l_api_name CONSTANT VARCHAR2(40) := 'check_context_type_code';
152:
153: CURSOR context_type_cur (p_context_id IN NUMBER) IS
154: SELECT context_type_code FROM IBE_DSP_CONTEXT_B WHERE
155: context_id = p_context_id ;
156:
157: l_type_code VARCHAR2(40) := null;
158:

Line 203: FROM IBE_DSP_CONTEXT_B WHERE

199:
200: CURSOR context_cur( p_context_id IN NUMBER ,p_context_type IN VARCHAR2 ) IS
201: -- SELECT context_id
202: SELECT 1
203: FROM IBE_DSP_CONTEXT_B WHERE
204: context_id = p_context_id and context_type_code = p_context_type;
205:
206: CURSOR context_version_cur( p_context_id IN NUMBER,p_context_type IN VARCHAR2 ,
207: p_object_version_number IN NUMBER) IS

Line 210: FROM IBE_DSP_CONTEXT_B WHERE

206: CURSOR context_version_cur( p_context_id IN NUMBER,p_context_type IN VARCHAR2 ,
207: p_object_version_number IN NUMBER) IS
208: -- SELECT context_id
209: SELECT 1
210: FROM IBE_DSP_CONTEXT_B WHERE
211: context_id = p_context_id and context_type_code = p_context_type
212: and object_version_number = p_object_version_number;
213:
214: l_exists NUMBER;

Line 393: FROM IBE_DSP_CONTEXT_B WHERE

389: p_context_type IN VARCHAR2)
390: IS
391: -- SELECT access_name
392: SELECT 1
393: FROM IBE_DSP_CONTEXT_B WHERE
394: access_name = p_context_accessname ;
395:
396: CURSOR context_accessname_id_cur( p_context_accessname IN VARCHAR2 ,
397: p_context_type IN VARCHAR2,

Line 402: FROM IBE_DSP_CONTEXT_B WHERE

398: p_context_id IN VARCHAR2)
399: IS
400: -- SELECT access_name
401: SELECT 1
402: FROM IBE_DSP_CONTEXT_B WHERE
403: access_name = p_context_accessname and
404: context_id <> p_context_id ;
405: l_exists NUMBER;
406: l_return_status boolean := true;