[Home] [Help]
4120: l_master_organization_id NUMBER;
4121:
4122:
4123: BEGIN
4124: -- Standard Start of API savepoint
4125: SAVEPOINT CREATE_quote_PVT;
4126:
4127: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4128: aso_debug_pub.add('******************************************************', 1, 'Y');
4129: aso_debug_pub.add('Begin Create_Quote Procedure', 1, 'Y');
4130: aso_debug_pub.add('******************************************************', 1, 'Y');
4131: END IF;
4132:
4133: -- Standard call to check for call compatibility.
4134: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4135: p_api_version_number,
4136: l_api_name,
4137: G_PKG_NAME) THEN
6485: --
6486: -- End of API body
6487: --
6488:
6489: -- Standard check for p_commit
6490:
6491: IF FND_API.to_Boolean( p_commit ) THEN
6492: COMMIT WORK;
6493: END IF;
6493: END IF;
6494:
6495:
6496:
6497: -- Standard call to get message count and if count is 1, get message info.
6498:
6499: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6500: p_data => x_msg_data );
6501:
6914: l_paynow_charges NUMBER;
6915: l_paynow_total NUMBER;
6916: l_call_ar_api varchar2(1);
6917: BEGIN
6918: -- Standard Start of API savepoint
6919: SAVEPOINT UPDATE_quote_PVT;
6920:
6921: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6922: aso_debug_pub.add('******************************************************', 1, 'Y');
6923: aso_debug_pub.add('Begin Update_Quote Procedure', 1, 'Y');
6924: aso_debug_pub.add('******************************************************', 1, 'Y');
6925: END IF;
6926:
6927: -- Standard call to check for call compatibility.
6928: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
6929: p_api_version_number,
6930: l_api_name,
6931: G_PKG_NAME) THEN
10514:
10515: -- Change END
10516:
10517:
10518: -- Standard check for p_commit
10519: IF FND_API.to_Boolean( p_commit ) THEN
10520: COMMIT WORK;
10521: END IF;
10522:
10519: IF FND_API.to_Boolean( p_commit ) THEN
10520: COMMIT WORK;
10521: END IF;
10522:
10523: -- Standard call to get message count and if count is 1, get message info.
10524: FND_MSG_PUB.Count_And_Get
10525: ( p_count => x_msg_count,
10526: p_data => x_msg_data
10527: );
10589: CURSOR c_qte_line(l_d_qte_line NUMBER) IS
10590: SELECT quote_line_id FROM ASO_QUOTE_LINES_ALL
10591: where quote_line_id= l_qte_line_rec.quote_line_id;
10592: BEGIN
10593: -- Standard Start of API savepoint
10594: SAVEPOINT DELETE_quote_PVT;
10595:
10596: -- Standard call to check for call compatibility.
10597: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
10592: BEGIN
10593: -- Standard Start of API savepoint
10594: SAVEPOINT DELETE_quote_PVT;
10595:
10596: -- Standard call to check for call compatibility.
10597: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
10598: p_api_version_number,
10599: l_api_name,
10600: G_PKG_NAME)
10711: --
10712: -- End of API body
10713: --
10714:
10715: -- Standard check for p_commit
10716: IF FND_API.to_Boolean( p_commit )
10717: THEN
10718: COMMIT WORK;
10719: END IF;
10718: COMMIT WORK;
10719: END IF;
10720:
10721:
10722: -- Standard call to get message count and if count is 1, get message info.
10723: FND_MSG_PUB.Count_And_Get
10724: ( p_count => x_msg_count,
10725: p_data => x_msg_data
10726: );
10960: l_Copy_Quote_Control_Rec ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
10961: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec;
10962:
10963: BEGIN
10964: -- Standard Start of API savepoint
10965: SAVEPOINT COPY_QUOTE_PVT;
10966:
10967: -- Standard call to check for call compatibility.
10968: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
10963: BEGIN
10964: -- Standard Start of API savepoint
10965: SAVEPOINT COPY_QUOTE_PVT;
10966:
10967: -- Standard call to check for call compatibility.
10968: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
10969: p_api_version_number,
10970: l_api_name,
10971: G_PKG_NAME) THEN
11265: --
11266: -- End of API body
11267: --
11268: */ -- original cpy_qte
11269: -- Standard check for p_commit
11270: IF FND_API.to_Boolean( p_commit )
11271: THEN
11272: COMMIT WORK;
11273: END IF;
11273: END IF;
11274:
11275:
11276:
11277: -- Standard call to get message count and if count is 1, get message info.
11278: FND_MSG_PUB.Count_And_Get
11279: ( p_count => x_msg_count,
11280: p_data => x_msg_data
11281: );
11841: -- Local scratch record
11842: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
11843: l_crit_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
11844: BEGIN
11845: -- Standard Start of API savepoint
11846: SAVEPOINT GET_QUOTE_PVT;
11847:
11848: -- Standard call to check for call compatibility.
11849: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
11844: BEGIN
11845: -- Standard Start of API savepoint
11846: SAVEPOINT GET_QUOTE_PVT;
11847:
11848: -- Standard call to check for call compatibility.
11849: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
11850: p_api_version_number,
11851: l_api_name,
11852: G_PKG_NAME)
11986: --
11987:
11988:
11989:
11990: -- Standard call to get message count and if count is 1, get message info.
11991: FND_MSG_PUB.Count_And_Get
11992: ( p_count => x_msg_count,
11993: p_data => x_msg_data
11994: );
12685: AND role.delete_flag = 'N';
12686:
12687: BEGIN
12688:
12689: -- Standard call to check for call compatibility.
12690: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
12691: p_api_version_number,
12692: l_api_name,
12693: G_PKG_NAME)
12756: aso_debug_pub.add('Quote_Security_Check(): End: Security_Flag: '||X_Security_Flag, 1, 'Y');
12757: END IF;
12758:
12759:
12760: -- Standard call to get message count and if count is 1, get message info.
12761: FND_MSG_PUB.Count_And_Get
12762: ( p_count => x_msg_count,
12763: p_data => x_msg_data
12764: );