1 PACKAGE cn_objects_pkg AS
2 -- $Header: cnreobjs.pls 120.3 2005/09/20 07:12:43 hakhter noship $
3 --+
4 -- Procedure Name
5 -- insert_row
6 -- Purpose
7 -- Insert a new record in the table with values supplied by the parameters.
8 -- History
9 --+
10 PROCEDURE insert_row (
11 X_rowid IN OUT NOCOPY ROWID,
12 X_object_id cn_objects.object_id%TYPE,
13 X_dependency_map_complete cn_objects.dependency_map_complete%TYPE,
14 X_name cn_objects.name%TYPE,
15 X_description cn_objects.description%TYPE,
16 X_object_type cn_objects.object_type%TYPE,
17 X_repository_id cn_objects.repository_id%TYPE,
18 X_next_synchronization_date cn_objects.next_synchronization_date%TYPE,
19 X_synchronization_frequency cn_objects.synchronization_frequency%TYPE,
20 X_object_status cn_objects.object_status%TYPE,
21 X_object_value cn_objects.object_value%TYPE,
22 X_org_id cn_objects.org_id%TYPE);
23
24 --+
25 -- Procedure Name
26 -- select_row
27 -- Purpose
28 -- Select a row from the table, given the primary key
29 -- History
30 --+
31
32 PROCEDURE select_row(
33 recinfo IN OUT NOCOPY cn_objects%ROWTYPE);
34
35 PROCEDURE LOAD_SEED_ROW (
36 x_UPLOAD_MODE in varchar2,
37 x_OBJECT_ID in varchar2,
38 x_DEPENDENCY_MAP_COMPLETE in varchar2,
39 x_NAME in varchar2,
40 x_OBJECT_TYPE in varchar2,
41 x_REPOSITORY_ID in varchar2,
42 x_OBJECT_STATUS in varchar2,
43 x_LAST_UPDATE_DATE in varchar2,
44 x_LAST_UPDATED_BY in varchar2,
45 x_CREATION_DATE in varchar2,
46 x_CREATED_BY in varchar2,
47 x_LAST_UPDATE_LOGIN in varchar2,
48 x_DESCRIPTION in varchar2,
49 x_NEXT_SYNCHRONIZATION_DATE in varchar2,
50 x_SYNCHRONIZATION_FREQUENCY in varchar2,
51 x_DATA_LENGTH in varchar2,
52 x_DATA_TYPE in varchar2,
53 x_NULLABLE in varchar2,
54 x_PRIMARY_KEY in varchar2,
55 x_POSITION in varchar2,
56 x_DIMENSION_ID in varchar2,
57 x_DATA_SCALE in varchar2,
58 x_COLUMN_TYPE in varchar2,
59 x_TABLE_ID in varchar2,
60 x_UNIQUE_FLAG in varchar2,
61 x_PACKAGE_TYPE in varchar2,
62 x_PACKAGE_SPECIFICATION_ID in varchar2,
63 x_PARAMETER_LIST in varchar2,
64 x_RETURN_TYPE in varchar2,
65 x_PROCEDURE_TYPE in varchar2,
66 x_PACKAGE_ID in varchar2,
67 x_START_VALUE in varchar2,
68 x_INCREMENT_VALUE in varchar2,
69 x_STATEMENT_TEXT in varchar2,
70 x_ALIAS in varchar2,
71 x_TABLE_LEVEL in varchar2,
72 x_TABLE_TYPE in varchar2,
73 x_WHEN_CLAUSE in varchar2,
74 x_TRIGGERING_EVENT in varchar2,
75 x_EVENT_ID in varchar2,
76 x_PUBLIC_FLAG in varchar2,
77 x_CHILD_FLAG in varchar2,
78 x_FOR_EACH_ROW in varchar2,
79 x_TRIGGER_TYPE in varchar2,
80 x_USER_COLUMN_NAME in varchar2,
81 x_SEED_OBJECT_ID in varchar2,
82 x_PRIMARY_KEY_COLUMN_ID in varchar2,
83 x_USER_NAME_COLUMN_ID in varchar2,
84 x_CONNECT_TO_USERNAME in varchar2,
85 x_CONNECT_TO_PASSWORD in varchar2,
86 x_CONNECT_TO_HOST in varchar2,
87 x_USER_NAME in varchar2,
88 x_SCHEMA in varchar2,
89 x_FOREIGN_KEY in varchar2,
90 x_CLASSIFICATION_COLUMN in varchar2,
91 x_ORG_ID in varchar2,
92 x_CALC_FORMULA_FLAG in varchar2,
93 x_CALC_ELIGIBLE_FLAG in varchar2,
94 x_COLUMN_DATATYPE in varchar2,
95 x_VALUE_SET_ID in varchar2,
96 x_OBJECT_VALUE in varchar2,
97 x_CUSTOM_CALL in varchar2,
98 x_SECURITY_GROUP_ID in varchar2,
99 x_APPLICATION_SHORT_NAME in varchar2,
100 x_OWNER in varchar2
101 );
102
103 PROCEDURE LOAD_ROW
104 ( x_OBJECT_ID in varchar2,
105 x_DEPENDENCY_MAP_COMPLETE in varchar2,
106 x_NAME in varchar2,
107 x_OBJECT_TYPE in varchar2,
108 x_REPOSITORY_ID in varchar2,
109 x_OBJECT_STATUS in varchar2,
110 x_LAST_UPDATE_DATE in varchar2,
111 x_LAST_UPDATED_BY in varchar2,
112 x_CREATION_DATE in varchar2,
113 x_CREATED_BY in varchar2,
114 x_LAST_UPDATE_LOGIN in varchar2,
115 x_DESCRIPTION in varchar2,
116 x_NEXT_SYNCHRONIZATION_DATE in varchar2,
117 x_SYNCHRONIZATION_FREQUENCY in varchar2,
118 x_DATA_LENGTH in varchar2,
119 x_DATA_TYPE in varchar2,
120 x_NULLABLE in varchar2,
121 x_PRIMARY_KEY in varchar2,
122 x_POSITION in varchar2,
123 x_DIMENSION_ID in varchar2,
124 x_DATA_SCALE in varchar2,
125 x_COLUMN_TYPE in varchar2,
126 x_TABLE_ID in varchar2,
127 x_UNIQUE_FLAG in varchar2,
128 x_PACKAGE_TYPE in varchar2,
129 x_PACKAGE_SPECIFICATION_ID in varchar2,
130 x_PARAMETER_LIST in varchar2,
131 x_RETURN_TYPE in varchar2,
132 x_PROCEDURE_TYPE in varchar2,
133 x_PACKAGE_ID in varchar2,
134 x_START_VALUE in varchar2,
135 x_INCREMENT_VALUE in varchar2,
136 x_STATEMENT_TEXT in varchar2,
137 x_ALIAS in varchar2,
138 x_TABLE_LEVEL in varchar2,
139 x_TABLE_TYPE in varchar2,
140 x_WHEN_CLAUSE in varchar2,
141 x_TRIGGERING_EVENT in varchar2,
142 x_EVENT_ID in varchar2,
143 x_PUBLIC_FLAG in varchar2,
144 x_CHILD_FLAG in varchar2,
145 x_FOR_EACH_ROW in varchar2,
146 x_TRIGGER_TYPE in varchar2,
147 x_USER_COLUMN_NAME in varchar2,
148 x_SEED_OBJECT_ID in varchar2,
149 x_PRIMARY_KEY_COLUMN_ID in varchar2,
150 x_USER_NAME_COLUMN_ID in varchar2,
151 x_CONNECT_TO_USERNAME in varchar2,
152 x_CONNECT_TO_PASSWORD in varchar2,
153 x_CONNECT_TO_HOST in varchar2,
154 x_USER_NAME in varchar2,
155 x_SCHEMA in varchar2,
156 x_FOREIGN_KEY in varchar2,
157 x_CLASSIFICATION_COLUMN in varchar2,
158 x_ORG_ID in varchar2,
159 x_CALC_FORMULA_FLAG in varchar2,
160 x_CALC_ELIGIBLE_FLAG in varchar2,
161 x_COLUMN_DATATYPE in varchar2,
162 x_VALUE_SET_ID in varchar2,
163 x_OBJECT_VALUE in varchar2,
164 x_CUSTOM_CALL in varchar2,
165 x_SECURITY_GROUP_ID in varchar2,
166 x_APPLICATION_SHORT_NAME in varchar2,
167 x_OWNER in varchar2);
168
169 END cn_objects_pkg;
[Home] [Help]