1 PACKAGE IBE_ORDER_UTIL_PVT AUTHID CURRENT_USER AS
2 /* $Header: IBEVOUTS.pls 120.3 2005/11/27 13:43:52 susinha noship $ */
3
4 PROCEDURE Get_Ord_Recurring_totals
5 ( p_header_id IN NUMBER,
6 x_charge_periodicity_code OUT NOCOPY JTF_VARCHAR2_TABLE_300,
7 x_charge_periodicity_desc OUT NOCOPY JTF_VARCHAR2_TABLE_300,
8 x_charge_periodicity_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_300,
9 x_rec_subtotal OUT NOCOPY JTF_NUMBER_TABLE,
10 x_rec_tax OUT NOCOPY JTF_NUMBER_TABLE,
11 x_rec_charges OUT NOCOPY JTF_NUMBER_TABLE,
12 x_rec_total OUT NOCOPY JTF_NUMBER_TABLE,
13 X_return_status OUT NOCOPY VARCHAR2,
14 X_msg_count OUT NOCOPY NUMBER,
15 X_msg_data OUT NOCOPY VARCHAR2
16 );
17
18
19 PROCEDURE Get_Adjustments(
20 x_adjustment_name OUT NOCOPY JTF_VARCHAR2_TABLE_300 ,
21 x_adjustment_description OUT NOCOPY JTF_VARCHAR2_TABLE_2000 ,
22 x_list_line_no OUT NOCOPY JTF_VARCHAR2_TABLE_300 ,
23 x_adjustment_type_code OUT NOCOPY JTF_VARCHAR2_TABLE_300 ,
24 x_arithmetic_operator OUT NOCOPY JTF_VARCHAR2_TABLE_300 ,
25 x_return_status OUT NOCOPY VARCHAR2,
26 p_header_id IN NUMBER:= FND_API.G_MISS_NUM,
27 p_line_id IN NUMBER:= FND_API.G_MISS_NUM,
28 x_price_adjustment_id OUT NOCOPY jtf_number_table ,
29 x_operand OUT NOCOPY jtf_number_table ,
30 x_unit_discount_amount OUT NOCOPY jtf_number_table,
31 x_count_lines OUT NOCOPY NUMBER
32
33 );
34
35
36
37 PROCEDURE Get_MACD_Action_Mode
38 ( p_header_id IN NUMBER,
39 x_top_model_line_id OUT NOCOPY JTF_NUMBER_TABLE,
40 x_line_is_reconfig OUT NOCOPY JTF_VARCHAR2_TABLE_100,
41 x_return_status OUT NOCOPY VARCHAR2
42 );
43
44 -- Function to get the PRIMARY Phone and Email for the iStore Party
45 -- i.e For Party-Type=B2C, get for party of type PERSON (pass person_party_id)
46 -- For Party-Type=B2B, get for party of type PARTY_RELATIONSHIP(pass party_id of type party_relationship)
47 FUNCTION GET_PHONE_EMAIL
48 ( p_party_id IN NUMBER
49 ) RETURN VARCHAR2;
50
51
52 -- The following procudure verifies whether the last_updated_date passed is
53 -- older than the last_updated_date present in the DB
54
55 PROCEDURE validate_last_update_date
56 (p_header_id IN NUMBER,
57 p_last_update_date IN DATE,
58 x_is_diff_last_update OUT NOCOPY VARCHAR2);
59
60
61 END IBE_ORDER_UTIL_PVT;