PACKAGE: APPS.HZ_DNBUI_PVT

Source

1 PACKAGE HZ_DNBUI_PVT AUTHID CURRENT_USER AS
2 /*$Header: ARHDNBUS.pls 120.2 2005/10/30 03:51:51 appldev ship $*/
3 
4 FUNCTION get_lookup_meaning (p_lookup_type  IN VARCHAR2,
5                              p_lookup_code  IN VARCHAR2)
6 RETURN VARCHAR2;
7 
8 function get_financial_number(p_financial_name IN VARCHAR2, p_financial_report_id NUMBER) RETURN NUMBER;
9 
10 function get_financial_number_currency(
11 	p_financial_name IN VARCHAR2,
12 	p_financial_report_id NUMBER)
13 RETURN VARCHAR2;
14 
15 function get_financial_number_actflg(
16 	p_financial_name IN VARCHAR2,
17 	p_financial_report_id NUMBER)
18 RETURN VARCHAR2;
19 
20 function get_primary_phone_number(
21 	p_party_id IN NUMBER,
22 	p_source_type IN VARCHAR2)
23 RETURN VARCHAR2;
24 
25 function get_primary_fax_number(
26 	p_party_id IN NUMBER,
27 	p_source_type IN VARCHAR2)
28 RETURN VARCHAR2;
29 
30 function get_all_phone_numbers(
31 	p_party_id IN NUMBER,
32 	p_source_type IN VARCHAR2)
33 RETURN VARCHAR2;
34 
35 function get_country_name(
36 	p_country_code IN VARCHAR2)
37 RETURN VARCHAR2;
38 
39 function get_max_financial_report_id(
40         p_party_id      		IN      NUMBER,
41         p_type_of_financial_report	IN      VARCHAR2,
42         p_actual_content_source   	IN      VARCHAR2)
43 RETURN NUMBER;
44 
45 function get_max_credit_rating_id(
46 	p_party_id      	IN      NUMBER,
47 	p_actual_content_source   IN      VARCHAR2)
48 RETURN NUMBER;
49 
50 /*
51 function get_currency_symbol(
52 	p_financial_name IN VARCHAR2,
53 	p_financial_report_id NUMBER)
54 RETURN VARCHAR2;
55 */
56 
57 function get_financial_symbol_number(
58     p_financial_name IN VARCHAR2,
59     p_financial_report_id NUMBER)
60 RETURN VARCHAR2;
61 
62 
63 function get_SIC_code(
64     p_class_category IN VARCHAR2,
65     p_party_id       IN NUMBER,
66     p_sequence       IN NUMBER,
67     p_actual_content_source IN VARCHAR2  := 'DNB'
68     )
69 RETURN VARCHAR2;
70 
71 function get_location_id (
72     p_party_id IN NUMBER,
73     p_actual_content_source in VARCHAR2)
74 RETURN NUMBER;
75 
76 function get_first_available_report(
77         p_party_id      		IN      NUMBER,
78         p_actual_content_source		IN	VARCHAR2)
79 RETURN VARCHAR2;
80 
81 
82 END HZ_DNBUI_PVT;