DBA Data[Home] [Help]

APPS.OE_BULK_TAX_UTIL dependencies on OE_SYS_PARAMETERS

Line 51: l_invoice_source := oe_sys_parameters.value('INVOICE_SOURCE', p_org_id);

47: IF l_debug_level > 0 THEN
48: oe_debug_pub.add( 'INVOICE SOURCE ID IS ( 3 ) : '||L_INVOICE_SOURCE_ID , 5 ) ;
49: END IF;
50: ELSE
51: l_invoice_source := oe_sys_parameters.value('INVOICE_SOURCE', p_org_id);
52:
53: IF (l_invoice_source IS NOT NULL) THEN
54: SELECT batch_source_id
55: INTO l_invoice_source_id

Line 67: l_cust_trx_type_id := oe_sys_parameters.value('OE_INVOICE_TRANSACTION_TYPE_ID',p_org_id);

63: END IF;
64: END IF;
65:
66: IF l_cust_trx_type_id IS NULL THEN
67: l_cust_trx_type_id := oe_sys_parameters.value('OE_INVOICE_TRANSACTION_TYPE_ID',p_org_id);
68: IF l_debug_level > 0 THEN
69: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM sys parameter : '||L_CUST_TRX_TYPE_ID , 5 ) ;
70: END IF;
71: END IF;

Line 299: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params(OE_GLOBALS.G_ORG_ID);

295: THEN
296: BEGIN
297: IF oe_code_control.code_release_level >= '110510' THEN
298:
299: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params(OE_GLOBALS.G_ORG_ID);
300: l_sob_id := l_AR_Sys_Param_Rec.set_of_books_id;
301:
302: SELECT 'VALID'
303: INTO l_dummy

Line 558: --l_AR_Sys_Param_Rec := OE_SYS_PARAMETERS_PVT.Get_AR_Sys_Params;

554: oe_debug_pub.add( 'tax method: ' || l_tax_method || ' vendor installed: ' || l_vendor_installed);
555: END IF;
556:
557:
558: --l_AR_Sys_Param_Rec := OE_SYS_PARAMETERS_PVT.Get_AR_Sys_Params;
559:
560:
561: --Loop over the loaded lines to calculate the tax
562: l_index := 1;

Line 683: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index));

679:
680: l_currency_code := OE_Bulk_Order_PVT.G_HEADER_REC.transactional_curr_code(l_header_index);
681: l_header_org_id := OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index);
682: l_conversion_rate := OE_Bulk_Order_PVT.G_HEADER_REC.conversion_rate(l_header_index);
683: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index));
684:
685:
686: select c.minimum_accountable_unit,
687: c.precision

Line 693: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params;

689: l_precision
690: from fnd_currencies c
691: where c.currency_code = l_currency_code;
692:
693: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params;
694:
695: --code changes made for bug 1883552 begin
696: l_commitment_id := nvl(OE_Bulk_Order_PVT.G_LINE_REC.commitment_id(l_index),0);
697: if l_commitment_id <> 0 then