eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IMC_OBJECT_METADATA_PUB dependencies on IMC_OBJECT_METADATA

Line 1: PACKAGE BODY IMC_OBJECT_METADATA_PUB AS

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:

Line 7: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE

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:

Line 24: FROM IMC_OBJECT_METADATA

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';

Line 51: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,

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,

Line 52: p_description IN IMC_OBJECT_METADATA.description%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,

Line 53: p_function_name IN IMC_OBJECT_METADATA.function_name%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,

Line 54: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%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,

Line 55: p_enabled IN IMC_OBJECT_METADATA.enabled%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,

Line 56: p_application_id IN IMC_OBJECT_METADATA.application_id%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,

Line 57: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%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,

Line 58: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%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,

Line 59: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%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,

Line 60: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%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,

Line 61: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%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,

Line 62: p_created_by IN IMC_OBJECT_METADATA.created_by%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

Line 63: p_creation_date IN IMC_OBJECT_METADATA.creation_date%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

Line 64: p_last_updated_by IN IMC_OBJECT_METADATA.last_updated_by%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
68:

Line 65: p_last_update_date IN IMC_OBJECT_METADATA.last_update_date%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:
69: BEGIN

Line 66: p_last_update_login IN IMC_OBJECT_METADATA.last_update_login%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
70:

Line 71: UPDATE IMC_OBJECT_METADATA SET

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,

Line 100: p_metadata_id IN IMC_OBJECT_METADATA.metadata_id%TYPE,

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,

Line 101: p_object_type IN IMC_OBJECT_METADATA.object_type%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,

Line 102: p_description IN IMC_OBJECT_METADATA.description%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,

Line 103: p_function_name IN IMC_OBJECT_METADATA.function_name%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,

Line 104: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%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,

Line 105: p_enabled IN IMC_OBJECT_METADATA.enabled%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,

Line 106: p_application_id IN IMC_OBJECT_METADATA.application_id%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,

Line 107: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%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,

Line 108: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%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,

Line 109: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%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,

Line 110: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%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,

Line 111: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%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,

Line 112: p_created_by IN IMC_OBJECT_METADATA.created_by%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

Line 113: p_creation_date IN IMC_OBJECT_METADATA.creation_date%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

Line 114: p_last_updated_by IN IMC_OBJECT_METADATA.last_updated_by%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
118:

Line 115: p_last_update_date IN IMC_OBJECT_METADATA.last_update_date%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:
119: BEGIN

Line 116: p_last_update_login IN IMC_OBJECT_METADATA.last_update_login%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
120:

Line 121: INSERT INTO IMC_OBJECT_METADATA (

117: ) AS
118:
119: BEGIN
120:
121: INSERT INTO IMC_OBJECT_METADATA (
122: METADATA_ID,
123: OBJECT_TYPE,
124: DESCRIPTION,
125: FUNCTION_NAME,

Line 166: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,

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,

Line 167: p_description IN IMC_OBJECT_METADATA.description%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,

Line 168: p_function_name IN IMC_OBJECT_METADATA.function_name%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,

Line 169: p_parameter_name IN IMC_OBJECT_METADATA.parameter_name%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,

Line 170: p_enabled IN IMC_OBJECT_METADATA.enabled%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,

Line 171: p_application_id IN IMC_OBJECT_METADATA.application_id%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,

Line 172: p_additional_value1 IN IMC_OBJECT_METADATA.additional_value1%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,

Line 173: p_additional_value2 IN IMC_OBJECT_METADATA.additional_value2%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,

Line 174: p_additional_value3 IN IMC_OBJECT_METADATA.additional_value3%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,
178: x_msg_count OUT NOCOPY VARCHAR2,

Line 175: p_additional_value4 IN IMC_OBJECT_METADATA.additional_value4%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,
179: x_msg_data OUT NOCOPY VARCHAR2

Line 176: p_additional_value5 IN IMC_OBJECT_METADATA.additional_value5%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
180: ) AS

Line 182: l_metadata_id IMC_OBJECT_METADATA.metadata_id%TYPE;

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:

Line 183: l_last_update_login IMC_OBJECT_METADATA.last_update_login%TYPE;

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 */

Line 215: SELECT IMC_OBJECT_METADATA_S.NEXTVAL INTO l_metadata_id FROM DUAL;

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,

Line 268: p_object_type IN IMC_OBJECT_METADATA.object_type%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

Line 276: DELETE FROM IMC_OBJECT_METADATA

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;

Line 308: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,

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

Line 320: l_query := l_query || 'FROM IMC_OBJECT_METADATA ';

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

Line 373: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE

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:

Line 374: ) RETURN IMC_OBJECT_METADATA.function_name%TYPE AS

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

Line 376: l_return_val IMC_OBJECT_METADATA.function_name%TYPE;

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

Line 385: FROM IMC_OBJECT_METADATA

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:

Line 401: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE

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:

Line 402: ) RETURN IMC_OBJECT_METADATA.parameter_name%TYPE AS

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

Line 404: l_return_val IMC_OBJECT_METADATA.parameter_name%TYPE;

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

Line 413: FROM IMC_OBJECT_METADATA

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:

Line 429: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE,

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 */

Line 448: 'FROM IMC_OBJECT_METADATA ' ||

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);

Line 483: p_object_type IN IMC_OBJECT_METADATA.object_type%TYPE

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);

Line 486: l_function_name IMC_OBJECT_METADATA.function_name%TYPE;

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:

Line 496: FROM IMC_OBJECT_METADATA

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:

Line 514: END IMC_OBJECT_METADATA_PUB;

510: RETURN NULL;
511:
512: END Get_File_Name;
513:
514: END IMC_OBJECT_METADATA_PUB;