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