DBA Data[Home] [Help]

PACKAGE: APPS.PER_CAGR_API_PARAMETERS_PKG

Source


1 package PER_CAGR_API_PARAMETERS_PKG as
2 /* $Header: pecaplct.pkh 120.1.12000000.2 2007/05/15 08:49:23 ghshanka ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out nocopy VARCHAR2,
5   X_CAGR_API_PARAM_ID in NUMBER,
6   X_DEFAULT_UOM in VARCHAR2,
7   X_CAGR_API_ID in NUMBER,
8   X_PARAMETER_NAME in VARCHAR2,
9   X_COLUMN_TYPE in VARCHAR2,
10   X_COLUMN_SIZE in NUMBER,
11   X_UOM_PARAMETER in VARCHAR2,
12   X_UOM_LOOKUP in VARCHAR2,
13   X_HIDDEN in VARCHAR2,
14   X_OBJECT_VERSION_NUMBER in NUMBER,
15   X_DISPLAY_NAME in VARCHAR2,
16   X_CREATION_DATE in DATE,
17   X_CREATED_BY in NUMBER,
18   X_LAST_UPDATE_DATE in DATE,
19   X_LAST_UPDATED_BY in NUMBER,
20   X_LAST_UPDATE_LOGIN in NUMBER);
21 
22 procedure TRANSLATE_ROW (
23   X_DISPLAY_NAME1           in VARCHAR2 default null,
24   X_DISPLAY_NAME            in VARCHAR2,
25   X_API_NAME                in VARCHAR2 default null,
26   X_OWNER                   in VARCHAR2);
27 
28 procedure LOAD_ROW (
29  X_CAGR_API_NAME 	         in VARCHAR2,
30  X_PARAMETER_NAME          in VARCHAR2,
31  X_DISPLAY_NAME            in VARCHAR2,
32  X_OWNER                   in VARCHAR2,
33  X_OBJECT_VERSION_NUMBER   in NUMBER,
34  X_COLUMN_TYPE 	    	   in VARCHAR2,
35  X_COLUMN_SIZE 	    	   in NUMBER,
36  X_UOM_PARAMETER 	   in VARCHAR2,
37  X_UOM_LOOKUP 		   in VARCHAR2,
38  X_HIDDEN              IN VARCHAR2,
39  X_DEFAULT_UOM 	   in VARCHAR2
40  );
41 
42 
43 procedure LOCK_ROW (
44   X_CAGR_API_PARAM_ID in NUMBER,
45   X_DEFAULT_UOM in VARCHAR2,
46   X_CAGR_API_ID in NUMBER,
47   X_PARAMETER_NAME in VARCHAR2,
48   X_COLUMN_TYPE in VARCHAR2,
49   X_COLUMN_SIZE in NUMBER,
50   X_UOM_PARAMETER in VARCHAR2,
51   X_UOM_LOOKUP in VARCHAR2,
52   X_HIDDEN in VARCHAR2,
53   X_OBJECT_VERSION_NUMBER in NUMBER,
54   X_DISPLAY_NAME in VARCHAR2
55 );
56 procedure UPDATE_ROW (
57   X_CAGR_API_PARAM_ID in NUMBER,
58   X_DEFAULT_UOM in VARCHAR2,
59   X_CAGR_API_ID in NUMBER,
60   X_PARAMETER_NAME in VARCHAR2,
61   X_COLUMN_TYPE in VARCHAR2,
62   X_COLUMN_SIZE in NUMBER,
63   X_UOM_PARAMETER in VARCHAR2,
64   X_UOM_LOOKUP in VARCHAR2,
65   X_HIDDEN in VARCHAR2,
66   X_OBJECT_VERSION_NUMBER in NUMBER,
67   X_DISPLAY_NAME in VARCHAR2,
68   X_LAST_UPDATE_DATE in DATE,
69   X_LAST_UPDATED_BY in NUMBER,
70   X_LAST_UPDATE_LOGIN in NUMBER
71 );
72 procedure DELETE_ROW (
73   X_CAGR_API_PARAM_ID in NUMBER
74 );
75 procedure ADD_LANGUAGE;
76 end PER_CAGR_API_PARAMETERS_PKG;