[Home] [Help]
162: PROCEDURE NAME: get_diff_in_user_list
163:
164: DESCRIPTION :
165: Given a two lists of users, this procedure gives the difference of the two lists.
166: The users must be present in the fnd_user table.
167:
168: Referenced by : locate_notifier
169: parameters :
170:
187: IS
188: l_refcur g_refcur;
189: l_name_list varchar2(2000);
190: l_count number;
191: l_user_name FND_USER.USER_NAME%type;
192: l_progress varchar2(255);
193: BEGIN
194: l_count := 0;
195: open l_refcur for
193: BEGIN
194: l_count := 0;
195: open l_refcur for
196: 'select distinct fu.user_name
197: from fnd_user fu
198: where fu.user_name in ('|| p_super_set || ')
199: and fu.user_name not in (' || p_subset || ')';
200:
201:
261: l_offset PLS_INTEGER;
262: l_length PLS_INTEGER;
263: l_start PLS_INTEGER;
264: l_end PLS_INTEGER;
265: l_user_name fnd_user.user_name%TYPE;
266: l_count PLS_INTEGER;
267:
268: CURSOR l_cur IS
269: SELECT role_name
404: l_count := 0;
405: l_f := '''' || 'F' || '''';
406: open l_refcur for
407: 'select distinct fu.user_name
408: from fnd_user fu, fnd_user_resp_groups furg
409: where fu.user_id = furg.user_id
410: and furg.responsibility_id in
411: (
412: SELECT
5325: l_numerator_rate number;
5326: l_approval_currency varchar2(30);
5327: l_amount_disp varchar2(60);
5328: l_amount_approval_currency number;
5329: l_approver_user_name fnd_user.user_name%TYPE;
5330: l_user_id fnd_user.user_id%TYPE;
5331: l_progress varchar2(200);
5332: l_no_rate_msg varchar2(200);
5333:
5326: l_approval_currency varchar2(30);
5327: l_amount_disp varchar2(60);
5328: l_amount_approval_currency number;
5329: l_approver_user_name fnd_user.user_name%TYPE;
5330: l_user_id fnd_user.user_id%TYPE;
5331: l_progress varchar2(200);
5332: l_no_rate_msg varchar2(200);
5333:
5334: begin
5346: aname=>'APPROVER_USER_NAME');
5347: if (l_approver_user_name is not null) then
5348: SELECT user_id
5349: INTO l_user_id
5350: FROM fnd_user
5351: WHERE user_name = l_approver_user_name;
5352:
5353: l_progress := 'getReqAmountInfo:' || l_user_id;
5354: IF (g_po_wf_debug = 'Y') THEN
8810: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
8811: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
8812: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
8813: -- End of Bug 2850566
8814: l_rspndr_usr_name fnd_user.user_name%TYPE := '';
8815: l_accepting_party varchar2(1);
8816: begin
8817: -- Bug 2850566
8818: -- Commented out the select statement as it is handled in the PO_ACCEPTANCES rowhandler
8877: aname => 'SUPPLIER_USER_NAME');
8878:
8879: begin
8880: select user_id into l_Last_Updated_By
8881: from fnd_user
8882: where user_name = upper(l_rspndr_usr_name);
8883: l_accepting_party := 'S';
8884: exception when others then
8885: --in case of non-isp users there wont be any suppliers
9699: x_result_out out NOCOPY varchar2 ) is
9700: l_progress varchar2(200);
9701: l_doc_id number;
9702: l_doc_type PO_HEADERS_ALL.TYPE_LOOKUP_CODE%type;
9703: l_cat_admin_user_name FND_USER.USER_NAME%type;
9704: BEGIN
9705: l_progress := '100';
9706: IF (g_po_wf_debug = 'Y') THEN
9707: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key,l_progress);
9774: p_item_key in varchar2,
9775: p_doc_id in number,
9776: p_doc_type in varchar2) is
9777: l_progress varchar2(255);
9778: l_user_name FND_USER.USER_NAME%type;
9779: l_lock_owner_role PO_HEADERS_ALL.lock_owner_role%type;
9780: l_lock_owner_user_id PO_HEADERS_ALL.lock_owner_user_id%type;
9781: BEGIN
9782: l_progress := 'PO_REQAPPROVAL_INIT1.set_catalog_admin_user_name: 100' ||
9812:
9813: -- The performer attribute holds the user name, get the user name
9814: -- associated with the user id
9815: select user_name into l_user_name
9816: from fnd_user
9817: where user_id = l_lock_owner_user_id;
9818:
9819: l_progress := 'PO_REQAPPROVAL_INIT1.set_catalog_admin_user_name: 155' ||
9820: 'UserName='|| l_user_name;