APPS.JTF_DSPMGRVALIDATION_GRP dependencies on JTF_AMV_ATTACHMENTS

Line 21: SELECT attachment_used_by_id FROM JTF_AMV_ATTACHMENTS

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

Line 27: SELECT attachment_used_by_id FROM JTF_AMV_ATTACHMENTS

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

Line 95: SELECT attachment_used_by_id FROM JTF_AMV_ATTACHMENTS

91: IS
92: l_api_name CONSTANT VARCHAR2(40) := 'check_attachment_deliverable';
93:
94: CURSOR attachment_cur( p_attachment_id IN NUMBER ) IS
95: SELECT attachment_used_by_id FROM JTF_AMV_ATTACHMENTS
96: WHERE attachment_id = p_attachment_id;
97:
98: l_deliverable_id NUMBER;
99: l_ath_not_exists_exception EXCEPTION;

Line 957: SELECT file_name FROM JTF_AMV_ATTACHMENTS

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,
961: p_file_name IN VARCHAR2) IS

Line 963: SELECT file_name FROM JTF_AMV_ATTACHMENTS

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

Line 1461: SELECT attachment_id FROM JTF_AMV_ATTACHMENTS

1457: IS
1458: l_api_name CONSTANT VARCHAR2(40) := 'check_attachment_exists';
1459:
1460: CURSOR attachment_cur(p_file_name IN VARCHAR2) IS
1461: SELECT attachment_id FROM JTF_AMV_ATTACHMENTS
1462: WHERE file_name = p_file_name;
1463:
1464: l_attachment_id NUMBER := NULL;
1465:

Line 1496: SELECT attachment_id FROM JTF_AMV_ATTACHMENTS

1492: IS
1493: l_api_name CONSTANT VARCHAR2(40) := 'check_attachment_exists';
1494:
1495: CURSOR attachment_cur(p_deliverable_id IN NUMBER,p_file_id IN NUMBER,p_file_name IN VARCHAR2) IS
1496: SELECT attachment_id FROM JTF_AMV_ATTACHMENTS
1497: WHERE file_name = p_file_name AND
1498: file_id = p_file_id AND
1499: attachment_used_by_id = p_deliverable_id;
1500:

Line 1502: SELECT attachment_id FROM JTF_AMV_ATTACHMENTS

1498: file_id = p_file_id AND
1499: attachment_used_by_id = p_deliverable_id;
1500:
1501: CURSOR attachment_cur2(p_deliverable_id IN NUMBER,p_file_name IN VARCHAR2) IS
1502: SELECT attachment_id FROM JTF_AMV_ATTACHMENTS
1503: WHERE file_name = p_file_name AND
1504: file_id is null AND
1505: attachment_used_by_id = p_deliverable_id;
1506:

Line 1546: SELECT attachment_used_by_id FROM JTF_AMV_ATTACHMENTS

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