eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_LINE_ADJ_UTIL dependencies on OE_ORDER_PUB

Line 11: Procedure Process_Cancelled_Lines(p_x_new_line_rec In Oe_Order_Pub.line_rec_type, p_ordered_quantity In Number);

7:
8:
9: Type pbh_tbl_type Is Table Of Number Index by Binary_Integer;
10:
11: Procedure Process_Cancelled_Lines(p_x_new_line_rec In Oe_Order_Pub.line_rec_type, p_ordered_quantity In Number);
12: --bug7491829 added p_ordered_quantity
13:
14: Procedure Log_Pricing_Requests (p_x_new_line_rec in out nocopy Oe_Order_Pub.Line_Rec_Type,
15: p_old_line_rec in Oe_Order_Pub.Line_Rec_Type,

Line 14: Procedure Log_Pricing_Requests (p_x_new_line_rec in out nocopy Oe_Order_Pub.Line_Rec_Type,

10:
11: Procedure Process_Cancelled_Lines(p_x_new_line_rec In Oe_Order_Pub.line_rec_type, p_ordered_quantity In Number);
12: --bug7491829 added p_ordered_quantity
13:
14: Procedure Log_Pricing_Requests (p_x_new_line_rec in out nocopy Oe_Order_Pub.Line_Rec_Type,
15: p_old_line_rec in Oe_Order_Pub.Line_Rec_Type,
16: p_no_price_flag Boolean Default False,
17: p_price_flag Varchar2 Default 'Y');
18:

Line 15: p_old_line_rec in Oe_Order_Pub.Line_Rec_Type,

11: Procedure Process_Cancelled_Lines(p_x_new_line_rec In Oe_Order_Pub.line_rec_type, p_ordered_quantity In Number);
12: --bug7491829 added p_ordered_quantity
13:
14: Procedure Log_Pricing_Requests (p_x_new_line_rec in out nocopy Oe_Order_Pub.Line_Rec_Type,
15: p_old_line_rec in Oe_Order_Pub.Line_Rec_Type,
16: p_no_price_flag Boolean Default False,
17: p_price_flag Varchar2 Default 'Y');
18:
19: FUNCTION G_MISS_OE_AK_LINE_ADJ_REC

Line 135: Procedure Append_Association (p_line_adj_tbl in Oe_Order_Pub.line_adj_tbl_type,

131: RETURN l_rowtype_rec;
132:
133: END G_MISS_OE_AK_LINE_ADJ_REC;
134:
135: Procedure Append_Association (p_line_adj_tbl in Oe_Order_Pub.line_adj_tbl_type,
136: px_line_adj_assoc_tbl in out nocopy Oe_Order_Pub.line_adj_assoc_tbl_type,
137: p_pbh_tbl in pbh_tbl_type
138: ) As
139:

Line 136: px_line_adj_assoc_tbl in out nocopy Oe_Order_Pub.line_adj_assoc_tbl_type,

132:
133: END G_MISS_OE_AK_LINE_ADJ_REC;
134:
135: Procedure Append_Association (p_line_adj_tbl in Oe_Order_Pub.line_adj_tbl_type,
136: px_line_adj_assoc_tbl in out nocopy Oe_Order_Pub.line_adj_assoc_tbl_type,
137: p_pbh_tbl in pbh_tbl_type
138: ) As
139:
140: CURSOR l_price_Adj_assoc_csr(p_price_adjustment_id In Number) IS

Line 219: ( p_LINE_ADJ_rec IN OE_Order_PUB.LINE_ADJ_Rec_Type

215: END IF;
216: End;
217:
218: PROCEDURE API_Rec_To_Rowtype_Rec
219: ( p_LINE_ADJ_rec IN OE_Order_PUB.LINE_ADJ_Rec_Type
220: , x_rowtype_rec OUT nocopy OE_AK_LINE_PRCADJS_V%ROWTYPE
221: ) IS
222: BEGIN
223:

Line 338: , x_api_rec IN OUT nocopy OE_Order_PUB.LINE_ADJ_Rec_Type

334:
335:
336: PROCEDURE Rowtype_Rec_To_API_Rec
337: ( p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
338: , x_api_rec IN OUT nocopy OE_Order_PUB.LINE_ADJ_Rec_Type
339: )
340: iS
341:
342: --

Line 1209: , p_x_Line_Adj_rec IN out nocopy OE_Order_PUB.Line_Adj_Rec_Type

1205:
1206:
1207: PROCEDURE Clear_Dependent_Attr
1208: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
1209: , p_x_Line_Adj_rec IN out nocopy OE_Order_PUB.Line_Adj_Rec_Type
1210: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
1211: OE_Order_PUB.G_MISS_LINE_ADJ_REC
1212: )
1213: IS

Line 1210: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=

1206:
1207: PROCEDURE Clear_Dependent_Attr
1208: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
1209: , p_x_Line_Adj_rec IN out nocopy OE_Order_PUB.Line_Adj_Rec_Type
1210: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
1211: OE_Order_PUB.G_MISS_LINE_ADJ_REC
1212: )
1213: IS
1214: l_Line_Adj_rec OE_AK_Line_PRCADJS_V%ROWTYPE;

Line 1211: OE_Order_PUB.G_MISS_LINE_ADJ_REC

1207: PROCEDURE Clear_Dependent_Attr
1208: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
1209: , p_x_Line_Adj_rec IN out nocopy OE_Order_PUB.Line_Adj_Rec_Type
1210: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
1211: OE_Order_PUB.G_MISS_LINE_ADJ_REC
1212: )
1213: IS
1214: l_Line_Adj_rec OE_AK_Line_PRCADJS_V%ROWTYPE;
1215: l_old_Line_Adj_rec OE_AK_Line_PRCADJS_V%ROWTYPE ;

Line 1247: ( p_x_Line_Adj_rec IN out nocopy OE_Order_PUB.Line_Adj_Rec_Type

1243:
1244: -- Procedure Apply_Attribute_Changes
1245:
1246: PROCEDURE Apply_Attribute_Changes
1247: ( p_x_Line_Adj_rec IN out nocopy OE_Order_PUB.Line_Adj_Rec_Type
1248: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
1249: OE_Order_PUB.G_MISS_LINE_ADJ_REC
1250: --, x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type
1251: )

Line 1248: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=

1244: -- Procedure Apply_Attribute_Changes
1245:
1246: PROCEDURE Apply_Attribute_Changes
1247: ( p_x_Line_Adj_rec IN out nocopy OE_Order_PUB.Line_Adj_Rec_Type
1248: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
1249: OE_Order_PUB.G_MISS_LINE_ADJ_REC
1250: --, x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type
1251: )
1252: IS

Line 1249: OE_Order_PUB.G_MISS_LINE_ADJ_REC

1245:
1246: PROCEDURE Apply_Attribute_Changes
1247: ( p_x_Line_Adj_rec IN out nocopy OE_Order_PUB.Line_Adj_Rec_Type
1248: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
1249: OE_Order_PUB.G_MISS_LINE_ADJ_REC
1250: --, x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type
1251: )
1252: IS
1253: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1250: --, x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type

1246: PROCEDURE Apply_Attribute_Changes
1247: ( p_x_Line_Adj_rec IN out nocopy OE_Order_PUB.Line_Adj_Rec_Type
1248: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
1249: OE_Order_PUB.G_MISS_LINE_ADJ_REC
1250: --, x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type
1251: )
1252: IS
1253: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1254: l_price_flag boolean := FALSE;

Line 1265: l_header_rec OE_Order_PUB.Header_Rec_Type;

1261: l_line_category_code VARCHAR2(30);
1262:
1263: --bug#5961160
1264: l_calling_action VARCHAR2(30);
1265: l_header_rec OE_Order_PUB.Header_Rec_Type;
1266: l_rule_defined VARCHAR2(1);
1267: l_credit_check_rule_id NUMBER;
1268: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type ;
1269: --

Line 2042: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

2038:
2039: -- Procedure Complete_Record
2040:
2041: PROCEDURE Complete_Record
2042: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
2043: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
2044: )
2045: IS
2046: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type := p_x_Line_Adj_rec;

Line 2043: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type

2039: -- Procedure Complete_Record
2040:
2041: PROCEDURE Complete_Record
2042: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
2043: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
2044: )
2045: IS
2046: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type := p_x_Line_Adj_rec;
2047: BEGIN

Line 2046: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type := p_x_Line_Adj_rec;

2042: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
2043: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
2044: )
2045: IS
2046: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type := p_x_Line_Adj_rec;
2047: BEGIN
2048:
2049: IF l_Line_Adj_rec.adjusted_amount = FND_API.G_MISS_NUM THEN
2050: l_Line_Adj_rec.adjusted_amount := p_old_Line_Adj_rec.adjusted_amount;

Line 2495: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

2491:
2492: -- Procedure Convert_Miss_To_Null
2493:
2494: PROCEDURE Convert_Miss_To_Null
2495: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
2496: )
2497: IS
2498: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type := p_x_Line_Adj_rec;
2499: --

Line 2498: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type := p_x_Line_Adj_rec;

2494: PROCEDURE Convert_Miss_To_Null
2495: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
2496: )
2497: IS
2498: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type := p_x_Line_Adj_rec;
2499: --
2500: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2501: --
2502: BEGIN

Line 2922: ( p_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

2918:
2919: -- Procedure Update_Row
2920:
2921: PROCEDURE Update_Row
2922: ( p_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
2923: )
2924: IS
2925: l_lock_control NUMBER;
2926: l_index NUMBER;

Line 3135: ( p_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

3131:
3132: -- Procedure Insert_Row
3133:
3134: PROCEDURE Insert_Row
3135: ( p_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
3136: )
3137: IS
3138: l_lock_control NUMBER := 1;
3139: l_index NUMBER;

Line 3465: l_new_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

3461: FROM OE_PRICE_ADJUSTMENTS
3462: WHERE LINE_ID = p_line_id;
3463:
3464: -- added for notification framework
3465: l_new_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3466: l_index NUMBER;
3467:
3468: --
3469: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3631: , x_Line_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

3627: -- Procedure Query_Row
3628:
3629: PROCEDURE Query_Row
3630: ( p_price_adjustment_id IN NUMBER
3631: , x_Line_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
3632: )
3633: IS
3634: l_Line_Adj_Tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3635: BEGIN

Line 3634: l_Line_Adj_Tbl OE_Order_PUB.Line_Adj_Tbl_Type;

3630: ( p_price_adjustment_id IN NUMBER
3631: , x_Line_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
3632: )
3633: IS
3634: l_Line_Adj_Tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3635: BEGIN
3636:
3637: Query_Rows
3638: ( p_price_adjustment_id => p_price_adjustment_id

Line 3656: , x_Line_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type

3652: , p_Header_id IN NUMBER :=
3653: FND_API.G_MISS_NUM
3654: , p_Line_Level_Header_id IN NUMBER :=
3655: FND_API.G_MISS_NUM
3656: , x_Line_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
3657: )
3658: IS
3659: l_count NUMBER;
3660:

Line 4356: , p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

4352:
4353: PROCEDURE Lock_Row
4354: ( x_return_status OUT NOCOPY VARCHAR2
4355:
4356: , p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
4357: -- := OE_Order_PUB.G_MISS_LINE_ADJ_REC
4358: , p_price_adjustment_id IN NUMBER
4359: := FND_API.G_MISS_NUM
4360: -- , x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type

Line 4357: -- := OE_Order_PUB.G_MISS_LINE_ADJ_REC

4353: PROCEDURE Lock_Row
4354: ( x_return_status OUT NOCOPY VARCHAR2
4355:
4356: , p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
4357: -- := OE_Order_PUB.G_MISS_LINE_ADJ_REC
4358: , p_price_adjustment_id IN NUMBER
4359: := FND_API.G_MISS_NUM
4360: -- , x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type
4361: )

Line 4360: -- , x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type

4356: , p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
4357: -- := OE_Order_PUB.G_MISS_LINE_ADJ_REC
4358: , p_price_adjustment_id IN NUMBER
4359: := FND_API.G_MISS_NUM
4360: -- , x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type
4361: )
4362: IS
4363: l_price_adjustment_id NUMBER;
4364: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 4364: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

4360: -- , x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type
4361: )
4362: IS
4363: l_price_adjustment_id NUMBER;
4364: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4365: l_lock_control NUMBER;
4366:
4367: --
4368: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4513: , x_Line_Adj_tbl OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type

4509: ( p_price_adjustment_id IN NUMBER
4510: := FND_API.G_MISS_NUM
4511: , p_line_id IN NUMBER
4512: := FND_API.G_MISS_NUM
4513: , x_Line_Adj_tbl OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
4514: , x_return_status OUT NOCOPY VARCHAR2
4515:
4516: )
4517: IS

Line 4526: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

4522: WHERE line_id = p_line_id
4523: FOR UPDATE NOWAIT;
4524:
4525: l_price_adjustment_id NUMBER;
4526: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4527: l_lock_control NUMBER;
4528:
4529: --
4530: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4631: , p_adj_rec IN OE_order_pub.Line_Adj_Rec_Type

4627:
4628: PROCEDURE Log_Adj_Requests
4629: ( x_return_status OUT NOCOPY VARCHAR2
4630:
4631: , p_adj_rec IN OE_order_pub.Line_Adj_Rec_Type
4632: , p_old_adj_rec IN OE_order_pub.Line_Adj_Rec_Type
4633: , p_delete_flag IN BOOLEAN DEFAULT FALSE
4634: ) IS
4635: BEGIN

Line 4632: , p_old_adj_rec IN OE_order_pub.Line_Adj_Rec_Type

4628: PROCEDURE Log_Adj_Requests
4629: ( x_return_status OUT NOCOPY VARCHAR2
4630:
4631: , p_adj_rec IN OE_order_pub.Line_Adj_Rec_Type
4632: , p_old_adj_rec IN OE_order_pub.Line_Adj_Rec_Type
4633: , p_delete_flag IN BOOLEAN DEFAULT FALSE
4634: ) IS
4635: BEGIN
4636:

Line 4678: ( p_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type

4674:
4675: -- Function Get_Values
4676:
4677: FUNCTION Get_Values
4678: ( p_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
4679: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
4680: OE_Order_PUB.G_MISS_LINE_ADJ_REC
4681: ) RETURN OE_Order_PUB.Line_Adj_Val_Rec_Type
4682: IS

Line 4679: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=

4675: -- Function Get_Values
4676:
4677: FUNCTION Get_Values
4678: ( p_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
4679: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
4680: OE_Order_PUB.G_MISS_LINE_ADJ_REC
4681: ) RETURN OE_Order_PUB.Line_Adj_Val_Rec_Type
4682: IS
4683: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;

Line 4680: OE_Order_PUB.G_MISS_LINE_ADJ_REC

4676:
4677: FUNCTION Get_Values
4678: ( p_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
4679: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
4680: OE_Order_PUB.G_MISS_LINE_ADJ_REC
4681: ) RETURN OE_Order_PUB.Line_Adj_Val_Rec_Type
4682: IS
4683: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
4684: BEGIN

Line 4681: ) RETURN OE_Order_PUB.Line_Adj_Val_Rec_Type

4677: FUNCTION Get_Values
4678: ( p_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
4679: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
4680: OE_Order_PUB.G_MISS_LINE_ADJ_REC
4681: ) RETURN OE_Order_PUB.Line_Adj_Val_Rec_Type
4682: IS
4683: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
4684: BEGIN
4685:

Line 4683: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;

4679: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
4680: OE_Order_PUB.G_MISS_LINE_ADJ_REC
4681: ) RETURN OE_Order_PUB.Line_Adj_Val_Rec_Type
4682: IS
4683: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
4684: BEGIN
4685:
4686: IF (p_Line_Adj_rec.discount_id IS NULL OR
4687: p_Line_Adj_rec.discount_id <> FND_API.G_MISS_NUM) AND

Line 4703: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

4699:
4700: -- Procedure Get_Ids
4701:
4702: PROCEDURE Get_Ids
4703: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
4704: , p_Line_Adj_val_rec IN OE_Order_PUB.Line_Adj_Val_Rec_Type
4705: )
4706: IS
4707: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 4704: , p_Line_Adj_val_rec IN OE_Order_PUB.Line_Adj_Val_Rec_Type

4700: -- Procedure Get_Ids
4701:
4702: PROCEDURE Get_Ids
4703: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
4704: , p_Line_Adj_val_rec IN OE_Order_PUB.Line_Adj_Val_Rec_Type
4705: )
4706: IS
4707: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4708: BEGIN

Line 4707: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

4703: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
4704: , p_Line_Adj_val_rec IN OE_Order_PUB.Line_Adj_Val_Rec_Type
4705: )
4706: IS
4707: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4708: BEGIN
4709:
4710: -- initialize return_status.
4711:

Line 4756: ( p_header_adj_rec IN OE_Order_PUB.Header_adj_rec_type)

4752: END Get_Ids;
4753:
4754: -- This function converts a Header adj record to a Line Adjustment record
4755: Function Convert_Hdr_Adj_To_Line_Adj
4756: ( p_header_adj_rec IN OE_Order_PUB.Header_adj_rec_type)
4757: RETURN OE_Order_PUB.Line_Adj_Rec_Type
4758: IS
4759: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4760: BEGIN

