1 PACKAGE OZF_TP_UTIL_QUERIES AS
2 /* $Header: ozfvtpqs.pls 120.2 2005/12/19 13:21:03 gramanat ship $ */
3
4 TYPE QUALIFIER_REC_TYPE IS RECORD
5 (
6 qualifier_context VARCHAR2(30),
7 qualifier_attribute VARCHAR2(30),
8 qualifier_attr_value VARCHAR2(30)
9 );
10
11
12 TYPE QUALIFIER_TBL_TYPE IS TABLE OF QUALIFIER_REC_TYPE
13 INDEX BY BINARY_INTEGER;
14
15 -- FUNCTION
16 FUNCTION get_party_name(p_site_use_id IN NUMBER) return VARCHAR2;
17 -- get activity description for Schedules and Offers
18 FUNCTION get_activity_description(activity_class IN VARCHAR2 DEFAULT NULL, activity_id IN NUMBER DEFAULT NULL) RETURN VARCHAR2;
19
20 FUNCTION get_activity_access(p_object_class IN VARCHAR2,p_object_id IN NUMBER,p_resource_id IN NUMBER) RETURN VARCHAR2;
21
22 FUNCTION get_uom_conv(p_object_id IN VARCHAR2
23 ,p_qty IN NUMBER
24 ,p_from_uom IN VARCHAR2
25 ,p_to_uom IN VARCHAR2) RETURN NUMBER;
26
27 FUNCTION get_a_alert(p_object_id IN NUMBER,
28 p_object_type IN VARCHAR2,
29 p_report_date IN DATE,
30 p_resource_id IN NUMBER,
31 p_alert_type IN VARCHAR2,
32 p_alert_for IN VARCHAR2) RETURN VARCHAR2;
33
34 FUNCTION get_alert(p_site_use_id IN NUMBER,
35 p_cust_account_id IN NUMBER,
36 p_report_date IN DATE,
37 p_resource_id IN NUMBER,
38 p_alert_type IN VARCHAR2,
39 p_alert_for IN VARCHAR2) RETURN VARCHAR2;
40
41 FUNCTION get_p_alert(p_product_attribute IN VARCHAR2,
42 p_product_attr_value IN NUMBER,
43 p_report_date IN DATE,
44 p_resource_id IN NUMBER,
45 p_alert_type IN VARCHAR2,
46 p_alert_for IN VARCHAR2) RETURN VARCHAR2;
47
48
49 PROCEDURE get_list_price(
50 p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
52 p_commit IN VARCHAR2 := FND_API.g_false,
53
54 p_obj_id IN NUMBER,
55 p_obj_type IN VARCHAR2,
56 p_product_attribute IN VARCHAR2,
57 p_product_attr_value IN VARCHAR2,
58 p_fcst_uom IN VARCHAR2,
59 p_currency_code IN VARCHAR2,
60 p_price_list_id IN NUMBER,
61 p_qualifier_tbl IN OZF_TP_UTIL_QUERIES.QUALIFIER_TBL_TYPE,
62
63 x_list_price OUT NOCOPY NUMBER,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2
67 );
68
69 FUNCTION get_quota_unit RETURN VARCHAR2;
70
71 FUNCTION get_item_descr ( p_FlexField_Name IN VARCHAR2
72 ,p_Context_Name IN VARCHAR2
73 ,p_attribute_name IN VARCHAR2
74 ,p_attr_value IN VARCHAR2 ) RETURN VARCHAR2;
75
76 FUNCTION get_item_name ( p_inventory_item_id IN NUMBER) RETURN VARCHAR2;
77 FUNCTION get_item_cost ( p_inventory_item_id IN NUMBER) RETURN NUMBER;
78
79
80 END OZF_TP_UTIL_QUERIES;
81 --show errors;