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_RECENT_OBJECT_ACCESS_PUB dependencies on IMC_RECENT_ACCESSED_OBJ

Line 7: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,

3:
4: /*=======================================================================*/
5:
6: FUNCTION Record_Exists (
7: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
8: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
9: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
10: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE
11: ) RETURN VARCHAR2 AS

Line 8: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,

4: /*=======================================================================*/
5:
6: FUNCTION Record_Exists (
7: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
8: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
9: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
10: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE
11: ) RETURN VARCHAR2 AS
12:

Line 9: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,

5:
6: FUNCTION Record_Exists (
7: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
8: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
9: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
10: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE
11: ) RETURN VARCHAR2 AS
12:
13: l_dummy NUMBER;

Line 10: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE

6: FUNCTION Record_Exists (
7: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
8: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
9: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
10: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE
11: ) RETURN VARCHAR2 AS
12:
13: l_dummy NUMBER;
14:

Line 46: FROM IMC_RECENT_ACCESSED_OBJ

42: l_dummy := 0;
43:
44: SELECT 1
45: INTO l_dummy
46: FROM IMC_RECENT_ACCESSED_OBJ
47: WHERE USER_ID = p_user_id
48: -- AND OBJECT_TYPE = p_object_type
49: AND OBJECT_ID = p_object_id
50: -- AND OBJECT_NAME = p_object_name

Line 78: p_old_access_id IN IMC_RECENT_ACCESSED_OBJ.access_id%TYPE,

