APPS.ASO_OPP_QTE_PUB dependencies on STANDARD

Line 259: SELECT hcp.standard_terms

255: FROM oe_agreements
256: WHERE agreement_id = p_agreement_id;
257:
258: CURSOR c_pay_term_acct(p_cust_account_id IN Number) IS
259: SELECT hcp.standard_terms
260: FROM hz_cust_accounts hca,hz_customer_profiles hcp
261: WHERE hca.cust_account_id = p_cust_account_id
262: AND hcp.cust_account_id = hca.cust_account_id
263: AND nvl(hcp.status,'A') = 'A';

Line 307: -- Standard Start of API savepoint

303: l_add_line varchar2(1);
304:
305: BEGIN
306:
307: -- Standard Start of API savepoint
308: SAVEPOINT Create_Qte_Opportunity_pub;
309:
310: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
311:

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

312: IF aso_debug_pub.g_debug_flag = 'Y' THEN
313: aso_debug_pub.add('****** Start of Create_Qte_Opportunity API ******', 1, 'Y');
314: END IF;
315:
316: -- Standard call to check for call compatibility.
317: IF NOT FND_API.Compatible_API_Call(
318: L_API_VERSION,
319: P_API_VERSION_NUMBER,
320: L_API_NAME,

Line 1509: -- Standard check of p_commit.

1505: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1506: aso_debug_pub.add('****** End of Create_Qte_Opportunity API ******', 1, 'Y');
1507: END IF;
1508:
1509: -- Standard check of p_commit.
1510: IF FND_API.To_Boolean(p_commit) THEN
1511: COMMIT WORK;
1512: END IF;
1513:

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

1510: IF FND_API.To_Boolean(p_commit) THEN
1511: COMMIT WORK;
1512: END IF;
1513:
1514: -- Standard call to get message count and if count is 1, get message info.
1515: FND_Msg_Pub.Count_And_Get(
1516: p_encoded => FND_API.G_FALSE,
1517: p_count => x_msg_count ,
1518: p_data => x_msg_data