314: ) IS
315: X_progress VARCHAR2(3) := NULL;
316: x_vendor_site_id number := null;
317: x_last_update_date date := sysdate;
318: x_last_updated_by number := fnd_global.user_id ;
319: x_creation_date date := sysdate;
320: x_created_by number := fnd_global.user_id;
321: x_last_update_login number := fnd_global.user_id;
322: x_sr_receipt_id number := null;
316: x_vendor_site_id number := null;
317: x_last_update_date date := sysdate;
318: x_last_updated_by number := fnd_global.user_id ;
319: x_creation_date date := sysdate;
320: x_created_by number := fnd_global.user_id;
321: x_last_update_login number := fnd_global.user_id;
322: x_sr_receipt_id number := null;
323: x_sr_source_id number := null;
324: X_ASSIGNMENT_ID number := null;
317: x_last_update_date date := sysdate;
318: x_last_updated_by number := fnd_global.user_id ;
319: x_creation_date date := sysdate;
320: x_created_by number := fnd_global.user_id;
321: x_last_update_login number := fnd_global.user_id;
322: x_sr_receipt_id number := null;
323: x_sr_source_id number := null;
324: X_ASSIGNMENT_ID number := null;
325: --
727: x_vendor_count_on_sr number := null;
728: x_sourcing_name varchar2(50);
729: x_sourcing_rule_within number := 0;
730: x_last_update_date date := sysdate;
731: x_last_updated_by number := fnd_global.user_id ;
732: x_creation_date date := sysdate;
733: x_created_by number := fnd_global.user_id;
734: x_last_update_login number := fnd_global.user_id;
735: x_effective_date date ;
729: x_sourcing_rule_within number := 0;
730: x_last_update_date date := sysdate;
731: x_last_updated_by number := fnd_global.user_id ;
732: x_creation_date date := sysdate;
733: x_created_by number := fnd_global.user_id;
734: x_last_update_login number := fnd_global.user_id;
735: x_effective_date date ;
736: x_disable_date date;
737: x_cnt_srdate number := null;
730: x_last_update_date date := sysdate;
731: x_last_updated_by number := fnd_global.user_id ;
732: x_creation_date date := sysdate;
733: x_created_by number := fnd_global.user_id;
734: x_last_update_login number := fnd_global.user_id;
735: x_effective_date date ;
736: x_disable_date date;
737: x_cnt_srdate number := null;
738: v_error_code NUMBER := 0;