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_DEFN_B

Line 1712: SELECT INSTRUCTION_ID INTO L_PERM_INSTR_ID FROM GMO_INSTR_DEFN_B

1708: LOOP
1709: FETCH L_TEMP_INSTR_CHK_CSR INTO L_TEMP_INSTR_ID,L_TEMP_INSTR_SEQ;
1710: EXIT WHEN L_TEMP_INSTR_CHK_CSR%NOTFOUND;
1711: begin
1712: SELECT INSTRUCTION_ID INTO L_PERM_INSTR_ID FROM GMO_INSTR_DEFN_B
1713: WHERE INSTRUCTION_SET_ID = L_PERM_INSTRUCTION_SET_ID AND INSTR_SEQ = L_TEMP_INSTR_SEQ;
1714: exception
1715: when no_data_found then
1716: SELECT GMO_INSTR_DEFN_S.NEXTVAL INTO L_PERM_INSTR_ID FROM DUAL;

Line 1870: SELECT COUNT(*) INTO L_INSTR_COUNT FROM GMO_INSTR_DEFN_B

1866: -- for that set in the permanent table
1867: -- if yes update the instruction
1868: -- else insert it
1869:
1870: SELECT COUNT(*) INTO L_INSTR_COUNT FROM GMO_INSTR_DEFN_B
1871: WHERE INSTRUCTION_ID = L_TEMP_INSTR_DEFN_REC.INSTRUCTION_ID
1872: AND INSTRUCTION_SET_ID = L_TEMP_INSTR_DEFN_REC.INSTRUCTION_SET_ID;
1873:
1874: IF(L_INSTR_COUNT > 0) THEN

Line 1876: UPDATE GMO_INSTR_DEFN_B SET

1872: AND INSTRUCTION_SET_ID = L_TEMP_INSTR_DEFN_REC.INSTRUCTION_SET_ID;
1873:
1874: IF(L_INSTR_COUNT > 0) THEN
1875: --Bug 5224619: start
1876: UPDATE GMO_INSTR_DEFN_B SET
1877: INSTR_SEQ = L_INSTR_SEQ_COUNT,
1878: TASK_ID = L_TEMP_INSTR_DEFN_REC.TASK_ID,
1879: TASK_ATTRIBUTE_ID = L_TEMP_INSTR_DEFN_REC.TASK_ATTRIBUTE_ID,
1880: TASK_ATTRIBUTE = L_TEMP_INSTR_DEFN_REC.TASK_ATTRIBUTE,

Line 2056: AND INSTRUCTION_ID IN (SELECT INSTRUCTION_ID FROM GMO_INSTR_DEFN_B WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID)

2052: DELETE FROM GMO_INSTR_DEFN_TL
2053: WHERE INSTRUCTION_ID NOT IN
2054: ( SELECT INSTRUCTION_ID FROM GMO_INSTR_DEFN_T WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
2055: AND INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID)
2056: AND INSTRUCTION_ID IN (SELECT INSTRUCTION_ID FROM GMO_INSTR_DEFN_B WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID)
2057: AND LANGUAGE=USERENV('LANG');
2058:
2059: DELETE FROM GMO_INSTR_DEFN_B
2060: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID

Line 2059: DELETE FROM GMO_INSTR_DEFN_B

2055: AND INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID)
2056: AND INSTRUCTION_ID IN (SELECT INSTRUCTION_ID FROM GMO_INSTR_DEFN_B WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID)
2057: AND LANGUAGE=USERENV('LANG');
2058:
2059: DELETE FROM GMO_INSTR_DEFN_B
2060: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID
2061: AND INSTRUCTION_ID NOT IN
2062: ( SELECT INSTRUCTION_ID FROM GMO_INSTR_DEFN_T WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
2063: AND INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID);

Line 2104: (SELECT INSTRUCTION_ID FROM GMO_INSTR_DEFN_B

2100:
2101: -- First delete the approvers
2102: DELETE FROM GMO_INSTR_APPR_DEFN
2103: WHERE INSTRUCTION_ID IN
2104: (SELECT INSTRUCTION_ID FROM GMO_INSTR_DEFN_B
2105: WHERE INSTRUCTION_SET_ID = L_DEL_INSTR_SET_ID);
2106:
2107: -- Second remove the instructions
2108: --Bug 5224619: start

Line 2110: (SELECT INSTRUCTION_ID FROM GMO_INSTR_DEFN_B WHERE INSTRUCTION_SET_ID = L_DEL_INSTR_SET_ID) AND LANGUAGE=USERENV('LANG');

2106:
2107: -- Second remove the instructions
2108: --Bug 5224619: start
2109: DELETE FROM GMO_INSTR_DEFN_TL WHERE INSTRUCTION_ID IN
2110: (SELECT INSTRUCTION_ID FROM GMO_INSTR_DEFN_B WHERE INSTRUCTION_SET_ID = L_DEL_INSTR_SET_ID) AND LANGUAGE=USERENV('LANG');
2111:
2112: DELETE FROM GMO_INSTR_DEFN_B
2113: WHERE INSTRUCTION_SET_ID = L_DEL_INSTR_SET_ID;
2114:

Line 2112: DELETE FROM GMO_INSTR_DEFN_B

2108: --Bug 5224619: start
2109: DELETE FROM GMO_INSTR_DEFN_TL WHERE INSTRUCTION_ID IN
2110: (SELECT INSTRUCTION_ID FROM GMO_INSTR_DEFN_B WHERE INSTRUCTION_SET_ID = L_DEL_INSTR_SET_ID) AND LANGUAGE=USERENV('LANG');
2111:
2112: DELETE FROM GMO_INSTR_DEFN_B
2113: WHERE INSTRUCTION_SET_ID = L_DEL_INSTR_SET_ID;
2114:
2115: -- Finally remove the instruction set from table
2116: DELETE FROM GMO_INSTR_SET_DEFN_TL

Line 6146: X_from_entity_name => 'GMO_INSTR_DEFN_B',

6142: l_task_label
6143: );
6144:
6145: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments (
6146: X_from_entity_name => 'GMO_INSTR_DEFN_B',
6147: X_from_pk1_value => l_instruction_id,
6148: X_from_pk2_value => NULL,
6149: X_from_pk3_value => NULL,
6150: X_from_pk4_value => NULL,

Line 6423: from gmo_instr_defn_b

6419: if (l_instruction_process_id is null or l_instruction_process_id = -1) then
6420: --if process is not valid check permanent tables
6421: --we are not using any specific entity, so it will take care of all levels
6422: select count(*) into l_count
6423: from gmo_instr_defn_b
6424: where task_attribute_id like l_check_attribute;
6425:
6426: l_total_count := l_count;
6427:

Line 6440: from gmo_instr_defn_b

6436: --now check permanent tables for the attribute usage
6437: --for all instructions not in current process
6438:
6439: select count(*) into l_count
6440: from gmo_instr_defn_b
6441: where task_attribute_id like l_check_attribute
6442: and instruction_set_id not in (select instruction_set_id from gmo_instr_set_defn_t where instruction_process_id = l_instruction_process_id);
6443:
6444: l_total_count := l_total_count + l_count;