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_ATTRIBUTES_T

Line 58: UPDATE GMO_INSTR_ATTRIBUTES_T SET ENTITY_KEY = P_ENTITY_KEY

54: IS
55: PRAGMA AUTONOMOUS_TRANSACTION;
56: BEGIN
57: IF(P_INSTRUCTION_PROCESS_ID IS NOT NULL AND P_ENTITY_KEY IS NOT NULL) THEN
58: UPDATE GMO_INSTR_ATTRIBUTES_T SET ENTITY_KEY = P_ENTITY_KEY
59: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
60: AND ATTRIBUTE_NAME = GMO_CONSTANTS_GRP.G_PARAM_ENTITY;
61: END IF;
62:

Line 168: SELECT COUNT(*) FROM GMO_INSTR_ATTRIBUTES_T

164: L_ENTITY_EXIST_COUNT NUMBER;
165: L_INSTR_SET_EXIST_COUNT NUMBER;
166:
167: CURSOR L_IS_VALID_PROCESS_CSR IS
168: SELECT COUNT(*) FROM GMO_INSTR_ATTRIBUTES_T
169: WHERE INSTRUCTION_PROCESS_ID = P_CURR_INSTR_PROCESS_ID
170: AND ATTRIBUTE_NAME = GMO_CONSTANTS_GRP.G_PROCESS_STATUS
171: AND ATTRIBUTE_VALUE <> GMO_CONSTANTS_GRP.G_PROCESS_TERMINATE;
172:

Line 207: -- This API will create rows in GMO_INSTR_ATTRIBUTES_T table with

203:
204: -- If the process is valid, then proceed with creating the definition
205: -- context
206: IF (L_VALID_PROCESS = 0) THEN
207: -- This API will create rows in GMO_INSTR_ATTRIBUTES_T table with
208: -- name , value pairs for entity_name, entity_key and context parameters
209: -- to create a context for the definition of Process Instructions to start
210: SELECT GMO_INSTR_PROCESS_ID_S.NEXTVAL INTO L_INSTRUCTION_PROCESS_ID
211: FROM DUAL;

Line 214: INSERT INTO GMO_INSTR_ATTRIBUTES_T

