APPS.OE_MASS_CHANGE_PVT dependencies on OE_MASS_CHANGE_PVT

Line 1: PACKAGE BODY OE_MASS_CHANGE_PVT AS

1: PACKAGE BODY OE_MASS_CHANGE_PVT AS
2: /* $Header: OEXVMSCB.pls 120.18.12020000.2 2013/01/07 13:31:03 sujithku ship $ */
3:
4: -- 4020312
5: g_sel_rec_tbl OE_GLOBALS.Selected_Record_Tbl;

Line 1553: FROM TABLE(OE_MASS_CHANGE_PVT.get_sel_rec_tbl) x,

1549: nextpos Integer;
1550:
1551: CURSOR c1 IS SELECT x.id1, x.org_id, l.header_id, l.arrival_set_id,
1552: l.ship_set_id, l.top_model_line_id
1553: FROM TABLE(OE_MASS_CHANGE_PVT.get_sel_rec_tbl) x,
1554: oe_order_lines_all l
1555: WHERE l.line_id = x.id1
1556: ORDER BY l.header_id,
1557: nvl(l.arrival_set_id, -1),

Line 1568: oe_debug_pub.add('Entering OE_MASS_CHANGE_PVT.Process_Line_Scalar');

1564:
1565:
1566: BEGIN
1567: IF l_debug_level > 0 THEN
1568: oe_debug_pub.add('Entering OE_MASS_CHANGE_PVT.Process_Line_Scalar');
1569: END IF;
1570:
1571: p_error_count := l_error_count;
1572:

Line 1620: OE_MASS_CHANGE_PVT.G_PRICING_ERROR := 'N';

1616: --Will be creating new savepoint only if the header has changed
1617: --This savepoint will used to rollback changes done to the whole order, in case of pricing error
1618: IF l_header_changed
1619: THEN
1620: OE_MASS_CHANGE_PVT.G_PRICING_ERROR := 'N';
1621: SAVEPOINT Pricing_Header_Savepoint;
1622: END IF;
1623:
1624: SAVEPOINT Process_Line_Scalar;

Line 3035: IF OE_MASS_CHANGE_PVT.G_PRICING_ERROR = 'Y'

3031: ROLLBACK TO SAVEPOINT Process_Line_Scalar;
3032:
3033: --Bug 7566697
3034: OE_Globals.G_PRICING_RECURSION := 'N';
3035: IF OE_MASS_CHANGE_PVT.G_PRICING_ERROR = 'Y'
3036: THEN
3037: oe_debug_pub.add('Pricing error has occured. Rolling back changes done to all lines');
3038: ROLLBACK TO SAVEPOINT Pricing_Header_Savepoint;
3039: END IF;

Line 3092: IF OE_MASS_CHANGE_PVT.G_PRICING_ERROR = 'Y'

3088: ROLLBACK TO SAVEPOINT Process_Line_Scalar;
3089:
3090: --Bug 7566697
3091: OE_Globals.G_PRICING_RECURSION := 'N';
3092: IF OE_MASS_CHANGE_PVT.G_PRICING_ERROR = 'Y'
3093: THEN
3094: oe_debug_pub.add('Pricing error has occured. Rolling back changes done to all lines');
3095: ROLLBACK TO SAVEPOINT Pricing_Header_Savepoint;
3096: END IF;

Line 3154: IF OE_MASS_CHANGE_PVT.G_PRICING_ERROR = 'Y'

3150: ROLLBACK TO SAVEPOINT Process_Line_Scalar;
3151:
3152: --Bug 7566697
3153: OE_Globals.G_PRICING_RECURSION := 'N';
3154: IF OE_MASS_CHANGE_PVT.G_PRICING_ERROR = 'Y'
3155: THEN
3156: oe_debug_pub.add('Pricing error has occured. Rolling back changes done to all lines');
3157: ROLLBACK TO SAVEPOINT Pricing_Header_Savepoint;
3158: END IF;

Line 3182: oe_debug_pub.add('Exiting OE_MASS_CHANGE_PVT.Process_Line_Scalar');

3178: G_HEADER_CHANGED :=NULL ; -- - bug 6850537,7210480
3179: IS_MASS_CHANGE := 'F'; --Added for bug 4911340
3180:
3181: IF l_debug_level > 0 THEN
3182: oe_debug_pub.add('Exiting OE_MASS_CHANGE_PVT.Process_Line_Scalar');
3183: END IF;
3184: end Process_Line_Scalar;
3185:
3186: Procedure MC_Rollback

Line 3327: end OE_MASS_CHANGE_PVT;

3323: END LOOP;
3324: RETURN;
3325: END get_sel_rec_tbl;
3326:
3327: end OE_MASS_CHANGE_PVT;