860: l_row_cnt := l_row_cnt + 1;
861: END IF;
862:
863: --Bug 3797002, kkillams
864: --FND_DATE.DATE_TO_CANONICAL function is added to conver the date into character value.
865: IF (l_vr_db_rec.START_DATE <> p_recipe_vr_rec.START_DATE) THEN
866: p_vr_update_tbl(l_row_cnt).p_col_to_update := 'START_DATE';
867: p_vr_update_tbl(l_row_cnt).p_value :=FND_DATE.DATE_TO_CANONICAL(p_recipe_vr_rec.START_DATE);
868: l_row_cnt := l_row_cnt + 1;
863: --Bug 3797002, kkillams
864: --FND_DATE.DATE_TO_CANONICAL function is added to conver the date into character value.
865: IF (l_vr_db_rec.START_DATE <> p_recipe_vr_rec.START_DATE) THEN
866: p_vr_update_tbl(l_row_cnt).p_col_to_update := 'START_DATE';
867: p_vr_update_tbl(l_row_cnt).p_value :=FND_DATE.DATE_TO_CANONICAL(p_recipe_vr_rec.START_DATE);
868: l_row_cnt := l_row_cnt + 1;
869: END IF;
870:
871: IF ((l_vr_db_rec.END_DATE IS NULL) AND (p_recipe_vr_rec.END_DATE IS NOT NULL)) THEN
869: END IF;
870:
871: IF ((l_vr_db_rec.END_DATE IS NULL) AND (p_recipe_vr_rec.END_DATE IS NOT NULL)) THEN
872: p_vr_update_tbl(l_row_cnt).p_col_to_update := 'END_DATE';
873: p_vr_update_tbl(l_row_cnt).p_value := FND_DATE.DATE_TO_CANONICAL(p_recipe_vr_rec.END_DATE);
874: l_row_cnt := l_row_cnt + 1;
875: ELSIF ((l_vr_db_rec.END_DATE IS NOT NULL) AND (p_recipe_vr_rec.END_DATE IS NULL)) THEN
876: p_vr_update_tbl(l_row_cnt).p_col_to_update := 'END_DATE';
877: p_vr_update_tbl(l_row_cnt).p_value := FND_DATE.DATE_TO_CANONICAL(p_recipe_vr_rec.END_DATE);
873: p_vr_update_tbl(l_row_cnt).p_value := FND_DATE.DATE_TO_CANONICAL(p_recipe_vr_rec.END_DATE);
874: l_row_cnt := l_row_cnt + 1;
875: ELSIF ((l_vr_db_rec.END_DATE IS NOT NULL) AND (p_recipe_vr_rec.END_DATE IS NULL)) THEN
876: p_vr_update_tbl(l_row_cnt).p_col_to_update := 'END_DATE';
877: p_vr_update_tbl(l_row_cnt).p_value := FND_DATE.DATE_TO_CANONICAL(p_recipe_vr_rec.END_DATE);
878: l_row_cnt := l_row_cnt + 1;
879: ELSIF (l_vr_db_rec.END_DATE <> p_recipe_vr_rec.END_DATE) THEN
880: p_vr_update_tbl(l_row_cnt).p_col_to_update := 'END_DATE';
881: p_vr_update_tbl(l_row_cnt).p_value := FND_DATE.DATE_TO_CANONICAL(p_recipe_vr_rec.END_DATE);
877: p_vr_update_tbl(l_row_cnt).p_value := FND_DATE.DATE_TO_CANONICAL(p_recipe_vr_rec.END_DATE);
878: l_row_cnt := l_row_cnt + 1;
879: ELSIF (l_vr_db_rec.END_DATE <> p_recipe_vr_rec.END_DATE) THEN
880: p_vr_update_tbl(l_row_cnt).p_col_to_update := 'END_DATE';
881: p_vr_update_tbl(l_row_cnt).p_value := FND_DATE.DATE_TO_CANONICAL(p_recipe_vr_rec.END_DATE);
882: l_row_cnt := l_row_cnt + 1;
883: END IF;
884:
885: IF ( l_vr_db_rec.MIN_QTY <> p_recipe_vr_rec.MIN_QTY) THEN
930: p_vr_update_tbl(l_row_cnt).p_value := NVL(p_recipe_vr_rec.last_updated_by, fnd_global.USER_ID);
931: l_row_cnt := l_row_cnt + 1;
932:
933: p_vr_update_tbl(l_row_cnt).p_col_to_update := 'LAST_UPDATE_DATE';
934: p_vr_update_tbl(l_row_cnt).p_value := FND_DATE.DATE_TO_CANONICAL(NVL(p_recipe_vr_rec.last_update_date,SYSDATE));
935: l_row_cnt := l_row_cnt + 1;
936:
937: p_vr_update_tbl(l_row_cnt).p_col_to_update := 'LAST_UPDATE_LOGIN';
938: p_vr_update_tbl(l_row_cnt).p_value := NVL(p_recipe_vr_rec.last_update_login, gmd_api_grp.login_id);