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.AMW_ORG_HIERARCHY_PKG dependencies on STANDARD

Line 170: STANDARD_PROCESS_FLAG,

166: (CONTROL_COUNT,
167: RISK_COUNT,
168: PROCESS_ORGANIZATION_ID,
169: PROCESS_ID,
170: STANDARD_PROCESS_FLAG,
171: RISK_CATEGORY,
172: CERTIFICATION_STATUS,
173: LAST_AUDIT_STATUS,
174: ORGANIZATION_ID,

Line 209: STANDARD_VARIATION,

205: PROCESS_CODE,
206: PROCESS_TYPE,
207: CONTROL_ACTIVITY_TYPE,
208: RL_PROCESS_REV_ID,
209: STANDARD_VARIATION,
210: PROCESS_CATEGORY,
211: LAST_UPDATE_DATE,
212: LAST_UPDATED_BY,
213: CREATION_DATE,

Line 231: STANDARD_PROCESS_FLAG,

227: CONTROL_COUNT,
228: RISK_COUNT,
229: AMW_PROCESS_ORGANIZATION_S.nextval, --kosriniv this is primary key till AMW.C PROCESS_ORGANIZATION_ID,
230: PROCESS_ID,
231: STANDARD_PROCESS_FLAG,
232: RISK_CATEGORY,
233: CERTIFICATION_STATUS,
234: LAST_AUDIT_STATUS,
235: ORGANIZATION_ID,

Line 270: STANDARD_VARIATION,

266: PROCESS_CODE,
267: PROCESS_TYPE,
268: CONTROL_ACTIVITY_TYPE,
269: RL_PROCESS_REV_ID,
270: STANDARD_VARIATION,
271: PROCESS_CATEGORY,
272: sysdate,
273: G_USER_ID,
274: sysdate,

Line 361: STANDARD_PROCESS_FLAG,

357: (CONTROL_COUNT,
358: RISK_COUNT,
359: PROCESS_ORGANIZATION_ID,
360: PROCESS_ID,
361: STANDARD_PROCESS_FLAG,
362: RISK_CATEGORY,
363: CERTIFICATION_STATUS,
364: LAST_AUDIT_STATUS,
365: ORGANIZATION_ID,

Line 400: STANDARD_VARIATION,

396: PROCESS_CODE,
397: PROCESS_TYPE,
398: CONTROL_ACTIVITY_TYPE,
399: RL_PROCESS_REV_ID,
400: STANDARD_VARIATION,
401: PROCESS_CATEGORY,
402: LAST_UPDATE_DATE,
403: LAST_UPDATED_BY,
404: CREATION_DATE,

Line 422: STANDARD_PROCESS_FLAG,

418: CONTROL_COUNT,
419: RISK_COUNT,
420: AMW_PROCESS_ORGANIZATION_S.nextval, --kosriniv this is primary key till AMW.C PROCESS_ORGANIZATION_ID,
421: PROCESS_ID,
422: STANDARD_PROCESS_FLAG,
423: RISK_CATEGORY,
424: CERTIFICATION_STATUS,
425: LAST_AUDIT_STATUS,
426: ORGANIZATION_ID,

Line 461: STANDARD_VARIATION,

457: PROCESS_CODE,
458: PROCESS_TYPE,
459: CONTROL_ACTIVITY_TYPE,
460: RL_PROCESS_REV_ID,
461: STANDARD_VARIATION,
462: PROCESS_CATEGORY,
463: sysdate,
464: G_USER_ID,
465: sysdate,

Line 764: STANDARD_PROCESS_FLAG,

760: ORGANIZATION_ID,
761: PROCESS_CODE,
762: RL_PROCESS_REV_ID,
763: SIGNIFICANT_PROCESS_FLAG,
764: STANDARD_PROCESS_FLAG,
765: PROCESS_CATEGORY_CODE,
766: STANDARD_VARIATION,
767: ATTRIBUTE_CATEGORY,
768: ATTRIBUTE1,

Line 766: STANDARD_VARIATION,

762: RL_PROCESS_REV_ID,
763: SIGNIFICANT_PROCESS_FLAG,
764: STANDARD_PROCESS_FLAG,
765: PROCESS_CATEGORY_CODE,
766: STANDARD_VARIATION,
767: ATTRIBUTE_CATEGORY,
768: ATTRIBUTE1,
769: ATTRIBUTE2,
770: ATTRIBUTE3,

Line 805: STANDARD_PROCESS_FLAG,

801: p_org_id,
802: PROCESS_CODE,
803: PROCESS_REV_ID,
804: SIGNIFICANT_PROCESS_FLAG,
805: STANDARD_PROCESS_FLAG,
806: PROCESS_CATEGORY,
807: STANDARD_VARIATION,
808: ATTRIBUTE_CATEGORY,
809: ATTRIBUTE1,

Line 807: STANDARD_VARIATION,

803: PROCESS_REV_ID,
804: SIGNIFICANT_PROCESS_FLAG,
805: STANDARD_PROCESS_FLAG,
806: PROCESS_CATEGORY,
807: STANDARD_VARIATION,
808: ATTRIBUTE_CATEGORY,
809: ATTRIBUTE1,
810: ATTRIBUTE2,
811: ATTRIBUTE3,

Line 1327: l_STANDARD_PROCESS_FLAG amw_process.STANDARD_PROCESS_FLAG%type;

1323: apply_rcm in varchar2) is
1324:
1325: l_RL_PROCESS_REV_ID amw_process.PROCESS_REV_ID%type;
1326: l_SIGNIFICANT_PROCESS_FLAG amw_process.SIGNIFICANT_PROCESS_FLAG%type;
1327: l_STANDARD_PROCESS_FLAG amw_process.STANDARD_PROCESS_FLAG%type;
1328: l_PROCESS_CATEGORY amw_process.PROCESS_CATEGORY%type;
1329: l_STANDARD_VARIATION amw_process.STANDARD_VARIATION%type;
1330: l_ATTRIBUTE_CATEGORY amw_process.ATTRIBUTE_CATEGORY%type;
1331: l_ATTRIBUTE1 amw_process.ATTRIBUTE1%type;

Line 1329: l_STANDARD_VARIATION amw_process.STANDARD_VARIATION%type;

1325: l_RL_PROCESS_REV_ID amw_process.PROCESS_REV_ID%type;
1326: l_SIGNIFICANT_PROCESS_FLAG amw_process.SIGNIFICANT_PROCESS_FLAG%type;
1327: l_STANDARD_PROCESS_FLAG amw_process.STANDARD_PROCESS_FLAG%type;
1328: l_PROCESS_CATEGORY amw_process.PROCESS_CATEGORY%type;
1329: l_STANDARD_VARIATION amw_process.STANDARD_VARIATION%type;
1330: l_ATTRIBUTE_CATEGORY amw_process.ATTRIBUTE_CATEGORY%type;
1331: l_ATTRIBUTE1 amw_process.ATTRIBUTE1%type;
1332: l_ATTRIBUTE2 amw_process.ATTRIBUTE2%type;
1333: l_ATTRIBUTE3 amw_process.ATTRIBUTE3%type;

Line 1359: STANDARD_PROCESS_FLAG,

1355:
1356: -- copy the attributes from rl to org
1357: select PROCESS_REV_ID,
1358: SIGNIFICANT_PROCESS_FLAG,
1359: STANDARD_PROCESS_FLAG,
1360: PROCESS_CATEGORY,
1361: STANDARD_VARIATION,
1362: ATTRIBUTE_CATEGORY,
1363: ATTRIBUTE1,

Line 1361: STANDARD_VARIATION,

1357: select PROCESS_REV_ID,
1358: SIGNIFICANT_PROCESS_FLAG,
1359: STANDARD_PROCESS_FLAG,
1360: PROCESS_CATEGORY,
1361: STANDARD_VARIATION,
1362: ATTRIBUTE_CATEGORY,
1363: ATTRIBUTE1,
1364: ATTRIBUTE2,
1365: ATTRIBUTE3,

Line 1384: l_STANDARD_PROCESS_FLAG,

1380: CONTROL_ACTIVITY_TYPE
1381: into
1382: l_RL_PROCESS_REV_ID,
1383: l_SIGNIFICANT_PROCESS_FLAG,
1384: l_STANDARD_PROCESS_FLAG,
1385: l_PROCESS_CATEGORY,
1386: l_STANDARD_VARIATION,
1387: l_ATTRIBUTE_CATEGORY,
1388: l_ATTRIBUTE1,

Line 1386: l_STANDARD_VARIATION,

1382: l_RL_PROCESS_REV_ID,
1383: l_SIGNIFICANT_PROCESS_FLAG,
1384: l_STANDARD_PROCESS_FLAG,
1385: l_PROCESS_CATEGORY,
1386: l_STANDARD_VARIATION,
1387: l_ATTRIBUTE_CATEGORY,
1388: l_ATTRIBUTE1,
1389: l_ATTRIBUTE2,
1390: l_ATTRIBUTE3,

Line 1414: STANDARD_PROCESS_FLAG = l_STANDARD_PROCESS_FLAG,

1410:
1411: update amw_process_organization
1412: set RL_PROCESS_REV_ID = l_RL_PROCESS_REV_ID,
1413: SIGNIFICANT_PROCESS_FLAG = l_SIGNIFICANT_PROCESS_FLAG,
1414: STANDARD_PROCESS_FLAG = l_STANDARD_PROCESS_FLAG,
1415: PROCESS_CATEGORY_CODE = l_PROCESS_CATEGORY,
1416: STANDARD_VARIATION = l_STANDARD_VARIATION,
1417: ATTRIBUTE_CATEGORY = l_ATTRIBUTE_CATEGORY,
1418: ATTRIBUTE1 = l_ATTRIBUTE1,

Line 1416: STANDARD_VARIATION = l_STANDARD_VARIATION,

1412: set RL_PROCESS_REV_ID = l_RL_PROCESS_REV_ID,
1413: SIGNIFICANT_PROCESS_FLAG = l_SIGNIFICANT_PROCESS_FLAG,
1414: STANDARD_PROCESS_FLAG = l_STANDARD_PROCESS_FLAG,
1415: PROCESS_CATEGORY_CODE = l_PROCESS_CATEGORY,
1416: STANDARD_VARIATION = l_STANDARD_VARIATION,
1417: ATTRIBUTE_CATEGORY = l_ATTRIBUTE_CATEGORY,
1418: ATTRIBUTE1 = l_ATTRIBUTE1,
1419: ATTRIBUTE2 = l_ATTRIBUTE2,
1420: ATTRIBUTE3 = l_ATTRIBUTE3,

Line 5298: l_STANDARD_PROCESS_FLAG amw_process.STANDARD_PROCESS_FLAG%type;

5294:
5295:
5296: l_RL_PROCESS_REV_ID amw_process.PROCESS_REV_ID%type;
5297: l_SIGNIFICANT_PROCESS_FLAG amw_process.SIGNIFICANT_PROCESS_FLAG%type;
5298: l_STANDARD_PROCESS_FLAG amw_process.STANDARD_PROCESS_FLAG%type;
5299: l_PROCESS_CATEGORY amw_process.PROCESS_CATEGORY%type;
5300: l_STANDARD_VARIATION amw_process.STANDARD_VARIATION%type;
5301: l_ATTRIBUTE_CATEGORY amw_process.ATTRIBUTE_CATEGORY%type;
5302: l_ATTRIBUTE1 amw_process.ATTRIBUTE1%type;

Line 5300: l_STANDARD_VARIATION amw_process.STANDARD_VARIATION%type;

5296: l_RL_PROCESS_REV_ID amw_process.PROCESS_REV_ID%type;
5297: l_SIGNIFICANT_PROCESS_FLAG amw_process.SIGNIFICANT_PROCESS_FLAG%type;
5298: l_STANDARD_PROCESS_FLAG amw_process.STANDARD_PROCESS_FLAG%type;
5299: l_PROCESS_CATEGORY amw_process.PROCESS_CATEGORY%type;
5300: l_STANDARD_VARIATION amw_process.STANDARD_VARIATION%type;
5301: l_ATTRIBUTE_CATEGORY amw_process.ATTRIBUTE_CATEGORY%type;
5302: l_ATTRIBUTE1 amw_process.ATTRIBUTE1%type;
5303: l_ATTRIBUTE2 amw_process.ATTRIBUTE2%type;
5304: l_ATTRIBUTE3 amw_process.ATTRIBUTE3%type;

Line 5330: STANDARD_PROCESS_FLAG,

5326:
5327: -- copy the attributes from rl to org
5328: select PROCESS_REV_ID,
5329: SIGNIFICANT_PROCESS_FLAG,
5330: STANDARD_PROCESS_FLAG,
5331: PROCESS_CATEGORY,
5332: STANDARD_VARIATION,
5333: ATTRIBUTE_CATEGORY,
5334: ATTRIBUTE1,

Line 5332: STANDARD_VARIATION,

5328: select PROCESS_REV_ID,
5329: SIGNIFICANT_PROCESS_FLAG,
5330: STANDARD_PROCESS_FLAG,
5331: PROCESS_CATEGORY,
5332: STANDARD_VARIATION,
5333: ATTRIBUTE_CATEGORY,
5334: ATTRIBUTE1,
5335: ATTRIBUTE2,
5336: ATTRIBUTE3,

Line 5355: l_STANDARD_PROCESS_FLAG,

5351: CONTROL_ACTIVITY_TYPE
5352: into
5353: l_RL_PROCESS_REV_ID,
5354: l_SIGNIFICANT_PROCESS_FLAG,
5355: l_STANDARD_PROCESS_FLAG,
5356: l_PROCESS_CATEGORY,
5357: l_STANDARD_VARIATION,
5358: l_ATTRIBUTE_CATEGORY,
5359: l_ATTRIBUTE1,

Line 5357: l_STANDARD_VARIATION,

5353: l_RL_PROCESS_REV_ID,
5354: l_SIGNIFICANT_PROCESS_FLAG,
5355: l_STANDARD_PROCESS_FLAG,
5356: l_PROCESS_CATEGORY,
5357: l_STANDARD_VARIATION,
5358: l_ATTRIBUTE_CATEGORY,
5359: l_ATTRIBUTE1,
5360: l_ATTRIBUTE2,
5361: l_ATTRIBUTE3,

Line 5389: STANDARD_PROCESS_FLAG = l_STANDARD_PROCESS_FLAG,

5385:
5386: update amw_process_organization
5387: set RL_PROCESS_REV_ID = l_RL_PROCESS_REV_ID,
5388: SIGNIFICANT_PROCESS_FLAG = l_SIGNIFICANT_PROCESS_FLAG,
5389: STANDARD_PROCESS_FLAG = l_STANDARD_PROCESS_FLAG,
5390: PROCESS_CATEGORY_CODE = l_PROCESS_CATEGORY,
5391: STANDARD_VARIATION = l_STANDARD_VARIATION,
5392: ATTRIBUTE_CATEGORY = l_ATTRIBUTE_CATEGORY,
5393: ATTRIBUTE1 = l_ATTRIBUTE1,

Line 5391: STANDARD_VARIATION = l_STANDARD_VARIATION,

5387: set RL_PROCESS_REV_ID = l_RL_PROCESS_REV_ID,
5388: SIGNIFICANT_PROCESS_FLAG = l_SIGNIFICANT_PROCESS_FLAG,
5389: STANDARD_PROCESS_FLAG = l_STANDARD_PROCESS_FLAG,
5390: PROCESS_CATEGORY_CODE = l_PROCESS_CATEGORY,
5391: STANDARD_VARIATION = l_STANDARD_VARIATION,
5392: ATTRIBUTE_CATEGORY = l_ATTRIBUTE_CATEGORY,
5393: ATTRIBUTE1 = l_ATTRIBUTE1,
5394: ATTRIBUTE2 = l_ATTRIBUTE2,
5395: ATTRIBUTE3 = l_ATTRIBUTE3,

Line 5569: l_STANDARD_PROCESS_FLAG amw_process.STANDARD_PROCESS_FLAG%type;

5565: */
5566: procedure sync_process_attributes(p_process_id in number ) is
5567: l_RL_PROCESS_REV_ID amw_process.PROCESS_REV_ID%type;
5568: l_SIGNIFICANT_PROCESS_FLAG amw_process.SIGNIFICANT_PROCESS_FLAG%type;
5569: l_STANDARD_PROCESS_FLAG amw_process.STANDARD_PROCESS_FLAG%type;
5570: l_PROCESS_CATEGORY amw_process.PROCESS_CATEGORY%type;
5571: l_STANDARD_VARIATION amw_process.STANDARD_VARIATION%type;
5572: l_ATTRIBUTE_CATEGORY amw_process.ATTRIBUTE_CATEGORY%type;
5573: l_ATTRIBUTE1 amw_process.ATTRIBUTE1%type;

Line 5571: l_STANDARD_VARIATION amw_process.STANDARD_VARIATION%type;

5567: l_RL_PROCESS_REV_ID amw_process.PROCESS_REV_ID%type;
5568: l_SIGNIFICANT_PROCESS_FLAG amw_process.SIGNIFICANT_PROCESS_FLAG%type;
5569: l_STANDARD_PROCESS_FLAG amw_process.STANDARD_PROCESS_FLAG%type;
5570: l_PROCESS_CATEGORY amw_process.PROCESS_CATEGORY%type;
5571: l_STANDARD_VARIATION amw_process.STANDARD_VARIATION%type;
5572: l_ATTRIBUTE_CATEGORY amw_process.ATTRIBUTE_CATEGORY%type;
5573: l_ATTRIBUTE1 amw_process.ATTRIBUTE1%type;
5574: l_ATTRIBUTE2 amw_process.ATTRIBUTE2%type;
5575: l_ATTRIBUTE3 amw_process.ATTRIBUTE3%type;

Line 5602: STANDARD_PROCESS_FLAG,

5598: -- copy the attributes from rl to org
5599:
5600: select PROCESS_REV_ID,
5601: SIGNIFICANT_PROCESS_FLAG,
5602: STANDARD_PROCESS_FLAG,
5603: PROCESS_CATEGORY,
5604: STANDARD_VARIATION,
5605: ATTRIBUTE_CATEGORY,
5606: ATTRIBUTE1,

Line 5604: STANDARD_VARIATION,

5600: select PROCESS_REV_ID,
5601: SIGNIFICANT_PROCESS_FLAG,
5602: STANDARD_PROCESS_FLAG,
5603: PROCESS_CATEGORY,
5604: STANDARD_VARIATION,
5605: ATTRIBUTE_CATEGORY,
5606: ATTRIBUTE1,
5607: ATTRIBUTE2,
5608: ATTRIBUTE3,

Line 5627: l_STANDARD_PROCESS_FLAG,

5623: CONTROL_ACTIVITY_TYPE
5624: into
5625: l_RL_PROCESS_REV_ID,
5626: l_SIGNIFICANT_PROCESS_FLAG,
5627: l_STANDARD_PROCESS_FLAG,
5628: l_PROCESS_CATEGORY,
5629: l_STANDARD_VARIATION,
5630: l_ATTRIBUTE_CATEGORY,
5631: l_ATTRIBUTE1,

Line 5629: l_STANDARD_VARIATION,

5625: l_RL_PROCESS_REV_ID,
5626: l_SIGNIFICANT_PROCESS_FLAG,
5627: l_STANDARD_PROCESS_FLAG,
5628: l_PROCESS_CATEGORY,
5629: l_STANDARD_VARIATION,
5630: l_ATTRIBUTE_CATEGORY,
5631: l_ATTRIBUTE1,
5632: l_ATTRIBUTE2,
5633: l_ATTRIBUTE3,

Line 5660: STANDARD_PROCESS_FLAG = l_STANDARD_PROCESS_FLAG,

5656: FORALL indx IN Org_Ids.FIRST .. Org_Ids.LAST
5657: update amw_process_organization
5658: set RL_PROCESS_REV_ID = l_RL_PROCESS_REV_ID,
5659: SIGNIFICANT_PROCESS_FLAG = l_SIGNIFICANT_PROCESS_FLAG,
5660: STANDARD_PROCESS_FLAG = l_STANDARD_PROCESS_FLAG,
5661: PROCESS_CATEGORY_CODE = l_PROCESS_CATEGORY,
5662: STANDARD_VARIATION = l_STANDARD_VARIATION,
5663: ATTRIBUTE_CATEGORY = l_ATTRIBUTE_CATEGORY,
5664: ATTRIBUTE1 = l_ATTRIBUTE1,

Line 5662: STANDARD_VARIATION = l_STANDARD_VARIATION,

5658: set RL_PROCESS_REV_ID = l_RL_PROCESS_REV_ID,
5659: SIGNIFICANT_PROCESS_FLAG = l_SIGNIFICANT_PROCESS_FLAG,
5660: STANDARD_PROCESS_FLAG = l_STANDARD_PROCESS_FLAG,
5661: PROCESS_CATEGORY_CODE = l_PROCESS_CATEGORY,
5662: STANDARD_VARIATION = l_STANDARD_VARIATION,
5663: ATTRIBUTE_CATEGORY = l_ATTRIBUTE_CATEGORY,
5664: ATTRIBUTE1 = l_ATTRIBUTE1,
5665: ATTRIBUTE2 = l_ATTRIBUTE2,
5666: ATTRIBUTE3 = l_ATTRIBUTE3,