32: l_api_name VARCHAR2(255):='Get_EmailAccount_List';
33: l_api_version_number NUMBER:=1.0;
34:
35: BEGIN
36: -- Standard Start of API savepoint
37: SAVEPOINT Get_EmailAccount_List_PUB;
38: -- Standard call to check for call compatibility.
39: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
40: p_api_version_number,
34:
35: BEGIN
36: -- Standard Start of API savepoint
37: SAVEPOINT Get_EmailAccount_List_PUB;
38: -- Standard call to check for call compatibility.
39: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
40: p_api_version_number,
41: l_api_name,
42: G_PKG_NAME)
76: l_email_index:=l_email_index+1;
77:
78: END LOOP;
79: END IF;
80: -- Standard Check Of p_commit.
81: IF FND_API.To_Boolean(p_commit) THEN
82: COMMIT WORK;
83: END IF;
84: -- Standard callto get message count and if count is 1, get message info.
80: -- Standard Check Of p_commit.
81: IF FND_API.To_Boolean(p_commit) THEN
82: COMMIT WORK;
83: END IF;
84: -- Standard callto get message count and if count is 1, get message info.
85: FND_MSG_PUB.Count_And_Get
86: ( p_count => x_msg_count,
87: p_data => x_msg_data
88: );
159: l_res_name varchar2(1000);
160: l_flag number;
161:
162: BEGIN
163: -- Standard Start of API savepoint
164: SAVEPOINT ListAgentAccounts_PUB;
165: -- Standard call to check for call compatibility.
166: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
167: p_api_version_number,
161:
162: BEGIN
163: -- Standard Start of API savepoint
164: SAVEPOINT ListAgentAccounts_PUB;
165: -- Standard call to check for call compatibility.
166: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
167: p_api_version_number,
168: l_api_name,
169: G_PKG_NAME)
203: l_email_index:=l_email_index+1;
204:
205: END LOOP;
206: END IF;
207: -- Standard Check Of p_commit.
208: IF FND_API.To_Boolean(p_commit) THEN
209: COMMIT WORK;
210: END IF;
211: -- Standard callto get message count and if count is 1, get message info.
207: -- Standard Check Of p_commit.
208: IF FND_API.To_Boolean(p_commit) THEN
209: COMMIT WORK;
210: END IF;
211: -- Standard callto get message count and if count is 1, get message info.
212: FND_MSG_PUB.Count_And_Get
213: ( p_count => x_msg_count,
214: p_data => x_msg_data
215: );
276: l_res_name varchar2(1000);
277: l_flag number;
278:
279: BEGIN
280: -- Standard Start of API savepoint
281: SAVEPOINT ListAgentCPAccounts_PUB;
282: -- Standard call to check for call compatibility.
283: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
284: p_api_version_number,
278:
279: BEGIN
280: -- Standard Start of API savepoint
281: SAVEPOINT ListAgentCPAccounts_PUB;
282: -- Standard call to check for call compatibility.
283: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
284: p_api_version_number,
285: l_api_name,
286: G_PKG_NAME)
320: l_email_index:=l_email_index+1;
321:
322: END LOOP;
323: END IF;
324: -- Standard Check Of p_commit.
325: IF FND_API.To_Boolean(p_commit) THEN
326: COMMIT WORK;
327: END IF;
328: -- Standard callto get message count and if count is 1, get message info.
324: -- Standard Check Of p_commit.
325: IF FND_API.To_Boolean(p_commit) THEN
326: COMMIT WORK;
327: END IF;
328: -- Standard callto get message count and if count is 1, get message info.
329: FND_MSG_PUB.Count_And_Get
330: ( p_count => x_msg_count,
331: p_data => x_msg_data
332: );
406: l_dummy INTEGER;
407: l_role_Str varchar2(1000);
408:
409: BEGIN
410: -- Standard Start of API savepoint
411: SAVEPOINT ListAgentAccountDetails_PUB;
412: -- Standard call to check for call compatibility.
413: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
414: p_api_version_number,
408:
409: BEGIN
410: -- Standard Start of API savepoint
411: SAVEPOINT ListAgentAccountDetails_PUB;
412: -- Standard call to check for call compatibility.
413: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
414: p_api_version_number,
415: l_api_name,
416: G_PKG_NAME)
553: END LOOP;
554: END IF;
555: END IF;
556:
557: -- Standard Check Of p_commit.
558: IF FND_API.To_Boolean(p_commit) THEN
559: COMMIT WORK;
560: END IF;
561: -- Standard callto get message count and if count is 1, get message info.
557: -- Standard Check Of p_commit.
558: IF FND_API.To_Boolean(p_commit) THEN
559: COMMIT WORK;
560: END IF;
561: -- Standard callto get message count and if count is 1, get message info.
562: FND_MSG_PUB.Count_And_Get
563: ( p_count => x_msg_count,
564: p_data => x_msg_data
565: );
624: l_api_name VARCHAR2(255):='ListAccountDetails';
625: l_api_version_number NUMBER:=1.0;
626:
627: BEGIN
628: -- Standard Start of API savepoint
629: SAVEPOINT ListAccountDetails_PUB;
630: -- Standard call to check for call compatibility.
631: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
632: p_api_version_number,
626:
627: BEGIN
628: -- Standard Start of API savepoint
629: SAVEPOINT ListAccountDetails_PUB;
630: -- Standard call to check for call compatibility.
631: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
632: p_api_version_number,
633: l_api_name,
634: G_PKG_NAME)
658: l_email_index:=l_email_index+1;
659:
660: END LOOP;
661: END IF;
662: -- Standard Check Of p_commit.
663: IF FND_API.To_Boolean(p_commit) THEN
664: COMMIT WORK;
665: END IF;
666: -- Standard callto get message count and if count is 1, get message info.
662: -- Standard Check Of p_commit.
663: IF FND_API.To_Boolean(p_commit) THEN
664: COMMIT WORK;
665: END IF;
666: -- Standard callto get message count and if count is 1, get message info.
667: FND_MSG_PUB.Count_And_Get
668: ( p_count => x_msg_count,
669: p_data => x_msg_data
670: );