APPS.JL_ZZ_RECEIV_INTERFACE dependencies on OE_PROFILE

Line 129: l_so_organization_id:= to_number(oe_profile.value('SO_ORGANIZATION_ID'));

125:
126: l_tax_method := JL_ZZ_AR_TX_LIB_PKG.get_tax_method(l_org_id);
127: OE_DEBUG_PUB.ADD('JL-Tax Method is ' || l_tax_method);
128:
129: l_so_organization_id:= to_number(oe_profile.value('SO_ORGANIZATION_ID'));
130: OE_DEBUG_PUB.ADD('JL-So Organization id is ' || l_so_organization_id);
131:
132: IF l_country_code = 'BR' THEN
133: l_header_attr_category := 'JL.BR.ARXTWMAI.Additional Info';

Line 434: to_number(oe_profile.value('SO_ORGANIZATION_ID'));

430:
431: ELSIF l_order_line_id IS NOT NULL THEN
432:
433: l_so_organization_id :=
434: to_number(oe_profile.value('SO_ORGANIZATION_ID'));
435:
436: BEGIN
437: SELECT ol.global_attribute1 op_fiscal_code,
438: msi.global_attribute3 item_origin,

Line 878: to_number(oe_profile.value('SO_ORGANIZATION_ID'));

874:
875: ELSIF l_order_line_id IS NOT NULL THEN
876:
877: l_so_organization_id :=
878: to_number(oe_profile.value('SO_ORGANIZATION_ID'));
879:
880: BEGIN
881: SELECT ol.global_attribute1 op_fiscal_code,
882: msi.global_attribute3 item_origin,

Line 1001: l_so_organization_id:= to_number(oe_profile.value('SO_ORGANIZATION_ID'));

997: l_gdf_cat := l_jl||'.'||l_country_code||'.OEXOEORD.LINES';
998:
999: l_tax_method := JL_ZZ_AR_TX_LIB_PKG.get_tax_method(l_org_id);
1000:
1001: l_so_organization_id:= to_number(oe_profile.value('SO_ORGANIZATION_ID'));
1002:
1003: --
1004: -- Bug#4929759- use ship_from_org_id for Colombia
1005: -- replace WHERE mtl.organization_id = l_so_organization_id