1 package AMS_METRICS_ALL_PKG as
2 /* $Header: amslmtcs.pls 120.1 2005/08/16 13:24:45 appldev ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_METRICS_ALL_PKG
7 -- Purpose
8 --
9 -- History
10 -- 03/06/2003 dmvincen BUG2819067: Do not update if customized.
11 -- 08/20/2003 dmvincen Add Display_type
12 -- 08/16/2005 dmvincen Added Target_type, and denorm_code
13 --
14 -- NOTE
15 --
16 -- End of Comments
17 -- ===============================================================
18 procedure INSERT_ROW (
19 X_ROWID in VARCHAR2,
20 X_METRIC_ID in NUMBER,
21 X_OBJECT_VERSION_NUMBER in NUMBER,
22 X_ARC_METRIC_USED_FOR_OBJECT in VARCHAR2,
23 X_METRIC_CALCULATION_TYPE in VARCHAR2,
24 X_APPLICATION_ID in NUMBER,
25 X_METRIC_CATEGORY in NUMBER,
26 X_ACCRUAL_TYPE in VARCHAR2,
27 X_VALUE_TYPE in VARCHAR2,
28 X_SENSITIVE_DATA_FLAG in VARCHAR2,
29 X_ENABLED_FLAG in VARCHAR2,
30 X_METRIC_SUB_CATEGORY in NUMBER,
31 X_FUNCTION_NAME in VARCHAR2,
32 X_FUNCTION_TYPE in VARCHAR2,
33 X_METRIC_PARENT_ID in NUMBER,
34 X_SUMMARY_METRIC_ID in NUMBER,
35 X_COMPUTE_USING_FUNCTION in VARCHAR2,
36 X_DEFAULT_UOM_CODE in VARCHAR2,
37 X_UOM_TYPE in VARCHAR2,
38 X_FORMULA in VARCHAR2,
39 X_DISPLAY_TYPE in VARCHAR2,
40 X_METRICS_NAME in VARCHAR2,
41 X_DESCRIPTION in VARCHAR2,
42 X_FORMULA_DISPLAY in VARCHAR2,
43 X_TARGET_TYPE in VARCHAR2,
44 X_DENORM_CODE in VARCHAR2,
45 X_CREATION_DATE in DATE,
46 X_CREATED_BY in NUMBER,
47 X_LAST_UPDATE_DATE in DATE,
48 X_LAST_UPDATED_BY in NUMBER,
49 X_LAST_UPDATE_LOGIN in NUMBER);
50 procedure LOCK_ROW (
51 X_METRIC_ID in NUMBER,
52 X_OBJECT_VERSION_NUMBER in NUMBER,
53 X_ARC_METRIC_USED_FOR_OBJECT in VARCHAR2,
54 X_METRIC_CALCULATION_TYPE in VARCHAR2,
55 X_APPLICATION_ID in NUMBER,
56 X_METRIC_CATEGORY in NUMBER,
57 X_ACCRUAL_TYPE in VARCHAR2,
58 X_VALUE_TYPE in VARCHAR2,
59 X_SENSITIVE_DATA_FLAG in VARCHAR2,
60 X_ENABLED_FLAG in VARCHAR2,
61 X_METRIC_SUB_CATEGORY in NUMBER,
62 X_FUNCTION_NAME in VARCHAR2,
63 X_FUNCTION_TYPE in VARCHAR2,
64 X_METRIC_PARENT_ID in NUMBER,
65 X_SUMMARY_METRIC_ID in NUMBER,
66 X_COMPUTE_USING_FUNCTION in VARCHAR2,
67 X_DEFAULT_UOM_CODE in VARCHAR2,
68 X_UOM_TYPE in VARCHAR2,
69 X_FORMULA in VARCHAR2,
70 X_DISPLAY_TYPE in VARCHAR2,
71 X_METRICS_NAME in VARCHAR2,
72 X_DESCRIPTION in VARCHAR2,
73 X_FORMULA_DISPLAY in VARCHAR2,
74 X_TARGET_TYPE in VARCHAR2,
75 X_DENORM_CODE in VARCHAR2
76 );
77 procedure UPDATE_ROW (
78 X_METRIC_ID in NUMBER,
79 X_OBJECT_VERSION_NUMBER in NUMBER,
80 X_ARC_METRIC_USED_FOR_OBJECT in VARCHAR2,
81 X_METRIC_CALCULATION_TYPE in VARCHAR2,
82 X_APPLICATION_ID in NUMBER,
83 X_METRIC_CATEGORY in NUMBER,
84 X_ACCRUAL_TYPE in VARCHAR2,
85 X_VALUE_TYPE in VARCHAR2,
86 X_SENSITIVE_DATA_FLAG in VARCHAR2,
87 X_ENABLED_FLAG in VARCHAR2,
88 X_METRIC_SUB_CATEGORY in NUMBER,
89 X_FUNCTION_NAME in VARCHAR2,
90 X_FUNCTION_TYPE in VARCHAR2,
91 X_METRIC_PARENT_ID in NUMBER,
92 X_SUMMARY_METRIC_ID in NUMBER,
93 X_COMPUTE_USING_FUNCTION in VARCHAR2,
94 X_DEFAULT_UOM_CODE in VARCHAR2,
95 X_UOM_TYPE in VARCHAR2,
96 X_FORMULA in VARCHAR2,
97 X_DISPLAY_TYPE in VARCHAR2,
98 X_METRICS_NAME in VARCHAR2,
99 X_DESCRIPTION in VARCHAR2,
100 X_FORMULA_DISPLAY in VARCHAR2,
101 X_TARGET_TYPE in VARCHAR2,
102 X_DENORM_CODE in VARCHAR2,
103 X_LAST_UPDATE_DATE in DATE,
104 X_LAST_UPDATED_BY in NUMBER,
105 X_LAST_UPDATE_LOGIN in NUMBER
106 );
107 procedure DELETE_ROW (
108 X_METRIC_ID in NUMBER
109 );
110 procedure ADD_LANGUAGE;
111
112 procedure TRANSLATE_ROW(
113 x_metric_id in NUMBER,
114 X_METRICS_NAME in VARCHAR2,
115 X_DESCRIPTION in VARCHAR2,
116 x_owner in VARCHAR2
117 ) ;
118
119 procedure LOAD_ROW(
120 X_METRIC_ID in NUMBER,
121 X_ARC_METRIC_USED_FOR_OBJECT in VARCHAR2,
122 X_METRIC_CALCULATION_TYPE in VARCHAR2,
123 X_APPLICATION_ID in NUMBER,
124 X_METRIC_CATEGORY in NUMBER,
125 X_ACCRUAL_TYPE in VARCHAR2,
126 X_VALUE_TYPE in VARCHAR2,
127 X_SENSITIVE_DATA_FLAG in VARCHAR2,
128 X_ENABLED_FLAG in VARCHAR2,
129 X_METRIC_SUB_CATEGORY in NUMBER,
130 X_FUNCTION_NAME in VARCHAR2,
131 X_FUNCTION_TYPE in VARCHAR2,
132 X_METRIC_PARENT_ID in NUMBER,
133 X_SUMMARY_METRIC_ID in NUMBER,
134 X_COMPUTE_USING_FUNCTION in VARCHAR2,
135 X_DEFAULT_UOM_CODE in VARCHAR2,
136 X_UOM_TYPE in VARCHAR2,
137 X_FORMULA in VARCHAR2,
138 X_DISPLAY_TYPE in VARCHAR2,
139 X_METRICS_NAME in VARCHAR2,
140 X_DESCRIPTION in VARCHAR2,
141 X_FORMULA_DISPLAY in VARCHAR2,
142 X_TARGET_TYPE in VARCHAR2,
143 X_DENORM_CODE in VARCHAR2,
144 X_Owner IN VARCHAR2,
145 X_CUSTOM_MODE IN VARCHAR2
146 );
147
148
149
150 end AMS_METRICS_ALL_PKG;