74:
75: /*=======================================================================*/
76:
77: PROCEDURE Update_Record (
78: p_old_access_id IN IMC_RECENT_ACCESSED_OBJ.access_id%TYPE,
79: p_new_access_id IN IMC_RECENT_ACCESSED_OBJ.access_id%TYPE,
80: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
81: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
82: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,

Line 79: p_new_access_id IN IMC_RECENT_ACCESSED_OBJ.access_id%TYPE,

75: /*=======================================================================*/
76:
77: PROCEDURE Update_Record (
78: p_old_access_id IN IMC_RECENT_ACCESSED_OBJ.access_id%TYPE,
79: p_new_access_id IN IMC_RECENT_ACCESSED_OBJ.access_id%TYPE,
80: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
81: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
82: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
83: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,

Line 80: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,

76:
77: PROCEDURE Update_Record (
78: p_old_access_id IN IMC_RECENT_ACCESSED_OBJ.access_id%TYPE,
79: p_new_access_id IN IMC_RECENT_ACCESSED_OBJ.access_id%TYPE,
80: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
81: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
82: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
83: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
84: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,

Line 81: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,

77: PROCEDURE Update_Record (
78: p_old_access_id IN IMC_RECENT_ACCESSED_OBJ.access_id%TYPE,
79: p_new_access_id IN IMC_RECENT_ACCESSED_OBJ.access_id%TYPE,
80: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
81: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
82: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
83: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
84: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
85: p_date_created IN IMC_RECENT_ACCESSED_OBJ.date_created%TYPE,

Line 82: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,

78: p_old_access_id IN IMC_RECENT_ACCESSED_OBJ.access_id%TYPE,
79: p_new_access_id IN IMC_RECENT_ACCESSED_OBJ.access_id%TYPE,
80: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
81: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
82: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
83: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
84: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
85: p_date_created IN IMC_RECENT_ACCESSED_OBJ.date_created%TYPE,
86: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,

Line 83: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,

79: p_new_access_id IN IMC_RECENT_ACCESSED_OBJ.access_id%TYPE,
80: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
81: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
82: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
83: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
84: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
85: p_date_created IN IMC_RECENT_ACCESSED_OBJ.date_created%TYPE,
86: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
87: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,

Line 84: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,

80: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
81: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
82: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
83: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
84: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
85: p_date_created IN IMC_RECENT_ACCESSED_OBJ.date_created%TYPE,
86: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
87: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
88: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,

Line 85: p_date_created IN IMC_RECENT_ACCESSED_OBJ.date_created%TYPE,

81: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
82: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
83: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
84: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
85: p_date_created IN IMC_RECENT_ACCESSED_OBJ.date_created%TYPE,
86: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
87: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
88: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
89: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,

Line 86: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,

82: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
83: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
84: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
85: p_date_created IN IMC_RECENT_ACCESSED_OBJ.date_created%TYPE,
86: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
87: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
88: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
89: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
90: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,

Line 87: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,

83: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
84: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
85: p_date_created IN IMC_RECENT_ACCESSED_OBJ.date_created%TYPE,
86: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
87: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
88: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
89: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
90: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
91: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,

Line 88: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,

84: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
85: p_date_created IN IMC_RECENT_ACCESSED_OBJ.date_created%TYPE,
86: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
87: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
88: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
89: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
90: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
91: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
92: p_created_by IN IMC_RECENT_ACCESSED_OBJ.created_by%TYPE,

Line 89: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,

85: p_date_created IN IMC_RECENT_ACCESSED_OBJ.date_created%TYPE,
86: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
87: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
88: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
89: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
90: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
91: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
92: p_created_by IN IMC_RECENT_ACCESSED_OBJ.created_by%TYPE,
93: p_creation_date IN IMC_RECENT_ACCESSED_OBJ.creation_date%TYPE,

Line 90: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,

86: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
87: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
88: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
89: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
90: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
91: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
92: p_created_by IN IMC_RECENT_ACCESSED_OBJ.created_by%TYPE,
93: p_creation_date IN IMC_RECENT_ACCESSED_OBJ.creation_date%TYPE,
94: p_last_updated_by IN IMC_RECENT_ACCESSED_OBJ.last_updated_by%TYPE,

Line 91: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,

87: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
88: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
89: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
90: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
91: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
92: p_created_by IN IMC_RECENT_ACCESSED_OBJ.created_by%TYPE,
93: p_creation_date IN IMC_RECENT_ACCESSED_OBJ.creation_date%TYPE,
94: p_last_updated_by IN IMC_RECENT_ACCESSED_OBJ.last_updated_by%TYPE,
95: p_last_update_date IN IMC_RECENT_ACCESSED_OBJ.last_update_date%TYPE,

Line 92: p_created_by IN IMC_RECENT_ACCESSED_OBJ.created_by%TYPE,

88: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
89: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
90: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
91: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
92: p_created_by IN IMC_RECENT_ACCESSED_OBJ.created_by%TYPE,
93: p_creation_date IN IMC_RECENT_ACCESSED_OBJ.creation_date%TYPE,
94: p_last_updated_by IN IMC_RECENT_ACCESSED_OBJ.last_updated_by%TYPE,
95: p_last_update_date IN IMC_RECENT_ACCESSED_OBJ.last_update_date%TYPE,
96: p_last_update_login IN IMC_RECENT_ACCESSED_OBJ.last_update_login%TYPE

Line 93: p_creation_date IN IMC_RECENT_ACCESSED_OBJ.creation_date%TYPE,

89: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
90: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
91: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
92: p_created_by IN IMC_RECENT_ACCESSED_OBJ.created_by%TYPE,
93: p_creation_date IN IMC_RECENT_ACCESSED_OBJ.creation_date%TYPE,
94: p_last_updated_by IN IMC_RECENT_ACCESSED_OBJ.last_updated_by%TYPE,
95: p_last_update_date IN IMC_RECENT_ACCESSED_OBJ.last_update_date%TYPE,
96: p_last_update_login IN IMC_RECENT_ACCESSED_OBJ.last_update_login%TYPE
97: ) AS

Line 94: p_last_updated_by IN IMC_RECENT_ACCESSED_OBJ.last_updated_by%TYPE,

90: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
91: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
92: p_created_by IN IMC_RECENT_ACCESSED_OBJ.created_by%TYPE,
93: p_creation_date IN IMC_RECENT_ACCESSED_OBJ.creation_date%TYPE,
94: p_last_updated_by IN IMC_RECENT_ACCESSED_OBJ.last_updated_by%TYPE,
95: p_last_update_date IN IMC_RECENT_ACCESSED_OBJ.last_update_date%TYPE,
96: p_last_update_login IN IMC_RECENT_ACCESSED_OBJ.last_update_login%TYPE
97: ) AS
98:

Line 95: p_last_update_date IN IMC_RECENT_ACCESSED_OBJ.last_update_date%TYPE,

91: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
92: p_created_by IN IMC_RECENT_ACCESSED_OBJ.created_by%TYPE,
93: p_creation_date IN IMC_RECENT_ACCESSED_OBJ.creation_date%TYPE,
94: p_last_updated_by IN IMC_RECENT_ACCESSED_OBJ.last_updated_by%TYPE,
95: p_last_update_date IN IMC_RECENT_ACCESSED_OBJ.last_update_date%TYPE,
96: p_last_update_login IN IMC_RECENT_ACCESSED_OBJ.last_update_login%TYPE
97: ) AS
98:
99: BEGIN

Line 96: p_last_update_login IN IMC_RECENT_ACCESSED_OBJ.last_update_login%TYPE

92: p_created_by IN IMC_RECENT_ACCESSED_OBJ.created_by%TYPE,
93: p_creation_date IN IMC_RECENT_ACCESSED_OBJ.creation_date%TYPE,
94: p_last_updated_by IN IMC_RECENT_ACCESSED_OBJ.last_updated_by%TYPE,
95: p_last_update_date IN IMC_RECENT_ACCESSED_OBJ.last_update_date%TYPE,
96: p_last_update_login IN IMC_RECENT_ACCESSED_OBJ.last_update_login%TYPE
97: ) AS
98:
99: BEGIN
100:

Line 101: UPDATE IMC_RECENT_ACCESSED_OBJ SET

97: ) AS
98:
99: BEGIN
100:
101: UPDATE IMC_RECENT_ACCESSED_OBJ SET
102: ACCESS_ID = p_new_access_id,
103: OBJECT_TYPE = p_object_type,
104: OBJECT_ID = p_object_id,
105: OBJECT_NAME = DECODE(p_object_name, FND_API.G_MISS_CHAR, NULL, p_object_name),

Line 132: p_access_id IN IMC_RECENT_ACCESSED_OBJ.access_id%TYPE,

128:
129: /*=======================================================================*/
130:
131: PROCEDURE Insert_Record (
132: p_access_id IN IMC_RECENT_ACCESSED_OBJ.access_id%TYPE,
133: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
134: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
135: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
136: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,

Line 133: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,

129: /*=======================================================================*/
130:
131: PROCEDURE Insert_Record (
132: p_access_id IN IMC_RECENT_ACCESSED_OBJ.access_id%TYPE,
133: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
134: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
135: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
136: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
137: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,

Line 134: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,

130:
131: PROCEDURE Insert_Record (
132: p_access_id IN IMC_RECENT_ACCESSED_OBJ.access_id%TYPE,
133: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
134: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
135: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
136: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
137: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
138: p_date_created IN IMC_RECENT_ACCESSED_OBJ.date_created%TYPE,

Line 135: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,

131: PROCEDURE Insert_Record (
132: p_access_id IN IMC_RECENT_ACCESSED_OBJ.access_id%TYPE,
133: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
134: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
135: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
136: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
137: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
138: p_date_created IN IMC_RECENT_ACCESSED_OBJ.date_created%TYPE,
139: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,

Line 136: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,

132: p_access_id IN IMC_RECENT_ACCESSED_OBJ.access_id%TYPE,
133: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
134: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
135: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
136: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
137: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
138: p_date_created IN IMC_RECENT_ACCESSED_OBJ.date_created%TYPE,
139: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
140: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,

Line 137: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,

133: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
134: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
135: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
136: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
137: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
138: p_date_created IN IMC_RECENT_ACCESSED_OBJ.date_created%TYPE,
139: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
140: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
141: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,

Line 138: p_date_created IN IMC_RECENT_ACCESSED_OBJ.date_created%TYPE,

134: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
135: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
136: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
137: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
138: p_date_created IN IMC_RECENT_ACCESSED_OBJ.date_created%TYPE,
139: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
140: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
141: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
142: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,

Line 139: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,

135: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
136: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
137: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
138: p_date_created IN IMC_RECENT_ACCESSED_OBJ.date_created%TYPE,
139: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
140: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
141: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
142: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
143: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,

Line 140: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,

136: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
137: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
138: p_date_created IN IMC_RECENT_ACCESSED_OBJ.date_created%TYPE,
139: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
140: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
141: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
142: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
143: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
144: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,

Line 141: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,

137: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
138: p_date_created IN IMC_RECENT_ACCESSED_OBJ.date_created%TYPE,
139: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
140: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
141: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
142: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
143: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
144: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
145: p_created_by IN IMC_RECENT_ACCESSED_OBJ.created_by%TYPE,

Line 142: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,

138: p_date_created IN IMC_RECENT_ACCESSED_OBJ.date_created%TYPE,
139: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
140: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
141: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
142: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
143: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
144: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
145: p_created_by IN IMC_RECENT_ACCESSED_OBJ.created_by%TYPE,
146: p_creation_date IN IMC_RECENT_ACCESSED_OBJ.creation_date%TYPE,

Line 143: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,

139: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
140: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
141: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
142: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
143: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
144: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
145: p_created_by IN IMC_RECENT_ACCESSED_OBJ.created_by%TYPE,
146: p_creation_date IN IMC_RECENT_ACCESSED_OBJ.creation_date%TYPE,
147: p_last_updated_by IN IMC_RECENT_ACCESSED_OBJ.last_updated_by%TYPE,

Line 144: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,

140: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
141: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
142: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
143: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
144: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
145: p_created_by IN IMC_RECENT_ACCESSED_OBJ.created_by%TYPE,
146: p_creation_date IN IMC_RECENT_ACCESSED_OBJ.creation_date%TYPE,
147: p_last_updated_by IN IMC_RECENT_ACCESSED_OBJ.last_updated_by%TYPE,
148: p_last_update_date IN IMC_RECENT_ACCESSED_OBJ.last_update_date%TYPE,

Line 145: p_created_by IN IMC_RECENT_ACCESSED_OBJ.created_by%TYPE,

141: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
142: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
143: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
144: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
145: p_created_by IN IMC_RECENT_ACCESSED_OBJ.created_by%TYPE,
146: p_creation_date IN IMC_RECENT_ACCESSED_OBJ.creation_date%TYPE,
147: p_last_updated_by IN IMC_RECENT_ACCESSED_OBJ.last_updated_by%TYPE,
148: p_last_update_date IN IMC_RECENT_ACCESSED_OBJ.last_update_date%TYPE,
149: p_last_update_login IN IMC_RECENT_ACCESSED_OBJ.last_update_login%TYPE

Line 146: p_creation_date IN IMC_RECENT_ACCESSED_OBJ.creation_date%TYPE,

142: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
143: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
144: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
145: p_created_by IN IMC_RECENT_ACCESSED_OBJ.created_by%TYPE,
146: p_creation_date IN IMC_RECENT_ACCESSED_OBJ.creation_date%TYPE,
147: p_last_updated_by IN IMC_RECENT_ACCESSED_OBJ.last_updated_by%TYPE,
148: p_last_update_date IN IMC_RECENT_ACCESSED_OBJ.last_update_date%TYPE,
149: p_last_update_login IN IMC_RECENT_ACCESSED_OBJ.last_update_login%TYPE
150: ) AS

Line 147: p_last_updated_by IN IMC_RECENT_ACCESSED_OBJ.last_updated_by%TYPE,

143: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
144: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
145: p_created_by IN IMC_RECENT_ACCESSED_OBJ.created_by%TYPE,
146: p_creation_date IN IMC_RECENT_ACCESSED_OBJ.creation_date%TYPE,
147: p_last_updated_by IN IMC_RECENT_ACCESSED_OBJ.last_updated_by%TYPE,
148: p_last_update_date IN IMC_RECENT_ACCESSED_OBJ.last_update_date%TYPE,
149: p_last_update_login IN IMC_RECENT_ACCESSED_OBJ.last_update_login%TYPE
150: ) AS
151:

Line 148: p_last_update_date IN IMC_RECENT_ACCESSED_OBJ.last_update_date%TYPE,

144: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
145: p_created_by IN IMC_RECENT_ACCESSED_OBJ.created_by%TYPE,
146: p_creation_date IN IMC_RECENT_ACCESSED_OBJ.creation_date%TYPE,
147: p_last_updated_by IN IMC_RECENT_ACCESSED_OBJ.last_updated_by%TYPE,
148: p_last_update_date IN IMC_RECENT_ACCESSED_OBJ.last_update_date%TYPE,
149: p_last_update_login IN IMC_RECENT_ACCESSED_OBJ.last_update_login%TYPE
150: ) AS
151:
152: BEGIN

Line 149: p_last_update_login IN IMC_RECENT_ACCESSED_OBJ.last_update_login%TYPE

145: p_created_by IN IMC_RECENT_ACCESSED_OBJ.created_by%TYPE,
146: p_creation_date IN IMC_RECENT_ACCESSED_OBJ.creation_date%TYPE,
147: p_last_updated_by IN IMC_RECENT_ACCESSED_OBJ.last_updated_by%TYPE,
148: p_last_update_date IN IMC_RECENT_ACCESSED_OBJ.last_update_date%TYPE,
149: p_last_update_login IN IMC_RECENT_ACCESSED_OBJ.last_update_login%TYPE
150: ) AS
151:
152: BEGIN
153:

Line 154: INSERT INTO IMC_RECENT_ACCESSED_OBJ (

150: ) AS
151:
152: BEGIN
153:
154: INSERT INTO IMC_RECENT_ACCESSED_OBJ (
155: ACCESS_ID,
156: USER_ID,
157: OBJECT_TYPE,
158: OBJECT_ID,

Line 201: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,

197:
198: /*=======================================================================*/
199:
200: PROCEDURE Add_Recently_Accessed_Object (
201: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
202: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
203: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
204: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
205: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,

Line 202: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,

198: /*=======================================================================*/
199:
200: PROCEDURE Add_Recently_Accessed_Object (
201: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
202: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
203: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
204: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
205: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
206: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,

Line 203: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,

199:
200: PROCEDURE Add_Recently_Accessed_Object (
201: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
202: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
203: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
204: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
205: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
206: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
207: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,

Line 204: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,

200: PROCEDURE Add_Recently_Accessed_Object (
201: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
202: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
203: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
204: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
205: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
206: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
207: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
208: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,

Line 205: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,

201: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
202: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
203: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
204: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
205: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
206: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
207: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
208: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
209: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,

Line 206: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,

202: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
203: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
204: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
205: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
206: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
207: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
208: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
209: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
210: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,

Line 207: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,

203: p_object_id IN IMC_RECENT_ACCESSED_OBJ.object_id%TYPE,
204: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
205: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
206: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
207: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
208: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
209: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
210: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
211: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,

Line 208: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,

204: p_object_name IN IMC_RECENT_ACCESSED_OBJ.object_name%TYPE,
205: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
206: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
207: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
208: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
209: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
210: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
211: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
212: x_return_status OUT NOCOPY VARCHAR2,

Line 209: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,

205: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
206: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
207: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
208: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
209: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
210: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
211: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY VARCHAR2,

Line 210: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,

206: p_additional_value1 IN IMC_RECENT_ACCESSED_OBJ.additional_value1%TYPE,
207: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
208: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
209: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
210: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
211: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY VARCHAR2,
214: x_msg_data OUT NOCOPY VARCHAR2

Line 211: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,

207: p_additional_value2 IN IMC_RECENT_ACCESSED_OBJ.additional_value2%TYPE,
208: p_additional_value3 IN IMC_RECENT_ACCESSED_OBJ.additional_value3%TYPE,
209: p_additional_value4 IN IMC_RECENT_ACCESSED_OBJ.additional_value4%TYPE,
210: p_additional_value5 IN IMC_RECENT_ACCESSED_OBJ.additional_value5%TYPE,
211: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY VARCHAR2,
214: x_msg_data OUT NOCOPY VARCHAR2
215: ) AS

Line 219: FROM IMC_RECENT_ACCESSED_OBJ

215: ) AS
216:
217: CURSOR records_for_this_user IS
218: SELECT *
219: FROM IMC_RECENT_ACCESSED_OBJ
220: WHERE USER_ID = p_user_id
221: ORDER BY access_id;
222:
223: l_user_record records_for_this_user%ROWTYPE;

Line 228: l_old_access_id IMC_RECENT_ACCESSED_OBJ.access_id%TYPE;

224: l_exists VARCHAR2(1);
225: l_maintain VARCHAR2(30);
226: l_curr_count NUMBER;
227: l_max_records NUMBER;
228: l_old_access_id IMC_RECENT_ACCESSED_OBJ.access_id%TYPE;
229: l_new_access_id IMC_RECENT_ACCESSED_OBJ.access_id%TYPE;
230: l_object_version_number IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE;
231: l_last_update_login IMC_RECENT_ACCESSED_OBJ.last_update_login%TYPE;
232:

Line 229: l_new_access_id IMC_RECENT_ACCESSED_OBJ.access_id%TYPE;

225: l_maintain VARCHAR2(30);
226: l_curr_count NUMBER;
227: l_max_records NUMBER;
228: l_old_access_id IMC_RECENT_ACCESSED_OBJ.access_id%TYPE;
229: l_new_access_id IMC_RECENT_ACCESSED_OBJ.access_id%TYPE;
230: l_object_version_number IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE;
231: l_last_update_login IMC_RECENT_ACCESSED_OBJ.last_update_login%TYPE;
232:
233: BEGIN

Line 230: l_object_version_number IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE;

226: l_curr_count NUMBER;
227: l_max_records NUMBER;
228: l_old_access_id IMC_RECENT_ACCESSED_OBJ.access_id%TYPE;
229: l_new_access_id IMC_RECENT_ACCESSED_OBJ.access_id%TYPE;
230: l_object_version_number IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE;
231: l_last_update_login IMC_RECENT_ACCESSED_OBJ.last_update_login%TYPE;
232:
233: BEGIN
234:

Line 231: l_last_update_login IMC_RECENT_ACCESSED_OBJ.last_update_login%TYPE;

227: l_max_records NUMBER;
228: l_old_access_id IMC_RECENT_ACCESSED_OBJ.access_id%TYPE;
229: l_new_access_id IMC_RECENT_ACCESSED_OBJ.access_id%TYPE;
230: l_object_version_number IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE;
231: l_last_update_login IMC_RECENT_ACCESSED_OBJ.last_update_login%TYPE;
232:
233: BEGIN
234:
235: l_exists := Record_Exists(p_user_id, p_object_type, p_object_id, p_object_name);

Line 243: FROM IMC_RECENT_ACCESSED_OBJ

239: IF (l_exists = 'Y') THEN
240: /* Record exists; Update details of access. */
241: SELECT access_id
242: INTO l_old_access_id
243: FROM IMC_RECENT_ACCESSED_OBJ
244: WHERE USER_ID = p_user_id
245: -- AND OBJECT_TYPE = p_object_type
246: AND OBJECT_ID = p_object_id
247: AND ROWNUM = 1;

Line 250: SELECT IMC_RECENT_ACCESSED_OBJ_S.NEXTVAL INTO l_new_access_id FROM DUAL;

246: AND OBJECT_ID = p_object_id
247: AND ROWNUM = 1;
248:
249: /* init access_id */
250: SELECT IMC_RECENT_ACCESSED_OBJ_S.NEXTVAL INTO l_new_access_id FROM DUAL;
251:
252: /* init object version number */
253: l_object_version_number := NVL(p_object_version_number, g_object_version_number);
254:

Line 296: SELECT IMC_RECENT_ACCESSED_OBJ_S.NEXTVAL INTO l_new_access_id FROM DUAL;

292: ELSIF (l_exists = 'N') THEN
293: /* Record doesn't exist; Create */
294:
295: /* init access_id */
296: SELECT IMC_RECENT_ACCESSED_OBJ_S.NEXTVAL INTO l_new_access_id FROM DUAL;
297:
298: /* init object version number */
299: l_object_version_number := NVL(p_object_version_number, g_object_version_number);
300:

Line 326: FROM IMC_RECENT_ACCESSED_OBJ

322:
323: IF l_maintain = 'Y' OR l_maintain = 'Yes' THEN
324: SELECT count(*)
325: INTO l_curr_count
326: FROM IMC_RECENT_ACCESSED_OBJ
327: WHERE USER_ID = p_user_id;
328:
329: -- dbms_output.put_line('l_curr_count = ' || l_curr_count);
330:

Line 451: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,

447:
448: /*=======================================================================*/
449:
450: PROCEDURE Get_Recently_Accessed_Objects (
451: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
452: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
453: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
454: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
455: x_object_info OUT NOCOPY ref_cursor_rec_obj_acc,

Line 452: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,

448: /*=======================================================================*/
449:
450: PROCEDURE Get_Recently_Accessed_Objects (
451: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
452: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
453: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
454: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
455: x_object_info OUT NOCOPY ref_cursor_rec_obj_acc,
456: x_return_status OUT NOCOPY VARCHAR2,

Line 453: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,

449:
450: PROCEDURE Get_Recently_Accessed_Objects (
451: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
452: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
453: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
454: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
455: x_object_info OUT NOCOPY ref_cursor_rec_obj_acc,
456: x_return_status OUT NOCOPY VARCHAR2,
457: x_msg_count OUT NOCOPY VARCHAR2,

Line 454: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,

450: PROCEDURE Get_Recently_Accessed_Objects (
451: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
452: p_object_type IN IMC_RECENT_ACCESSED_OBJ.object_type%TYPE,
453: p_application_id IN IMC_RECENT_ACCESSED_OBJ.application_id%TYPE,
454: p_object_version_number IN IMC_RECENT_ACCESSED_OBJ.object_version_number%TYPE,
455: x_object_info OUT NOCOPY ref_cursor_rec_obj_acc,
456: x_return_status OUT NOCOPY VARCHAR2,
457: x_msg_count OUT NOCOPY VARCHAR2,
458: x_msg_data OUT NOCOPY VARCHAR2

Line 476: 'FROM IMC_RECENT_ACCESSED_OBJ ';

472: FND_MSG_PUB.ADD;
473: RAISE FND_API.G_EXC_ERROR;
474: ELSE
475: l_query := 'SELECT object_type, object_id, object_name, date_created ' ||
476: 'FROM IMC_RECENT_ACCESSED_OBJ ';
477:
478: l_where_clause := 'WHERE user_id = ' || p_user_id || ' ';
479:
480: IF p_object_type IS NOT NULL THEN

Line 547: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,

543:
544: /*=======================================================================*/
545:
546: PROCEDURE Flush (
547: p_user_id IN IMC_RECENT_ACCESSED_OBJ.user_id%TYPE,
548: x_flush_count OUT NOCOPY NUMBER,
549: x_return_status OUT NOCOPY VARCHAR2,
550: x_msg_count OUT NOCOPY VARCHAR2,
551: x_msg_data OUT NOCOPY VARCHAR2

Line 556: FROM IMC_RECENT_ACCESSED_OBJ

552: ) AS
553:
554: CURSOR records_for_this_user IS
555: SELECT *
556: FROM IMC_RECENT_ACCESSED_OBJ
557: WHERE USER_ID = p_user_id
558: ORDER BY access_id;
559:
560: l_user_record records_for_this_user%ROWTYPE;

Line 582: FROM IMC_RECENT_ACCESSED_OBJ

578: OPEN records_for_this_user;
579:
580: SELECT count(*)
581: INTO l_curr_count
582: FROM IMC_RECENT_ACCESSED_OBJ
583: WHERE USER_ID = p_user_id;
584:
585: IF l_curr_count <= l_max_records THEN
586: /* Nothing to do */

Line 594: DELETE FROM IMC_RECENT_ACCESSED_OBJ

590:
591: WHILE x_flush_count < l_num_to_delete LOOP
592: FETCH records_for_this_user INTO l_user_record;
593:
594: DELETE FROM IMC_RECENT_ACCESSED_OBJ
595: WHERE ACCESS_ID = l_user_record.access_id;
596:
597: IF SQL%NOTFOUND THEN
598: RAISE NO_DATA_FOUND;