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.PON_AUCTION_PKG dependencies on FND_USER

Line 161: x_auctioneer_user_name FND_USER.USER_NAME%TYPE;

157: x_auctioneer_tag Varchar2(30);
158: x_event_id NUMBER;
159: x_event_title VARCHAR2(80);
160: x_language_code VARCHAR2(3) := null;
161: x_auctioneer_user_name FND_USER.USER_NAME%TYPE;
162: x_preview_message VARCHAR2(100);
163: x_article_doc_type VARCHAR2(100);
164:
165: x_doctype_group_name VARCHAR2(100);

Line 204: l_origin_user_name FND_USER.USER_NAME%TYPE;

200: x_auction_header_id_orig_amend NUMBER;
201: x_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
202: x_preview_date DATE;
203: x_preview_date_notspec VARCHAR2(240);
204: l_origin_user_name FND_USER.USER_NAME%TYPE;
205:
206: x_staggered_closing_interval NUMBER;
207: x_staggered_close_note VARCHAR2(1000);
208:

Line 507: from fnd_user

503: select user_name,
504: person_party_id
505: into x_user_name,
506: x_contact_id
507: from fnd_user
508: where person_party_id = x_auction_contact_id
509: and nvl(end_date, sysdate+1) > sysdate;
510: EXCEPTION
511: WHEN TOO_MANY_ROWS THEN

Line 523: from fnd_user

519: select user_name,
520: person_party_id
521: into x_user_name,
522: x_contact_id
523: from fnd_user
524: where person_party_id = x_auction_contact_id
525: and nvl(end_date, sysdate+1) > sysdate
526: and rownum=1;
527:

Line 2851: l_origin_user_name fnd_user.user_name%TYPE;

2847: x_disqualify_date date;
2848: x_bid_name VARCHAR2(10);
2849: x_staggered_close_note VARCHAR2(1000);
2850:
2851: l_origin_user_name fnd_user.user_name%TYPE;
2852:
2853: begin
2854:
2855: if (p_action_code = 'CANCEL') then

Line 3110: -- First sql of the cursor can have multiple fnd_user entries for a given trading

3106: IS
3107: -- First pick all the invited suppliers from bidding parties table.
3108:
3109: --
3110: -- First sql of the cursor can have multiple fnd_user entries for a given trading
3111: -- partner contact id and thus it has virtually no way to remove the rows with
3112: -- duplicate TPC Ids. We are assuming that only one fnd_user will be alive after
3113: -- a party merge
3114: --

Line 3112: -- duplicate TPC Ids. We are assuming that only one fnd_user will be alive after

3108:
3109: --
3110: -- First sql of the cursor can have multiple fnd_user entries for a given trading
3111: -- partner contact id and thus it has virtually no way to remove the rows with
3112: -- duplicate TPC Ids. We are assuming that only one fnd_user will be alive after
3113: -- a party merge
3114: --
3115: SELECT fu.user_name user_name,
3116: trading_partner_id party_id,

Line 3121: fnd_user fu

3117: trading_partner_name party_name,
3118: DECODE(vendor_site_code, '-1', NULL, vendor_site_code) vendor_site_code,
3119: vendor_site_id
3120: FROM pon_bidding_parties pbp,
3121: fnd_user fu
3122: WHERE auction_header_id = x_doc_header_id_prev_round
3123: AND fu.person_party_id = pbp.trading_partner_contact_id
3124: AND nvl(fu.end_date, sysdate+1) > sysdate
3125: UNION

Line 3215: l_origin_user_name fnd_user.user_name%TYPE;

3211: x_timezone_disp VARCHAR2(240);
3212: x_staggered_closing_interval NUMBER;
3213: x_staggered_close_note VARCHAR2(1000);
3214:
3215: l_origin_user_name fnd_user.user_name%TYPE;
3216:
3217: BEGIN
3218:
3219: x_doc_header_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,

Line 3508: party_id = (select person_party_id from fnd_user where user_name = prevBidder.user_name);

3504: if (x_bidder_name is null or x_bidder_name = '') then
3505: begin
3506: select party_name into x_bidder_name
3507: from hz_parties where
3508: party_id = (select person_party_id from fnd_user where user_name = prevBidder.user_name);
3509: exception
3510: when others then
3511: x_bidder_name := prevBidder.user_name;
3512: end;

