DBA Data[Home] [Help]

APPS.AMW_PROCESS_NAMES_PKG dependencies on STANDARD

Line 19: X_STANDARD_VARIATION in NUMBER,

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,

Line 21: X_STANDARD_PROCESS_FLAG 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,

Line 78: STANDARD_VARIATION,

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,

Line 81: STANDARD_PROCESS_FLAG,

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,

Line 131: X_STANDARD_VARIATION,

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,

Line 134: X_STANDARD_PROCESS_FLAG,

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,

Line 233: X_STANDARD_VARIATION in NUMBER,

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,

Line 235: X_STANDARD_PROCESS_FLAG 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,

Line 283: STANDARD_VARIATION,

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,

Line 285: STANDARD_PROCESS_FLAG,

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,

Line 363: AND ((recinfo.STANDARD_VARIATION = X_STANDARD_VARIATION)

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)

Line 364: OR ((recinfo.STANDARD_VARIATION is null) AND (X_STANDARD_VARIATION is null)))

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)))

Line 367: AND ((recinfo.STANDARD_PROCESS_FLAG = X_STANDARD_PROCESS_FLAG)

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)

Line 368: OR ((recinfo.STANDARD_PROCESS_FLAG is null) AND (X_STANDARD_PROCESS_FLAG is null)))

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)))

Line 466: X_STANDARD_VARIATION in NUMBER,

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,

Line 468: X_STANDARD_PROCESS_FLAG 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,

Line 520: STANDARD_VARIATION = X_STANDARD_VARIATION,

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,

Line 522: STANDARD_PROCESS_FLAG = X_STANDARD_PROCESS_FLAG,

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,

Line 705: X_STANDARD_VARIATION => null,

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,

Line 707: X_STANDARD_PROCESS_FLAG => 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,

Line 763: X_STANDARD_VARIATION => 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,

Line 765: X_STANDARD_PROCESS_FLAG => 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,