[Home] [Help]
PACKAGE: APPS.OE_OE_HTML_HEADER
Source
1 PACKAGE Oe_Oe_Html_Header AS
2 /* $Header: ONTHHDRS.pls 120.0 2005/06/01 00:47:56 appldev noship $ */
3
4 -- Procedure : Default_Attributes
5 --
6
7
8
9 TYPE Number_Tbl_Type IS TABLE OF NUMBER
10 INDEX BY BINARY_INTEGER;
11
12 TYPE Varchar2_Tbl_Type IS TABLE OF Varchar2(2000)
13 INDEX BY BINARY_INTEGER;
14
15 G_NULL_NUMBER_TBL Number_Tbl_Type;
16 G_NULL_VARCHAR2_TBL Varchar2_Tbl_Type;
17
18 PROCEDURE Default_Attributes
19 ( x_return_status OUT NOCOPY VARCHAR2
20 , x_msg_count OUT NOCOPY NUMBER
21 , x_msg_data OUT NOCOPY VARCHAR2
22 , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
23 , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
24 , p_transaction_phase_code IN VARCHAR2
25 );
26
27 -- Procedure : Change_Attribute
28 --
29
30 PROCEDURE Change_Attribute
31 ( x_return_status OUT NOCOPY VARCHAR2
32 , x_msg_count OUT NOCOPY NUMBER
33 , x_msg_data OUT NOCOPY VARCHAR2
34 , p_header_id IN NUMBER
35 , p_attr_id IN NUMBER
36 , p_attr_value IN VARCHAR2
37 , p_attr_id_tbl IN Number_Tbl_Type
38 , p_attr_value_tbl IN Varchar2_Tbl_Type
39 , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
40 , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
41 , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
42 );
43
44 PROCEDURE Save_Header
45 ( x_return_status OUT NOCOPY VARCHAR2
46 , x_msg_count OUT NOCOPY NUMBER
47 , x_msg_data OUT NOCOPY VARCHAR2
48 , p_header_id IN NUMBER
49 , p_process IN BOOLEAN DEFAULT FALSE
50 , x_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
51 , x_header_val_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Val_Rec_Type
52 , x_old_header_rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
53 );
54 PROCEDURE Delete_Row
55 ( x_return_status OUT NOCOPY VARCHAR2
56 , x_msg_count OUT NOCOPY NUMBER
57 , x_msg_data OUT NOCOPY VARCHAR2
58 , p_header_id IN NUMBER
59 );
60
61
62 -- Procedure Process_Object
63 --
64
65 PROCEDURE Process_Object
66 (
67 p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
68 , x_return_status OUT NOCOPY VARCHAR2
69 , x_msg_count OUT NOCOPY NUMBER
70 , x_msg_data OUT NOCOPY VARCHAR2
71 , x_cascade_flag OUT NOCOPY BOOLEAN
72 );
73
74 -- Procedure lock_Row
75 --
76
77 PROCEDURE Lock_Row
78 ( x_return_status OUT NOCOPY VARCHAR2
79 , x_msg_count OUT NOCOPY NUMBER
80 , x_msg_data OUT NOCOPY VARCHAR2
81 , p_header_id IN NUMBER
82 , p_lock_control IN NUMBER
83 );
84
85
86
87 Procedure Clear_Record
88 ( x_return_status OUT NOCOPY VARCHAR2
89 , x_msg_count OUT NOCOPY NUMBER
90 , x_msg_data OUT NOCOPY VARCHAR2
91 , p_header_id IN NUMBER
92 );
93
94
95 Procedure Delete_All_Requests
96 ( x_return_status OUT NOCOPY VARCHAR2
97 , x_msg_count OUT NOCOPY NUMBER
98 , x_msg_data OUT NOCOPY VARCHAR2
99 );
100
101 Procedure Populate_Transient_Attributes
102 (
103 P_header_rec IN Oe_Order_Pub.header_rec_type
104 , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
105 , x_return_status OUT NOCOPY VARCHAR2
106 , x_msg_count OUT NOCOPY NUMBER
107 , x_msg_data OUT NOCOPY VARCHAR2
108 );
109
110
111 END Oe_Oe_Html_Header;