APPS.JTF_AMV_ATTACHMENT_PUB dependencies on JTF_AMV_ATTACHMENTS

Line 161: 'jtf_amv_attachments',

157: -- need to check if this attachment_id is unique.
158: IF p_validation_mode = JTF_PLSQL_API.g_create AND
159: p_act_attachment_rec.attachment_id IS NOT NULL THEN
160: IF check_uniqueness(
161: 'jtf_amv_attachments',
162: 'attachment_id = ' || p_act_attachment_rec.attachment_id
163: ) = FND_API.g_false THEN
164: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
165: FND_MESSAGE.set_name('JTF', 'JTF_AMV_ACT_ATTACH_DUPL_ID');

Line 322: SELECT jtf_amv_attachments_s.NEXTVAL

318: l_act_attachment_rec act_attachment_rec_type := p_act_attachment_rec;
319: l_act_attachment_count NUMBER;
320:
321: CURSOR c_act_attachment_seq IS
322: SELECT jtf_amv_attachments_s.NEXTVAL
323: FROM DUAL;
324:
325: CURSOR c_act_attachment_count(act_attachment_id IN NUMBER) IS
326: SELECT COUNT(*)

Line 327: FROM jtf_amv_attachments

323: FROM DUAL;
324:
325: CURSOR c_act_attachment_count(act_attachment_id IN NUMBER) IS
326: SELECT COUNT(*)
327: FROM jtf_amv_attachments
328: WHERE attachment_id = act_attachment_id;
329: --
330: CURSOR c_get_deli_type_code(p_item_id IN NUMBER) IS
331: SELECT deliverable_type_code

Line 418: INSERT INTO jtf_amv_attachments

414: END IF;
415: RAISE FND_API.G_EXC_ERROR;
416: END IF;
417: END IF;
418: INSERT INTO jtf_amv_attachments
419: (
420: attachment_id,
421: last_update_date,
422: last_updated_by,

Line 615: DELETE FROM jtf_amv_attachments

611: END IF;
612: x_return_status := FND_API.G_RET_STS_SUCCESS;
613:
614: ------------------------ delete ------------------------
615: DELETE FROM jtf_amv_attachments
616: WHERE attachment_id = p_act_attachment_id
617: AND object_version_number = p_object_version;
618:
619: IF (SQL%NOTFOUND) THEN

Line 789: UPDATE jtf_amv_attachments SET

785: RAISE FND_API.G_EXC_ERROR;
786: END IF;
787: END IF;
788: -------------------------- update --------------------
789: UPDATE jtf_amv_attachments SET
790: last_update_date = SYSDATE,
791: last_updated_by = FND_GLOBAL.user_id,
792: last_update_login = FND_GLOBAL.conc_login_id,
793: object_version_number = l_act_attachment_rec.object_version_number + 1,

Line 931: FROM jtf_amv_attachments

927: l_act_attachment_id NUMBER;
928:
929: CURSOR c_act_attachment IS
930: SELECT attachment_id
931: FROM jtf_amv_attachments
932: WHERE attachment_id = p_act_attachment_id
933: AND object_version_number = p_object_version
934: FOR UPDATE OF attachment_id NOWAIT;
935:

Line 1280: FROM jtf_amv_attachments

1276: x_complete_rec OUT NOCOPY act_attachment_rec_type
1277: ) AS
1278: CURSOR c_act_attachment IS
1279: SELECT *
1280: FROM jtf_amv_attachments
1281: WHERE attachment_id = p_act_attachment_rec.attachment_id;
1282:
1283: l_act_attachment_rec c_act_attachment%ROWTYPE;
1284: