APPS.OE_ORDER_IMPORT_MAIN_PVT dependencies on OE_PAYMENTS_IFACE_ALL

Line 51: tabname => 'OE_PAYMENTS_IFACE_ALL');

47: tabname => 'OE_CREDITS_IFACE_ALL');
48: FND_STATS.Gather_Table_Stats(ownname => 'ONT',
49: tabname => 'OE_LOTSERIALS_IFACE_ALL');
50: FND_STATS.Gather_Table_Stats(ownname => 'ONT',
51: tabname => 'OE_PAYMENTS_IFACE_ALL');
52:
53: IF l_debug_level > 0 THEN
54: oe_debug_pub.add( 'AFTER CALLING PERF STATISTICS API' ) ;
55: END IF;

Line 656: UPDATE oe_payments_iface_all

652:
653: COMMIT;
654:
655:
656: UPDATE oe_payments_iface_all
657: SET request_id = l_request_id
658: WHERE (order_source_id, orig_sys_document_ref,
659: 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
660: ( SELECT order_source_id, orig_sys_document_ref,

Line 860: UPDATE oe_payments_iface_all /* Bug #3419970 */

856: 'N', ' '); */ -- Bug 5205691
857:
858: COMMIT;
859:
860: UPDATE oe_payments_iface_all /* Bug #3419970 */
861: SET request_id = l_request_id,
862: sold_to_org_id = nvl(sold_to_org_id, l_sold_to_org_id),
863: sold_to_org = nvl(sold_to_org, l_sold_to_org),
864: org_id = l_org_id