APPS.OE_INVOICE_PUB dependencies on OE_INVOICE_PUB

Line 1: PACKAGE BODY OE_Invoice_PUB AS

1: PACKAGE BODY OE_Invoice_PUB AS
2: /* $Header: OEXPINVB.pls 120.77.12020000.8 2013/04/12 05:36:44 sujithku ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Invoice_PUB';

2: /* $Header: OEXPINVB.pls 120.77.12020000.8 2013/04/12 05:36:44 sujithku ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Invoice_PUB';
7: G_ITEMTYPE VARCHAR2(8);
8:
9: --bug5336639 start
10: G_CURRENT_LINE_ID NUMBER := null;

Line 194: oe_debug_pub.add('entering oe_invoice_pub . update_service_dates() '

190: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
191: BEGIN
192:
193: IF l_debug_level > 0 THEN
194: oe_debug_pub.add('entering oe_invoice_pub . update_service_dates() '
195: ||' p_line_rec.line_id = ' || P_LINE_REC.LINE_ID
196: ||' p_line_rec.service_start_date = '||TO_CHAR(P_LINE_REC.SERVICE_START_DATE, 'YYYY/MM/DD' )
197: ||' p_line_rec.service_end_date = '|| TO_CHAR ( P_LINE_REC.SERVICE_END_DATE , 'YYYY/MM/DD' )
198: ) ;

Line 236: oe_debug_pub.add('exiting oe_invoice_pub . update_service_dates() '

232: --13724397 Start
233: x_return_status :=l_return_status;
234: --13724397 End
235: IF l_debug_level > 0 THEN
236: oe_debug_pub.add('exiting oe_invoice_pub . update_service_dates() '
237: ||' p_line_rec.line_id = ' || P_LINE_REC.LINE_ID
238: ||' p_line_rec.service_start_date = '||TO_CHAR(P_LINE_REC.SERVICE_START_DATE, 'YYYY/MM/DD' )
239: ||' p_line_rec.service_end_date = '|| TO_CHAR ( P_LINE_REC.SERVICE_END_DATE , 'YYYY/MM/DD' )
240: ) ;

Line 7830: SERVICE_START_DATE = p_line_rec.SERVICE_START_DATE, --bug# 7231974 :- as srvc_dates are derived in OE_INVOICE_PUB, they should be updated in OM tables as well

7826: UPDATE OE_ORDER_LINES_ALL
7827: SET INVOICE_INTERFACE_STATUS_CODE = p_invoice_interface_status,
7828: INVOICED_QUANTITY = l_invoiced_quantity,
7829: FLOW_STATUS_CODE = l_flow_status_code,
7830: SERVICE_START_DATE = p_line_rec.SERVICE_START_DATE, --bug# 7231974 :- as srvc_dates are derived in OE_INVOICE_PUB, they should be updated in OM tables as well
7831: SERVICE_END_DATE = p_line_rec.SERVICE_END_DATE, --bug # 7231974
7832: --9040537 CREDIT_INVOICE_LINE_ID = p_line_rec.CREDIT_INVOICE_LINE_ID, --8319535
7833: CALCULATE_PRICE_FLAG = 'N',
7834: LOCK_CONTROL = LOCK_CONTROL + 1

Line 10572: END OE_Invoice_PUB;

10568: END;
10569: -- BUG# 7431368 : Performance fix : End
10570:
10571:
10572: END OE_Invoice_PUB;