106: -- Notes :
107: --
108: ---------------------------------------------------------------------------------
109: PROCEDURE Add_Recently_Accessed_Object (
110: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
111: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
112: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
113: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
114: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
107: --
108: ---------------------------------------------------------------------------------
109: PROCEDURE Add_Recently_Accessed_Object (
110: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
111: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
112: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
113: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
114: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
115: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
108: ---------------------------------------------------------------------------------
109: PROCEDURE Add_Recently_Accessed_Object (
110: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
111: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
112: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
113: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
114: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
115: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
116: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
109: PROCEDURE Add_Recently_Accessed_Object (
110: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
111: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
112: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
113: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
114: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
115: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
116: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
117: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
110: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
111: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
112: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
113: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
114: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
115: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
116: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
117: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
118: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
111: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
112: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
113: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
114: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
115: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
116: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
117: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
118: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
119: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
112: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
113: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
114: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
115: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
116: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
117: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
118: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
119: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
120: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
113: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
114: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
115: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
116: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
117: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
118: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
119: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
120: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
121: x_return_status OUT NOCOPY VARCHAR2,
114: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
115: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
116: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
117: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
118: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
119: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
120: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY VARCHAR2,
115: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
116: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
117: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
118: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
119: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
120: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY VARCHAR2,
123: x_msg_data OUT NOCOPY VARCHAR2
116: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
117: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
118: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
119: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
120: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY VARCHAR2,
123: x_msg_data OUT NOCOPY VARCHAR2
124: );
181: -- Notes :
182: --
183: ---------------------------------------------------------------------------------
184: PROCEDURE Get_Recently_Accessed_Objects (
185: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
186: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
187: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
188: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
189: x_object_info OUT NOCOPY ref_cursor_rec_obj_acc,
182: --
183: ---------------------------------------------------------------------------------
184: PROCEDURE Get_Recently_Accessed_Objects (
185: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
186: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
187: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
188: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
189: x_object_info OUT NOCOPY ref_cursor_rec_obj_acc,
190: x_return_status OUT NOCOPY VARCHAR2,
183: ---------------------------------------------------------------------------------
184: PROCEDURE Get_Recently_Accessed_Objects (
185: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
186: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
187: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
188: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
189: x_object_info OUT NOCOPY ref_cursor_rec_obj_acc,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY VARCHAR2,
184: PROCEDURE Get_Recently_Accessed_Objects (
185: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
186: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
187: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
188: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
189: x_object_info OUT NOCOPY ref_cursor_rec_obj_acc,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY VARCHAR2,
192: x_msg_data OUT NOCOPY VARCHAR2
233: -- Notes :
234: --
235: ---------------------------------------------------------------------------------
236: PROCEDURE Flush (
237: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
238: x_flush_count OUT NOCOPY NUMBER,
239: x_return_status OUT NOCOPY VARCHAR2,
240: x_msg_count OUT NOCOPY VARCHAR2,
241: x_msg_data OUT NOCOPY VARCHAR2