APPS.ASO_SERVICE_CONTRACTS_INT dependencies on FND_PROFILE

Line 78: decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',nvl(END_CUSTOMER_CUST_ACCOUNT_ID,cust_account_id),cust_account_id)

74:
75: /*** Start: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
76: CURSOR C_cust_id (Quote_hd_id NUMBER)IS
77: SELECT cust_account_id,
78: decode(nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N'),'Y',nvl(END_CUSTOMER_CUST_ACCOUNT_ID,cust_account_id),cust_account_id)
79: hd_end_cust_account_id
80: FROM aso_quote_headers_all
81: WHERE quote_header_id= Quote_hd_id;
82:

Line 107: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

103: BEGIN
104: -- Standard Start of API savepoint
105: SAVEPOINT GET_SERVICE_ATTRIBUTES_PVT;
106:
107: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
108:
109: -- Standard call to check for call compatibility.
110: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
111: p_api_version_number,

Line 273: if fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST') ='Y' then

269: END IF;
270: CLOSE C_cs_item;
271:
272: /*** Start: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
273: if fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST') ='Y' then
274:
275: OPEN C_get_cust_line (P_Qte_Line_rec.quote_line_id);
276: FETCH C_get_cust_line INTO ln_end_cust_account_id;
277:

Line 381: if fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST') ='Y' then

377: aso_debug_pub.add('SUN ER Get Service Attr: PRODUCT_CATALOG service ref line id'||P_Qte_Line_rec.quote_LINE_ID, 1, 'Y');
378:
379: END IF;
380: -- Checking for end customer depending on profile 8647883
381: if fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST') ='Y' then
382:
383: OPEN C_get_cust_line (P_Qte_Line_rec.quote_line_id);
384: FETCH C_get_cust_line INTO ln_end_cust_account_id;
385:

Line 526: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

522: BEGIN
523: -- Standard Start of API savepoint
524: SAVEPOINT GET_DURATION_PUB;
525:
526: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
527:
528: -- Standard call to check for call compatibility.
529: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
530: p_api_version_number,

Line 690: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

686: BEGIN
687: -- Standard Start of API savepoint
688: SAVEPOINT IS_SERVICE_AVAILABLE_PUB;
689:
690: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
691:
692: -- Standard call to check for call compatibility.
693: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
694: p_api_version_number,

Line 876: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

872: BEGIN
873: -- Standard Start of API savepoint
874: SAVEPOINT AVAILABLE_SERVICES_PUB;
875:
876: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
877:
878: -- Standard call to check for call compatibility.
879: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
880: p_api_version_number,

Line 1074: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

1070: BEGIN
1071: -- Standard Start of API savepoint
1072: SAVEPOINT GET_WARRANTY_PUB;
1073:
1074: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1075:
1076: -- Standard call to check for call compatibility.
1077: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1078: p_api_version_number,