74:
75: BEGIN
76:
77: l_stmt := 10;
78: -- Standard Start of API savepoint
79: SAVEPOINT insert_AR_Interface_PVT;
80: -- Standard call to check for call compatibility.
81: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
82: p_api_version ,
76:
77: l_stmt := 10;
78: -- Standard Start of API savepoint
79: SAVEPOINT insert_AR_Interface_PVT;
80: -- Standard call to check for call compatibility.
81: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
82: p_api_version ,
83: l_api_name ,
84: G_PKG_NAME )
352: l_stmt := 70;
353:
354: -- End of API body.
355:
356: -- Standard check of p_commit.
357: IF FND_API.To_Boolean( p_commit ) THEN
358: COMMIT WORK;
359: END IF;
360: -- Standard call to get message count and if count is 1, get message info.
356: -- Standard check of p_commit.
357: IF FND_API.To_Boolean( p_commit ) THEN
358: COMMIT WORK;
359: END IF;
360: -- Standard call to get message count and if count is 1, get message info.
361: FND_MSG_PUB.Count_And_Get
362: ( p_count => x_msg_count ,
363: p_data => x_msg_data
364: );
413: l_rounded_unit_price NUMBER;
414: l_rounded_conv_rate NUMBER;
415:
416: BEGIN
417: -- Standard Start of API savepoint
418: SAVEPOINT insert_WO_Table_PVT;
419: -- Standard call to check for call compatibility.
420: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
421: p_api_version ,
415:
416: BEGIN
417: -- Standard Start of API savepoint
418: SAVEPOINT insert_WO_Table_PVT;
419: -- Standard call to check for call compatibility.
420: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
421: p_api_version ,
422: l_api_name ,
423: G_PKG_NAME )
559:
560:
561:
562: -- End of API body.
563: -- Standard check of p_commit.
564: IF FND_API.To_Boolean( p_commit ) THEN
565: COMMIT WORK;
566: END IF;
567: -- Standard call to get message count and if count is 1, get message info.
563: -- Standard check of p_commit.
564: IF FND_API.To_Boolean( p_commit ) THEN
565: COMMIT WORK;
566: END IF;
567: -- Standard call to get message count and if count is 1, get message info.
568: FND_MSG_PUB.Count_And_Get
569: ( p_count => x_msg_count ,
570: p_data => x_msg_data
571: );
651: l_rounded_amount NUMBER;
652:
653:
654: BEGIN
655: -- Standard Start of API savepoint
656: SAVEPOINT insert_PAEvent_Table_PVT;
657: -- Standard call to check for call compatibility.
658: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
659: p_api_version ,
653:
654: BEGIN
655: -- Standard Start of API savepoint
656: SAVEPOINT insert_PAEvent_Table_PVT;
657: -- Standard call to check for call compatibility.
658: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
659: p_api_version ,
660: l_api_name ,
661: G_PKG_NAME )
813: --dbms_output.put_line('finished inserting');
814:
815:
816: -- End of API body.
817: -- Standard check of p_commit.
818: IF FND_API.To_Boolean( p_commit ) THEN
819: COMMIT WORK;
820: END IF;
821: -- Standard call to get message count and if count is 1, get message info.
817: -- Standard check of p_commit.
818: IF FND_API.To_Boolean( p_commit ) THEN
819: COMMIT WORK;
820: END IF;
821: -- Standard call to get message count and if count is 1, get message info.
822: FND_MSG_PUB.Count_And_Get
823: ( p_count => x_msg_count ,
824: p_data => x_msg_data
825: );