APPS.FND_OID_BULKLOAD dependencies on FND_USER

Line 23: l_user_name fnd_user.user_name%type;

19:
20: l_module_source varchar2(256);
21: l_user_count number;
22: l_user_id number;
23: l_user_name fnd_user.user_name%type;
24: l_description fnd_user.description%type;
25: l_fax fnd_user.fax%type;
26: l_email_address fnd_user.email_address%type;
27: l_user_guid fnd_user.user_guid%type;

Line 24: l_description fnd_user.description%type;

20: l_module_source varchar2(256);
21: l_user_count number;
22: l_user_id number;
23: l_user_name fnd_user.user_name%type;
24: l_description fnd_user.description%type;
25: l_fax fnd_user.fax%type;
26: l_email_address fnd_user.email_address%type;
27: l_user_guid fnd_user.user_guid%type;
28:

Line 25: l_fax fnd_user.fax%type;

21: l_user_count number;
22: l_user_id number;
23: l_user_name fnd_user.user_name%type;
24: l_description fnd_user.description%type;
25: l_fax fnd_user.fax%type;
26: l_email_address fnd_user.email_address%type;
27: l_user_guid fnd_user.user_guid%type;
28:
29: begin

Line 26: l_email_address fnd_user.email_address%type;

22: l_user_id number;
23: l_user_name fnd_user.user_name%type;
24: l_description fnd_user.description%type;
25: l_fax fnd_user.fax%type;
26: l_email_address fnd_user.email_address%type;
27: l_user_guid fnd_user.user_guid%type;
28:
29: begin
30:

Line 27: l_user_guid fnd_user.user_guid%type;

23: l_user_name fnd_user.user_name%type;
24: l_description fnd_user.description%type;
25: l_fax fnd_user.fax%type;
26: l_email_address fnd_user.email_address%type;
27: l_user_guid fnd_user.user_guid%type;
28:
29: begin
30:
31: fnd_global.apps_initialize(0, -1, -1);

Line 56: from fnd_user

52: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'user guid = ' || l_user_guid);
53: end if;
54:
55: select count(user_name) into l_user_count
56: from fnd_user
57: where user_name = l_user_name;
58:
59: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
60: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'user count for ' || l_user_name || ' = ' || l_user_count);

Line 64: fnd_user_pkg.CreateUser(x_user_name => l_user_name,

60: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'user count for ' || l_user_name || ' = ' || l_user_count);
61: end if;
62:
63: if (l_user_count = 0) then
64: fnd_user_pkg.CreateUser(x_user_name => l_user_name,
65: x_owner => 'CUST',
66: x_unencrypted_password => fnd_web_sec.EXTERNAL_PWD,
67: x_description => l_description,
68: x_fax => l_fax,

Line 71: x_change_source => fnd_user_pkg.change_source_oid);

67: x_description => l_description,
68: x_fax => l_fax,
69: x_email_address => l_email_address,
70: x_user_guid => l_user_guid,
71: x_change_source => fnd_user_pkg.change_source_oid);
72:
73: /* fnd_oid_util.send_subscription_add_to_OID(p_orcl_guid=>l_user_guid); */
74:
75: fnd_oid_subscriptions.assign_default_resp(p_user_name => l_user_name);

Line 89: from fnd_user

85: end if;
86: end if;
87: else /* count_user <> 0 */
88: select count(user_name) into l_user_count
89: from fnd_user
90: where user_name = l_user_name
91: and user_guid is not null;
92:
93: if (l_user_count = 0) then

Line 98: fnd_user_pkg.UpdateUser(x_user_name => l_user_name,

94: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
95: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'user guid for ' || l_user_name || ' is null');
96: end if;
97: if (p_duplicate = G_DUP_TRUE) then
98: fnd_user_pkg.UpdateUser(x_user_name => l_user_name,
99: x_owner => 'CUST',
100: x_description => l_description,
101: x_fax => l_fax,
102: x_email_address => l_email_address,

Line 104: x_change_source => fnd_user_pkg.change_source_oid);

100: x_description => l_description,
101: x_fax => l_fax,
102: x_email_address => l_email_address,
103: x_user_guid => l_user_guid,
104: x_change_source => fnd_user_pkg.change_source_oid);
105: x_ret_status := G_LINKED;
106: else
107: x_ret_status := G_NOT_LINKED;
108: end if;