APPS.RRS_ASSETS_PKG dependencies on RRS_SITES_INTF

Line 15: FROM RRS_SITES_INTF

11: IS
12:
13: CURSOR SELECTED_SITES_CUR IS
14: SELECT SITE_ID
15: FROM RRS_SITES_INTF
16: WHERE SESSION_ID = p_session_id;
17:
18: CURSOR SELECTED_SITE_DET_CUR( c_site_id IN NUMBER ) IS
19: SELECT PARTY_SITE_ID

Line 255: DELETE FROM RRS_SITES_INTF WHERE SESSION_ID = p_session_id ;

251: END LOOP ; -- end SUBJECT_IDS_CUR cursor
252: END LOOP ; -- end SELECTED_SITES_CUR FOR
253:
254: --IF l_conc_or_online <> 'ONLINE' THEN
255: DELETE FROM RRS_SITES_INTF WHERE SESSION_ID = p_session_id ;
256: COMMIT;
257: --END IF;
258:
259: EXCEPTION

Line 368: PROCEDURE POPULATE_RRS_SITES_INTF

364: x_return_status := 'E' ;
365: x_msg_count := FND_MSG_PUB.COUNT_MSG;
366: END CREATE_ASSET_INSTANCES_CONC ;
367:
368: PROCEDURE POPULATE_RRS_SITES_INTF
369: ( p_session_id IN VARCHAR2
370: ,p_site_ids IN RRS_NUMBER_TBL_TYPE DEFAULT NULL
371: ,p_created_by IN NUMBER
372: ,p_creation_date IN DATE

Line 380: INSERT INTO RRS_SITES_INTF

376: )
377: IS
378: BEGIN
379: FORALL i in 1..p_site_ids.count
380: INSERT INTO RRS_SITES_INTF
381: ( session_id
382: ,site_id
383: ,created_by
384: ,creation_date

Line 398: END POPULATE_RRS_SITES_INTF;

394: ,p_last_update_date
395: ,p_last_update_login
396: );
397:
398: END POPULATE_RRS_SITES_INTF;
399:
400:
401: END RRS_ASSETS_PKG;
402: