[Home] [Help]
PACKAGE BODY: APPS.OE_PORTAL_LINE
Source
1 PACKAGE BODY OE_Portal_Line AS
2 /* $Header: OEXLPORB.pls 120.0 2005/06/04 11:11:24 appldev noship $ */
3
4
5
6 -- Global constant holding the package name
7
8 G_PKG_NAME CONSTANT VARCHAR2(30) := 'Oe_Portal_Line';
9
10 -- Global variables holding cached record.
11
12 g_line_rec OE_Order_PUB.Line_Rec_Type;
13 g_db_line_rec OE_Order_PUB.Line_Rec_Type;
14 --g_set_of_books_rec Set_Of_Books_Rec_Type;
15 -- Forward declaration of procedures maintaining entity record cache.
16
17
18
19 PROCEDURE Get_line
20 ( p_line_id IN NUMBER
21 , x_line_rec OUT NOCOPY OE_Order_PUB.Line_Rec_Type
22 );
23
24
25 PROCEDURE Get_Item_Values(Item_Id IN NUMBER ,
26 Inventory_Item OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
27 Item_Desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
28 PROCEDURE Clear_Line;
29
30 -- Global variable holding performed operations.
31
32 g_opr__tbl OE_Order_PUB.Header_Tbl_Type;
33
34
35 PROCEDURE Validate_Write_Line
36 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
37 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
38 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39 , p_line_id IN NUMBER
40 , p_header_id IN NUMBER
41 , p_db_flag IN VARCHAR2 DEFAULT 'N'
42 , p_sold_to_org_id IN NUMBER
43 , p_inventory_item_id IN NUMBER
44 , p_ordered_quantity IN NUMBER
45 , p_order_quantity_uom IN VARCHAR2
46 ,p_ship_to_org_id IN NUMBER
47 , p_request_date IN varchar2
48 , x_discounts OUT NOCOPY /* file.sql.39 change */ NUMBER
49 , x_charges OUT NOCOPY /* file.sql.39 change */ NUMBER
50 , x_taxes OUT NOCOPY /* file.sql.39 change */ NUMBER
51 , x_line_tax_value OUT NOCOPY /* file.sql.39 change */ NUMBER
52 , x_schedule_ship_date OUT NOCOPY /* file.sql.39 change */ VARCHAR2
53 , x_schedule_arrival_date OUT NOCOPY /* file.sql.39 change */ VARCHAR2
54 , x_schedule_status_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
55 , x_schedule_action_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
56 , x_ship_from_address1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
57 , x_ship_from_address2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
58 , x_ship_from_address3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
59 , x_ship_from_address4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
60 , x_ship_from_location OUT NOCOPY /* file.sql.39 change */ VARCHAR2
61 , x_ship_from_org OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62 , x_ship_from_org_id OUT NOCOPY /* file.sql.39 change */ NUMBER
63 , x_promise_date OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64 , x_unit_selling_price OUT NOCOPY /* file.sql.39 change */ NUMBER
65 , x_unit_list_price OUT NOCOPY /* file.sql.39 change */ NUMBER
66 , x_list_percent OUT NOCOPY /* file.sql.39 change */ NUMBER
67 , x_selling_percent OUT NOCOPY /* file.sql.39 change */ NUMBER
68 , x_pricing_quantity OUT NOCOPY /* file.sql.39 change */ NUMBER
69 , x_pricing_quantity_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
70 , x_calculate_price_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
71 , x_calculate_price_descr OUT NOCOPY /* file.sql.39 change */ VARCHAR2
72 , x_inventory_item_id OUT NOCOPY /* file.sql.39 change */ NUMBER
73 , x_customer_item OUT NOCOPY /* file.sql.39 change */ VARCHAR2
74 , x_inventory_item OUT NOCOPY /* file.sql.39 change */ VARCHAR2
75 , x_item_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2
76 , x_ordered_quantity OUT NOCOPY /* file.sql.39 change */ NUMBER
77 , x_order_quantity_uom OUT NOCOPY /* file.sql.39 change */ VARCHAR2
78 , x_request_date OUT NOCOPY /* file.sql.39 change */ DATE
79 , x_ordered_item_id OUT NOCOPY /* file.sql.39 change */ NUMBER
80 , x_price_list_id OUT NOCOPY /* file.sql.39 change */ NUMBER
81 , x_price_list OUT NOCOPY /* file.sql.39 change */ VARCHAR2
82 , x_payment_term_id OUT NOCOPY /* file.sql.39 change */ NUMBER
83 , x_payment_term OUT NOCOPY /* file.sql.39 change */ varchar2
84 , x_shipment_priority_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
85 , x_shipment_priority OUT NOCOPY /* file.sql.39 change */ VARCHAR2
86 , x_freight_terms_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
87 , x_freight_terms OUT NOCOPY /* file.sql.39 change */ VARCHAR2
88 , x_lock_control OUT NOCOPY /* file.sql.39 change */ NUMBER
89 , x_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
90 , x_ship_to_org_id OUT NOCOPY /* file.sql.39 change */ NUMBER
91 , x_ship_to_org OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92 , x_ship_to_location OUT NOCOPY /* file.sql.39 change */ VARCHAR2
93 , x_ship_to_address1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94 , x_ship_to_address2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
95 , x_ship_to_address3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96 , x_ship_to_address4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97 )
98 IS
99 l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
100 l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
101 l_control_rec OE_GLOBALS.Control_Rec_Type;
102 l_return_status VARCHAR2(1);
103 l_x_line_rec OE_Order_PUB.Line_Rec_Type;
104 l_charge_amount NUMBER := 0.0;
105 BEGIN
106
107 /* chhung delete the content of all procedures. Request by Esha */
108 null;
109
110 END Validate_Write_Line;
111
112
113
114 PROCEDURE Get_Item_Values(Item_Id IN NUMBER ,
115 Inventory_Item OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
116 Item_Desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
117 IS
118 BEGIN
119
120 /* chhung delete the content of all procedures. Request by Esha */
121 null;
122
123 END Get_Item_Values;
124
125
126
127
128 PROCEDURE Delete_Row
129 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
130 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
131 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
132 , p_line_id IN NUMBER
133 )
134 IS
135 l_x_line_rec OE_Order_PUB.Line_Rec_Type;
136 l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
137 l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
138 l_control_rec OE_GLOBALS.Control_Rec_Type;
139 l_return_status VARCHAR2(1);
140 BEGIN
141
142 /* chhung delete the content of all procedures. Request by Esha */
143 null;
144
145 END Delete_Row;
146
147
148 PROCEDURE Get_line
149 (
150 p_line_id IN NUMBER
151 , x_line_rec OUT NOCOPY OE_Order_PUB.Line_Rec_Type
152 )
153 IS
154 BEGIN
155
156 /* chhung delete the content of all procedures. Request by Esha */
157 null;
158
159 END Get_Line;
160
161 PROCEDURE Clear_Line
162 IS
163 BEGIN
164
165 /* chhung delete the content of all procedures. Request by Esha */
166 null;
167
168 END Clear_Line;
169
170
171
172
173 END Oe_Portal_Line;