[Home] [Help]
338: order by checklist_item_id;
339:
340: CURSOR c_get_chklst_tl_rec (cv_program_id IN NUMBER) IS
341: SELECT tl.checklist_item_id, checklist_item_name, source_lang, language
342: FROM pv_ge_chklst_items_b b, pv_ge_chklst_items_tl tl
343: WHERE b.checklist_item_id = tl.checklist_item_id
344: AND b.arc_used_by_entity_code = 'PRGM'
345: AND b.used_by_entity_id = cv_program_id
346: order by tl.checklist_item_id;
488: end loop;
489:
490: Forall j in 1..old_checklist_item_id_array.count
491: --PVX_UTILITY_PVT.debug_message(l_api_name || 'insert into pv_checklist_items_tl');
492: INSERT INTO pv_ge_chklst_items_tl(
493: checklist_item_id,
494: language ,
495: last_update_date ,
496: last_updated_by ,