APPS.PON_AUCTION_APPROVAL_PKG dependencies on FND_USER

Line 242: from fnd_user

238:
239: -- use user_id wherever possible
240: select user_id
241: into l_user_id
242: from fnd_user
243: where user_name = p_user_name;
244:
245:
246:

Line 305: from fnd_user

301:
302: -- use user_id wherever possible
303: select user_id
304: into l_user_id
305: from fnd_user
306: where user_name = p_user_name;
307:
308: -- Check to see if this user has already approved
309: begin

Line 465: /* Get FND user name from trading_partner_contact_id */

461:
462: l_resp_id NUMBER; -- bug 11732401
463: l_appl_id NUMBER; -- bug 11732401
464:
465: /* Get FND user name from trading_partner_contact_id */
466: CURSOR c_auction_info IS
467: select fnd.user_name, fnd.user_id, pon.close_bidding_date,
468: pon.auction_title,
469: decode(nvl(pon.open_auction_now_flag,'N'),'Y',to_date(null),pon.open_bidding_date) open_bidding_date,

Line 467: select fnd.user_name, fnd.user_id, pon.close_bidding_date,

463: l_appl_id NUMBER; -- bug 11732401
464:
465: /* Get FND user name from trading_partner_contact_id */
466: CURSOR c_auction_info IS
467: select fnd.user_name, fnd.user_id, pon.close_bidding_date,
468: pon.auction_title,
469: decode(nvl(pon.open_auction_now_flag,'N'),'Y',to_date(null),pon.open_bidding_date) open_bidding_date,
470: nvl(pon.open_auction_now_flag,'N') open_auction_now_flag,
471: pon.document_number, trading_partner_contact_id, trading_partner_name, trading_partner_contact_name,

Line 474: from fnd_user fnd,pon_auction_headers_all pon

470: nvl(pon.open_auction_now_flag,'N') open_auction_now_flag,
471: pon.document_number, trading_partner_contact_id, trading_partner_name, trading_partner_contact_name,
472: open_bidding_date, close_bidding_date, nvl(auction_round_number, 1),
473: nvl(amendment_number, 0), auction_header_id_orig_amend, view_by_date
474: from fnd_user fnd,pon_auction_headers_all pon
475: where fnd.person_party_id = pon.trading_partner_contact_id and
476: pon.auction_header_id = p_auction_header_id and
477: rownum=1;
478:

Line 753: fnd_user fnd

749:
750: /* Get the creator's full name */
751: select emp.full_name into l_creator_full_name from
752: per_all_people_f emp,
753: fnd_user fnd
754: where fnd.employee_id=emp.person_id and
755: fnd.user_id = l_creator_user_id and
756: trunc(sysdate) between emp.effective_start_date and emp.effective_end_date;
757:

Line 755: fnd.user_id = l_creator_user_id and

751: select emp.full_name into l_creator_full_name from
752: per_all_people_f emp,
753: fnd_user fnd
754: where fnd.employee_id=emp.person_id and
755: fnd.user_id = l_creator_user_id and
756: trunc(sysdate) between emp.effective_start_date and emp.effective_end_date;
757:
758: wf_engine.SetItemAttrText (itemtype => l_itemType,
759: itemkey => l_itemKey,

Line 786: from fnd_user

782:
783: -- use user_id wherever possible
784: select user_id
785: into l_submit_user_id
786: from fnd_user
787: where user_name = p_submit_user_name;
788:
789:
790: UPD_AUCTION_STATUSHISTORY(p_auction_header_id,

Line 881: from pon_neg_team_members neg, pon_auction_headers_all auc, fnd_user u

877: trading_partner_contact_id auction_contact_id,
878: nvl(auc.publish_auction_now_flag,'N') publish_auction_now_flag,
879: nvl(auc.open_auction_now_flag,'N') open_auction_now_flag,
880: auc.auction_header_id_orig_amend
881: from pon_neg_team_members neg, pon_auction_headers_all auc, fnd_user u
882: where neg.auction_header_id = auc.auction_header_id and
883: auc.auction_header_id = p_auction_header_id
884: and neg.APPROVER_FLAG ='Y'
885: AND neg.MENU_NAME <> 'EMD_ADMIN' --FOR ERIC TEST ONLY

Line 2182: , fnd_user u

2178: , auc.auction_header_id_orig_amend
2179: FROM
2180: pon_neg_team_members neg
2181: , pon_auction_headers_all auc
2182: , fnd_user u
2183: WHERE neg.auction_header_id = auc.auction_header_id
2184: AND auc.auction_header_id = p_auction_header_id
2185: AND MENU_NAME='EMD_ADMIN'
2186: AND approver_flag = 'Y' --for eric test only