DBA Data[Home] [Help]

APPS.ASO_MAP_QUOTE_ORDER_INT dependencies on FND_PROFILE

Line 204: --:= to_number(FND_PROFILE.value('OE_SET_OF_BOOKS_ID'));

200: -- currency conversion
201:
202: l_set_of_books_id NUMBER
203: := oe_profile.value('OE_SET_OF_BOOKS_ID', p_qte_rec.org_id);
204: --:= to_number(FND_PROFILE.value('OE_SET_OF_BOOKS_ID'));
205: l_conversion_type VARCHAR2(30)
206: := FND_PROFILE.Value('ASO_QUOTE_CONVERSION_TYPE');
207: l_conversion_rate NUMBER;
208:

Line 206: := FND_PROFILE.Value('ASO_QUOTE_CONVERSION_TYPE');

202: l_set_of_books_id NUMBER
203: := oe_profile.value('OE_SET_OF_BOOKS_ID', p_qte_rec.org_id);
204: --:= to_number(FND_PROFILE.value('OE_SET_OF_BOOKS_ID'));
205: l_conversion_type VARCHAR2(30)
206: := FND_PROFILE.Value('ASO_QUOTE_CONVERSION_TYPE');
207: l_conversion_rate NUMBER;
208:
209: l_om_defaulting_prof VARCHAR2(2)
210: := NVL(FND_PROFILE.Value('ASO_OM_DEFAULTING'), 'N');

Line 210: := NVL(FND_PROFILE.Value('ASO_OM_DEFAULTING'), 'N');

206: := FND_PROFILE.Value('ASO_QUOTE_CONVERSION_TYPE');
207: l_conversion_rate NUMBER;
208:
209: l_om_defaulting_prof VARCHAR2(2)
210: := NVL(FND_PROFILE.Value('ASO_OM_DEFAULTING'), 'N');
211: l_validate_salesrep_prof VARCHAR2(2)
212: := FND_PROFILE.VALUE('ASO_VALIDATE_SALESREP');
213: l_ret_reason_code_prof VARCHAR2(200)
214: := FND_PROFILE.value('ASO_RET_REASON_CODE');

Line 212: := FND_PROFILE.VALUE('ASO_VALIDATE_SALESREP');

208:
209: l_om_defaulting_prof VARCHAR2(2)
210: := NVL(FND_PROFILE.Value('ASO_OM_DEFAULTING'), 'N');
211: l_validate_salesrep_prof VARCHAR2(2)
212: := FND_PROFILE.VALUE('ASO_VALIDATE_SALESREP');
213: l_ret_reason_code_prof VARCHAR2(200)
214: := FND_PROFILE.value('ASO_RET_REASON_CODE');
215:
216: -- Change START

Line 214: := FND_PROFILE.value('ASO_RET_REASON_CODE');

210: := NVL(FND_PROFILE.Value('ASO_OM_DEFAULTING'), 'N');
211: l_validate_salesrep_prof VARCHAR2(2)
212: := FND_PROFILE.VALUE('ASO_VALIDATE_SALESREP');
213: l_ret_reason_code_prof VARCHAR2(200)
214: := FND_PROFILE.value('ASO_RET_REASON_CODE');
215:
216: -- Change START
217: -- Release 12 MOAC Changes : Bug 4500739
218: -- Changes Done by : Girish

Line 221: -- l_default_person_id_prof VARCHAR2(300) := FND_PROFILE.Value('ASO_DEFAULT_PERSON_ID');

217: -- Release 12 MOAC Changes : Bug 4500739
218: -- Changes Done by : Girish
219: -- Comments : Using HR EIT in place of org striped profile
220:
221: -- l_default_person_id_prof VARCHAR2(300) := FND_PROFILE.Value('ASO_DEFAULT_PERSON_ID');
222: l_default_person_id_prof VARCHAR2(300) := ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_SALESREP);
223:
224: -- Change END
225:

Line 228: := FND_PROFILE.Value('ASO_RESERVATION_LEVEL');

224: -- Change END
225:
226:
227: l_reservation_lvl_prof VARCHAR2(80)
228: := FND_PROFILE.Value('ASO_RESERVATION_LEVEL');
229:
230: l_sysdate DATE := sysdate;
231: l_functional_currency VARCHAR2(15);
232:

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

2606: l_party_type VARCHAR2(30);
2607: l_site_use_id number;
2608: begin
2609:
2610: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2611:
2612: x_return_status := FND_API.G_RET_STS_SUCCESS;
2613:
2614: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 4407: := NVL(FND_PROFILE.Value('ASO_OM_DEFAULTING'), 'N');

4403: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4404: --bug8775480
4405: --l_line_tbl OE_Order_PUB.Line_Tbl_Type := x_Line_tbl;
4406: l_om_defaulting_prof VARCHAR2(2)
4407: := NVL(FND_PROFILE.Value('ASO_OM_DEFAULTING'), 'N');
4408: Begin
4409: FOR i in 1..P_Line_Payment_Tbl.count LOOP
4410:
4411: IF P_Line_Payment_Tbl(i).qte_line_index = p_qte_line_index THEN