Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if (p_newcaps = 'Y') then
- p_newcapsdesc := 'Yes';
- elsif (p_newcaps = 'N') then
- p_newcapsdesc := 'No';
- else p_newcapsdesc := 'Keep';
- end if;
- if (p_newwkp = 'Y') then
- p_newwkpdesc := 'Yes';
- elsif (p_newwkp = 'N') then
- p_newwkpdesc := 'No';
- else p_newwkpdesc := 'Keep';
- end if;
- if (p_newunsch = 'Y') then
- p_newunschdesc := 'Yes';
- elsif (p_newunsch = 'N') then
- p_newunschdesc := 'No';
- else p_newunschdesc := 'Keep';
- end if;
Add Comment
Please, Sign In to add comment