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_SET_INSTANCE_VL

Line 2389: FROM GMO_INSTR_SET_INSTANCE_VL

2385: L_INSTANCE_ENTITY_KEY := GMO_CONSTANTS_GRP.G_INSTR_PREFIX || L_NEW_INSTRUCTION_SET_ID;
2386: ELSE
2387: BEGIN
2388: SELECT INSTRUCTION_SET_ID INTO L_INSTRUCTION_SET_ID
2389: FROM GMO_INSTR_SET_INSTANCE_VL
2390: WHERE
2391: ENTITY_NAME = P_INSTANCE_ENTITY_NAME
2392: AND nvl(ENTITY_KEY,1) = nvl(P_INSTANCE_ENTITY_KEY,1)
2393: AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE

Line 2427: INSERT INTO GMO_INSTR_SET_INSTANCE_VL

2423: FETCH L_INSTR_SET_DEFN_CSR INTO L_INSTR_SET_DEFN_REC;
2424: EXIT WHEN L_INSTR_SET_DEFN_CSR%NOTFOUND;
2425:
2426: --INSERT DATA FROM DEFN TABLE TO INSTANCE TABLE
2427: INSERT INTO GMO_INSTR_SET_INSTANCE_VL
2428: (
2429: INSTRUCTION_SET_ID,
2430: INSTRUCTION_TYPE,
2431: ENTITY_NAME,

Line 2718: FROM GMO_INSTR_SET_INSTANCE_VL

2714: --Bug 5013199: end
2715: CURSOR L_INSTR_SET_CSR IS
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:

Line 2780: FROM GMO_INSTR_SET_INSTANCE_VL

2776: -- nullified, if it is nullified, allow same entity
2777: -- key
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:

Line 2836: FROM GMO_INSTR_SET_INSTANCE_VL

2832: -- if the source and target entity key are different
2833: IF(P_TARGET_ENTITY_KEY IS NOT NULL AND P_SOURCE_ENTITY_KEY <> P_TARGET_ENTITY_KEY) THEN
2834: BEGIN
2835: SELECT INSTRUCTION_SET_ID INTO L_INSTRUCTION_SET_ID
2836: FROM GMO_INSTR_SET_INSTANCE_VL
2837: WHERE
2838: ENTITY_NAME = P_SOURCE_ENTITY_NAME
2839: AND ENTITY_KEY = P_TARGET_ENTITY_KEY
2840: AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE

Line 2869: INSERT INTO GMO_INSTR_SET_INSTANCE_VL

2865:
2866: SELECT GMO_INSTR_SET_INSTANCE_S.NEXTVAL INTO L_NEW_INSTRUCTION_SET_ID
2867: FROM DUAL;
2868:
2869: INSERT INTO GMO_INSTR_SET_INSTANCE_VL
2870: (
2871: INSTRUCTION_SET_ID,
2872: INSTRUCTION_TYPE,
2873: ENTITY_NAME,

Line 3113: FROM GMO_INSTR_SET_INSTANCE_VL

3109: RAISE L_ENTITY_ERR;
3110: END IF;
3111:
3112: SELECT COUNT(INSTRUCTION_SET_ID) INTO L_INSTR_SET_COUNT
3113: FROM GMO_INSTR_SET_INSTANCE_VL
3114: WHERE ENTITY_NAME = P_ENTITY_NAME
3115: AND nvl(ENTITY_KEY,1) = nvl(P_ENTITY_KEY,1)
3116: AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE
3117: AND INSTR_SET_STATUS <> GMO_CONSTANTS_GRP.G_INSTR_STATUS_CANCEL;

Line 3123: FROM GMO_INSTR_SET_INSTANCE_VL

3119: IF (L_INSTR_SET_COUNT = 0 ) THEN
3120: X_MODE := GMO_CONSTANTS_GRP.G_INSTR_INSTANCE_MODE_INSERT;
3121: ELSE
3122: SELECT INSTRUCTION_SET_ID INTO L_INSTRUCTION_SET_ID
3123: FROM GMO_INSTR_SET_INSTANCE_VL
3124: WHERE ENTITY_NAME = P_ENTITY_NAME
3125: AND nvl(ENTITY_KEY,1) = nvl(P_ENTITY_KEY,1)
3126: AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE
3127: AND INSTR_SET_STATUS <> GMO_CONSTANTS_GRP.G_INSTR_STATUS_CANCEL;

Line 3405: FROM GMO_INSTR_SET_INSTANCE_VL

3401: L_INSTR_PROCEED_ALLOWED := GMO_CONSTANTS_GRP.G_INSTR_PROCEED_ALLOWED;
3402:
3403: -- Check if the instruction set exists, get instruction set id
3404: SELECT INSTRUCTION_SET_ID INTO L_INSTRUCTION_SET_ID
3405: FROM GMO_INSTR_SET_INSTANCE_VL
3406: WHERE ENTITY_NAME = P_ENTITY_NAME
3407: AND nvl(ENTITY_KEY,1) = nvl(P_ENTITY_KEY,1)
3408: AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE
3409: AND INSTR_SET_STATUS <> GMO_CONSTANTS_GRP.G_INSTR_STATUS_CANCEL;

Line 3742: FROM GMO_INSTR_SET_INSTANCE_VL

3738: FROM GMO_INSTR_SET_INSTANCE_T
3739: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
3740:
3741: SELECT ENTITY_KEY INTO L_ENTITY_KEY
3742: FROM GMO_INSTR_SET_INSTANCE_VL
3743: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
3744:
3745: IF (P_ENTITY_KEY IS NOT NULL) THEN
3746:

Line 3795: select count(*) into l_set_active from gmo_instr_set_instance_vl

3791: EXIT WHEN L_TEMP_INSTR_SET_CSR%NOTFOUND;
3792:
3793: --Bug 4730261:start
3794: --update the instructions only when the set is active
3795: select count(*) into l_set_active from gmo_instr_set_instance_vl
3796: where instruction_set_id = L_INSTR_SET_REC.INSTRUCTION_SET_ID
3797: and instr_set_status = GMO_CONSTANTS_GRP.G_PROCESS_ACTIVE;
3798:
3799: if (l_set_active > 0) then

Line 4136: FROM GMO_INSTR_SET_INSTANCE_VL

4132: -- INSTRUCTION SET ID
4133:
4134: SELECT ENTITY_NAME, ENTITY_KEY
4135: INTO L_ENTITY_NAME, L_ENTITY_KEY
4136: FROM GMO_INSTR_SET_INSTANCE_VL
4137: WHERE
4138: INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
4139:
4140: -- IF THE ENTITY KEY IS internally set by PI while creation,

Line 4275: FROM GMO_INSTR_SET_INSTANCE_VL

4271:
4272: L_API_NAME := 'NULLIFY_INSTR_FOR_ENTITY';
4273:
4274: SELECT INSTRUCTION_SET_ID INTO L_INSTRUCTION_SET_ID
4275: FROM GMO_INSTR_SET_INSTANCE_VL
4276: WHERE ENTITY_NAME = P_ENTITY_NAME
4277: AND ENTITY_KEY = P_ENTITY_KEY
4278: AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE
4279: AND INSTR_SET_STATUS <> GMO_CONSTANTS_GRP.G_INSTR_STATUS_CANCEL;

Line 5026: FROM GMO_INSTR_SET_INSTANCE_VL

5022: BEGIN
5023:
5024: -- GET THE INSTRUCTION SET ID FROM INSTANCE INSTRUCTION SET TABLE
5025: SELECT MAX(INSTRUCTION_SET_ID) INTO L_INSTRUCTION_SET_ID
5026: FROM GMO_INSTR_SET_INSTANCE_VL
5027: WHERE ENTITY_NAME = P_ENTITY_NAME
5028: AND ENTITY_KEY = P_ENTITY_KEY
5029: AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE;
5030:

Line 5033: FROM GMO_INSTR_SET_INSTANCE_VL

5029: AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE;
5030:
5031: -- CHECK IF THE INSTRUCTION SET IS NULLIFIED
5032: SELECT INSTR_SET_STATUS INTO L_INSTR_SET_STATUS
5033: FROM GMO_INSTR_SET_INSTANCE_VL
5034: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
5035:
5036: -- CHECK THE INSTRUCTION SET STATUS, IT MUST BE ACTIVE
5037: -- FOR THE PROCESS TO PROCEED FURTHER

Line 5280: FROM GMO_INSTR_SET_INSTANCE_VL WHERE

5276:
5277: BEGIN
5278: SELECT INSTRUCTION_TYPE, ENTITY_NAME, ENTITY_KEY
5279: INTO L_INSTRUCTION_TYPE, L_ENTITY_NAME, L_ENTITY_KEY
5280: FROM GMO_INSTR_SET_INSTANCE_VL WHERE
5281: INSTRUCTION_SET_ID = P_INSTRUCTION_SET_ID;
5282: EXCEPTION
5283: WHEN NO_DATA_FOUND THEN
5284: ROLLBACK;

Line 6328: GMO_INSTR_SET_INSTANCE_VL INSTR_SETVL

6324: )
6325: )
6326: INTO L_INSTR_XML
6327: FROM GMO_INSTR_SET_INSTANCE_T INSTR_SET,
6328: GMO_INSTR_SET_INSTANCE_VL INSTR_SETVL
6329: WHERE INSTR_SET.INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
6330: AND INSTR_SETVL.INSTRUCTION_SET_ID = INSTR_SET.INSTRUCTION_SET_ID;
6331:
6332: --Return the CLOB value of the XML.