1 PACKAGE HZ_EMAIL_DOMAINS_V2PUB AUTHID CURRENT_USER AS
2 /*$Header: ARH2EMDS.pls 115.5 2003/10/31 20:36:47 rrangan noship $ */
3
4 --------------------------------------
5 -- declaration of public procedures and functions
6 --------------------------------------
7
8 /**
9 * FUNCTION transpose_domain
10 *
11 * DESCRIPTION
12 * This API will accept an input domain, and return it with the segments
13 * transposed (reversed). The return value should be all-uppercase.
14 *
15 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
16 *
17 * ARGUMENTS
18 * IN:
19 * p_domain_name Input domain
20 *
21 * IN/OUT:
22 * OUT:
23 *
24 * NOTES
25 *
26 * MODIFICATION HISTORY
27 *
28 * 21-APR-2003 Sreedhar Mohan o Created.
29 *
30 */
31
32 FUNCTION transpose_domain(
33 p_domain_name IN VARCHAR2
34 ) RETURN VARCHAR2;
35
36 --------------------------------------
37 -- declaration of public procedures and functions
38 --------------------------------------
39
40 /**
41 * PROCEDURE create_email_domain
42 *
43 * DESCRIPTION
44 * This API will insert a row into the HZ_EMAIL_DOMAINS table. It should
45 * internally call the function defined above (transpose_domain), and
46 * insert the transposed value as well.
47 *
48 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
49 *
50 * ARGUMENTS
51 * IN:
52 * p_party_id Initialize message stack if it is set to
53 * FND_API.G_TRUE. Default is FND_API.G_FALSE.
54 * p_domain_name Financial report record.
55 * IN/OUT:
56 * OUT:
57 * x_return_status Return status after the call. The status can
58 * be FND_API.G_RET_STS_SUCCESS (success),
59 * FND_API.G_RET_STS_ERROR (error),
60 * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
61 * x_msg_count Number of messages in message stack.
62 * x_msg_data Message text if x_msg_count is 1.
63 *
64 * NOTES
65 *
66 * MODIFICATION HISTORY
67 *
68 * 21-APR-2003 Sreedhar Mohan o Created.
69 *
70 */
71
72 PROCEDURE create_email_domain(
73 p_party_id IN NUMBER,
74 p_domain_name IN VARCHAR2,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2);
78
79 FUNCTION check_email_domain_dup(
80 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
81 x_to_id IN OUT NOCOPY NUMBER,
82 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
83 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
84 x_return_status IN OUT NOCOPY VARCHAR2)
85 RETURN VARCHAR2;
86
87 PROCEDURE email_domains_merge(
88 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
89 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
90 x_to_id IN OUT NOCOPY NUMBER,
91 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
92 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
93 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
94 p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
95 p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
96 x_return_status OUT NOCOPY VARCHAR2
97
98 );
99
100 PROCEDURE check_params(
101 p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
102 p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
103 p_to_id IN NUMBER:=FND_API.G_MISS_NUM,
104 p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
105 p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
106 p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
107 p_proc_name IN VARCHAR2,
108 p_exp_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
109 p_exp_par_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
110 p_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
111 p_par_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
112 x_return_status IN OUT NOCOPY VARCHAR2
113 );
114
115 FUNCTION get_email_domains(
116 p_party_id IN NUMBER,
117 p_entity IN VARCHAR2,
118 p_attribute IN VARCHAR2,
119 p_context IN VARCHAR2 DEFAULT NULL)
120 RETURN VARCHAR2;
121
122 FUNCTION CORE_DOMAIN(
123 p_input_str IN VARCHAR2,
124 p_language IN VARCHAR2,
125 p_attribute_name IN VARCHAR2,
126 p_entity_name IN VARCHAR2)
127 RETURN VARCHAR2;
128
129 FUNCTION FULL_DOMAIN(
130 p_input_str IN VARCHAR2,
131 p_language IN VARCHAR2,
132 p_attribute_name IN VARCHAR2,
133 p_entity_name IN VARCHAR2)
134 RETURN VARCHAR2;
135
136
137
138 END HZ_EMAIL_DOMAINS_V2PUB;
139
140