APPS.GMO_INSTRUCTION_PVT dependencies on GMO_INSTR_SET_DEFN_VL

Line 139: FROM GMO_INSTR_SET_DEFN_VL

135: CURSOR L_GMO_INSTR_SET_CSR IS
136: SELECT INSTRUCTION_SET_ID, INSTRUCTION_TYPE,
137: ENTITY_NAME, ENTITY_KEY, INSTR_SET_NAME,
138: INSTR_SET_DESC, ACKN_STATUS
139: FROM GMO_INSTR_SET_DEFN_VL
140: WHERE ENTITY_NAME = L_ENTITY_NAME
141: AND NVL(ENTITY_KEY,1) = NVL(L_ENTITY_KEY,1)
142: AND ACKN_STATUS = GMO_CONSTANTS_GRP.G_INSTR_SET_ACKN_STATUS;
143:

Line 1016: FROM GMO_INSTR_SET_DEFN_VL

1012: CURSOR L_INSTR_SET_DEFN_CSR IS
1013: SELECT INSTRUCTION_SET_ID, INSTRUCTION_TYPE,
1014: ENTITY_NAME, ENTITY_KEY, INSTR_SET_NAME,
1015: INSTR_SET_DESC, ACKN_STATUS
1016: FROM GMO_INSTR_SET_DEFN_VL
1017: WHERE
1018: ENTITY_NAME = P_SOURCE_ENTITY_NAME
1019: AND ENTITY_KEY = P_SOURCE_ENTITY_KEY
1020: AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE;

Line 1086: FROM GMO_INSTR_SET_DEFN_VL

1082: END IF;
1083:
1084: BEGIN
1085: SELECT INSTRUCTION_SET_ID INTO L_TARGET_INSTRUCTION_SET_ID
1086: FROM GMO_INSTR_SET_DEFN_VL
1087: WHERE ENTITY_NAME = P_SOURCE_ENTITY_NAME
1088: AND ENTITY_KEY = P_TARGET_ENTITY_KEY
1089: AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE;
1090:

Line 1112: INSERT INTO GMO_INSTR_SET_DEFN_VL

1108: SELECT GMO_INSTR_SET_DEFN_S.NEXTVAL INTO L_NEW_INSTRUCTION_SET_ID FROM DUAL;
1109:
1110: X_INSTRUCTION_SET_ID := L_NEW_INSTRUCTION_SET_ID;
1111:
1112: INSERT INTO GMO_INSTR_SET_DEFN_VL
1113: (
1114: INSTRUCTION_SET_ID,
1115: INSTRUCTION_TYPE,
1116: INSTR_SET_NAME,

Line 1773: INSERT INTO GMO_INSTR_SET_DEFN_VL

1769: WHERE INSTRUCTION_SET_ID = L_TEMP_INSTR_SET_DEFN_REC.INSTRUCTION_SET_ID;
1770: --Bug 5224619: end
1771:
1772: ELSE
1773: INSERT INTO GMO_INSTR_SET_DEFN_VL
1774: (
1775: INSTRUCTION_SET_ID,
1776: INSTRUCTION_TYPE,
1777: INSTR_SET_NAME,

Line 2297: FROM GMO_INSTR_SET_DEFN_VL

2293: CURSOR L_INSTR_SET_DEFN_CSR IS
2294: SELECT INSTRUCTION_SET_ID, INSTRUCTION_TYPE,
2295: ENTITY_NAME, ENTITY_KEY, INSTR_SET_NAME,
2296: INSTR_SET_DESC, ACKN_STATUS
2297: FROM GMO_INSTR_SET_DEFN_VL
2298: WHERE
2299: ENTITY_NAME = P_DEFINITION_ENTITY_NAME
2300: AND ENTITY_KEY = P_DEFINITION_ENTITY_KEY
2301: AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE

Line 3246: FROM GMO_INSTR_SET_DEFN_VL

3242: RAISE L_ENTITY_PARAM_ERR;
3243: END IF;
3244:
3245: SELECT INSTRUCTION_SET_ID INTO L_INSTRUCTION_SET_ID
3246: FROM GMO_INSTR_SET_DEFN_VL
3247: WHERE
3248: ENTITY_NAME = P_ENTITY_NAME
3249: AND nvl(ENTITY_KEY,1) = nvl(P_ENTITY_KEY,1)
3250: AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE;