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 31: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

27:
28: -- Added 09-DEC-2002
29: -- Forward declaration of LOCAL PROCEDURE Log_Blanket_Request
30: PROCEDURE Log_Blanket_Request
31: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
32: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
33: );
34:
35: Procedure Log_Dropship_CMS_Request

Line 32: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

28: -- Added 09-DEC-2002
29: -- Forward declaration of LOCAL PROCEDURE Log_Blanket_Request
30: PROCEDURE Log_Blanket_Request
31: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
32: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
33: );
34:
35: Procedure Log_Dropship_CMS_Request
36: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

Line 36: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

32: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
33: );
34:
35: Procedure Log_Dropship_CMS_Request
36: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
37: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
38: );
39:
40: PROCEDURE get_customer_details

Line 37: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

33: );
34:
35: Procedure Log_Dropship_CMS_Request
36: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
37: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
38: );
39:
40: PROCEDURE get_customer_details
41: ( p_org_id IN NUMBER

Line 58: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

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

Line 59: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

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

Line 60: OE_Order_PUB.G_MISS_LINE_REC

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

Line 64: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

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

Line 65: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

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

Line 66: OE_Order_PUB.G_MISS_LINE_REC

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

Line 70: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

66: OE_Order_PUB.G_MISS_LINE_REC
67: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
68:
69: PROCEDURE Log_Cascade_Requests
70: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
71: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
72: OE_Order_PUB.G_MISS_LINE_REC
73: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
74: --------------------------------------------------------------

Line 71: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

67: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
68:
69: PROCEDURE Log_Cascade_Requests
70: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
71: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
72: OE_Order_PUB.G_MISS_LINE_REC
73: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
74: --------------------------------------------------------------
75:

Line 72: OE_Order_PUB.G_MISS_LINE_REC

68:
69: PROCEDURE Log_Cascade_Requests
70: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
71: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
72: OE_Order_PUB.G_MISS_LINE_REC
73: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
74: --------------------------------------------------------------
75:
76: --16206165 CW Start

Line 85: p_Line_rec OE_Order_PUB.Line_Rec_Type

81: -- This will return NULL if this is not a Catch Weight Case
82: --------------------------------------------------------------------------------------------------
83: FUNCTION IS_CATCH_WEIGHT
84: (
85: p_Line_rec OE_Order_PUB.Line_Rec_Type
86: )
87: RETURN VARCHAR2
88: IS
89:

Line 94: l_ref_line_rec OE_ORDER_PUB.LINE_REC_TYPE;

90: l_item_rec OE_ORDER_CACHE.ITEM_REC_TYPE;
91: l_hook_pricing_uom OE_ORDER_LINES_ALL.PRICING_QUANTITY_UOM%TYPE;
92: l_primary_catch_weight VARCHAR2(1) := NULL;
93: l_secondary_catch_weight VARCHAR2(1) := NULL;
94: l_ref_line_rec OE_ORDER_PUB.LINE_REC_TYPE;
95: TYPE uom_class_tbl IS TABLE of MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE index by MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
96: l_uom_class_tbl uom_class_tbl;
97: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
98:

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

274: l_set_tbl_count number;
275: l_header_id number;
276:
277: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
278: l_delete_lines_tbl OE_ORDER_PUB.Request_Tbl_Type; -- For bug 3754586
279: BEGIN
280: if l_debug_level > 0 then
281: oe_debug_pub.add('Entering in Delete Dependents');
282: end if;

Line 474: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

470: END Delete_Dependents;
471:
472:
473: Procedure Calc_Catchweight_Return_qty2
474: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
475: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type) IS
476: x_item_rec OE_ORDER_CACHE.item_rec_type;
477: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
478:

Line 475: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type) IS

471:
472:
473: Procedure Calc_Catchweight_Return_qty2
474: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
475: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type) IS
476: x_item_rec OE_ORDER_CACHE.item_rec_type;
477: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
478:
479: BEGIN

Line 547: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

543: Procedure Apply_Attribute_Changes
544: -----------------------------------------------------------*/
545:
546: PROCEDURE Apply_Attribute_Changes
547: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
548: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
549: OE_Order_PUB.G_MISS_LINE_REC
550: )
551: IS

Line 548: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

544: -----------------------------------------------------------*/
545:
546: PROCEDURE Apply_Attribute_Changes
547: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
548: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
549: OE_Order_PUB.G_MISS_LINE_REC
550: )
551: IS
552: l_temp_pricing_quantity NUMBER:=0;

Line 549: OE_Order_PUB.G_MISS_LINE_REC

545:
546: PROCEDURE Apply_Attribute_Changes
547: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
548: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
549: OE_Order_PUB.G_MISS_LINE_REC
550: )
551: IS
552: l_temp_pricing_quantity NUMBER:=0;
553: L_RETURN_STATUS VARCHAR2(1);

Line 561: l_x_line_Tbl OE_Order_PUB.Line_Tbl_Type;

557: l_explosion_date_changed VARCHAR2(1) := FND_API.G_FALSE;
558: l_ordered_quantity_changed VARCHAR2(1) := FND_API.G_FALSE;
559: l_shipping_unique_key1 VARCHAR2(30);
560: l_shipping_param1 VARCHAR2(240);
561: l_x_line_Tbl OE_Order_PUB.Line_Tbl_Type;
562: l_temp_shipped_quantity NUMBER;
563: l_validated_quantity NUMBER;
564: l_primary_quantity NUMBER;
565: l_qty_return_status VARCHAR2(1);

Line 595: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

591: --OPM 06/SEP/00 END
592: --OPM BUG 1491504 BEGIN
593: l_ordered_quantity NUMBER := p_x_line_rec.ordered_quantity;
594: l_ordered_quantity2 NUMBER := p_x_line_rec.ordered_quantity2;
595: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
596: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
597: l_control_rec OE_GLOBALS.Control_Rec_Type;
598: --OPM BUG 1491504 END
599: /* csheu -- bug #1533658 start*/

Line 596: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

592: --OPM BUG 1491504 BEGIN
593: l_ordered_quantity NUMBER := p_x_line_rec.ordered_quantity;
594: l_ordered_quantity2 NUMBER := p_x_line_rec.ordered_quantity2;
595: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
596: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
597: l_control_rec OE_GLOBALS.Control_Rec_Type;
598: --OPM BUG 1491504 END
599: /* csheu -- bug #1533658 start*/
600: l_copy_service_fields boolean := FALSE;

Line 6423: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

6419: PROCEDURE Complete_Record
6420: -----------------------------------------------------------*/
6421:
6422: PROCEDURE Complete_Record
6423: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
6424: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
6425: )
6426: IS
6427: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 6424: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

6420: -----------------------------------------------------------*/
6421:
6422: PROCEDURE Complete_Record
6423: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
6424: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
6425: )
6426: IS
6427: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6428: BEGIN

Line 7907: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

7903: PROCEDURE Convert_Miss_To_Null
7904: -----------------------------------------------------------*/
7905:
7906: PROCEDURE Convert_Miss_To_Null
7907: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
7908: )
7909: IS
7910: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7911: BEGIN

Line 9370: ( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

9366: Procedure Update_Row
9367: -----------------------------------------------------------*/
9368:
9369: PROCEDURE Update_Row
9370: ( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
9371: )
9372: IS
9373: l_org_id NUMBER;
9374: l_lock_control NUMBER;

Line 9842: ( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

9838: Procedure Insert_Row
9839: -----------------------------------------------------------*/
9840:
9841: PROCEDURE Insert_Row
9842: ( p_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
9843: )
9844: IS
9845: l_org_id NUMBER ;
9846: l_sold_from_org NUMBER;

Line 10729: l_line_rec oe_order_pub.line_rec_type;

10725: ,p_header_id IN NUMBER := FND_API.G_MISS_NUM)
10726: IS
10727: l_return_status VARCHAR2(30);
10728: l_org_id NUMBER;
10729: l_line_rec oe_order_pub.line_rec_type;
10730: lsqlstmt varchar2(4000) ;
10731: lvariable1 varchar2(80);
10732: lvariable2 number;
10733: TYPE llinecur IS REF CURSOR;

Line 10744: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

10740: l_config_header_id number;
10741: l_config_rev_nbr number;
10742: l_in_line_id number := p_line_id;
10743: l_column varchar2(30);
10744: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
10745: l_schedule_status_code VARCHAR2(30);
10746: l_shipping_interfaced_flag VARCHAR2(1);
10747: l_ordered_quantity NUMBER; -- BUG 2670775 Reverse Limits
10748: l_price_request_code varchar2(240); -- BUG 2670775 Reverse Limits

Line 10767: l_new_line_rec OE_Order_PUB.Line_Rec_Type;

10763: WHERE HEADER_ID = p_header_id;
10764: /*AND NVL(ORG_ID,NVL(l_org_id,0))= NVL(l_org_id,0);*/
10765:
10766: -- added for notification framework
10767: l_new_line_rec OE_Order_PUB.Line_Rec_Type;
10768: l_index NUMBER;
10769: CURSOR svc_line IS
10770: SELECT line_id, item_type_code
10771: FROM OE_ORDER_LINES

Line 11240: ) RETURN OE_Order_PUB.Line_Rec_Type

11236: -----------------------------------------------------------*/
11237:
11238: FUNCTION Query_Row
11239: ( p_line_id IN NUMBER
11240: ) RETURN OE_Order_PUB.Line_Rec_Type
11241: IS
11242: l_line_rec OE_Order_PUB.Line_Rec_Type;
11243: BEGIN
11244:

Line 11242: l_line_rec OE_Order_PUB.Line_Rec_Type;

11238: FUNCTION Query_Row
11239: ( p_line_id IN NUMBER
11240: ) RETURN OE_Order_PUB.Line_Rec_Type
11241: IS
11242: l_line_rec OE_Order_PUB.Line_Rec_Type;
11243: BEGIN
11244:
11245: Query_Row
11246: ( p_line_id => p_line_id

Line 11261: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

11257: -----------------------------------------------------------*/
11258:
11259: PROCEDURE Query_Row
11260: ( p_line_id IN NUMBER
11261: , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
11262: )
11263: IS
11264:
11265: CURSOR l_line_csr IS

Line 12073: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

12069: , p_header_id IN NUMBER :=
12070: FND_API.G_MISS_NUM
12071: , p_line_set_id IN NUMBER :=
12072: FND_API.G_MISS_NUM
12073: , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
12074: )
12075: IS
12076: l_org_id NUMBER;
12077: i NUMBER;

Line 12862: l_line_rec OE_ORDER_PUB.line_rec_type;

12858:
12859: --
12860: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
12861: --
12862: l_line_rec OE_ORDER_PUB.line_rec_type;
12863: BEGIN
12864:
12865: IF l_debug_level > 0 THEN
12866: oe_debug_pub.add('Entering OE_LINE_UTIL.QUERY_ROWS, line_id:'||p_line_id, 1);

Line 13756: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

13752: -----------------------------------------------------------*/
13753:
13754: PROCEDURE Lock_Row
13755: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
13756: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
13757: , p_line_id IN NUMBER
13758: := FND_API.G_MISS_NUM
13759: )
13760: IS

Line 14081: , x_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

14077: ( p_line_id IN NUMBER :=
14078: FND_API.G_MISS_NUM
14079: , p_header_id IN NUMBER :=
14080: FND_API.G_MISS_NUM
14081: , x_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
14082: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
14083: )
14084: IS
14085: CURSOR lock_lines(p_header_id NUMBER) IS

Line 14206: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

14202: Function Get_Values
14203: -----------------------------------------------------------*/
14204:
14205: FUNCTION Get_Values
14206: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
14207: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
14208: OE_Order_PUB.G_MISS_LINE_REC
14209: ) RETURN OE_Order_PUB.Line_Val_Rec_Type
14210: IS

Line 14207: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

14203: -----------------------------------------------------------*/
14204:
14205: FUNCTION Get_Values
14206: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
14207: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
14208: OE_Order_PUB.G_MISS_LINE_REC
14209: ) RETURN OE_Order_PUB.Line_Val_Rec_Type
14210: IS
14211: l_customer_number VARCHAR2(30);

Line 14208: OE_Order_PUB.G_MISS_LINE_REC

14204:
14205: FUNCTION Get_Values
14206: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
14207: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
14208: OE_Order_PUB.G_MISS_LINE_REC
14209: ) RETURN OE_Order_PUB.Line_Val_Rec_Type
14210: IS
14211: l_customer_number VARCHAR2(30);
14212: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;

Line 14209: ) RETURN OE_Order_PUB.Line_Val_Rec_Type

14205: FUNCTION Get_Values
14206: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
14207: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
14208: OE_Order_PUB.G_MISS_LINE_REC
14209: ) RETURN OE_Order_PUB.Line_Val_Rec_Type
14210: IS
14211: l_customer_number VARCHAR2(30);
14212: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;
14213: l_organization_id NUMBER := OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');

Line 14212: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;

14208: OE_Order_PUB.G_MISS_LINE_REC
14209: ) RETURN OE_Order_PUB.Line_Val_Rec_Type
14210: IS
14211: l_customer_number VARCHAR2(30);
14212: l_line_val_rec OE_Order_PUB.Line_Val_Rec_Type;
14213: l_organization_id NUMBER := OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
14214:
14215: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
14216: BEGIN

Line 14927: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

14923: Function Get_Ids
14924: -----------------------------------------------------------*/
14925:
14926: PROCEDURE Get_Ids
14927: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
14928: , p_line_val_rec IN OE_Order_PUB.Line_Val_Rec_Type
14929: )
14930: IS
14931: l_sold_to_org_id NUMBER;

Line 14928: , p_line_val_rec IN OE_Order_PUB.Line_Val_Rec_Type

14924: -----------------------------------------------------------*/
14925:
14926: PROCEDURE Get_Ids
14927: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
14928: , p_line_val_rec IN OE_Order_PUB.Line_Val_Rec_Type
14929: )
14930: IS
14931: l_sold_to_org_id NUMBER;
14932: l_deliver_to_org_id NUMBER;

Line 16924: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

16920: Function Is_Over_Return
16921: -----------------------------------------------------------*/
16922:
16923: Function Is_Over_Return
16924: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
16925: ) RETURN BOOLEAN
16926: IS
16927: l_total NUMBER;
16928: l_orig_quantity NUMBER;

Line 17068: (p_x_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type

17064: PROCEDURE Get_Inventory_Item
17065: -----------------------------------------------------------*/
17066:
17067: PROCEDURE Get_Inventory_Item
17068: (p_x_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
17069: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
17070: )
17071: IS
17072: /* Variables to call process order */

Line 17073: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

17069: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
17070: )
17071: IS
17072: /* Variables to call process order */
17073: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
17074: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
17075: l_control_rec OE_GLOBALS.Control_Rec_Type;
17076:
17077: l_attribute_value VARCHAR2(2000);

Line 17074: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

17070: )
17071: IS
17072: /* Variables to call process order */
17073: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
17074: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
17075: l_control_rec OE_GLOBALS.Control_Rec_Type;
17076:
17077: l_attribute_value VARCHAR2(2000);
17078: l_address_id VARCHAR2(2000):= NULL;

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

17230: PROCEDURE Clear_Shipping_Method
17231: -----------------------------------------------------------*/
17232:
17233: PROCEDURE Clear_Shipping_Method
17234: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
17235: IS
17236: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
17237: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
17238: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 17236: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

17232:
17233: PROCEDURE Clear_Shipping_Method
17234: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
17235: IS
17236: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
17237: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
17238: l_control_rec OE_GLOBALS.Control_Rec_Type;
17239: l_return_status VARCHAR2(30);
17240: BEGIN

Line 17237: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

