APPS.GMO_INSTR_ENTITY_PVT dependencies on GMO_INSTR_DEFN_T

Line 435: cursor get_instr_details is select instruction_id, task_id, task_attribute_id from gmo_instr_defn_t where instruction_process_id = P_INSTRUCTION_PROCESS_ID and instruction_set_id=P_INSTRUCTION_SET_ID;

431: l_task_attribute_id varchar2(4000);
432: l_new_task_attribute_id varchar2(4000);
433: l_task_id number;
434:
435: cursor get_instr_details is select instruction_id, task_id, task_attribute_id from gmo_instr_defn_t where instruction_process_id = P_INSTRUCTION_PROCESS_ID and instruction_set_id=P_INSTRUCTION_SET_ID;
436:
437:
438: BEGIN
439: IF (P_SOURCE_ENTITY_KEY <> P_TARGET_ENTITY_KEY) THEN

Line 454: update gmo_instr_defn_t set task_attribute_id = l_new_task_attribute_id

450: P_TASK_ID => L_TASK_ID,
451: P_TASK_ATTRIBUTE_ID => L_TASK_ATTRIBUTE_ID
452: );
453:
454: update gmo_instr_defn_t set task_attribute_id = l_new_task_attribute_id
455: where instruction_process_id = P_INSTRUCTION_PROCESS_ID and instruction_id = l_instruction_id;
456: end if;
457:
458: end loop;