APPS.AMS_COPYELEMENTS_PVT dependencies on JTF_AMV_ATTACHMENTS

Line 1060: FROM jtf_amv_attachments

1056:
1057: CURSOR attachments_cur(p_doc_id IN NUMBER)
1058: IS
1059: SELECT *
1060: FROM jtf_amv_attachments
1061: WHERE attachment_used_by_id = p_src_act_id
1062: AND attachment_used_by = p_src_act_type
1063: AND document_id = p_doc_id
1064: -- added by soagrawa on 25-jan-2002 to copy content

Line 1176: -- Create jtf amv attachments

1172: p_errmsg,
1173: 'ERROR');
1174: END IF;
1175:
1176: -- Create jtf amv attachments
1177: OPEN attachments_cur(l_doc_att_rec.document_id) ;
1178: FETCH attachments_cur INTO attachments_rec ;
1179: CLOSE attachments_cur ;
1180:

Line 4152: FROM jtf_amv_attachments

4148:
4149: CURSOR attachments_cur
4150: IS
4151: SELECT *
4152: FROM jtf_amv_attachments
4153: WHERE attachment_used_by_id = p_src_act_id
4154: AND attachment_used_by = p_src_act_type
4155: AND (attachment_type IN ('WEB_TEXT' ,'WEB_IMAGE'));
4156:

Line 4182: -- Create jtf amv attachments

4178: );
4179: l_stmt_num := 1;
4180:
4181:
4182: -- Create jtf amv attachments
4183: FOR attachments_rec IN attachments_cur
4184: LOOP
4185: BEGIN
4186: