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

Line 24: px_line_tbl IN Oe_Order_Pub.Line_Tbl_Type,

20: End If;
21: End Adj_Debug;
22:
23: procedure Sort_Line_Table(
24: px_line_tbl IN Oe_Order_Pub.Line_Tbl_Type,
25: px_price_line_id_tbl IN OUT NOCOPY Oe_Order_Adj_Pvt.Index_Tbl_Type)
26: IS
27: l_line_index Number;
28: --

Line 42: p_old_header_rec OE_Order_Pub.Header_Rec_Type,

38: End;
39:
40:
41: Procedure Call_Process_Order(
42: p_old_header_rec OE_Order_Pub.Header_Rec_Type,
43: px_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type,
44: px_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
45: px_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
46: p_control_rec IN OUT NOCOPY OE_GLOBALS.Control_Rec_Type,

Line 43: px_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type,

39:
40:
41: Procedure Call_Process_Order(
42: p_old_header_rec OE_Order_Pub.Header_Rec_Type,
43: px_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type,
44: px_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
45: px_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
46: p_control_rec IN OUT NOCOPY OE_GLOBALS.Control_Rec_Type,
47: x_return_status OUT NOCOPY VARCHAR2)

Line 44: px_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,

40:
41: Procedure Call_Process_Order(
42: p_old_header_rec OE_Order_Pub.Header_Rec_Type,
43: px_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type,
44: px_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
45: px_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
46: p_control_rec IN OUT NOCOPY OE_GLOBALS.Control_Rec_Type,
47: x_return_status OUT NOCOPY VARCHAR2)
48: IS

Line 45: px_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,

41: Procedure Call_Process_Order(
42: p_old_header_rec OE_Order_Pub.Header_Rec_Type,
43: px_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type,
44: px_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
45: px_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
46: p_control_rec IN OUT NOCOPY OE_GLOBALS.Control_Rec_Type,
47: x_return_status OUT NOCOPY VARCHAR2)
48: IS
49: lx_old_header_rec OE_Order_Pub.Header_Rec_Type := p_old_header_rec;

Line 49: lx_old_header_rec OE_Order_Pub.Header_Rec_Type := p_old_header_rec;

45: px_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
46: p_control_rec IN OUT NOCOPY OE_GLOBALS.Control_Rec_Type,
47: x_return_status OUT NOCOPY VARCHAR2)
48: IS
49: lx_old_header_rec OE_Order_Pub.Header_Rec_Type := p_old_header_rec;
50: l_line_index NUMBER;
51: -- process_order in variables
52:
53: I NUMBER;

Line 58: l_new_line_tbl OE_Order_Pub.Line_Tbl_Type;

54: l_msg_count NUMBER;
55: l_msg_data VARCHAR2(2000);
56: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
57: l_index NUMBER:=1;
58: l_new_line_tbl OE_Order_Pub.Line_Tbl_Type;
59: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;
60: --
61: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
62: --

Line 59: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;

55: l_msg_data VARCHAR2(2000);
56: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
57: l_index NUMBER:=1;
58: l_new_line_tbl OE_Order_Pub.Line_Tbl_Type;
59: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;
60: --
61: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
62: --
63: BEGIN

Line 153: px_line_rec in out nocopy OE_Order_PUB.line_rec_type

149: End Call_Process_Order;
150:
151: --Bug 13573144
152: procedure set_tsn(
153: px_line_rec in out nocopy OE_Order_PUB.line_rec_type
154: ,p_term varchar2
155: ,p_substitution_attribute varchar2
156: )
157: is

Line 175: px_line_rec in out nocopy OE_Order_PUB.line_rec_type

171: END IF;
172: end set_tsn;
173: --End of Bug 13573144
174: procedure set_item_for_iue(
175: px_line_rec in out nocopy OE_Order_PUB.line_rec_type
176: ,p_related_item_id NUMBER
177: )
178: is
179: l_org_id NUMBER := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

Line 239: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

235: Procedure delete_attribs_for_iue(
236: p_price_adjustment_id in number
237: ,p_modifier_level_code IN VARCHAR2 DEFAULT 'LINE') --Bug 13573144
238: is
239: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
240: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type; --Bug 13573144
241: l_return_status VARCHAR2(30);
242: l_index NUMBER;
243: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 240: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type; --Bug 13573144

236: p_price_adjustment_id in number
237: ,p_modifier_level_code IN VARCHAR2 DEFAULT 'LINE') --Bug 13573144
238: is
239: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
240: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type; --Bug 13573144
241: l_return_status VARCHAR2(30);
242: l_index NUMBER;
243: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
244:

Line 298: ( px_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,

294: DELETE FROM OE_PRICE_ADJ_ATTRIBS WHERE price_adjustment_id = p_price_adjustment_id;
295: End;
296:
297: Procedure Item_Upgrade
298: ( px_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
299: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
300: p_pricing_events IN VARCHAR2
301: )
302: IS

Line 299: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,

295: End;
296:
297: Procedure Item_Upgrade
298: ( px_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
299: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
300: p_pricing_events IN VARCHAR2
301: )
302: IS
303:

Line 526: , oe_order_pub.g_hdr.header_id --p_Line_Adj_rec.header_id

522: , NULL --p_Line_Adj_rec.program_application_id
523: , NULL --p_Line_Adj_rec.program_id
524: , NULL --p_Line_Adj_rec.program_update_date
525: , NULL --p_Line_Adj_rec.request_id
526: , oe_order_pub.g_hdr.header_id --p_Line_Adj_rec.header_id
527: , NULL --p_Line_Adj_rec.discount_id
528: , NULL --p_Line_Adj_rec.discount_line_id
529: , ldets.automatic_flag
530: , NULL --p_Line_Adj_rec.percent

Line 639: ( p_old_header_rec IN OE_ORDER_PUB.Header_Rec_Type,

635:
636:
637:
638: Procedure Term_Substitution
639: ( p_old_header_rec IN OE_ORDER_PUB.Header_Rec_Type,
640: px_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
641: px_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
642: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
643: p_pricing_events IN VARCHAR2 --Bug 13573144

Line 640: px_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,

636:
637:
638: Procedure Term_Substitution
639: ( p_old_header_rec IN OE_ORDER_PUB.Header_Rec_Type,
640: px_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
641: px_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
642: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
643: p_pricing_events IN VARCHAR2 --Bug 13573144
644: )

Line 641: px_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,

637:
638: Procedure Term_Substitution
639: ( p_old_header_rec IN OE_ORDER_PUB.Header_Rec_Type,
640: px_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
641: px_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
642: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
643: p_pricing_events IN VARCHAR2 --Bug 13573144
644: )
645: Is

Line 642: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,

638: Procedure Term_Substitution
639: ( p_old_header_rec IN OE_ORDER_PUB.Header_Rec_Type,
640: px_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
641: px_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
642: px_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
643: p_pricing_events IN VARCHAR2 --Bug 13573144
644: )
645: Is
646: cursor oe_price_adj_cur(p_line_id number) is

Line 739: -- l_header_rec OE_ORDER_PUB.Header_Rec_Type := oe_order_cache.g_header_rec;

735: l number;
736: --vcount number; --Bug 13573144
737: vcount number := 0; --Bug 13573144
738: m number;
739: -- l_header_rec OE_ORDER_PUB.Header_Rec_Type := oe_order_cache.g_header_rec;
740: --Bug 13573144
741: /*
742: --bug 4190357
743: l_count NUMBER;

Line 1160: , oe_order_pub.g_hdr.header_id --p_Line_Adj_rec.header_id

1156: , NULL --p_Line_Adj_rec.program_application_id
1157: , NULL --p_Line_Adj_rec.program_id
1158: , NULL --p_Line_Adj_rec.program_update_date
1159: , NULL --p_Line_Adj_rec.request_id
1160: , oe_order_pub.g_hdr.header_id --p_Line_Adj_rec.header_id
1161: , NULL --p_Line_Adj_rec.discount_id
1162: , NULL --p_Line_Adj_rec.discount_line_id
1163: , ldets.automatic_flag
1164: , NULL --p_Line_Adj_rec.percent

Line 1268: px_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type

1264: End Loop;
1265: END Term_Substitution;
1266:
1267: Procedure Set_Prg(
1268: px_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type
1269: , p_line_id IN QP_PREQ_LINES_TMP.line_id%TYPE
1270: , p_line_index IN QP_PREQ_LINES_TMP.line_index%TYPE
1271: , p_line_quantity IN QP_PREQ_LINES_TMP.line_quantity%TYPE
1272: , p_service_duration IN QP_PREQ_LINES_TMP.service_duration%TYPE DEFAULT NULL --Service ER 16227925

Line 1287: l_line_rec Oe_Order_Pub.line_rec_type := px_line_rec;

1283: , p_priced_uom_code IN QP_PREQ_LINES_TMP.priced_uom_code%TYPE
1284: , p_price_request_code IN QP_PREQ_LINES_TMP.price_request_code%TYPE
1285: )
1286: IS
1287: l_line_rec Oe_Order_Pub.line_rec_type := px_line_rec;
1288: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1289: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1290: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1291: l_pricing_event varchar2(30);

Line 1534: px_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type

1530: raise fnd_api.g_exc_error;
1531: end Set_Prg;
1532:
1533: Procedure Delete_Prg(
1534: px_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type
1535: )
1536: IS
1537: l_line_rec OE_Order_Pub.line_rec_type := px_line_rec;
1538: l_pricing_event varchar2(30);

Line 1537: l_line_rec OE_Order_Pub.line_rec_type := px_line_rec;

1533: Procedure Delete_Prg(
1534: px_line_rec IN OUT NOCOPY OE_Order_Pub.line_rec_type
1535: )
1536: IS
1537: l_line_rec OE_Order_Pub.line_rec_type := px_line_rec;
1538: l_pricing_event varchar2(30);
1539: l_return_status varchar2(1);
1540: --
1541: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1614: procedure Process_PRG(px_line_Tbl in out nocopy oe_order_pub.line_tbl_type

1610: When Others then
1611: Raise FND_API.G_EXC_ERROR;
1612: End Delete_Prg;
1613:
1614: procedure Process_PRG(px_line_Tbl in out nocopy oe_order_pub.line_tbl_type
1615: , px_old_line_tbl in out nocopy oe_order_pub.line_tbl_type
1616: , px_price_line_id_tbl IN OUT NOCOPY Oe_Order_Adj_Pvt.Index_Tbl_Type
1617: )
1618: IS

Line 1615: , px_old_line_tbl in out nocopy oe_order_pub.line_tbl_type

1611: Raise FND_API.G_EXC_ERROR;
1612: End Delete_Prg;
1613:
1614: procedure Process_PRG(px_line_Tbl in out nocopy oe_order_pub.line_tbl_type
1615: , px_old_line_tbl in out nocopy oe_order_pub.line_tbl_type
1616: , px_price_line_id_tbl IN OUT NOCOPY Oe_Order_Adj_Pvt.Index_Tbl_Type
1617: )
1618: IS
1619: cursor prg_lines IS

Line 1645: l_line_rec oe_order_pub.line_rec_type;

1641: , QP_PREQ_PUB.G_STATUS_UPDATED
1642: , QP_PREQ_PUB.G_STATUS_DELETED
1643: , 'FREEGOOD'
1644: );
1645: l_line_rec oe_order_pub.line_rec_type;
1646: l_buy_line_rec oe_order_pub.line_rec_type;
1647: l_parent_line_index pls_integer;
1648: l_parent_line_id number ; -- pls_integer; bug 8631297
1649: l_return_status varchar2(1);

Line 1646: l_buy_line_rec oe_order_pub.line_rec_type;

1642: , QP_PREQ_PUB.G_STATUS_DELETED
1643: , 'FREEGOOD'
1644: );
1645: l_line_rec oe_order_pub.line_rec_type;
1646: l_buy_line_rec oe_order_pub.line_rec_type;
1647: l_parent_line_index pls_integer;
1648: l_parent_line_id number ; -- pls_integer; bug 8631297
1649: l_return_status varchar2(1);
1650: E_CLOSED_LINE Exception;

Line 1783: l_line_rec:=OE_ORDER_PUB.G_MISS_LINE_REC;

1779: IF (l_line_rec.operation <> OE_GLOBALS.G_OPR_NONE) THEN
1780: px_line_tbl(px_price_line_id_tbl(l_mod_line_id)) := l_line_rec; -- Bug 8631297
1781: END IF;
1782: Elsif (i.Process_Status = QP_PREQ_PUB.G_STATUS_NEW) THEN
1783: l_line_rec:=OE_ORDER_PUB.G_MISS_LINE_REC;
1784: l_line_rec.cancelled_quantity := 0;
1785: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1786: l_line_rec.Header_id := oe_order_cache.g_header_rec.header_id;
1787: l_line_rec.line_id := OE_DEFAULT_LINE.get_line;

Line 2294: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

2290: AND ldets.list_line_type_code<>'PLL'
2291:
2292: AND (l_booked_flag = 'N' or ldets.list_line_type_code<>'IUE');
2293:
2294: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2295: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2296: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2297: l_index NUMBER;
2298: l_return_status VARCHAR2(1);

Line 2295: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

2291:
2292: AND (l_booked_flag = 'N' or ldets.list_line_type_code<>'IUE');
2293:
2294: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2295: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2296: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2297: l_index NUMBER;
2298: l_return_status VARCHAR2(1);
2299: l_qty NUMBER; --Bug8467307

Line 2316: l_Line_Adj_rec.header_id := oe_order_pub.g_hdr.header_id;

2312: l_Line_Adj_rec.created_by := fnd_global.user_id;
2313: l_Line_Adj_rec.last_update_date := sysdate;
2314: l_Line_Adj_rec.last_updated_by := fnd_global.user_id;
2315: l_Line_Adj_rec.last_update_login := fnd_global.user_id;
2316: l_Line_Adj_rec.header_id := oe_order_pub.g_hdr.header_id;
2317: l_Line_Adj_rec.automatic_flag := l_insert.auto_flag;
2318: l_Line_Adj_rec.LIST_HEADER_ID := l_insert.LIST_HEADER_ID;
2319: l_Line_Adj_rec.LIST_LINE_ID := l_insert.LIST_LINE_ID;
2320: l_Line_Adj_rec.LIST_LINE_TYPE_CODE := l_insert.LIST_LINE_TYPE_CODE;

Line 2434: l_Header_Adj_rec.header_id := oe_order_pub.g_hdr.header_id;

2430: l_Header_Adj_rec.created_by := fnd_global.user_id;
2431: l_Header_Adj_rec.last_update_date := sysdate;
2432: l_Header_Adj_rec.last_updated_by := fnd_global.user_id;
2433: l_Header_Adj_rec.last_update_login := fnd_global.user_id;
2434: l_Header_Adj_rec.header_id := oe_order_pub.g_hdr.header_id;
2435: l_Header_Adj_rec.automatic_flag := l_insert.auto_flag;
2436: l_Header_Adj_rec.LIST_HEADER_ID := l_insert.LIST_HEADER_ID;
2437: l_Header_Adj_rec.LIST_LINE_ID := l_insert.LIST_LINE_ID;
2438: l_Header_Adj_rec.LIST_LINE_TYPE_CODE := l_insert.LIST_LINE_TYPE_CODE;

Line 2541: px_line_Tbl IN OUT NOCOPY oe_Order_Pub.Line_Tbl_Type

2537:
2538:
2539: --bug 3702538
2540: procedure Register_price_list(
2541: px_line_Tbl IN OUT NOCOPY oe_Order_Pub.Line_Tbl_Type
2542: )
2543: IS
2544:
2545: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2587: px_line_Tbl IN OUT NOCOPY oe_Order_Pub.Line_Tbl_Type,

2583: (
2584: x_return_status OUT NOCOPY Varchar2,
2585: p_Control_Rec IN OE_ORDER_PRICE_PVT.Control_rec_type,
2586: p_any_frozen_line IN Boolean,
2587: px_line_Tbl IN OUT NOCOPY oe_Order_Pub.Line_Tbl_Type,
2588: px_old_line_Tbl IN OUT NOCOPY oe_order_pub.line_tbl_type,
2589: p_header_id IN number,
2590: p_line_id IN number,
2591: p_header_rec IN oe_Order_Pub.header_rec_type,

Line 2588: px_old_line_Tbl IN OUT NOCOPY oe_order_pub.line_tbl_type,

2584: x_return_status OUT NOCOPY Varchar2,
2585: p_Control_Rec IN OE_ORDER_PRICE_PVT.Control_rec_type,
2586: p_any_frozen_line IN Boolean,
2587: px_line_Tbl IN OUT NOCOPY oe_Order_Pub.Line_Tbl_Type,
2588: px_old_line_Tbl IN OUT NOCOPY oe_order_pub.line_tbl_type,
2589: p_header_id IN number,
2590: p_line_id IN number,
2591: p_header_rec IN oe_Order_Pub.header_rec_type,
2592: p_pricing_events IN varchar2

Line 2591: p_header_rec IN oe_Order_Pub.header_rec_type,

2587: px_line_Tbl IN OUT NOCOPY oe_Order_Pub.Line_Tbl_Type,
2588: px_old_line_Tbl IN OUT NOCOPY oe_order_pub.line_tbl_type,
2589: p_header_id IN number,
2590: p_line_id IN number,
2591: p_header_rec IN oe_Order_Pub.header_rec_type,
2592: p_pricing_events IN varchar2
2593: ) IS
2594:
2595: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 2596: lx_new_header_rec oe_Order_Pub.header_rec_type := p_header_rec;

2592: p_pricing_events IN varchar2
2593: ) IS
2594:
2595: l_control_rec OE_GLOBALS.Control_Rec_Type;
2596: lx_new_header_rec oe_Order_Pub.header_rec_type := p_header_rec;
2597: l_notify_flag BOOLEAN;
2598: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
2599:
2600:

Line 2792: , decode(p_header_id, NULL, oe_order_pub.g_hdr.header_id, p_header_id) --p_Line_Adj_rec.header_id

2788: , NULL --p_Line_Adj_rec.program_application_id
2789: , NULL --p_Line_Adj_rec.program_id
2790: , NULL --p_Line_Adj_rec.program_update_date
2791: , NULL --p_Line_Adj_rec.request_id
2792: , decode(p_header_id, NULL, oe_order_pub.g_hdr.header_id, p_header_id) --p_Line_Adj_rec.header_id
2793: , NULL --p_Line_Adj_rec.discount_id
2794: , NULL --p_Line_Adj_rec.discount_line_id
2795: , ldets.automatic_flag
2796: , NULL --p_Line_Adj_rec.percent