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 1964: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

1960:
1961: -- Procedure Complete_Record
1962:
1963: PROCEDURE Complete_Record
1964: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
1965: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
1966: )
1967: IS
1968: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type := p_x_Line_Adj_rec;

Line 1965: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type

1961: -- Procedure Complete_Record
1962:
1963: PROCEDURE Complete_Record
1964: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
1965: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
1966: )
1967: IS
1968: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type := p_x_Line_Adj_rec;
1969: BEGIN

Line 1968: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type := p_x_Line_Adj_rec;

1964: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
1965: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
1966: )
1967: IS
1968: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type := p_x_Line_Adj_rec;
1969: BEGIN
1970:
1971: IF l_Line_Adj_rec.adjusted_amount = FND_API.G_MISS_NUM THEN
1972: l_Line_Adj_rec.adjusted_amount := p_old_Line_Adj_rec.adjusted_amount;

Line 2417: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

2413:
2414: -- Procedure Convert_Miss_To_Null
2415:
2416: PROCEDURE Convert_Miss_To_Null
2417: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
2418: )
2419: IS
2420: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type := p_x_Line_Adj_rec;
2421: --

Line 2420: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type := p_x_Line_Adj_rec;

2416: PROCEDURE Convert_Miss_To_Null
2417: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
2418: )
2419: IS
2420: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type := p_x_Line_Adj_rec;
2421: --
2422: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2423: --
2424: BEGIN

Line 2844: ( p_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

2840:
2841: -- Procedure Update_Row
2842:
2843: PROCEDURE Update_Row
2844: ( p_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
2845: )
2846: IS
2847: l_lock_control NUMBER;
2848: l_index NUMBER;

Line 3057: ( p_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

3053:
3054: -- Procedure Insert_Row
3055:
3056: PROCEDURE Insert_Row
3057: ( p_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
3058: )
3059: IS
3060: l_lock_control NUMBER := 1;
3061: l_index NUMBER;

Line 3387: l_new_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

3383: FROM OE_PRICE_ADJUSTMENTS
3384: WHERE LINE_ID = p_line_id;
3385:
3386: -- added for notification framework
3387: l_new_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3388: l_index NUMBER;
3389:
3390: --
3391: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3553: , x_Line_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

3549: -- Procedure Query_Row
3550:
3551: PROCEDURE Query_Row
3552: ( p_price_adjustment_id IN NUMBER
3553: , x_Line_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
3554: )
3555: IS
3556: l_Line_Adj_Tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3557: BEGIN

Line 3556: l_Line_Adj_Tbl OE_Order_PUB.Line_Adj_Tbl_Type;

3552: ( p_price_adjustment_id IN NUMBER
3553: , x_Line_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
3554: )
3555: IS
3556: l_Line_Adj_Tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3557: BEGIN
3558:
3559: Query_Rows
3560: ( p_price_adjustment_id => p_price_adjustment_id

Line 3578: , x_Line_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type

3574: , p_Header_id IN NUMBER :=
3575: FND_API.G_MISS_NUM
3576: , p_Line_Level_Header_id IN NUMBER :=
3577: FND_API.G_MISS_NUM
3578: , x_Line_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
3579: )
3580: IS
3581: l_count NUMBER;
3582:

Line 4278: , p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

4274:
4275: PROCEDURE Lock_Row
4276: ( x_return_status OUT NOCOPY VARCHAR2
4277:
4278: , p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
4279: -- := OE_Order_PUB.G_MISS_LINE_ADJ_REC
4280: , p_price_adjustment_id IN NUMBER
4281: := FND_API.G_MISS_NUM
4282: -- , x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type

Line 4279: -- := OE_Order_PUB.G_MISS_LINE_ADJ_REC

4275: PROCEDURE Lock_Row
4276: ( x_return_status OUT NOCOPY VARCHAR2
4277:
4278: , p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
4279: -- := OE_Order_PUB.G_MISS_LINE_ADJ_REC
4280: , p_price_adjustment_id IN NUMBER
4281: := FND_API.G_MISS_NUM
4282: -- , x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type
4283: )

Line 4282: -- , x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type

4278: , p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
4279: -- := OE_Order_PUB.G_MISS_LINE_ADJ_REC
4280: , p_price_adjustment_id IN NUMBER
4281: := FND_API.G_MISS_NUM
4282: -- , x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type
4283: )
4284: IS
4285: l_price_adjustment_id NUMBER;
4286: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 4286: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

4282: -- , x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type
4283: )
4284: IS
4285: l_price_adjustment_id NUMBER;
4286: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4287: l_lock_control NUMBER;
4288:
4289: --
4290: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4435: , x_Line_Adj_tbl OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type

4431: ( p_price_adjustment_id IN NUMBER
4432: := FND_API.G_MISS_NUM
4433: , p_line_id IN NUMBER
4434: := FND_API.G_MISS_NUM
4435: , x_Line_Adj_tbl OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
4436: , x_return_status OUT NOCOPY VARCHAR2
4437:
4438: )
4439: IS

Line 4448: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

4444: WHERE line_id = p_line_id
4445: FOR UPDATE NOWAIT;
4446:
4447: l_price_adjustment_id NUMBER;
4448: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4449: l_lock_control NUMBER;
4450:
4451: --
4452: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4553: , p_adj_rec IN OE_order_pub.Line_Adj_Rec_Type

4549:
4550: PROCEDURE Log_Adj_Requests
4551: ( x_return_status OUT NOCOPY VARCHAR2
4552:
4553: , p_adj_rec IN OE_order_pub.Line_Adj_Rec_Type
4554: , p_old_adj_rec IN OE_order_pub.Line_Adj_Rec_Type
4555: , p_delete_flag IN BOOLEAN DEFAULT FALSE
4556: ) IS
4557: BEGIN

Line 4554: , p_old_adj_rec IN OE_order_pub.Line_Adj_Rec_Type

4550: PROCEDURE Log_Adj_Requests
4551: ( x_return_status OUT NOCOPY VARCHAR2
4552:
4553: , p_adj_rec IN OE_order_pub.Line_Adj_Rec_Type
4554: , p_old_adj_rec IN OE_order_pub.Line_Adj_Rec_Type
4555: , p_delete_flag IN BOOLEAN DEFAULT FALSE
4556: ) IS
4557: BEGIN
4558:

Line 4600: ( p_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type

4596:
4597: -- Function Get_Values
4598:
4599: FUNCTION Get_Values
4600: ( p_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
4601: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
4602: OE_Order_PUB.G_MISS_LINE_ADJ_REC
4603: ) RETURN OE_Order_PUB.Line_Adj_Val_Rec_Type
4604: IS

Line 4601: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=

4597: -- Function Get_Values
4598:
4599: FUNCTION Get_Values
4600: ( p_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
4601: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
4602: OE_Order_PUB.G_MISS_LINE_ADJ_REC
4603: ) RETURN OE_Order_PUB.Line_Adj_Val_Rec_Type
4604: IS
4605: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;

Line 4602: OE_Order_PUB.G_MISS_LINE_ADJ_REC

4598:
4599: FUNCTION Get_Values
4600: ( p_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
4601: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
4602: OE_Order_PUB.G_MISS_LINE_ADJ_REC
4603: ) RETURN OE_Order_PUB.Line_Adj_Val_Rec_Type
4604: IS
4605: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
4606: BEGIN

Line 4603: ) RETURN OE_Order_PUB.Line_Adj_Val_Rec_Type

4599: FUNCTION Get_Values
4600: ( p_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
4601: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
4602: OE_Order_PUB.G_MISS_LINE_ADJ_REC
4603: ) RETURN OE_Order_PUB.Line_Adj_Val_Rec_Type
4604: IS
4605: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
4606: BEGIN
4607:

Line 4605: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;

4601: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
4602: OE_Order_PUB.G_MISS_LINE_ADJ_REC
4603: ) RETURN OE_Order_PUB.Line_Adj_Val_Rec_Type
4604: IS
4605: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
4606: BEGIN
4607:
4608: IF (p_Line_Adj_rec.discount_id IS NULL OR
4609: p_Line_Adj_rec.discount_id <> FND_API.G_MISS_NUM) AND

Line 4625: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

4621:
4622: -- Procedure Get_Ids
4623:
4624: PROCEDURE Get_Ids
4625: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
4626: , p_Line_Adj_val_rec IN OE_Order_PUB.Line_Adj_Val_Rec_Type
4627: )
4628: IS
4629: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 4626: , p_Line_Adj_val_rec IN OE_Order_PUB.Line_Adj_Val_Rec_Type

4622: -- Procedure Get_Ids
4623:
4624: PROCEDURE Get_Ids
4625: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
4626: , p_Line_Adj_val_rec IN OE_Order_PUB.Line_Adj_Val_Rec_Type
4627: )
4628: IS
4629: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4630: BEGIN

Line 4629: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

4625: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
4626: , p_Line_Adj_val_rec IN OE_Order_PUB.Line_Adj_Val_Rec_Type
4627: )
4628: IS
4629: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4630: BEGIN
4631:
4632: -- initialize return_status.
4633:

Line 4678: ( p_header_adj_rec IN OE_Order_PUB.Header_adj_rec_type)

4674: END Get_Ids;
4675:
4676: -- This function converts a Header adj record to a Line Adjustment record
4677: Function Convert_Hdr_Adj_To_Line_Adj
4678: ( p_header_adj_rec IN OE_Order_PUB.Header_adj_rec_type)
4679: RETURN OE_Order_PUB.Line_Adj_Rec_Type
4680: IS
4681: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4682: BEGIN

Line 4679: RETURN OE_Order_PUB.Line_Adj_Rec_Type

4675:
4676: -- This function converts a Header adj record to a Line Adjustment record
4677: Function Convert_Hdr_Adj_To_Line_Adj
4678: ( p_header_adj_rec IN OE_Order_PUB.Header_adj_rec_type)
4679: RETURN OE_Order_PUB.Line_Adj_Rec_Type
4680: IS
4681: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4682: BEGIN
4683:

Line 4681: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

4677: Function Convert_Hdr_Adj_To_Line_Adj
4678: ( p_header_adj_rec IN OE_Order_PUB.Header_adj_rec_type)
4679: RETURN OE_Order_PUB.Line_Adj_Rec_Type
4680: IS
4681: l_line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4682: BEGIN
4683:
4684: l_line_adj_rec.attribute1 := p_header_adj_rec.attribute1;
4685: l_line_adj_rec.attribute10 := p_header_adj_rec.attribute10;

Line 4795: px_Line_Adj_Att_Tbl in out nocopy OE_Order_Pub.line_adj_att_tbl_Type

4791:
4792: END Convert_Hdr_Adj_To_Line_Adj;
4793:
4794: Procedure Append_Adjustment_Attribs(
4795: px_Line_Adj_Att_Tbl in out nocopy OE_Order_Pub.line_adj_att_tbl_Type
4796: ,p_price_adjustment_id number
4797: ,p_adj_index pls_integer
4798: )
4799: is

Line 4800: l_Line_Adj_Att_Tbl OE_Order_Pub.line_adj_att_tbl_Type;

4796: ,p_price_adjustment_id number
4797: ,p_adj_index pls_integer
4798: )
4799: is
4800: l_Line_Adj_Att_Tbl OE_Order_Pub.line_adj_att_tbl_Type;
4801: i pls_integer;
4802: begin
4803:
4804: Oe_Line_Price_Aattr_util.Query_Rows(

Line 4826: px_line_adj_rec IN OUT NOCOPY OE_Order_Pub.Line_AdJ_Rec_Type

4822:
4823: end Append_Adjustment_Attribs;
4824:
4825: Procedure Prorate_Lumpsum (
4826: px_line_adj_rec IN OUT NOCOPY OE_Order_Pub.Line_AdJ_Rec_Type
4827: , p_to_line_id IN NUMBER
4828: , x_copy_from_line_adj_rec OUT NOCOPY OE_Order_Pub.Line_Adj_Rec_Type
4829:
4830: )

Line 4828: , x_copy_from_line_adj_rec OUT NOCOPY OE_Order_Pub.Line_Adj_Rec_Type

4824:
4825: Procedure Prorate_Lumpsum (
4826: px_line_adj_rec IN OUT NOCOPY OE_Order_Pub.Line_AdJ_Rec_Type
4827: , p_to_line_id IN NUMBER
4828: , x_copy_from_line_adj_rec OUT NOCOPY OE_Order_Pub.Line_Adj_Rec_Type
4829:
4830: )
4831: IS
4832: l_ordered_quantity NUMBER;

Line 4942: px_Line_Adj_Att_Tbl in out nocopy OE_Order_Pub.line_adj_att_tbl_Type,

4938: p_to_header_id Number default null,
4939: p_operation varchar2,
4940: p_line_category_code varchar2,
4941: p_split_by varchar2 default null,
4942: px_Line_Adj_Att_Tbl in out nocopy OE_Order_Pub.line_adj_att_tbl_Type,
4943: px_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type,
4944: px_line_adj_assoc_tbl in out nocopy OE_Order_PUB.Line_Adj_Assoc_tbl_type,
4945: --RT{
4946: p_mode varchar2 default null,

Line 4943: px_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type,

4939: p_operation varchar2,
4940: p_line_category_code varchar2,
4941: p_split_by varchar2 default null,
4942: px_Line_Adj_Att_Tbl in out nocopy OE_Order_Pub.line_adj_att_tbl_Type,
4943: px_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type,
4944: px_line_adj_assoc_tbl in out nocopy OE_Order_PUB.Line_Adj_Assoc_tbl_type,
4945: --RT{
4946: p_mode varchar2 default null,
4947: p_retrobill_request_id in Varchar2 default null,

Line 4944: px_line_adj_assoc_tbl in out nocopy OE_Order_PUB.Line_Adj_Assoc_tbl_type,

4940: p_line_category_code varchar2,
4941: p_split_by varchar2 default null,
4942: px_Line_Adj_Att_Tbl in out nocopy OE_Order_Pub.line_adj_att_tbl_Type,
4943: px_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type,
4944: px_line_adj_assoc_tbl in out nocopy OE_Order_PUB.Line_Adj_Assoc_tbl_type,
4945: --RT{
4946: p_mode varchar2 default null,
4947: p_retrobill_request_id in Varchar2 default null,
4948: p_key_line_id in Number default null

Line 4952: l_Line_Adj_Tbl OE_Order_Pub.Line_Adj_Tbl_Type;

4948: p_key_line_id in Number default null
4949: --RT}
4950: )
4951: is
4952: l_Line_Adj_Tbl OE_Order_Pub.Line_Adj_Tbl_Type;
4953: i pls_integer;
4954: l_has_pbh VARCHAR2(1):='N';
4955: l_pbh_tbl Pbh_Tbl_Type;
4956: cnt Pls_Integer:=0;

Line 4957: l_copy_from_line_adj_rec OE_Order_pub.Line_Adj_Rec_Type;

4953: i pls_integer;
4954: l_has_pbh VARCHAR2(1):='N';
4955: l_pbh_tbl Pbh_Tbl_Type;
4956: cnt Pls_Integer:=0;
4957: l_copy_from_line_adj_rec OE_Order_pub.Line_Adj_Rec_Type;
4958: --
4959: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4960: --
4961: l_from_line_category VARCHAR2(100);

Line 5331: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;

5327: ,x_return_status out nocopy varchar2
5328:
5329: )
5330: is
5331: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;
5332: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
5333: l_control_rec Oe_Globals.Control_rec_type;
5334: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5335: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;

Line 5332: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;

5328:
5329: )
5330: is
5331: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;
5332: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
5333: l_control_rec Oe_Globals.Control_rec_type;
5334: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5335: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5336: -- l_x_header_rec OE_Order_PUB.Header_Rec_Type;

Line 5334: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;

5330: is
5331: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;
5332: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
5333: l_control_rec Oe_Globals.Control_rec_type;
5334: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5335: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5336: -- l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5337: l_header_rec OE_Order_PUB.Header_Rec_Type;
5338: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 5335: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;

5331: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;
5332: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
5333: l_control_rec Oe_Globals.Control_rec_type;
5334: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5335: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5336: -- l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5337: l_header_rec OE_Order_PUB.Header_Rec_Type;
5338: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5339: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 5336: -- l_x_header_rec OE_Order_PUB.Header_Rec_Type;

5332: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
5333: l_control_rec Oe_Globals.Control_rec_type;
5334: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5335: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5336: -- l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5337: l_header_rec OE_Order_PUB.Header_Rec_Type;
5338: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5339: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5340: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 5337: l_header_rec OE_Order_PUB.Header_Rec_Type;

5333: l_control_rec Oe_Globals.Control_rec_type;
5334: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5335: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5336: -- l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5337: l_header_rec OE_Order_PUB.Header_Rec_Type;
5338: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5339: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5340: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5341: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 5338: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

5334: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5335: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5336: -- l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5337: l_header_rec OE_Order_PUB.Header_Rec_Type;
5338: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5339: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5340: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5341: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5342: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 5339: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

5335: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5336: -- l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5337: l_header_rec OE_Order_PUB.Header_Rec_Type;
5338: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5339: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5340: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5341: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5342: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5343: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 5340: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

5336: -- l_x_header_rec OE_Order_PUB.Header_Rec_Type;
5337: l_header_rec OE_Order_PUB.Header_Rec_Type;
5338: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5339: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5340: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5341: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5342: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5343: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5344: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

Line 5341: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

5337: l_header_rec OE_Order_PUB.Header_Rec_Type;
5338: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5339: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5340: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5341: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5342: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5343: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5344: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
5345: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

Line 5342: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

5338: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
5339: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5340: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5341: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5342: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5343: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5344: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
5345: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
5346: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;

Line 5343: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

5339: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
5340: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5341: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5342: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5343: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5344: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
5345: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
5346: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
5347: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;

Line 5344: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

5340: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
5341: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5342: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5343: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5344: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
5345: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
5346: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
5347: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
5348: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;

Line 5345: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

5341: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
5342: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5343: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5344: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
5345: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
5346: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
5347: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
5348: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
5349: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;

Line 5346: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;

5342: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
5343: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5344: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
5345: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
5346: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
5347: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
5348: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
5349: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
5350: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;

Line 5347: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;

5343: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
5344: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
5345: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
5346: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
5347: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
5348: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
5349: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
5350: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5351: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;

Line 5348: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;

5344: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
5345: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
5346: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
5347: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
5348: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
5349: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
5350: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5351: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5352: l_x_msg_count number;

Line 5349: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;

5345: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
5346: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
5347: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
5348: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
5349: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
5350: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5351: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5352: l_x_msg_count number;
5353: l_x_msg_data Varchar2(2000);

Line 5350: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;

5346: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
5347: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
5348: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
5349: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
5350: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5351: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5352: l_x_msg_count number;
5353: l_x_msg_data Varchar2(2000);
5354: i pls_integer;

Line 5351: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;

5347: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
5348: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
5349: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
5350: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
5351: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
5352: l_x_msg_count number;
5353: l_x_msg_data Varchar2(2000);
5354: i pls_integer;
5355: --serla begin

Line 5356: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

5352: l_x_msg_count number;
5353: l_x_msg_data Varchar2(2000);
5354: i pls_integer;
5355: --serla begin
5356: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
5357: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
5358: --serla end
5359: --
5360: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 5357: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

5353: l_x_msg_data Varchar2(2000);
5354: i pls_integer;
5355: --serla begin
5356: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
5357: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
5358: --serla end
5359: --
5360: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5361: --

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

5522: end copy_adjustment_lines;
5523:
5524: /* Start AuditTrail */
5525: PROCEDURE Pre_Write_Process
5526: ( p_x_line_adj_rec IN OUT NOCOPY OE_ORDER_PUB.line_adj_rec_type,
5527: p_old_line_adj_rec IN OE_ORDER_PUB.line_adj_rec_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC) IS
5528: /*local */
5529: l_return_status varchar2(30);
5530: --

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

5523:
5524: /* Start AuditTrail */
5525: PROCEDURE Pre_Write_Process
5526: ( p_x_line_adj_rec IN OUT NOCOPY OE_ORDER_PUB.line_adj_rec_type,
5527: p_old_line_adj_rec IN OE_ORDER_PUB.line_adj_rec_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC) IS
5528: /*local */
5529: l_return_status varchar2(30);
5530: --
5531: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

5614:
5615: END Pre_Write_Process;
5616: /* End AuditTrail */
5617:
5618: Function Is_Pricing_Related_Change(p_new_line_rec In Oe_Order_Pub.Line_Rec_Type,
5619: p_old_line_rec In Oe_Order_Pub.Line_Rec_Type) Return Boolean As
5620: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5621: Begin
5622:

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

5615: END Pre_Write_Process;
5616: /* End AuditTrail */
5617:
5618: Function Is_Pricing_Related_Change(p_new_line_rec In Oe_Order_Pub.Line_Rec_Type,
5619: p_old_line_rec In Oe_Order_Pub.Line_Rec_Type) Return Boolean As
5620: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5621: Begin
5622:
5623: IF l_debug_level > 0 THEN

Line 5712: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

5708: from oe_price_adjustments
5709: where line_id = p_line_id AND list_line_type_code = 'PRG';
5710:
5711: /* Variables to call process order */
5712: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5713: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5714: l_control_rec OE_GLOBALS.Control_Rec_Type;
5715: l_line_rec OE_Order_PUB.Line_Rec_Type;
5716: x_return_status Varchar2(1);

Line 5713: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

5709: where line_id = p_line_id AND list_line_type_code = 'PRG';
5710:
5711: /* Variables to call process order */
5712: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5713: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5714: l_control_rec OE_GLOBALS.Control_Rec_Type;
5715: l_line_rec OE_Order_PUB.Line_Rec_Type;
5716: x_return_status Varchar2(1);
5717: l_prg_line_id NUMBER;

Line 5715: l_line_rec OE_Order_PUB.Line_Rec_Type;

5711: /* Variables to call process order */
5712: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5713: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
5714: l_control_rec OE_GLOBALS.Control_Rec_Type;
5715: l_line_rec OE_Order_PUB.Line_Rec_Type;
5716: x_return_status Varchar2(1);
5717: l_prg_line_id NUMBER;
5718: l_price_adj_id NUMBER;
5719: l_delete_prg varchar2(1);

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

5847: END IF;
5848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5849: End Delete_PRG_Lines;
5850:
5851: Procedure Check_Canceled_PRG(p_old_line_rec in Oe_Order_Pub.line_rec_type,
5852: p_new_line_rec in Oe_Order_Pub.line_rec_type) Is
5853: --
5854: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5855: --

Line 5852: p_new_line_rec in Oe_Order_Pub.line_rec_type) Is

5848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5849: End Delete_PRG_Lines;
5850:
5851: Procedure Check_Canceled_PRG(p_old_line_rec in Oe_Order_Pub.line_rec_type,
5852: p_new_line_rec in Oe_Order_Pub.line_rec_type) Is
5853: --
5854: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5855: --
5856: Begin

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

5886: ------------------------------------------------------------------------------------
5887: --Called from OEXULINB.pls apply_attribute_changes to check is a repricing is required
5888: --Not yet fully implemented. Will work in when getting the lock of OEXULINB.pls
5889: ------------------------------------------------------------------------------------
5890: Procedure Process_Pricing (p_x_new_line_rec In OUT Nocopy Oe_Order_Pub.Line_Rec_Type,
5891: p_old_line_rec In Oe_Order_Pub.Line_Rec_Type,
5892: p_no_price_flag In Boolean) Is
5893:
5894: l_price_flag Varchar2(1):='Y';

Line 5891: p_old_line_rec In Oe_Order_Pub.Line_Rec_Type,

5887: --Called from OEXULINB.pls apply_attribute_changes to check is a repricing is required
5888: --Not yet fully implemented. Will work in when getting the lock of OEXULINB.pls
5889: ------------------------------------------------------------------------------------
5890: Procedure Process_Pricing (p_x_new_line_rec In OUT Nocopy Oe_Order_Pub.Line_Rec_Type,
5891: p_old_line_rec In Oe_Order_Pub.Line_Rec_Type,
5892: p_no_price_flag In Boolean) Is
5893:
5894: l_price_flag Varchar2(1):='Y';
5895: l_charges_for_included_item VARCHAR2(1):=NVL(FND_PROFILE.VALUE('ONT_CHARGES_FOR_INCLUDED_ITEM'),'N');

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

6043: oe_debug_pub.add( 'LEAVING OE_LINE_ADJ_UTIL.PROCESS_PRICING' ) ;
6044: END IF;
6045: End Process_Pricing;
6046:
6047: Procedure Log_Pricing_Requests (p_x_new_line_rec in Out Nocopy Oe_Order_Pub.Line_Rec_Type,
6048: p_old_line_rec in Oe_Order_Pub.Line_Rec_Type,
6049: p_no_price_flag Boolean Default False,
6050: p_price_flag Varchar2 Default 'Y') Is
6051:

Line 6048: p_old_line_rec in Oe_Order_Pub.Line_Rec_Type,

6044: END IF;
6045: End Process_Pricing;
6046:
6047: Procedure Log_Pricing_Requests (p_x_new_line_rec in Out Nocopy Oe_Order_Pub.Line_Rec_Type,
6048: p_old_line_rec in Oe_Order_Pub.Line_Rec_Type,
6049: p_no_price_flag Boolean Default False,
6050: p_price_flag Varchar2 Default 'Y') Is
6051:
6052: l_zero_line_qty Boolean :=FALSE;

Line 6054: l_x_line_tbl Oe_Order_Pub.Line_Tbl_Type;

6050: p_price_flag Varchar2 Default 'Y') Is
6051:
6052: l_zero_line_qty Boolean :=FALSE;
6053: l_price_control_rec QP_PREQ_GRP.control_record_type;
6054: l_x_line_tbl Oe_Order_Pub.Line_Tbl_Type;
6055: l_return_status Varchar2(5);
6056: i PLS_INTEGER;
6057: l_x_result_out Varchar2(5);
6058: --

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

6306: --in which we either combine all events to call pricing engine once
6307: --or not calling at all depending on the output of QP_UTIL_PUB.Get_Order_Lines_Status
6308: /*----------------------------------------------------------------------*/
6309:
6310: Procedure Process_Cancelled_Lines(p_x_new_line_rec In Oe_Order_Pub.line_rec_type, p_ordered_quantity In Number) Is
6311: --bug7491829 added p_ordered_quantity
6312:
6313: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
6314: l_return_status Varchar2(5);

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

6534: End;
6535:
6536: /* Added the following procedure to fix the bug 2917690 */
6537:
6538: Procedure Change_adj_for_uom_change(p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
6539: ) Is
6540: l_return_status Varchar2(15);
6541: l_old_pricing_qty NUMBER;
6542: l_new_pricing_qty NUMBER;