DBA Data[Home] [Help]

APPS.ASO_MAP_QUOTE_ORDER_INT dependencies on FND_PROFILE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2550: l_party_type VARCHAR2(30);
2551: l_site_use_id number;
2552: begin
2553:
2554: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2555:
2556: x_return_status := FND_API.G_RET_STS_SUCCESS;
2557:
2558: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

4324: pay_count NUMBER := 1;
4325: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4326: l_line_tbl OE_Order_PUB.Line_Tbl_Type := x_Line_tbl;
4327: l_om_defaulting_prof VARCHAR2(2)
4328: := NVL(FND_PROFILE.Value('ASO_OM_DEFAULTING'), 'N');
4329: Begin
4330: FOR i in 1..P_Line_Payment_Tbl.count LOOP
4331:
4332: IF P_Line_Payment_Tbl(i).qte_line_index = p_qte_line_index THEN