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 576: IF ( NVL (oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y' ) THEN

572: oe_debug_pub.add( 'line_index for line'||OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID(i) ||' :'|| i);
573: Entity_info_tbl(l_index).trx_level_type := 'LINE';
574: Entity_info_tbl(l_index).charge_amt := NULL;
575: l_index := l_index+1;
576: IF ( NVL (oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y' ) THEN
577:
578: l_charge_tbl := om_tax_util.get_charge_details(p_header_id =>OE_Bulk_Order_PVT.G_LINE_REC.header_id(i) , p_line_id =>OE_Bulk_Order_PVT.G_LINE_REC.line_id(i));
579: IF l_charge_tbl.Count > 0 THEN
580: oe_debug_pub.add( 'Entering Values for line charges in entity info table');

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

594: l_index := l_index+1;
595: END LOOP;
596: END IF;
597: END LOOP;
598: IF ( NVL (oe_sys_parameters.value('OE_INVOICE_FREIGHT_AS_LINE',l_org_id), 'N') = 'Y' ) THEN
599: FOR i IN 1.. OE_Bulk_Order_PVT.G_HEADER_REC.HEADER_ID.COUNT
600: LOOP
601: l_charge_tbl := om_tax_util.get_charge_details(p_header_id =>OE_Bulk_Order_PVT.G_HEADER_REC.HEADER_ID(i) , p_line_id =>NULL);
602: IF l_charge_tbl.Count > 0 THEN

Line 662: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params;

658: p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index) );
659: l_remaining_lines := OE_Bulk_Order_PVT.G_HEADER_REC.end_line_index(l_header_index) - l_index;
660: l_index_inc := l_remaining_lines + 1;
661: ELSE
662: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params;
663: BEGIN
664: SELECT location_id
665: INTO l_bill_from_location_id
666: FROM HR_ALL_ORGANIZATION_UNITS

Line 758: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));

754: END IF;
755: l_header_org_id := OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index);
756: l_currency_code := OE_Bulk_Order_PVT.G_HEADER_REC.transactional_curr_code(Entity_info_tbl(i).header_index);
757: l_conversion_rate := OE_Bulk_Order_PVT.G_HEADER_REC.conversion_rate(Entity_info_tbl(i).header_index);
758: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
759: SELECT c.minimum_accountable_unit,
760: c.precision
761: INTO l_minimum_accountable_unit,
762: l_precision

Line 924: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));

920: END IF;
921: l_header_org_id := OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index);
922: l_currency_code := OE_Bulk_Order_PVT.G_HEADER_REC.transactional_curr_code(Entity_info_tbl(i).header_index);
923: l_conversion_rate := OE_Bulk_Order_PVT.G_HEADER_REC.conversion_rate(Entity_info_tbl(i).header_index);
924: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
925: SELECT c.minimum_accountable_unit,
926: c.precision
927: INTO l_minimum_accountable_unit,
928: l_precision

Line 1077: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));

1073: END;
1074: l_header_org_id := OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index);
1075: l_currency_code := OE_Bulk_Order_PVT.G_HEADER_REC.transactional_curr_code(Entity_info_tbl(i).header_index);
1076: l_conversion_rate := OE_Bulk_Order_PVT.G_HEADER_REC.conversion_rate(Entity_info_tbl(i).header_index);
1077: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(Entity_info_tbl(i).header_index));
1078: SELECT c.minimum_accountable_unit,
1079: c.precision
1080: INTO l_minimum_accountable_unit,
1081: l_precision