[Home] [Help]
500: if x_sponsor_action_date <> l_old_sponsor_action_date or
501: nvl(x_sponsor_action_code,'_') <> nvl(l_old_sponsor_action_code,'_') or
502: nvl(x_sponsor_action_comments,'_') <> nvl(l_old_sponsor_action_comments,'_') then
503:
504: insert into igw_prop_comments
505: (
506: PROPOSAL_ID,
507: COMMENT_ID,
508: COMMENTS,
517: )
518: values
519: (
520: X_PROPOSAL_ID,
521: IGW_PROP_COMMENTS_S.NEXTVAL,
522: X_SPONSOR_ACTION_COMMENTS,
523: X_LAST_UPDATE_DATE,
524: X_LAST_UPDATED_BY,
525: X_LAST_UPDATE_DATE,