DBA Data[Home] [Help]

APPS.OE_OE_HTML_LINE dependencies on OE_ORDER_PUB

Line 10: g_line_rec OE_Order_PUB.Line_Rec_Type;

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_Oe_Html_Line';
7:
8: -- Global variables holding cached record.
9:
10: g_line_rec OE_Order_PUB.Line_Rec_Type;
11: g_db_line_rec OE_Order_PUB.Line_Rec_Type;
12:
13:
14: -- Procedure : Default_Attributes

Line 11: g_db_line_rec OE_Order_PUB.Line_Rec_Type;

7:
8: -- Global variables holding cached record.
9:
10: g_line_rec OE_Order_PUB.Line_Rec_Type;
11: g_db_line_rec OE_Order_PUB.Line_Rec_Type;
12:
13:
14: -- Procedure : Default_Attributes
15: --

Line 22: , x_line_Rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type

18: ( x_return_status OUT NOCOPY VARCHAR2
19: , x_msg_count OUT NOCOPY NUMBER
20: , x_msg_data OUT NOCOPY VARCHAR2
21: , p_header_id IN NUMBER
22: , x_line_Rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
23: , x_line_val_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Rec_Type
24: , p_header_Rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
25:
26: )

Line 23: , x_line_val_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Rec_Type

19: , x_msg_count OUT NOCOPY NUMBER
20: , x_msg_data OUT NOCOPY VARCHAR2
21: , p_header_id IN NUMBER
22: , x_line_Rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
23: , x_line_val_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Rec_Type
24: , p_header_Rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
25:
26: )
27: IS

Line 24: , p_header_Rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type

20: , x_msg_data OUT NOCOPY VARCHAR2
21: , p_header_id IN NUMBER
22: , x_line_Rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
23: , x_line_val_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Rec_Type
24: , p_header_Rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
25:
26: )
27: IS
28: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 30: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

26: )
27: IS
28: l_control_rec OE_GLOBALS.Control_Rec_Type;
29: l_return_status VARCHAR2(1);
30: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
31: l_error NUMBER := 0;
32: --
33: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
34:

Line 35: x_line_tbl OE_Order_PUB.Line_Tbl_Type;

31: l_error NUMBER := 0;
32: --
33: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
34:
35: x_line_tbl OE_Order_PUB.Line_Tbl_Type;
36: x_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
37: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
38: l_fname varchar2(1000);
39: BEGIN

Line 36: x_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

32: --
33: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
34:
35: x_line_tbl OE_Order_PUB.Line_Tbl_Type;
36: x_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
37: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
38: l_fname varchar2(1000);
39: BEGIN
40:

Line 37: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;

33: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
34:
35: x_line_tbl OE_Order_PUB.Line_Tbl_Type;
36: x_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
37: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
38: l_fname varchar2(1000);
39: BEGIN
40:
41: oe_debug_pub.g_debug_level := FND_PROFILE.VALUE('ONT_DEBUG_LEVEL');

Line 74: x_old_line_tbl(1) :=OE_ORDER_PUB.G_MISS_LINE_REC;

70: l_control_rec.clear_api_cache := TRUE;
71: l_control_rec.clear_api_requests := TRUE;
72:
73: -- Load IN parameters if any exist
74: x_old_line_tbl(1) :=OE_ORDER_PUB.G_MISS_LINE_REC;
75: x_line_tbl(1) :=OE_ORDER_PUB.G_MISS_LINE_REC;
76: x_line_tbl(1).header_id := p_header_id;
77:
78: -- Defaulting of flex values is currently done by the form.

Line 75: x_line_tbl(1) :=OE_ORDER_PUB.G_MISS_LINE_REC;

71: l_control_rec.clear_api_requests := TRUE;
72:
73: -- Load IN parameters if any exist
74: x_old_line_tbl(1) :=OE_ORDER_PUB.G_MISS_LINE_REC;
75: x_line_tbl(1) :=OE_ORDER_PUB.G_MISS_LINE_REC;
76: x_line_tbl(1).header_id := p_header_id;
77:
78: -- Defaulting of flex values is currently done by the form.
79: -- Set flex attributes to NULL in order to avoid defaulting them.

Line 237: x_line_val_rec:=OE_ORDER_PUB.G_MISS_LINE_VAL_REC;

233: x_line_rec := x_line_tbl(1);
234:
235:
236: -- Load display out parameters if any
237: x_line_val_rec:=OE_ORDER_PUB.G_MISS_LINE_VAL_REC;
238: x_line_val_rec:=OE_Line_Util.Get_Values
239: ( p_line_rec => x_line_tbl(1)
240: );
241: -- Set db_flag to False before writing to cache

Line 334: , x_line_Rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type

330: , p_attr_id_tbl IN Number_Tbl_Type
331: , p_attr_value_tbl IN Varchar2_Tbl_Type
332: , p_reason IN VARCHAR2
333: , p_comments IN VARCHAR2
334: , x_line_Rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
335: , x_old_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
336: , x_line_val_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Rec_Type
337:
338:

Line 335: , x_old_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type

331: , p_attr_value_tbl IN Varchar2_Tbl_Type
332: , p_reason IN VARCHAR2
333: , p_comments IN VARCHAR2
334: , x_line_Rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
335: , x_old_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
336: , x_line_val_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Rec_Type
337:
338:
339:

Line 336: , x_line_val_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Rec_Type

332: , p_reason IN VARCHAR2
333: , p_comments IN VARCHAR2
334: , x_line_Rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
335: , x_old_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
336: , x_line_val_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Rec_Type
337:
338:
339:
340: )

Line 354: x_line_tbl OE_Order_PUB.Line_Tbl_Type;

350: --
351: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
352: --
353:
354: x_line_tbl OE_Order_PUB.Line_Tbl_Type;
355: x_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
356: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
357: BEGIN
358:

Line 355: x_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

351: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
352: --
353:
354: x_line_tbl OE_Order_PUB.Line_Tbl_Type;
355: x_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
356: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
357: BEGIN
358:
359: IF l_debug_level > 0 THEN

Line 356: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;

352: --
353:
354: x_line_tbl OE_Order_PUB.Line_Tbl_Type;
355: x_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
356: x_line_val_tbl OE_ORDER_PUB.Line_Val_Tbl_Type;
357: BEGIN
358:
359: IF l_debug_level > 0 THEN
360: oe_debug_pub.add( 'ENTERING Oe_Oe_Html_Line.CHANGE_ATTRIBUTES' , 1 ) ;

Line 541: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

537: , p_change_reason_code IN VARCHAR2 Default Null
538: , p_change_comments IN VARCHAR2 Default Null
539: )
540: IS
541: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
542: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
543: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
544: l_control_rec OE_GLOBALS.Control_Rec_Type;
545: l_return_status VARCHAR2(1);

Line 542: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

538: , p_change_comments IN VARCHAR2 Default Null
539: )
540: IS
541: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
542: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
543: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
544: l_control_rec OE_GLOBALS.Control_Rec_Type;
545: l_return_status VARCHAR2(1);
546: --

Line 543: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;

539: )
540: IS
541: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
542: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
543: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
544: l_control_rec OE_GLOBALS.Control_Rec_Type;
545: l_return_status VARCHAR2(1);
546: --
547: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 693: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

689: )
690:
691: IS
692: l_return_status VARCHAR2(1);
693: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
694: --
695: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
696: --
697: BEGIN

Line 815: l_new_line_rec OE_Order_PUB.Line_Rec_Type; --3445778

811: l_return_status Varchar2(30);
812: --
813: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
814: --
815: l_new_line_rec OE_Order_PUB.Line_Rec_Type; --3445778
816: l_old_line_rec OE_Order_PUB.Line_Rec_Type; --3445778
817: l_index NUMBER; --3445778
818: BEGIN
819: OE_MSG_PUB.initialize;

Line 816: l_old_line_rec OE_Order_PUB.Line_Rec_Type; --3445778

812: --
813: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
814: --
815: l_new_line_rec OE_Order_PUB.Line_Rec_Type; --3445778
816: l_old_line_rec OE_Order_PUB.Line_Rec_Type; --3445778
817: l_index NUMBER; --3445778
818: BEGIN
819: OE_MSG_PUB.initialize;
820: x_return_status := FND_API.G_RET_STS_SUCCESS;