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.JTF_DSPMGRVALIDATION_GRP dependencies on DUAL

Line 20: SELECT 1 FROM dual WHERE exists (

16:
17: l_api_name CONSTANT VARCHAR2(40) := 'check_attachment_exists';
18:
19: CURSOR attachment_cur( p_attachment_id IN NUMBER ) IS
20: SELECT 1 FROM dual WHERE exists (
21: SELECT attachment_used_by_id FROM JTF_AMV_ATTACHMENTS
22: WHERE attachment_id = p_attachment_id);
23:
24: CURSOR attachment_version_cur( p_attachment_id IN NUMBER ,

Line 26: SELECT 1 FROM dual WHERE exists (

22: WHERE attachment_id = p_attachment_id);
23:
24: CURSOR attachment_version_cur( p_attachment_id IN NUMBER ,
25: p_object_version_number IN NUMBER) IS
26: SELECT 1 FROM dual WHERE exists (
27: SELECT attachment_used_by_id FROM JTF_AMV_ATTACHMENTS
28: WHERE attachment_id = p_attachment_id
29: AND object_version_number=p_object_version_number);
30:

Line 199: SELECT 1 from dual where exists(

195: IS
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 ,

Line 205: SELECT 1 from dual where exists(

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
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:

Line 317: select 1 from dual where exists (

313: RETURN boolean
314: IS
315:
316: CURSOR valid_object_cur (p_object_type IN VARCHAR2) IS
317: select 1 from dual where exists (
318: select lookup_code from FND_LOOKUP_VALUES_VL WHERE
319: lookup_type = 'IBE_RELATIONSHIP_RULE_OBJ_TYPE' and
320: lookup_code = p_object_type and
321: lookup_code <> 'N' and

Line 386: SELECT 1 from dual where exists(

382: l_context_type VARCHAR2(30);
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 ,

Line 394: SELECT 1 from dual where exists(

390: CURSOR context_accessname_id_cur( p_context_accessname IN VARCHAR2 ,
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;

Line 455: SELECT 1 from dual where exists (select tpl_ctg_id from jtf_dsp_tpl_ctg where

451: IS
452: l_api_name CONSTANT VARCHAR2(40) := 'check_ctg_tpl_relation_exists';
453:
454: CURSOR ctg_tpl_relation_cur( p_category_id IN NUMBER,p_template_id IN NUMBER ) IS
455: SELECT 1 from dual where exists (select tpl_ctg_id from jtf_dsp_tpl_ctg where
456: category_id = p_category_id and item_id = p_template_id);
457: l_exists NUMBER;
458: l_return_status boolean := false;
459:

Line 494: SELECT 1 from dual where exists (

490: IS
491: l_api_name CONSTANT VARCHAR2(40) := 'check_category_exists';
492:
493: CURSOR category_cur( p_category_id IN NUMBER ) IS
494: SELECT 1 from dual where exists (
495: select category_id from mtl_categories where category_id=p_category_id);
496:
497: l_exists NUMBER;
498: l_return_status boolean := false;

Line 539: SELECT 1 from dual where exists (

535: IS
536: l_api_name CONSTANT VARCHAR2(40) := 'check_item_exists';
537:
538: CURSOR item_cur( p_item_id IN NUMBER ) IS
539: SELECT 1 from dual where exists (
540: select distinct inventory_item_id from mtl_system_items
541: where inventory_item_id = p_item_id);
542:
543: l_exists NUMBER;

Line 585: SELECT 1 from dual where exists (

581: IS
582: l_api_name CONSTANT VARCHAR2(40) := 'check_section_exists';
583:
584: CURSOR section_cur( p_section_id IN NUMBER ) IS
585: SELECT 1 from dual where exists (
586: select section_id from jtf_dsp_sections_b where
587: section_id = p_section_id);
588: l_exists NUMBER;
589: l_return_status boolean := false;

Line 630: SELECT 1 from dual where exists (

626: IS
627: l_api_name CONSTANT VARCHAR2(40) := 'check_root_section_exists';
628:
629: CURSOR section_cur( p_section_id IN NUMBER ) IS
630: SELECT 1 from dual where exists (
631: select section_id from jtf_dsp_sections_b where
632: section_id = p_section_id );
633: l_exists NUMBER;
634: l_return_status boolean := false;

Line 730: select 1 from dual where exists (

726: l_exists NUMBER;
727: l_item_type VARCHAR2(40);
728: CURSOR deliverable_type_cur( p_deliverable_id IN NUMBER,
729: p_item_type IN VARCHAR2 ) IS
730: select 1 from dual where exists (
731: SELECT item_id FROM JTF_AMV_ITEMS_B
732: WHERE item_id = p_deliverable_id and
733: deliverable_type_code = p_item_type );
734:

Line 737: select 1 from dual where exists (

733: deliverable_type_code = p_item_type );
734:
735: CURSOR deliverable_type_app_cur( p_deliverable_id IN NUMBER,
736: p_item_type IN VARCHAR2, p_applicable_to IN VARCHAR2 ) IS
737: select 1 from dual where exists (
738: SELECT item_id FROM JTF_AMV_ITEMS_B
739: WHERE item_id = p_deliverable_id and
740: deliverable_type_code = p_item_type and
741: applicable_to_code = p_applicable_to);

Line 803: select 1 from dual where exists (

799: IS
800: l_api_name CONSTANT VARCHAR2(40) := 'check_deliverable_exists';
801:
802: CURSOR deliverable_cur( p_deliverable_id IN NUMBER ) IS
803: select 1 from dual where exists (
804: SELECT item_id FROM JTF_AMV_ITEMS_B
805: WHERE item_id = p_deliverable_id);
806:
807: CURSOR deliverable_version_cur( p_deliverable_id IN NUMBER,

Line 809: select 1 from dual where exists (

805: WHERE item_id = p_deliverable_id);
806:
807: CURSOR deliverable_version_cur( p_deliverable_id IN NUMBER,
808: p_object_version_number IN NUMBER ) IS
809: select 1 from dual where exists (
810: SELECT item_id FROM JTF_AMV_ITEMS_B
811: WHERE item_id = p_deliverable_id and
812: object_version_number = p_object_version_number);
813:

Line 883: SELECT 1 from dual where exists (

879: IS
880: l_api_name CONSTANT VARCHAR2(40) := 'check_lgl_ctnt_id_exists';
881:
882: CURSOR lgl_ctnt_cur( p_lgl_ctnt_id IN NUMBER ) IS
883: SELECT 1 from dual where exists (
884: SELECT obj_lgl_ctnt_id FROM JTF_DSP_OBJ_LGL_CTNT
885: WHERE obj_lgl_ctnt_id = p_lgl_ctnt_id);
886:
887: CURSOR lgl_ctnt_version_cur( p_lgl_ctnt_id IN NUMBER,

Line 889: SELECT 1 from dual where exists (

885: WHERE obj_lgl_ctnt_id = p_lgl_ctnt_id);
886:
887: CURSOR lgl_ctnt_version_cur( p_lgl_ctnt_id IN NUMBER,
888: p_object_version_number IN NUMBER ) IS
889: SELECT 1 from dual where exists (
890: select obj_lgl_ctnt_id FROM JTF_DSP_OBJ_LGL_CTNT
891: WHERE obj_lgl_ctnt_id = p_lgl_ctnt_id and
892: object_version_number = p_object_version_number);
893:

Line 956: SELECT 1 FROM dual WHERE EXISTS (

952: l_return_status BOOLEAN := FALSE;
953: l_exists NUMBER;
954:
955: CURSOR filename_cur( p_file_name IN VARCHAR2 ) IS
956: SELECT 1 FROM dual WHERE EXISTS (
957: SELECT file_name FROM JTF_AMV_ATTACHMENTS
958: WHERE file_name = p_file_name);
959:
960: CURSOR attachment_filename_cur(p_attachment_id IN NUMBER,

Line 962: SELECT 1 FROM dual WHERE EXISTS (

958: WHERE file_name = p_file_name);
959:
960: CURSOR attachment_filename_cur(p_attachment_id IN NUMBER,
961: p_file_name IN VARCHAR2) IS
962: SELECT 1 FROM dual WHERE EXISTS (
963: SELECT file_name FROM JTF_AMV_ATTACHMENTS
964: WHERE file_name = p_file_name and attachment_id <> p_attachment_id);
965:
966: l_dup_file_exception EXCEPTION;

Line 1036: SELECT 1 from dual where exists (

1032: l_return_status boolean := false;
1033: l_exists NUMBER;
1034:
1035: CURSOR msite_cur( p_msite_id IN NUMBER ) IS
1036: SELECT 1 from dual where exists (
1037: SELECT msite_id FROM JTF_MSITES_B where msite_id = p_msite_id);
1038: -- and
1039: -- end_date_active is null);
1040: --- sysdate between start_date_active and nvl(end_date_active,sysdate));

Line 1044: select 1 from dual where exists (

1040: --- sysdate between start_date_active and nvl(end_date_active,sysdate));
1041:
1042: CURSOR msite_version_cur( p_msite_id IN NUMBER,
1043: p_object_version_number IN NUMBER ) IS
1044: select 1 from dual where exists (
1045: SELECT msite_id FROM JTF_MSITES_B
1046: WHERE msite_id = p_msite_id
1047: and object_version_number = p_object_version_number);
1048: -- AND

Line 1116: SELECT 1 from dual where exists (

1112: l_return_status boolean := false;
1113: l_exists NUMBER;
1114:
1115: CURSOR lgl_phys_map_cur( p_lgl_phys_map_id IN NUMBER ) IS
1116: SELECT 1 from dual where exists (
1117: SELECT lgl_phys_map_id FROM JTF_DSP_LGL_PHYS_MAP
1118: where lgl_phys_map_id = p_lgl_phys_map_id);
1119:
1120: l_map_not_exists_exception EXCEPTION;

Line 1180: SELECT 1 FROM dual WHERE EXISTS (

1176: l_return_status boolean := false;
1177: l_exists NUMBER;
1178:
1179: CURSOR accessname_cur(p_access_name IN VARCHAR2 ) IS
1180: SELECT 1 FROM dual WHERE EXISTS (
1181: SELECT access_name FROM JTF_AMV_ITEMS_B
1182: WHERE access_name = p_access_name);
1183:
1184: CURSOR deliverable_accessname_cur(p_item_id IN NUMBER,

Line 1186: SELECT 1 FROM dual WHERE EXISTS (

1182: WHERE access_name = p_access_name);
1183:
1184: CURSOR deliverable_accessname_cur(p_item_id IN NUMBER,
1185: p_access_name IN VARCHAR2 ) IS
1186: SELECT 1 FROM dual WHERE EXISTS (
1187: SELECT access_name FROM JTF_AMV_ITEMS_B
1188: WHERE access_name = p_access_name AND item_id <> p_item_id);
1189:
1190: l_dup_access_exception EXCEPTION;

Line 1263: SELECT 1 from dual where exists (

1259: l_return_status boolean := false;
1260: l_exists NUMBER;
1261:
1262: CURSOR msite_lang_cur( p_msite_id IN NUMBER, p_language_code IN VARCHAR2 ) IS
1263: SELECT 1 from dual where exists (
1264: SELECT b.language_code FROM
1265: JTF_MSITES_B A, JTF_MSITE_LANGUAGES B where
1266: A.msite_id = p_msite_id and
1267: B.msite_id = A.msite_id and

Line 1318: SELECT 1 from dual where exists

1314: l_api_name CONSTANT VARCHAR2(40) := 'check_item_deliverable';
1315:
1316: CURSOR item_dlv_cur(p_item_id in NUMBER,
1317: p_deliverable_id IN NUMBER ) IS
1318: SELECT 1 from dual where exists
1319: (SELECT A.ITEM_ID from JTF_DSP_TPL_CTG A, MTL_ITEM_CATEGORIES B where
1320: B.INVENTORY_ITEM_ID = p_item_id and
1321: B.CATEGORY_ID = A.CATEGORY_ID AND
1322: A.ITEM_ID= p_deliverable_id );

Line 1378: SELECT 1 from dual where exists

1374: l_api_name CONSTANT VARCHAR2(40) := 'check_category_deliverable';
1375:
1376: CURSOR category_dlv_cur(p_category_id in NUMBER,
1377: p_deliverable_id IN NUMBER ) IS
1378: SELECT 1 from dual where exists
1379: (SELECT ITEM_ID from JTF_DSP_TPL_CTG where category_id = p_category_id and
1380: ITEM_ID= p_deliverable_id );
1381:
1382: l_return_status boolean := false;

Line 1545: SELECT 1 FROM DUAL WHERE EXISTS (

1541: l_api_name CONSTANT VARCHAR2(40) := 'check_attachment_deliverable';
1542:
1543: CURSOR attachment_cur(p_attachment_id IN NUMBER,
1544: p_deliverable_id IN NUMBER) IS
1545: SELECT 1 FROM DUAL WHERE EXISTS (
1546: SELECT attachment_used_by_id FROM JTF_AMV_ATTACHMENTS
1547: WHERE attachment_id = p_attachment_id
1548: AND attachment_used_by_id = p_deliverable_id);
1549:

Line 1595: SELECT 1 FROM DUAL WHERE EXISTS (

1591:
1592: l_api_name CONSTANT VARCHAR2(40) := 'check_default_attachment';
1593:
1594: CURSOR physmap_cur(p_attachment_id IN NUMBER) IS
1595: SELECT 1 FROM DUAL WHERE EXISTS (
1596: SELECT attachment_id FROM JTF_DSP_LGL_PHYS_MAP
1597: WHERE attachment_id = p_attachment_id
1598: AND default_site = 'Y'
1599: AND default_language = 'Y');