[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,
3542: , p_Header_id NUMBER := FND_API.G_MISS_NUM
3543: )
3544: IS
3545: --
3546: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3547: --
3548: BEGIN
3549: IF p_Header_id <> FND_API.G_MISS_NUM Then
3550:
3577: IS
3578: l_lock_control NUMBER := 1;
3579:
3580: --
3581: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3582: --
3583: BEGIN
3584:
3585: IF l_debug_level > 0 THEN
3582: --
3583: BEGIN
3584:
3585: IF l_debug_level > 0 THEN
3586: oe_debug_pub.add( 'ENTERING OE_HEADER_PATT_UTIL.INSERT_ROW' , 1 ) ;
3587: END IF;
3588:
3589: INSERT INTO OE_ORDER_PRICE_ATTRIBS
3590: ( HEADER_ID
3856:
3857: p_Header_Price_Att_rec.lock_control := l_lock_control;
3858:
3859: IF l_debug_level > 0 THEN
3860: oe_debug_pub.add( 'EXITING OE_HEADER_PATT_UTIL.INSERT_ROW' , 1 ) ;
3861: END IF;
3862:
3863: EXCEPTION
3864:
3882: IS
3883: l_lock_control NUMBER;
3884:
3885: --
3886: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3887: --
3888: BEGIN
3889:
3890: IF l_debug_level > 0 THEN
3887: --
3888: BEGIN
3889:
3890: IF l_debug_level > 0 THEN
3891: oe_debug_pub.add( 'ENTERING OE_HEADER_PATT_UTIL.UPDATE_ROW' , 1 ) ;
3892: END IF;
3893:
3894: -- increment lock_control by 1 whenever record is updated
3895: SELECT lock_control
4036:
4037: p_Header_Price_Att_rec.lock_control := l_lock_control;
4038:
4039: IF l_debug_level > 0 THEN
4040: oe_debug_pub.add( 'EXITING OE_HEADER_PATT_UTIL.UPDATE_ROW' , 1 ) ;
4041: END IF;
4042:
4043: EXCEPTION
4044:
4070: l_order_price_attrib_id NUMBER;
4071: l_lock_control NUMBER;
4072:
4073: --
4074: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4075: --
4076: BEGIN
4077:
4078: IF l_debug_level > 0 THEN
4075: --
4076: BEGIN
4077:
4078: IF l_debug_level > 0 THEN
4079: oe_debug_pub.add( 'ENTERING OE_LINE_ADJ_UTIL.LOCK_ROW.' , 1 ) ;
4080: END IF;
4081: SAVEPOINT Lock_Row;
4082:
4083: l_lock_control := NULL;
4101: );
4102:
4103:
4104: IF l_debug_level > 0 THEN
4105: oe_debug_pub.add( 'QUERIED LOCK_CONTROL: '|| P_X_HEADER_PRICE_ATT_REC.LOCK_CONTROL , 1 ) ;
4106: END IF;
4107:
4108: -- If lock_control is not passed(is null or missing), then return the locked record.
4109:
4124: -- Row locked. If the whole record is passed, then
4125: -- Compare lock_control.
4126:
4127: IF l_debug_level > 0 THEN
4128: oe_debug_pub.add( 'COMPARE ' , 1 ) ;
4129: END IF;
4130:
4131: IF OE_GLOBALS.Equal(p_x_Header_Price_Att_rec.lock_control,
4132: l_lock_control)
4134:
4135: -- Row has not changed. Set out parameter.
4136:
4137: IF l_debug_level > 0 THEN
4138: oe_debug_pub.add( 'LOCKED ROW' , 1 ) ;
4139: END IF;
4140:
4141: -- Set return status
4142:
4146: ELSE
4147:
4148: -- Row has changed by another user.
4149: IF l_debug_level > 0 THEN
4150: oe_debug_pub.add( 'ROW CHANGED BY OTHER USER' , 1 ) ;
4151: END IF;
4152:
4153: x_return_status := FND_API.G_RET_STS_ERROR;
4154: p_x_Header_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4229: l_order_price_attrib_id NUMBER;
4230: l_lock_control NUMBER;
4231:
4232: --
4233: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4234: --
4235: BEGIN
4236:
4237: IF l_debug_level > 0 THEN
4234: --
4235: BEGIN
4236:
4237: IF l_debug_level > 0 THEN
4238: oe_debug_pub.add( 'ENTERING OE_HEADER_PATTR_UTIL.LOCK_ROWS.' , 1 ) ;
4239: END IF;
4240:
4241: IF (p_order_price_attrib_id IS NOT NULL AND
4242: p_order_price_attrib_id <> FND_API.G_MISS_NUM) AND
4323: );
4324: END IF;
4325:
4326: IF l_debug_level > 0 THEN
4327: oe_debug_pub.add( 'EXITING OE_HEADER_PATTR_UTIL.LOCK_ROWS.' , 1 ) ;
4328: END IF;
4329:
4330:
4331: END lock_rows;