[Home] [Help]
PACKAGE: APPS.OE_BLANKET_FORM_CONTROL
Source
1 PACKAGE OE_Blanket_Form_Control AUTHID CURRENT_USER AS
2 /* $Header: OEXFBSOS.pls 120.1 2006/03/29 16:44:16 spooruli noship $ */
3 G_PKG_NAME VARCHAR2(30) := 'OE_Blanket_Form_Control';
4
5 G_INCLUDE_ALL_REVISIONS VARCHAR2(1) := 'N';
6
7 PROCEDURE Header_Value_Conversion
8 ( p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_type
9 , p_header_val_rec IN OUT NOCOPY OE_Order_PUB.Header_Val_Rec_Type
10 );
11
12 PROCEDURE Line_Value_Conversion
13 ( p_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_Rec_Type
14 , p_line_val_rec IN OUT NOCOPY OE_Order_PUB.Line_Val_Rec_Type
15 );
16
17 PROCEDURE Populate_Header_Values_ID
18 ( p_Header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_Rec_Type
19 , p_Header_val_rec IN OUT NOCOPY OE_Order_PUB.Header_Val_Rec_Type
20 );
21
22 PROCEDURE Populate_Line_Values_ID
23 ( p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_Rec_Type
24 , p_Line_val_rec IN OUT NOCOPY OE_Order_PUB.Line_Val_Rec_Type
25 );
26
27 PROCEDURE Validate_Entity
28 (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2
32 );
33
34 PROCEDURE Validate_Entity
35 (p_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type,
36 x_return_status IN OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2
39 );
40
41 PROCEDURE Insert_Row
42 (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2);
46
47 PROCEDURE Update_Row
48 (p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2);
52
53 -- hashraf start pack J
54 PROCEDURE Delete_Row
55 (p_header_id IN NUMBER,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2);
59 -- hashraf end pack J
60
61 PROCEDURE Insert_Row
62 (p_line_rec IN OUT NOCOPY OE_BLANKET_PUB.Line_Rec_Type,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2);
66
67 PROCEDURE Update_Row
68 (p_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_rec_type,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2);
72
73 -- hashraf start pack J
74 PROCEDURE Delete_Row
75 (p_line_id IN NUMBER,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2);
79 -- hashraf end pack J
80
81 PROCEDURE Default_Attributes
82 (p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 x_return_status OUT NOCOPY VARCHAR2);
86
87 PROCEDURE Default_Attributes
88 (p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 x_return_status OUT NOCOPY VARCHAR2);
92
93 PROCEDURE Process_Object
94 (x_return_status IN OUT NOCOPY varchar2,
95 x_msg_count IN OUT NOCOPY NUMBER,
96 x_msg_data IN OUT NOCOPY VARCHAR2);
97
98 PROCEDURE Check_Sec_Header_Attr
99 (x_return_status IN OUT NOCOPY varchar2,
100 p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
101 p_old_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
102 -- 11i10 security changes
103 p_column_name IN VARCHAR2 DEFAULT NULL,
104 x_msg_count IN OUT NOCOPY NUMBER,
105 x_msg_data IN OUT NOCOPY VARCHAR2);
106
107 PROCEDURE Check_Sec_Line_Attr
108 (x_return_status IN OUT NOCOPY varchar2,
109 p_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_rec_type,
110 p_old_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_rec_type,
111 x_msg_count IN OUT NOCOPY NUMBER,
112 x_msg_data IN OUT NOCOPY VARCHAR2);
113
114 PROCEDURE Check_Sec_Header_Entity
115 (x_return_status IN OUT NOCOPY varchar2,
116 p_header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
117 x_msg_count IN OUT NOCOPY NUMBER,
118 x_msg_data IN OUT NOCOPY VARCHAR2);
119
120 PROCEDURE Check_Sec_Line_Entity
121 (x_return_status IN OUT NOCOPY varchar2,
122 p_line_rec IN OUT NOCOPY OE_Blanket_PUB.Line_rec_type,
123 x_msg_count IN OUT NOCOPY NUMBER,
124 x_msg_data IN OUT NOCOPY VARCHAR2);
125
126 PROCEDURE Update_Header_Cache
127 (p_x_header_rec IN OUT NOCOPY OE_Blanket_PUB.header_rec_type,
128 delete_flag IN Varchar2 DEFAULT NULL);
129
130 PROCEDURE Update_Line_Cache
131 (p_x_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type,
132 delete_flag IN Varchar2 DEFAULT NULL);
133
134 PROCEDURE Lock_Header_Row
135 (p_row_id IN VARCHAR2);
136
137 PROCEDURE Lock_Line_Row
138 (p_row_id IN VARCHAR2);
139
140 PROCEDURE Load_Blanket_Line_Number
141 (l_x_header_id IN Varchar2);
142
143 PROCEDURE Load_Blanket_Header_Rec
144 (p_x_Header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type
145 ,p_x_old_Header_rec IN OUT NOCOPY OE_Blanket_PUB.Header_rec_type);
146
147 PROCEDURE Load_Blanket_Line_Rec
148 (p_x_line_rec IN OE_Blanket_PUB.line_rec_type
149 ,p_x_old_line_rec IN OUT NOCOPY OE_Blanket_PUB.line_rec_type);
150
151 -- hashraf start pack J
152 Procedure Clear_Record
153 ( x_return_status OUT NOCOPY VARCHAR2
154 , x_msg_count OUT NOCOPY NUMBER
155 , x_msg_data OUT NOCOPY VARCHAR2
156 , block_name IN VARCHAR2
157 );
158 -- hashraf end pack J
159
160 FUNCTION Line_number
161 ( p_header_id IN NUMBER
162 ) RETURN number;
163
164 FUNCTION Line_number_reset
165 RETURN varchar2;
166
167 FUNCTION Sales_Order_Type
168 (p_order_type_id IN number)
169 RETURN varchar2;
170
171 FUNCTION item_identifier
172 (p_item_identifier_type IN varchar2)
173 RETURN varchar2;
174
175 FUNCTION Get_Currency_Format
176 (p_currency_code IN VARCHAR2,
177 p_field_length IN NUMBER,
178 p_percision IN NUMBER default null,
179 p_min_acct_unit IN NUMBER default null)
180 RETURN VARCHAR2;
181
182 FUNCTION Get_Opr_Create
183 RETURN varchar2;
184
185 FUNCTION Get_Opr_Update
186 RETURN varchar2;
187
188 -- hashraf start pack J
189 FUNCTION Get_Opr_Delete
190 RETURN varchar2;
191 -- hashraf end pack J
192
193 FUNCTION Chk_for_header_release
194 (p_blanket_number IN number)
195 RETURN varchar2;
196
197 FUNCTION Chk_for_line_release
198 (p_blanket_number IN number,
199 p_blanket_line_number IN number)
200 RETURN varchar2;
201
202 PROCEDURE Set_Include_All_Revisions
203 (p_value IN Varchar2);
204
205 FUNCTION Include_All_Revisions
206 RETURN Varchar2;
207
208 FUNCTION Chk_active_revision
209 (p_blanket_number IN number,
210 p_version_number IN number)
211 RETURN varchar2;
212
213 FUNCTION get_trxt_phase_from_order_type
214 (p_order_type_id IN number)
215 RETURN varchar2;
216
217 END OE_Blanket_Form_Control;