[Home] [Help]
1: PACKAGE BODY OE_CHG_ORDER_PVT AS
2: /* $Header: OEXVCHGB.pls 120.9.12020000.3 2013/01/17 08:43:10 sujithku ship $ */
3:
4: -- Start of Comments
5: -- API name OE_CHG_ORDER_PVT
1: PACKAGE BODY OE_CHG_ORDER_PVT AS
2: /* $Header: OEXVCHGB.pls 120.9.12020000.3 2013/01/17 08:43:10 sujithku ship $ */
3:
4: -- Start of Comments
5: -- API name OE_CHG_ORDER_PVT
6: -- Type PRIVATE
7: -- Function
8: --
9: -- Pre-reqs
136:
137: /* wf_engine.SetItemAttrText(l_chgord_item_type
138: , l_wf_item_key
139: , 'BOOKING_DOCUMENT'
140: , 'PLSQL:OE_CHG_ORDER_PVT.Generate_PLSQLDoc/' || l_wf_item_key);
141: */
142: wf_engine.SetItemAttrText(l_chgord_item_type
143: , l_wf_item_key
144: , 'USER_TEXT'
151: ,'RESOLVING_ROLE'
152: ,p_resolving_name);
153:
154: -- Retrieve the value of the order number from the global variable
155: l_order_number := OE_CHG_ORDER_PVT.G_ORDER_NUMBER;
156: oe_msg_pub.add('Order Number is: ' || l_order_number);
157:
158: -- Set the order number context for the message header
159:
229: --
230: BEGIN
231:
232: -- Set The global variable to the user text entered in the UI
233: OE_CHG_ORDER_PVT.G_USER_TEXT := p_user_text;
234:
235: EXCEPTION
236: WHEN OTHERS THEN
237: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
255: --
256: BEGIN
257:
258: -- Set The global variable to the user text entered in the UI
259: OE_CHG_ORDER_PVT.G_ORDER_NUMBER := p_order_number;
260:
261: EXCEPTION
262:
263: WHEN OTHERS THEN
305: IF l_debug_level > 0 THEN
306: oe_debug_pub.add( 'USER TEXT IS: ' || L_USER_TEXT ) ;
307: END IF;
308:
309: -- p_document := OE_CHG_ORDER_PVT.G_USER_TEXT;
310: p_document := l_user_text;
311: IF l_debug_level > 0 THEN
312: oe_debug_pub.add( 'VALUE OF THE P_DOCUMENT IS: '|| P_DOCUMENT ) ;
313: END IF;
2518: OE_GLOBALS.OE_AUDIT_HISTORY_TBL.delete;
2519: OE_DEBUG_PUB.add('Reason Required Flag has been reset to N',1);
2520: END Reset_Audit_History_Flags;
2521:
2522: END OE_CHG_ORDER_PVT;