1 PACKAGE PON_LOCALE_PKG as
2 /*$Header: PONLOCS.pls 120.1 2006/05/29 05:37:13 pchintap noship $ */
3
4 /* Constants defined for the name format */
5 NAME_FIRST_LAST CONSTANT NUMBER := 1;
6 NAME_LAST_FIRST CONSTANT NUMBER := 2;
7 NAME_FIRST CONSTANT NUMBER := 3;
8 NAME_LAST CONSTANT NUMBER := 4;
9 NAME_TITLE_LAST CONSTANT NUMBER := 5;
10 NAME_TITLE_LAST_FIRST CONSTANT NUMBER := 6;
11 NAME_TITLE_FIRST_LAST CONSTANT NUMBER := 7;
12 NAME_TITLE_FIRST CONSTANT NUMBER := 8;
13 NAME_PREFIX_F_M_L_SUFFIX CONSTANT NUMBER := 9;
14 NAME_F_M_L_SUFFIX CONSTANT NUMBER := 10;
15 NAME_FIRST_M_LAST CONSTANT NUMBER := 11;
16 NAME_LAST_TITLE_FIRST CONSTANT NUMBER := 12;
17 --This is the default pattern that will be used across sourcing.
18 --This will be used by the function party_display_name_for_queries.
19 --One has to change this variable to appropriate display pattern if
20 --one needs to change the name display pattern in future.
21 DEFAULT_NAME_DISPLAY_PATTERN CONSTANT NUMBER := NAME_LAST_TITLE_FIRST;
22 /**
23 Retrieves Party display name according to the given Name format.
24 */
25 PROCEDURE party_display_name (
26 p_first_name IN VARCHAR2
27 , p_last_name IN VARCHAR2
28 , p_middle_name IN VARCHAR2
29 , p_prefix IN VARCHAR2
30 , p_suffix IN VARCHAR2
31 , p_name_format IN NUMBER
32 , p_language IN VARCHAR2
33 , x_display_name OUT NOCOPY VARCHAR2
34 , x_status OUT NOCOPY VARCHAR2
35 , x_exception_msg OUT NOCOPY VARCHAR2
36 );
37
38 /**
39 Retrieves Party display name according to the given Name format.
40 */
41 PROCEDURE party_display_name (
42 p_first_name IN VARCHAR2
43 , p_last_name IN VARCHAR2
44 , p_name_format IN NUMBER
45 , p_language IN VARCHAR2
46 , x_display_name OUT NOCOPY VARCHAR2
47 , x_status OUT NOCOPY VARCHAR2
48 , x_exception_msg OUT NOCOPY VARCHAR2
49 );
50 /**
51 Retrieves Party display name according to the given Name format.
52 */
53
54 PROCEDURE retrieve_party_display_name (
55 p_party_id IN NUMBER
56 , p_name_format IN NUMBER
57 , p_language IN VARCHAR2
58 , x_display_name OUT NOCOPY VARCHAR2
59 , x_status OUT NOCOPY VARCHAR2
60 , x_exception_msg OUT NOCOPY VARCHAR2
61 );
62
63 /**
64 Returns Party display name according to the given Name format.
65 */
66 FUNCTION get_party_display_name(
67 p_party_id NUMBER
68 , p_name_format NUMBER
69 , p_language VARCHAR2)
70 RETURN VARCHAR2;
71
72 /**
73 Returns Party display name where
74 language : userenv('LANG')
75 Name_Format : NAME_FIRST_LAST
76 */
77 FUNCTION get_party_display_name( p_party_id NUMBER) RETURN VARCHAR2;
78
79
80 /**
81 Retrieves Party display name according to the given Name format.
82 Wrapper on the procedure retrieve_party_display_name
83 */
84 FUNCTION party_display_name (
85 p_first_name IN VARCHAR2
86 , p_last_name IN VARCHAR2
87 , p_middle_name IN VARCHAR2
88 , p_prefix IN VARCHAR2
89 , p_suffix IN VARCHAR2
90 , p_language IN VARCHAR2) RETURN VARCHAR2;
91
92 END PON_LOCALE_PKG;