DBA Data[Home] [Help]

APPS.RRS_IMPORT_INTERFACE_PKG dependencies on RRS_LOCATION_UA_INTF

Line 149: from RRS_LOCATION_UA_INTF A

145:
146: Begin
147: select 'Y'
148: into l_loc_exist
149: from RRS_LOCATION_UA_INTF A
150: where a.batch_id = p_batch_id
151: and (A.LOCATION_ID is NOT NULL )
152: and (A.Process_status = G_PS_TO_BE_PROCESSED )
153: and rownum < 2;

Line 205: UPDATE RRS_LOCATION_UA_INTF

201:
202: end if;
203:
204: If l_loc_exist = 'Y' then
205: UPDATE RRS_LOCATION_UA_INTF
206: SET DATA_SET_ID = l_data_set_id,
207: Transaction_id = l_data_set_id,
208: ATTR_GROUP_TYPE = 'RRS_LOCATION_GROUP',
209: DATA_LEVEL_ID = 71801,

Line 217: fnd_stats.gather_table_stats('RRS','RRS_LOCATION_UA_INTF',cascade=>true,percent=>30);

213: and Process_status = G_PS_TO_BE_PROCESSED;
214:
215: If p_gather_stats = 'Y' then
216:
217: fnd_stats.gather_table_stats('RRS','RRS_LOCATION_UA_INTF',cascade=>true,percent=>30);
218:
219: end if;
220:
221: