APPS.OM_TAX_UTIL dependencies on OE_SYS_PARAMETERS

Line 269: IF p_entity_id_tbl(i).requesting_entity_code = OE_GLOBALS.G_ENTITY_HEADER AND (NVL(oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y') THEN

265: k :=1;
266: p :=1;
267: FOR i IN 1..p_entity_id_tbl.count
268: LOOP
269: IF p_entity_id_tbl(i).requesting_entity_code = OE_GLOBALS.G_ENTITY_HEADER AND (NVL(oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y') THEN
270: /* getting header record */
271: l_header_rec := OE_Header_UTIL.Query_Row(p_header_id=> p_entity_id_tbl(i).entity_id );
272: l_level := 'H' ;
273: elsif p_entity_id_tbl(i).requesting_entity_code = OE_GLOBALS.G_ENTITY_LINE THEN

Line 282: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',l_header_rec.org_id);

278: END IF;
279: l_currency_code := l_header_rec.transactional_curr_code;
280: l_header_org_id := l_header_rec.org_id;
281: l_conversion_rate := l_header_rec.conversion_rate;
282: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',l_header_rec.org_id);
283: SELECT c.minimum_accountable_unit,
284: c.precision
285: INTO l_minimum_accountable_unit,
286: l_precision

Line 289: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params;

285: INTO l_minimum_accountable_unit,
286: l_precision
287: FROM fnd_currencies c
288: WHERE c.currency_code = l_currency_code;
289: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params;
290: --8431420
291: IF OE_ORDER_UTIL.G_Precision IS NULL THEN
292: Is_fmt := OE_ORDER_UTIL.Get_Precision(p_header_id=> l_header_rec.header_id);
293: IF OE_ORDER_UTIL.G_Precision IS NULL THEN

Line 1473: IF (NVL(oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y') THEN

1469: k := k+1;
1470: p :=p +1;
1471: END IF;
1472:
1473: IF (NVL(oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y') THEN
1474: l_charge_tbl :=get_charge_details(l_line_rec.header_id, l_line_rec.line_id);
1475: FOR j IN 1..l_charge_tbl.count
1476: LOOP
1477: -- Initialising zx_global_structures_pkg.init_trx_line_dist_tbl for line charges

Line 2097: if ( NVL (oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y' ) then -- added if for bug#12333456

2093: l_entity_id_tbl(i).requesting_entity_code := OE_GLOBALS.G_ENTITY_LINE; --TaxER
2094: END LOOP;
2095:
2096: --Bug#12311063
2097: if ( NVL (oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y' ) then -- added if for bug#12333456
2098: j:= l_entity_id_tbl.Count + 1;
2099: l_entity_id_tbl(j).request_ind := j;
2100: l_entity_id_tbl(j).entity_id := p_header_id;
2101: l_entity_id_tbl(j).requesting_entity_code := OE_GLOBALS.G_ENTITY_HEADER; --TaxER

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

2467: IF l_debug_level > 0 THEN
2468: oe_debug_pub.add( 'INVOICE SOURCE ID IS ( 3 ) : '||L_INVOICE_SOURCE_ID , 5 ) ;
2469: END IF;
2470: ELSE
2471: l_invoice_source := oe_sys_parameters.value('INVOICE_SOURCE', p_org_id);
2472:
2473: IF (l_invoice_source IS NOT NULL) THEN
2474: SELECT batch_source_id
2475: INTO l_invoice_source_id

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

2483: END IF;
2484: END IF;
2485:
2486: IF l_cust_trx_type_id IS NULL THEN
2487: l_cust_trx_type_id := oe_sys_parameters.value('OE_INVOICE_TRANSACTION_TYPE_ID',p_org_id);
2488: IF l_debug_level > 0 THEN
2489: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM sys parameter : '||L_CUST_TRX_TYPE_ID , 5 ) ;
2490: END IF;
2491: END IF;