DBA Data[Home] [Help]

APPS.ASO_HEADER_RLTSHIP_PVT dependencies on STANDARD

Line 32: -- Standard Start of API savepoint

28: l_api_version_number CONSTANT NUMBER := 1.0;
29: l_return_status_full VARCHAR2(1);
30: --l_identity_sales_member_rec ASO_SALES_MEMBER_PUB.Sales_member_rec_Type;
31: BEGIN
32: -- Standard Start of API savepoint
33: SAVEPOINT CREATE_HEADER_RLTSHIP_PVT;
34:
35: -- Standard call to check for call compatibility.
36: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 35: -- Standard call to check for call compatibility.

31: BEGIN
32: -- Standard Start of API savepoint
33: SAVEPOINT CREATE_HEADER_RLTSHIP_PVT;
34:
35: -- Standard call to check for call compatibility.
36: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
37: p_api_version_number,
38: l_api_name,
39: G_PKG_NAME)

Line 123: -- Standard check for p_commit

119: --
120: -- End of API body
121: --
122:
123: -- Standard check for p_commit
124: IF FND_API.to_Boolean( p_commit )
125: THEN
126: COMMIT WORK;
127: END IF;

Line 130: -- Standard call to get message count and if count is 1, get message info.

126: COMMIT WORK;
127: END IF;
128:
129:
130: -- Standard call to get message count and if count is 1, get message info.
131: FND_MSG_PUB.Count_And_Get
132: ( p_count => x_msg_count,
133: p_data => x_msg_data
134: );

Line 209: -- Standard Start of API savepoint

205: l_ref_HEADER_RLTSHIP_rec ASO_quote_PUB.HEADER_RLTSHIP_Rec_Type;
206: l_tar_HEADER_RLTSHIP_rec ASO_quote_PUB.HEADER_RLTSHIP_Rec_Type := P_HEADER_RLTSHIP_Rec;
207: l_rowid ROWID;
208: BEGIN
209: -- Standard Start of API savepoint
210: SAVEPOINT UPDATE_HEADER_RLTSHIP_PVT;
211:
212: -- Standard call to check for call compatibility.
213: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 212: -- Standard call to check for call compatibility.

208: BEGIN
209: -- Standard Start of API savepoint
210: SAVEPOINT UPDATE_HEADER_RLTSHIP_PVT;
211:
212: -- Standard call to check for call compatibility.
213: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
214: p_api_version_number,
215: l_api_name,
216: G_PKG_NAME)

Line 311: -- Standard check for p_commit

307: --
308: -- End of API body.
309: --
310:
311: -- Standard check for p_commit
312: IF FND_API.to_Boolean( p_commit )
313: THEN
314: COMMIT WORK;
315: END IF;

Line 319: -- Standard call to get message count and if count is 1, get message info.

315: END IF;
316:
317:
318:
319: -- Standard call to get message count and if count is 1, get message info.
320: FND_MSG_PUB.Count_And_Get
321: ( p_count => x_msg_count,
322: p_data => x_msg_data
323: );

Line 391: -- Standard Start of API savepoint

387: IS
388: l_api_name CONSTANT VARCHAR2(30) := 'Delete_header_rltship';
389: l_api_version_number CONSTANT NUMBER := 1.0;
390: BEGIN
391: -- Standard Start of API savepoint
392: SAVEPOINT DELETE_HEADER_RLTSHIP_PVT;
393:
394: -- Standard call to check for call compatibility.
395: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 394: -- Standard call to check for call compatibility.

390: BEGIN
391: -- Standard Start of API savepoint
392: SAVEPOINT DELETE_HEADER_RLTSHIP_PVT;
393:
394: -- Standard call to check for call compatibility.
395: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
396: p_api_version_number,
397: l_api_name,
398: G_PKG_NAME)

Line 424: -- Standard check for p_commit

420: --
421: -- End of API body
422: --
423:
424: -- Standard check for p_commit
425: IF FND_API.to_Boolean( p_commit )
426: THEN
427: COMMIT WORK;
428: END IF;

Line 432: -- Standard call to get message count and if count is 1, get message info.

428: END IF;
429:
430:
431:
432: -- Standard call to get message count and if count is 1, get message info.
433: FND_MSG_PUB.Count_And_Get
434: ( p_count => x_msg_count,
435: p_data => x_msg_data
436: );

Line 492: -- Standard Start of API savepoint

488:
489: l_api_name CONSTANT VARCHAR2(30) := 'Delete_header_rltship';
490: l_api_version_number CONSTANT NUMBER := 1.0;
491: BEGIN
492: -- Standard Start of API savepoint
493: SAVEPOINT DELETE_HEADER_RLTSHIP_PVT;
494:
495: -- Standard call to check for call compatibility.
496: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 495: -- Standard call to check for call compatibility.

