APPS.FND_USER_PKG dependencies on FND_API

Line 1575: p_return_status := FND_API.G_RET_STS_SUCCESS;

1571: p_batch_id in number,
1572: p_batch_party_id in number,
1573: p_return_status in out nocopy varchar2) is
1574: begin
1575: p_return_status := FND_API.G_RET_STS_SUCCESS;
1576:
1577: if (p_from_fk_id <> p_to_fk_id) then
1578:
1579: update fnd_user

Line 2910: -- Create a user whose start_date and end_date = FND_API.G_MISS_DATE as

2906:
2907: ----------------------------------------------------------------------------
2908: --
2909: -- CreatePendingUser (PUBLIC)
2910: -- Create a user whose start_date and end_date = FND_API.G_MISS_DATE as
2911: -- a pending user.
2912: -- Pending user is created when a user registers a user account through
2913: -- UMX with an aproval process.
2914: --

Line 2945: FND_API.G_MISS_DATE,

2941: x_user_name,
2942: x_owner,
2943: x_unencrypted_password,
2944: x_session_number,
2945: FND_API.G_MISS_DATE,
2946: FND_API.G_MISS_DATE,
2947: null,
2948: x_description,
2949: x_password_date,

Line 2946: FND_API.G_MISS_DATE,

2942: x_owner,
2943: x_unencrypted_password,
2944: x_session_number,
2945: FND_API.G_MISS_DATE,
2946: FND_API.G_MISS_DATE,
2947: null,
2948: x_description,
2949: x_password_date,
2950: x_password_accesses_left,

Line 2989: and to_char(start_date) = to_char(FND_API.G_MISS_DATE)

2985: select user_id, user_guid
2986: into l_user_id, l_user_guid
2987: from fnd_user
2988: where user_name = upper(username)
2989: and to_char(start_date) = to_char(FND_API.G_MISS_DATE)
2990: and to_char(end_date) = to_char(FND_API.G_MISS_DATE);
2991:
2992: exception
2993: when no_data_found then

Line 2990: and to_char(end_date) = to_char(FND_API.G_MISS_DATE);

2986: into l_user_id, l_user_guid
2987: from fnd_user
2988: where user_name = upper(username)
2989: and to_char(start_date) = to_char(FND_API.G_MISS_DATE)
2990: and to_char(end_date) = to_char(FND_API.G_MISS_DATE);
2991:
2992: exception
2993: when no_data_found then
2994: fnd_message.set_name('FND', 'FND_INVALID_USER');

Line 3015: and to_char(start_date) = to_char(FND_API.G_MISS_DATE)

3011:
3012: -- Only allow to delete a PENDING user
3013: delete from fnd_user
3014: where user_name = upper(username)
3015: and to_char(start_date) = to_char(FND_API.G_MISS_DATE)
3016: and to_char(end_date) = to_char(FND_API.G_MISS_DATE);
3017:
3018: if (sql%rowcount = 0) then
3019: fnd_message.set_name('FND', 'FND_INVALID_USER');

Line 3016: and to_char(end_date) = to_char(FND_API.G_MISS_DATE);

3012: -- Only allow to delete a PENDING user
3013: delete from fnd_user
3014: where user_name = upper(username)
3015: and to_char(start_date) = to_char(FND_API.G_MISS_DATE)
3016: and to_char(end_date) = to_char(FND_API.G_MISS_DATE);
3017:
3018: if (sql%rowcount = 0) then
3019: fnd_message.set_name('FND', 'FND_INVALID_USER');
3020: fnd_message.set_token('USER_NAME', username);

Line 3304: p_return_status := FND_API.G_RET_STS_SUCCESS;

3300: p_batch_id in number,
3301: p_batch_party_id in number,
3302: p_return_status in out nocopy varchar2) is
3303: begin
3304: p_return_status := FND_API.G_RET_STS_SUCCESS;
3305:
3306: if (p_from_fk_id <> p_to_fk_id) then
3307:
3308: update fnd_user