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 3803: UPDATE GMO_INSTR_INSTANCE_T

3799:
3800: IF(L_INSTR_STATUS = GMO_CONSTANTS_GRP.G_INSTR_STATUS_DONE ) THEN
3801: L_INSTR_STATUS := GMO_CONSTANTS_GRP.G_INSTR_STATUS_COMPLETE;
3802:
3803: UPDATE GMO_INSTR_INSTANCE_T
3804: SET INSTR_STATUS = L_INSTR_STATUS
3805: WHERE INSTR_STATUS = GMO_CONSTANTS_GRP.G_INSTR_STATUS_DONE
3806: AND INSTRUCTION_ID = L_INSTR_REC.INSTRUCTION_ID;
3807:

Line 3809: UPDATE GMO_INSTR_INSTANCE_TL

3805: WHERE INSTR_STATUS = GMO_CONSTANTS_GRP.G_INSTR_STATUS_DONE
3806: AND INSTRUCTION_ID = L_INSTR_REC.INSTRUCTION_ID;
3807:
3808: --Bug 5224619: start
3809: UPDATE GMO_INSTR_INSTANCE_TL
3810: SET
3811: COMMENTS = L_INSTR_REC.COMMENTS,
3812: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
3813: LAST_UPDATED_BY = L_LAST_UPDATED_BY,

Line 4041: GMO_INSTR_INSTANCE_T INSTR_TEMP,

4037: END IF;
4038:
4039: SELECT INSTRN.INSTRUCTION_SET_ID INTO L_INSTRUCTION_SET_ID
4040: FROM
4041: GMO_INSTR_INSTANCE_T INSTR_TEMP,
4042: GMO_INSTR_INSTANCE_VL INSTRN
4043: WHERE
4044: INSTR_TEMP.INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
4045: AND INSTR_TEMP.INSTRUCTION_ID = P_INSTRUCTION_ID

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

4097: END IF;
4098:
4099: END LOOP;
4100:
4101: -- UPDATE THE PARAMETER IN GMO_INSTR_INSTANCE_T 'DISABLE_TASK' = 'Y' OR 'N'
4102: UPDATE GMO_INSTR_INSTANCE_T
4103: SET
4104: DISABLE_TASK = P_DISABLE_TASK
4105: WHERE

Line 4102: UPDATE GMO_INSTR_INSTANCE_T

4098:
4099: END LOOP;
4100:
4101: -- UPDATE THE PARAMETER IN GMO_INSTR_INSTANCE_T 'DISABLE_TASK' = 'Y' OR 'N'
4102: UPDATE GMO_INSTR_INSTANCE_T
4103: SET
4104: DISABLE_TASK = P_DISABLE_TASK
4105: WHERE
4106: INSTRUCTION_ID = P_INSTRUCTION_ID

Line 4138: UPDATE GMO_INSTR_INSTANCE_T

4134:
4135: -- Acknowledge the task by setting the task ackn status
4136: -- only if API is called by task application
4137: IF(P_MANUAL_ENTRY <> GMO_CONSTANTS_GRP.YES ) THEN
4138: UPDATE GMO_INSTR_INSTANCE_T
4139: SET TASK_ACKN_STATUS = GMO_CONSTANTS_GRP.G_INSTR_TASK_ACKN_STATUS,
4140: TASK_ACKN_DATE = L_CREATION_DATE
4141: WHERE INSTRUCTION_ID = P_INSTRUCTION_ID
4142: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;

Line 4336: UPDATE GMO_INSTR_INSTANCE_T

4332: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
4333:
4334: -- This must complete optional instructions in temp table for
4335: -- particular session
4336: UPDATE GMO_INSTR_INSTANCE_T
4337: SET
4338: INSTR_STATUS = GMO_CONSTANTS_GRP.G_INSTR_STATUS_DONE,
4339: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
4340: LAST_UPDATED_BY = L_LAST_UPDATED_BY,

Line 4562: UPDATE GMO_INSTR_INSTANCE_T

4558: X_LAST_UPDATED_BY => L_LAST_UPDATED_BY,
4559: X_LAST_UPDATE_LOGIN => L_LAST_UPDATE_LOGIN
4560: );
4561:
4562: UPDATE GMO_INSTR_INSTANCE_T
4563: SET
4564: OPERATOR_ACKN = P_OPERATOR_ACKN,
4565: COMMENTS = P_INSTR_COMMENTS,
4566: INSTR_STATUS = P_INSTR_STATUS,

Line 4818: INSERT INTO GMO_INSTR_INSTANCE_T

4814: EXIT WHEN L_INSTR_CSR%NOTFOUND;
4815:
4816: L_INSTRUCTION_ID := L_INSTR_REC.INSTRUCTION_ID;
4817:
4818: INSERT INTO GMO_INSTR_INSTANCE_T
4819: (
4820: INSTRUCTION_PROCESS_ID,
4821: INSTRUCTION_ID,
4822: COMMENTS,

Line 6296: FROM GMO_INSTR_INSTANCE_T INSTR,

6292: WHERE TK.INSTRUCTION_ID = INSTR.INSTRUCTION_ID) AS TASKS
6293: )
6294: )
6295: )
6296: FROM GMO_INSTR_INSTANCE_T INSTR,
6297: GMO_INSTR_INSTANCE_VL INSTRVL
6298: WHERE INSTR.INSTRUCTION_PROCESS_ID = INSTR_SET.INSTRUCTION_PROCESS_ID
6299: AND INSTR.INSTRUCTION_ID = INSTRVL.INSTRUCTION_ID) AS "INSTRUCTIONS")
6300: )