APPS.OE_ORDER_IMPORT_MAIN_PVT dependencies on OE_PRICE_ADJS_IFACE_ALL

Line 43: tabname => 'OE_PRICE_ADJS_IFACE_ALL');

39: tabname => 'OE_LINES_IFACE_ALL');
40: FND_STATS.Gather_Table_Stats(ownname => 'ONT',
41: tabname => 'OE_ACTIONS_IFACE_ALL');
42: FND_STATS.Gather_Table_Stats(ownname => 'ONT',
43: tabname => 'OE_PRICE_ADJS_IFACE_ALL');
44: FND_STATS.Gather_Table_Stats(ownname => 'ONT',
45: tabname => 'OE_RESERVTNS_IFACE_ALL');
46: FND_STATS.Gather_Table_Stats(ownname => 'ONT',
47: tabname => 'OE_CREDITS_IFACE_ALL');

Line 639: UPDATE oe_price_adjs_iface_all

635: END IF;
636:
637: COMMIT;
638:
639: UPDATE oe_price_adjs_iface_all
640: SET request_id = l_request_id
641: WHERE (order_source_id, orig_sys_document_ref,
642: 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
643: ( SELECT order_source_id, orig_sys_document_ref,

Line 843: UPDATE oe_price_adjs_iface_all

839:
840:
841: COMMIT;
842:
843: UPDATE oe_price_adjs_iface_all
844: SET request_id = l_request_id,
845: sold_to_org_id = nvl(sold_to_org_id, l_sold_to_org_id),
846: sold_to_org = nvl(sold_to_org, l_sold_to_org),
847: org_id = l_org_id