DBA Data[Home] [Help]

APPS.RRS_SITE_UTILS dependencies on RRS_USER_FAVORITES

Line 852: select 1 into l_temp from rrs_user_favorites

848: obj_index := v_object_type.first;
849: while obj_index <= v_object_type.last
850: LOOP
851: BEGIN
852: select 1 into l_temp from rrs_user_favorites
853: where object_type = v_object_type(obj_index) and
854: object_id = v_object_id(obj_index) and
855: user_id = P_USER_ID;
856:

Line 873: insert into rrs_user_favorites

869: /*Bug Fix 9700523 -- Modified by Narasimha */
870: for ins_index in v_object_type.first..v_object_type.last
871: loop
872: if v_object_type.exists(ins_index) then
873: insert into rrs_user_favorites
874: (USER_FAVORITE_ID,
875: OBJECT_TYPE,
876: OBJECT_ID,
877: USER_ID,