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_HEADER_ADJ_UTIL dependencies on OE_ORDER_PUB

Line 123: ( p_HEADER_ADJ_rec IN OE_Order_PUB.HEADER_ADJ_Rec_Type

119:
120: END G_MISS_OE_AK_HEADER_ADJ_REC;
121:
122: PROCEDURE API_Rec_To_Rowtype_Rec
123: ( p_HEADER_ADJ_rec IN OE_Order_PUB.HEADER_ADJ_Rec_Type
124: , x_rowtype_rec OUT nocopy OE_AK_HEADER_PRCADJS_V%ROWTYPE
125: ) IS
126: --
127: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 241: , x_api_rec OUT nocopy OE_Order_PUB.HEADER_ADJ_Rec_Type

237:
238:
239: PROCEDURE Rowtype_Rec_To_API_Rec
240: ( p_record IN OE_AK_HEADER_PRCADJS_V%ROWTYPE
241: , x_api_rec OUT nocopy OE_Order_PUB.HEADER_ADJ_Rec_Type
242: )
243: iS
244:
245: --

Line 1114: , p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type

1110: -- maintaining 2 code sets
1111:
1112: PROCEDURE Clear_Dependent_Attr
1113: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
1114: , p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type
1115: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
1116: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
1117: --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
1118: )

Line 1115: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=

1111:
1112: PROCEDURE Clear_Dependent_Attr
1113: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
1114: , p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type
1115: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
1116: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
1117: --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
1118: )
1119: IS

Line 1116: OE_Order_PUB.G_MISS_HEADER_ADJ_REC

1112: PROCEDURE Clear_Dependent_Attr
1113: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
1114: , p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type
1115: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
1116: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
1117: --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
1118: )
1119: IS
1120:

Line 1117: --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type

1113: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
1114: , p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type
1115: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
1116: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
1117: --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
1118: )
1119: IS
1120:
1121: l_Header_Adj_rec OE_AK_HEADER_PRCADJS_V%ROWTYPE;

Line 1201: ( p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type

1197:
1198: -- Procedure Apply_Attribute_Changes
1199:
1200: PROCEDURE Apply_Attribute_Changes
1201: ( p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type
1202: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
1203: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
1204: --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
1205: )

Line 1202: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=

1198: -- Procedure Apply_Attribute_Changes
1199:
1200: PROCEDURE Apply_Attribute_Changes
1201: ( p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type
1202: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
1203: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
1204: --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
1205: )
1206: IS

Line 1203: OE_Order_PUB.G_MISS_HEADER_ADJ_REC

1199:
1200: PROCEDURE Apply_Attribute_Changes
1201: ( p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type
1202: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
1203: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
1204: --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
1205: )
1206: IS
1207: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1204: --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type

1200: PROCEDURE Apply_Attribute_Changes
1201: ( p_x_Header_Adj_rec IN out nocopy OE_Order_PUB.Header_Adj_Rec_Type
1202: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
1203: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
1204: --, x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
1205: )
1206: IS
1207: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1208: l_price_flag boolean := FALSE;

Line 1212: l_header_rec OE_Order_PUB.Header_Rec_Type;

1208: l_price_flag boolean := FALSE;
1209: l_verify_payment_flag VARCHAR2(30) := 'N';
1210: --bug#5961160
1211: l_calling_action VARCHAR2(30);
1212: l_header_rec OE_Order_PUB.Header_Rec_Type;
1213: l_rule_defined VARCHAR2(1);
1214: l_credit_check_rule_id NUMBER;
1215: l_credit_check_rule_rec OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type ;
1216: --

Line 1814: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

1810:
1811: -- Procedure Complete_Record
1812:
1813: PROCEDURE Complete_Record
1814: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
1815: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
1816: )
1817: IS
1818: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;

Line 1815: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type

1811: -- Procedure Complete_Record
1812:
1813: PROCEDURE Complete_Record
1814: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
1815: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
1816: )
1817: IS
1818: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;
1819: --

Line 1818: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;

1814: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
1815: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
1816: )
1817: IS
1818: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;
1819: --
1820: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1821: --
1822: BEGIN

Line 2269: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

2265:
2266: -- Procedure Convert_Miss_To_Null
2267:
2268: PROCEDURE Convert_Miss_To_Null
2269: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
2270: )
2271: IS
2272: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;
2273: --

Line 2272: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;

2268: PROCEDURE Convert_Miss_To_Null
2269: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
2270: )
2271: IS
2272: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;
2273: --
2274: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2275: --
2276: BEGIN

Line 2691: ( p_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

2687: -- Procedure Update_Row
2688:
2689:
2690: PROCEDURE Update_Row
2691: ( p_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
2692: )
2693: IS
2694: l_lock_control NUMBER;
2695: --added for notification framework

Line 2886: ( p_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

2882:
2883: -- Procedure Insert_Row
2884:
2885: PROCEDURE Insert_Row
2886: ( p_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
2887: )
2888: IS
2889: l_lock_control NUMBER := 1;
2890: --added for notification framework

Line 3221: l_new_header_adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

3217: FROM OE_PRICE_ADJUSTMENTS
3218: WHERE HEADER_ID = p_header_id;
3219:
3220: -- added for notification framework
3221: l_new_header_adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3222: l_index NUMBER;
3223:
3224: --
3225: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3396: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

3392:
3393:
3394: PROCEDURE Query_Row
3395: ( p_price_adjustment_id IN NUMBER
3396: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
3397: )
3398: IS
3399: l_Header_Adj_Tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3400: --

Line 3399: l_Header_Adj_Tbl OE_Order_PUB.Header_Adj_Tbl_Type;

3395: ( p_price_adjustment_id IN NUMBER
3396: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
3397: )
3398: IS
3399: l_Header_Adj_Tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3400: --
3401: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3402: --
3403: BEGIN

Line 3427: , x_Header_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type

3423: ( p_price_adjustment_id IN NUMBER :=
3424: FND_API.G_MISS_NUM
3425: , p_header_id IN NUMBER :=
3426: FND_API.G_MISS_NUM
3427: , x_Header_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
3428: )
3429: IS
3430: l_count NUMBER;
3431:

Line 3863: , p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

3859:
3860: PROCEDURE Lock_Row
3861: ( x_return_status OUT NOCOPY VARCHAR2
3862:
3863: , p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
3864: -- := OE_Order_PUB.G_MISS_HEADER_ADJ_REC
3865: , p_price_adjustment_id IN NUMBER
3866: := FND_API.G_MISS_NUM
3867: -- , x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type

Line 3864: -- := OE_Order_PUB.G_MISS_HEADER_ADJ_REC

3860: PROCEDURE Lock_Row
3861: ( x_return_status OUT NOCOPY VARCHAR2
3862:
3863: , p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
3864: -- := OE_Order_PUB.G_MISS_HEADER_ADJ_REC
3865: , p_price_adjustment_id IN NUMBER
3866: := FND_API.G_MISS_NUM
3867: -- , x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
3868: )

Line 3867: -- , x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type

3863: , p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
3864: -- := OE_Order_PUB.G_MISS_HEADER_ADJ_REC
3865: , p_price_adjustment_id IN NUMBER
3866: := FND_API.G_MISS_NUM
3867: -- , x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
3868: )
3869: IS
3870: l_price_adjustment_id NUMBER;
3871: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

Line 3871: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

3867: -- , x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
3868: )
3869: IS
3870: l_price_adjustment_id NUMBER;
3871: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3872: l_lock_control NUMBER;
3873: --
3874: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3875: --

Line 4025: , x_Header_Adj_tbl OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type

4021: ( p_price_adjustment_id IN NUMBER
4022: := FND_API.G_MISS_NUM
4023: , p_header_id IN NUMBER
4024: := FND_API.G_MISS_NUM
4025: , x_Header_Adj_tbl OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
4026: , x_return_status OUT NOCOPY VARCHAR2
4027:
4028: )
4029: IS

Line 4038: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

4034: WHERE header_id = p_header_id
4035: FOR UPDATE NOWAIT;
4036:
4037: l_price_adjustment_id NUMBER;
4038: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4039: l_lock_control NUMBER;
4040:
4041: --
4042: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4143: , p_adj_rec IN OE_order_pub.Header_Adj_Rec_Type

4139:
4140: PROCEDURE Log_Adj_Requests
4141: ( x_return_status OUT NOCOPY VARCHAR2
4142:
4143: , p_adj_rec IN OE_order_pub.Header_Adj_Rec_Type
4144: , p_old_adj_rec IN OE_order_pub.Header_Adj_Rec_Type
4145: , p_delete_flag IN BOOLEAN DEFAULT FALSE
4146: ) IS
4147:

Line 4144: , p_old_adj_rec IN OE_order_pub.Header_Adj_Rec_Type

4140: PROCEDURE Log_Adj_Requests
4141: ( x_return_status OUT NOCOPY VARCHAR2
4142:
4143: , p_adj_rec IN OE_order_pub.Header_Adj_Rec_Type
4144: , p_old_adj_rec IN OE_order_pub.Header_Adj_Rec_Type
4145: , p_delete_flag IN BOOLEAN DEFAULT FALSE
4146: ) IS
4147:
4148: --

Line 4194: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type

4190:
4191: -- Function Get_Values
4192:
4193: FUNCTION Get_Values
4194: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
4195: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
4196: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
4197: ) RETURN OE_Order_PUB.Header_Adj_Val_Rec_Type
4198: IS

Line 4195: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=

4191: -- Function Get_Values
4192:
4193: FUNCTION Get_Values
4194: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
4195: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
4196: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
4197: ) RETURN OE_Order_PUB.Header_Adj_Val_Rec_Type
4198: IS
4199: l_Header_Adj_val_rec OE_Order_PUB.Header_Adj_Val_Rec_Type;

Line 4196: OE_Order_PUB.G_MISS_HEADER_ADJ_REC

4192:
4193: FUNCTION Get_Values
4194: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
4195: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
4196: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
4197: ) RETURN OE_Order_PUB.Header_Adj_Val_Rec_Type
4198: IS
4199: l_Header_Adj_val_rec OE_Order_PUB.Header_Adj_Val_Rec_Type;
4200: --

Line 4197: ) RETURN OE_Order_PUB.Header_Adj_Val_Rec_Type

4193: FUNCTION Get_Values
4194: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
4195: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
4196: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
4197: ) RETURN OE_Order_PUB.Header_Adj_Val_Rec_Type
4198: IS
4199: l_Header_Adj_val_rec OE_Order_PUB.Header_Adj_Val_Rec_Type;
4200: --
4201: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4199: l_Header_Adj_val_rec OE_Order_PUB.Header_Adj_Val_Rec_Type;

4195: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
4196: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
4197: ) RETURN OE_Order_PUB.Header_Adj_Val_Rec_Type
4198: IS
4199: l_Header_Adj_val_rec OE_Order_PUB.Header_Adj_Val_Rec_Type;
4200: --
4201: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4202: --
4203: BEGIN

Line 4222: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

4218:
4219: -- Procedure Get_Ids
4220:
4221: PROCEDURE Get_Ids
4222: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
4223: , p_Header_Adj_val_rec IN OE_Order_PUB.Header_Adj_Val_Rec_Type
4224: )
4225: IS
4226: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

Line 4223: , p_Header_Adj_val_rec IN OE_Order_PUB.Header_Adj_Val_Rec_Type

4219: -- Procedure Get_Ids
4220:
4221: PROCEDURE Get_Ids
4222: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
4223: , p_Header_Adj_val_rec IN OE_Order_PUB.Header_Adj_Val_Rec_Type
4224: )
4225: IS
4226: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
4227: --

Line 4226: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

4222: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
4223: , p_Header_Adj_val_rec IN OE_Order_PUB.Header_Adj_Val_Rec_Type
4224: )
4225: IS
4226: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
4227: --
4228: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4229: --
4230: BEGIN

Line 4469: (p_x_header_adj_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.header_adj_rec_type,

4465: END get_line_adjustments;
4466:
4467: /* Start AuditTrail */
4468: PROCEDURE Pre_Write_Process
4469: (p_x_header_adj_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.header_adj_rec_type,
4470: p_old_header_adj_rec IN OE_ORDER_PUB.header_adj_rec_type := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC) IS
4471: /*local */
4472: l_return_status varchar2(30);
4473: --

Line 4470: p_old_header_adj_rec IN OE_ORDER_PUB.header_adj_rec_type := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC) IS

4466:
4467: /* Start AuditTrail */
4468: PROCEDURE Pre_Write_Process
4469: (p_x_header_adj_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.header_adj_rec_type,
4470: p_old_header_adj_rec IN OE_ORDER_PUB.header_adj_rec_type := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC) IS
4471: /*local */
4472: l_return_status varchar2(30);
4473: --
4474: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4569: l_from_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

4565: )
4566: is
4567: l_copy_freight_charge VARCHAR2(1);
4568: l_from_order_category VARCHAR2(30);
4569: l_from_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4570: l_from_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4571: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4572: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4573: i pls_integer;

Line 4570: l_from_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;

4566: is
4567: l_copy_freight_charge VARCHAR2(1);
4568: l_from_order_category VARCHAR2(30);
4569: l_from_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4570: l_from_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4571: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4572: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4573: i pls_integer;
4574: j pls_integer;

Line 4571: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

4567: l_copy_freight_charge VARCHAR2(1);
4568: l_from_order_category VARCHAR2(30);
4569: l_from_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4570: l_from_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4571: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4572: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4573: i pls_integer;
4574: j pls_integer;
4575: l_control_rec OE_Globals.Control_rec_type;

Line 4572: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;

4568: l_from_order_category VARCHAR2(30);
4569: l_from_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4570: l_from_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4571: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4572: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4573: i pls_integer;
4574: j pls_integer;
4575: l_control_rec OE_Globals.Control_rec_type;
4576: l_header_rec OE_Order_PUB.Header_Rec_Type;

Line 4576: l_header_rec OE_Order_PUB.Header_Rec_Type;

4572: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4573: i pls_integer;
4574: j pls_integer;
4575: l_control_rec OE_Globals.Control_rec_type;
4576: l_header_rec OE_Order_PUB.Header_Rec_Type;
4577: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4578: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4579: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4580: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 4577: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;

4573: i pls_integer;
4574: j pls_integer;
4575: l_control_rec OE_Globals.Control_rec_type;
4576: l_header_rec OE_Order_PUB.Header_Rec_Type;
4577: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4578: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4579: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4580: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4581: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 4578: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;

4574: j pls_integer;
4575: l_control_rec OE_Globals.Control_rec_type;
4576: l_header_rec OE_Order_PUB.Header_Rec_Type;
4577: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4578: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4579: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4580: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4581: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4582: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;

Line 4579: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

4575: l_control_rec OE_Globals.Control_rec_type;
4576: l_header_rec OE_Order_PUB.Header_Rec_Type;
4577: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4578: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4579: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4580: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4581: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4582: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4583: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;

Line 4580: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

4576: l_header_rec OE_Order_PUB.Header_Rec_Type;
4577: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4578: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4579: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4580: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4581: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4582: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4583: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4584: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;

Line 4581: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

4577: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4578: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4579: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4580: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4581: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4582: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4583: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4584: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4585: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 4582: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;

4578: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4579: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4580: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4581: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4582: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4583: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4584: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4585: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4586: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

Line 4583: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;

4579: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4580: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4581: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4582: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4583: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4584: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4585: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4586: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4587: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

Line 4584: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;

4580: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4581: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4582: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4583: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4584: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4585: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4586: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4587: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4588: l_x_msg_count NUMBER;

Line 4585: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

4581: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4582: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4583: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4584: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4585: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4586: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4587: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4588: l_x_msg_count NUMBER;
4589: l_x_msg_data VARCHAR2(2000);

Line 4586: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

4582: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4583: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4584: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4585: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4586: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4587: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4588: l_x_msg_count NUMBER;
4589: l_x_msg_data VARCHAR2(2000);
4590:

Line 4587: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

4583: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4584: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4585: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4586: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4587: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4588: l_x_msg_count NUMBER;
4589: l_x_msg_data VARCHAR2(2000);
4590:
4591: cursor c1

Line 4750: l_from_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

4746: )
4747: is
4748: l_copy_freight_charge VARCHAR2(1);
4749: l_from_order_category VARCHAR2(30);
4750: l_from_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4751: l_from_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4752: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4753: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4754: i pls_integer;

Line 4751: l_from_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;

4747: is
4748: l_copy_freight_charge VARCHAR2(1);
4749: l_from_order_category VARCHAR2(30);
4750: l_from_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4751: l_from_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4752: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4753: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4754: i pls_integer;
4755: j pls_integer;

Line 4752: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

4748: l_copy_freight_charge VARCHAR2(1);
4749: l_from_order_category VARCHAR2(30);
4750: l_from_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4751: l_from_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4752: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4753: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4754: i pls_integer;
4755: j pls_integer;
4756: l_control_rec OE_Globals.Control_rec_type;

Line 4753: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;

4749: l_from_order_category VARCHAR2(30);
4750: l_from_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4751: l_from_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4752: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4753: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4754: i pls_integer;
4755: j pls_integer;
4756: l_control_rec OE_Globals.Control_rec_type;
4757: l_header_rec OE_Order_PUB.Header_Rec_Type;

Line 4757: l_header_rec OE_Order_PUB.Header_Rec_Type;

4753: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4754: i pls_integer;
4755: j pls_integer;
4756: l_control_rec OE_Globals.Control_rec_type;
4757: l_header_rec OE_Order_PUB.Header_Rec_Type;
4758: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4759: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4760: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4761: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 4758: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;

4754: i pls_integer;
4755: j pls_integer;
4756: l_control_rec OE_Globals.Control_rec_type;
4757: l_header_rec OE_Order_PUB.Header_Rec_Type;
4758: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4759: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4760: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4761: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4762: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 4759: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;

4755: j pls_integer;
4756: l_control_rec OE_Globals.Control_rec_type;
4757: l_header_rec OE_Order_PUB.Header_Rec_Type;
4758: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4759: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4760: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4761: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4762: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4763: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;

Line 4760: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

4756: l_control_rec OE_Globals.Control_rec_type;
4757: l_header_rec OE_Order_PUB.Header_Rec_Type;
4758: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4759: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4760: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4761: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4762: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4763: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4764: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;

Line 4761: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

4757: l_header_rec OE_Order_PUB.Header_Rec_Type;
4758: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4759: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4760: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4761: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4762: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4763: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4764: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4765: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;

Line 4762: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

4758: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4759: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4760: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4761: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4762: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4763: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4764: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4765: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4766: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 4763: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;

4759: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4760: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4761: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4762: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4763: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4764: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4765: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4766: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4767: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

Line 4764: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;

4760: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4761: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4762: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4763: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4764: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4765: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4766: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4767: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4768: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

Line 4765: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;

4761: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4762: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4763: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4764: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4765: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4766: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4767: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4768: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4769: l_x_msg_count NUMBER;

Line 4766: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

4762: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4763: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4764: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4765: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4766: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4767: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4768: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4769: l_x_msg_count NUMBER;
4770: l_x_msg_data VARCHAR2(2000);

Line 4767: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

4763: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4764: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4765: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4766: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4767: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4768: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4769: l_x_msg_count NUMBER;
4770: l_x_msg_data VARCHAR2(2000);
4771:

Line 4768: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

4764: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4765: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4766: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4767: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4768: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4769: l_x_msg_count NUMBER;
4770: l_x_msg_data VARCHAR2(2000);
4771:
4772: cursor c1

Line 4778: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

4774: select order_category_code
4775: from oe_order_headers
4776: where header_id = p_from_header_id;
4777: --serla begin
4778: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4779: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4780: --serla end
4781: --
4782: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4779: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

4775: from oe_order_headers
4776: where header_id = p_from_header_id;
4777: --serla begin
4778: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4779: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4780: --serla end
4781: --
4782: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4783: --