DBA Data[Home] [Help]

APPS.IBU_ORDER_CAPTURE dependencies on FND_PROFILE

Line 164: l_qte_header_rec.order_type_id := FND_PROFILE.VALUE_WNPS('ASO_ORDER_TYPE_ID'); --1436

160: l_qte_header_rec.party_id := HEADER_REC.PARTY_ID;
161: l_qte_header_rec.cust_account_id := HEADER_REC.CUST_ACCOUNT_ID;
162: l_qte_header_rec.org_contact_id := HEADER_REC.ORG_CONTACT_ID;
163: l_qte_header_rec.invoice_to_party_site_id := HEADER_REC.INVOICE_TO_PARTY_SITE_ID;
164: l_qte_header_rec.order_type_id := FND_PROFILE.VALUE_WNPS('ASO_ORDER_TYPE_ID'); --1436
165: l_qte_header_rec.quote_category_code := 'RETURN';
166: l_qte_header_rec.ordered_date := sysdate;
167: l_qte_header_rec.price_list_id := l_pricelist_id;
168: l_qte_header_rec.currency_code := l_transaction_curr_code;

Line 179: if FND_PROFILE.VALUE_WNPS('ASO_DEFAULT_PERSON_ID') is not NULL then

175: FETCH Get_order_salesrep_id into l_salesrep_id;
176: CLOSE Get_order_salesrep_id ;
177:
178: if l_salesrep_id is NULL or l_salesrep_id = FND_API.G_MISS_NUM then
179: if FND_PROFILE.VALUE_WNPS('ASO_DEFAULT_PERSON_ID') is not NULL then
180: OPEN Get_person_id ( FND_PROFILE.VALUE_WNPS('ASO_DEFAULT_PERSON_ID'));
181: FETCH Get_person_id into l_person_id;
182: CLOSE Get_person_id ;
183: end if;

Line 180: OPEN Get_person_id ( FND_PROFILE.VALUE_WNPS('ASO_DEFAULT_PERSON_ID'));

176: CLOSE Get_order_salesrep_id ;
177:
178: if l_salesrep_id is NULL or l_salesrep_id = FND_API.G_MISS_NUM then
179: if FND_PROFILE.VALUE_WNPS('ASO_DEFAULT_PERSON_ID') is not NULL then
180: OPEN Get_person_id ( FND_PROFILE.VALUE_WNPS('ASO_DEFAULT_PERSON_ID'));
181: FETCH Get_person_id into l_person_id;
182: CLOSE Get_person_id ;
183: end if;
184: else

Line 394: --l_qte_line_tbl (i).order_line_type_id := FND_PROFILE.VALUE_WNPS('IBU_ORDER_LINE_TYPE_ID');

390: l_qte_line_tbl (i).operation_code := 'CREATE';
391: l_qte_line_tbl (i).org_id := l_line_org_id;
392: l_qte_line_tbl (i).line_category_code := 'RETURN';
393:
394: --l_qte_line_tbl (i).order_line_type_id := FND_PROFILE.VALUE_WNPS('IBU_ORDER_LINE_TYPE_ID');
395: l_qte_line_tbl (i).invoice_to_party_site_id := LINE_TBL(i).INVOICE_TO_PARTY_SITE_ID;
396: l_qte_line_tbl (i).inventory_item_id := l_inventory_item_id;
397: l_qte_line_tbl (i).quantity := LINE_TBL(i).QUANTITY;
398: l_qte_line_tbl (i).uom_code := l_ordered_quantity_uom;

Line 626: l_booked_profile_value := FND_PROFILE.VALUE_WNPS('ASO_DEFAULT_ORDER_STATE');

622: aso_debug_pub.add ('IBU: ship_to_pty_site_id = ' || l_line_shipment_tbl (i).ship_to_party_site_id , 1, 'Y');
623:
624: end loop;
625: end if;
626: l_booked_profile_value := FND_PROFILE.VALUE_WNPS('ASO_DEFAULT_ORDER_STATE');
627: if ( l_booked_profile_value = 'BOOKED' ) then
628: l_control_rec.book_flag := FND_API.G_TRUE;
629: else
630: l_control_rec.book_flag := FND_API.G_FALSE;

Line 755: to_number(NVL(FND_PROFILE.Value('LANGUAGE'), '0')));

751: l_message_num := NULL;
752: IF l_id is not NULL
753: THEN
754: OPEN Get_Message_Num (l_message_name, l_id,
755: to_number(NVL(FND_PROFILE.Value('LANGUAGE'), '0')));
756: FETCH Get_Message_Num into l_message_num;
757: CLOSE Get_Message_Num;
758: END IF;
759: