APPS.JL_ZZ_RECEIV_INTERFACE dependencies on OE_PROFILE

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

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

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

416:
417: ELSIF l_order_line_id IS NOT NULL THEN
418:
419: l_so_organization_id :=
420: to_number(oe_profile.value('SO_ORGANIZATION_ID'));
421:
422: BEGIN
423: SELECT ol.global_attribute1 op_fiscal_code,
424: msi.global_attribute3 item_origin,

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

848:
849: ELSIF l_order_line_id IS NOT NULL THEN
850:
851: l_so_organization_id :=
852: to_number(oe_profile.value('SO_ORGANIZATION_ID'));
853:
854: BEGIN
855: SELECT ol.global_attribute1 op_fiscal_code,
856: msi.global_attribute3 item_origin,

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

971: l_gdf_cat := l_jl||'.'||l_country_code||'.OEXOEORD.LINES';
972:
973: l_tax_method := JL_ZZ_AR_TX_LIB_PKG.get_tax_method(l_org_id);
974:
975: l_so_organization_id:= to_number(oe_profile.value('SO_ORGANIZATION_ID'));
976:
977: --
978: -- Bug#4929759- use ship_from_org_id for Colombia
979: -- replace WHERE mtl.organization_id = l_so_organization_id