APPS.GMO_INSTRUCTION_PVT dependencies on GMO_INSTR_SET_INSTANCE_B

Line 21: cursor c_get_entity_key is select entity_key from gmo_instr_set_instance_b where instruction_set_id = P_INSTRUCTION_SET_ID;

17: l_param_table FND_WF_EVENT.Param_Table;
18: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
19:
20: l_entity_key varchar2(500);
21: cursor c_get_entity_key is select entity_key from gmo_instr_set_instance_b where instruction_set_id = P_INSTRUCTION_SET_ID;
22:
23: BEGIN
24:
25: if (P_INSTRUCTION_SET_ID is not null and P_INSTRUCTION_SET_ID <> -1 ) THEN

Line 2720: FROM GMO_INSTR_SET_INSTANCE_B

2716: SELECT INSTRUCTION_SET_ID, INSTRUCTION_TYPE, ENTITY_NAME, ENTITY_KEY,
2717: INSTR_SET_NAME, INSTR_SET_DESC, ACKN_STATUS, ORIG_SOURCE, ORIG_SOURCE_ID
2718: FROM GMO_INSTR_SET_INSTANCE_VL
2719: WHERE INSTRUCTION_SET_ID = (SELECT MAX(INSTRUCTION_SET_ID)
2720: FROM GMO_INSTR_SET_INSTANCE_B
2721: WHERE ENTITY_NAME = P_SOURCE_ENTITY_NAME AND ENTITY_KEY = P_SOURCE_ENTITY_KEY AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE);
2722:
2723: CURSOR L_INSTR_CSR IS
2724: SELECT INSTRUCTION_ID, INSTRUCTION_SET_ID, INSTRUCTION_TEXT, INSTR_STATUS,

Line 2782: FROM GMO_INSTR_SET_INSTANCE_B

2778: SELECT INSTRUCTION_SET_ID, INSTR_SET_STATUS
2779: INTO L_INSTRUCTION_SET_ID, L_INSTR_SET_STATUS
2780: FROM GMO_INSTR_SET_INSTANCE_VL
2781: WHERE INSTRUCTION_SET_ID = (SELECT MAX(INSTRUCTION_SET_ID)
2782: FROM GMO_INSTR_SET_INSTANCE_B
2783: WHERE ENTITY_NAME = P_SOURCE_ENTITY_NAME AND ENTITY_KEY = P_SOURCE_ENTITY_KEY AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE);
2784:
2785: -- if the instruction instance already exist for the given
2786: -- target entity name and entity_key, it will exist

Line 3749: UPDATE GMO_INSTR_SET_INSTANCE_B

3745: IF (P_ENTITY_KEY IS NOT NULL) THEN
3746:
3747: IF(L_ENTITY_KEY LIKE (GMO_CONSTANTS_GRP.G_INSTR_PREFIX || '%' )) THEN
3748: --Bug 5224619: start
3749: UPDATE GMO_INSTR_SET_INSTANCE_B
3750: SET ENTITY_KEY = P_ENTITY_KEY
3751: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
3752: --Bug 5224619: end
3753:

Line 3802: UPDATE GMO_INSTR_SET_INSTANCE_B

3798:
3799: if (l_set_active > 0) then
3800: --Bug 4730261: end
3801: --Bug 5224619: start
3802: UPDATE GMO_INSTR_SET_INSTANCE_B
3803: SET
3804: ACKN_STATUS = GMO_CONSTANTS_GRP.G_INSTR_SET_ACKN_STATUS,
3805: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
3806: LAST_UPDATED_BY = L_LAST_UPDATED_BY,

Line 3948: UPDATE GMO_INSTR_SET_INSTANCE_B

3944:
3945: -- Set the Instruction set status to complete
3946: IF(L_INSTRUCTION_COUNT = 0) THEN
3947: --Bug 5224619: start
3948: UPDATE GMO_INSTR_SET_INSTANCE_B
3949: SET INSTR_SET_STATUS = GMO_CONSTANTS_GRP.G_PROCESS_COMPLETE
3950: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
3951: --Bug 5224619: end
3952: END IF;

Line 4145: UPDATE GMO_INSTR_SET_INSTANCE_B

4141: -- UPDATE IT
4142: IF (L_ENTITY_KEY LIKE ( GMO_CONSTANTS_GRP.G_INSTR_PREFIX || '%')
4143: AND P_ENTITY_KEY IS NOT NULL) THEN
4144: --Bug 5224619: start
4145: UPDATE GMO_INSTR_SET_INSTANCE_B
4146: SET ENTITY_KEY = P_ENTITY_KEY
4147: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
4148: --Bug 5224619: end
4149:

Line 4283: UPDATE GMO_INSTR_SET_INSTANCE_B

4279: AND INSTR_SET_STATUS <> GMO_CONSTANTS_GRP.G_INSTR_STATUS_CANCEL;
4280:
4281: --Set the instruction set status to CANCEL
4282: --Bug 5224619: start
4283: UPDATE GMO_INSTR_SET_INSTANCE_B
4284: SET
4285: INSTR_SET_STATUS = GMO_CONSTANTS_GRP.G_INSTR_STATUS_CANCEL
4286: WHERE
4287: INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;

Line 4757: FROM GMO_INSTR_SET_INSTANCE_B

4753: L_INSTRUCTION_ID NUMBER;
4754:
4755: CURSOR L_INSTR_SET_CSR IS
4756: SELECT INSTRUCTION_SET_ID, ACKN_STATUS
4757: FROM GMO_INSTR_SET_INSTANCE_B
4758: WHERE ENTITY_NAME = P_ENTITY_NAME
4759: AND nvl(ENTITY_KEY,1) = nvl(P_ENTITY_KEY,1)
4760: AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE
4761: AND INSTR_SET_STATUS <> GMO_CONSTANTS_GRP.G_INSTR_STATUS_CANCEL;