292: where placement_citem_id = x_placement_citem_id;
293:
294: cursor c_get_placement_citem_id is
295: select ams_web_plce_citem_assoc_s.nextval 296: from dual; 297: BEGIN
298: if X_OWNER = 'SEED' then
299: l_user_id := 1;
300: elsif X_OWNER = 'ORACLE' then