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 3704: FROM GMO_INSTR_ATTRIBUTES_T

3700: ORDER BY INSTR_TASK_SEQ;
3701:
3702: CURSOR L_AUTO_COMMIT_ATTRIBUTE IS
3703: SELECT ATTRIBUTE_VALUE
3704: FROM GMO_INSTR_ATTRIBUTES_T
3705: WHERE INSTRUCTION_PROCESS_ID=P_INSTRUCTION_PROCESS_ID
3706: AND Upper(ATTRIBUTE_NAME)='AUTO_COMMIT'
3707: AND Upper(ATTRIBUTE_TYPE)='ACONTEXT';
3708: L_INSTR_SET_REC L_TEMP_INSTR_SET_CSR%ROWTYPE;

Line 4051: FROM GMO_INSTR_ATTRIBUTES_T

4047: -- VALIDATE THE INSTRUCTION ID FIRST BY SEEING IF IT EXISTS IN
4048: -- THE TEMPORARY TABLE
4049:
4050: SELECT COUNT(*) INTO L_PROCESS_COUNT
4051: FROM GMO_INSTR_ATTRIBUTES_T
4052: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
4053: AND ATTRIBUTE_NAME = GMO_CONSTANTS_GRP.G_INSTANCE_STATUS
4054: AND ATTRIBUTE_TYPE = GMO_CONSTANTS_GRP.G_PARAM_INTERNAL
4055: AND ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_PROCESS_ERROR;

Line 4422: FROM GMO_INSTR_ATTRIBUTES_T

4418:
4419: L_API_NAME := 'GET_DEFN_STATUS';
4420:
4421: SELECT ATTRIBUTE_VALUE INTO X_DEFINITION_STATUS
4422: FROM GMO_INSTR_ATTRIBUTES_T
4423: WHERE ATTRIBUTE_NAME = GMO_CONSTANTS_GRP.G_DEFINITION_STATUS
4424: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
4425: AND ATTRIBUTE_TYPE = GMO_CONSTANTS_GRP.G_PARAM_INTERNAL;
4426:

Line 4495: FROM GMO_INSTR_ATTRIBUTES_T

4491:
4492: L_API_NAME := 'GET_INSTANCE_STATUS';
4493:
4494: SELECT ATTRIBUTE_VALUE INTO X_INSTANCE_STATUS
4495: FROM GMO_INSTR_ATTRIBUTES_T
4496: WHERE ATTRIBUTE_NAME = 'INSTANCE_STATUS'
4497: AND ATTRIBUTE_TYPE = 'INTERNAL'
4498: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
4499:

Line 5104: INSERT INTO GMO_INSTR_ATTRIBUTES_T

5100: X_LAST_UPDATED_BY => L_LAST_UPDATED_BY,
5101: X_LAST_UPDATE_LOGIN => L_LAST_UPDATE_LOGIN
5102: );
5103:
5104: INSERT INTO GMO_INSTR_ATTRIBUTES_T
5105: (
5106: INSTRUCTION_PROCESS_ID,
5107: ATTRIBUTE_SEQ,
5108: ATTRIBUTE_NAME,

Line 5122: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,

5118: )
5119: VALUES
5120: (
5121: L_INSTRUCTION_PROCESS_ID,
5122: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,
5123: GMO_CONSTANTS_GRP.G_PARAM_ENTITY,
5124: P_ENTITY_NAME,
5125: P_ENTITY_KEY,
5126: P_INSTRUCTION_TYPE,

Line 5135: INSERT INTO GMO_INSTR_ATTRIBUTES_T

5131: L_LAST_UPDATED_BY,
5132: L_LAST_UPDATE_LOGIN
5133: );
5134:
5135: INSERT INTO GMO_INSTR_ATTRIBUTES_T
5136: (
5137: INSTRUCTION_PROCESS_ID,
5138: ATTRIBUTE_SEQ,
5139: ATTRIBUTE_NAME,

Line 5151: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,

5147: )
5148: VALUES
5149: (
5150: L_INSTRUCTION_PROCESS_ID,
5151: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,
5152: GMO_CONSTANTS_GRP.G_INSTANCE_STATUS,
5153: GMO_CONSTANTS_GRP.G_PROCESS_ERROR,
5154: GMO_CONSTANTS_GRP.G_PARAM_INTERNAL,
5155: L_CREATION_DATE,

Line 5168: INSERT INTO GMO_INSTR_ATTRIBUTES_T

5164:
5165: FOR I IN 1..P_CONTEXT_PARAM_NAME.COUNT LOOP
5166: IF(P_CONTEXT_PARAM_NAME(I) IS NOT NULL) THEN
5167:
5168: INSERT INTO GMO_INSTR_ATTRIBUTES_T
5169: (
5170: INSTRUCTION_PROCESS_ID,
5171: ATTRIBUTE_SEQ,
5172: ATTRIBUTE_NAME,

Line 5184: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,

5180: )
5181: VALUES
5182: (
5183: L_INSTRUCTION_PROCESS_ID,
5184: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,
5185: P_CONTEXT_PARAM_NAME(i),
5186: P_CONTEXT_PARAM_VALUE(i),
5187: GMO_CONSTANTS_GRP.G_PARAM_INTERNAL,
5188: L_CREATION_DATE,

Line 5365: --respectively in GMO_INSTR_ATTRIBUTES_T for the specified

5361:
5362:
5363: --This procedure updates the definition and
5364: --process status attribute values to "MODIFIED" and "SUCCESS"
5365: --respectively in GMO_INSTR_ATTRIBUTES_T for the specified
5366: --instruction process ID.
5367: PROCEDURE UPDATE_INSTR_ATTRIBUTES(P_INSTRUCTION_PROCESS_ID IN VARCHAR2,
5368: P_UPDATE_DEFN_STATUS IN VARCHAR2)
5369: IS

Line 5385: GMO_INSTR_ATTRIBUTES_T

5381:
5382: --Update the definition status if required based on the flag.
5383: IF(P_UPDATE_DEFN_STATUS = FND_API.G_TRUE) THEN
5384: UPDATE
5385: GMO_INSTR_ATTRIBUTES_T
5386: SET
5387: ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_STATUS_MODIFIED
5388: WHERE
5389: INSTRUCTION_PROCESS_ID = L_INSTRUCTION_PROCESS_ID

Line 5396: GMO_INSTR_ATTRIBUTES_T

5392: END IF;
5393:
5394: --Update the PROCESS_STATUS to success.
5395: UPDATE
5396: GMO_INSTR_ATTRIBUTES_T
5397: SET
5398: ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_PROCESS_SUCCESS
5399: WHERE
5400: INSTRUCTION_PROCESS_ID = L_INSTRUCTION_PROCESS_ID

Line 5428: --respectively in GMO_INSTR_ATTRIBUTES_T for the specified

5424: END UPDATE_INSTR_ATTRIBUTES;
5425:
5426: --This procedure sets the definition and
5427: --process status attribute values to "MODIFIED" and "SUCCESS"
5428: --respectively in GMO_INSTR_ATTRIBUTES_T for the specified
5429: --instruction process ID.
5430: PROCEDURE SET_INSTR_STATUS_ATTRIBUTES(P_INSTRUCTION_PROCESS_ID IN VARCHAR2,
5431: P_UPDATE_DEFN_STATUS IN VARCHAR2)
5432: IS

Line 5448: GMO_INSTR_ATTRIBUTES_T

5444:
5445: --Update the definition status if required based on the flag.
5446: IF(P_UPDATE_DEFN_STATUS = FND_API.G_TRUE) THEN
5447: UPDATE
5448: GMO_INSTR_ATTRIBUTES_T
5449: SET
5450: ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_STATUS_MODIFIED
5451: WHERE
5452: INSTRUCTION_PROCESS_ID = L_INSTRUCTION_PROCESS_ID

Line 5459: GMO_INSTR_ATTRIBUTES_T

5455: END IF;
5456:
5457: --Update the PROCESS_STATUS to success.
5458: UPDATE
5459: GMO_INSTR_ATTRIBUTES_T
5460: SET
5461: ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_PROCESS_SUCCESS
5462: WHERE
5463: INSTRUCTION_PROCESS_ID = L_INSTRUCTION_PROCESS_ID

Line 5512: GMO_INSTR_ATTRIBUTES_T

5508: L_INSTRUCTION_PROCESS_ID := TO_NUMBER(P_INSTRUCTION_PROCESS_ID,'999999999999.999999');
5509:
5510: --Update the PROCESS_STATUS to cancel.
5511: UPDATE
5512: GMO_INSTR_ATTRIBUTES_T
5513: SET
5514: ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_PROCESS_CANCEL
5515: WHERE
5516: INSTRUCTION_PROCESS_ID = L_INSTRUCTION_PROCESS_ID

Line 5555: FROM GMO_INSTR_ATTRIBUTES_T

5551: IS
5552: L_ATTRIBUTE_VALUE VARCHAR2(1000);
5553: BEGIN
5554: SELECT ATTRIBUTE_VALUE INTO L_ATTRIBUTE_VALUE
5555: FROM GMO_INSTR_ATTRIBUTES_T
5556: WHERE ATTRIBUTE_NAME = P_ATTRIBUTE_NAME
5557: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
5558: AND ATTRIBUTE_TYPE = P_ATTRIBUTE_TYPE;
5559:

Line 5571: -- session table gmo_instr_attributes_t

5567: END GET_PROCESS_VARIABLE;
5568:
5569:
5570: -- This function inserts a process variable in temporary
5571: -- session table gmo_instr_attributes_t
5572:
5573: FUNCTION INSERT_PROCESS_VARIABLE
5574: (
5575: P_INSTRUCTION_PROCESS_ID IN NUMBER ,

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

5599: X_LAST_UPDATED_BY => L_LAST_UPDATED_BY,
5600: X_LAST_UPDATE_LOGIN => L_LAST_UPDATE_LOGIN
5601: );
5602:
5603: SELECT COUNT(*) INTO L_COUNT FROM GMO_INSTR_ATTRIBUTES_T
5604: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
5605: AND ATTRIBUTE_NAME = P_ATTRIBUTE_NAME
5606: AND ATTRIBUTE_TYPE = P_ATTRIBUTE_TYPE;
5607:

Line 5611: UPDATE GMO_INSTR_ATTRIBUTES_T

5607:
5608: IF (P_ATTRIBUTE_NAME IS NOT NULL AND P_INSTRUCTION_PROCESS_ID IS NOT NULL) THEN
5609: IF L_COUNT > 0 THEN
5610:
5611: UPDATE GMO_INSTR_ATTRIBUTES_T
5612: SET ATTRIBUTE_VALUE = P_ATTRIBUTE_VALUE,
5613: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
5614: LAST_UPDATED_BY = L_LAST_UPDATED_BY,
5615: LAST_UPDATE_LOGIN = L_LAST_UPDATE_LOGIN

Line 5623: INSERT INTO GMO_INSTR_ATTRIBUTES_T

5619:
5620:
5621: ELSE
5622:
5623: INSERT INTO GMO_INSTR_ATTRIBUTES_T
5624: (
5625: INSTRUCTION_PROCESS_ID,
5626: ATTRIBUTE_SEQ,
5627: ATTRIBUTE_NAME,

Line 5639: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,

5635: )
5636: VALUES
5637: (
5638: P_INSTRUCTION_PROCESS_ID,
5639: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,
5640: P_ATTRIBUTE_NAME,
5641: P_ATTRIBUTE_VALUE,
5642: P_ATTRIBUTE_TYPE,
5643: L_CREATION_DATE,

Line 5688: UPDATE GMO_INSTR_ATTRIBUTES_T

5684: PRAGMA AUTONOMOUS_TRANSACTION;
5685:
5686: BEGIN
5687:
5688: UPDATE GMO_INSTR_ATTRIBUTES_T
5689: SET ATTRIBUTE_VALUE = P_ATTRIBUTE_VALUE
5690: WHERE ATTRIBUTE_NAME = P_ATTRIBUTE_NAME
5691: AND ATTRIBUTE_TYPE = P_ATTRIBUTE_TYPE
5692: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;

Line 5705: INSERT INTO GMO_INSTR_ATTRIBUTES_T

5701: X_LAST_UPDATED_BY => L_LAST_UPDATED_BY,
5702: X_LAST_UPDATE_LOGIN => L_LAST_UPDATE_LOGIN
5703: );
5704:
5705: INSERT INTO GMO_INSTR_ATTRIBUTES_T
5706: (
5707: INSTRUCTION_PROCESS_ID,
5708: ATTRIBUTE_SEQ,
5709: ATTRIBUTE_NAME,

Line 5721: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,

5717: )
5718: VALUES
5719: (
5720: P_INSTRUCTION_PROCESS_ID,
5721: GMO_INSTR_ATTRIBUTES_T_S.NEXTVAL,
5722: P_ATTRIBUTE_NAME,
5723: P_ATTRIBUTE_VALUE,
5724: P_ATTRIBUTE_TYPE,
5725: L_CREATION_DATE,

Line 6364: UPDATE GMO_INSTR_ATTRIBUTES_T

6360:
6361: BEGIN
6362:
6363: --Update the process status to complete for the instruction definition identified by the specified process ID.
6364: UPDATE GMO_INSTR_ATTRIBUTES_T
6365: SET ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_PROCESS_TERMINATE
6366: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
6367: AND ATTRIBUTE_TYPE = GMO_CONSTANTS_GRP.G_PARAM_INTERNAL
6368: AND ATTRIBUTE_NAME = GMO_CONSTANTS_GRP.G_PROCESS_STATUS;

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

6415: l_count := 0;
6416: l_instruction_process_id := p_instruction_process_id;
6417:
6418: --check valid process
6419: SELECT COUNT(*) into l_valid_process FROM GMO_INSTR_ATTRIBUTES_T
6420: WHERE INSTRUCTION_PROCESS_ID = p_instruction_process_id
6421: AND ATTRIBUTE_NAME = GMO_CONSTANTS_GRP.G_PROCESS_STATUS
6422: AND ATTRIBUTE_VALUE = GMO_CONSTANTS_GRP.G_PROCESS_SUCCESS;
6423: