101: );
102: X_Choice_ID := L_Choice_ID;
103: -- End of API Body
104:
105: -- Standard check of p_commit.
106: IF FND_API.To_Boolean( p_commit ) THEN
107: COMMIT WORK;
108: END IF;
109: -- Standard call to get message count and if count is 1, get message info.
105: -- Standard check of p_commit.
106: IF FND_API.To_Boolean( p_commit ) THEN
107: COMMIT WORK;
108: END IF;
109: -- Standard call to get message count and if count is 1, get message info.
110: FND_MSG_PUB.Count_And_Get
111: (p_count => x_msg_count ,
112: p_data => x_msg_data
113: );
160: CS_TP_CHOICES_PKG.DELETE_ROW ( P_Choice_ID);
161:
162: -- End of API Body
163:
164: -- Standard check of p_commit.
165: IF FND_API.To_Boolean( p_commit ) THEN
166: COMMIT WORK;
167: END IF;
168: -- Standard call to get message count and if count is 1, get message info.
164: -- Standard check of p_commit.
165: IF FND_API.To_Boolean( p_commit ) THEN
166: COMMIT WORK;
167: END IF;
168: -- Standard call to get message count and if count is 1, get message info.
169: FND_MSG_PUB.Count_And_Get
170: (p_count => x_msg_count ,
171: p_data => x_msg_data
172: );
250: );
251: end loop;
252: end if;
253:
254: -- Standard check of p_commit.
255: IF FND_API.To_Boolean( p_commit ) THEN
256: COMMIT WORK;
257: END IF;
258: -- Standard call to get message count and if count is 1, get message info.
254: -- Standard check of p_commit.
255: IF FND_API.To_Boolean( p_commit ) THEN
256: COMMIT WORK;
257: END IF;
258: -- Standard call to get message count and if count is 1, get message info.
259: FND_MSG_PUB.Count_And_Get
260: (p_count => x_msg_count ,
261: p_data => x_msg_data
262: );
373: j:=j+1;
374:
375: end loop;
376: dbms_sql.close_cursor(l_CursorID);
377: -- Standard check of p_commit.
378: IF FND_API.To_Boolean( p_commit) THEN
379: COMMIT WORK;
380: END IF;
381: -- Standard call to get message count and if count is 1, get message info.
377: -- Standard check of p_commit.
378: IF FND_API.To_Boolean( p_commit) THEN
379: COMMIT WORK;
380: END IF;
381: -- Standard call to get message count and if count is 1, get message info.
382: FND_MSG_PUB.Count_And_Get
383: (p_count => x_msg_count,
384: p_data => x_msg_data
385: );
477: end loop;
478: end if;
479:
480:
481: -- Standard check of p_commit.
482: IF FND_API.To_Boolean( p_commit ) THEN
483: COMMIT WORK;
484: END IF;
485: -- Standard call to get message count and if count is 1, get message info.
481: -- Standard check of p_commit.
482: IF FND_API.To_Boolean( p_commit ) THEN
483: COMMIT WORK;
484: END IF;
485: -- Standard call to get message count and if count is 1, get message info.
486: FND_MSG_PUB.Count_And_Get
487: (p_count => x_msg_count ,
488: p_data => x_msg_data
489: );
596: end if;
597: X_Freetext_ID := l_Freetext_ID ;
598: -- End of API Body
599:
600: -- Standard check of p_commit.
601: IF FND_API.To_Boolean( p_commit ) THEN
602: COMMIT WORK;
603: END IF;
604: -- Standard call to get message count and if count is 1, get message info.
600: -- Standard check of p_commit.
601: IF FND_API.To_Boolean( p_commit ) THEN
602: COMMIT WORK;
603: END IF;
604: -- Standard call to get message count and if count is 1, get message info.
605: FND_MSG_PUB.Count_And_Get
606: (p_count => x_msg_count ,
607: p_data => x_msg_data
608: );
684: X_Freetext.mLast_Updated_Date :=l_freetext.LAST_UPDATE_DATE;
685:
686: -- End of API Body
687:
688: -- Standard check of p_commit.
689: IF FND_API.To_Boolean( p_commit ) THEN
690: COMMIT WORK;
691: END IF;
692: -- Standard call to get message count and if count is 1, get message info.
688: -- Standard check of p_commit.
689: IF FND_API.To_Boolean( p_commit ) THEN
690: COMMIT WORK;
691: END IF;
692: -- Standard call to get message count and if count is 1, get message info.
693: FND_MSG_PUB.Count_And_Get
694: (p_count => x_msg_count ,
695: p_data => x_msg_data
696: );