APPS.FND_SEARCH_EVENT dependencies on FND_SEARCHABLE_CHANGE_LOG

Line 11: UPDATE FND_SEARCHABLE_CHANGE_LOG

7: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
8: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.START_CRAWL',
9: 'Begin Start_Crawl to initialize crawl status in change log');
10: end if;
11: UPDATE FND_SEARCHABLE_CHANGE_LOG
12: set CRAWL_STATUS='Y'
13: where object_name=obj_name;
14:
15: if (sql%rowcount=0) then

Line 38: DELETE FROM FND_SEARCHABLE_CHANGE_LOG

34: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.END_CRAWL',
35: 'Begin End_Crawl to remove crawled entries from the change log');
36: end if;
37: if (change_type='EVENT') then
38: DELETE FROM FND_SEARCHABLE_CHANGE_LOG
39: WHERE OBJECT_NAME=obj_name
40: AND CHANGE_TYPE IN ('INSERT','UPDATE')
41: AND CRAWL_STATUS='Y';
42: elsif (change_Type ='DELETE') then

Line 43: DELETE FROM FND_SEARCHABLE_CHANGE_LOG

39: WHERE OBJECT_NAME=obj_name
40: AND CHANGE_TYPE IN ('INSERT','UPDATE')
41: AND CRAWL_STATUS='Y';
42: elsif (change_Type ='DELETE') then
43: DELETE FROM FND_SEARCHABLE_CHANGE_LOG
44: WHERE OBJECT_NAME=obj_name
45: AND CHANGE_TYPE ='DELETE'
46: AND CRAWL_STATUS='Y';
47: elsif (change_Type='ERROR') then

Line 48: DELETE FROM FND_SEARCHABLE_CHANGE_LOG

44: WHERE OBJECT_NAME=obj_name
45: AND CHANGE_TYPE ='DELETE'
46: AND CRAWL_STATUS='Y';
47: elsif (change_Type='ERROR') then
48: DELETE FROM FND_SEARCHABLE_CHANGE_LOG
49: WHERE OBJECT_NAME=obj_name
50: AND CHANGE_TYPE ='ERROR'
51: AND CRAWL_STATUS='Y';
52: end if;

Line 79: UPDATE FND_SEARCHABLE_CHANGE_LOG

75: fnd_log.string(FND_LOG.LEVEL_STATEMENT, 'FND_SEARCH_EVENT.END_CRAWL',
76: 'Begin Reset_Crawl to reset entries that errored out during crawl');
77: end if;
78: if (change_type='EVENT') then
79: UPDATE FND_SEARCHABLE_CHANGE_LOG
80: SET CRAWL_STATUS=NULL
81: WHERE OBJECT_NAME=obj_name
82: AND CHANGE_TYPE IN ('INSERT','UPDATE')
83: AND CRAWL_STATUS='Y';

Line 85: UPDATE FND_SEARCHABLE_CHANGE_LOG

81: WHERE OBJECT_NAME=obj_name
82: AND CHANGE_TYPE IN ('INSERT','UPDATE')
83: AND CRAWL_STATUS='Y';
84: elsif (change_Type ='DELETE') then
85: UPDATE FND_SEARCHABLE_CHANGE_LOG
86: SET CRAWL_STATUS=NULL
87: WHERE OBJECT_NAME=obj_name
88: AND CHANGE_TYPE ='DELETE'
89: AND CRAWL_STATUS='Y';

Line 91: UPDATE FND_SEARCHABLE_CHANGE_LOG

87: WHERE OBJECT_NAME=obj_name
88: AND CHANGE_TYPE ='DELETE'
89: AND CRAWL_STATUS='Y';
90: elsif (change_Type='ERROR') then
91: UPDATE FND_SEARCHABLE_CHANGE_LOG
92: SET CRAWL_STATUS=NULL
93: WHERE OBJECT_NAME=obj_name
94: AND CHANGE_TYPE ='ERROR'
95: AND CRAWL_STATUS='Y';

Line 160: insert into fnd_searchable_change_log

156: pk_value_5 := p_event.GetValueForParameter('PK_VALUE_5');
157: status := p_event.GetValueForParameter('CRAWL_STATUS');
158: feed_url := p_event.GetValueForParameter('DATA_FEED_URL');
159:
160: insert into fnd_searchable_change_log
161: (
162: EVENT_INSTANCE_ID,
163: OBJECT_NAME,
164: CHANGE_TYPE,