17233: PROCEDURE Clear_Shipping_Method
17234: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
17235: IS
17236: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
17237: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
17238: l_control_rec OE_GLOBALS.Control_Rec_Type;
17239: l_return_status VARCHAR2(30);
17240: BEGIN
17241:

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

17277: PROCEDURE Clear_Commitment_Id
17278: -----------------------------------------------------------*/
17279:
17280: PROCEDURE Clear_Commitment_Id
17281: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
17282: IS
17283: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
17284: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
17285: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 17283: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

17279:
17280: PROCEDURE Clear_Commitment_Id
17281: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
17282: IS
17283: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
17284: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
17285: l_control_rec OE_GLOBALS.Control_Rec_Type;
17286: l_return_status VARCHAR2(30);
17287: BEGIN

Line 17284: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

17280: PROCEDURE Clear_Commitment_Id
17281: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type)
17282: IS
17283: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
17284: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
17285: l_control_rec OE_GLOBALS.Control_Rec_Type;
17286: l_return_status VARCHAR2(30);
17287: BEGIN
17288:

Line 17359: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

17355: PROCEDURE Pre_Write_Process
17356: -----------------------------------------------------------*/
17357:
17358: PROCEDURE Pre_Write_Process
17359: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
17360: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
17361: OE_Order_PUB.G_MISS_LINE_REC
17362: ) IS
17363: l_atp_tbl OE_ATP.atp_tbl_type;

Line 17360: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

17356: -----------------------------------------------------------*/
17357:
17358: PROCEDURE Pre_Write_Process
17359: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
17360: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
17361: OE_Order_PUB.G_MISS_LINE_REC
17362: ) IS
17363: l_atp_tbl OE_ATP.atp_tbl_type;
17364: l_return_status varchar2(30);

Line 17361: OE_Order_PUB.G_MISS_LINE_REC

17357:
17358: PROCEDURE Pre_Write_Process
17359: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
17360: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
17361: OE_Order_PUB.G_MISS_LINE_REC
17362: ) IS
17363: l_atp_tbl OE_ATP.atp_tbl_type;
17364: l_return_status varchar2(30);
17365: l_split_action_code varchar2(30);

Line 17410: l_G_Delayed_Requests OE_ORDER_PUB.Request_Tbl_Type;

17406: l_attr_attach_change boolean := FALSE; --6896311
17407:
17408: -- Bug 8940667,8947394 begin
17409: i number;
17410: l_G_Delayed_Requests OE_ORDER_PUB.Request_Tbl_Type;
17411: -- Bug 8940667,8947394 end
17412:
17413: l_ship_to_org_id NUMBER; --Bug# 13451157
17414:

Line 18646: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

18642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
18643: END Pre_Write_Process;
18644:
18645: PROCEDURE Version_Audit_Process
18646: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
18647: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
18648: OE_Order_PUB.G_MISS_LINE_REC
18649: , p_process_step IN NUMBER := 3
18650: )

Line 18647: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

18643: END Pre_Write_Process;
18644:
18645: PROCEDURE Version_Audit_Process
18646: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
18647: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
18648: OE_Order_PUB.G_MISS_LINE_REC
18649: , p_process_step IN NUMBER := 3
18650: )
18651: IS

Line 18648: OE_Order_PUB.G_MISS_LINE_REC

18644:
18645: PROCEDURE Version_Audit_Process
18646: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
18647: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
18648: OE_Order_PUB.G_MISS_LINE_REC
18649: , p_process_step IN NUMBER := 3
18650: )
18651: IS
18652:

Line 18970: l_line_rec OE_Order_PUB.Line_Rec_Type;

18966: where line_set_id = p_line_set_id
18967: and c.line_id = b.top_model_line_id);
18968:
18969:
18970: l_line_rec OE_Order_PUB.Line_Rec_Type;
18971: l_cursor_flag VARCHAR2(1) := null;
18972:
18973: BEGIN
18974: oe_debug_pub.add('Entering OE_LINE_UTIL.CASCADE_LINE_NUMBER ');

Line 19214: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

19210: PROCEDURE Post_Write_Process
19211: -----------------------------------------------------------*/
19212:
19213: PROCEDURE Post_Write_Process
19214: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
19215: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
19216: OE_Order_PUB.G_MISS_LINE_REC
19217: ) IS
19218: l_return_status VARCHAR2(30):= FND_API.G_RET_STS_SUCCESS;

Line 19215: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

19211: -----------------------------------------------------------*/
19212:
19213: PROCEDURE Post_Write_Process
19214: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
19215: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
19216: OE_Order_PUB.G_MISS_LINE_REC
19217: ) IS
19218: l_return_status VARCHAR2(30):= FND_API.G_RET_STS_SUCCESS;
19219: I NUMBER;

Line 19216: OE_Order_PUB.G_MISS_LINE_REC

19212:
19213: PROCEDURE Post_Write_Process
19214: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
19215: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
19216: OE_Order_PUB.G_MISS_LINE_REC
19217: ) IS
19218: l_return_status VARCHAR2(30):= FND_API.G_RET_STS_SUCCESS;
19219: I NUMBER;
19220: l_ship_authorize VARCHAR2(1);

Line 19871: , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type

19867: -----------------------------------------------------------*/
19868:
19869: PROCEDURE Post_Line_Process
19870: ( p_control_rec IN OE_GLOBALS.Control_Rec_Type
19871: , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
19872: )
19873: IS
19874: l_return_status VARCHAR2(1);
19875: I NUMBER;

Line 20250: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

20246: /*----------------------------------------------------------
20247: Function Get_Return_Item_Type_Code
20248: -----------------------------------------------------------*/
20249: Function Get_Return_Item_Type_Code
20250: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
20251: ) RETURN varchar2
20252: IS
20253: l_item_type_code varchar2(30);
20254: BEGIN

Line 20356: FUNCTION Get_Dual_Uom(p_line_rec OE_ORDER_PUB.Line_Rec_Type)

20352: /*----------------------------------------------------------
20353: FUNCTION Get_Dual_Uom
20354: ----------------------------------------------------------- INVCONV REMOVEd to OE_Default_Line
20355:
20356: FUNCTION Get_Dual_Uom(p_line_rec OE_ORDER_PUB.Line_Rec_Type)
20357: RETURN VARCHAR2
20358: IS
20359: -- l_APPS_UOM2 VARCHAR2(3) := NULL; INVCONV
20360: l_status VARCHAR2(1);

Line 20426: FUNCTION Get_Preferred_Grade(p_line_rec OE_ORDER_PUB.Line_Rec_Type,

20422: /*----------------------------------------------------------
20423: FUNCTION Get_Preferred_Grade
20424: ----------------------------------------------------------- INVCONV removed
20425:
20426: FUNCTION Get_Preferred_Grade(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
20427: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)
20428: RETURN VARCHAR2
20429: IS
20430: l_grade_ctl NUMBER(5):= NULL;

Line 20427: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)

20423: FUNCTION Get_Preferred_Grade
20424: ----------------------------------------------------------- INVCONV removed
20425:
20426: FUNCTION Get_Preferred_Grade(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
20427: p_old_line_rec OE_ORDER_PUB.Line_Rec_Type)
20428: RETURN VARCHAR2
20429: IS
20430: l_grade_ctl NUMBER(5):= NULL;
20431: l_preferred_grade VARCHAR2(4) := NULL;

Line 20530: P_X_LINE_REC IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type

20526: PROCEDURE Sync_Dual_Qty
20527: -----------------------------------------------------------*/
20528: PROCEDURE Sync_Dual_Qty
20529: (
20530: P_X_LINE_REC IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
20531: ,P_OLD_LINE_REC IN OE_ORDER_PUB.Line_Rec_Type
20532: )
20533: IS
20534:

Line 20531: ,P_OLD_LINE_REC IN OE_ORDER_PUB.Line_Rec_Type

20527: -----------------------------------------------------------*/
20528: PROCEDURE Sync_Dual_Qty
20529: (
20530: P_X_LINE_REC IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
20531: ,P_OLD_LINE_REC IN OE_ORDER_PUB.Line_Rec_Type
20532: )
20533: IS
20534:
20535: l_converted_qty NUMBER(19,9); -- OPM 25/AUG/00

Line 21092: P_LINE_REC IN OE_ORDER_PUB.Line_Rec_Type

21088: -- comment out this as it will not be used in the converged inventory code replaced by calculate_dual_quantity
21089:
21090: FUNCTION Calculate_Ordered_Quantity2
21091: (
21092: P_LINE_REC IN OE_ORDER_PUB.Line_Rec_Type
21093: ) RETURN NUMBER
21094: IS
21095:
21096: l_item_rec OE_ORDER_CACHE.item_rec_type;

Line 21170: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type

21166: /*-----------------------------------------------------------
21167: PROCEDURE Pre_Attribute_Security
21168: ------------------------------------------------------------*/
21169: PROCEDURE Pre_Attribute_Security
21170: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
21171: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
21172: , p_index IN NUMBER
21173: ) IS
21174: l_return_status VARCHAR2(1);

Line 21171: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type

21167: PROCEDURE Pre_Attribute_Security
21168: ------------------------------------------------------------*/
21169: PROCEDURE Pre_Attribute_Security
21170: ( p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
21171: , p_old_line_rec IN OE_ORDER_PUB.Line_Rec_Type
21172: , p_index IN NUMBER
21173: ) IS
21174: l_return_status VARCHAR2(1);
21175: --Added for bug 14296662

Line 21358: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

21354: 3) in case of pto+ato, if new option is created and
21355: even 1 config item exist.
21356: ----------------------------------------------------------------------*/
21357: PROCEDURE Log_CTO_Requests
21358: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
21359: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
21360: OE_Order_PUB.G_MISS_LINE_REC
21361: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
21362: IS

Line 21359: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

21355: even 1 config item exist.
21356: ----------------------------------------------------------------------*/
21357: PROCEDURE Log_CTO_Requests
21358: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
21359: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
21360: OE_Order_PUB.G_MISS_LINE_REC
21361: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
21362: IS
21363: l_num NUMBER;

Line 21360: OE_Order_PUB.G_MISS_LINE_REC

21356: ----------------------------------------------------------------------*/
21357: PROCEDURE Log_CTO_Requests
21358: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
21359: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
21360: OE_Order_PUB.G_MISS_LINE_REC
21361: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
21362: IS
21363: l_num NUMBER;
21364: l_flag BOOLEAN;

Line 21971: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

21967: top model line with request_unique_key of line_id.
21968: ----------------------------------------------------------------------*/
21969:
21970: PROCEDURE Log_Config_Requests
21971: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
21972: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
21973: OE_Order_PUB.G_MISS_LINE_REC
21974: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
21975: IS

Line 21972: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

21968: ----------------------------------------------------------------------*/
21969:
21970: PROCEDURE Log_Config_Requests
21971: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
21972: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
21973: OE_Order_PUB.G_MISS_LINE_REC
21974: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
21975: IS
21976: l_flag BOOLEAN;

Line 21973: OE_Order_PUB.G_MISS_LINE_REC

21969:
21970: PROCEDURE Log_Config_Requests
21971: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
21972: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
21973: OE_Order_PUB.G_MISS_LINE_REC
21974: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
21975: IS
21976: l_flag BOOLEAN;
21977: l_cancellation VARCHAR2(1);

Line 22360: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

22356:
22357: ----------------------------------------------------------------------*/
22358:
22359: PROCEDURE Log_Cascade_Requests
22360: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
22361: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
22362: OE_Order_PUB.G_MISS_LINE_REC
22363: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
22364: IS

Line 22361: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=

22357: ----------------------------------------------------------------------*/
22358:
22359: PROCEDURE Log_Cascade_Requests
22360: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
22361: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
22362: OE_Order_PUB.G_MISS_LINE_REC
22363: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
22364: IS
22365: l_param1 VARCHAR2(2000):= FND_API.G_MISS_NUM;

Line 22362: OE_Order_PUB.G_MISS_LINE_REC

22358:
22359: PROCEDURE Log_Cascade_Requests
22360: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
22361: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type :=
22362: OE_Order_PUB.G_MISS_LINE_REC
22363: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
22364: IS
22365: l_param1 VARCHAR2(2000):= FND_API.G_MISS_NUM;
22366: l_param2 VARCHAR2(240) := FND_API.G_MISS_NUM;

Line 23043: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

23039: PROCEDURE Log_Scheduling_Requests
23040: ------------------------------------------------------------*/
23041:
23042: PROCEDURE Log_Scheduling_Requests
23043: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
23044: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
23045: ,p_caller IN VARCHAR2
23046: ,p_order_type_id IN NUMBER
23047: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 23044: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

23040: ------------------------------------------------------------*/
23041:
23042: PROCEDURE Log_Scheduling_Requests
23043: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
23044: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
23045: ,p_caller IN VARCHAR2
23046: ,p_order_type_id IN NUMBER
23047: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
23048: IS

Line 23692: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

23688:
23689:
23690:
23691: PROCEDURE Log_Blanket_Request
23692: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
23693: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
23694: )
23695: IS
23696: l_return_status VARCHAR2(30);

Line 23693: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

23689:
23690:
23691: PROCEDURE Log_Blanket_Request
23692: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
23693: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
23694: )
23695: IS
23696: l_return_status VARCHAR2(30);
23697: --

Line 23961: ( p_old_line_rec IN OE_Order_PUB.line_rec_type,

23957: --parent adjustments for free goods
23958: --see bug#2643552
23959:
23960: PROCEDURE update_adjustment_flags
23961: ( p_old_line_rec IN OE_Order_PUB.line_rec_type,
23962: p_x_line_rec IN OE_Order_PUB.line_rec_type)
23963: IS
23964:
23965: --cursor to return the current line association id and the

Line 23962: p_x_line_rec IN OE_Order_PUB.line_rec_type)

23958: --see bug#2643552
23959:
23960: PROCEDURE update_adjustment_flags
23961: ( p_old_line_rec IN OE_Order_PUB.line_rec_type,
23962: p_x_line_rec IN OE_Order_PUB.line_rec_type)
23963: IS
23964:
23965: --cursor to return the current line association id and the
23966: --parent line assocation id through the OE_PRICE_ADJ_ASSOCS table

Line 24143: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

24139: the commit time.
24140: Change Record :
24141: +--------------------------------------------------------------*/
24142: Procedure Log_Dropship_CMS_Request
24143: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
24144: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
24145: )
24146: IS
24147: l_return_status VARCHAR2(30);

Line 24144: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

24140: Change Record :
24141: +--------------------------------------------------------------*/
24142: Procedure Log_Dropship_CMS_Request
24143: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
24144: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
24145: )
24146: IS
24147: l_return_status VARCHAR2(30);
24148: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 24548: ( p_line_customer_info_tbl IN OUT NOCOPY OE_Order_Pub.CUSTOMER_INFO_TABLE_TYPE,

24544:
24545:
24546: --ER7675548
24547: Procedure Get_customer_info_ids
24548: ( p_line_customer_info_tbl IN OUT NOCOPY OE_Order_Pub.CUSTOMER_INFO_TABLE_TYPE,
24549: p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
24550: x_return_status OUT NOCOPY VARCHAR2,
24551: x_msg_count OUT NOCOPY NUMBER,
24552: x_msg_data OUT NOCOPY VARCHAR2

Line 24549: p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,

24545:
24546: --ER7675548
24547: Procedure Get_customer_info_ids
24548: ( p_line_customer_info_tbl IN OUT NOCOPY OE_Order_Pub.CUSTOMER_INFO_TABLE_TYPE,
24549: p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type,
24550: x_return_status OUT NOCOPY VARCHAR2,
24551: x_msg_count OUT NOCOPY NUMBER,
24552: x_msg_data OUT NOCOPY VARCHAR2
24553: ) IS