APPS.IBE_DSPMGRVALIDATION_GRP dependencies on JTF_AMV_ATTACHMENTS

Line 22: FROM JTF_AMV_ATTACHMENTS

18:
19: CURSOR attachment_cur( p_attachment_id IN NUMBER ) IS
20: -- SELECT attachment_used_by_id
21: SELECT 1
22: FROM JTF_AMV_ATTACHMENTS
23: WHERE attachment_id = p_attachment_id;
24:
25: CURSOR attachment_version_cur( p_attachment_id IN NUMBER ,
26: p_object_version_number IN NUMBER) IS

Line 29: FROM JTF_AMV_ATTACHMENTS

25: CURSOR attachment_version_cur( p_attachment_id IN NUMBER ,
26: p_object_version_number IN NUMBER) IS
27: -- SELECT attachment_used_by_id
28: SELECT 1
29: FROM JTF_AMV_ATTACHMENTS
30: WHERE attachment_id = p_attachment_id
31: AND object_version_number=p_object_version_number;
32:
33: l_exists NUMBER;

Line 97: SELECT attachment_used_by_id FROM JTF_AMV_ATTACHMENTS

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

Line 984: FROM JTF_AMV_ATTACHMENTS

980:
981: CURSOR filename_cur( p_file_name IN VARCHAR2 ) IS
982: -- SELECT file_name
983: SELECT 1
984: FROM JTF_AMV_ATTACHMENTS
985: WHERE file_name = p_file_name;
986:
987: CURSOR attachment_filename_cur(p_attachment_id IN NUMBER,
988: p_file_name IN VARCHAR2) IS

Line 991: FROM JTF_AMV_ATTACHMENTS

987: CURSOR attachment_filename_cur(p_attachment_id IN NUMBER,
988: p_file_name IN VARCHAR2) IS
989: -- SELECT file_name
990: SELECT 1
991: FROM JTF_AMV_ATTACHMENTS
992: WHERE file_name = p_file_name and attachment_id <> p_attachment_id;
993:
994: l_dup_file_exception EXCEPTION;
995:

Line 1495: SELECT attachment_id FROM JTF_AMV_ATTACHMENTS

1491: IS
1492: l_api_name CONSTANT VARCHAR2(40) := 'check_attachment_exists';
1493:
1494: CURSOR attachment_cur(p_file_name IN VARCHAR2) IS
1495: SELECT attachment_id FROM JTF_AMV_ATTACHMENTS
1496: WHERE file_name = p_file_name;
1497:
1498: l_attachment_id NUMBER := NULL;
1499:

Line 1531: SELECT attachment_id FROM JTF_AMV_ATTACHMENTS

1527: l_api_name CONSTANT VARCHAR2(40) := 'check_attachment_exists';
1528:
1529: /*bug 2665027
1530: CURSOR attachment_cur(p_deliverable_id IN NUMBER,p_file_id IN NUMBER,p_file_name IN VARCHAR2) IS
1531: SELECT attachment_id FROM JTF_AMV_ATTACHMENTS
1532: WHERE file_name = p_file_name AND
1533: file_id = p_file_id AND
1534: attachment_used_by_id = p_deliverable_id;
1535:

Line 1537: SELECT attachment_id FROM JTF_AMV_ATTACHMENTS

1533: file_id = p_file_id AND
1534: attachment_used_by_id = p_deliverable_id;
1535:
1536: CURSOR attachment_cur2(p_deliverable_id IN NUMBER,p_file_name IN VARCHAR2) IS
1537: SELECT attachment_id FROM JTF_AMV_ATTACHMENTS
1538: WHERE file_name = p_file_name AND
1539: file_id is null AND
1540: attachment_used_by_id = p_deliverable_id;
1541: */

Line 1545: FROM JTF_AMV_ATTACHMENTS jta,

1541: */
1542: --bug 2665027
1543: CURSOR attachment_cur(p_deliverable_id IN NUMBER,p_file_id IN NUMBER,p_file_name IN VARCHAR2) IS
1544: SELECT jta.attachment_id
1545: FROM JTF_AMV_ATTACHMENTS jta,
1546: JTF_AMV_ITEMS_B jtai,
1547: IBE_DSP_LGL_PHYS_MAP idlpm
1548: WHERE jta.file_name = p_file_name AND
1549: jta.file_id = p_file_id AND

Line 1556: FROM JTF_AMV_ATTACHMENTS jta,

1552: rownum=1;
1553:
1554: CURSOR attachment_cur2(p_deliverable_id IN NUMBER,p_file_name IN VARCHAR2) IS
1555: SELECT jta.attachment_id
1556: FROM JTF_AMV_ATTACHMENTS jta,
1557: JTF_AMV_ITEMS_B jtai,
1558: IBE_DSP_LGL_PHYS_MAP idlpm
1559: WHERE jta.file_name = p_file_name AND
1560: jta.file_id is null AND

Line 1605: FROM JTF_AMV_ATTACHMENTS

1601: CURSOR attachment_cur(p_attachment_id IN NUMBER,
1602: p_deliverable_id IN NUMBER) IS
1603: -- SELECT attachment_used_by_id
1604: SELECT 1
1605: FROM JTF_AMV_ATTACHMENTS
1606: WHERE attachment_id = p_attachment_id
1607: AND attachment_used_by_id = p_deliverable_id;
1608:
1609: l_exists NUMBER;