-- -- ec_product__new/16 -- create or replace function ec_product__new( integer, integer, integer, character varying, numeric, character varying, character varying, character varying, character varying, boolean, character, character varying, timestamp with time zone, character varying, character varying, character varying ) returns int4 as $$ declare new__product_id alias for $1; -- default null new__creation_user alias for $2; -- default null new__context_id alias for $3; -- default null (package_id) new__product_name alias for $4; new__price alias for $5; -- default null new__sku alias for $6; -- default null new__one_line_description alias for $7; -- default null new__detailed_description alias for $8; -- default null new__search_keywords alias for $9; -- default null new__present_p alias for $10; -- default t new__stock_status alias for $11; -- default o new__dirname alias for $12; -- default null new__available_date alias for $13; -- default sysdate new__color_list alias for $14; -- default null new__size_list alias for $15; -- default null new__creation_ip alias for $16; -- default null -- new__style_list alias for $17 -- default null -- new__email_on_purchase_list alias for $18 -- default null -- new__url alias for $19 -- default null -- new__no_shipping_avail_p alias for $20 -- default f -- new__shipping alias for $21 -- default null -- new__shipping_additional alias for $22 -- default null -- new__weight alias for $23 -- default null -- new__active_p alias for $24 -- default t -- new__template_id alias for $25 -- default null -- new__announcements alias for $26 -- default null -- new__announcements_expire alias for $27 -- default null v_object_id integer; begin v_object_id := acs_object__new ( new__product_id, 'ec_product', now(), new__creation_user, new__creation_ip, new__context_id ); insert into ec_products (product_id, creation_date, last_modified, last_modifying_user, modified_ip_address, product_name, price, sku, one_line_description, detailed_description, search_keywords, present_p, stock_status, dirname, available_date, color_list, size_list) values (v_object_id, now(), now(), new__creation_user, new__creation_ip, new__product_name, new__price, new__sku, new__one_line_description, new__detailed_description, new__search_keywords, new__present_p, new__stock_status, new__dirname, new__available_date, new__color_list, new__size_list); return v_object_id; end;$$ language plpgsql;