APPS.RRS_IMPORT_INTERFACE_PKG dependencies on RRS_SITE_UA_INTF

Line 134: from RRS_SITE_UA_INTF A

130:
131: Begin
132: select 'Y'
133: into l_site_exist
134: from RRS_SITE_UA_INTF A
135: where a.batch_id = p_batch_id
136: and (A.SITE_ID is NOT NULL )
137: and (A.Process_status = G_PS_TO_BE_PROCESSED )
138: and rownum < 2;

Line 186: UPDATE RRS_SITE_UA_INTF

182: INTO l_data_set_id
183: FROM DUAL;
184:
185: If l_site_exist = 'Y' then
186: UPDATE RRS_SITE_UA_INTF
187: SET DATA_SET_ID = l_data_set_id,
188: Transaction_id = l_data_set_id,
189: ATTR_GROUP_TYPE = 'RRS_SITEMGMT_GROUP',
190: DATA_LEVEL_ID = 71802,

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

194: and Process_status = G_PS_TO_BE_PROCESSED;
195:
196: If p_gather_stats = 'Y' then
197:
198: fnd_stats.gather_table_stats('RRS','RRS_SITE_UA_INTF',cascade=>true,percent=>30);
199:
200: end if;
201:
202: end if;