APPS.JTF_DSPMGRVALIDATION_GRP dependencies on JTF_AMV_ITEMS_B

Line 731: SELECT item_id FROM JTF_AMV_ITEMS_B

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:
735: CURSOR deliverable_type_app_cur( p_deliverable_id IN NUMBER,

Line 738: SELECT item_id FROM JTF_AMV_ITEMS_B

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);
742:

Line 804: SELECT item_id FROM JTF_AMV_ITEMS_B

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,
808: p_object_version_number IN NUMBER ) IS

Line 810: SELECT item_id FROM JTF_AMV_ITEMS_B

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:
814: l_exists NUMBER;

Line 1181: SELECT access_name FROM JTF_AMV_ITEMS_B

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,
1185: p_access_name IN VARCHAR2 ) IS

Line 1187: SELECT access_name FROM JTF_AMV_ITEMS_B

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