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 1858: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

1854:
1855: -- Procedure Complete_Record
1856:
1857: PROCEDURE Complete_Record
1858: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
1859: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
1860: )
1861: IS
1862: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;

Line 1859: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type

1855: -- Procedure Complete_Record
1856:
1857: PROCEDURE Complete_Record
1858: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
1859: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
1860: )
1861: IS
1862: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;
1863: --

Line 1862: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;

1858: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
1859: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
1860: )
1861: IS
1862: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;
1863: --
1864: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1865: --
1866: BEGIN

Line 2320: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

2316:
2317: -- Procedure Convert_Miss_To_Null
2318:
2319: PROCEDURE Convert_Miss_To_Null
2320: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
2321: )
2322: IS
2323: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;
2324: --

Line 2323: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;

2319: PROCEDURE Convert_Miss_To_Null
2320: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
2321: )
2322: IS
2323: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;
2324: --
2325: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2326: --
2327: BEGIN

Line 2748: ( p_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

2744: -- Procedure Update_Row
2745:
2746:
2747: PROCEDURE Update_Row
2748: ( p_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
2749: )
2750: IS
2751: l_lock_control NUMBER;
2752: --added for notification framework

Line 2943: ( p_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

2939:
2940: -- Procedure Insert_Row
2941:
2942: PROCEDURE Insert_Row
2943: ( p_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
2944: )
2945: IS
2946: l_lock_control NUMBER := 1;
2947: --added for notification framework

Line 3280: l_new_header_adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

3276: FROM OE_PRICE_ADJUSTMENTS
3277: WHERE HEADER_ID = p_header_id;
3278:
3279: -- added for notification framework
3280: l_new_header_adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3281: l_index NUMBER;
3282:
3283: --
3284: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3455: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

3451:
3452:
3453: PROCEDURE Query_Row
3454: ( p_price_adjustment_id IN NUMBER
3455: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
3456: )
3457: IS
3458: l_Header_Adj_Tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3459: --

Line 3458: l_Header_Adj_Tbl OE_Order_PUB.Header_Adj_Tbl_Type;

3454: ( p_price_adjustment_id IN NUMBER
3455: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
3456: )
3457: IS
3458: l_Header_Adj_Tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3459: --
3460: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3461: --
3462: BEGIN

Line 3486: , x_Header_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type

3482: ( p_price_adjustment_id IN NUMBER :=
3483: FND_API.G_MISS_NUM
3484: , p_header_id IN NUMBER :=
3485: FND_API.G_MISS_NUM
3486: , x_Header_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
3487: )
3488: IS
3489: l_count NUMBER;
3490:

Line 3922: , p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

3918:
3919: PROCEDURE Lock_Row
3920: ( x_return_status OUT NOCOPY VARCHAR2
3921:
3922: , p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
3923: -- := OE_Order_PUB.G_MISS_HEADER_ADJ_REC
3924: , p_price_adjustment_id IN NUMBER
3925: := FND_API.G_MISS_NUM
3926: -- , x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type

Line 3923: -- := OE_Order_PUB.G_MISS_HEADER_ADJ_REC

3919: PROCEDURE Lock_Row
3920: ( x_return_status OUT NOCOPY VARCHAR2
3921:
3922: , p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
3923: -- := OE_Order_PUB.G_MISS_HEADER_ADJ_REC
3924: , p_price_adjustment_id IN NUMBER
3925: := FND_API.G_MISS_NUM
3926: -- , x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
3927: )

Line 3926: -- , x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type

3922: , p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
3923: -- := OE_Order_PUB.G_MISS_HEADER_ADJ_REC
3924: , p_price_adjustment_id IN NUMBER
3925: := FND_API.G_MISS_NUM
3926: -- , x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
3927: )
3928: IS
3929: l_price_adjustment_id NUMBER;
3930: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

Line 3930: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

3926: -- , x_Header_Adj_rec OUT OE_Order_PUB.Header_Adj_Rec_Type
3927: )
3928: IS
3929: l_price_adjustment_id NUMBER;
3930: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3931: l_lock_control NUMBER;
3932: --
3933: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3934: --

Line 4084: , x_Header_Adj_tbl OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type

4080: ( p_price_adjustment_id IN NUMBER
4081: := FND_API.G_MISS_NUM
4082: , p_header_id IN NUMBER
4083: := FND_API.G_MISS_NUM
4084: , x_Header_Adj_tbl OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
4085: , x_return_status OUT NOCOPY VARCHAR2
4086:
4087: )
4088: IS

Line 4097: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

4093: WHERE header_id = p_header_id
4094: FOR UPDATE NOWAIT;
4095:
4096: l_price_adjustment_id NUMBER;
4097: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4098: l_lock_control NUMBER;
4099:
4100: --
4101: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4202: , p_adj_rec IN OE_order_pub.Header_Adj_Rec_Type

4198:
4199: PROCEDURE Log_Adj_Requests
4200: ( x_return_status OUT NOCOPY VARCHAR2
4201:
4202: , p_adj_rec IN OE_order_pub.Header_Adj_Rec_Type
4203: , p_old_adj_rec IN OE_order_pub.Header_Adj_Rec_Type
4204: , p_delete_flag IN BOOLEAN DEFAULT FALSE
4205: ) IS
4206:

Line 4203: , p_old_adj_rec IN OE_order_pub.Header_Adj_Rec_Type

4199: PROCEDURE Log_Adj_Requests
4200: ( x_return_status OUT NOCOPY VARCHAR2
4201:
4202: , p_adj_rec IN OE_order_pub.Header_Adj_Rec_Type
4203: , p_old_adj_rec IN OE_order_pub.Header_Adj_Rec_Type
4204: , p_delete_flag IN BOOLEAN DEFAULT FALSE
4205: ) IS
4206:
4207: --

Line 4253: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type

4249:
4250: -- Function Get_Values
4251:
4252: FUNCTION Get_Values
4253: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
4254: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
4255: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
4256: ) RETURN OE_Order_PUB.Header_Adj_Val_Rec_Type
4257: IS

Line 4254: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=

4250: -- Function Get_Values
4251:
4252: FUNCTION Get_Values
4253: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
4254: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
4255: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
4256: ) RETURN OE_Order_PUB.Header_Adj_Val_Rec_Type
4257: IS
4258: l_Header_Adj_val_rec OE_Order_PUB.Header_Adj_Val_Rec_Type;

Line 4255: OE_Order_PUB.G_MISS_HEADER_ADJ_REC

4251:
4252: FUNCTION Get_Values
4253: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
4254: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
4255: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
4256: ) RETURN OE_Order_PUB.Header_Adj_Val_Rec_Type
4257: IS
4258: l_Header_Adj_val_rec OE_Order_PUB.Header_Adj_Val_Rec_Type;
4259: --

Line 4256: ) RETURN OE_Order_PUB.Header_Adj_Val_Rec_Type

4252: FUNCTION Get_Values
4253: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
4254: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
4255: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
4256: ) RETURN OE_Order_PUB.Header_Adj_Val_Rec_Type
4257: IS
4258: l_Header_Adj_val_rec OE_Order_PUB.Header_Adj_Val_Rec_Type;
4259: --
4260: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4258: l_Header_Adj_val_rec OE_Order_PUB.Header_Adj_Val_Rec_Type;

4254: , p_old_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type :=
4255: OE_Order_PUB.G_MISS_HEADER_ADJ_REC
4256: ) RETURN OE_Order_PUB.Header_Adj_Val_Rec_Type
4257: IS
4258: l_Header_Adj_val_rec OE_Order_PUB.Header_Adj_Val_Rec_Type;
4259: --
4260: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4261: --
4262: BEGIN

Line 4281: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

4277:
4278: -- Procedure Get_Ids
4279:
4280: PROCEDURE Get_Ids
4281: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
4282: , p_Header_Adj_val_rec IN OE_Order_PUB.Header_Adj_Val_Rec_Type
4283: )
4284: IS
4285: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

Line 4282: , p_Header_Adj_val_rec IN OE_Order_PUB.Header_Adj_Val_Rec_Type

4278: -- Procedure Get_Ids
4279:
4280: PROCEDURE Get_Ids
4281: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
4282: , p_Header_Adj_val_rec IN OE_Order_PUB.Header_Adj_Val_Rec_Type
4283: )
4284: IS
4285: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
4286: --

Line 4285: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

4281: ( p_x_Header_Adj_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
4282: , p_Header_Adj_val_rec IN OE_Order_PUB.Header_Adj_Val_Rec_Type
4283: )
4284: IS
4285: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
4286: --
4287: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4288: --
4289: BEGIN

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

4524: END get_line_adjustments;
4525:
4526: /* Start AuditTrail */
4527: PROCEDURE Pre_Write_Process
4528: (p_x_header_adj_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.header_adj_rec_type,
4529: p_old_header_adj_rec IN OE_ORDER_PUB.header_adj_rec_type := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC) IS
4530: /*local */
4531: l_return_status varchar2(30);
4532: --

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

4525:
4526: /* Start AuditTrail */
4527: PROCEDURE Pre_Write_Process
4528: (p_x_header_adj_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.header_adj_rec_type,
4529: p_old_header_adj_rec IN OE_ORDER_PUB.header_adj_rec_type := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC) IS
4530: /*local */
4531: l_return_status varchar2(30);
4532: --
4533: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4538: l_header_rec OE_Order_PUB.Header_Rec_Type; --TaxER

4534: --
4535: l_org_id NUMBER(15):=MO_GLOBAL.Get_Current_Org_Id; --TaxER
4536: l_current_event number := 0; --TaxER
4537: l_tax_calculation_event_code number := 0; --TaxER
4538: l_header_rec OE_Order_PUB.Header_Rec_Type; --TaxER
4539: BEGIN
4540:
4541: --11.5.10 Versioning/Audit Trail updates
4542: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND

Line 4725: l_from_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

4721: )
4722: is
4723: l_copy_freight_charge VARCHAR2(1);
4724: l_from_order_category VARCHAR2(30);
4725: l_from_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4726: l_from_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4727: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4728: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4729: i pls_integer;

Line 4726: l_from_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;

4722: is
4723: l_copy_freight_charge VARCHAR2(1);
4724: l_from_order_category VARCHAR2(30);
4725: l_from_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4726: l_from_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4727: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4728: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4729: i pls_integer;
4730: j pls_integer;

Line 4727: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

4723: l_copy_freight_charge VARCHAR2(1);
4724: l_from_order_category VARCHAR2(30);
4725: l_from_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4726: l_from_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4727: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4728: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4729: i pls_integer;
4730: j pls_integer;
4731: l_control_rec OE_Globals.Control_rec_type;

Line 4728: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;

4724: l_from_order_category VARCHAR2(30);
4725: l_from_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4726: l_from_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4727: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4728: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4729: i pls_integer;
4730: j pls_integer;
4731: l_control_rec OE_Globals.Control_rec_type;
4732: l_header_rec OE_Order_PUB.Header_Rec_Type;

Line 4732: l_header_rec OE_Order_PUB.Header_Rec_Type;

4728: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4729: i pls_integer;
4730: j pls_integer;
4731: l_control_rec OE_Globals.Control_rec_type;
4732: l_header_rec OE_Order_PUB.Header_Rec_Type;
4733: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4734: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4735: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4736: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 4733: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;

4729: i pls_integer;
4730: j pls_integer;
4731: l_control_rec OE_Globals.Control_rec_type;
4732: l_header_rec OE_Order_PUB.Header_Rec_Type;
4733: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4734: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4735: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4736: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4737: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 4734: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;

4730: j pls_integer;
4731: l_control_rec OE_Globals.Control_rec_type;
4732: l_header_rec OE_Order_PUB.Header_Rec_Type;
4733: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4734: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4735: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4736: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4737: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4738: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;

Line 4735: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

4731: l_control_rec OE_Globals.Control_rec_type;
4732: l_header_rec OE_Order_PUB.Header_Rec_Type;
4733: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4734: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4735: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4736: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4737: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4738: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4739: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;

Line 4736: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

4732: l_header_rec OE_Order_PUB.Header_Rec_Type;
4733: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4734: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4735: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4736: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4737: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4738: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4739: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4740: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;

Line 4737: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

4733: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4734: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4735: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4736: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4737: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4738: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4739: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4740: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4741: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 4738: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;

4734: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4735: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4736: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4737: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4738: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4739: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4740: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4741: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4742: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

Line 4739: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;

4735: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4736: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4737: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4738: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4739: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4740: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4741: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4742: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4743: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

Line 4740: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;

4736: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4737: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4738: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4739: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4740: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4741: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4742: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4743: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4744: l_x_msg_count NUMBER;

Line 4741: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

4737: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4738: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4739: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4740: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4741: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4742: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4743: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4744: l_x_msg_count NUMBER;
4745: l_x_msg_data VARCHAR2(2000);

Line 4742: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

4738: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4739: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4740: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4741: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4742: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4743: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4744: l_x_msg_count NUMBER;
4745: l_x_msg_data VARCHAR2(2000);
4746:

Line 4743: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

4739: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4740: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4741: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4742: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4743: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4744: l_x_msg_count NUMBER;
4745: l_x_msg_data VARCHAR2(2000);
4746:
4747: cursor c1

Line 4906: l_from_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

4902: )
4903: is
4904: l_copy_freight_charge VARCHAR2(1);
4905: l_from_order_category VARCHAR2(30);
4906: l_from_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4907: l_from_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4908: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4909: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4910: i pls_integer;

Line 4907: l_from_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;

4903: is
4904: l_copy_freight_charge VARCHAR2(1);
4905: l_from_order_category VARCHAR2(30);
4906: l_from_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4907: l_from_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4908: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4909: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4910: i pls_integer;
4911: j pls_integer;

Line 4908: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

4904: l_copy_freight_charge VARCHAR2(1);
4905: l_from_order_category VARCHAR2(30);
4906: l_from_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4907: l_from_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4908: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4909: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4910: i pls_integer;
4911: j pls_integer;
4912: l_control_rec OE_Globals.Control_rec_type;

Line 4909: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;

4905: l_from_order_category VARCHAR2(30);
4906: l_from_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4907: l_from_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4908: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4909: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4910: i pls_integer;
4911: j pls_integer;
4912: l_control_rec OE_Globals.Control_rec_type;
4913: l_header_rec OE_Order_PUB.Header_Rec_Type;

Line 4913: l_header_rec OE_Order_PUB.Header_Rec_Type;

4909: l_header_adj_att_tbl OE_Order_Pub.Header_Adj_Att_Tbl_Type;
4910: i pls_integer;
4911: j pls_integer;
4912: l_control_rec OE_Globals.Control_rec_type;
4913: l_header_rec OE_Order_PUB.Header_Rec_Type;
4914: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4915: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4916: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4917: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 4914: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;

4910: i pls_integer;
4911: j pls_integer;
4912: l_control_rec OE_Globals.Control_rec_type;
4913: l_header_rec OE_Order_PUB.Header_Rec_Type;
4914: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4915: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4916: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4917: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4918: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 4915: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;

4911: j pls_integer;
4912: l_control_rec OE_Globals.Control_rec_type;
4913: l_header_rec OE_Order_PUB.Header_Rec_Type;
4914: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4915: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4916: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4917: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4918: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4919: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;

Line 4916: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

4912: l_control_rec OE_Globals.Control_rec_type;
4913: l_header_rec OE_Order_PUB.Header_Rec_Type;
4914: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4915: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4916: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4917: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4918: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4919: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4920: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;

Line 4917: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

4913: l_header_rec OE_Order_PUB.Header_Rec_Type;
4914: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4915: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4916: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4917: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4918: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4919: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4920: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4921: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;

Line 4918: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

4914: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4915: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4916: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4917: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4918: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4919: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4920: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4921: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4922: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 4919: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;

4915: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4916: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4917: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4918: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4919: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4920: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4921: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4922: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4923: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

Line 4920: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;

4916: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4917: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4918: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4919: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4920: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4921: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4922: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4923: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4924: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

Line 4921: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;

4917: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4918: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4919: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4920: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4921: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4922: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4923: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4924: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4925: l_x_msg_count NUMBER;

Line 4922: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

4918: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4919: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4920: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4921: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4922: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4923: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4924: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4925: l_x_msg_count NUMBER;
4926: l_x_msg_data VARCHAR2(2000);

Line 4923: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

4919: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4920: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4921: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4922: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4923: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4924: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4925: l_x_msg_count NUMBER;
4926: l_x_msg_data VARCHAR2(2000);
4927:

Line 4924: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

4920: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4921: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4922: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4923: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4924: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4925: l_x_msg_count NUMBER;
4926: l_x_msg_data VARCHAR2(2000);
4927:
4928: cursor c1

Line 4934: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

4930: select order_category_code
4931: from oe_order_headers
4932: where header_id = p_from_header_id;
4933: --serla begin
4934: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4935: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4936: --serla end
4937: --
4938: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4935: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

4931: from oe_order_headers
4932: where header_id = p_from_header_id;
4933: --serla begin
4934: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4935: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4936: --serla end
4937: --
4938: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4939: --