eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMO_INSTRUCTION_PVT dependencies on GMO_INSTR_TASK_DEFN_VL

Line 1184: select task_id into l_entity_task_id from gmo_instr_task_defn_vl

1180: -- get the correct task id for the new entity name and entity key
1181: l_entity_task_id := null;
1182: if (L_INSTR_DEFN_REC.TASK_ID is not null) then
1183:
1184: select task_id into l_entity_task_id from gmo_instr_task_defn_vl
1185: where entity_name = P_TARGET_ENTITY_NAME
1186: and GMO_INSTR_ENTITY_PVT.GET_ENTITYKEY_SEPARATOR_COUNT(entity_key_pattern) = GMO_INSTR_ENTITY_PVT.GET_ENTITYKEY_SEPARATOR_COUNT(P_TARGET_ENTITY_KEY)
1187: and instruction_type = P_INSTRUCTION_TYPE
1188: and task_name = (select task_name from gmo_instr_task_defn_b where task_id = L_INSTR_DEFN_REC.TASK_ID);

Line 2501: select display_name into l_task_label from gmo_instr_task_defn_vl where task_id = L_INSTR_DEFN_REC.TASK_ID;

2497: --Bug 4730261: start
2498: --if task id is available, and task label is not available, we
2499: --take the task display name and assign to task label.
2500: if (L_INSTR_DEFN_REC.TASK_ID is not null and trim(L_INSTR_DEFN_REC.TASK_LABEL) is null ) then
2501: select display_name into l_task_label from gmo_instr_task_defn_vl where task_id = L_INSTR_DEFN_REC.TASK_ID;
2502: else
2503: l_task_label := L_INSTR_DEFN_REC.TASK_LABEL;
2504: end if;
2505: --Bug 4730261: end

Line 3223: FROM GMO_INSTR_DEFN_VL INSTR_DEFN, GMO_INSTR_TASK_DEFN_VL TSK

3219: CURSOR L_INSTR_CSR IS
3220: SELECT INSTR_DEFN.INSTRUCTION_ID, INSTR_DEFN.INSTRUCTION_SET_ID,
3221: INSTR_DEFN.INSTRUCTION_TEXT,
3222: INSTR_DEFN.TASK_ATTRIBUTE, TSK.TASK_NAME, TSK.DISPLAY_NAME
3223: FROM GMO_INSTR_DEFN_VL INSTR_DEFN, GMO_INSTR_TASK_DEFN_VL TSK
3224: WHERE INSTR_DEFN.INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID
3225: AND INSTR_DEFN.TASK_ID = TSK.TASK_ID;
3226:
3227: L_INSTR_REC L_INSTR_CSR%ROWTYPE;

Line 5870: GMO_INSTR_TASK_DEFN_VL TK

5866: LK1.LOOKUP_CODE = INSTR.INSTR_ACKN_TYPE) AS INSTRUCTION_ACKN_TYPE,
5867: (SELECT
5868: TK.DISPLAY_NAME
5869: FROM
5870: GMO_INSTR_TASK_DEFN_VL TK
5871: WHERE
5872: TK.TASK_ID = INSTR.TASK_ID) AS TASK_NAME,
5873: INSTR.TASK_ATTRIBUTE AS TASK_ATTRIBUTE,
5874: INSTR.TASK_LABEL AS TASK_LABEL,

Line 6119: select max_allowed_task into l_maximum_allowed_task from GMO_INSTR_TASK_DEFN_VL

6115:
6116: if (l_instruction_id is not null) then
6117: -- task id is not null then check with maximum allowed task
6118: if(l_task_id IS NOT NULL) THEN
6119: select max_allowed_task into l_maximum_allowed_task from GMO_INSTR_TASK_DEFN_VL
6120: where task_id = l_task_id;
6121: open task_count_per_inst_set;
6122: fetch task_count_per_inst_set into l_task_count_per_inst_set;
6123: if(l_task_count_per_inst_set >= l_maximum_allowed_task) THEN