[Home] [Help]
526:
527: Cursor LookupC is
528: select count (*) from CS_TP_LOOKUPS where LOOKUP_ID = p_One_Freetext.mLookupID;
529: Cursor FreetextC is
530: select FREETEXT_ID from CS_TP_FREETEXTS where LOOKUP_ID= p_One_Freetext.mLookupID;
531:
532:
533: l_lookup_count NUMBER;
534: l_freetext_id NUMBER:=NULL;
550:
551: -- Perform validation
552: IF (p_One_Freetext.mFreetextSize is NULL OR p_One_Freetext.mFreetextSize= FND_API.G_MISS_NUM) THEN
553: X_Return_Status := FND_API.G_RET_STS_ERROR;
554: FND_MESSAGE.SET_NAME('CS','CS_TP_FreetextSize_INVALID');
555: FND_MSG_PUB.Add;
556: RAISE FND_API.G_EXC_ERROR;
557: END IF;
558: open LookupC;
571: fetch FreetextC into l_freetext_update_id;
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,
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,
647: ftxt.freetext_size,
648: ftxt.lookup_id,
649: ftxt.last_update_date,
650: flkup.default_value
651: FROM cs_tp_freetexts ftxt,
652: cs_tp_lookups flkup
653: WHERE flkup.lookup_id = p_lookup_id
654: AND ftxt.lookup_id = flkup.lookup_id;
655: