572: close FreeTextC;
573:
574: if (l_freetext_update_id is NULL ) then
575: select CS_TP_FREETEXTS_S.NEXTVAL into l_freetext_id from dual;
576: CS_TP_FREETEXTS_PKG.INSERT_ROW (
577: X_ROWID => l_ROWID,
578: X_FREETEXT_ID => l_freetext_id,
579: X_LOOKUP_ID => P_One_Freetext.mLookupID,
580: X_FREETEXT_SIZE => P_One_Freetext.mFreetextSize,
584: X_LAST_UPDATED_BY => l_created_by,
585: X_LAST_UPDATE_LOGIN => l_login );
586:
587: elsif (l_freetext_update_id is not NULL ) then
588: CS_TP_FREETEXTS_PKG.UPDATE_ROW (
589: X_FREETEXT_ID => l_freetext_update_id,
590: X_FREETEXT_SIZE => P_One_Freetext.mFreetextSize,
591: X_LOOKUP_ID => P_One_Freetext.mLookUpID,
592: X_LAST_UPDATE_DATE => l_current_date,