eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_USER_ACCT_INTERNAL dependencies on FND_USER

Line 11: g_empty_fnd_user_rec hr_user_acct_utility.fnd_user_rec;

7: g_max_user_name_length constant number := 100;
8: g_max_email_address_length constant number := 240;
9: g_max_fax_length constant number := 80;
10: g_api_vers constant number := 1.0;
11: g_empty_fnd_user_rec hr_user_acct_utility.fnd_user_rec;
12: g_emtpy_fnd_resp_tbl hr_user_acct_utility.fnd_responsibility_tbl;
13: g_emtpy_fnd_prof_opt_val_tbl hr_user_acct_utility.fnd_profile_opt_val_tbl;
14: --
15: -- ----------------------------------------------------------------------------

Line 80: -- |-------------------------- < create_fnd_user > ---------------------------|

76: --
77: --
78: --
79: -- ----------------------------------------------------------------------------
80: -- |-------------------------- < create_fnd_user > ---------------------------|
81: -- | NOTE: The fnd api fnd_user_pkg.create_user that this api will be calling |
82: -- | does not have code to handle AK securing attributes. Thus, this |
83: -- | api will not do any inserts into ak_web_user_sec_attr_values table.|
84: -- | So, this api does not do everything that the FND Create User form |

Line 81: -- | NOTE: The fnd api fnd_user_pkg.create_user that this api will be calling |

77: --
78: --
79: -- ----------------------------------------------------------------------------
80: -- |-------------------------- < create_fnd_user > ---------------------------|
81: -- | NOTE: The fnd api fnd_user_pkg.create_user that this api will be calling |
82: -- | does not have code to handle AK securing attributes. Thus, this |
83: -- | api will not do any inserts into ak_web_user_sec_attr_values table.|
84: -- | So, this api does not do everything that the FND Create User form |
85: -- | does. |

Line 90: -- Fix 2288014. Modified procedure create_fnd_user adding parameter

86: -- | No savepoint will be issued here because business support internal |
87: -- process is not supposed to issue any savepoint or rollback. |
88: -- ----------------------------------------------------------------------------
89: --
90: -- Fix 2288014. Modified procedure create_fnd_user adding parameter
91: -- p_password_date that could be passed to fnd_user_pkg.CreateUserId
92: PROCEDURE create_fnd_user
93: (p_hire_date in date default null
94: ,p_user_name in varchar2

Line 91: -- p_password_date that could be passed to fnd_user_pkg.CreateUserId

87: -- process is not supposed to issue any savepoint or rollback. |
88: -- ----------------------------------------------------------------------------
89: --
90: -- Fix 2288014. Modified procedure create_fnd_user adding parameter
91: -- p_password_date that could be passed to fnd_user_pkg.CreateUserId
92: PROCEDURE create_fnd_user
93: (p_hire_date in date default null
94: ,p_user_name in varchar2
95: ,p_password in out nocopy varchar2

Line 92: PROCEDURE create_fnd_user

88: -- ----------------------------------------------------------------------------
89: --
90: -- Fix 2288014. Modified procedure create_fnd_user adding parameter
91: -- p_password_date that could be passed to fnd_user_pkg.CreateUserId
92: PROCEDURE create_fnd_user
93: (p_hire_date in date default null
94: ,p_user_name in varchar2
95: ,p_password in out nocopy varchar2
96: ,p_user_start_date in date default null

Line 112: FROM fnd_user

108: ) IS
109:
110: CURSOR lc_get_user_name IS
111: SELECT user_name, user_id
112: FROM fnd_user
113: WHERE user_name = upper(p_user_name);
114:
115: l_proc varchar2(72) := g_package||'create_fnd_user';
116: l_fnd_user_start_date date default null;

Line 115: l_proc varchar2(72) := g_package||'create_fnd_user';

111: SELECT user_name, user_id
112: FROM fnd_user
113: WHERE user_name = upper(p_user_name);
114:
115: l_proc varchar2(72) := g_package||'create_fnd_user';
116: l_fnd_user_start_date date default null;
117: l_fnd_user_end_date date default null;
118: l_host_port_name varchar2(2000) default null;
119: l_pos number default 0;

Line 116: l_fnd_user_start_date date default null;

112: FROM fnd_user
113: WHERE user_name = upper(p_user_name);
114:
115: l_proc varchar2(72) := g_package||'create_fnd_user';
116: l_fnd_user_start_date date default null;
117: l_fnd_user_end_date date default null;
118: l_host_port_name varchar2(2000) default null;
119: l_pos number default 0;
120: l_count number default 0;

Line 117: l_fnd_user_end_date date default null;

113: WHERE user_name = upper(p_user_name);
114:
115: l_proc varchar2(72) := g_package||'create_fnd_user';
116: l_fnd_user_start_date date default null;
117: l_fnd_user_end_date date default null;
118: l_host_port_name varchar2(2000) default null;
119: l_pos number default 0;
120: l_count number default 0;
121: l_password varchar2(30) default null;

Line 125: l_fnd_user_id number default null;

121: l_password varchar2(30) default null;
122: l_return_status varchar2(32000) default null;
123: l_msg_count number default 0;
124: l_msg_data varchar2(32000) default null;
125: l_fnd_user_id number default null;
126: l_last_updated_by number default null;
127: l_last_update_login number default null;
128: l_app_short_name varchar2(200) default null;
129: l_msg_name fnd_new_messages.message_name%type

Line 134: l_user_name fnd_user.user_name%type default null;

130: default null;
131: l_host_name varchar2(2000) default null;
132: l_port_name varchar2(2000) default null;
133: l_plsql_agent varchar2(2000) default null;
134: l_user_name fnd_user.user_name%type default null;
135: l_user_id fnd_user.user_id%type default null;
136:
137: e_create_fnd_user EXCEPTION; -- Fix 2288014
138: --

Line 135: l_user_id fnd_user.user_id%type default null;

131: l_host_name varchar2(2000) default null;
132: l_port_name varchar2(2000) default null;
133: l_plsql_agent varchar2(2000) default null;
134: l_user_name fnd_user.user_name%type default null;
135: l_user_id fnd_user.user_id%type default null;
136:
137: e_create_fnd_user EXCEPTION; -- Fix 2288014
138: --
139: --

Line 137: e_create_fnd_user EXCEPTION; -- Fix 2288014

133: l_plsql_agent varchar2(2000) default null;
134: l_user_name fnd_user.user_name%type default null;
135: l_user_id fnd_user.user_id%type default null;
136:
137: e_create_fnd_user EXCEPTION; -- Fix 2288014
138: --
139: --
140: begin
141: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 152: l_fnd_user_start_date := p_hire_date;

148: THEN
149: hr_utility.set_message(800, 'HR_NO_HIRE_DATE');
150: hr_utility.raise_error;
151: ELSE
152: l_fnd_user_start_date := p_hire_date;
153: END IF;
154: ELSE
155: l_fnd_user_start_date := p_user_start_date;
156: END IF;

Line 155: l_fnd_user_start_date := p_user_start_date;

151: ELSE
152: l_fnd_user_start_date := p_hire_date;
153: END IF;
154: ELSE
155: l_fnd_user_start_date := p_user_start_date;
156: END IF;
157:
158:
159: -- Validate p_user_end_date. If entered, it must be larger than start_date

Line 162: l_fnd_user_end_date := null;

158:
159: -- Validate p_user_end_date. If entered, it must be larger than start_date
160: IF p_user_end_date IS NULL
161: THEN
162: l_fnd_user_end_date := null;
163: ELSE
164: IF p_user_end_date >= l_fnd_user_start_date
165: THEN
166: l_fnd_user_end_date := p_user_end_date;

Line 164: IF p_user_end_date >= l_fnd_user_start_date

160: IF p_user_end_date IS NULL
161: THEN
162: l_fnd_user_end_date := null;
163: ELSE
164: IF p_user_end_date >= l_fnd_user_start_date
165: THEN
166: l_fnd_user_end_date := p_user_end_date;
167: ELSE
168: hr_utility.set_message(800, 'HR_51070_CAU_START_END');

Line 166: l_fnd_user_end_date := p_user_end_date;

162: l_fnd_user_end_date := null;
163: ELSE
164: IF p_user_end_date >= l_fnd_user_start_date
165: THEN
166: l_fnd_user_end_date := p_user_end_date;
167: ELSE
168: hr_utility.set_message(800, 'HR_51070_CAU_START_END');
169: hr_utility.raise_error;
170: END IF;

Line 299: hr_utility.set_location (l_proc || ' before fnd_user_pkg.CreateUser', 30);

295: END IF;
296: --
297: -- Now, we're ready to call fnd api to create a user name.
298: --
299: hr_utility.set_location (l_proc || ' before fnd_user_pkg.CreateUser', 30);
300: --
301: -- Fix 2288014 Start
302:
303: BEGIN

Line 304: -- Using fnd_user_pkg.CreateUserId is useful as we do not have to write another select

300: --
301: -- Fix 2288014 Start
302:
303: BEGIN
304: -- Using fnd_user_pkg.CreateUserId is useful as we do not have to write another select
305: -- query to retrieve user_id based on user_name.
306:
307: p_user_id := fnd_user_pkg.CreateUserId (
308: x_user_name => p_user_name,

Line 307: p_user_id := fnd_user_pkg.CreateUserId (

303: BEGIN
304: -- Using fnd_user_pkg.CreateUserId is useful as we do not have to write another select
305: -- query to retrieve user_id based on user_name.
306:
307: p_user_id := fnd_user_pkg.CreateUserId (
308: x_user_name => p_user_name,
309: x_owner => '',
310: x_unencrypted_password => l_password,
311: x_start_date => l_fnd_user_start_date,

Line 311: x_start_date => l_fnd_user_start_date,

307: p_user_id := fnd_user_pkg.CreateUserId (
308: x_user_name => p_user_name,
309: x_owner => '',
310: x_unencrypted_password => l_password,
311: x_start_date => l_fnd_user_start_date,
312: x_end_date => l_fnd_user_end_date,
313: -- x_last_logon_date => sysdate, -- For BUG 7116804
314: x_description => p_description,
315: x_password_date => p_password_date, -- Fix 2288014

Line 312: x_end_date => l_fnd_user_end_date,

308: x_user_name => p_user_name,
309: x_owner => '',
310: x_unencrypted_password => l_password,
311: x_start_date => l_fnd_user_start_date,
312: x_end_date => l_fnd_user_end_date,
313: -- x_last_logon_date => sysdate, -- For BUG 7116804
314: x_description => p_description,
315: x_password_date => p_password_date, -- Fix 2288014
316: x_employee_id => p_employee_id,

Line 324: raise e_create_fnd_user;

320: x_supplier_id => p_supplier_id);
321:
322: EXCEPTION
323: WHEN OTHERS THEN
324: raise e_create_fnd_user;
325: END;
326:
327: -- Set out parameters
328:

Line 344: END create_fnd_user;

340:
341: -- Fix 2288014 End
342:
343:
344: END create_fnd_user;
345: --
346: -- ----------------------------------------------------------------------------
347: -- |---------------------- < create_fnd_responsibility > ----------------------|
348: -- | |

Line 678: -- |-------------------- < create_fnd_user_resp_groups > ----------------------|

674:
675: END create_fnd_responsibility;
676: --
677: -- ----------------------------------------------------------------------------
678: -- |-------------------- < create_fnd_user_resp_groups > ----------------------|
679: -- |NOTE: No savepoint will be issued here because business support internal |
680: -- | process is not supposed to issue any savepoint or rollback. |
681: -- ----------------------------------------------------------------------------
682: --

Line 683: PROCEDURE create_fnd_user_resp_groups

679: -- |NOTE: No savepoint will be issued here because business support internal |
680: -- | process is not supposed to issue any savepoint or rollback. |
681: -- ----------------------------------------------------------------------------
682: --
683: PROCEDURE create_fnd_user_resp_groups
684: (p_user_id in fnd_user.user_id%type
685: ,p_responsibility_id in fnd_responsibility.responsibility_id%type
686: ,p_application_id in
687: fnd_user_resp_groups.responsibility_application_id%type

Line 684: (p_user_id in fnd_user.user_id%type

680: -- | process is not supposed to issue any savepoint or rollback. |
681: -- ----------------------------------------------------------------------------
682: --
683: PROCEDURE create_fnd_user_resp_groups
684: (p_user_id in fnd_user.user_id%type
685: ,p_responsibility_id in fnd_responsibility.responsibility_id%type
686: ,p_application_id in
687: fnd_user_resp_groups.responsibility_application_id%type
688: ,p_sec_group_id in fnd_user_resp_groups.security_group_id%type

Line 687: fnd_user_resp_groups.responsibility_application_id%type

683: PROCEDURE create_fnd_user_resp_groups
684: (p_user_id in fnd_user.user_id%type
685: ,p_responsibility_id in fnd_responsibility.responsibility_id%type
686: ,p_application_id in
687: fnd_user_resp_groups.responsibility_application_id%type
688: ,p_sec_group_id in fnd_user_resp_groups.security_group_id%type
689: ,p_start_date in fnd_user_resp_groups.start_date%type
690: ,p_end_date in fnd_user_resp_groups.end_date%type
691: default null

Line 688: ,p_sec_group_id in fnd_user_resp_groups.security_group_id%type

684: (p_user_id in fnd_user.user_id%type
685: ,p_responsibility_id in fnd_responsibility.responsibility_id%type
686: ,p_application_id in
687: fnd_user_resp_groups.responsibility_application_id%type
688: ,p_sec_group_id in fnd_user_resp_groups.security_group_id%type
689: ,p_start_date in fnd_user_resp_groups.start_date%type
690: ,p_end_date in fnd_user_resp_groups.end_date%type
691: default null
692: ,p_description in fnd_user_resp_groups.description%type

Line 689: ,p_start_date in fnd_user_resp_groups.start_date%type

685: ,p_responsibility_id in fnd_responsibility.responsibility_id%type
686: ,p_application_id in
687: fnd_user_resp_groups.responsibility_application_id%type
688: ,p_sec_group_id in fnd_user_resp_groups.security_group_id%type
689: ,p_start_date in fnd_user_resp_groups.start_date%type
690: ,p_end_date in fnd_user_resp_groups.end_date%type
691: default null
692: ,p_description in fnd_user_resp_groups.description%type
693: default null

Line 690: ,p_end_date in fnd_user_resp_groups.end_date%type

686: ,p_application_id in
687: fnd_user_resp_groups.responsibility_application_id%type
688: ,p_sec_group_id in fnd_user_resp_groups.security_group_id%type
689: ,p_start_date in fnd_user_resp_groups.start_date%type
690: ,p_end_date in fnd_user_resp_groups.end_date%type
691: default null
692: ,p_description in fnd_user_resp_groups.description%type
693: default null
694: ) IS

Line 692: ,p_description in fnd_user_resp_groups.description%type

688: ,p_sec_group_id in fnd_user_resp_groups.security_group_id%type
689: ,p_start_date in fnd_user_resp_groups.start_date%type
690: ,p_end_date in fnd_user_resp_groups.end_date%type
691: default null
692: ,p_description in fnd_user_resp_groups.description%type
693: default null
694: ) IS
695: --
696: CURSOR lc_get_user_id IS

Line 698: FROM fnd_user

694: ) IS
695: --
696: CURSOR lc_get_user_id IS
697: SELECT user_id
698: FROM fnd_user
699: WHERE user_id = p_user_id;
700: --
701: CURSOR lc_get_resp_id IS
702: SELECT responsibility_id

Line 714: FROM fnd_user_resp_groups

710: --
711: --
712: CURSOR lc_unique_user_resp_groups IS
713: SELECT user_id
714: FROM fnd_user_resp_groups
715: WHERE user_id = p_user_id
716: AND responsibility_application_id = p_application_id
717: AND responsibility_id = p_responsibility_id
718: AND security_group_id = p_sec_group_id;

Line 720: l_proc varchar2(72) := g_package || 'create_fnd_user_resp_groups';

716: AND responsibility_application_id = p_application_id
717: AND responsibility_id = p_responsibility_id
718: AND security_group_id = p_sec_group_id;
719:
720: l_proc varchar2(72) := g_package || 'create_fnd_user_resp_groups';
721: l_dummy number default null;
722: --
723: BEGIN
724: hr_utility.set_location('Entering:' || l_proc, 10);

Line 728: -- create_fnd_user_api first.

724: hr_utility.set_location('Entering:' || l_proc, 10);
725: --
726: -- Validate input parameters first. We need to validate input parameter
727: -- again here because users can just invoke this procedure without calling
728: -- create_fnd_user_api first.
729: --
730: -- Validate user_id
731: --
732: l_dummy := null;

Line 740: fnd_message.set_token('TABLE', 'FND_USER');

736: IF lc_get_user_id%NOTFOUND
737: THEN
738: CLOSE lc_get_user_id;
739: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
740: fnd_message.set_token('TABLE', 'FND_USER');
741: fnd_message.set_token('COLUMN', 'USER_ID');
742: fnd_message.set_token('VALUE', to_char(p_user_id));
743: hr_utility.raise_error;
744: ELSE

Line 823: -- Now call the fnd_user_resp_groups_api

819: hr_utility.raise_error;
820: END IF;
821: END IF;
822: --
823: -- Now call the fnd_user_resp_groups_api
824: --
825: hr_utility.set_location(l_proc ||
826: ' before fnd_user_resp_groups_api.insert_assignment', 30);
827: --

Line 826: ' before fnd_user_resp_groups_api.insert_assignment', 30);

822: --
823: -- Now call the fnd_user_resp_groups_api
824: --
825: hr_utility.set_location(l_proc ||
826: ' before fnd_user_resp_groups_api.insert_assignment', 30);
827: --
828: fnd_user_resp_groups_api.insert_assignment
829: (user_id => p_user_id
830: ,responsibility_id => p_responsibility_id

Line 828: fnd_user_resp_groups_api.insert_assignment

824: --
825: hr_utility.set_location(l_proc ||
826: ' before fnd_user_resp_groups_api.insert_assignment', 30);
827: --
828: fnd_user_resp_groups_api.insert_assignment
829: (user_id => p_user_id
830: ,responsibility_id => p_responsibility_id
831: ,responsibility_application_id => p_application_id
832: ,security_group_id => p_sec_group_id

Line 841: END create_fnd_user_resp_groups;

837:
838: --
839: hr_utility.set_location('Leaving:'||l_proc, 50);
840:
841: END create_fnd_user_resp_groups;
842: --
843: -- ----------------------------------------------------------------------------
844: -- |---------------------- < create_sec_profile_asg > ------------------------|
845: -- ----------------------------------------------------------------------------

Line 848: (p_user_id in fnd_user.user_id%type

844: -- |---------------------- < create_sec_profile_asg > ------------------------|
845: -- ----------------------------------------------------------------------------
846: --
847: PROCEDURE create_sec_profile_asg
848: (p_user_id in fnd_user.user_id%type
849: ,p_sec_group_id in fnd_security_groups.security_group_id%type
850: ,p_sec_profile_id in per_security_profiles.security_profile_id%type
851: ,p_resp_key in fnd_responsibility.responsibility_key%type
852: ,p_resp_app_id in

Line 865: FROM fnd_user

861: --
862:
863: CURSOR lc_get_user_id IS
864: SELECT user_id
865: FROM fnd_user
866: WHERE user_id = p_user_id;
867: --
868: CURSOR lc_get_sec_group_id IS
869: SELECT security_group_id

Line 899: -- fnd_user_acct_api first.

895: hr_utility.set_location('Entering:' || l_proc, 10);
896:
897: -- Validate input parameters first. We need to validate input parameter
898: -- again here because users can just invoke this procedure without calling
899: -- fnd_user_acct_api first.
900: --
901: -- Validate user_id
902: --
903: l_dummy := null;

Line 911: fnd_message.set_token('TABLE', 'FND_USER');

907: IF lc_get_user_id%NOTFOUND
908: THEN
909: CLOSE lc_get_user_id;
910: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
911: fnd_message.set_token('TABLE', 'FND_USER');
912: fnd_message.set_token('COLUMN', 'USER_ID');
913: fnd_message.set_token('VALUE', to_char(p_user_id));
914: hr_utility.raise_error;
915: ELSE

Line 989: -- per_sec_profile_assignments as well as fnd_user_resp_groups.

985: END IF;
986: END IF;
987: --
988: -- Now call the per_asp_ins.ins which will insert a row into
989: -- per_sec_profile_assignments as well as fnd_user_resp_groups.
990: per_asp_ins.ins
991: (p_user_id => p_user_id
992: ,p_security_group_id => p_sec_group_id
993: ,p_business_group_id => l_bg_id

Line 1051: -- fnd_user_resp_wrapper first.

1047: hr_utility.set_location('Entering:' || l_proc, 10);
1048: --
1049: -- Validate input parameters first. We need to validate input parameter
1050: -- again here because users can just invoke this procedure without calling
1051: -- fnd_user_resp_wrapper first.
1052: --
1053: -- Validate profile options to determine if it is updateable
1054: OPEN lc_get_update_flag;
1055: FETCH lc_get_update_flag INTO l_resp_update_allowed_flag

Line 2293: -- |-------------------------- < update_fnd_user > ----------------------------|

2289: --
2290: END create_fnd_resp_functions;
2291: --
2292: -- ----------------------------------------------------------------------------
2293: -- |-------------------------- < update_fnd_user > ----------------------------|
2294: -- |NOTE: No savepoint will be issued here because business support internal |
2295: -- | process is not supposed to issue any savepoint or rollback. |
2296: -- ----------------------------------------------------------------------------
2297: --

Line 2298: PROCEDURE update_fnd_user

2294: -- |NOTE: No savepoint will be issued here because business support internal |
2295: -- | process is not supposed to issue any savepoint or rollback. |
2296: -- ----------------------------------------------------------------------------
2297: --
2298: PROCEDURE update_fnd_user
2299: (p_user_id in number
2300: ,p_old_password in varchar2 default hr_api.g_varchar2
2301: ,p_new_password in varchar2 default hr_api.g_varchar2
2302: ,p_end_date in date default hr_api.g_date

Line 2317: FROM fnd_user

2313: --
2314: CURSOR lc_get_user_data
2315: IS
2316: SELECT *
2317: FROM fnd_user
2318: WHERE user_id = p_user_Id;
2319: --
2320: l_proc varchar2(72) := g_package||'update_fnd_user';
2321: l_user_data fnd_user%rowtype;

Line 2320: l_proc varchar2(72) := g_package||'update_fnd_user';

2316: SELECT *
2317: FROM fnd_user
2318: WHERE user_id = p_user_Id;
2319: --
2320: l_proc varchar2(72) := g_package||'update_fnd_user';
2321: l_user_data fnd_user%rowtype;
2322: l_old_password fnd_user.encrypted_user_password%type
2323: default null;
2324: -- The new un-encrypted password cannot exceed a length of 30, which

Line 2321: l_user_data fnd_user%rowtype;

2317: FROM fnd_user
2318: WHERE user_id = p_user_Id;
2319: --
2320: l_proc varchar2(72) := g_package||'update_fnd_user';
2321: l_user_data fnd_user%rowtype;
2322: l_old_password fnd_user.encrypted_user_password%type
2323: default null;
2324: -- The new un-encrypted password cannot exceed a length of 30, which
2325: -- is what is allowed in forms.

Line 2322: l_old_password fnd_user.encrypted_user_password%type

2318: WHERE user_id = p_user_Id;
2319: --
2320: l_proc varchar2(72) := g_package||'update_fnd_user';
2321: l_user_data fnd_user%rowtype;
2322: l_old_password fnd_user.encrypted_user_password%type
2323: default null;
2324: -- The new un-encrypted password cannot exceed a length of 30, which
2325: -- is what is allowed in forms.
2326: l_new_password varchar2(30) default null;

Line 2331: l_email_address fnd_user.email_address%type default null;

2327: l_end_date date default null;
2328: l_host_port varchar2(32000) default null;
2329: l_pos number default 0;
2330: l_count number default 0;
2331: l_email_address fnd_user.email_address%type default null;
2332: l_fax fnd_user.fax%type default null;
2333: l_description fnd_user.description%type default null;
2334: l_language varchar2(32000) default null;
2335: l_employee_id number default null ; -- Fix 2951145

Line 2332: l_fax fnd_user.fax%type default null;

2328: l_host_port varchar2(32000) default null;
2329: l_pos number default 0;
2330: l_count number default 0;
2331: l_email_address fnd_user.email_address%type default null;
2332: l_fax fnd_user.fax%type default null;
2333: l_description fnd_user.description%type default null;
2334: l_language varchar2(32000) default null;
2335: l_employee_id number default null ; -- Fix 2951145
2336: l_customer_id number default null ; -- Fix 2951145

Line 2333: l_description fnd_user.description%type default null;

2329: l_pos number default 0;
2330: l_count number default 0;
2331: l_email_address fnd_user.email_address%type default null;
2332: l_fax fnd_user.fax%type default null;
2333: l_description fnd_user.description%type default null;
2334: l_language varchar2(32000) default null;
2335: l_employee_id number default null ; -- Fix 2951145
2336: l_customer_id number default null ; -- Fix 2951145
2337: l_supplier_id number default null ; -- Fix 2951145

Line 2368: fnd_message.set_token('TABLE', 'FND_USER');

2364: THEN
2365:
2366: CLOSE lc_get_user_data;
2367: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2368: fnd_message.set_token('TABLE', 'FND_USER');
2369: fnd_message.set_token('COLUMN', 'USER_ID');
2370: fnd_message.set_token('VALUE', p_user_id);
2371: hr_utility.raise_error;
2372: ELSE

Line 2498: hr_utility.set_location (l_proc || ' before fnd_user_pkg.UpdateUser', 30);

2494: END IF;
2495: --
2496: -- Now, we're ready to call fnd api to update a user account.
2497: --
2498: hr_utility.set_location (l_proc || ' before fnd_user_pkg.UpdateUser', 30);
2499: --
2500: -- Fix 2288014 Start
2501:
2502: select user_name into l_user_name from fnd_user

Line 2502: select user_name into l_user_name from fnd_user

2498: hr_utility.set_location (l_proc || ' before fnd_user_pkg.UpdateUser', 30);
2499: --
2500: -- Fix 2288014 Start
2501:
2502: select user_name into l_user_name from fnd_user
2503: where user_id = p_user_id;
2504:
2505:
2506: fnd_user_pkg.UpdateUser (

Line 2506: fnd_user_pkg.UpdateUser (

2502: select user_name into l_user_name from fnd_user
2503: where user_id = p_user_id;
2504:
2505:
2506: fnd_user_pkg.UpdateUser (
2507: x_user_name => l_user_name,
2508: x_owner => '',
2509: x_unencrypted_password =>l_new_password,
2510: x_description => l_description,

Line 2530: END update_fnd_user;

2526: hr_utility.raise_error;
2527:
2528: -- Fix 2288014 End
2529:
2530: END update_fnd_user;
2531: --
2532: -- ----------------------------------------------------------------------------
2533: -- |-------------------- < update_fnd_user_resp_groups > ----------------------|
2534: -- |NOTE: No savepoint will be issued here because business support internal |

Line 2533: -- |-------------------- < update_fnd_user_resp_groups > ----------------------|

2529:
2530: END update_fnd_user;
2531: --
2532: -- ----------------------------------------------------------------------------
2533: -- |-------------------- < update_fnd_user_resp_groups > ----------------------|
2534: -- |NOTE: No savepoint will be issued here because business support internal |
2535: -- | process is not supposed to issue any savepoint or rollback. |
2536: -- ----------------------------------------------------------------------------
2537: --

Line 2538: PROCEDURE update_fnd_user_resp_groups

2534: -- |NOTE: No savepoint will be issued here because business support internal |
2535: -- | process is not supposed to issue any savepoint or rollback. |
2536: -- ----------------------------------------------------------------------------
2537: --
2538: PROCEDURE update_fnd_user_resp_groups
2539: (p_user_id in number
2540: ,p_responsibility_id in number
2541: ,p_resp_application_id in number
2542: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type

Line 2542: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type

2538: PROCEDURE update_fnd_user_resp_groups
2539: (p_user_id in number
2540: ,p_responsibility_id in number
2541: ,p_resp_application_id in number
2542: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type
2543: ,p_start_date in date default hr_api.g_date
2544: ,p_end_date in date default hr_api.g_date
2545: ,p_description in varchar2 default hr_api.g_varchar2
2546: ) IS

Line 2550: FROM fnd_user

2546: ) IS
2547: --
2548: CURSOR lc_get_user_id IS
2549: SELECT user_id
2550: FROM fnd_user
2551: WHERE user_id = p_user_id;
2552: --
2553: CURSOR lc_get_resp_id_n_key IS
2554: SELECT responsibility_id

Line 2565: -- fnd_user_resp_groups should function like R11 fnd_user_responsibility, the

2561: FROM fnd_application
2562: WHERE application_id = p_resp_application_id;
2563: --
2564: -- When ENABLED_SECURITY_GROUPS profile option = 'N', then the
2565: -- fnd_user_resp_groups should function like R11 fnd_user_responsibility, the
2566: -- security_group_id is 0 and there should not be more than 1 row for the
2567: -- combination of user_id, responsibility_id, application_id and
2568: -- security_group_id.
2569:

Line 2572: FROM fnd_user_resp_groups

2568: -- security_group_id.
2569:
2570: CURSOR lc_unique_user_resp IS
2571: SELECT count(*)
2572: FROM fnd_user_resp_groups
2573: WHERE user_id = p_user_id
2574: AND responsibility_id = p_responsibility_id
2575: AND responsibility_application_id = p_resp_application_id
2576: AND security_group_id = p_security_group_id;

Line 2584: FROM fnd_user_resp_groups

2580: ,responsibility_id
2581: ,start_date
2582: ,end_date
2583: ,description
2584: FROM fnd_user_resp_groups
2585: WHERE user_id = p_user_id
2586: AND responsibility_id = p_responsibility_id
2587: AND responsibility_application_id = p_resp_application_id
2588: AND security_group_id = p_security_group_id;

Line 2596: FROM fnd_user_resp_groups_direct

2592: ,responsibility_id
2593: ,start_date
2594: ,end_date
2595: ,description
2596: FROM fnd_user_resp_groups_direct
2597: WHERE user_id = p_user_id
2598: AND responsibility_id = p_responsibility_id
2599: AND responsibility_application_id = p_resp_application_id
2600: AND security_group_id = p_security_group_id;

Line 2602: l_proc varchar2(72) := g_package||'update_fnd_user_resp_groups';

2598: AND responsibility_id = p_responsibility_id
2599: AND responsibility_application_id = p_resp_application_id
2600: AND security_group_id = p_security_group_id;
2601:
2602: l_proc varchar2(72) := g_package||'update_fnd_user_resp_groups';
2603: l_count number default null;
2604: l_dummy number default null;
2605: l_start_date date default null;
2606: l_end_date date default null;

Line 2607: l_description fnd_user_resp_groups.description%type default null;

2603: l_count number default null;
2604: l_dummy number default null;
2605: l_start_date date default null;
2606: l_end_date date default null;
2607: l_description fnd_user_resp_groups.description%type default null;
2608: l_resp_key fnd_responsibility.responsibility_key%type default null;
2609: l_fnd_user_resp_data lc_user_resp_row%rowtype;
2610: --
2611: BEGIN

Line 2609: l_fnd_user_resp_data lc_user_resp_row%rowtype;

2605: l_start_date date default null;
2606: l_end_date date default null;
2607: l_description fnd_user_resp_groups.description%type default null;
2608: l_resp_key fnd_responsibility.responsibility_key%type default null;
2609: l_fnd_user_resp_data lc_user_resp_row%rowtype;
2610: --
2611: BEGIN
2612: hr_utility.set_location('Entering:' || l_proc, 10);
2613: --

Line 2616: -- fnd_user_acct_api first.

2612: hr_utility.set_location('Entering:' || l_proc, 10);
2613: --
2614: -- Validate input parameters first. We need to validate input parameter
2615: -- again here because users can just invoke this procedure without calling
2616: -- fnd_user_acct_api first.
2617: --
2618: -- Validate user_id
2619: --
2620: l_dummy := null;

Line 2628: fnd_message.set_token('TABLE', 'FND_USER');

2624: IF lc_get_user_id%NOTFOUND
2625: THEN
2626: CLOSE lc_get_user_id;
2627: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2628: fnd_message.set_token('TABLE', 'FND_USER');
2629: fnd_message.set_token('COLUMN', 'USER_ID');
2630: fnd_message.set_token('VALUE', to_char(p_user_id));
2631: hr_utility.raise_error;
2632: ELSE

Line 2701: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');

2697: NULL;
2698: /*
2699: CLOSE lc_unique_user_resp;
2700: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2701: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');
2702: fnd_message.set_token('COLUMN', 'USER_ID');
2703: fnd_message.set_token('VALUE', to_char(p_user_id));
2704: hr_utility.raise_error;
2705: */

Line 2714: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');

2710: -- It's an error, the user responsibility record must exist before
2711: -- this program is invoked.
2712: -- CLOSE lc_unique_user_resp;
2713: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2714: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');
2715: fnd_message.set_token('COLUMN', 'USER_ID');
2716: fnd_message.set_token('VALUE', to_char(p_user_id));
2717: hr_utility.raise_error;
2718: END;

Line 2721: -- Get existing fnd_user_resp_groups data

2717: hr_utility.raise_error;
2718: END;
2719: --
2720: -- Bug #1341128 Fix
2721: -- Get existing fnd_user_resp_groups data
2722: /*
2723: Bug fix 8582264
2724: When 2 responsibilities have same responsibility_id , but different
2725: application_ids and one of those responsibility is end dated, l_dummy

Line 2727: FND_USER_RESP_GROUPS_DIRECT instead of FND_USER_RESP_GROUPS

2723: Bug fix 8582264
2724: When 2 responsibilities have same responsibility_id , but different
2725: application_ids and one of those responsibility is end dated, l_dummy
2726: will be 0. In this case, we will fetch the data from
2727: FND_USER_RESP_GROUPS_DIRECT instead of FND_USER_RESP_GROUPS
2728: */
2729:
2730: IF l_dummy = 0 OR l_dummy IS NULL THEN
2731: OPEN lc_user_resp_direct_row;

Line 2732: FETCH lc_user_resp_direct_row into l_fnd_user_resp_data;

2728: */
2729:
2730: IF l_dummy = 0 OR l_dummy IS NULL THEN
2731: OPEN lc_user_resp_direct_row;
2732: FETCH lc_user_resp_direct_row into l_fnd_user_resp_data;
2733: CLOSE lc_user_resp_direct_row;
2734: ELSE
2735: OPEN lc_user_resp_row;
2736: FETCH lc_user_resp_row into l_fnd_user_resp_data;

Line 2736: FETCH lc_user_resp_row into l_fnd_user_resp_data;

2732: FETCH lc_user_resp_direct_row into l_fnd_user_resp_data;
2733: CLOSE lc_user_resp_direct_row;
2734: ELSE
2735: OPEN lc_user_resp_row;
2736: FETCH lc_user_resp_row into l_fnd_user_resp_data;
2737: CLOSE lc_user_resp_row;
2738: END IF;
2739:
2740: -- Convert hr_api default values to null values

Line 2743: l_start_date := l_fnd_user_resp_data.start_date;

2739:
2740: -- Convert hr_api default values to null values
2741: IF p_start_date = hr_api.g_date
2742: THEN
2743: l_start_date := l_fnd_user_resp_data.start_date;
2744: ELSE
2745: l_start_date := p_start_date;
2746: END IF;
2747:

Line 2751: l_end_date := l_fnd_user_resp_data.end_date;

2747:
2748: -- Validate End Date must be >= Start Date
2749: IF p_end_date = hr_api.g_date
2750: THEN
2751: l_end_date := l_fnd_user_resp_data.end_date;
2752: ELSIF p_end_date IS NULL
2753: THEN
2754: l_end_date := p_end_date;
2755: ELSE

Line 2771: l_description := l_fnd_user_resp_data.description;

2767: END IF;
2768: --
2769: IF p_description = hr_api.g_varchar2
2770: THEN
2771: l_description := l_fnd_user_resp_data.description;
2772: ELSE
2773: l_description := p_description;
2774: END IF;
2775: --

Line 2777: -- Now call the fnd_user_resp_groups_api

2773: l_description := p_description;
2774: END IF;
2775: --
2776: --
2777: -- Now call the fnd_user_resp_groups_api
2778: --
2779: hr_utility.set_location(l_proc ||
2780: ' before fnd_user_resp_groups_api.update_assignment', 30);
2781: hr_utility.set_location(l_proc || ' Passing p_user_id=' || p_user_id , 31);

Line 2780: ' before fnd_user_resp_groups_api.update_assignment', 30);

2776: --
2777: -- Now call the fnd_user_resp_groups_api
2778: --
2779: hr_utility.set_location(l_proc ||
2780: ' before fnd_user_resp_groups_api.update_assignment', 30);
2781: hr_utility.set_location(l_proc || ' Passing p_user_id=' || p_user_id , 31);
2782: hr_utility.set_location(l_proc || ' Security_group_id=' || p_security_group_id ,32);
2783: --
2784: fnd_user_resp_groups_api.update_assignment

Line 2784: fnd_user_resp_groups_api.update_assignment

2780: ' before fnd_user_resp_groups_api.update_assignment', 30);
2781: hr_utility.set_location(l_proc || ' Passing p_user_id=' || p_user_id , 31);
2782: hr_utility.set_location(l_proc || ' Security_group_id=' || p_security_group_id ,32);
2783: --
2784: fnd_user_resp_groups_api.update_assignment
2785: (user_id => p_user_id
2786: ,responsibility_id => p_responsibility_id
2787: ,responsibility_application_id => p_resp_application_id
2788: ,security_group_id =>p_security_group_id -- Fix 2978610

Line 2797: END update_fnd_user_resp_groups;

2793: --
2794: --
2795: hr_utility.set_location('Leaving:'||l_proc, 50);
2796:
2797: END update_fnd_user_resp_groups;
2798: --
2799: -- ----------------------------------------------------------------------------
2800: -- |---------------------- < update_sec_profile_asg > ------------------------|
2801: -- ----------------------------------------------------------------------------

Line 2806: ,p_user_id in fnd_user.user_id%type default null

2802: --
2803: PROCEDURE update_sec_profile_asg
2804: (p_sec_profile_asg_id in
2805: per_sec_profile_assignments.sec_profile_assignment_id%type default null
2806: ,p_user_id in fnd_user.user_id%type default null
2807: ,p_responsibility_id in per_sec_profile_assignments.responsibility_id%type
2808: default null
2809: ,p_resp_app_id in
2810: per_sec_profile_assignments.responsibility_application_id%type default null

Line 2811: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type

2807: ,p_responsibility_id in per_sec_profile_assignments.responsibility_id%type
2808: default null
2809: ,p_resp_app_id in
2810: per_sec_profile_assignments.responsibility_application_id%type default null
2811: ,p_security_group_id in fnd_user_resp_groups.security_group_id%type
2812: default null
2813: ,p_start_date in per_sec_profile_assignments.start_date%type
2814: default null
2815: ,p_end_date in per_sec_profile_assignments.end_date%type

Line 2825: FROM fnd_user

2821: --
2822:
2823: CURSOR lc_get_user_id IS
2824: SELECT user_id
2825: FROM fnd_user
2826: WHERE user_id = p_user_id;
2827: --
2828: --
2829: CURSOR lc_get_sec_profile_asg_id IS

Line 2868: -- fnd_user_acct_api first.

2864: END IF;
2865:
2866: -- Validate input parameters first. We need to validate input parameter
2867: -- again here because users can just invoke this procedure without calling
2868: -- fnd_user_acct_api first.
2869: --
2870: -- Validate user_id
2871: --
2872: l_dummy := null;

Line 2882: fnd_message.set_token('TABLE', 'FND_USER');

2878: IF lc_get_user_id%NOTFOUND
2879: THEN
2880: CLOSE lc_get_user_id;
2881: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2882: fnd_message.set_token('TABLE', 'FND_USER');
2883: fnd_message.set_token('COLUMN', 'USER_ID');
2884: fnd_message.set_token('VALUE', to_char(p_user_id));
2885: hr_utility.raise_error;
2886: ELSE

Line 2953: -- per_sec_profile_assignments as well as fnd_user_resp_groups.

2949: END IF;
2950: --
2951: --
2952: -- Now call the per_asp_upd.upd which will update a row in
2953: -- per_sec_profile_assignments as well as fnd_user_resp_groups.
2954: --
2955: per_asp_upd.upd
2956: (p_sec_profile_assignment_id => l_sec_prof_asg_id
2957: ,p_object_version_number => l_obj_vers_num