Line 4757: RETURN OE_Order_PUB.Line_Adj_Rec_Type

4753:
4754: -- This function converts a Header adj record to a Line Adjustment record
4755: Function Convert_Hdr_Adj_To_Line_Adj
4756: ( p_header_adj_rec IN OE_Order_PUB.Header_adj_rec_type)
4757: RETURN OE_Order_PUB.Line_Adj_Rec_Type
4758: IS
4759: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4760: BEGIN
4761:

Line 4759: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

4755: Function Convert_Hdr_Adj_To_Line_Adj
4756: ( p_header_adj_rec IN OE_Order_PUB.Header_adj_rec_type)
4757: RETURN OE_Order_PUB.Line_Adj_Rec_Type
4758: IS
4759: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4760: BEGIN
4761:
4762: l_line_adj_rec.attribute1 := p_header_adj_rec.attribute1;
4763: l_line_adj_rec.attribute10 := p_header_adj_rec.attribute10;

Line 4873: px_Line_Adj_Att_Tbl in out nocopy OE_Order_Pub.line_adj_att_tbl_Type

4869:
4870: END Convert_Hdr_Adj_To_Line_Adj;
4871:
4872: Procedure Append_Adjustment_Attribs(
4873: px_Line_Adj_Att_Tbl in out nocopy OE_Order_Pub.line_adj_att_tbl_Type
4874: ,p_price_adjustment_id number
4875: ,p_adj_index pls_integer
4876: )
4877: is

Line 4878: l_Line_Adj_Att_Tbl OE_Order_Pub.line_adj_att_tbl_Type;

4874: ,p_price_adjustment_id number
4875: ,p_adj_index pls_integer
4876: )
4877: is
4878: l_Line_Adj_Att_Tbl OE_Order_Pub.line_adj_att_tbl_Type;
4879: i pls_integer;
4880: begin
4881:
4882: Oe_Line_Price_Aattr_util.Query_Rows(

Line 4904: px_line_adj_rec IN OUT NOCOPY OE_Order_Pub.Line_AdJ_Rec_Type

4900:
4901: end Append_Adjustment_Attribs;
4902:
4903: Procedure Prorate_Lumpsum (
4904: px_line_adj_rec IN OUT NOCOPY OE_Order_Pub.Line_AdJ_Rec_Type
4905: , p_to_line_id IN NUMBER
4906: , x_copy_from_line_adj_rec OUT NOCOPY OE_Order_Pub.Line_Adj_Rec_Type
4907:
4908: )

Line 4906: , x_copy_from_line_adj_rec OUT NOCOPY OE_Order_Pub.Line_Adj_Rec_Type

4902:
4903: Procedure Prorate_Lumpsum (
4904: px_line_adj_rec IN OUT NOCOPY OE_Order_Pub.Line_AdJ_Rec_Type
4905: , p_to_line_id IN NUMBER
4906: , x_copy_from_line_adj_rec OUT NOCOPY OE_Order_Pub.Line_Adj_Rec_Type
4907:
4908: )
4909: IS
4910: l_ordered_quantity NUMBER;

Line 5020: px_Line_Adj_Att_Tbl in out nocopy OE_Order_Pub.line_adj_att_tbl_Type,

5016: p_to_header_id Number default null,
5017: p_operation varchar2,
5018: p_line_category_code varchar2,
5019: p_split_by varchar2 default null,
5020: px_Line_Adj_Att_Tbl in out nocopy OE_Order_Pub.line_adj_att_tbl_Type,
5021: px_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type,
5022: px_line_adj_assoc_tbl in out nocopy OE_Order_PUB.Line_Adj_Assoc_tbl_type,
5023: --RT{
5024: p_mode varchar2 default null,

Line 5021: px_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type,

5017: p_operation varchar2,
5018: p_line_category_code varchar2,
5019: p_split_by varchar2 default null,
5020: px_Line_Adj_Att_Tbl in out nocopy OE_Order_Pub.line_adj_att_tbl_Type,
5021: px_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type,
5022: px_line_adj_assoc_tbl in out nocopy OE_Order_PUB.Line_Adj_Assoc_tbl_type,
5023: --RT{
5024: p_mode varchar2 default null,
5025: p_retrobill_request_id in Varchar2 default null,

Line 5022: px_line_adj_assoc_tbl in out nocopy OE_Order_PUB.Line_Adj_Assoc_tbl_type,

5018: p_line_category_code varchar2,
5019: p_split_by varchar2 default null,
5020: px_Line_Adj_Att_Tbl in out nocopy OE_Order_Pub.line_adj_att_tbl_Type,
5021: px_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type,
5022: px_line_adj_assoc_tbl in out nocopy OE_Order_PUB.Line_Adj_Assoc_tbl_type,
5023: --RT{
5024: p_mode varchar2 default null,
5025: p_retrobill_request_id in Varchar2 default null,
5026: p_key_line_id in Number default null

Line 5030: l_Line_Adj_Tbl OE_Order_Pub.Line_Adj_Tbl_Type;

5026: p_key_line_id in Number default null
5027: --RT}
5028: )
5029: is
5030: l_Line_Adj_Tbl OE_Order_Pub.Line_Adj_Tbl_Type;
5031: i pls_integer;
5032: l_has_pbh VARCHAR2(1):='N';
5033: l_pbh_tbl Pbh_Tbl_Type;
5034: cnt Pls_Integer:=0;

Line 5035: l_copy_from_line_adj_rec OE_Order_pub.Line_Adj_Rec_Type;

5031: i pls_integer;
5032: l_has_pbh VARCHAR2(1):='N';
5033: l_pbh_tbl Pbh_Tbl_Type;
5034: cnt Pls_Integer:=0;
5035: l_copy_from_line_adj_rec OE_Order_pub.Line_Adj_Rec_Type;
5036: --
5037: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5038: --
5039: l_from_line_category VARCHAR2(100);

Line 5436: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;

5432: ,x_return_status out nocopy varchar2
5433:
5434: )
5435: is
5436: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;
5437: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
5438: l_control_rec Oe_Globals.Control_rec_type;
5439: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5440: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;

Line 5437: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;

5433:
5434: )
5435: is
5436: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;
5437: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
5438: l_control_rec Oe_Globals.Control_rec_type;
5439: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5440: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5441: -- l_x_header_rec OE_Order_PUB.Header_Rec_Type;

Line 5439: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;

5435: is
5436: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;
5437: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
5438: l_control_rec Oe_Globals.Control_rec_type;
5439: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5440: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5441: -- l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5442: l_header_rec OE_Order_PUB.Header_Rec_Type;
5443: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 5440: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;

5436: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;
5437: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
5438: l_control_rec Oe_Globals.Control_rec_type;
5439: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5440: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5441: -- l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5442: l_header_rec OE_Order_PUB.Header_Rec_Type;
5443: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5444: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 5441: -- l_x_header_rec OE_Order_PUB.Header_Rec_Type;

5437: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
5438: l_control_rec Oe_Globals.Control_rec_type;
5439: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5440: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5441: -- l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5442: l_header_rec OE_Order_PUB.Header_Rec_Type;
5443: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5444: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5445: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 5442: l_header_rec OE_Order_PUB.Header_Rec_Type;

5438: l_control_rec Oe_Globals.Control_rec_type;
5439: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5440: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5441: -- l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5442: l_header_rec OE_Order_PUB.Header_Rec_Type;
5443: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5444: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5445: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5446: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 5443: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

5439: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5440: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5441: -- l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5442: l_header_rec OE_Order_PUB.Header_Rec_Type;
5443: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5444: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5445: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5446: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5447: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 5444: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

5440: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5441: -- l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5442: l_header_rec OE_Order_PUB.Header_Rec_Type;
5443: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5444: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5445: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5446: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5447: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5448: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 5445: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

5441: -- l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5442: l_header_rec OE_Order_PUB.Header_Rec_Type;
5443: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5444: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5445: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5446: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5447: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5448: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5449: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

Line 5446: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

5442: l_header_rec OE_Order_PUB.Header_Rec_Type;
5443: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5444: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5445: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5446: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5447: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5448: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5449: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
5450: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

Line 5447: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

5443: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5444: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5445: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5446: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5447: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5448: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5449: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
5450: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
5451: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;

Line 5448: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

5444: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5445: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5446: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5447: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5448: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5449: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
5450: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
5451: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
5452: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;

Line 5449: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

5445: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5446: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5447: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5448: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5449: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
5450: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
5451: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
5452: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
5453: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;

Line 5450: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

5446: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5447: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5448: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5449: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
5450: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
5451: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
5452: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
5453: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
5454: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;

Line 5451: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;

5447: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5448: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5449: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
5450: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
5451: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
5452: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
5453: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
5454: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
5455: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;

Line 5452: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;

5448: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5449: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
5450: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
5451: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
5452: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
5453: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
5454: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
5455: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5456: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;

Line 5453: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;

5449: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
5450: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
5451: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
5452: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
5453: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
5454: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
5455: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5456: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5457: l_x_msg_count number;

Line 5454: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;

5450: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
5451: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
5452: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
5453: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
5454: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
5455: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5456: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5457: l_x_msg_count number;
5458: l_x_msg_data Varchar2(2000);

Line 5455: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;

5451: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
5452: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
5453: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
5454: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
5455: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5456: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5457: l_x_msg_count number;
5458: l_x_msg_data Varchar2(2000);
5459: i pls_integer;

Line 5456: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;

5452: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
5453: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
5454: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
5455: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5456: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5457: l_x_msg_count number;
5458: l_x_msg_data Varchar2(2000);
5459: i pls_integer;
5460: --serla begin

Line 5461: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

5457: l_x_msg_count number;
5458: l_x_msg_data Varchar2(2000);
5459: i pls_integer;
5460: --serla begin
5461: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
5462: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
5463: --serla end
5464: --
5465: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 5462: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

5458: l_x_msg_data Varchar2(2000);
5459: i pls_integer;
5460: --serla begin
5461: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
5462: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
5463: --serla end
5464: --
5465: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5466: --

Line 5631: ( p_x_line_adj_rec IN OUT NOCOPY OE_ORDER_PUB.line_adj_rec_type,

5627: end copy_adjustment_lines;
5628:
5629: /* Start AuditTrail */
5630: PROCEDURE Pre_Write_Process
5631: ( p_x_line_adj_rec IN OUT NOCOPY OE_ORDER_PUB.line_adj_rec_type,
5632: p_old_line_adj_rec IN OE_ORDER_PUB.line_adj_rec_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC) IS
5633: /*local */
5634: l_return_status varchar2(30);
5635: --

Line 5632: p_old_line_adj_rec IN OE_ORDER_PUB.line_adj_rec_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC) IS

5628:
5629: /* Start AuditTrail */
5630: PROCEDURE Pre_Write_Process
5631: ( p_x_line_adj_rec IN OUT NOCOPY OE_ORDER_PUB.line_adj_rec_type,
5632: p_old_line_adj_rec IN OE_ORDER_PUB.line_adj_rec_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC) IS
5633: /*local */
5634: l_return_status varchar2(30);
5635: --
5636: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 5641: l_line_rec OE_Order_PUB.Line_Rec_Type; --TaxER

5637: --
5638: l_org_id NUMBER(15):=MO_GLOBAL.Get_Current_Org_Id; --TaxER
5639: l_current_event number := 0; --TaxER
5640: l_tax_calculation_event_code number := 0; --TaxER
5641: l_line_rec OE_Order_PUB.Line_Rec_Type; --TaxER
5642: BEGIN
5643:
5644: --11.5.10 Versioning/Audit Trail updates
5645: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND

Line 5826: Function Is_Pricing_Related_Change(p_new_line_rec In Oe_Order_Pub.Line_Rec_Type,

5822:
5823: END Pre_Write_Process;
5824: /* End AuditTrail */
5825:
5826: Function Is_Pricing_Related_Change(p_new_line_rec In Oe_Order_Pub.Line_Rec_Type,
5827: p_old_line_rec In Oe_Order_Pub.Line_Rec_Type) Return Boolean As
5828: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5829: Begin
5830:

Line 5827: p_old_line_rec In Oe_Order_Pub.Line_Rec_Type) Return Boolean As

5823: END Pre_Write_Process;
5824: /* End AuditTrail */
5825:
5826: Function Is_Pricing_Related_Change(p_new_line_rec In Oe_Order_Pub.Line_Rec_Type,
5827: p_old_line_rec In Oe_Order_Pub.Line_Rec_Type) Return Boolean As
5828: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5829: Begin
5830:
5831: IF l_debug_level > 0 THEN

Line 5920: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

5916: from oe_price_adjustments
5917: where line_id = p_line_id AND list_line_type_code = 'PRG';
5918:
5919: /* Variables to call process order */
5920: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5921: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5922: l_control_rec OE_GLOBALS.Control_Rec_Type;
5923: l_line_rec OE_Order_PUB.Line_Rec_Type;
5924: x_return_status Varchar2(1);

Line 5921: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

5917: where line_id = p_line_id AND list_line_type_code = 'PRG';
5918:
5919: /* Variables to call process order */
5920: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5921: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5922: l_control_rec OE_GLOBALS.Control_Rec_Type;
5923: l_line_rec OE_Order_PUB.Line_Rec_Type;
5924: x_return_status Varchar2(1);
5925: l_prg_line_id NUMBER;

Line 5923: l_line_rec OE_Order_PUB.Line_Rec_Type;

5919: /* Variables to call process order */
5920: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5921: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5922: l_control_rec OE_GLOBALS.Control_Rec_Type;
5923: l_line_rec OE_Order_PUB.Line_Rec_Type;
5924: x_return_status Varchar2(1);
5925: l_prg_line_id NUMBER;
5926: l_price_adj_id NUMBER;
5927: l_delete_prg varchar2(1);

Line 6059: Procedure Check_Canceled_PRG(p_old_line_rec in Oe_Order_Pub.line_rec_type,

6055: END IF;
6056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6057: End Delete_PRG_Lines;
6058:
6059: Procedure Check_Canceled_PRG(p_old_line_rec in Oe_Order_Pub.line_rec_type,
6060: p_new_line_rec in Oe_Order_Pub.line_rec_type) Is
6061: --
6062: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6063: --

Line 6060: p_new_line_rec in Oe_Order_Pub.line_rec_type) Is

6056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6057: End Delete_PRG_Lines;
6058:
6059: Procedure Check_Canceled_PRG(p_old_line_rec in Oe_Order_Pub.line_rec_type,
6060: p_new_line_rec in Oe_Order_Pub.line_rec_type) Is
6061: --
6062: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6063: --
6064: Begin

Line 6098: Procedure Process_Pricing (p_x_new_line_rec In OUT Nocopy Oe_Order_Pub.Line_Rec_Type,

6094: ------------------------------------------------------------------------------------
6095: --Called from OEXULINB.pls apply_attribute_changes to check is a repricing is required
6096: --Not yet fully implemented. Will work in when getting the lock of OEXULINB.pls
6097: ------------------------------------------------------------------------------------
6098: Procedure Process_Pricing (p_x_new_line_rec In OUT Nocopy Oe_Order_Pub.Line_Rec_Type,
6099: p_old_line_rec In Oe_Order_Pub.Line_Rec_Type,
6100: p_no_price_flag In Boolean) Is
6101:
6102: l_price_flag Varchar2(1):='Y';

Line 6099: p_old_line_rec In Oe_Order_Pub.Line_Rec_Type,

6095: --Called from OEXULINB.pls apply_attribute_changes to check is a repricing is required
6096: --Not yet fully implemented. Will work in when getting the lock of OEXULINB.pls
6097: ------------------------------------------------------------------------------------
6098: Procedure Process_Pricing (p_x_new_line_rec In OUT Nocopy Oe_Order_Pub.Line_Rec_Type,
6099: p_old_line_rec In Oe_Order_Pub.Line_Rec_Type,
6100: p_no_price_flag In Boolean) Is
6101:
6102: l_price_flag Varchar2(1):='Y';
6103: l_charges_for_included_item VARCHAR2(1):=NVL(FND_PROFILE.VALUE('ONT_CHARGES_FOR_INCLUDED_ITEM'),'N');

Line 6255: Procedure Log_Pricing_Requests (p_x_new_line_rec in Out Nocopy Oe_Order_Pub.Line_Rec_Type,

6251: oe_debug_pub.add( 'LEAVING OE_LINE_ADJ_UTIL.PROCESS_PRICING' ) ;
6252: END IF;
6253: End Process_Pricing;
6254:
6255: Procedure Log_Pricing_Requests (p_x_new_line_rec in Out Nocopy Oe_Order_Pub.Line_Rec_Type,
6256: p_old_line_rec in Oe_Order_Pub.Line_Rec_Type,
6257: p_no_price_flag Boolean Default False,
6258: p_price_flag Varchar2 Default 'Y') Is
6259:

Line 6256: p_old_line_rec in Oe_Order_Pub.Line_Rec_Type,

6252: END IF;
6253: End Process_Pricing;
6254:
6255: Procedure Log_Pricing_Requests (p_x_new_line_rec in Out Nocopy Oe_Order_Pub.Line_Rec_Type,
6256: p_old_line_rec in Oe_Order_Pub.Line_Rec_Type,
6257: p_no_price_flag Boolean Default False,
6258: p_price_flag Varchar2 Default 'Y') Is
6259:
6260: l_zero_line_qty Boolean :=FALSE;

Line 6262: l_x_line_tbl Oe_Order_Pub.Line_Tbl_Type;

6258: p_price_flag Varchar2 Default 'Y') Is
6259:
6260: l_zero_line_qty Boolean :=FALSE;
6261: l_price_control_rec QP_PREQ_GRP.control_record_type;
6262: l_x_line_tbl Oe_Order_Pub.Line_Tbl_Type;
6263: l_return_status Varchar2(5);
6264: i PLS_INTEGER;
6265: l_x_result_out Varchar2(5);
6266: --

Line 6564: Procedure Process_Cancelled_Lines(p_x_new_line_rec In Oe_Order_Pub.line_rec_type, p_ordered_quantity In Number) Is

6560: --in which we either combine all events to call pricing engine once
6561: --or not calling at all depending on the output of QP_UTIL_PUB.Get_Order_Lines_Status
6562: /*----------------------------------------------------------------------*/
6563:
6564: Procedure Process_Cancelled_Lines(p_x_new_line_rec In Oe_Order_Pub.line_rec_type, p_ordered_quantity In Number) Is
6565: --bug7491829 added p_ordered_quantity
6566:
6567: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
6568: l_return_status Varchar2(5);

Line 6801: Procedure Change_adj_for_uom_change(p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

6797: End;
6798:
6799: /* Added the following procedure to fix the bug 2917690 */
6800:
6801: Procedure Change_adj_for_uom_change(p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
6802: ) Is
6803: l_return_status Varchar2(15);
6804: l_old_pricing_qty NUMBER;
6805: l_new_pricing_qty NUMBER;