APPS.OE_INF_POPULATE_PUB dependencies on OE_HEADERS_IFACE_ALL

Line 70: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_HEADERS_IFACE_ALL' ) ;

66:
67: IF old_header_id_v is not null THEN
68:
69: IF l_debug_level > 0 THEN
70: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_HEADERS_IFACE_ALL' ) ;
71: END IF;
72:
73: INSERT INTO oe_headers_iface_all (
74: order_source_id

Line 73: INSERT INTO oe_headers_iface_all (

69: IF l_debug_level > 0 THEN
70: oe_debug_pub.add( 'OEXPIFPB: BEFORE INSERT TO OE_HEADERS_IFACE_ALL' ) ;
71: END IF;
72:
73: INSERT INTO oe_headers_iface_all (
74: order_source_id
75: ,orig_sys_document_ref
76: ,change_sequence
77: ,order_source

Line 517: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_HEADERS_IFACE_ALL' ) ;

513: where order_number = order_number_v;
514:
515: IF SQL%ROWCOUNT > 0 THEN
516: IF l_debug_level > 0 THEN
517: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_HEADERS_IFACE_ALL' ) ;
518: END IF;
519: ELSE
520: IF l_debug_level > 0 THEN
521: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_HEADERS_IFACE_ALL' ) ;

Line 521: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_HEADERS_IFACE_ALL' ) ;

517: oe_debug_pub.add( 'OEXPIFPB: AFTER SUCCESSFUL INSERT TO OE_HEADERS_IFACE_ALL' ) ;
518: END IF;
519: ELSE
520: IF l_debug_level > 0 THEN
521: oe_debug_pub.add( 'OEXPIFPB: AFTER UN-SUCCESSFUL INSERT TO OE_HEADERS_IFACE_ALL' ) ;
522: END IF;
523: return;
524: END IF;
525: