DBA Data[Home] [Help]

APPS.HZ_EMAIL_DOMAINS_V2PUB dependencies on FND_API

Line 53: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

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

Line 58: * be FND_API.G_RET_STS_SUCCESS (success),

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.

Line 59: * FND_API.G_RET_STS_ERROR (error),

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: *

Line 60: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

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

Line 80: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

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)

Line 82: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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:

Line 83: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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(

Line 88: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

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,

Line 89: p_from_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,

Line 91: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 92: p_to_fk_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

Line 93: p_par_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:

Line 94: p_batch_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: );

Line 95: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

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:

Line 101: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

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,

Line 102: p_from_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,

Line 103: p_to_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 104: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 105: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

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,

Line 106: p_par_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,

Line 108: p_exp_ent_name 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

Line 109: p_exp_par_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

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: );

Line 110: p_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,

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:

Line 111: p_par_pk_column 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(