DBA Data[Home] [Help]

APPS.CS_TP_CHOICES_PVT dependencies on CS_TP_CHOICES_PKG

Line 86: CS_TP_CHOICES_PKG.INSERT_ROW (

82: l_created_by := FND_GLOBAL.user_id;
83: l_login := fnd_global.login_id;
84:
85: select CS_TP_CHOICES_S.NEXTVAL into l_choice_id from dual;
86: CS_TP_CHOICES_PKG.INSERT_ROW (
87: X_ROWID => l_ROWID,
88: X_CHOICE_ID => l_choice_id,
89: X_LOOKUP_ID => P_One_Choice.mLookupID,
90: X_SEQUENCE_NUMBER => l_max_sequence +1,

Line 160: CS_TP_CHOICES_PKG.DELETE_ROW ( P_Choice_ID);

156: -- Start API Body
157:
158: -- delete choice
159:
160: CS_TP_CHOICES_PKG.DELETE_ROW ( P_Choice_ID);
161:
162: -- End of API Body
163:
164: -- Standard check of p_commit.

Line 238: CS_TP_CHOICES_PKG.UPDATE_ROW (

234: FND_MESSAGE.SET_NAME('CS','CS_TP_CHOICE_UPDATED');
235: FND_MSG_PUB.Add;
236: RAISE FND_API.G_EXC_ERROR;
237: end if;
238: CS_TP_CHOICES_PKG.UPDATE_ROW (
239: X_CHOICE_ID => P_Choices (i).mChoiceID,
240: X_LOOKUP_ID => l_lookup_id,
241: X_START_DATE_ACTIVE => null,
242: X_END_DATE_ACTIVE =>null,

Line 462: CS_TP_CHOICES_PKG.UPDATE_ROW (

458: RAISE FND_API.G_EXC_ERROR;
459: end if;
460: */
461:
462: CS_TP_CHOICES_PKG.UPDATE_ROW (
463: X_CHOICE_ID => P_Choices (i).mChoiceID,
464: X_LOOKUP_ID => P_Choices (i).mLookupID,
465: X_START_DATE_ACTIVE => null,
466: X_END_DATE_ACTIVE =>null,