[Home] [Help]
4207: l_ato_line_id number;
4208:
4209:
4210: BEGIN
4211: -- Standard Start of API savepoint
4212: SAVEPOINT CREATE_quote_PVT;
4213:
4214: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4215: aso_debug_pub.add('******************************************************', 1, 'Y');
4216: aso_debug_pub.add('Begin Create_Quote Procedure', 1, 'Y');
4217: aso_debug_pub.add('******************************************************', 1, 'Y');
4218: END IF;
4219:
4220: -- Standard call to check for call compatibility.
4221: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4222: p_api_version_number,
4223: l_api_name,
4224: G_PKG_NAME) THEN
6623: --
6624: -- End of API body
6625: --
6626:
6627: -- Standard check for p_commit
6628:
6629: IF FND_API.to_Boolean( p_commit ) THEN
6630: COMMIT WORK;
6631: END IF;
6631: END IF;
6632:
6633:
6634:
6635: -- Standard call to get message count and if count is 1, get message info.
6636:
6637: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
6638: p_data => x_msg_data );
6639:
7156: From aso_quote_headers_all
7157: Where quote_header_id = p_quote_header_id;
7158:
7159: CURSOR c_pay_term_acct(p_cust_account_id IN Number) IS
7160: SELECT hcp.standard_terms
7161: FROM hz_cust_accounts hca,hz_customer_profiles hcp
7162: WHERE hca.cust_account_id = p_cust_account_id
7163: AND hcp.cust_account_id = hca.cust_account_id
7164: AND nvl(hcp.status,'A') = 'A';
7214:
7215: /*** End : Code change done for Bug 13926015 ***/
7216:
7217: BEGIN
7218: -- Standard Start of API savepoint
7219: SAVEPOINT UPDATE_quote_PVT;
7220:
7221: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7222: aso_debug_pub.add('******************************************************', 1, 'Y');
7223: aso_debug_pub.add('Begin Update_Quote Procedure', 1, 'Y');
7224: aso_debug_pub.add('******************************************************', 1, 'Y');
7225: END IF;
7226:
7227: -- Standard call to check for call compatibility.
7228: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
7229: p_api_version_number,
7230: l_api_name,
7231: G_PKG_NAME) THEN
11585:
11586: -- Change END
11587:
11588:
11589: -- Standard check for p_commit
11590: IF FND_API.to_Boolean( p_commit ) THEN
11591: COMMIT WORK;
11592: END IF;
11593:
11590: IF FND_API.to_Boolean( p_commit ) THEN
11591: COMMIT WORK;
11592: END IF;
11593:
11594: -- Standard call to get message count and if count is 1, get message info.
11595: FND_MSG_PUB.Count_And_Get
11596: ( p_count => x_msg_count,
11597: p_data => x_msg_data
11598: );
11660: CURSOR c_qte_line(l_d_qte_line NUMBER) IS
11661: SELECT quote_line_id FROM ASO_QUOTE_LINES_ALL
11662: where quote_line_id= l_qte_line_rec.quote_line_id;
11663: BEGIN
11664: -- Standard Start of API savepoint
11665: SAVEPOINT DELETE_quote_PVT;
11666:
11667: -- Standard call to check for call compatibility.
11668: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
11663: BEGIN
11664: -- Standard Start of API savepoint
11665: SAVEPOINT DELETE_quote_PVT;
11666:
11667: -- Standard call to check for call compatibility.
11668: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
11669: p_api_version_number,
11670: l_api_name,
11671: G_PKG_NAME)
11782: --
11783: -- End of API body
11784: --
11785:
11786: -- Standard check for p_commit
11787: IF FND_API.to_Boolean( p_commit )
11788: THEN
11789: COMMIT WORK;
11790: END IF;
11789: COMMIT WORK;
11790: END IF;
11791:
11792:
11793: -- Standard call to get message count and if count is 1, get message info.
11794: FND_MSG_PUB.Count_And_Get
11795: ( p_count => x_msg_count,
11796: p_data => x_msg_data
11797: );
12031: l_Copy_Quote_Control_Rec ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
12032: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec;
12033:
12034: BEGIN
12035: -- Standard Start of API savepoint
12036: SAVEPOINT COPY_QUOTE_PVT;
12037:
12038: -- Standard call to check for call compatibility.
12039: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
12034: BEGIN
12035: -- Standard Start of API savepoint
12036: SAVEPOINT COPY_QUOTE_PVT;
12037:
12038: -- Standard call to check for call compatibility.
12039: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
12040: p_api_version_number,
12041: l_api_name,
12042: G_PKG_NAME) THEN
12336: --
12337: -- End of API body
12338: --
12339: */ -- original cpy_qte
12340: -- Standard check for p_commit
12341: IF FND_API.to_Boolean( p_commit )
12342: THEN
12343: COMMIT WORK;
12344: END IF;
12344: END IF;
12345:
12346:
12347:
12348: -- Standard call to get message count and if count is 1, get message info.
12349: FND_MSG_PUB.Count_And_Get
12350: ( p_count => x_msg_count,
12351: p_data => x_msg_data
12352: );
12912: -- Local scratch record
12913: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
12914: l_crit_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
12915: BEGIN
12916: -- Standard Start of API savepoint
12917: SAVEPOINT GET_QUOTE_PVT;
12918:
12919: -- Standard call to check for call compatibility.
12920: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
12915: BEGIN
12916: -- Standard Start of API savepoint
12917: SAVEPOINT GET_QUOTE_PVT;
12918:
12919: -- Standard call to check for call compatibility.
12920: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
12921: p_api_version_number,
12922: l_api_name,
12923: G_PKG_NAME)
13057: --
13058:
13059:
13060:
13061: -- Standard call to get message count and if count is 1, get message info.
13062: FND_MSG_PUB.Count_And_Get
13063: ( p_count => x_msg_count,
13064: p_data => x_msg_data
13065: );
13756: AND role.delete_flag = 'N';
13757:
13758: BEGIN
13759:
13760: -- Standard call to check for call compatibility.
13761: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
13762: p_api_version_number,
13763: l_api_name,
13764: G_PKG_NAME)
13827: aso_debug_pub.add('Quote_Security_Check(): End: Security_Flag: '||X_Security_Flag, 1, 'Y');
13828: END IF;
13829:
13830:
13831: -- Standard call to get message count and if count is 1, get message info.
13832: FND_MSG_PUB.Count_And_Get
13833: ( p_count => x_msg_count,
13834: p_data => x_msg_data
13835: );