15: X_PROCESS_TYPE in VARCHAR2,
16: X_CONTROL_ACTIVITY_TYPE in VARCHAR2,
17: X_RISK_COUNT_LATEST in NUMBER,
18: X_CONTROL_COUNT_LATEST in NUMBER,
19: X_STANDARD_VARIATION in NUMBER,
20: X_SIGNIFICANT_PROCESS_FLAG in VARCHAR2,
21: X_STANDARD_PROCESS_FLAG in VARCHAR2,
22: X_APPROVAL_STATUS in VARCHAR2,
23: X_CERTIFICATION_STATUS in VARCHAR2,
17: X_RISK_COUNT_LATEST in NUMBER,
18: X_CONTROL_COUNT_LATEST in NUMBER,
19: X_STANDARD_VARIATION in NUMBER,
20: X_SIGNIFICANT_PROCESS_FLAG in VARCHAR2,
21: X_STANDARD_PROCESS_FLAG in VARCHAR2,
22: X_APPROVAL_STATUS in VARCHAR2,
23: X_CERTIFICATION_STATUS in VARCHAR2,
24: X_PROCESS_CATEGORY in VARCHAR2,
25: X_PROCESS_OWNER_ID in NUMBER,
74: PROCESS_TYPE,
75: CONTROL_ACTIVITY_TYPE,
76: RISK_COUNT_LATEST,
77: CONTROL_COUNT_LATEST,
78: STANDARD_VARIATION,
79: PROCESS_REV_ID,
80: SIGNIFICANT_PROCESS_FLAG,
81: STANDARD_PROCESS_FLAG,
82: APPROVAL_STATUS,
77: CONTROL_COUNT_LATEST,
78: STANDARD_VARIATION,
79: PROCESS_REV_ID,
80: SIGNIFICANT_PROCESS_FLAG,
81: STANDARD_PROCESS_FLAG,
82: APPROVAL_STATUS,
83: CERTIFICATION_STATUS,
84: PROCESS_CATEGORY,
85: PROCESS_OWNER_ID,
127: X_PROCESS_TYPE,
128: X_CONTROL_ACTIVITY_TYPE,
129: X_RISK_COUNT_LATEST,
130: X_CONTROL_COUNT_LATEST,
131: X_STANDARD_VARIATION,
132: X_PROCESS_REV_ID,
133: X_SIGNIFICANT_PROCESS_FLAG,
134: X_STANDARD_PROCESS_FLAG,
135: X_APPROVAL_STATUS,
130: X_CONTROL_COUNT_LATEST,
131: X_STANDARD_VARIATION,
132: X_PROCESS_REV_ID,
133: X_SIGNIFICANT_PROCESS_FLAG,
134: X_STANDARD_PROCESS_FLAG,
135: X_APPROVAL_STATUS,
136: X_CERTIFICATION_STATUS,
137: X_PROCESS_CATEGORY,
138: X_PROCESS_OWNER_ID,
229: X_PROCESS_TYPE in VARCHAR2,
230: X_CONTROL_ACTIVITY_TYPE in VARCHAR2,
231: X_RISK_COUNT_LATEST in NUMBER,
232: X_CONTROL_COUNT_LATEST in NUMBER,
233: X_STANDARD_VARIATION in NUMBER,
234: X_SIGNIFICANT_PROCESS_FLAG in VARCHAR2,
235: X_STANDARD_PROCESS_FLAG in VARCHAR2,
236: X_APPROVAL_STATUS in VARCHAR2,
237: X_CERTIFICATION_STATUS in VARCHAR2,
231: X_RISK_COUNT_LATEST in NUMBER,
232: X_CONTROL_COUNT_LATEST in NUMBER,
233: X_STANDARD_VARIATION in NUMBER,
234: X_SIGNIFICANT_PROCESS_FLAG in VARCHAR2,
235: X_STANDARD_PROCESS_FLAG in VARCHAR2,
236: X_APPROVAL_STATUS in VARCHAR2,
237: X_CERTIFICATION_STATUS in VARCHAR2,
238: X_PROCESS_CATEGORY in VARCHAR2,
239: X_PROCESS_OWNER_ID in NUMBER,
279: PROCESS_TYPE,
280: CONTROL_ACTIVITY_TYPE,
281: RISK_COUNT_LATEST,
282: CONTROL_COUNT_LATEST,
283: STANDARD_VARIATION,
284: SIGNIFICANT_PROCESS_FLAG,
285: STANDARD_PROCESS_FLAG,
286: APPROVAL_STATUS,
287: CERTIFICATION_STATUS,
281: RISK_COUNT_LATEST,
282: CONTROL_COUNT_LATEST,
283: STANDARD_VARIATION,
284: SIGNIFICANT_PROCESS_FLAG,
285: STANDARD_PROCESS_FLAG,
286: APPROVAL_STATUS,
287: CERTIFICATION_STATUS,
288: PROCESS_CATEGORY,
289: PROCESS_OWNER_ID,
359: AND ((recinfo.RISK_COUNT_LATEST = X_RISK_COUNT_LATEST)
360: OR ((recinfo.RISK_COUNT_LATEST is null) AND (X_RISK_COUNT_LATEST is null)))
361: AND ((recinfo.CONTROL_COUNT_LATEST = X_CONTROL_COUNT_LATEST)
362: OR ((recinfo.CONTROL_COUNT_LATEST is null) AND (X_CONTROL_COUNT_LATEST is null)))
363: AND ((recinfo.STANDARD_VARIATION = X_STANDARD_VARIATION)
364: OR ((recinfo.STANDARD_VARIATION is null) AND (X_STANDARD_VARIATION is null)))
365: AND ((recinfo.SIGNIFICANT_PROCESS_FLAG = X_SIGNIFICANT_PROCESS_FLAG)
366: OR ((recinfo.SIGNIFICANT_PROCESS_FLAG is null) AND (X_SIGNIFICANT_PROCESS_FLAG is null)))
367: AND ((recinfo.STANDARD_PROCESS_FLAG = X_STANDARD_PROCESS_FLAG)
360: OR ((recinfo.RISK_COUNT_LATEST is null) AND (X_RISK_COUNT_LATEST is null)))
361: AND ((recinfo.CONTROL_COUNT_LATEST = X_CONTROL_COUNT_LATEST)
362: OR ((recinfo.CONTROL_COUNT_LATEST is null) AND (X_CONTROL_COUNT_LATEST is null)))
363: AND ((recinfo.STANDARD_VARIATION = X_STANDARD_VARIATION)
364: OR ((recinfo.STANDARD_VARIATION is null) AND (X_STANDARD_VARIATION is null)))
365: AND ((recinfo.SIGNIFICANT_PROCESS_FLAG = X_SIGNIFICANT_PROCESS_FLAG)
366: OR ((recinfo.SIGNIFICANT_PROCESS_FLAG is null) AND (X_SIGNIFICANT_PROCESS_FLAG is null)))
367: AND ((recinfo.STANDARD_PROCESS_FLAG = X_STANDARD_PROCESS_FLAG)
368: OR ((recinfo.STANDARD_PROCESS_FLAG is null) AND (X_STANDARD_PROCESS_FLAG is null)))
363: AND ((recinfo.STANDARD_VARIATION = X_STANDARD_VARIATION)
364: OR ((recinfo.STANDARD_VARIATION is null) AND (X_STANDARD_VARIATION is null)))
365: AND ((recinfo.SIGNIFICANT_PROCESS_FLAG = X_SIGNIFICANT_PROCESS_FLAG)
366: OR ((recinfo.SIGNIFICANT_PROCESS_FLAG is null) AND (X_SIGNIFICANT_PROCESS_FLAG is null)))
367: AND ((recinfo.STANDARD_PROCESS_FLAG = X_STANDARD_PROCESS_FLAG)
368: OR ((recinfo.STANDARD_PROCESS_FLAG is null) AND (X_STANDARD_PROCESS_FLAG is null)))
369: AND ((recinfo.APPROVAL_STATUS = X_APPROVAL_STATUS)
370: OR ((recinfo.APPROVAL_STATUS is null) AND (X_APPROVAL_STATUS is null)))
371: AND ((recinfo.CERTIFICATION_STATUS = X_CERTIFICATION_STATUS)
364: OR ((recinfo.STANDARD_VARIATION is null) AND (X_STANDARD_VARIATION is null)))
365: AND ((recinfo.SIGNIFICANT_PROCESS_FLAG = X_SIGNIFICANT_PROCESS_FLAG)
366: OR ((recinfo.SIGNIFICANT_PROCESS_FLAG is null) AND (X_SIGNIFICANT_PROCESS_FLAG is null)))
367: AND ((recinfo.STANDARD_PROCESS_FLAG = X_STANDARD_PROCESS_FLAG)
368: OR ((recinfo.STANDARD_PROCESS_FLAG is null) AND (X_STANDARD_PROCESS_FLAG is null)))
369: AND ((recinfo.APPROVAL_STATUS = X_APPROVAL_STATUS)
370: OR ((recinfo.APPROVAL_STATUS is null) AND (X_APPROVAL_STATUS is null)))
371: AND ((recinfo.CERTIFICATION_STATUS = X_CERTIFICATION_STATUS)
372: OR ((recinfo.CERTIFICATION_STATUS is null) AND (X_CERTIFICATION_STATUS is null)))
462: X_PROCESS_TYPE in VARCHAR2,
463: X_CONTROL_ACTIVITY_TYPE in VARCHAR2,
464: X_RISK_COUNT_LATEST in NUMBER,
465: X_CONTROL_COUNT_LATEST in NUMBER,
466: X_STANDARD_VARIATION in NUMBER,
467: X_SIGNIFICANT_PROCESS_FLAG in VARCHAR2,
468: X_STANDARD_PROCESS_FLAG in VARCHAR2,
469: X_APPROVAL_STATUS in VARCHAR2,
470: X_CERTIFICATION_STATUS in VARCHAR2,
464: X_RISK_COUNT_LATEST in NUMBER,
465: X_CONTROL_COUNT_LATEST in NUMBER,
466: X_STANDARD_VARIATION in NUMBER,
467: X_SIGNIFICANT_PROCESS_FLAG in VARCHAR2,
468: X_STANDARD_PROCESS_FLAG in VARCHAR2,
469: X_APPROVAL_STATUS in VARCHAR2,
470: X_CERTIFICATION_STATUS in VARCHAR2,
471: X_PROCESS_CATEGORY in VARCHAR2,
472: X_PROCESS_OWNER_ID in NUMBER,
516: PROCESS_TYPE = X_PROCESS_TYPE,
517: CONTROL_ACTIVITY_TYPE = X_CONTROL_ACTIVITY_TYPE,
518: RISK_COUNT_LATEST = X_RISK_COUNT_LATEST,
519: CONTROL_COUNT_LATEST = X_CONTROL_COUNT_LATEST,
520: STANDARD_VARIATION = X_STANDARD_VARIATION,
521: SIGNIFICANT_PROCESS_FLAG = X_SIGNIFICANT_PROCESS_FLAG,
522: STANDARD_PROCESS_FLAG = X_STANDARD_PROCESS_FLAG,
523: APPROVAL_STATUS = X_APPROVAL_STATUS,
524: CERTIFICATION_STATUS = X_CERTIFICATION_STATUS,
518: RISK_COUNT_LATEST = X_RISK_COUNT_LATEST,
519: CONTROL_COUNT_LATEST = X_CONTROL_COUNT_LATEST,
520: STANDARD_VARIATION = X_STANDARD_VARIATION,
521: SIGNIFICANT_PROCESS_FLAG = X_SIGNIFICANT_PROCESS_FLAG,
522: STANDARD_PROCESS_FLAG = X_STANDARD_PROCESS_FLAG,
523: APPROVAL_STATUS = X_APPROVAL_STATUS,
524: CERTIFICATION_STATUS = X_CERTIFICATION_STATUS,
525: PROCESS_CATEGORY = X_PROCESS_CATEGORY,
526: PROCESS_OWNER_ID = X_PROCESS_OWNER_ID,
701: X_PROCESS_TYPE => 'P',
702: X_CONTROL_ACTIVITY_TYPE => null,
703: X_RISK_COUNT_LATEST => null,
704: X_CONTROL_COUNT_LATEST => null,
705: X_STANDARD_VARIATION => null,
706: X_SIGNIFICANT_PROCESS_FLAG => null,
707: X_STANDARD_PROCESS_FLAG => null,
708: X_APPROVAL_STATUS => 'A',
709: X_CERTIFICATION_STATUS => null,
703: X_RISK_COUNT_LATEST => null,
704: X_CONTROL_COUNT_LATEST => null,
705: X_STANDARD_VARIATION => null,
706: X_SIGNIFICANT_PROCESS_FLAG => null,
707: X_STANDARD_PROCESS_FLAG => null,
708: X_APPROVAL_STATUS => 'A',
709: X_CERTIFICATION_STATUS => null,
710: X_PROCESS_CATEGORY => null,
711: X_PROCESS_OWNER_ID => null,
759: X_PROCESS_TYPE => 'P',
760: X_CONTROL_ACTIVITY_TYPE => null,
761: X_RISK_COUNT_LATEST => null,
762: X_CONTROL_COUNT_LATEST => null,
763: X_STANDARD_VARIATION => null,
764: X_SIGNIFICANT_PROCESS_FLAG => null,
765: X_STANDARD_PROCESS_FLAG => null,
766: X_APPROVAL_STATUS => 'A',
767: X_CERTIFICATION_STATUS => null,
761: X_RISK_COUNT_LATEST => null,
762: X_CONTROL_COUNT_LATEST => null,
763: X_STANDARD_VARIATION => null,
764: X_SIGNIFICANT_PROCESS_FLAG => null,
765: X_STANDARD_PROCESS_FLAG => null,
766: X_APPROVAL_STATUS => 'A',
767: X_CERTIFICATION_STATUS => null,
768: X_PROCESS_CATEGORY => null,
769: X_PROCESS_OWNER_ID => null,