APPS.GMO_INSTRUCTION_PVT dependencies on GMO_INSTR_INSTANCE_T

Line 3546: FROM GMO_INSTR_INSTANCE_T

3542: L_INSTR_OPTIONAL := GMO_CONSTANTS_GRP.G_INSTR_OPTIONAL;
3543: L_INSTR_PROCEED_ALLOWED := GMO_CONSTANTS_GRP.G_INSTR_PROCEED_ALLOWED;
3544:
3545: SELECT COUNT(INSTRUCTION_ID) INTO L_TOTAL_INSTRUCTIONS
3546: FROM GMO_INSTR_INSTANCE_T
3547: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
3548:
3549: SELECT COUNT(TEMP.INSTRUCTION_ID) INTO L_OPTIONAL_PENDING_INSTR
3550: FROM GMO_INSTR_INSTANCE_T TEMP, GMO_INSTR_INSTANCE_VL PERM

Line 3550: FROM GMO_INSTR_INSTANCE_T TEMP, GMO_INSTR_INSTANCE_VL PERM

3546: FROM GMO_INSTR_INSTANCE_T
3547: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
3548:
3549: SELECT COUNT(TEMP.INSTRUCTION_ID) INTO L_OPTIONAL_PENDING_INSTR
3550: FROM GMO_INSTR_INSTANCE_T TEMP, GMO_INSTR_INSTANCE_VL PERM
3551: WHERE TEMP.INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
3552: AND TEMP.INSTR_STATUS = GMO_CONSTANTS_GRP.G_INSTR_STATUS_PENDING
3553: AND TEMP.INSTRUCTION_ID = PERM.INSTRUCTION_ID
3554: AND ( PERM.INSTR_ACKN_TYPE = L_INSTR_OPTIONAL);

Line 3557: FROM GMO_INSTR_INSTANCE_VL PERM, GMO_INSTR_INSTANCE_T TEMP

3553: AND TEMP.INSTRUCTION_ID = PERM.INSTRUCTION_ID
3554: AND ( PERM.INSTR_ACKN_TYPE = L_INSTR_OPTIONAL);
3555:
3556: SELECT COUNT(TEMP.INSTRUCTION_ID) INTO L_MANDATORY_PENDING_INSTR
3557: FROM GMO_INSTR_INSTANCE_VL PERM, GMO_INSTR_INSTANCE_T TEMP
3558: WHERE TEMP.INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
3559: AND TEMP.INSTR_STATUS = GMO_CONSTANTS_GRP.G_INSTR_STATUS_PENDING
3560: AND TEMP.INSTRUCTION_ID = PERM.INSTRUCTION_ID
3561: AND ( PERM.INSTR_ACKN_TYPE = L_INSTR_MANDATORY OR PERM.INSTR_ACKN_TYPE = L_INSTR_PROCEED_ALLOWED);

Line 3680: FROM GMO_INSTR_INSTANCE_T TEMP, GMO_INSTR_INSTANCE_VL PERM

3676: CURSOR L_TEMP_INSTR_CSR IS
3677: SELECT TEMP.INSTRUCTION_PROCESS_ID, TEMP.INSTRUCTION_ID, PERM.INSTRUCTION_SET_ID,
3678: TEMP.COMMENTS, TEMP.OPERATOR_ACKN, TEMP.INSTR_STATUS,
3679: TEMP.TASK_ACKN_STATUS, TEMP.TASK_ACKN_DATE, TEMP.DISABLE_TASK
3680: FROM GMO_INSTR_INSTANCE_T TEMP, GMO_INSTR_INSTANCE_VL PERM
3681: WHERE PERM.INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID
3682: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
3683: AND PERM.INSTRUCTION_ID = TEMP.INSTRUCTION_ID FOR UPDATE;
3684:

Line 3824: UPDATE GMO_INSTR_INSTANCE_T

3820:
3821: IF(L_INSTR_STATUS = GMO_CONSTANTS_GRP.G_INSTR_STATUS_DONE ) THEN
3822: L_INSTR_STATUS := GMO_CONSTANTS_GRP.G_INSTR_STATUS_COMPLETE;
3823:
3824: UPDATE GMO_INSTR_INSTANCE_T
3825: SET INSTR_STATUS = L_INSTR_STATUS
3826: WHERE INSTR_STATUS = GMO_CONSTANTS_GRP.G_INSTR_STATUS_DONE
3827: AND INSTRUCTION_ID = L_INSTR_REC.INSTRUCTION_ID;
3828:

Line 3830: UPDATE GMO_INSTR_INSTANCE_TL

