APPS.OE_DEALS_UTIL dependencies on FND_PROFILE

Line 140: l_db_link := FND_PROFILE.VALUE('QPR_PN_DBLINK') ;

136: l_quote_origin NUMBER := 660;
137: l_dynamicSqlString VARCHAR2(2000);
138: BEGIN
139:
140: l_db_link := FND_PROFILE.VALUE('QPR_PN_DBLINK') ;
141:
142: IF l_db_link IS NOT NULL
143: THEN
144: l_db_link := '@' || l_db_link;

Line 193: l_instance_id := FND_PROFILE.VALUE('QPR_CURRENT_INSTANCE') ;

189: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
190:
191: BEGIN
192:
193: l_instance_id := FND_PROFILE.VALUE('QPR_CURRENT_INSTANCE') ;
194: --If Instance ID is NULL, QPR API will fail so DONT call.
195: IF l_instance_id is NULL THEN
196: FND_MESSAGE.SET_NAME('ONT','OE_PROFILE_INCORRECT');
197: FND_MESSAGE.SET_TOKEN('PROFILE_NAME', 'QPR_CURRENT_INSTANCE');

Line 206: l_db_link := FND_PROFILE.VALUE('QPR_PN_DBLINK') ;

202:
203: IF l_debug_level > 0 THEN
204: oe_debug_pub.add( 'CALL DEAL API' || l_procedure ) ;
205: END IF;
206: l_db_link := FND_PROFILE.VALUE('QPR_PN_DBLINK') ;
207:
208: IF l_db_link is NOT NULL THEN
209: l_db_link := '@' || l_db_link;
210: END IF;

Line 312: l_instance_id := FND_PROFILE.VALUE('QPR_CURRENT_INSTANCE') ;

308: oe_order_headers_all where header_id= l_header_id;
309:
310: L_ORDER_NUMBER := nvl(L_ORDER_NUMBER, L_QUOTE_NUMBER);
311:
312: l_instance_id := FND_PROFILE.VALUE('QPR_CURRENT_INSTANCE') ;
313: --If Instance ID is NULL, QPR API will fail so DONT call.
314: IF l_instance_id is NULL THEN
315: FND_MESSAGE.SET_NAME('ONT','OE_PROFILE_INCORRECT');
316: FND_MESSAGE.SET_TOKEN('PROFILE_NAME', 'QPR_CURRENT_INSTANCE');

Line 929: l_list_line_profile := FND_PROFILE.VALUE('QPR_DEAL_DIFF_MODIFIER') ;

925: x_return_status := FND_API.G_RET_STS_SUCCESS;
926: x_msg_count := NULL ;
927: x_msg_data := NULL ;
928:
929: l_list_line_profile := FND_PROFILE.VALUE('QPR_DEAL_DIFF_MODIFIER') ;
930: l_list_line_id := to_number(l_list_line_profile);
931: l_db_link := FND_PROFILE.VALUE('QPR_PN_DBLINK') ;
932:
933: IF l_db_link is NOT NULL THEN

Line 931: l_db_link := FND_PROFILE.VALUE('QPR_PN_DBLINK') ;

927: x_msg_data := NULL ;
928:
929: l_list_line_profile := FND_PROFILE.VALUE('QPR_DEAL_DIFF_MODIFIER') ;
930: l_list_line_id := to_number(l_list_line_profile);
931: l_db_link := FND_PROFILE.VALUE('QPR_PN_DBLINK') ;
932:
933: IF l_db_link is NOT NULL THEN
934: l_db_link := '@' || l_db_link;
935: END IF;

Line 1136: l_db_link := FND_PROFILE.VALUE('QPR_PN_DBLINK') ;

1132: END IF;
1133: x_deal_id := NULL;
1134: x_deal_status := NULL;
1135:
1136: l_db_link := FND_PROFILE.VALUE('QPR_PN_DBLINK') ;
1137:
1138: IF l_db_link is NOT NULL THEN
1139: l_db_link := '@' || l_db_link;
1140: END IF;