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 3736: FROM GMO_INSTR_SET_INSTANCE_VL

3732: FROM GMO_INSTR_SET_INSTANCE_T
3733: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
3734:
3735: SELECT ENTITY_KEY INTO L_ENTITY_KEY
3736: FROM GMO_INSTR_SET_INSTANCE_VL
3737: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
3738:
3739: IF (P_ENTITY_KEY IS NOT NULL) THEN
3740:

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

3770: EXIT WHEN L_TEMP_INSTR_SET_CSR%NOTFOUND;
3771:
3772: --Bug 4730261:start
3773: --update the instructions only when the set is active
3774: select count(*) into l_set_active from gmo_instr_set_instance_vl
3775: where instruction_set_id = L_INSTR_SET_REC.INSTRUCTION_SET_ID
3776: and instr_set_status = GMO_CONSTANTS_GRP.G_PROCESS_ACTIVE;
3777:
3778: if (l_set_active > 0) then

Line 4114: FROM GMO_INSTR_SET_INSTANCE_VL

4110: -- INSTRUCTION SET ID
4111:
4112: SELECT ENTITY_NAME, ENTITY_KEY
4113: INTO L_ENTITY_NAME, L_ENTITY_KEY
4114: FROM GMO_INSTR_SET_INSTANCE_VL
4115: WHERE
4116: INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
4117:
4118: -- IF THE ENTITY KEY IS internally set by PI while creation,

Line 4253: FROM GMO_INSTR_SET_INSTANCE_VL

4249:
4250: L_API_NAME := 'NULLIFY_INSTR_FOR_ENTITY';
4251:
4252: SELECT INSTRUCTION_SET_ID INTO L_INSTRUCTION_SET_ID
4253: FROM GMO_INSTR_SET_INSTANCE_VL
4254: WHERE ENTITY_NAME = P_ENTITY_NAME
4255: AND ENTITY_KEY = P_ENTITY_KEY
4256: AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE
4257: AND INSTR_SET_STATUS <> GMO_CONSTANTS_GRP.G_INSTR_STATUS_CANCEL;

Line 5004: FROM GMO_INSTR_SET_INSTANCE_VL

5000: BEGIN
5001:
5002: -- GET THE INSTRUCTION SET ID FROM INSTANCE INSTRUCTION SET TABLE
5003: SELECT MAX(INSTRUCTION_SET_ID) INTO L_INSTRUCTION_SET_ID
5004: FROM GMO_INSTR_SET_INSTANCE_VL
5005: WHERE ENTITY_NAME = P_ENTITY_NAME
5006: AND ENTITY_KEY = P_ENTITY_KEY
5007: AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE;
5008:

Line 5011: FROM GMO_INSTR_SET_INSTANCE_VL

5007: AND INSTRUCTION_TYPE = P_INSTRUCTION_TYPE;
5008:
5009: -- CHECK IF THE INSTRUCTION SET IS NULLIFIED
5010: SELECT INSTR_SET_STATUS INTO L_INSTR_SET_STATUS
5011: FROM GMO_INSTR_SET_INSTANCE_VL
5012: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
5013:
5014: -- CHECK THE INSTRUCTION SET STATUS, IT MUST BE ACTIVE
5015: -- FOR THE PROCESS TO PROCEED FURTHER

Line 5258: FROM GMO_INSTR_SET_INSTANCE_VL WHERE

5254:
5255: BEGIN
5256: SELECT INSTRUCTION_TYPE, ENTITY_NAME, ENTITY_KEY
5257: INTO L_INSTRUCTION_TYPE, L_ENTITY_NAME, L_ENTITY_KEY
5258: FROM GMO_INSTR_SET_INSTANCE_VL WHERE
5259: INSTRUCTION_SET_ID = P_INSTRUCTION_SET_ID;
5260: EXCEPTION
5261: WHEN NO_DATA_FOUND THEN
5262: ROLLBACK;

Line 6305: GMO_INSTR_SET_INSTANCE_VL INSTR_SETVL

6301: )
6302: )
6303: INTO L_INSTR_XML
6304: FROM GMO_INSTR_SET_INSTANCE_T INSTR_SET,
6305: GMO_INSTR_SET_INSTANCE_VL INSTR_SETVL
6306: WHERE INSTR_SET.INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
6307: AND INSTR_SETVL.INSTRUCTION_SET_ID = INSTR_SET.INSTRUCTION_SET_ID;
6308:
6309: --Return the CLOB value of the XML.