APPS.JTF_AMV_ATTACHMENT_PUB dependencies on JTF_AMV_ITEMS_B

Line 332: FROM jtf_amv_items_b

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
332: FROM jtf_amv_items_b
333: WHERE item_id = p_item_id;
334: l_deli_type_code VARCHAR2(40);
335: --
336: BEGIN

Line 528: update jtf_amv_items_b

524: l_act_attachment_rec.secured_flag,
525: l_act_attachment_rec.attachment_sub_type
526: );
527: IF (l_act_attachment_rec.attachment_used_by = G_USED_BY_ITEM) THEN
528: update jtf_amv_items_b
529: set last_update_date = sysdate,
530: last_updated_by = FND_GLOBAL.user_id,
531: last_update_login = FND_GLOBAL.conc_login_id
532: where item_id = l_act_attachment_rec.attachment_used_by_id ;

Line 701: FROM jtf_amv_items_b

697: l_return_status VARCHAR2(1);
698: --
699: CURSOR c_get_deli_type_code(p_item_id IN NUMBER) IS
700: SELECT deliverable_type_code
701: FROM jtf_amv_items_b
702: WHERE item_id = p_item_id;
703: l_deli_type_code VARCHAR2(40);
704: --
705: BEGIN

Line 852: update jtf_amv_items_b

848: RAISE FND_API.g_exc_error;
849: END IF;
850:
851: IF (l_act_attachment_rec.attachment_used_by = G_USED_BY_ITEM) THEN
852: update jtf_amv_items_b
853: set last_update_date = sysdate,
854: last_updated_by = FND_GLOBAL.user_id,
855: last_update_login = FND_GLOBAL.conc_login_id
856: where item_id = l_act_attachment_rec.attachment_used_by_id;