1: PACKAGE BODY IMC_OBJECT_METADATA_PUB AS
2: /* $Header: imcomdb.pls 115.4 2002/11/12 21:53:08 tsli noship $ */
3:
4: /*=======================================================================*/
5:
3:
4: /*=======================================================================*/
5:
6: FUNCTION Object_Metadata_Exists (
7: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE
8: ) RETURN VARCHAR2 AS
9:
10: l_dummy NUMBER;
11:
20: END IF;
21:
22: SELECT 1
23: INTO l_dummy
24: FROM IMC_OBJECT_METADATA
25: WHERE OBJECT_TYPE = p_object_type
26: AND ROWNUM = 1;
27:
28: RETURN 'Y';
47:
48: /*=======================================================================*/
49:
50: PROCEDURE Update_Record (
51: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,
52: p_description IN IMC_OBJECT_METADATA.description%TYPE,
53: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
54: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
55: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
48: /*=======================================================================*/
49:
50: PROCEDURE Update_Record (
51: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,
52: p_description IN IMC_OBJECT_METADATA.description%TYPE,
53: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
54: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
55: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
56: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
49:
50: PROCEDURE Update_Record (
51: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,
52: p_description IN IMC_OBJECT_METADATA.description%TYPE,
53: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
54: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
55: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
56: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
57: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
50: PROCEDURE Update_Record (
51: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,
52: p_description IN IMC_OBJECT_METADATA.description%TYPE,
53: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
54: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
55: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
56: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
57: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
58: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
51: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,
52: p_description IN IMC_OBJECT_METADATA.description%TYPE,
53: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
54: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
55: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
56: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
57: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
58: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
59: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
52: p_description IN IMC_OBJECT_METADATA.description%TYPE,
53: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
54: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
55: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
56: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
57: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
58: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
59: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
60: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
53: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
54: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
55: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
56: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
57: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
58: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
59: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
60: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
61: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
54: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
55: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
56: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
57: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
58: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
59: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
60: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
61: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
62: p_created_by IN IMC_OBJECT_METADATA.created_by%TYPE,
55: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
56: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
57: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
58: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
59: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
60: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
61: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
62: p_created_by IN IMC_OBJECT_METADATA.created_by%TYPE,
63: p_creation_date IN IMC_OBJECT_METADATA.creation_date%TYPE,
56: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
57: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
58: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
59: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
60: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
61: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
62: p_created_by IN IMC_OBJECT_METADATA.created_by%TYPE,
63: p_creation_date IN IMC_OBJECT_METADATA.creation_date%TYPE,
64: p_last_updated_by IN IMC_OBJECT_METADATA.last_updated_by%TYPE,
57: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
58: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
59: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
60: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
61: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
62: p_created_by IN IMC_OBJECT_METADATA.created_by%TYPE,
63: p_creation_date IN IMC_OBJECT_METADATA.creation_date%TYPE,
64: p_last_updated_by IN IMC_OBJECT_METADATA.last_updated_by%TYPE,
65: p_last_update_date IN IMC_OBJECT_METADATA.last_update_date%TYPE,
58: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
59: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
60: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
61: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
62: p_created_by IN IMC_OBJECT_METADATA.created_by%TYPE,
63: p_creation_date IN IMC_OBJECT_METADATA.creation_date%TYPE,
64: p_last_updated_by IN IMC_OBJECT_METADATA.last_updated_by%TYPE,
65: p_last_update_date IN IMC_OBJECT_METADATA.last_update_date%TYPE,
66: p_last_update_login IN IMC_OBJECT_METADATA.last_update_login%TYPE
59: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
60: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
61: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
62: p_created_by IN IMC_OBJECT_METADATA.created_by%TYPE,
63: p_creation_date IN IMC_OBJECT_METADATA.creation_date%TYPE,
64: p_last_updated_by IN IMC_OBJECT_METADATA.last_updated_by%TYPE,
65: p_last_update_date IN IMC_OBJECT_METADATA.last_update_date%TYPE,
66: p_last_update_login IN IMC_OBJECT_METADATA.last_update_login%TYPE
67: ) AS
60: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
61: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
62: p_created_by IN IMC_OBJECT_METADATA.created_by%TYPE,
63: p_creation_date IN IMC_OBJECT_METADATA.creation_date%TYPE,
64: p_last_updated_by IN IMC_OBJECT_METADATA.last_updated_by%TYPE,
65: p_last_update_date IN IMC_OBJECT_METADATA.last_update_date%TYPE,
66: p_last_update_login IN IMC_OBJECT_METADATA.last_update_login%TYPE
67: ) AS
68:
61: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
62: p_created_by IN IMC_OBJECT_METADATA.created_by%TYPE,
63: p_creation_date IN IMC_OBJECT_METADATA.creation_date%TYPE,
64: p_last_updated_by IN IMC_OBJECT_METADATA.last_updated_by%TYPE,
65: p_last_update_date IN IMC_OBJECT_METADATA.last_update_date%TYPE,
66: p_last_update_login IN IMC_OBJECT_METADATA.last_update_login%TYPE
67: ) AS
68:
69: BEGIN
62: p_created_by IN IMC_OBJECT_METADATA.created_by%TYPE,
63: p_creation_date IN IMC_OBJECT_METADATA.creation_date%TYPE,
64: p_last_updated_by IN IMC_OBJECT_METADATA.last_updated_by%TYPE,
65: p_last_update_date IN IMC_OBJECT_METADATA.last_update_date%TYPE,
66: p_last_update_login IN IMC_OBJECT_METADATA.last_update_login%TYPE
67: ) AS
68:
69: BEGIN
70:
67: ) AS
68:
69: BEGIN
70:
71: UPDATE IMC_OBJECT_METADATA SET
72: DESCRIPTION = p_description,
73: FUNCTION_NAME = p_function_name,
74: PARAMETER_NAME = p_parameter_name,
75: ENABLED = p_enabled,
96:
97: /*=======================================================================*/
98:
99: PROCEDURE Insert_Record (
100: p_metadata_id IN IMC_OBJECT_METADATA.metadata_id%TYPE,
101: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,
102: p_description IN IMC_OBJECT_METADATA.description%TYPE,
103: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
104: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
97: /*=======================================================================*/
98:
99: PROCEDURE Insert_Record (
100: p_metadata_id IN IMC_OBJECT_METADATA.metadata_id%TYPE,
101: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,
102: p_description IN IMC_OBJECT_METADATA.description%TYPE,
103: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
104: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
105: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
98:
99: PROCEDURE Insert_Record (
100: p_metadata_id IN IMC_OBJECT_METADATA.metadata_id%TYPE,
101: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,
102: p_description IN IMC_OBJECT_METADATA.description%TYPE,
103: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
104: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
105: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
106: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
99: PROCEDURE Insert_Record (
100: p_metadata_id IN IMC_OBJECT_METADATA.metadata_id%TYPE,
101: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,
102: p_description IN IMC_OBJECT_METADATA.description%TYPE,
103: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
104: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
105: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
106: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
107: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
100: p_metadata_id IN IMC_OBJECT_METADATA.metadata_id%TYPE,
101: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,
102: p_description IN IMC_OBJECT_METADATA.description%TYPE,
103: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
104: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
105: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
106: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
107: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
108: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
101: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,
102: p_description IN IMC_OBJECT_METADATA.description%TYPE,
103: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
104: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
105: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
106: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
107: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
108: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
109: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
102: p_description IN IMC_OBJECT_METADATA.description%TYPE,
103: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
104: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
105: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
106: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
107: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
108: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
109: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
110: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
103: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
104: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
105: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
106: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
107: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
108: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
109: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
110: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
111: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
104: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
105: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
106: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
107: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
108: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
109: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
110: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
111: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
112: p_created_by IN IMC_OBJECT_METADATA.created_by%TYPE,
105: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
106: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
107: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
108: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
109: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
110: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
111: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
112: p_created_by IN IMC_OBJECT_METADATA.created_by%TYPE,
113: p_creation_date IN IMC_OBJECT_METADATA.creation_date%TYPE,
106: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
107: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
108: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
109: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
110: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
111: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
112: p_created_by IN IMC_OBJECT_METADATA.created_by%TYPE,
113: p_creation_date IN IMC_OBJECT_METADATA.creation_date%TYPE,
114: p_last_updated_by IN IMC_OBJECT_METADATA.last_updated_by%TYPE,
107: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
108: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
109: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
110: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
111: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
112: p_created_by IN IMC_OBJECT_METADATA.created_by%TYPE,
113: p_creation_date IN IMC_OBJECT_METADATA.creation_date%TYPE,
114: p_last_updated_by IN IMC_OBJECT_METADATA.last_updated_by%TYPE,
115: p_last_update_date IN IMC_OBJECT_METADATA.last_update_date%TYPE,
108: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
109: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
110: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
111: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
112: p_created_by IN IMC_OBJECT_METADATA.created_by%TYPE,
113: p_creation_date IN IMC_OBJECT_METADATA.creation_date%TYPE,
114: p_last_updated_by IN IMC_OBJECT_METADATA.last_updated_by%TYPE,
115: p_last_update_date IN IMC_OBJECT_METADATA.last_update_date%TYPE,
116: p_last_update_login IN IMC_OBJECT_METADATA.last_update_login%TYPE
109: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
110: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
111: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
112: p_created_by IN IMC_OBJECT_METADATA.created_by%TYPE,
113: p_creation_date IN IMC_OBJECT_METADATA.creation_date%TYPE,
114: p_last_updated_by IN IMC_OBJECT_METADATA.last_updated_by%TYPE,
115: p_last_update_date IN IMC_OBJECT_METADATA.last_update_date%TYPE,
116: p_last_update_login IN IMC_OBJECT_METADATA.last_update_login%TYPE
117: ) AS
110: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
111: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
112: p_created_by IN IMC_OBJECT_METADATA.created_by%TYPE,
113: p_creation_date IN IMC_OBJECT_METADATA.creation_date%TYPE,
114: p_last_updated_by IN IMC_OBJECT_METADATA.last_updated_by%TYPE,
115: p_last_update_date IN IMC_OBJECT_METADATA.last_update_date%TYPE,
116: p_last_update_login IN IMC_OBJECT_METADATA.last_update_login%TYPE
117: ) AS
118:
111: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
112: p_created_by IN IMC_OBJECT_METADATA.created_by%TYPE,
113: p_creation_date IN IMC_OBJECT_METADATA.creation_date%TYPE,
114: p_last_updated_by IN IMC_OBJECT_METADATA.last_updated_by%TYPE,
115: p_last_update_date IN IMC_OBJECT_METADATA.last_update_date%TYPE,
116: p_last_update_login IN IMC_OBJECT_METADATA.last_update_login%TYPE
117: ) AS
118:
119: BEGIN
112: p_created_by IN IMC_OBJECT_METADATA.created_by%TYPE,
113: p_creation_date IN IMC_OBJECT_METADATA.creation_date%TYPE,
114: p_last_updated_by IN IMC_OBJECT_METADATA.last_updated_by%TYPE,
115: p_last_update_date IN IMC_OBJECT_METADATA.last_update_date%TYPE,
116: p_last_update_login IN IMC_OBJECT_METADATA.last_update_login%TYPE
117: ) AS
118:
119: BEGIN
120:
117: ) AS
118:
119: BEGIN
120:
121: INSERT INTO IMC_OBJECT_METADATA (
122: METADATA_ID,
123: OBJECT_TYPE,
124: DESCRIPTION,
125: FUNCTION_NAME,
162:
163: /*=======================================================================*/
164:
165: PROCEDURE Add_Object_Metadata (
166: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,
167: p_description IN IMC_OBJECT_METADATA.description%TYPE,
168: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
169: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
170: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
163: /*=======================================================================*/
164:
165: PROCEDURE Add_Object_Metadata (
166: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,
167: p_description IN IMC_OBJECT_METADATA.description%TYPE,
168: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
169: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
170: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
171: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
164:
165: PROCEDURE Add_Object_Metadata (
166: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,
167: p_description IN IMC_OBJECT_METADATA.description%TYPE,
168: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
169: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
170: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
171: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
172: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
165: PROCEDURE Add_Object_Metadata (
166: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,
167: p_description IN IMC_OBJECT_METADATA.description%TYPE,
168: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
169: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
170: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
171: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
172: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
173: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
166: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,
167: p_description IN IMC_OBJECT_METADATA.description%TYPE,
168: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
169: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
170: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
171: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
172: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
173: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
174: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
167: p_description IN IMC_OBJECT_METADATA.description%TYPE,
168: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
169: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
170: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
171: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
172: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
173: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
174: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
175: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
168: p_function_name IN IMC_OBJECT_METADATA.function_name%TYPE,
169: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
170: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
171: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
172: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
173: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
174: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
175: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
176: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
169: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%TYPE,
170: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
171: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
172: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
173: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
174: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
175: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
176: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
177: x_return_status OUT NOCOPY VARCHAR2,
170: p_enabled IN IMC_OBJECT_METADATA.enabled%TYPE,
171: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
172: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
173: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
174: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
175: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
176: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY VARCHAR2,
171: p_application_id IN IMC_OBJECT_METADATA.application_id%TYPE,
172: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
173: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
174: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
175: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
176: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY VARCHAR2,
179: x_msg_data OUT NOCOPY VARCHAR2
172: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%TYPE,
173: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%TYPE,
174: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%TYPE,
175: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%TYPE,
176: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%TYPE,
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY VARCHAR2,
179: x_msg_data OUT NOCOPY VARCHAR2
180: ) AS
178: x_msg_count OUT NOCOPY VARCHAR2,
179: x_msg_data OUT NOCOPY VARCHAR2
180: ) AS
181:
182: l_metadata_id IMC_OBJECT_METADATA.metadata_id%TYPE;
183: l_last_update_login IMC_OBJECT_METADATA.last_update_login%TYPE;
184:
185: BEGIN
186:
179: x_msg_data OUT NOCOPY VARCHAR2
180: ) AS
181:
182: l_metadata_id IMC_OBJECT_METADATA.metadata_id%TYPE;
183: l_last_update_login IMC_OBJECT_METADATA.last_update_login%TYPE;
184:
185: BEGIN
186:
187: /* init last_update_login */
211: l_last_update_login /* Last update login */
212: );
213: ELSE
214: /* init metadata id */
215: SELECT IMC_OBJECT_METADATA_S.NEXTVAL INTO l_metadata_id FROM DUAL;
216:
217: Insert_Record (
218: l_metadata_id,
219: p_object_type,
264:
265: /*=======================================================================*/
266:
267: PROCEDURE Remove_Object_Metadata (
268: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY VARCHAR2,
271: x_msg_data OUT NOCOPY VARCHAR2
272: ) AS
272: ) AS
273:
274: BEGIN
275:
276: DELETE FROM IMC_OBJECT_METADATA
277: WHERE OBJECT_TYPE = p_object_type;
278:
279: IF SQL%NOTFOUND THEN
280: RAISE NO_DATA_FOUND;
304:
305: /*=======================================================================*/
306:
307: PROCEDURE Get_Object_Metadata (
308: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,
309: x_metadata_info OUT NOCOPY ref_cursor_obj_metadata,
310: x_return_status OUT NOCOPY VARCHAR2,
311: x_msg_count OUT NOCOPY VARCHAR2,
312: x_msg_data OUT NOCOPY VARCHAR2
316:
317: BEGIN
318:
319: l_query := 'SELECT object_type, description, function_name, parameter_name, enabled, application_id, additional_value1, additional_value2, additional_value3, additional_value4, additional_value5 ';
320: l_query := l_query || 'FROM IMC_OBJECT_METADATA ';
321:
322: IF p_object_type IS NOT NULL THEN
323: l_query := l_query || 'WHERE OBJECT_TYPE = ''' || p_object_type || '''';
324: ELSE
369:
370: /*=======================================================================*/
371:
372: FUNCTION Get_Function_Name (
373: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE
374: ) RETURN IMC_OBJECT_METADATA.function_name%TYPE AS
375:
376: l_return_val IMC_OBJECT_METADATA.function_name%TYPE;
377:
370: /*=======================================================================*/
371:
372: FUNCTION Get_Function_Name (
373: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE
374: ) RETURN IMC_OBJECT_METADATA.function_name%TYPE AS
375:
376: l_return_val IMC_OBJECT_METADATA.function_name%TYPE;
377:
378: BEGIN
372: FUNCTION Get_Function_Name (
373: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE
374: ) RETURN IMC_OBJECT_METADATA.function_name%TYPE AS
375:
376: l_return_val IMC_OBJECT_METADATA.function_name%TYPE;
377:
378: BEGIN
379:
380: IF p_object_type IS NULL THEN
381: RETURN NULL;
382: ELSE
383: SELECT function_name
384: INTO l_return_val
385: FROM IMC_OBJECT_METADATA
386: WHERE OBJECT_TYPE = p_object_type
387: AND ROWNUM = 1;
388: END IF;
389:
397:
398: /*=======================================================================*/
399:
400: FUNCTION Get_Parameter_Name (
401: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE
402: ) RETURN IMC_OBJECT_METADATA.parameter_name%TYPE AS
403:
404: l_return_val IMC_OBJECT_METADATA.parameter_name%TYPE;
405:
398: /*=======================================================================*/
399:
400: FUNCTION Get_Parameter_Name (
401: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE
402: ) RETURN IMC_OBJECT_METADATA.parameter_name%TYPE AS
403:
404: l_return_val IMC_OBJECT_METADATA.parameter_name%TYPE;
405:
406: BEGIN
400: FUNCTION Get_Parameter_Name (
401: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE
402: ) RETURN IMC_OBJECT_METADATA.parameter_name%TYPE AS
403:
404: l_return_val IMC_OBJECT_METADATA.parameter_name%TYPE;
405:
406: BEGIN
407:
408: IF p_object_type IS NULL THEN
409: RETURN NULL;
410: ELSE
411: SELECT parameter_name
412: INTO l_return_val
413: FROM IMC_OBJECT_METADATA
414: WHERE OBJECT_TYPE = p_object_type
415: AND ROWNUM = 1;
416: END IF;
417:
425:
426: /*=======================================================================*/
427:
428: FUNCTION Get_Additional_Value (
429: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,
430: p_index IN NUMBER
431: ) RETURN VARCHAR2 AS
432:
433: l_return_val VARCHAR2(150); /* Type of all additional value columns */
444: -- TO-DO: Execute query, return column value.
445: l_cursorId := DBMS_SQL.OPEN_CURSOR;
446: l_column_name := 'ADDITIONAL_VALUE' || p_index;
447: l_query := 'SELECT ' || l_column_name || ' ' ||
448: 'FROM IMC_OBJECT_METADATA ' ||
449: 'WHERE OBJECT_TYPE = ''' || p_object_type || ''' ' ||
450: 'AND ROWNUM = 1';
451: DBMS_SQL.PARSE(l_cursorId, l_query, DBMS_SQL.V7);
452: DBMS_SQL.DEFINE_COLUMN(l_cursorId, 1, l_return_val, 150);
479:
480: /*=======================================================================*/
481:
482: FUNCTION Get_File_Name (
483: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE
484: ) RETURN VARCHAR2 AS
485:
486: l_function_name IMC_OBJECT_METADATA.function_name%TYPE;
487: l_return_val VARCHAR2(30);
482: FUNCTION Get_File_Name (
483: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE
484: ) RETURN VARCHAR2 AS
485:
486: l_function_name IMC_OBJECT_METADATA.function_name%TYPE;
487: l_return_val VARCHAR2(30);
488:
489: BEGIN
490:
492: RETURN NULL;
493: ELSE
494: SELECT FUNCTION_NAME
495: INTO l_function_name
496: FROM IMC_OBJECT_METADATA
497: WHERE OBJECT_TYPE = p_object_type
498: AND ROWNUM = 1;
499: END IF;
500:
510: RETURN NULL;
511:
512: END Get_File_Name;
513:
514: END IMC_OBJECT_METADATA_PUB;