APPS.OM_TAX_UTIL dependencies on OE_GLOBALS

Line 3: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT;

1: PACKAGE BODY om_tax_util AS
2: /* $Header: OEXUTAXB.pls 120.32 2011/05/31 10:58:42 jmedaven ship $ */
3: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT;
4: G_DEBUG_BYPASS_TAX CONSTANT VARCHAR2(1):=nvl(Fnd_Profile.value('OE_DBG_BYPASS'),'N');
5: -- structure for caching loc_ship_bill_info
6: TYPE loc_ship_bill_info_rec IS RECORD (
7: site_use_id HZ_CUST_SITE_USES_ALL.site_use_id%TYPE,

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 273: elsif p_entity_id_tbl(i).requesting_entity_code = OE_GLOBALS.G_ENTITY_LINE THEN

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
274: /* getting header record and line record*/
275: l_line_rec := OE_line_UTIL.Query_Row(p_line_id=> p_entity_id_tbl(i).entity_id );
276: l_header_rec:= OE_Header_UTIL.Query_Row(p_header_id=> l_line_rec.header_id );
277: l_level := 'L';

Line 544: IF NOT (OE_GLOBALS.Equal(l_salesrep_id, G_SALESREP_ID) AND OE_Globals.Equal(l_header_org_id, G_SALESREP_POA_ID)) THEN

540: NULL;
541: END;
542: END IF;
543: IF l_salesrep_id IS NOT NULL THEN
544: IF NOT (OE_GLOBALS.Equal(l_salesrep_id, G_SALESREP_ID) AND OE_Globals.Equal(l_header_org_id, G_SALESREP_POA_ID)) THEN
545: -- fetch and cache salerep info
546: BEGIN
547: G_SALESREP_ID := l_salesrep_id;
548: G_SALESREP_POA_ID := l_header_org_id;

Line 2093: l_entity_id_tbl(i).requesting_entity_code := OE_GLOBALS.G_ENTITY_LINE; --TaxER

2089:
2090: FOR i in 1..l_num_tbl.count LOOP
2091: l_entity_id_tbl(i).request_ind := i;
2092: l_entity_id_tbl(i).entity_id := l_num_tbl(i);
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

Line 2101: l_entity_id_tbl(j).requesting_entity_code := OE_GLOBALS.G_ENTITY_HEADER; --TaxER

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
2102: end if;
2103: --Bug#12311063
2104:
2105: