1 PACKAGE Oe_Oe_Html_Line AUTHID CURRENT_USER AS
2 /* $Header: ONTHLINS.pls 120.0 2005/06/01 00:36:16 appldev noship $ */
3
4 TYPE Number_Tbl_Type IS TABLE OF NUMBER
5 INDEX BY BINARY_INTEGER;
6
7 TYPE Varchar2_Tbl_Type IS TABLE OF Varchar2(2000)
8 INDEX BY BINARY_INTEGER;
9
10 G_NULL_NUMBER_TBL Number_Tbl_Type;
11 G_NULL_VARCHAR2_TBL Varchar2_Tbl_Type;
12
13 --
14
15 PROCEDURE Default_Attributes
16 ( x_return_status OUT NOCOPY VARCHAR2
17 , x_msg_count OUT NOCOPY NUMBER
18 , x_msg_data OUT NOCOPY VARCHAR2
19 , p_header_id IN NUMBER
20 , x_line_Rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
21 , x_line_val_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Rec_Type
22 , p_header_Rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
23 );
24
25 -- Procedure : Change_Attribute
26
27
28 PROCEDURE Change_Attribute
29 ( x_return_status OUT NOCOPY VARCHAR2
30 , x_msg_count OUT NOCOPY NUMBER
31 , x_msg_data OUT NOCOPY VARCHAR2
32 , p_line_id IN NUMBER
33 , p_attr_id IN NUMBER
34 , p_attr_value IN VARCHAR2
35 , p_attr_id_tbl IN Number_Tbl_Type DEFAULT G_NULL_NUMBER_TBL
36 , p_attr_value_tbl IN Varchar2_Tbl_Type DEFAULT G_NULL_VARCHAR2_TBL
37 , p_reason IN VARCHAR2
38 , p_comments IN VARCHAR2
39 , x_line_Rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
40 , x_old_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
41 , x_line_val_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Rec_Type
42
43 );
44
45
46 -- Procedure Delete_Row
47 --
48
49 PROCEDURE Delete_Row
50 ( x_return_status OUT NOCOPY VARCHAR2
51 , x_msg_count OUT NOCOPY NUMBER
52 , x_msg_data OUT NOCOPY VARCHAR2
53 , p_line_id IN NUMBER
54 , p_change_reason_code IN VARCHAR2 Default Null
55 , p_change_comments IN VARCHAR2 Default Null
56 );
57
58
59 -- Procedure lock_Row
60 --
61
62 PROCEDURE Lock_Row
63 ( x_return_status OUT NOCOPY VARCHAR2
64 , x_msg_count OUT NOCOPY NUMBER
65 , x_msg_data OUT NOCOPY VARCHAR2
66 , p_line_id IN NUMBER
67 , p_lock_control IN NUMBER
68
69 );
70
71 Procedure Clear_Record
72 ( x_return_status OUT NOCOPY VARCHAR2
73 , x_msg_count OUT NOCOPY NUMBER
74 , x_msg_data OUT NOCOPY VARCHAR2
75 , p_line_id IN NUMBER
76 );
77
78 END Oe_Oe_Html_Line;
79
80