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.8.12010000.5 2008/11/15 10:58:25 sgoli ship $ */
3:
4: -- 4020312
5: g_sel_rec_tbl OE_GLOBALS.Selected_Record_Tbl;

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

1541: nextpos Integer;
1542:
1543: CURSOR c1 IS SELECT x.id1, x.org_id, l.header_id, l.arrival_set_id,
1544: l.ship_set_id, l.top_model_line_id
1545: FROM TABLE(OE_MASS_CHANGE_PVT.get_sel_rec_tbl) x,
1546: oe_order_lines_all l
1547: WHERE l.line_id = x.id1
1548: ORDER BY l.header_id,
1549: nvl(l.arrival_set_id, -1),

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

1556:
1557:
1558: BEGIN
1559: IF l_debug_level > 0 THEN
1560: oe_debug_pub.add('Entering OE_MASS_CHANGE_PVT.Process_Line_Scalar');
1561: END IF;
1562:
1563: p_error_count := l_error_count;
1564:

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

1608: --Will be creating new savepoint only if the header has changed
1609: --This savepoint will used to rollback changes done to the whole order, in case of pricing error
1610: IF l_header_changed
1611: THEN
1612: OE_MASS_CHANGE_PVT.G_PRICING_ERROR := 'N';
1613: SAVEPOINT Pricing_Header_Savepoint;
1614: END IF;
1615:
1616: SAVEPOINT Process_Line_Scalar;

Line 2919: IF OE_MASS_CHANGE_PVT.G_PRICING_ERROR = 'Y'

2915: ROLLBACK TO SAVEPOINT Process_Line_Scalar;
2916:
2917: --Bug 7566697
2918: OE_Globals.G_PRICING_RECURSION := 'N';
2919: IF OE_MASS_CHANGE_PVT.G_PRICING_ERROR = 'Y'
2920: THEN
2921: oe_debug_pub.add('Pricing error has occured. Rolling back changes done to all lines');
2922: ROLLBACK TO SAVEPOINT Pricing_Header_Savepoint;
2923: END IF;

Line 2976: IF OE_MASS_CHANGE_PVT.G_PRICING_ERROR = 'Y'

2972: ROLLBACK TO SAVEPOINT Process_Line_Scalar;
2973:
2974: --Bug 7566697
2975: OE_Globals.G_PRICING_RECURSION := 'N';
2976: IF OE_MASS_CHANGE_PVT.G_PRICING_ERROR = 'Y'
2977: THEN
2978: oe_debug_pub.add('Pricing error has occured. Rolling back changes done to all lines');
2979: ROLLBACK TO SAVEPOINT Pricing_Header_Savepoint;
2980: END IF;

Line 3038: IF OE_MASS_CHANGE_PVT.G_PRICING_ERROR = 'Y'

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

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

3062: G_HEADER_CHANGED :=NULL ; -- - bug 6850537,7210480
3063: IS_MASS_CHANGE := 'F'; --Added for bug 4911340
3064:
3065: IF l_debug_level > 0 THEN
3066: oe_debug_pub.add('Exiting OE_MASS_CHANGE_PVT.Process_Line_Scalar');
3067: END IF;
3068: end Process_Line_Scalar;
3069:
3070: Procedure MC_Rollback

Line 3211: end OE_MASS_CHANGE_PVT;

3207: END LOOP;
3208: RETURN;
3209: END get_sel_rec_tbl;
3210:
3211: end OE_MASS_CHANGE_PVT;