[Home] [Help]
10: IS
11: l_Header_Price_Att_Tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
12:
13: --
14: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
15: --
16: BEGIN
17: Query_Rows
18: ( p_order_price_attrib_id => p_order_price_attrib_id
174:
175:
176:
177: --
178: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
179: --
180: BEGIN
181:
182: IF
392: l_index NUMBER := 0;
393: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
394: l_dep_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
395: --
396: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
397: --
398: BEGIN
399:
400: -- Load out record
1596: IS
1597: l_Header_Price_Att_Rec OE_Order_PUB.Header_Price_Att_Rec_Type := p_x_Header_Price_Att_Rec;
1598:
1599: --
1600: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1601: --
1602: BEGIN
1603:
1604: IF l_Header_Price_Att_Rec.override_flag = FND_API.G_MISS_CHAR THEN
2139: IS
2140: l_Header_Price_Att_Rec OE_Order_PUB.Header_Price_Att_Rec_Type := p_x_Header_Price_Att_Rec;
2141:
2142: --
2143: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2144: --
2145: BEGIN
2146: IF l_Header_Price_Att_Rec.override_flag = FND_API.G_MISS_CHAR THEN
2147: l_Header_Price_Att_Rec.override_flag := NULL;
2684: l_booked_flag Varchar2(1) := 'N';
2685: l_Return_Status Varchar2(1);
2686: l_pricing_event Varchar2(30);
2687: --
2688: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2689: --
2690: --bug 2702382 begin
2691: l_price_adj_id1 number;
2692: l_tmp_price_flag boolean := FALSE;
2723: opa.list_line_type_code = 'PRG';
2724: exception
2725: when no_data_found then
2726: --indicates not a free goods adjustment, so delete it
2727: oe_debug_pub.add('in free goods line no data found');
2728: delete from oe_price_adjustments where
2729: price_adjustment_id = l_prc_adj_id;
2730: when others then
2731: null;
2737: RETURN FALSE;
2738: end if;
2739: exception
2740: when others then
2741: --oe_debug_pub.add('in no data found - apply attribute change');
2742: RETURN FALSE;
2743: end;
2744: --bug 2702382 end
2745: BEGIN
3416: and updated_flag = 'Y';
3417: l_price_flag := delete_price_adj(l_price_adj_id1,l_lst_type_code);
3418: exception
3419: when others then
3420: oe_debug_pub.add('in no data found - apply attribute change');
3421: null;
3422: end;
3423: else
3424: begin
3440:
3441: If l_price_flag Then
3442:
3443: IF l_debug_level > 0 THEN
3444: oe_debug_pub.add( 'LOGGING DELAYED REQUEST FOR PRICING FROM OE_HEADER_PATTR_UTIL.APPLY_ATTRIBUTE_CHANGES ' , 1 ) ;
3445: END IF;
3446: --2442012
3447: /* OE_delayed_requests_Pvt.log_request(
3448: p_entity_code => OE_GLOBALS.G_ENTITY_HEader_Price_Att,
3530: , p_Header_id NUMBER := FND_API.G_MISS_NUM
3531: )
3532: IS
3533: --
3534: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3535: --
3536: BEGIN
3537: IF p_Header_id <> FND_API.G_MISS_NUM Then
3538:
3565: IS
3566: l_lock_control NUMBER := 1;
3567:
3568: --
3569: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3570: --
3571: BEGIN
3572:
3573: IF l_debug_level > 0 THEN
3570: --
3571: BEGIN
3572:
3573: IF l_debug_level > 0 THEN
3574: oe_debug_pub.add( 'ENTERING OE_HEADER_PATT_UTIL.INSERT_ROW' , 1 ) ;
3575: END IF;
3576:
3577: INSERT INTO OE_ORDER_PRICE_ATTRIBS
3578: ( HEADER_ID
3844:
3845: p_Header_Price_Att_rec.lock_control := l_lock_control;
3846:
3847: IF l_debug_level > 0 THEN
3848: oe_debug_pub.add( 'EXITING OE_HEADER_PATT_UTIL.INSERT_ROW' , 1 ) ;
3849: END IF;
3850:
3851: EXCEPTION
3852:
3870: IS
3871: l_lock_control NUMBER;
3872:
3873: --
3874: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3875: --
3876: BEGIN
3877:
3878: IF l_debug_level > 0 THEN
3875: --
3876: BEGIN
3877:
3878: IF l_debug_level > 0 THEN
3879: oe_debug_pub.add( 'ENTERING OE_HEADER_PATT_UTIL.UPDATE_ROW' , 1 ) ;
3880: END IF;
3881:
3882: -- increment lock_control by 1 whenever record is updated
3883: SELECT lock_control
4024:
4025: p_Header_Price_Att_rec.lock_control := l_lock_control;
4026:
4027: IF l_debug_level > 0 THEN
4028: oe_debug_pub.add( 'EXITING OE_HEADER_PATT_UTIL.UPDATE_ROW' , 1 ) ;
4029: END IF;
4030:
4031: EXCEPTION
4032:
4058: l_order_price_attrib_id NUMBER;
4059: l_lock_control NUMBER;
4060:
4061: --
4062: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4063: --
4064: BEGIN
4065:
4066: IF l_debug_level > 0 THEN
4063: --
4064: BEGIN
4065:
4066: IF l_debug_level > 0 THEN
4067: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.LOCK_ROW.' , 1 ) ;
4068: END IF;
4069: SAVEPOINT Lock_Row;
4070:
4071: l_lock_control := NULL;
4089: );
4090:
4091:
4092: IF l_debug_level > 0 THEN
4093: oe_debug_pub.add( 'QUERIED LOCK_CONTROL: '|| P_X_HEADER_PRICE_ATT_REC.LOCK_CONTROL , 1 ) ;
4094: END IF;
4095:
4096: -- If lock_control is not passed(is null or missing), then return the locked record.
4097:
4112: -- Row locked. If the whole record is passed, then
4113: -- Compare lock_control.
4114:
4115: IF l_debug_level > 0 THEN
4116: oe_debug_pub.add( 'COMPARE ' , 1 ) ;
4117: END IF;
4118:
4119: IF OE_GLOBALS.Equal(p_x_Header_Price_Att_rec.lock_control,
4120: l_lock_control)
4122:
4123: -- Row has not changed. Set out parameter.
4124:
4125: IF l_debug_level > 0 THEN
4126: oe_debug_pub.add( 'LOCKED ROW' , 1 ) ;
4127: END IF;
4128:
4129: -- Set return status
4130:
4134: ELSE
4135:
4136: -- Row has changed by another user.
4137: IF l_debug_level > 0 THEN
4138: oe_debug_pub.add( 'ROW CHANGED BY OTHER USER' , 1 ) ;
4139: END IF;
4140:
4141: x_return_status := FND_API.G_RET_STS_ERROR;
4142: p_x_Header_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4217: l_order_price_attrib_id NUMBER;
4218: l_lock_control NUMBER;
4219:
4220: --
4221: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4222: --
4223: BEGIN
4224:
4225: IF l_debug_level > 0 THEN
4222: --
4223: BEGIN
4224:
4225: IF l_debug_level > 0 THEN
4226: oe_debug_pub.add( 'ENTERING OE_HEADER_PATTR_UTIL.LOCK_ROWS.' , 1 ) ;
4227: END IF;
4228:
4229: IF (p_order_price_attrib_id IS NOT NULL AND
4230: p_order_price_attrib_id <> FND_API.G_MISS_NUM) AND
4311: );
4312: END IF;
4313:
4314: IF l_debug_level > 0 THEN
4315: oe_debug_pub.add( 'EXITING OE_HEADER_PATTR_UTIL.LOCK_ROWS.' , 1 ) ;
4316: END IF;
4317:
4318:
4319: END lock_rows;