eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMO_INSTRUCTION_PVT dependencies on GMO_INSTR_INSTANCE_VL

Line 2507: INSERT INTO GMO_INSTR_INSTANCE_VL

2503: l_task_label := L_INSTR_DEFN_REC.TASK_LABEL;
2504: end if;
2505: --Bug 4730261: end
2506: -- INSERT INSTRNS FROM DEFN TABLE TO INSTANCE TABLE
2507: INSERT INTO GMO_INSTR_INSTANCE_VL
2508: (
2509: INSTRUCTION_ID,
2510: INSTRUCTION_SET_ID,
2511: INSTRUCTION_TEXT,

Line 2727: FROM GMO_INSTR_INSTANCE_VL

2723: CURSOR L_INSTR_CSR IS
2724: SELECT INSTRUCTION_ID, INSTRUCTION_SET_ID, INSTRUCTION_TEXT, INSTR_STATUS,
2725: COMMENTS, INSTR_NUMBER, INSTR_SEQ, OPERATOR_ACKN, INSTR_ACKN_TYPE, TASK_ID,
2726: TASK_ACKN_DATE, TASK_ACKN_STATUS, TASK_LABEL, TASK_ATTRIBUTE, TASK_ATTRIBUTE_ID
2727: FROM GMO_INSTR_INSTANCE_VL
2728: WHERE
2729: INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
2730:
2731: CURSOR L_INSTR_APPR_CSR IS

Line 2939: INSERT INTO GMO_INSTR_INSTANCE_VL

2935:
2936: SELECT GMO_INSTR_INSTANCE_S.NEXTVAL INTO L_NEW_INSTRUCTION_ID
2937: FROM DUAL;
2938:
2939: INSERT INTO GMO_INSTR_INSTANCE_VL
2940: (
2941: INSTRUCTION_ID,
2942: INSTRUCTION_SET_ID,
2943: INSTRUCTION_TEXT,

Line 3130: FROM GMO_INSTR_INSTANCE_VL WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;

3126: AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE
3127: AND INSTR_SET_STATUS <> GMO_CONSTANTS_GRP.G_INSTR_STATUS_CANCEL;
3128:
3129: SELECT COUNT(INSTRUCTION_ID) INTO L_INSTR_COUNT
3130: FROM GMO_INSTR_INSTANCE_VL WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
3131:
3132: IF (L_INSTR_COUNT > 0) THEN
3133: SELECT COUNT(INSTRUCTION_ID) INTO L_INSTR_COUNT
3134: FROM GMO_INSTR_INSTANCE_VL WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID

Line 3134: FROM GMO_INSTR_INSTANCE_VL WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID

3130: FROM GMO_INSTR_INSTANCE_VL WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
3131:
3132: IF (L_INSTR_COUNT > 0) THEN
3133: SELECT COUNT(INSTRUCTION_ID) INTO L_INSTR_COUNT
3134: FROM GMO_INSTR_INSTANCE_VL WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID
3135: AND ( INSTR_STATUS = GMO_CONSTANTS_GRP.G_INSTR_STATUS_PENDING
3136: OR INSTR_STATUS = GMO_CONSTANTS_GRP.G_INSTR_STATUS_DONE );
3137:
3138: IF (L_INSTR_COUNT > 0) THEN

Line 3412: FROM GMO_INSTR_INSTANCE_VL

3408: AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE
3409: AND INSTR_SET_STATUS <> GMO_CONSTANTS_GRP.G_INSTR_STATUS_CANCEL;
3410:
3411: SELECT COUNT(INSTRUCTION_ID) INTO L_TOTAL_INSTRUCTIONS
3412: FROM GMO_INSTR_INSTANCE_VL
3413: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
3414:
3415: SELECT COUNT(INSTRUCTION_ID) INTO L_OPTIONAL_PENDING_INSTR
3416: FROM GMO_INSTR_INSTANCE_VL

Line 3416: FROM GMO_INSTR_INSTANCE_VL

3412: FROM GMO_INSTR_INSTANCE_VL
3413: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
3414:
3415: SELECT COUNT(INSTRUCTION_ID) INTO L_OPTIONAL_PENDING_INSTR
3416: FROM GMO_INSTR_INSTANCE_VL
3417: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID
3418: AND INSTR_STATUS = GMO_CONSTANTS_GRP.G_INSTR_STATUS_PENDING
3419: AND ( INSTR_ACKN_TYPE = L_INSTR_OPTIONAL );
3420:

Line 3422: FROM GMO_INSTR_INSTANCE_VL

3418: AND INSTR_STATUS = GMO_CONSTANTS_GRP.G_INSTR_STATUS_PENDING
3419: AND ( INSTR_ACKN_TYPE = L_INSTR_OPTIONAL );
3420:
3421: SELECT COUNT(INSTRUCTION_ID) INTO L_MANDATORY_PENDING_INSTR
3422: FROM GMO_INSTR_INSTANCE_VL
3423: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID
3424: AND INSTR_STATUS = GMO_CONSTANTS_GRP.G_INSTR_STATUS_PENDING
3425: AND ( INSTR_ACKN_TYPE = L_INSTR_MANDATORY OR INSTR_ACKN_TYPE = L_INSTR_PROCEED_ALLOWED);
3426:

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 4064: GMO_INSTR_INSTANCE_VL INSTRN

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
4068: AND INSTR_TEMP.INSTRUCTION_ID = INSTRN.INSTRUCTION_ID;

Line 4767: FROM GMO_INSTR_INSTANCE_VL

4763: CURSOR L_INSTR_CSR IS
4764: SELECT INSTRUCTION_ID, INSTRUCTION_SET_ID,
4765: COMMENTS, OPERATOR_ACKN, INSTR_STATUS,
4766: TASK_ACKN_STATUS, TASK_ID
4767: FROM GMO_INSTR_INSTANCE_VL
4768: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
4769:
4770: CURSOR L_INSTR_TASK_CSR IS
4771: SELECT INSTRUCTION_ID, INSTR_TASK_SEQ, TASK_EREC_ID,

Line 6320: GMO_INSTR_INSTANCE_VL INSTRVL

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: )
6324: )