210: SELECT GMO_INSTR_PROCESS_ID_S.NEXTVAL INTO L_INSTRUCTION_PROCESS_ID
211: FROM DUAL;
212:
213: --Insert 'MODE' = P_MODE
214: INSERT INTO GMO_INSTR_ATTRIBUTES_T
215: (
216: INSTRUCTION_PROCESS_ID,
217: ATTRIBUTE_SEQ,
218: ATTRIBUTE_NAME,

Line 230: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,

226: )
227: VALUES
228: (
229: L_INSTRUCTION_PROCESS_ID,
230: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,
231: GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE,
232: P_MODE,
233: GMO_CONSTANTS_GRP.G_PARAM_INTERNAL,
234: L_CREATION_DATE,

Line 245: INSERT INTO GMO_INSTR_ATTRIBUTES_T

241: -- Insert 'DEFINITION_STATUS' = 'NO_CHANGE'
242: -- If anything is modified in definition UI, this status
243: -- gets changed from G_STATUS_NO_CHANGE to G_STATUS_MODIFIED
244:
245: INSERT INTO GMO_INSTR_ATTRIBUTES_T
246: (
247: INSTRUCTION_PROCESS_ID,
248: ATTRIBUTE_SEQ,
249: ATTRIBUTE_NAME,

Line 261: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,

257: )
258: VALUES
259: (
260: L_INSTRUCTION_PROCESS_ID,
261: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,
262: GMO_CONSTANTS_GRP.G_DEFINITION_STATUS,
263: GMO_CONSTANTS_GRP.G_STATUS_NO_CHANGE,
264: GMO_CONSTANTS_GRP.G_PARAM_INTERNAL,
265: L_CREATION_DATE,

Line 280: INSERT INTO GMO_INSTR_ATTRIBUTES_T

276: -- PROCESS_STATUS = CANCEL
277: -- If the process is error, i.e. browser close,
278: -- PROCESS_STATUS = ERROR , remains as is
279:
280: INSERT INTO GMO_INSTR_ATTRIBUTES_T
281: (
282: INSTRUCTION_PROCESS_ID,
283: ATTRIBUTE_SEQ,
284: ATTRIBUTE_NAME,

Line 296: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,

292: )
293: VALUES
294: (
295: L_INSTRUCTION_PROCESS_ID,
296: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,
297: GMO_CONSTANTS_GRP.G_PROCESS_STATUS,
298: GMO_CONSTANTS_GRP.G_PROCESS_ERROR,
299: GMO_CONSTANTS_GRP.G_PARAM_INTERNAL,
300: L_CREATION_DATE,

Line 310: UPDATE GMO_INSTR_ATTRIBUTES_T

306: ELSE
307: L_INSTRUCTION_PROCESS_ID := P_CURR_INSTR_PROCESS_ID;
308:
309: -- update the mode
310: UPDATE GMO_INSTR_ATTRIBUTES_T
311: SET ATTRIBUTE_VALUE = P_MODE,
312: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
313: LAST_UPDATED_BY = L_LAST_UPDATED_BY,
314: LAST_UPDATE_LOGIN = L_LAST_UPDATE_LOGIN

Line 320: UPDATE GMO_INSTR_ATTRIBUTES_T

316: AND ATTRIBUTE_NAME = GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE
317: AND ATTRIBUTE_TYPE = GMO_CONSTANTS_GRP.G_PARAM_INTERNAL;
318:
319: -- update the status to ERROR
320: UPDATE GMO_INSTR_ATTRIBUTES_T
321: SET ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_PROCESS_ERROR,
322: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
323: LAST_UPDATED_BY = L_LAST_UPDATED_BY,
324: LAST_UPDATE_LOGIN = L_LAST_UPDATE_LOGIN

Line 331: --Insert Entity Name and Entity Key values in GMO_INSTR_ATTRIBUTES_T

327: AND ATTRIBUTE_TYPE = GMO_CONSTANTS_GRP.G_PARAM_INTERNAL;
328:
329: END IF; -- if L_VALID_PROCESS = 0;
330:
331: --Insert Entity Name and Entity Key values in GMO_INSTR_ATTRIBUTES_T
332: L_INSTRUCTION_TYPE := P_INSTRUCTION_TYPE(1);
333:
334: FOR J IN 2..P_INSTRUCTION_TYPE.count LOOP
335: L_INSTRUCTION_TYPE := L_INSTRUCTION_TYPE || ',' || P_INSTRUCTION_TYPE(J);

Line 341: UPDATE GMO_INSTR_ATTRIBUTES_T

337:
338: IF (P_ENTITY_NAME.count > 0) THEN
339:
340: -- Mark all entities as RENDER FALSE
341: UPDATE GMO_INSTR_ATTRIBUTES_T
342: SET ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_RENDER_FALSE,
343: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
344: LAST_UPDATED_BY = L_LAST_UPDATED_BY,
345: LAST_UPDATE_LOGIN = L_LAST_UPDATE_LOGIN

Line 356: SELECT COUNT(*) INTO L_ENTITY_EXIST_COUNT FROM GMO_INSTR_ATTRIBUTES_T

352: L_ENTITY_DISPLAYNAME := P_ENTITY_DISPLAYNAME(I);
353:
354: L_ENTITY_EXIST_COUNT := 0;
355:
356: SELECT COUNT(*) INTO L_ENTITY_EXIST_COUNT FROM GMO_INSTR_ATTRIBUTES_T
357: WHERE INSTRUCTION_PROCESS_ID = L_INSTRUCTION_PROCESS_ID
358: AND ATTRIBUTE_NAME = GMO_CONSTANTS_GRP.G_PARAM_ENTITY
359: AND ENTITY_NAME = L_ENTITY_NAME
360: AND ENTITY_KEY = L_ENTITY_KEY;

Line 364: INSERT INTO GMO_INSTR_ATTRIBUTES_T

360: AND ENTITY_KEY = L_ENTITY_KEY;
361:
362: IF (l_entity_exist_count = 0) THEN
363: -- Validate all of these before inserting
364: INSERT INTO GMO_INSTR_ATTRIBUTES_T
365: (
366: INSTRUCTION_PROCESS_ID,
367: ATTRIBUTE_SEQ,
368: ATTRIBUTE_NAME,

Line 384: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,

380: )
381: VALUES
382: (
383: L_INSTRUCTION_PROCESS_ID,
384: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,
385: GMO_CONSTANTS_GRP.G_PARAM_ENTITY,
386: GMO_CONSTANTS_GRP.G_RENDER_TRUE,
387: GMO_CONSTANTS_GRP.G_PARAM_INTERNAL,
388: L_ENTITY_NAME,

Line 399: UPDATE GMO_INSTR_ATTRIBUTES_T

395: L_LAST_UPDATED_BY,
396: L_LAST_UPDATE_LOGIN
397: );
398: ELSE
399: UPDATE GMO_INSTR_ATTRIBUTES_T
400: SET ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_RENDER_TRUE,
401: ENTITY_DISPLAY_NAME = L_ENTITY_DISPLAYNAME
402: WHERE INSTRUCTION_PROCESS_ID = L_INSTRUCTION_PROCESS_ID
403: AND ATTRIBUTE_NAME = GMO_CONSTANTS_GRP.G_PARAM_ENTITY

Line 412: DELETE FROM GMO_INSTR_ATTRIBUTES_T WHERE INSTRUCTION_PROCESS_ID = L_INSTRUCTION_PROCESS_ID

408: END IF;
409:
410: -- Delete the existing context parameters
411: IF (P_CONTEXT_PARAMETERS.COUNT > 0) THEN
412: DELETE FROM GMO_INSTR_ATTRIBUTES_T WHERE INSTRUCTION_PROCESS_ID = L_INSTRUCTION_PROCESS_ID
413: AND ATTRIBUTE_TYPE = GMO_CONSTANTS_GRP.G_PARAM_CONTEXT;
414: END IF;
415:
416: -- Insert P_CONTEXT_PARAMETERS in GMO_INSTR_ATTRIBUTES_T

Line 416: -- Insert P_CONTEXT_PARAMETERS in GMO_INSTR_ATTRIBUTES_T

412: DELETE FROM GMO_INSTR_ATTRIBUTES_T WHERE INSTRUCTION_PROCESS_ID = L_INSTRUCTION_PROCESS_ID
413: AND ATTRIBUTE_TYPE = GMO_CONSTANTS_GRP.G_PARAM_CONTEXT;
414: END IF;
415:
416: -- Insert P_CONTEXT_PARAMETERS in GMO_INSTR_ATTRIBUTES_T
417: FOR I IN 1..P_CONTEXT_PARAMETERS.COUNT LOOP
418: IF P_CONTEXT_PARAMETERS(I).NAME = GMO_CONSTANTS_GRP.G_INSTR_RETURN_URL OR
419: P_CONTEXT_PARAMETERS(I).NAME = GMO_CONSTANTS_GRP.G_INSTR_SOURCE_APPL_TYPE THEN
420:

Line 433: INSERT INTO GMO_INSTR_ATTRIBUTES_T

429: APP_EXCEPTION.RAISE_EXCEPTION;
430: END IF;
431:
432: ELSE
433: INSERT INTO GMO_INSTR_ATTRIBUTES_T
434: (
435: INSTRUCTION_PROCESS_ID,
436: ATTRIBUTE_SEQ,
437: ATTRIBUTE_NAME,

Line 449: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,

445: )
446: VALUES
447: (
448: L_INSTRUCTION_PROCESS_ID,
449: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,
450: P_CONTEXT_PARAMETERS(I).NAME,
451: P_CONTEXT_PARAMETERS(I).VALUE,
452: GMO_CONSTANTS_GRP.G_PARAM_CONTEXT,
453: L_CREATION_DATE,

Line 1466: FROM GMO_INSTR_ATTRIBUTES_T

1462: ATTRIBUTE_NAME, ATTRIBUTE_VALUE,
1463: ENTITY_NAME, ENTITY_KEY, ENTITY_DISPLAY_NAME, INSTRUCTION_TYPE,
1464: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1465: LAST_UPDATE_LOGIN
1466: FROM GMO_INSTR_ATTRIBUTES_T
1467: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
1468: AND ATTRIBUTE_NAME = GMO_CONSTANTS_GRP.G_PARAM_ENTITY
1469: ORDER BY ATTRIBUTE_SEQ;
1470:

Line 1477: FROM GMO_INSTR_ATTRIBUTES_T

1473: ATTRIBUTE_NAME, ATTRIBUTE_VALUE,
1474: ENTITY_NAME, ENTITY_KEY, ENTITY_DISPLAY_NAME, INSTRUCTION_TYPE,
1475: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1476: LAST_UPDATE_LOGIN
1477: FROM GMO_INSTR_ATTRIBUTES_T
1478: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
1479: AND ATTRIBUTE_NAME = GMO_CONSTANTS_GRP.G_PARAM_ENTITY
1480: AND ENTITY_NAME = L_IN_ENTITY_NAME
1481: AND ENTITY_KEY = L_IN_ENTITY_KEY;

Line 1522: SELECT ATTRIBUTE_VALUE INTO L_DEFINITION_STATUS FROM GMO_INSTR_ATTRIBUTES_T

1518: BEGIN
1519: L_API_NAME := 'SEND_DEFN_ACKN';
1520:
1521: -- Validate definition
1522: SELECT ATTRIBUTE_VALUE INTO L_DEFINITION_STATUS FROM GMO_INSTR_ATTRIBUTES_T
1523: WHERE ATTRIBUTE_NAME = 'DEFINITION_STATUS' AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID AND ATTRIBUTE_TYPE = 'INTERNAL';
1524:
1525:
1526: -- Perform all the processing only if the definition status is

Line 1534: -- Then construct it from GMO_INSTR_ATTRIBUTES_T table by querying

1530: RETURN;
1531: END IF;
1532:
1533: -- If P_SOURCE_ENTITY_NAME and P_SOURCE_ENTITY_KEY is null,
1534: -- Then construct it from GMO_INSTR_ATTRIBUTES_T table by querying
1535: -- entity name, entity key and instruction type values
1536:
1537: L_SOURCE_ENTITY_KEY_ARR := FND_TABLE_OF_VARCHAR2_255();
1538: L_INSTRUCTION_TYPE_ARR := FND_TABLE_OF_VARCHAR2_255();

Line 1672: UPDATE GMO_INSTR_ATTRIBUTES_T

1668: AND ENTITY_KEY = L_SOURCE_ENTITY_KEY
1669: AND INSTRUCTION_TYPE = L_INSTRUCTION_TYPE;
1670:
1671:
1672: UPDATE GMO_INSTR_ATTRIBUTES_T
1673: SET ENTITY_KEY = L_TARGET_ENTITY_KEY
1674: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
1675: AND ATTRIBUTE_NAME = GMO_CONSTANTS_GRP.G_PARAM_ENTITY
1676: AND ENTITY_NAME = L_ENTITY_NAME

Line 4029: FROM GMO_INSTR_ATTRIBUTES_T

4025: -- VALIDATE THE INSTRUCTION ID FIRST BY SEEING IF IT EXISTS IN
4026: -- THE TEMPORARY TABLE
4027:
4028: SELECT COUNT(*) INTO L_PROCESS_COUNT
4029: FROM GMO_INSTR_ATTRIBUTES_T
4030: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
4031: AND ATTRIBUTE_NAME = GMO_CONSTANTS_GRP.G_INSTANCE_STATUS
4032: AND ATTRIBUTE_TYPE = GMO_CONSTANTS_GRP.G_PARAM_INTERNAL
4033: AND ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_PROCESS_ERROR;

Line 4400: FROM GMO_INSTR_ATTRIBUTES_T

4396:
4397: L_API_NAME := 'GET_DEFN_STATUS';
4398:
4399: SELECT ATTRIBUTE_VALUE INTO X_DEFINITION_STATUS
4400: FROM GMO_INSTR_ATTRIBUTES_T
4401: WHERE ATTRIBUTE_NAME = GMO_CONSTANTS_GRP.G_DEFINITION_STATUS
4402: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
4403: AND ATTRIBUTE_TYPE = GMO_CONSTANTS_GRP.G_PARAM_INTERNAL;
4404:

Line 4473: FROM GMO_INSTR_ATTRIBUTES_T

4469:
4470: L_API_NAME := 'GET_INSTANCE_STATUS';
4471:
4472: SELECT ATTRIBUTE_VALUE INTO X_INSTANCE_STATUS
4473: FROM GMO_INSTR_ATTRIBUTES_T
4474: WHERE ATTRIBUTE_NAME = 'INSTANCE_STATUS'
4475: AND ATTRIBUTE_TYPE = 'INTERNAL'
4476: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
4477:

Line 5082: INSERT INTO GMO_INSTR_ATTRIBUTES_T

5078: X_LAST_UPDATED_BY => L_LAST_UPDATED_BY,
5079: X_LAST_UPDATE_LOGIN => L_LAST_UPDATE_LOGIN
5080: );
5081:
5082: INSERT INTO GMO_INSTR_ATTRIBUTES_T
5083: (
5084: INSTRUCTION_PROCESS_ID,
5085: ATTRIBUTE_SEQ,
5086: ATTRIBUTE_NAME,

Line 5100: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,

5096: )
5097: VALUES
5098: (
5099: L_INSTRUCTION_PROCESS_ID,
5100: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,
5101: GMO_CONSTANTS_GRP.G_PARAM_ENTITY,
5102: P_ENTITY_NAME,
5103: P_ENTITY_KEY,
5104: P_INSTRUCTION_TYPE,

Line 5113: INSERT INTO GMO_INSTR_ATTRIBUTES_T

5109: L_LAST_UPDATED_BY,
5110: L_LAST_UPDATE_LOGIN
5111: );
5112:
5113: INSERT INTO GMO_INSTR_ATTRIBUTES_T
5114: (
5115: INSTRUCTION_PROCESS_ID,
5116: ATTRIBUTE_SEQ,
5117: ATTRIBUTE_NAME,

Line 5129: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,

5125: )
5126: VALUES
5127: (
5128: L_INSTRUCTION_PROCESS_ID,
5129: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,
5130: GMO_CONSTANTS_GRP.G_INSTANCE_STATUS,
5131: GMO_CONSTANTS_GRP.G_PROCESS_ERROR,
5132: GMO_CONSTANTS_GRP.G_PARAM_INTERNAL,
5133: L_CREATION_DATE,

Line 5146: INSERT INTO GMO_INSTR_ATTRIBUTES_T

5142:
5143: FOR I IN 1..P_CONTEXT_PARAM_NAME.COUNT LOOP
5144: IF(P_CONTEXT_PARAM_NAME(I) IS NOT NULL) THEN
5145:
5146: INSERT INTO GMO_INSTR_ATTRIBUTES_T
5147: (
5148: INSTRUCTION_PROCESS_ID,
5149: ATTRIBUTE_SEQ,
5150: ATTRIBUTE_NAME,

Line 5162: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,

5158: )
5159: VALUES
5160: (
5161: L_INSTRUCTION_PROCESS_ID,
5162: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,
5163: P_CONTEXT_PARAM_NAME(i),
5164: P_CONTEXT_PARAM_VALUE(i),
5165: GMO_CONSTANTS_GRP.G_PARAM_INTERNAL,
5166: L_CREATION_DATE,

Line 5343: --respectively in GMO_INSTR_ATTRIBUTES_T for the specified

5339:
5340:
5341: --This procedure updates the definition and
5342: --process status attribute values to "MODIFIED" and "SUCCESS"
5343: --respectively in GMO_INSTR_ATTRIBUTES_T for the specified
5344: --instruction process ID.
5345: PROCEDURE UPDATE_INSTR_ATTRIBUTES(P_INSTRUCTION_PROCESS_ID IN VARCHAR2,
5346: P_UPDATE_DEFN_STATUS IN VARCHAR2)
5347: IS

Line 5363: GMO_INSTR_ATTRIBUTES_T

5359:
5360: --Update the definition status if required based on the flag.
5361: IF(P_UPDATE_DEFN_STATUS = FND_API.G_TRUE) THEN
5362: UPDATE
5363: GMO_INSTR_ATTRIBUTES_T
5364: SET
5365: ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_STATUS_MODIFIED
5366: WHERE
5367: INSTRUCTION_PROCESS_ID = L_INSTRUCTION_PROCESS_ID

Line 5374: GMO_INSTR_ATTRIBUTES_T

5370: END IF;
5371:
5372: --Update the PROCESS_STATUS to success.
5373: UPDATE
5374: GMO_INSTR_ATTRIBUTES_T
5375: SET
5376: ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_PROCESS_SUCCESS
5377: WHERE
5378: INSTRUCTION_PROCESS_ID = L_INSTRUCTION_PROCESS_ID

Line 5406: --respectively in GMO_INSTR_ATTRIBUTES_T for the specified

5402: END UPDATE_INSTR_ATTRIBUTES;
5403:
5404: --This procedure sets the definition and
5405: --process status attribute values to "MODIFIED" and "SUCCESS"
5406: --respectively in GMO_INSTR_ATTRIBUTES_T for the specified
5407: --instruction process ID.
5408: PROCEDURE SET_INSTR_STATUS_ATTRIBUTES(P_INSTRUCTION_PROCESS_ID IN VARCHAR2,
5409: P_UPDATE_DEFN_STATUS IN VARCHAR2)
5410: IS

Line 5426: GMO_INSTR_ATTRIBUTES_T

5422:
5423: --Update the definition status if required based on the flag.
5424: IF(P_UPDATE_DEFN_STATUS = FND_API.G_TRUE) THEN
5425: UPDATE
5426: GMO_INSTR_ATTRIBUTES_T
5427: SET
5428: ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_STATUS_MODIFIED
5429: WHERE
5430: INSTRUCTION_PROCESS_ID = L_INSTRUCTION_PROCESS_ID

Line 5437: GMO_INSTR_ATTRIBUTES_T

5433: END IF;
5434:
5435: --Update the PROCESS_STATUS to success.
5436: UPDATE
5437: GMO_INSTR_ATTRIBUTES_T
5438: SET
5439: ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_PROCESS_SUCCESS
5440: WHERE
5441: INSTRUCTION_PROCESS_ID = L_INSTRUCTION_PROCESS_ID

Line 5490: GMO_INSTR_ATTRIBUTES_T

5486: L_INSTRUCTION_PROCESS_ID := TO_NUMBER(P_INSTRUCTION_PROCESS_ID,'999999999999.999999');
5487:
5488: --Update the PROCESS_STATUS to cancel.
5489: UPDATE
5490: GMO_INSTR_ATTRIBUTES_T
5491: SET
5492: ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_PROCESS_CANCEL
5493: WHERE
5494: INSTRUCTION_PROCESS_ID = L_INSTRUCTION_PROCESS_ID

Line 5533: FROM GMO_INSTR_ATTRIBUTES_T

5529: IS
5530: L_ATTRIBUTE_VALUE VARCHAR2(1000);
5531: BEGIN
5532: SELECT ATTRIBUTE_VALUE INTO L_ATTRIBUTE_VALUE
5533: FROM GMO_INSTR_ATTRIBUTES_T
5534: WHERE ATTRIBUTE_NAME = P_ATTRIBUTE_NAME
5535: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
5536: AND ATTRIBUTE_TYPE = P_ATTRIBUTE_TYPE;
5537:

Line 5549: -- session table gmo_instr_attributes_t

5545: END GET_PROCESS_VARIABLE;
5546:
5547:
5548: -- This function inserts a process variable in temporary
5549: -- session table gmo_instr_attributes_t
5550:
5551: FUNCTION INSERT_PROCESS_VARIABLE
5552: (
5553: P_INSTRUCTION_PROCESS_ID IN NUMBER ,

Line 5581: SELECT COUNT(*) INTO L_COUNT FROM GMO_INSTR_ATTRIBUTES_T

5577: X_LAST_UPDATED_BY => L_LAST_UPDATED_BY,
5578: X_LAST_UPDATE_LOGIN => L_LAST_UPDATE_LOGIN
5579: );
5580:
5581: SELECT COUNT(*) INTO L_COUNT FROM GMO_INSTR_ATTRIBUTES_T
5582: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
5583: AND ATTRIBUTE_NAME = P_ATTRIBUTE_NAME
5584: AND ATTRIBUTE_TYPE = P_ATTRIBUTE_TYPE;
5585:

Line 5589: UPDATE GMO_INSTR_ATTRIBUTES_T

5585:
5586: IF (P_ATTRIBUTE_NAME IS NOT NULL AND P_INSTRUCTION_PROCESS_ID IS NOT NULL) THEN
5587: IF L_COUNT > 0 THEN
5588:
5589: UPDATE GMO_INSTR_ATTRIBUTES_T
5590: SET ATTRIBUTE_VALUE = P_ATTRIBUTE_VALUE,
5591: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
5592: LAST_UPDATED_BY = L_LAST_UPDATED_BY,
5593: LAST_UPDATE_LOGIN = L_LAST_UPDATE_LOGIN

Line 5601: INSERT INTO GMO_INSTR_ATTRIBUTES_T

5597:
5598:
5599: ELSE
5600:
5601: INSERT INTO GMO_INSTR_ATTRIBUTES_T
5602: (
5603: INSTRUCTION_PROCESS_ID,
5604: ATTRIBUTE_SEQ,
5605: ATTRIBUTE_NAME,

Line 5617: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,

5613: )
5614: VALUES
5615: (
5616: P_INSTRUCTION_PROCESS_ID,
5617: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,
5618: P_ATTRIBUTE_NAME,
5619: P_ATTRIBUTE_VALUE,
5620: P_ATTRIBUTE_TYPE,
5621: L_CREATION_DATE,

Line 5666: UPDATE GMO_INSTR_ATTRIBUTES_T

5662: PRAGMA AUTONOMOUS_TRANSACTION;
5663:
5664: BEGIN
5665:
5666: UPDATE GMO_INSTR_ATTRIBUTES_T
5667: SET ATTRIBUTE_VALUE = P_ATTRIBUTE_VALUE
5668: WHERE ATTRIBUTE_NAME = P_ATTRIBUTE_NAME
5669: AND ATTRIBUTE_TYPE = P_ATTRIBUTE_TYPE
5670: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;

Line 5683: INSERT INTO GMO_INSTR_ATTRIBUTES_T

5679: X_LAST_UPDATED_BY => L_LAST_UPDATED_BY,
5680: X_LAST_UPDATE_LOGIN => L_LAST_UPDATE_LOGIN
5681: );
5682:
5683: INSERT INTO GMO_INSTR_ATTRIBUTES_T
5684: (
5685: INSTRUCTION_PROCESS_ID,
5686: ATTRIBUTE_SEQ,
5687: ATTRIBUTE_NAME,

Line 5699: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,

5695: )
5696: VALUES
5697: (
5698: P_INSTRUCTION_PROCESS_ID,
5699: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,
5700: P_ATTRIBUTE_NAME,
5701: P_ATTRIBUTE_VALUE,
5702: P_ATTRIBUTE_TYPE,
5703: L_CREATION_DATE,

Line 6341: UPDATE GMO_INSTR_ATTRIBUTES_T

6337:
6338: BEGIN
6339:
6340: --Update the process status to complete for the instruction definition identified by the specified process ID.
6341: UPDATE GMO_INSTR_ATTRIBUTES_T
6342: SET ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_PROCESS_TERMINATE
6343: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
6344: AND ATTRIBUTE_TYPE = GMO_CONSTANTS_GRP.G_PARAM_INTERNAL
6345: AND ATTRIBUTE_NAME = GMO_CONSTANTS_GRP.G_PROCESS_STATUS;

Line 6396: SELECT COUNT(*) into l_valid_process FROM GMO_INSTR_ATTRIBUTES_T

6392: l_count := 0;
6393: l_instruction_process_id := p_instruction_process_id;
6394:
6395: --check valid process
6396: SELECT COUNT(*) into l_valid_process FROM GMO_INSTR_ATTRIBUTES_T
6397: WHERE INSTRUCTION_PROCESS_ID = p_instruction_process_id
6398: AND ATTRIBUTE_NAME = GMO_CONSTANTS_GRP.G_PROCESS_STATUS
6399: AND ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_PROCESS_SUCCESS;
6400: