APPS.GMO_INSTRUCTION_PVT dependencies on GMO_INSTR_INSTANCE_B

Line 3839: UPDATE GMO_INSTR_INSTANCE_B

3835: LAST_UPDATE_LOGIN = L_LAST_UPDATE_LOGIN
3836: WHERE
3837: INSTRUCTION_ID = L_INSTR_REC.INSTRUCTION_ID;
3838:
3839: UPDATE GMO_INSTR_INSTANCE_B
3840: SET
3841: OPERATOR_ACKN = L_INSTR_REC.OPERATOR_ACKN,
3842: TASK_ACKN_STATUS = L_INSTR_REC.TASK_ACKN_STATUS,
3843: TASK_ACKN_DATE = L_INSTR_REC.TASK_ACKN_DATE,

Line 3941: FROM GMO_INSTR_INSTANCE_B

3937: -- Bug 5231778 : update the Instructin Set Status before raising Event
3938: --Set the instruction set status to 'complete' if all the
3939: --instructions are complete in a given instruction set
3940: SELECT COUNT(*) INTO L_INSTRUCTION_COUNT
3941: FROM GMO_INSTR_INSTANCE_B
3942: WHERE INSTR_STATUS <> GMO_CONSTANTS_GRP.G_INSTR_STATUS_COMPLETE
3943: AND INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
3944:
3945: -- Set the Instruction set status to complete

Line 4368: SELECT INSTRUCTION_ID FROM GMO_INSTR_INSTANCE_B

4364: WHERE
4365: INSTR_STATUS = GMO_CONSTANTS_GRP.G_INSTR_STATUS_PENDING
4366: AND
4367: INSTRUCTION_ID IN (
4368: SELECT INSTRUCTION_ID FROM GMO_INSTR_INSTANCE_B
4369: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID
4370: AND INSTR_ACKN_TYPE = GMO_CONSTANTS_GRP.G_INSTR_OPTIONAL
4371: )
4372: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;