2178: p_batch_id in number,
2179: p_batch_party_id in number,
2180: p_return_status in out nocopy varchar2) is
2181: begin
2182: p_return_status := FND_API.G_RET_STS_SUCCESS;
2183:
2184: if (p_from_fk_id <> p_to_fk_id) then
2185:
2186: update fnd_user
3513:
3514: ----------------------------------------------------------------------------
3515: --
3516: -- CreatePendingUser (PUBLIC)
3517: -- Create a user whose start_date and end_date = FND_API.G_MISS_DATE as
3518: -- a pending user.
3519: -- Pending user is created when a user registers a user account through
3520: -- UMX with an aproval process.
3521: --
3548: x_user_name,
3549: x_owner,
3550: x_unencrypted_password,
3551: x_session_number,
3552: FND_API.G_MISS_DATE,
3553: FND_API.G_MISS_DATE,
3554: null,
3555: x_description,
3556: x_password_date,
3549: x_owner,
3550: x_unencrypted_password,
3551: x_session_number,
3552: FND_API.G_MISS_DATE,
3553: FND_API.G_MISS_DATE,
3554: null,
3555: x_description,
3556: x_password_date,
3557: x_password_accesses_left,
3599: select user_id, user_guid
3600: into l_user_id, l_user_guid
3601: from fnd_user
3602: where user_name = upper(username)
3603: and to_char(start_date) = to_char(FND_API.G_MISS_DATE)
3604: and to_char(end_date) = to_char(FND_API.G_MISS_DATE);
3605:
3606: exception
3607: when no_data_found then
3600: into l_user_id, l_user_guid
3601: from fnd_user
3602: where user_name = upper(username)
3603: and to_char(start_date) = to_char(FND_API.G_MISS_DATE)
3604: and to_char(end_date) = to_char(FND_API.G_MISS_DATE);
3605:
3606: exception
3607: when no_data_found then
3608:
3641: end if;
3642:
3643: delete from fnd_user
3644: where user_name = upper(username)
3645: and to_char(start_date) = to_char(FND_API.G_MISS_DATE)
3646: and to_char(end_date) = to_char(FND_API.G_MISS_DATE);
3647:
3648: if (sql%rowcount = 0) then
3649: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3642:
3643: delete from fnd_user
3644: where user_name = upper(username)
3645: and to_char(start_date) = to_char(FND_API.G_MISS_DATE)
3646: and to_char(end_date) = to_char(FND_API.G_MISS_DATE);
3647:
3648: if (sql%rowcount = 0) then
3649: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3650: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,
3982: p_batch_id in number,
3983: p_batch_party_id in number,
3984: p_return_status in out nocopy varchar2) is
3985: begin
3986: p_return_status := FND_API.G_RET_STS_SUCCESS;
3987:
3988: if (p_from_fk_id <> p_to_fk_id) then
3989:
3990: update fnd_user