APPS.PON_AUCTION_APPROVAL_PKG dependencies on FND_USER

Line 116: from fnd_user

112:
113: -- use user_id wherever possible
114: select user_id
115: into l_user_id
116: from fnd_user
117: where user_name = p_user_name;
118:
119:
120:

Line 173: from fnd_user

169:
170: -- use user_id wherever possible
171: select user_id
172: into l_user_id
173: from fnd_user
174: where user_name = p_user_name;
175:
176: -- Check to see if this user has already approved
177: begin

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

295: l_preview_date_in_tz DATE;
296: l_timezone1_disp VARCHAR2(240);
297: l_submit_user_id number;
298:
299: /* Get FND user name from trading_partner_contact_id */
300: CURSOR c_auction_info IS
301: select fnd.user_name, fnd.user_id, pon.close_bidding_date,
302: pon.auction_title,
303: decode(nvl(pon.open_auction_now_flag,'N'),'Y',to_date(null),pon.open_bidding_date) open_bidding_date,

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

297: l_submit_user_id number;
298:
299: /* Get FND user name from trading_partner_contact_id */
300: CURSOR c_auction_info IS
301: select fnd.user_name, fnd.user_id, pon.close_bidding_date,
302: pon.auction_title,
303: decode(nvl(pon.open_auction_now_flag,'N'),'Y',to_date(null),pon.open_bidding_date) open_bidding_date,
304: nvl(pon.open_auction_now_flag,'N') open_auction_now_flag,
305: pon.document_number, trading_partner_contact_id, trading_partner_name, trading_partner_contact_name,

Line 308: from fnd_user fnd,pon_auction_headers_all pon

304: nvl(pon.open_auction_now_flag,'N') open_auction_now_flag,
305: pon.document_number, trading_partner_contact_id, trading_partner_name, trading_partner_contact_name,
306: open_bidding_date, close_bidding_date, nvl(auction_round_number, 1),
307: nvl(amendment_number, 0), auction_header_id_orig_amend, view_by_date
308: from fnd_user fnd,pon_auction_headers_all pon
309: where fnd.person_party_id = pon.trading_partner_contact_id and
310: pon.auction_header_id = p_auction_header_id and
311: rownum=1;
312:

Line 564: fnd_user fnd

560:
561: /* Get the creator's full name */
562: select emp.full_name into l_creator_full_name from
563: per_all_people_f emp,
564: fnd_user fnd
565: where fnd.employee_id=emp.person_id and
566: fnd.user_id = l_creator_user_id and
567: trunc(sysdate) between emp.effective_start_date and emp.effective_end_date;
568:

Line 566: fnd.user_id = l_creator_user_id and

562: select emp.full_name into l_creator_full_name from
563: per_all_people_f emp,
564: fnd_user fnd
565: where fnd.employee_id=emp.person_id and
566: fnd.user_id = l_creator_user_id and
567: trunc(sysdate) between emp.effective_start_date and emp.effective_end_date;
568:
569: wf_engine.SetItemAttrText (itemtype => l_itemType,
570: itemkey => l_itemKey,

Line 584: from fnd_user

580:
581: -- use user_id wherever possible
582: select user_id
583: into l_submit_user_id
584: from fnd_user
585: where user_name = p_submit_user_name;
586:
587:
588: UPD_AUCTION_STATUSHISTORY(p_auction_header_id, 'SUBMIT',p_note_to_approvers,

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

663: trading_partner_contact_id auction_contact_id,
664: nvl(auc.publish_auction_now_flag,'N') publish_auction_now_flag,
665: nvl(auc.open_auction_now_flag,'N') open_auction_now_flag,
666: auc.auction_header_id_orig_amend
667: from pon_neg_team_members neg, pon_auction_headers_all auc, fnd_user u
668: where neg.auction_header_id = auc.auction_header_id and
669: auc.auction_header_id = p_auction_header_id
670: and neg.APPROVER_FLAG ='Y'
671: and u.user_id = neg.user_id;