[Home] [Help]
PACKAGE: APPS.EDW_UTIL
Source
1 PACKAGE EDW_UTIL AUTHID CURRENT_USER AS
2 /* $Header: EDWSRGTS.pls 115.7 2002/12/05 22:20:58 arsantha ship $ */
3 VERSION CONSTANT CHAR(80) := '$Header: EDWSRGTS.pls 115.7 2002/12/05 22:20:58 arsantha ship $';
4
5 -- ------------------------
6 -- Public Functions
7 -- ------------------------
8
9 -- The function get_base_currency returns the functional currecy that is defined for
10 -- this organization unit.
11
12
13 FUNCTION get_base_currency( p_organization_id IN NUMBER) return VARCHAR2;
14
15
16 -- The function get_item_cost returns the cost price of the item as defined is
17 -- cst_item_costs
18
19 FUNCTION get_item_cost( p_item_id IN NUMBER, p_org_id IN NUMBER)
20 return NUMBER;
21
22 /* FUNCTION get_item_price( p_item_id IN NUMBER, p_org_id IN NUMBER,
23 p_price_list_id in number default null ,
24 p_currency in varchar2 default null) return NUMBER;
25 */
26 FUNCTION get_est_ship_date( p_disposition_id IN NUMBER,
27 p_organization_id IN NUMBER,
28 p_compile_designator IN VARCHAR2) return DATE;
29 FUNCTION get_pto_mmt_count(p_line_id IN NUMBER) return NUMBER;
30 FUNCTION get_line_detail_count(p_line_id IN NUMBER) return NUMBER;
31 FUNCTION get_party_id(p_sold_to_org_id IN NUMBER) return NUMBER;
32
33 FUNCTION get_wh_global_currency RETURN VARCHAR2 ;
34
35 FUNCTION get_rep_sched_scrapped_qty(rep_sched_id number,
36 organization_id number) RETURN NUMBER;
37
38 FUNCTION get_app_info return VARCHAR2 ;
39 PRAGMA RESTRICT_REFERENCES (get_app_info, WNDS, WNPS);
40
41 FUNCTION get_base_transaction_value(p_transaction_id number,
42 p_transfer_transaction_id number,
43 p_action_id number,
44 p_quantity number) return NUMBER;
45 FUNCTION get_edw_base_uom(p_uom_code IN VARCHAR2,
46 p_inventory_id IN NUMBER) RETURN VARCHAR2;
47 FUNCTION get_edw_base_uom(p_uom_code IN VARCHAR2,
48 p_inventory_id IN NUMBER, p_instance_code IN VARCHAR2) RETURN VARCHAR2;
49 FUNCTION get_uom_conv_rate(p_uom_code IN VARCHAR2,
50 p_inventory_id IN NUMBER) RETURN NUMBER;
51 FUNCTION get_uom_conv_rate(p_uom_code IN VARCHAR2,
52 p_inventory_id IN NUMBER, p_instance_code IN VARCHAR2) RETURN NUMBER;
53 FUNCTION get_uom_conv_rate(p_inventory_id IN NUMBER,
54 p_from_edw_base_uom_code IN VARCHAR2,
55 p_to_edw_base_uom_code IN VARCHAR2)
56 RETURN NUMBER;
57 FUNCTION get_uom_conv_rate(p_inventory_id IN NUMBER,
58 p_from_edw_base_uom_code IN VARCHAR2,
59 p_to_edw_base_uom_code IN VARCHAR2, p_instance_code IN VARCHAR2)
60 RETURN NUMBER;
61 FUNCTION get_edw_uom(p_uom_code IN VARCHAR2,
62 p_inventory_id IN NUMBER) RETURN VARCHAR2;
63 FUNCTION get_edw_uom(p_uom_code IN VARCHAR2,
64 p_inventory_id IN NUMBER, p_instance_code IN VARCHAR2) RETURN VARCHAR2;
65 FUNCTION bus_unit_id(p_type IN NUMBER,
66 p_organization_id IN NUMBER) return NUMBER;
67
68 PRAGMA RESTRICT_REFERENCES (get_base_transaction_value,WNDS, WNPS, RNPS);
69
70 PRAGMA RESTRICT_REFERENCES (get_rep_sched_scrapped_qty,WNDS, WNPS, RNPS);
71
72 PRAGMA RESTRICT_REFERENCES (get_base_currency,WNDS, WNPS, RNPS);
73 PRAGMA RESTRICT_REFERENCES (get_item_cost,WNDS, WNPS, RNPS);
74 --PRAGMA RESTRICT_REFERENCES (get_item_price,WNDS, WNPS, RNPS);
75 PRAGMA RESTRICT_REFERENCES (get_est_ship_date, WNDS, WNPS, RNPS);
76 PRAGMA RESTRICT_REFERENCES (get_pto_mmt_count, WNDS, WNPS, RNPS);
77 PRAGMA RESTRICT_REFERENCES (get_line_detail_count, WNDS, WNPS, RNPS);
78 PRAGMA RESTRICT_REFERENCES (get_party_id, WNDS, WNPS, RNPS);
79 PRAGMA RESTRICT_REFERENCES (get_wh_global_currency, WNDS, WNPS, RNPS);
80 PRAGMA RESTRICT_REFERENCES (get_edw_base_uom, WNDS, WNPS, RNPS);
81 PRAGMA RESTRICT_REFERENCES (get_uom_conv_rate, WNDS, WNPS, RNPS);
82 PRAGMA RESTRICT_REFERENCES (get_edw_uom, WNDS, WNPS, RNPS);
83 PRAGMA RESTRICT_REFERENCES (bus_unit_id, WNDS, WNPS, RNPS);
84
85
86 END EDW_UTIL;