DBA Data[Home] [Help]

APPS.OE_ORDER_IMPORT_MAIN_PVT dependencies on OE_PRICE_ATTS_IFACE_ALL

Line 677: UPDATE oe_price_atts_iface_all

673:
674: COMMIT;
675:
676: /* Added for #1433292 */
677: UPDATE oe_price_atts_iface_all
678: SET request_id = l_request_id
679: WHERE (order_source_id, orig_sys_document_ref,
680: nvl(sold_to_org_id, FND_API.G_MISS_NUM), nvl(sold_to_org, FND_API.G_MISS_CHAR), nvl(change_sequence, FND_API.G_MISS_CHAR),nvl(org_id,nvl(p_default_org_id,FND_API.G_MISS_NUM))) IN
681: ( SELECT order_source_id, orig_sys_document_ref,

Line 876: UPDATE oe_price_atts_iface_all

872: 'N', ' '); */ -- Bug 5205691
873:
874: COMMIT;
875:
876: UPDATE oe_price_atts_iface_all
877: SET request_id = l_request_id,
878: sold_to_org_id = nvl(sold_to_org_id, l_sold_to_org_id),
879: sold_to_org = nvl(sold_to_org, l_sold_to_org),
880: org_id = l_org_id