DBA Data[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;