DBA Data[Home] [Help]

PACKAGE: APPS.OE_PORTAL_LINE

Source


1 PACKAGE OE_Portal_Line AS
2 /* $Header: OEXLPORS.pls 120.0 2005/06/01 01:50:37 appldev noship $ */
3 
4 
5 
6 PROCEDURE Validate_Write_Line
7 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
8 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
9 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
10 ,   p_line_id                       IN   NUMBER
11 , p_header_id                       IN NUMBER
12 , p_db_flag                         IN VARCHAR2 DEFAULT 'N'
13 , p_sold_to_org_id                  IN NUMBER
14 , p_inventory_item_id               IN NUMBER
15 , p_ordered_quantity               IN NUMBER
16 , p_order_quantity_uom             IN VARCHAR2
17 , p_ship_to_org_id                 IN NUMBER
18 , p_request_date                   IN VARCHAR2
19 ,   x_discounts                     OUT NOCOPY /* file.sql.39 change */ NUMBER
20 ,   x_charges                       OUT NOCOPY /* file.sql.39 change */ NUMBER
21 ,   x_taxes                         OUT NOCOPY /* file.sql.39 change */ NUMBER
22 ,   x_line_tax_value                OUT NOCOPY /* file.sql.39 change */ NUMBER
23 ,   x_schedule_ship_date            OUT NOCOPY /* file.sql.39 change */ VARCHAR2
24 ,   x_schedule_arrival_date         OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25 ,   x_schedule_status_code          OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26 ,   x_schedule_action_code          OUT NOCOPY /* file.sql.39 change */ VARCHAR2
27 ,   x_ship_from_address1            OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 ,   x_ship_from_address2            OUT NOCOPY /* file.sql.39 change */ VARCHAR2
29 ,   x_ship_from_address3            OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30 ,   x_ship_from_address4            OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31 ,   x_ship_from_location            OUT NOCOPY /* file.sql.39 change */ VARCHAR2
32 ,   x_ship_from_org                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33 ,   x_ship_from_org_id              OUT NOCOPY /* file.sql.39 change */ NUMBER
34 ,   x_promise_date                  OUT NOCOPY /* file.sql.39 change */ VARCHAR2
35 ,   x_unit_selling_price			 OUT NOCOPY /* file.sql.39 change */	NUMBER
36 ,   x_unit_list_price			 OUT NOCOPY /* file.sql.39 change */ NUMBER
37 ,   x_list_percent				 OUT NOCOPY /* file.sql.39 change */ NUMBER
38 ,   x_selling_percent			 OUT NOCOPY /* file.sql.39 change */ NUMBER
39 ,   x_pricing_quantity			 OUT NOCOPY /* file.sql.39 change */ NUMBER
40 ,   x_pricing_quantity_uom		 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
41 ,   x_calculate_price_flag		 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42 ,   x_calculate_price_descr         OUT NOCOPY /* file.sql.39 change */ VARCHAR2
43 ,   x_inventory_item_id			 OUT NOCOPY /* file.sql.39 change */ NUMBER
44 , x_customer_item                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
45 , x_inventory_item                  OUT NOCOPY /* file.sql.39 change */ VARCHAR2
46 , x_item_desc                       OUT NOCOPY /* file.sql.39 change */ VARCHAR2
47 , x_ordered_quantity                OUT NOCOPY /* file.sql.39 change */ NUMBER
48 , x_order_quantity_uom            OUT NOCOPY /* file.sql.39 change */ VARCHAR2
49 , x_request_date                    OUT NOCOPY /* file.sql.39 change */ DATE
50 ,   x_ordered_item_id			 OUT NOCOPY /* file.sql.39 change */ NUMBER
51 ,   x_price_list_id				 OUT NOCOPY /* file.sql.39 change */ NUMBER
52 ,   x_price_list				 OUT NOCOPY /* file.sql.39 change */  VARCHAR2
53 ,   x_payment_term_id			 OUT NOCOPY /* file.sql.39 change */ NUMBER
54 ,   x_payment_term				 OUT NOCOPY /* file.sql.39 change */ varchar2
55 ,   x_shipment_priority_code		 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
56 ,   x_shipment_priority			 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
57 ,   x_freight_terms_code			 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
58 ,   x_freight_terms				 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
59 ,   x_lock_control                  OUT NOCOPY /* file.sql.39 change */ NUMBER
60 , x_line_id                         OUT NOCOPY /* file.sql.39 change */ NUMBER
61 , x_ship_to_org_id                  OUT NOCOPY /* file.sql.39 change */ NUMBER
62 , x_ship_to_org                     OUT NOCOPY /* file.sql.39 change */ VARCHAR2
63 , x_ship_to_location                     OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64 , x_ship_to_address1                OUT NOCOPY /* file.sql.39 change */ VARCHAR2
65 , x_ship_to_address2                OUT NOCOPY /* file.sql.39 change */ VARCHAR2
66 , x_ship_to_address3                OUT NOCOPY /* file.sql.39 change */ VARCHAR2
67 , x_ship_to_address4                OUT NOCOPY /* file.sql.39 change */ VARCHAR2
68 );
69 
70 /*
71 PROCEDURE Schedule_Line (
72 p_inventory_item_id IN NUMBER ,
73 p_input_quantity IN NUMBER,
74 p_customer_id IN NUMBER,
75 p_customer_site_id IN NUMBER,
76 p_uom IN VARCHAR2,
77 p_need_by_date IN VARCHAR2,
78 x_return_status     OUT NOCOPY  file.sql.39 change  VARCHAR2,
79 x_msg_data          OUT NOCOPY  file.sql.39 change  VARCHAR2,
80 x_msg_count          OUT NOCOPY  file.sql.39 change  NUMBER
81 );
82 */
83 PROCEDURE Delete_Row
84 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
85 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
86 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
87 ,   p_line_id                     IN  NUMBER
88 );
89 
90 END OE_Portal_Line;