1 PACKAGE CSD_ESTIMATES_FROM_BOM_PVT AS
2 /* $Header: csdvboms.pls 120.0 2008/02/23 17:07:07 subhat noship $*/
3
4 /* This is the wrapper Procedure to call the Bom Exploder.
5 -- This would retrieve a PL/SQL table and then insert it into the
6 --temporary table.
7 --@param:p_item: name of the item to be exploded.
8 --@param:p_alt_bom: alternate BOM if any.
9 */
10
11 PROCEDURE explode_bom_items(p_itemId IN NUMBER,p_alt_bom IN VARCHAR2 DEFAULT NULL );
12
13 PROCEDURE create_estimate_lines(p_itemQty IN varchar2_table_200,
14 p_repair_line_id IN NUMBER,
15 p_repair_type_id IN NUMBER,
16 p_currency_code IN VARCHAR2,
17 p_org_id IN NUMBER,
18 p_repair_estimate_id IN NUMBER,
19 p_pricelist_header_id IN NUMBER,
20 p_contract_line_id IN NUMBER default null,
21 p_incident_id IN NUMBER,
22 p_init_msg_list IN VARCHAR2,
23 x_msg_data OUT NOCOPY VARCHAR2,
24 x_msg_count OUT NOCOPY NUMBER,
25 x_return_status OUT NOCOPY varchar2);
26
27 FUNCTION get_default_contract(l_contract_line_id IN NUMBER,
28 l_repair_type_id IN NUMBER,
29 x_msg_count OUT NOCOPY NUMBER,
30 x_msg_data OUT NOCOPY VARCHAR2,
31 x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER;
32
33
34 FUNCTION get_item_cost(p_item_id IN number,
35 p_uom IN varchar2,
36 p_currency_code IN varchar2,
37 p_org_id IN NUMBER,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2,
40 x_return_status OUT NOCOPY VARCHAR2) return NUMBER ;
41
42 FUNCTION get_selling_price(p_item_id IN number,
43 p_uom IN varchar2,
44 p_quantity IN number,
45 p_pricelist_header_id IN number,
46 p_currency_code IN varchar2,
47 p_org_id IN NUMBER,
48 x_msg_count OUT NOCOPY NUMBER,
49 x_msg_data OUT NOCOPY VARCHAR2,
50 x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER;
51
52 FUNCTION get_discount_price(p_contract_line_id IN NUMBER,p_repair_type_id IN number,
53 p_selling_price IN NUMBER,p_quantity IN NUMBER,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 x_return_status OUT NOCOPY VARCHAR2)RETURN NUMBER;
57
58 END CSD_ESTIMATES_FROM_BOM_PVT;