PACKAGE: APPS.AMS_METRIC_FORMULAS_PKG

Source

1 PACKAGE AMS_METRIC_FORMULAS_PKG AUTHID CURRENT_USER as
2 /* $Header: amslmtfs.pls 115.2 2003/09/30 22:50:15 dmvincen noship $ */
3 -- ===============================================================
4 -- Package name
5 --          AMS_METRIC_FORMULAS_PKG
6 -- Purpose
7 --
8 -- History
9 --   08/20/2003  dmvincen  Created.
10 --
11 -- NOTE
12 --
13 -- ===============================================================
14 procedure INSERT_ROW (
15    X_ROWID in VARCHAR2,
16    X_METRIC_FORMULA_ID IN NUMBER,
17    X_METRIC_ID IN NUMBER,
18    X_SOURCE_TYPE in VARCHAR2,
19    X_SOURCE_ID IN NUMBER,
20    X_SOURCE_SUB_ID IN NUMBER,
21    X_USE_SUB_ID_FLAG IN VARCHAR2,
22    X_SOURCE_VALUE IN NUMBER,
23    X_TOKEN in VARCHAR2,
24    X_SEQUENCE IN NUMBER,
25    X_NOTATION_TYPE in VARCHAR2,
26    X_OBJECT_VERSION_NUMBER in NUMBER,
27    X_CREATION_DATE in DATE,
28    X_CREATED_BY in NUMBER,
29    X_LAST_UPDATE_DATE in DATE,
30    X_LAST_UPDATED_BY in NUMBER,
31    X_LAST_UPDATE_LOGIN in NUMBER
32 );
33 procedure LOCK_ROW (
34    X_METRIC_FORMULA_ID IN NUMBER,
35    X_METRIC_ID IN NUMBER,
36    X_SOURCE_TYPE in VARCHAR2,
37    X_SOURCE_ID IN NUMBER,
38    X_SOURCE_SUB_ID IN NUMBER,
39    X_USE_SUB_ID_FLAG IN VARCHAR2,
40    X_SOURCE_VALUE IN NUMBER,
41    X_TOKEN in VARCHAR2,
42    X_SEQUENCE IN NUMBER,
43    X_NOTATION_TYPE in VARCHAR2,
44    X_OBJECT_VERSION_NUMBER in NUMBER
45 );
46 procedure UPDATE_ROW (
47    X_METRIC_FORMULA_ID IN NUMBER,
48    X_METRIC_ID IN NUMBER,
49    X_SOURCE_TYPE in VARCHAR2,
50    X_SOURCE_ID IN NUMBER,
51    X_SOURCE_SUB_ID IN NUMBER,
52    X_USE_SUB_ID_FLAG IN VARCHAR2,
53    X_SOURCE_VALUE IN NUMBER,
54    X_TOKEN in VARCHAR2,
55    X_SEQUENCE IN NUMBER,
56    X_NOTATION_TYPE in VARCHAR2,
57    X_OBJECT_VERSION_NUMBER in NUMBER,
58    X_LAST_UPDATE_DATE in DATE,
59    X_LAST_UPDATED_BY in NUMBER,
60    X_LAST_UPDATE_LOGIN in NUMBER
61 );
62 procedure DELETE_ROW (
63    X_METRIC_FORMULA_ID in NUMBER
64 );
65 
66 procedure  LOAD_ROW(
67    X_METRIC_FORMULA_ID IN NUMBER,
68    X_METRIC_ID IN NUMBER,
69    X_SOURCE_TYPE in VARCHAR2,
70    X_SOURCE_ID IN NUMBER,
71    X_SOURCE_SUB_ID IN NUMBER,
72    X_USE_SUB_ID_FLAG IN VARCHAR2,
73    X_SOURCE_VALUE IN NUMBER,
74    X_TOKEN in VARCHAR2,
75    X_SEQUENCE IN NUMBER,
76    X_NOTATION_TYPE in VARCHAR2,
77    X_Owner   IN VARCHAR2,
78    X_CUSTOM_MODE IN VARCHAR2
79 );
80 
81 end AMS_METRIC_FORMULAS_PKG;