[Home] [Help]
599: if x_sponsor_action_date <> l_old_sponsor_action_date or
600: nvl(x_sponsor_action_code,'_') <> nvl(l_old_sponsor_action_code,'_') or
601: nvl(x_sponsor_action_comments,'_') <> nvl(l_old_sponsor_action_comments,'_') then
602:
603: insert into igw_prop_comments
604: (
605: PROPOSAL_ID,
606: COMMENT_ID,
607: COMMENTS,
616: )
617: values
618: (
619: X_PROPOSAL_ID,
620: IGW_PROP_COMMENTS_S.NEXTVAL,
621: X_SPONSOR_ACTION_COMMENTS,
622: X_LAST_UPDATE_DATE,
623: X_LAST_UPDATED_BY,
624: X_LAST_UPDATE_DATE,