Line 3793: from fnd_user where person_party_id = (select trading_partner_contact_id

3789: and pbp.requested_supplier_contact_id = pcr.contact_request_id (+);
3790:
3791: CURSOR c_user_name IS
3792: select user_name
3793: from fnd_user where person_party_id = (select trading_partner_contact_id
3794: from pon_auction_headers_all
3795: where auction_header_id = x_auction_header_id)
3796: and nvl(end_date,sysdate+1) > sysdate
3797: and rownum = 1;

Line 3844: from fnd_user where person_party_id = x_person_party_id

3840:
3841: BEGIN
3842: select user_name
3843: into x_user_name
3844: from fnd_user where person_party_id = x_person_party_id
3845: and nvl(end_date, sysdate+1) > sysdate;
3846: EXCEPTION
3847: when too_many_rows then
3848: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then

Line 3858: from fnd_user

3854: end if;
3855:
3856: select user_name
3857: into x_user_name
3858: from fnd_user
3859: where person_party_id = x_person_party_id
3860: and nvl(end_date, sysdate+1) > sysdate
3861: and rownum=1;
3862:

Line 3870: from fnd_user

3866: x_user_orig_system := 'FND_USR';
3867: begin
3868: select to_char(user_id)
3869: into x_user_orig_system_id
3870: from fnd_user
3871: where user_name = x_user_name;
3872: exception when others then
3873: x_user_orig_system_id := 0;
3874: end;

Line 4246: from fnd_user

4242:
4243: BEGIN
4244: select user_name
4245: into x_bidder_user_name
4246: from fnd_user
4247: where person_party_id= p_trading_partner_contact_id
4248: and nvl(end_date, sysdate+1) > sysdate;
4249: EXCEPTION
4250: when too_many_rows then

Line 4261: from fnd_user

4257: end if;
4258:
4259: select user_name
4260: into x_bidder_user_name
4261: from fnd_user
4262: where person_party_id = p_trading_partner_contact_id
4263: and nvl(end_date, sysdate+1) > sysdate
4264: and rownum=1;
4265:

Line 5315: -- from fnd_user where person_party_id = x_auction_contact_id;

5311: -------------------------------
5312:
5313: --select user_name, person_party_id
5314: -- into x_user_name, x_contact_id
5315: -- from fnd_user where person_party_id = x_auction_contact_id;
5316: --
5317:
5318: BEGIN
5319: --

Line 5331: from fnd_user

5327:
5328: BEGIN
5329: select user_name
5330: into x_user_name
5331: from fnd_user
5332: where person_party_id = x_contact_id
5333: and nvl(end_date, sysdate+1) > sysdate;
5334: EXCEPTION
5335: WHEN TOO_MANY_ROWS THEN

Line 5346: from fnd_user

5342: end if;
5343:
5344: select user_name
5345: into x_user_name
5346: from fnd_user
5347: where person_party_id = x_contact_id
5348: and nvl(end_date, sysdate+1) > sysdate
5349: and rownum=1;
5350:

Line 5444: from fnd_user

5440:
5441: BEGIN
5442: select user_name
5443: into x_user_name
5444: from fnd_user
5445: where person_party_id = x_contact_id
5446: and nvl(end_date, sysdate+1) > sysdate;
5447: EXCEPTION
5448: WHEN TOO_MANY_ROWS THEN

Line 5459: from fnd_user

5455: end if;
5456:
5457: select user_name
5458: into x_user_name
5459: from fnd_user
5460: where person_party_id = x_contact_id
5461: and nvl(end_date, sysdate+1) > sysdate
5462: and rownum=1;
5463:

Line 6062: from wf_user_roles wfu, fnd_user fnd

6058:
6059:
6060: CURSOR bidders IS
6061: select wfu.user_name user_name, person_party_id
6062: from wf_user_roles wfu, fnd_user fnd
6063: where role_name = x_wf_role_name
6064: and fnd.user_name (+) = wfu.user_name
6065: AND wfu.user_name NOT IN (SELECT wf_user_name FROM pon_bidding_parties
6066: WHERE auction_header_id = x_doc_number AND trading_partner_id IS NULL);

Line 6064: and fnd.user_name (+) = wfu.user_name

6060: CURSOR bidders IS
6061: select wfu.user_name user_name, person_party_id
6062: from wf_user_roles wfu, fnd_user fnd
6063: where role_name = x_wf_role_name
6064: and fnd.user_name (+) = wfu.user_name
6065: AND wfu.user_name NOT IN (SELECT wf_user_name FROM pon_bidding_parties
6066: WHERE auction_header_id = x_doc_number AND trading_partner_id IS NULL);
6067:
6068: CURSOR bidders_info IS

Line 7234: from fnd_user

7230: BEGIN
7231: begin
7232: select user_name
7233: into x_user_name
7234: from fnd_user
7235: where person_party_id = p_user_id
7236: and nvl(end_date,sysdate+1) > sysdate;
7237: exception
7238: when too_many_rows then

Line 7249: from fnd_user

7245: end if;
7246:
7247: select user_name
7248: into x_user_name
7249: from fnd_user
7250: where person_party_id = p_user_id
7251: and nvl(end_date, sysdate+1) > sysdate
7252: and rownum=1;
7253: end;

Line 7263: from fnd_user where user_name = p_user_name;

7259: IS
7260: x_count int := 0;
7261: BEGIN
7262: select count(*) into x_count
7263: from fnd_user where user_name = p_user_name;
7264:
7265: if (x_count > 0) then return true; else return false; end if;
7266: END;
7267:

Line 7292: -- occur if user is deleted from fnd_user table

7288:
7289: x_profile_user := GET_USER_NAME(x_user_id);
7290:
7291: if (x_profile_user is null) then -- this condition should not occur. It may
7292: -- occur if user is deleted from fnd_user table
7293: x_profile_user := p_preparer_tp_contact_name; -- Bug 3824928: changed from p_user_name to
7294: -- default to the auctioneer name
7295: end if;
7296: end if;

Line 7352: from fnd_user

7348:
7349: begin
7350: select user_id
7351: into x_user_id
7352: from fnd_user
7353: where person_party_id = contact_id
7354: and nvl(end_date, sysdate+1) > sysdate;
7355: x_timezone := fnd_profile.value_specific('CLIENT_TIMEZONE_ID',x_user_id);
7356: exception

Line 7368: from fnd_user

7364: end if;
7365:
7366: select user_id
7367: into x_user_id
7368: from fnd_user
7369: where person_party_id = contact_id
7370: and nvl(end_date, sysdate+1) > sysdate
7371: and rownum=1;
7372:

Line 7386: from fnd_user

7382: end if;
7383:
7384: select user_id
7385: into x_user_id
7386: from fnd_user
7387: where person_party_id = contact_id
7388: and rownum=1;
7389:
7390: x_timezone := fnd_profile.value_specific('CLIENT_TIMEZONE_ID',x_user_id);

Line 7418: FROM fnd_user

7414: begin
7415: begin
7416: SELECT person_party_id
7417: INTO x_contact_id
7418: FROM fnd_user
7419: WHERE user_name = contact_name;
7420: exception
7421: when others then
7422: x_contact_id := null;

Line 8334: fnd_user fu

8330: pbd.registration_id,
8331: pbd.trading_partner_contact_id, -- Bug 3824928 added
8332: pbd.vendor_site_id
8333: from pon_bidding_parties pbd,
8334: fnd_user fu
8335: WHERE pbd.trading_partner_contact_id=fu.person_party_id (+) AND -- Bug 3824928: added outer join
8336: nvl(fu.end_date, sysdate+1) > sysdate AND -- Added for TCA project
8337: pbd.auction_header_id=x_doc_number AND
8338: nvl(pbd.supp_acknowledgement,'havenot')= 'havenot'

Line 8389: l_origin_user_name fnd_user.user_name%TYPE;

8385: x_tp_id NUMBER;
8386:
8387: x_registration_key VARCHAR2(100);
8388:
8389: l_origin_user_name fnd_user.user_name%TYPE;
8390:
8391: BEGIN
8392:
8393: x_doc_number := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 8493: FROM fnd_user

8489:
8490: BEGIN
8491: SELECT person_party_id
8492: INTO x_person_party_id
8493: FROM fnd_user
8494: WHERE user_name = bidder.my_user_name;
8495: EXCEPTION
8496: WHEN TOO_MANY_ROWS THEN
8497: null; -- This can never throw too many row exception

Line 9897: fnd_user fu,

9893:
9894: from pon_auction_headers_all auh,
9895: hz_parties hz,
9896: pon_neg_team_members pntm,
9897: fnd_user fu,
9898: pon_auc_doctypes pad
9899: where auh.auction_header_id = p_auction_header_id
9900: AND hz.party_id = auh.trading_partner_id
9901: AND pntm.auction_header_id = auh.auction_header_id

Line 10213: fnd_user fu

10209: l_open_auction_now_flag,
10210: l_publish_auction_now_flag
10211: from pon_auction_headers_all auh,
10212: pon_auc_doctypes pad,
10213: fnd_user fu
10214: where auh.auction_header_id = p_auction_header_id
10215: AND pad.doctype_id = auh.doctype_id
10216: AND fu.person_party_id = auh.TRADING_PARTNER_CONTACT_ID
10217: AND nvl(fu.end_date,sysdate+1) > sysdate;

Line 10255: fnd_user fu

10251: l_open_auction_now_flag,
10252: l_publish_auction_now_flag
10253: from pon_auction_headers_all auh,
10254: pon_auc_doctypes pad,
10255: fnd_user fu
10256: where auh.auction_header_id = p_auction_header_id
10257: AND pad.doctype_id = auh.doctype_id
10258: AND fu.person_party_id = auh.TRADING_PARTNER_CONTACT_ID
10259: AND nvl(fu.end_date,sysdate+1) > sysdate

Line 10309: fnd_user fu

10305: l_task_completion_date,
10306: l_user_name
10307: from hz_parties hz,
10308: pon_neg_team_members pntm,
10309: fnd_user fu
10310: where pntm.auction_header_id = p_auction_header_id
10311: AND hz.party_id = l_trading_partner_id
10312: AND pntm.user_id = p_user_id
10313: AND fu.user_id = pntm.user_id;

Line 10546: l_tp_contact_usr_id FND_USER.USER_ID%TYPE;

10542: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
10543: l_response_number PON_BID_HEADERS.BID_NUMBER%TYPE;
10544: l_bidder_tpc_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
10545: l_bidder_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
10546: l_tp_contact_usr_id FND_USER.USER_ID%TYPE;
10547: l_timezone_disp VARCHAR2(240);
10548: l_bid_contact_dp_name VARCHAR2(350);
10549: l_bidder_dp_name VARCHAR2(350);
10550: l_response_type_name VARCHAR2(2000);

Line 10611: fnd_user fu

10607: l_auction_header_id
10608: from pon_auction_headers_all auh,
10609: pon_auc_doctypes pad,
10610: pon_bid_headers pbh,
10611: fnd_user fu
10612: where pbh.bid_number = p_bid_number
10613: AND pad.doctype_id = auh.doctype_id
10614: AND auh.auction_header_id = pbh.auction_header_id
10615: AND fu.person_party_id = pbh.trading_partner_contact_id

Line 10662: fnd_user fu

10658: l_auction_header_id
10659: from pon_auction_headers_all auh,
10660: pon_auc_doctypes pad,
10661: pon_bid_headers pbh,
10662: fnd_user fu
10663: where pbh.bid_number = p_bid_number
10664: AND pad.doctype_id = auh.doctype_id
10665: AND auh.auction_header_id = pbh.auction_header_id
10666: AND fu.person_party_id = pbh.trading_partner_contact_id

Line 11016: l_user_name FND_USER.USER_NAME%TYPE;

11012: l_sequence NUMBER;
11013: l_itemtype VARCHAR2(7);
11014: l_itemkey VARCHAR2(50);
11015: l_user_id NUMBER;
11016: l_user_name FND_USER.USER_NAME%TYPE;
11017: l_sender_user FND_USER.USER_NAME%TYPE;
11018: l_from_id NUMBER;
11019: l_from_company_id NUMBER;
11020: l_page_url VARCHAR2(500);

Line 11017: l_sender_user FND_USER.USER_NAME%TYPE;

11013: l_itemtype VARCHAR2(7);
11014: l_itemkey VARCHAR2(50);
11015: l_user_id NUMBER;
11016: l_user_name FND_USER.USER_NAME%TYPE;
11017: l_sender_user FND_USER.USER_NAME%TYPE;
11018: l_from_id NUMBER;
11019: l_from_company_id NUMBER;
11020: l_page_url VARCHAR2(500);
11021: l_discussion_id NUMBER;

Line 11040: fnd_user fu

11036: hz.person_first_name FIRST_NAME,
11037: hz.person_last_name LAST_NAME
11038: FROM pon_neg_team_members pntm,
11039: HZ_PARTIES hz,
11040: fnd_user fu
11041: WHERE hz.party_id=fu.person_party_id
11042: AND nvl(fu.end_date,sysdate+1) > sysdate
11043: AND fu.user_id=pntm.user_id
11044: AND fu.person_party_id <> p_sender_id

Line 11121: fnd_user fu

11117: hz.person_first_name FIRST_NAME,
11118: hz.person_last_name LAST_NAME
11119: FROM pon_scoring_team_members pntm,
11120: HZ_PARTIES hz,
11121: fnd_user fu
11122: WHERE hz.party_id=fu.person_party_id
11123: AND fu.user_id=pntm.user_id
11124: AND nvl(fu.end_date,sysdate+1) > sysdate
11125: AND fu.person_party_id <> p_sender_id

Line 11139: fnd_user fu

11135: hz.person_first_name FIRST_NAME,
11136: hz.person_last_name LAST_NAME
11137: FROM pon_scoring_team_members pntm,
11138: HZ_PARTIES hz,
11139: fnd_user fu
11140: WHERE hz.party_id=fu.person_party_id
11141: AND fu.user_id=pntm.user_id
11142: AND nvl(fu.end_date,sysdate+1) > sysdate
11143: AND fu.person_party_id <> p_sender_id

Line 11759: l_user_name FND_USER.USER_NAME%TYPE;

11755:
11756: l_itemtype VARCHAR2(7);
11757: l_itemkey VARCHAR2(50);
11758: l_user_id NUMBER;
11759: l_user_name FND_USER.USER_NAME%TYPE;
11760: l_sender_user FND_USER.USER_NAME%TYPE;
11761: l_page_url VARCHAR2(500);
11762: l_wfm_htmlagent VARCHAR2(500);
11763: l_discussion_id NUMBER;

Line 11760: l_sender_user FND_USER.USER_NAME%TYPE;

11756: l_itemtype VARCHAR2(7);
11757: l_itemkey VARCHAR2(50);
11758: l_user_id NUMBER;
11759: l_user_name FND_USER.USER_NAME%TYPE;
11760: l_sender_user FND_USER.USER_NAME%TYPE;
11761: l_page_url VARCHAR2(500);
11762: l_wfm_htmlagent VARCHAR2(500);
11763: l_discussion_id NUMBER;
11764: l_auction_start_date DATE;

Line 11792: FROM FND_USER

11788: USER_NAME
11789: INTO
11790: l_user_id,
11791: l_user_name
11792: FROM FND_USER
11793: WHERE PERSON_PARTY_ID = p_userPartyId
11794: AND NVL(END_DATE, SYSDATE+1) > SYSDATE;
11795:
11796: EXCEPTION

Line 11812: FROM FND_USER

11808: USER_NAME
11809: INTO
11810: l_user_id,
11811: l_user_name
11812: FROM FND_USER
11813: WHERE PERSON_PARTY_ID = p_userPartyId
11814: AND NVL(END_DATE, SYSDATE+1) > SYSDATE
11815: AND ROWNUM=1;
11816:

Line 11825: FROM FND_USER

11821: SELECT
11822: USER_NAME
11823: INTO
11824: l_sender_user
11825: FROM FND_USER
11826: WHERE PERSON_PARTY_ID = p_from_id
11827: AND NVL(END_DATE, SYSDATE+1) > SYSDATE;
11828:
11829: EXCEPTION

Line 11843: FROM FND_USER

11839: SELECT
11840: USER_NAME
11841: INTO
11842: l_sender_user
11843: FROM FND_USER
11844: WHERE PERSON_PARTY_ID = p_from_id
11845: AND NVL(END_DATE, SYSDATE+1) > SYSDATE
11846: AND ROWNUM=1;
11847: