DBA Data[Home] [Help]

APPS.IMC_RECENT_OBJECT_ACCESS_PUB dependencies on IMC_RECENT_ACCESSED_OBJ_S

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 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: