[Home] [Help]
448: raise no_data_found;
449: end if;
450:
451: --Srini
452: UPDATE pn_var_lines_all
453: SET sales_type_code = X_SALES_TYPE_CODE,
454: item_category_code = X_ITEM_CATEGORY_CODE
455: WHERE var_rent_id = X_VAR_RENT_ID
456: AND line_default_id = X_LINE_DEFAULT_ID;
472: IS
473:
474: CURSOR line_items IS
475: SELECT line_item_id
476: FROM pn_var_lines_all
477: WHERE line_default_id = x_line_default_id;
478:
479: BEGIN
480: