APPS.JTF_DSPMGRVALIDATION_GRP dependencies on JTF_DSP_CONTEXT_B

Line 152: SELECT context_type_code FROM JTF_DSP_CONTEXT_B WHERE

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

Line 200: SELECT context_id FROM JTF_DSP_CONTEXT_B WHERE

196: l_api_name CONSTANT VARCHAR2(40) := 'check_context_exists';
197:
198: CURSOR context_cur( p_context_id IN NUMBER ,p_context_type IN VARCHAR2 ) IS
199: SELECT 1 from dual where exists(
200: SELECT context_id FROM JTF_DSP_CONTEXT_B WHERE
201: context_id = p_context_id and context_type_code = p_context_type);
202:
203: CURSOR context_version_cur( p_context_id IN NUMBER,p_context_type IN VARCHAR2 ,
204: p_object_version_number IN NUMBER) IS

Line 206: SELECT context_id FROM JTF_DSP_CONTEXT_B WHERE

202:
203: CURSOR context_version_cur( p_context_id IN NUMBER,p_context_type IN VARCHAR2 ,
204: p_object_version_number IN NUMBER) IS
205: SELECT 1 from dual where exists(
206: SELECT context_id FROM JTF_DSP_CONTEXT_B WHERE
207: context_id = p_context_id and context_type_code = p_context_type
208: and object_version_number = p_object_version_number);
209:
210: l_exists NUMBER;

Line 387: SELECT access_name FROM JTF_DSP_CONTEXT_B WHERE

383: CURSOR context_accessname_cur( p_context_accessname IN VARCHAR2 ,
384: p_context_type IN VARCHAR2)
385: IS
386: SELECT 1 from dual where exists(
387: SELECT access_name FROM JTF_DSP_CONTEXT_B WHERE
388: access_name = p_context_accessname );
389:
390: CURSOR context_accessname_id_cur( p_context_accessname IN VARCHAR2 ,
391: p_context_type IN VARCHAR2,

Line 395: SELECT access_name FROM JTF_DSP_CONTEXT_B WHERE

391: p_context_type IN VARCHAR2,
392: p_context_id IN VARCHAR2)
393: IS
394: SELECT 1 from dual where exists(
395: SELECT access_name FROM JTF_DSP_CONTEXT_B WHERE
396: access_name = p_context_accessname and
397: context_id <> p_context_id );
398: l_exists NUMBER;
399: l_return_status boolean := true;