491: BEGIN
492: -- Standard Start of API savepoint
493: SAVEPOINT DELETE_HEADER_RLTSHIP_PVT;
494:
495: -- Standard call to check for call compatibility.
496: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
497: p_api_version_number,
498: l_api_name,
499: G_PKG_NAME)

Line 532: -- Standard check for p_commit

528: RAISE FND_API.G_EXC_ERROR;
529: END IF;
530: END LOOP;
531:
532: -- Standard check for p_commit
533: IF FND_API.to_Boolean( p_commit )
534: THEN
535: COMMIT WORK;
536: END IF;

Line 539: -- Standard call to get message count and if count is 1, get message info.

535: COMMIT WORK;
536: END IF;
537:
538:
539: -- Standard call to get message count and if count is 1, get message info.
540: FND_MSG_PUB.Count_And_Get
541: ( p_count => x_msg_count,
542: p_data => x_msg_data
543: );

Line 606: -- Standard call to get message count and if count is 1, get message info.

602: x_return_status := FND_API.G_RET_STS_ERROR;
603: END IF;
604:
605:
606: -- Standard call to get message count and if count is 1, get message info.
607: FND_MSG_PUB.Count_And_Get
608: ( p_count => x_msg_count,
609: p_data => x_msg_data
610: );

Line 635: -- Standard call to get message count and if count is 1, get message info.

631:
632: -- Initialize API return status to SUCCESS
633: x_return_status := FND_API.G_RET_STS_SUCCESS;
634:
635: -- Standard call to get message count and if count is 1, get message info.
636: FND_MSG_PUB.Count_And_Get
637: ( p_count => x_msg_count,
638: p_data => x_msg_data
639: );

Line 665: -- Standard call to get message count and if count is 1, get message info.

661:
662: -- Initialize API return status to SUCCESS
663: x_return_status := FND_API.G_RET_STS_SUCCESS;
664:
665: -- Standard call to get message count and if count is 1, get message info.
666: FND_MSG_PUB.Count_And_Get
667: ( p_count => x_msg_count,
668: p_data => x_msg_data
669: );

Line 694: -- Standard call to get message count and if count is 1, get message info.

690:
691: -- Initialize API return status to SUCCESS
692: x_return_status := FND_API.G_RET_STS_SUCCESS;
693:
694: -- Standard call to get message count and if count is 1, get message info.
695: FND_MSG_PUB.Count_And_Get
696: ( p_count => x_msg_count,
697: p_data => x_msg_data
698: );

Line 724: -- Standard call to get message count and if count is 1, get message info.

720: -- Initialize API return status to SUCCESS
721: x_return_status := FND_API.G_RET_STS_SUCCESS;
722:
723:
724: -- Standard call to get message count and if count is 1, get message info.
725: FND_MSG_PUB.Count_And_Get
726: ( p_count => x_msg_count,
727: p_data => x_msg_data
728: );

Line 754: -- Standard call to get message count and if count is 1, get message info.

750:
751: -- Initialize API return status to SUCCESS
752: x_return_status := FND_API.G_RET_STS_SUCCESS;
753:
754: -- Standard call to get message count and if count is 1, get message info.
755: FND_MSG_PUB.Count_And_Get
756: ( p_count => x_msg_count,
757: p_data => x_msg_data
758: );

Line 838: -- Standard call to get message count and if count is 1, get message info.

834: if l_count < 1 then
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: end if;
837: END IF;
838: -- Standard call to get message count and if count is 1, get message info.
839: FND_MSG_PUB.Count_And_Get
840: ( p_count => x_msg_count,
841: p_data => x_msg_data
842: );

Line 867: -- Standard call to get message count and if count is 1, get message info.

863:
864: -- Initialize API return status to SUCCESS
865: x_return_status := FND_API.G_RET_STS_SUCCESS;
866:
867: -- Standard call to get message count and if count is 1, get message info.
868: FND_MSG_PUB.Count_And_Get
869: ( p_count => x_msg_count,
870: p_data => x_msg_data
871: );

Line 897: -- Standard call to get message count and if count is 1, get message info.

893: -- Initialize API return status to SUCCESS
894: x_return_status := FND_API.G_RET_STS_SUCCESS;
895:
896:
897: -- Standard call to get message count and if count is 1, get message info.
898: FND_MSG_PUB.Count_And_Get
899: ( p_count => x_msg_count,
900: p_data => x_msg_data
901: );