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 3743: UPDATE GMO_INSTR_SET_INSTANCE_B

3739: IF (P_ENTITY_KEY IS NOT NULL) THEN
3740:
3741: IF(L_ENTITY_KEY LIKE (GMO_CONSTANTS_GRP.G_INSTR_PREFIX || '%' )) THEN
3742: --Bug 5224619: start
3743: UPDATE GMO_INSTR_SET_INSTANCE_B
3744: SET ENTITY_KEY = P_ENTITY_KEY
3745: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
3746: --Bug 5224619: end
3747:

Line 3781: UPDATE GMO_INSTR_SET_INSTANCE_B

3777:
3778: if (l_set_active > 0) then
3779: --Bug 4730261: end
3780: --Bug 5224619: start
3781: UPDATE GMO_INSTR_SET_INSTANCE_B
3782: SET
3783: ACKN_STATUS = GMO_CONSTANTS_GRP.G_INSTR_SET_ACKN_STATUS,
3784: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
3785: LAST_UPDATED_BY = L_LAST_UPDATED_BY,

Line 3927: UPDATE GMO_INSTR_SET_INSTANCE_B

3923:
3924: -- Set the Instruction set status to complete
3925: IF(L_INSTRUCTION_COUNT = 0) THEN
3926: --Bug 5224619: start
3927: UPDATE GMO_INSTR_SET_INSTANCE_B
3928: SET INSTR_SET_STATUS = GMO_CONSTANTS_GRP.G_PROCESS_COMPLETE
3929: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
3930: --Bug 5224619: end
3931: END IF;

Line 4123: UPDATE GMO_INSTR_SET_INSTANCE_B

4119: -- UPDATE IT
4120: IF (L_ENTITY_KEY LIKE ( GMO_CONSTANTS_GRP.G_INSTR_PREFIX || '%')
4121: AND P_ENTITY_KEY IS NOT NULL) THEN
4122: --Bug 5224619: start
4123: UPDATE GMO_INSTR_SET_INSTANCE_B
4124: SET ENTITY_KEY = P_ENTITY_KEY
4125: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
4126: --Bug 5224619: end
4127:

Line 4261: UPDATE GMO_INSTR_SET_INSTANCE_B

4257: AND INSTR_SET_STATUS <> GMO_CONSTANTS_GRP.G_INSTR_STATUS_CANCEL;
4258:
4259: --Set the instruction set status to CANCEL
4260: --Bug 5224619: start
4261: UPDATE GMO_INSTR_SET_INSTANCE_B
4262: SET
4263: INSTR_SET_STATUS = GMO_CONSTANTS_GRP.G_INSTR_STATUS_CANCEL
4264: WHERE
4265: INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;

Line 4735: FROM GMO_INSTR_SET_INSTANCE_B

4731: L_INSTRUCTION_ID NUMBER;
4732:
4733: CURSOR L_INSTR_SET_CSR IS
4734: SELECT INSTRUCTION_SET_ID, ACKN_STATUS
4735: FROM GMO_INSTR_SET_INSTANCE_B
4736: WHERE ENTITY_NAME = P_ENTITY_NAME
4737: AND nvl(ENTITY_KEY,1) = nvl(P_ENTITY_KEY,1)
4738: AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE
4739: AND INSTR_SET_STATUS <> GMO_CONSTANTS_GRP.G_INSTR_STATUS_CANCEL;