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
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.
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: *
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
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)
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:
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(
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,
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,
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,
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
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:
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: );
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:
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,
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,
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,
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,
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,
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,
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
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: );
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:
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(