3826: WHERE INSTR_STATUS = GMO_CONSTANTS_GRP.G_INSTR_STATUS_DONE
3827: AND INSTRUCTION_ID = L_INSTR_REC.INSTRUCTION_ID;
3828:
3829: --Bug 5224619: start
3830: UPDATE GMO_INSTR_INSTANCE_TL
3831: SET
3832: COMMENTS = L_INSTR_REC.COMMENTS,
3833: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
3834: LAST_UPDATED_BY = L_LAST_UPDATED_BY,

Line 4063: GMO_INSTR_INSTANCE_T INSTR_TEMP,

4059: END IF;
4060:
4061: SELECT INSTRN.INSTRUCTION_SET_ID INTO L_INSTRUCTION_SET_ID
4062: FROM
4063: GMO_INSTR_INSTANCE_T INSTR_TEMP,
4064: GMO_INSTR_INSTANCE_VL INSTRN
4065: WHERE
4066: INSTR_TEMP.INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
4067: AND INSTR_TEMP.INSTRUCTION_ID = P_INSTRUCTION_ID

Line 4123: -- UPDATE THE PARAMETER IN GMO_INSTR_INSTANCE_T 'DISABLE_TASK' = 'Y' OR 'N'

4119: END IF;
4120:
4121: END LOOP;
4122:
4123: -- UPDATE THE PARAMETER IN GMO_INSTR_INSTANCE_T 'DISABLE_TASK' = 'Y' OR 'N'
4124: UPDATE GMO_INSTR_INSTANCE_T
4125: SET
4126: DISABLE_TASK = P_DISABLE_TASK
4127: WHERE

Line 4124: UPDATE GMO_INSTR_INSTANCE_T

4120:
4121: END LOOP;
4122:
4123: -- UPDATE THE PARAMETER IN GMO_INSTR_INSTANCE_T 'DISABLE_TASK' = 'Y' OR 'N'
4124: UPDATE GMO_INSTR_INSTANCE_T
4125: SET
4126: DISABLE_TASK = P_DISABLE_TASK
4127: WHERE
4128: INSTRUCTION_ID = P_INSTRUCTION_ID

Line 4160: UPDATE GMO_INSTR_INSTANCE_T

4156:
4157: -- Acknowledge the task by setting the task ackn status
4158: -- only if API is called by task application
4159: IF(P_MANUAL_ENTRY <> GMO_CONSTANTS_GRP.YES ) THEN
4160: UPDATE GMO_INSTR_INSTANCE_T
4161: SET TASK_ACKN_STATUS = GMO_CONSTANTS_GRP.G_INSTR_TASK_ACKN_STATUS,
4162: TASK_ACKN_DATE = L_CREATION_DATE
4163: WHERE INSTRUCTION_ID = P_INSTRUCTION_ID
4164: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;

Line 4358: UPDATE GMO_INSTR_INSTANCE_T

4354: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
4355:
4356: -- This must complete optional instructions in temp table for
4357: -- particular session
4358: UPDATE GMO_INSTR_INSTANCE_T
4359: SET
4360: INSTR_STATUS = GMO_CONSTANTS_GRP.G_INSTR_STATUS_DONE,
4361: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
4362: LAST_UPDATED_BY = L_LAST_UPDATED_BY,

Line 4584: UPDATE GMO_INSTR_INSTANCE_T

4580: X_LAST_UPDATED_BY => L_LAST_UPDATED_BY,
4581: X_LAST_UPDATE_LOGIN => L_LAST_UPDATE_LOGIN
4582: );
4583:
4584: UPDATE GMO_INSTR_INSTANCE_T
4585: SET
4586: OPERATOR_ACKN = P_OPERATOR_ACKN,
4587: COMMENTS = P_INSTR_COMMENTS,
4588: INSTR_STATUS = P_INSTR_STATUS,

Line 4840: INSERT INTO GMO_INSTR_INSTANCE_T

4836: EXIT WHEN L_INSTR_CSR%NOTFOUND;
4837:
4838: L_INSTRUCTION_ID := L_INSTR_REC.INSTRUCTION_ID;
4839:
4840: INSERT INTO GMO_INSTR_INSTANCE_T
4841: (
4842: INSTRUCTION_PROCESS_ID,
4843: INSTRUCTION_ID,
4844: COMMENTS,

Line 6319: FROM GMO_INSTR_INSTANCE_T INSTR,

6315: WHERE TK.INSTRUCTION_ID = INSTR.INSTRUCTION_ID) AS TASKS
6316: )
6317: )
6318: )
6319: FROM GMO_INSTR_INSTANCE_T INSTR,
6320: GMO_INSTR_INSTANCE_VL INSTRVL
6321: WHERE INSTR.INSTRUCTION_PROCESS_ID = INSTR_SET.INSTRUCTION_PROCESS_ID
6322: AND INSTR.INSTRUCTION_ID = INSTRVL.INSTRUCTION_ID) AS "INSTRUCTIONS")
6323: )