DBA Data[Home] [Help]

APPS.CS_TP_CHOICES_PVT dependencies on CS_TP_FREETEXTS_PKG

Line 576: CS_TP_FREETEXTS_PKG.INSERT_ROW (

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,

Line 588: CS_TP_FREETEXTS_PKG.UPDATE_ROW (

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,