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

Line 24: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

20:
21: -- Added 09-DEC-2002
22: -- Forward declaration of LOCAL PROCEDURE Log_Blanket_Request
23: PROCEDURE Log_Blanket_Request
24: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
25: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
26: );
27:
28: Procedure Log_Dropship_CMS_Request

Line 25: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

21: -- Added 09-DEC-2002
22: -- Forward declaration of LOCAL PROCEDURE Log_Blanket_Request
23: PROCEDURE Log_Blanket_Request
24: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
25: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
26: );
27:
28: Procedure Log_Dropship_CMS_Request
29: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

Line 29: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

25: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
26: );
27:
28: Procedure Log_Dropship_CMS_Request
29: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
30: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
31: );
32:
33: PROCEDURE get_customer_details

Line 30: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

26: );
27:
28: Procedure Log_Dropship_CMS_Request
29: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
30: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
31: );
32:
33: PROCEDURE get_customer_details
34: ( p_org_id IN NUMBER

Line 51: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

47: , x_country OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
48:
49: ------------------------------------------------------------
50: PROCEDURE Log_CTO_Requests
51: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
52: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
53: OE_Order_PUB.G_MISS_LINE_REC
54: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
55:

Line 52: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

48:
49: ------------------------------------------------------------
50: PROCEDURE Log_CTO_Requests
51: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
52: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
53: OE_Order_PUB.G_MISS_LINE_REC
54: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
55:
56: PROCEDURE Log_Config_Requests

Line 53: OE_Order_PUB.G_MISS_LINE_REC

49: ------------------------------------------------------------
50: PROCEDURE Log_CTO_Requests
51: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
52: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
53: OE_Order_PUB.G_MISS_LINE_REC
54: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
55:
56: PROCEDURE Log_Config_Requests
57: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

Line 57: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

53: OE_Order_PUB.G_MISS_LINE_REC
54: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
55:
56: PROCEDURE Log_Config_Requests
57: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
58: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
59: OE_Order_PUB.G_MISS_LINE_REC
60: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
61:

Line 58: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

54: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
55:
56: PROCEDURE Log_Config_Requests
57: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
58: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
59: OE_Order_PUB.G_MISS_LINE_REC
60: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
61:
62: PROCEDURE Log_Cascade_Requests

Line 59: OE_Order_PUB.G_MISS_LINE_REC

55:
56: PROCEDURE Log_Config_Requests
57: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
58: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
59: OE_Order_PUB.G_MISS_LINE_REC
60: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
61:
62: PROCEDURE Log_Cascade_Requests
63: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

Line 63: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

59: OE_Order_PUB.G_MISS_LINE_REC
60: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
61:
62: PROCEDURE Log_Cascade_Requests
63: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
64: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
65: OE_Order_PUB.G_MISS_LINE_REC
66: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
67: --------------------------------------------------------------

Line 64: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

60: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
61:
62: PROCEDURE Log_Cascade_Requests
63: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
64: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
65: OE_Order_PUB.G_MISS_LINE_REC
66: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
67: --------------------------------------------------------------
68:

Line 65: OE_Order_PUB.G_MISS_LINE_REC

61:
62: PROCEDURE Log_Cascade_Requests
63: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
64: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
65: OE_Order_PUB.G_MISS_LINE_REC
66: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
67: --------------------------------------------------------------
68:
69:

Line 95: l_delete_lines_tbl OE_ORDER_PUB.Request_Tbl_Type; -- For bug 3754586

91: l_set_tbl_count number;
92: l_header_id number;
93:
94: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
95: l_delete_lines_tbl OE_ORDER_PUB.Request_Tbl_Type; -- For bug 3754586
96: BEGIN
97: if l_debug_level > 0 then
98: oe_debug_pub.add('Entering in Delete Dependents');
99: end if;

Line 291: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

287: END Delete_Dependents;
288:
289:
290: Procedure Calc_Catchweight_Return_qty2
291: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
292: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type) IS
293: x_item_rec OE_ORDER_CACHE.item_rec_type;
294: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
295:

Line 292: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type) IS

288:
289:
290: Procedure Calc_Catchweight_Return_qty2
291: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
292: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type) IS
293: x_item_rec OE_ORDER_CACHE.item_rec_type;
294: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
295:
296: BEGIN

Line 364: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

360: Procedure Apply_Attribute_Changes
361: -----------------------------------------------------------*/
362:
363: PROCEDURE Apply_Attribute_Changes
364: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
365: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
366: OE_Order_PUB.G_MISS_LINE_REC
367: )
368: IS

Line 365: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

361: -----------------------------------------------------------*/
362:
363: PROCEDURE Apply_Attribute_Changes
364: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
365: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
366: OE_Order_PUB.G_MISS_LINE_REC
367: )
368: IS
369: l_temp_pricing_quantity NUMBER:=0;

Line 366: OE_Order_PUB.G_MISS_LINE_REC

362:
363: PROCEDURE Apply_Attribute_Changes
364: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
365: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
366: OE_Order_PUB.G_MISS_LINE_REC
367: )
368: IS
369: l_temp_pricing_quantity NUMBER:=0;
370: L_RETURN_STATUS VARCHAR2(1);

Line 378: l_x_line_Tbl OE_Order_PUB.Line_Tbl_Type;

374: l_explosion_date_changed VARCHAR2(1) := FND_API.G_FALSE;
375: l_ordered_quantity_changed VARCHAR2(1) := FND_API.G_FALSE;
376: l_shipping_unique_key1 VARCHAR2(30);
377: l_shipping_param1 VARCHAR2(240);
378: l_x_line_Tbl OE_Order_PUB.Line_Tbl_Type;
379: l_temp_shipped_quantity NUMBER;
380: l_validated_quantity NUMBER;
381: l_primary_quantity NUMBER;
382: l_qty_return_status VARCHAR2(1);

Line 411: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

407: --OPM 06/SEP/00 END
408: --OPM BUG 1491504 BEGIN
409: l_ordered_quantity NUMBER := p_x_line_rec.ordered_quantity;
410: l_ordered_quantity2 NUMBER := p_x_line_rec.ordered_quantity2;
411: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
412: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
413: l_control_rec OE_GLOBALS.Control_Rec_Type;
414: --OPM BUG 1491504 END
415: /* csheu -- bug #1533658 start*/

Line 412: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

408: --OPM BUG 1491504 BEGIN
409: l_ordered_quantity NUMBER := p_x_line_rec.ordered_quantity;
410: l_ordered_quantity2 NUMBER := p_x_line_rec.ordered_quantity2;
411: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
412: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
413: l_control_rec OE_GLOBALS.Control_Rec_Type;
414: --OPM BUG 1491504 END
415: /* csheu -- bug #1533658 start*/
416: l_copy_service_fields boolean := FALSE;

Line 5297: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

5293: PROCEDURE Complete_Record
5294: -----------------------------------------------------------*/
5295:
5296: PROCEDURE Complete_Record
5297: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
5298: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
5299: )
5300: IS
5301: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 5298: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

5294: -----------------------------------------------------------*/
5295:
5296: PROCEDURE Complete_Record
5297: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
5298: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
5299: )
5300: IS
5301: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5302: BEGIN

Line 6740: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

6736: PROCEDURE Convert_Miss_To_Null
6737: -----------------------------------------------------------*/
6738:
6739: PROCEDURE Convert_Miss_To_Null
6740: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
6741: )
6742: IS
6743: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6744: BEGIN

Line 8141: ( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

8137: Procedure Update_Row
8138: -----------------------------------------------------------*/
8139:
8140: PROCEDURE Update_Row
8141: ( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
8142: )
8143: IS
8144: l_org_id NUMBER;
8145: l_lock_control NUMBER;

Line 8603: ( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

8599: Procedure Insert_Row
8600: -----------------------------------------------------------*/
8601:
8602: PROCEDURE Insert_Row
8603: ( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
8604: )
8605: IS
8606: l_org_id NUMBER ;
8607: l_sold_from_org NUMBER;

Line 9462: l_line_rec oe_order_pub.line_rec_type;

9458: ,p_header_id IN NUMBER := FND_API.G_MISS_NUM)
9459: IS
9460: l_return_status VARCHAR2(30);
9461: l_org_id NUMBER;
9462: l_line_rec oe_order_pub.line_rec_type;
9463: lsqlstmt varchar2(4000) ;
9464: lvariable1 varchar2(80);
9465: lvariable2 number;
9466: TYPE llinecur IS REF CURSOR;

Line 9477: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

9473: l_config_header_id number;
9474: l_config_rev_nbr number;
9475: l_in_line_id number := p_line_id;
9476: l_column varchar2(30);
9477: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
9478: l_schedule_status_code VARCHAR2(30);
9479: l_shipping_interfaced_flag VARCHAR2(1);
9480: l_ordered_quantity NUMBER; -- BUG 2670775 Reverse Limits
9481: l_price_request_code varchar2(240); -- BUG 2670775 Reverse Limits

Line 9500: l_new_line_rec OE_Order_PUB.Line_Rec_Type;

9496: WHERE HEADER_ID = p_header_id;
9497: /*AND NVL(ORG_ID,NVL(l_org_id,0))= NVL(l_org_id,0);*/
9498:
9499: -- added for notification framework
9500: l_new_line_rec OE_Order_PUB.Line_Rec_Type;
9501: l_index NUMBER;
9502: CURSOR svc_line IS
9503: SELECT line_id, item_type_code
9504: FROM OE_ORDER_LINES

Line 9973: ) RETURN OE_Order_PUB.Line_Rec_Type

9969: -----------------------------------------------------------*/
9970:
9971: FUNCTION Query_Row
9972: ( p_line_id IN NUMBER
9973: ) RETURN OE_Order_PUB.Line_Rec_Type
9974: IS
9975: l_line_rec OE_Order_PUB.Line_Rec_Type;
9976: BEGIN
9977:

Line 9975: l_line_rec OE_Order_PUB.Line_Rec_Type;

9971: FUNCTION Query_Row
9972: ( p_line_id IN NUMBER
9973: ) RETURN OE_Order_PUB.Line_Rec_Type
9974: IS
9975: l_line_rec OE_Order_PUB.Line_Rec_Type;
9976: BEGIN
9977:
9978: Query_Row
9979: ( p_line_id => p_line_id

Line 9994: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

9990: -----------------------------------------------------------*/
9991:
9992: PROCEDURE Query_Row
9993: ( p_line_id IN NUMBER
9994: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
9995: )
9996: IS
9997:
9998: CURSOR l_line_csr IS

Line 10781: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

10777: , p_header_id IN NUMBER :=
10778: FND_API.G_MISS_NUM
10779: , p_line_set_id IN NUMBER :=
10780: FND_API.G_MISS_NUM
10781: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
10782: )
10783: IS
10784: l_org_id NUMBER;
10785: i NUMBER;

Line 11550: l_line_rec OE_ORDER_PUB.line_rec_type;

11546:
11547: --
11548: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
11549: --
11550: l_line_rec OE_ORDER_PUB.line_rec_type;
11551: BEGIN
11552:
11553: IF l_debug_level > 0 THEN
11554: oe_debug_pub.add('Entering OE_LINE_UTIL.QUERY_ROWS, line_id:'||p_line_id, 1);

Line 12424: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

12420: -----------------------------------------------------------*/
12421:
12422: PROCEDURE Lock_Row
12423: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
12424: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
12425: , p_line_id IN NUMBER
12426: := FND_API.G_MISS_NUM
12427: )
12428: IS

Line 12749: , x_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

12745: ( p_line_id IN NUMBER :=
12746: FND_API.G_MISS_NUM
12747: , p_header_id IN NUMBER :=
12748: FND_API.G_MISS_NUM
12749: , x_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
12750: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
12751: )
12752: IS
12753: CURSOR lock_lines(p_header_id NUMBER) IS

Line 12874: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

12870: Function Get_Values
12871: -----------------------------------------------------------*/
12872:
12873: FUNCTION Get_Values
12874: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
12875: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
12876: OE_Order_PUB.G_MISS_LINE_REC
12877: ) RETURN OE_Order_PUB.Line_Val_Rec_Type
12878: IS

Line 12875: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

12871: -----------------------------------------------------------*/
12872:
12873: FUNCTION Get_Values
12874: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
12875: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
12876: OE_Order_PUB.G_MISS_LINE_REC
12877: ) RETURN OE_Order_PUB.Line_Val_Rec_Type
12878: IS
12879: l_customer_number VARCHAR2(30);

Line 12876: OE_Order_PUB.G_MISS_LINE_REC

12872:
12873: FUNCTION Get_Values
12874: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
12875: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
12876: OE_Order_PUB.G_MISS_LINE_REC
12877: ) RETURN OE_Order_PUB.Line_Val_Rec_Type
12878: IS
12879: l_customer_number VARCHAR2(30);
12880: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;

Line 12877: ) RETURN OE_Order_PUB.Line_Val_Rec_Type

12873: FUNCTION Get_Values
12874: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
12875: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
12876: OE_Order_PUB.G_MISS_LINE_REC
12877: ) RETURN OE_Order_PUB.Line_Val_Rec_Type
12878: IS
12879: l_customer_number VARCHAR2(30);
12880: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;
12881: l_organization_id NUMBER := OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');

Line 12880: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;

12876: OE_Order_PUB.G_MISS_LINE_REC
12877: ) RETURN OE_Order_PUB.Line_Val_Rec_Type
12878: IS
12879: l_customer_number VARCHAR2(30);
12880: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;
12881: l_organization_id NUMBER := OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
12882:
12883: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
12884: BEGIN

Line 13560: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

13556: Function Get_Ids
13557: -----------------------------------------------------------*/
13558:
13559: PROCEDURE Get_Ids
13560: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
13561: , p_line_val_rec IN OE_Order_PUB.Line_Val_Rec_Type
13562: )
13563: IS
13564: l_sold_to_org_id NUMBER;

Line 13561: , p_line_val_rec IN OE_Order_PUB.Line_Val_Rec_Type

13557: -----------------------------------------------------------*/
13558:
13559: PROCEDURE Get_Ids
13560: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
13561: , p_line_val_rec IN OE_Order_PUB.Line_Val_Rec_Type
13562: )
13563: IS
13564: l_sold_to_org_id NUMBER;
13565: l_deliver_to_org_id NUMBER;

Line 15480: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

15476: Function Is_Over_Return
15477: -----------------------------------------------------------*/
15478:
15479: Function Is_Over_Return
15480: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
15481: ) RETURN BOOLEAN
15482: IS
15483: l_total NUMBER;
15484: l_orig_quantity NUMBER;

Line 15624: (p_x_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type

15620: PROCEDURE Get_Inventory_Item
15621: -----------------------------------------------------------*/
15622:
15623: PROCEDURE Get_Inventory_Item
15624: (p_x_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
15625: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
15626: )
15627: IS
15628: /* Variables to call process order */

Line 15629: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

15625: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
15626: )
15627: IS
15628: /* Variables to call process order */
15629: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
15630: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
15631: l_control_rec OE_GLOBALS.Control_Rec_Type;
15632:
15633: l_attribute_value VARCHAR2(2000);

Line 15630: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

15626: )
15627: IS
15628: /* Variables to call process order */
15629: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
15630: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
15631: l_control_rec OE_GLOBALS.Control_Rec_Type;
15632:
15633: l_attribute_value VARCHAR2(2000);
15634: l_address_id VARCHAR2(2000):= NULL;

Line 15761: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)

15757: PROCEDURE Clear_Shipping_Method
15758: -----------------------------------------------------------*/
15759:
15760: PROCEDURE Clear_Shipping_Method
15761: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
15762: IS
15763: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
15764: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
15765: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 15763: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

15759:
15760: PROCEDURE Clear_Shipping_Method
15761: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
15762: IS
15763: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
15764: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
15765: l_control_rec OE_GLOBALS.Control_Rec_Type;
15766: l_return_status VARCHAR2(30);
15767: BEGIN

Line 15764: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

15760: PROCEDURE Clear_Shipping_Method
15761: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
15762: IS
15763: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
15764: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
15765: l_control_rec OE_GLOBALS.Control_Rec_Type;
15766: l_return_status VARCHAR2(30);
15767: BEGIN
15768:

Line 15808: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)

15804: PROCEDURE Clear_Commitment_Id
15805: -----------------------------------------------------------*/
15806:
15807: PROCEDURE Clear_Commitment_Id
15808: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
15809: IS
15810: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
15811: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
15812: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 15810: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

15806:
15807: PROCEDURE Clear_Commitment_Id
15808: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
15809: IS
15810: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
15811: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
15812: l_control_rec OE_GLOBALS.Control_Rec_Type;
15813: l_return_status VARCHAR2(30);
15814: BEGIN

Line 15811: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

15807: PROCEDURE Clear_Commitment_Id
15808: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
15809: IS
15810: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
15811: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
15812: l_control_rec OE_GLOBALS.Control_Rec_Type;
15813: l_return_status VARCHAR2(30);
15814: BEGIN
15815:

Line 15855: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

15851: PROCEDURE Pre_Write_Process
15852: -----------------------------------------------------------*/
15853:
15854: PROCEDURE Pre_Write_Process
15855: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
15856: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
15857: OE_Order_PUB.G_MISS_LINE_REC
15858: ) IS
15859: l_atp_tbl OE_ATP.atp_tbl_type;

Line 15856: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

15852: -----------------------------------------------------------*/
15853:
15854: PROCEDURE Pre_Write_Process
15855: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
15856: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
15857: OE_Order_PUB.G_MISS_LINE_REC
15858: ) IS
15859: l_atp_tbl OE_ATP.atp_tbl_type;
15860: l_return_status varchar2(30);

Line 15857: OE_Order_PUB.G_MISS_LINE_REC

15853:
15854: PROCEDURE Pre_Write_Process
15855: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
15856: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
15857: OE_Order_PUB.G_MISS_LINE_REC
15858: ) IS
15859: l_atp_tbl OE_ATP.atp_tbl_type;
15860: l_return_status varchar2(30);
15861: l_split_action_code varchar2(30);

Line 16944: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

16940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
16941: END Pre_Write_Process;
16942:
16943: PROCEDURE Version_Audit_Process
16944: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
16945: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
16946: OE_Order_PUB.G_MISS_LINE_REC
16947: , p_process_step IN NUMBER := 3
16948: )

Line 16945: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

16941: END Pre_Write_Process;
16942:
16943: PROCEDURE Version_Audit_Process
16944: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
16945: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
16946: OE_Order_PUB.G_MISS_LINE_REC
16947: , p_process_step IN NUMBER := 3
16948: )
16949: IS

Line 16946: OE_Order_PUB.G_MISS_LINE_REC

16942:
16943: PROCEDURE Version_Audit_Process
16944: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
16945: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
16946: OE_Order_PUB.G_MISS_LINE_REC
16947: , p_process_step IN NUMBER := 3
16948: )
16949: IS
16950:

Line 17265: l_line_rec OE_Order_PUB.Line_Rec_Type;

17261: where line_set_id = p_line_set_id
17262: and c.line_id = b.top_model_line_id);
17263:
17264:
17265: l_line_rec OE_Order_PUB.Line_Rec_Type;
17266: l_cursor_flag VARCHAR2(1) := null;
17267:
17268: BEGIN
17269: oe_debug_pub.add('Entering OE_LINE_UTIL.CASCADE_LINE_NUMBER ');

Line 17509: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

17505: PROCEDURE Post_Write_Process
17506: -----------------------------------------------------------*/
17507:
17508: PROCEDURE Post_Write_Process
17509: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
17510: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
17511: OE_Order_PUB.G_MISS_LINE_REC
17512: ) IS
17513: l_return_status VARCHAR2(30):= FND_API.G_RET_STS_SUCCESS;

Line 17510: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

17506: -----------------------------------------------------------*/
17507:
17508: PROCEDURE Post_Write_Process
17509: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
17510: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
17511: OE_Order_PUB.G_MISS_LINE_REC
17512: ) IS
17513: l_return_status VARCHAR2(30):= FND_API.G_RET_STS_SUCCESS;
17514: I NUMBER;

Line 17511: OE_Order_PUB.G_MISS_LINE_REC

17507:
17508: PROCEDURE Post_Write_Process
17509: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
17510: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
17511: OE_Order_PUB.G_MISS_LINE_REC
17512: ) IS
17513: l_return_status VARCHAR2(30):= FND_API.G_RET_STS_SUCCESS;
17514: I NUMBER;
17515: l_ship_authorize VARCHAR2(1);

Line 18069: , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

18065: -----------------------------------------------------------*/
18066:
18067: PROCEDURE Post_Line_Process
18068: ( p_control_rec IN OE_GLOBALS.Control_Rec_Type
18069: , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
18070: )
18071: IS
18072: l_return_status VARCHAR2(1);
18073: I NUMBER;

Line 18416: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

18412: /*----------------------------------------------------------
18413: Function Get_Return_Item_Type_Code
18414: -----------------------------------------------------------*/
18415: Function Get_Return_Item_Type_Code
18416: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
18417: ) RETURN varchar2
18418: IS
18419: l_item_type_code varchar2(30);
18420: BEGIN

Line 18522: FUNCTION Get_Dual_Uom(p_line_rec OE_ORDER_PUB.Line_Rec_Type)

18518: /*----------------------------------------------------------
18519: FUNCTION Get_Dual_Uom
18520: ----------------------------------------------------------- INVCONV REMOVEd to OE_Default_Line
18521:
18522: FUNCTION Get_Dual_Uom(p_line_rec OE_ORDER_PUB.Line_Rec_Type)
18523: RETURN VARCHAR2
18524: IS
18525: -- l_APPS_UOM2 VARCHAR2(3) := NULL; INVCONV
18526: l_status VARCHAR2(1);

Line 18592: FUNCTION Get_Preferred_Grade(p_line_rec OE_ORDER_PUB.Line_Rec_Type,

18588: /*----------------------------------------------------------
18589: FUNCTION Get_Preferred_Grade
18590: ----------------------------------------------------------- INVCONV removed
18591:
18592: FUNCTION Get_Preferred_Grade(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
18593: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)
18594: RETURN VARCHAR2
18595: IS
18596: l_grade_ctl NUMBER(5):= NULL;

Line 18593: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)

18589: FUNCTION Get_Preferred_Grade
18590: ----------------------------------------------------------- INVCONV removed
18591:
18592: FUNCTION Get_Preferred_Grade(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
18593: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)
18594: RETURN VARCHAR2
18595: IS
18596: l_grade_ctl NUMBER(5):= NULL;
18597: l_preferred_grade VARCHAR2(4) := NULL;

Line 18696: P_X_LINE_REC IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type

18692: PROCEDURE Sync_Dual_Qty
18693: -----------------------------------------------------------*/
18694: PROCEDURE Sync_Dual_Qty
18695: (
18696: P_X_LINE_REC IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
18697: ,P_OLD_LINE_REC IN OE_ORDER_PUB.Line_Rec_Type
18698: )
18699: IS
18700:

Line 18697: ,P_OLD_LINE_REC IN OE_ORDER_PUB.Line_Rec_Type

18693: -----------------------------------------------------------*/
18694: PROCEDURE Sync_Dual_Qty
18695: (
18696: P_X_LINE_REC IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
18697: ,P_OLD_LINE_REC IN OE_ORDER_PUB.Line_Rec_Type
18698: )
18699: IS
18700:
18701: l_converted_qty NUMBER(19,9); -- OPM 25/AUG/00

Line 19241: P_LINE_REC IN OE_ORDER_PUB.Line_Rec_Type

19237: -- comment out this as it will not be used in the converged inventory code replaced by calculate_dual_quantity
19238:
19239: FUNCTION Calculate_Ordered_Quantity2
19240: (
19241: P_LINE_REC IN OE_ORDER_PUB.Line_Rec_Type
19242: ) RETURN NUMBER
19243: IS
19244:
19245: l_item_rec OE_ORDER_CACHE.item_rec_type;

Line 19319: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type

19315: /*-----------------------------------------------------------
19316: PROCEDURE Pre_Attribute_Security
19317: ------------------------------------------------------------*/
19318: PROCEDURE Pre_Attribute_Security
19319: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
19320: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
19321: , p_index IN NUMBER
19322: ) IS
19323: l_return_status VARCHAR2(1);

Line 19320: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type

19316: PROCEDURE Pre_Attribute_Security
19317: ------------------------------------------------------------*/
19318: PROCEDURE Pre_Attribute_Security
19319: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
19320: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
19321: , p_index IN NUMBER
19322: ) IS
19323: l_return_status VARCHAR2(1);
19324:

Line 19481: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

19477: 3) in case of pto+ato, if new option is created and
19478: even 1 config item exist.
19479: ----------------------------------------------------------------------*/
19480: PROCEDURE Log_CTO_Requests
19481: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
19482: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
19483: OE_Order_PUB.G_MISS_LINE_REC
19484: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
19485: IS

Line 19482: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

19478: even 1 config item exist.
19479: ----------------------------------------------------------------------*/
19480: PROCEDURE Log_CTO_Requests
19481: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
19482: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
19483: OE_Order_PUB.G_MISS_LINE_REC
19484: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
19485: IS
19486: l_num NUMBER;

Line 19483: OE_Order_PUB.G_MISS_LINE_REC

19479: ----------------------------------------------------------------------*/
19480: PROCEDURE Log_CTO_Requests
19481: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
19482: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
19483: OE_Order_PUB.G_MISS_LINE_REC
19484: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
19485: IS
19486: l_num NUMBER;
19487: l_flag BOOLEAN;

Line 20093: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

20089: top model line with request_unique_key of line_id.
20090: ----------------------------------------------------------------------*/
20091:
20092: PROCEDURE Log_Config_Requests
20093: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
20094: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
20095: OE_Order_PUB.G_MISS_LINE_REC
20096: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
20097: IS

Line 20094: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

20090: ----------------------------------------------------------------------*/
20091:
20092: PROCEDURE Log_Config_Requests
20093: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
20094: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
20095: OE_Order_PUB.G_MISS_LINE_REC
20096: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
20097: IS
20098: l_flag BOOLEAN;

Line 20095: OE_Order_PUB.G_MISS_LINE_REC

20091:
20092: PROCEDURE Log_Config_Requests
20093: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
20094: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
20095: OE_Order_PUB.G_MISS_LINE_REC
20096: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
20097: IS
20098: l_flag BOOLEAN;
20099: l_cancellation VARCHAR2(1);

Line 20480: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

20476:
20477: ----------------------------------------------------------------------*/
20478:
20479: PROCEDURE Log_Cascade_Requests
20480: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
20481: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
20482: OE_Order_PUB.G_MISS_LINE_REC
20483: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
20484: IS

Line 20481: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

20477: ----------------------------------------------------------------------*/
20478:
20479: PROCEDURE Log_Cascade_Requests
20480: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
20481: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
20482: OE_Order_PUB.G_MISS_LINE_REC
20483: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
20484: IS
20485: l_param1 VARCHAR2(2000):= FND_API.G_MISS_NUM;

Line 20482: OE_Order_PUB.G_MISS_LINE_REC

20478:
20479: PROCEDURE Log_Cascade_Requests
20480: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
20481: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
20482: OE_Order_PUB.G_MISS_LINE_REC
20483: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
20484: IS
20485: l_param1 VARCHAR2(2000):= FND_API.G_MISS_NUM;
20486: l_param2 VARCHAR2(240) := FND_API.G_MISS_NUM;

Line 21161: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

21157: PROCEDURE Log_Scheduling_Requests
21158: ------------------------------------------------------------*/
21159:
21160: PROCEDURE Log_Scheduling_Requests
21161: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
21162: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
21163: ,p_caller IN VARCHAR2
21164: ,p_order_type_id IN NUMBER
21165: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 21162: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

21158: ------------------------------------------------------------*/
21159:
21160: PROCEDURE Log_Scheduling_Requests
21161: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
21162: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
21163: ,p_caller IN VARCHAR2
21164: ,p_order_type_id IN NUMBER
21165: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
21166: IS

Line 21808: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

21804:
21805:
21806:
21807: PROCEDURE Log_Blanket_Request
21808: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
21809: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
21810: )
21811: IS
21812: l_return_status VARCHAR2(30);

Line 21809: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

21805:
21806:
21807: PROCEDURE Log_Blanket_Request
21808: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
21809: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
21810: )
21811: IS
21812: l_return_status VARCHAR2(30);
21813: --

Line 22077: ( p_old_line_rec IN OE_Order_PUB.line_rec_type,

22073: --parent adjustments for free goods
22074: --see bug#2643552
22075:
22076: PROCEDURE update_adjustment_flags
22077: ( p_old_line_rec IN OE_Order_PUB.line_rec_type,
22078: p_x_line_rec IN OE_Order_PUB.line_rec_type)
22079: IS
22080:
22081: --cursor to return the current line association id and the

Line 22078: p_x_line_rec IN OE_Order_PUB.line_rec_type)

22074: --see bug#2643552
22075:
22076: PROCEDURE update_adjustment_flags
22077: ( p_old_line_rec IN OE_Order_PUB.line_rec_type,
22078: p_x_line_rec IN OE_Order_PUB.line_rec_type)
22079: IS
22080:
22081: --cursor to return the current line association id and the
22082: --parent line assocation id through the OE_PRICE_ADJ_ASSOCS table

Line 22259: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

22255: the commit time.
22256: Change Record :
22257: +--------------------------------------------------------------*/
22258: Procedure Log_Dropship_CMS_Request
22259: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
22260: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
22261: )
22262: IS
22263: l_return_status VARCHAR2(30);

Line 22260: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

22256: Change Record :
22257: +--------------------------------------------------------------*/
22258: Procedure Log_Dropship_CMS_Request
22259: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
22260: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
22261: )
22262: IS
22263: l_return_status VARCHAR2(30);
22264: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;