DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on FND_USER

Line 170: x_auctioneer_user_name FND_USER.USER_NAME%TYPE;

166: x_auctioneer_tag Varchar2(30);
167: x_event_id NUMBER;
168: x_event_title VARCHAR2(80);
169: x_language_code VARCHAR2(3) := null;
170: x_auctioneer_user_name FND_USER.USER_NAME%TYPE;
171: x_preview_message VARCHAR2(100);
172: x_article_doc_type VARCHAR2(100);
173:
174: x_doctype_group_name VARCHAR2(100);

Line 213: l_origin_user_name FND_USER.USER_NAME%TYPE;

209: x_auction_header_id_orig_amend NUMBER;
210: x_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
211: x_preview_date DATE;
212: x_preview_date_notspec VARCHAR2(240);
213: l_origin_user_name FND_USER.USER_NAME%TYPE;
214:
215: x_staggered_closing_interval NUMBER;
216: x_staggered_close_note VARCHAR2(1000);
217: x_exempt_flag VARCHAR2(1);

Line 530: from fnd_user

526: select user_name,
527: person_party_id
528: into x_user_name,
529: x_contact_id
530: from fnd_user
531: where person_party_id = x_auction_contact_id
532: and nvl(end_date, sysdate+1) > sysdate;
533: EXCEPTION
534: WHEN TOO_MANY_ROWS THEN

Line 546: from fnd_user

542: select user_name,
543: person_party_id
544: into x_user_name,
545: x_contact_id
546: from fnd_user
547: where person_party_id = x_auction_contact_id
548: and nvl(end_date, sysdate+1) > sysdate
549: and rownum=1;
550:

Line 1261: x_emd_admin_name fnd_user.user_name%TYPE;

1257: x_cancel_reason PON_ACTION_HISTORY.ACTION_NOTE%TYPE := '';
1258: x_cancel_date PON_AUCTION_HEADERS_ALL.CANCEL_DATE%TYPE;
1259: x_event_title PON_AUCTION_HEADERS_ALL.Event_Title%TYPE;
1260: x_start_date PON_AUCTION_HEADERS_ALL.PUBLISH_DATE%TYPE;
1261: x_emd_admin_name fnd_user.user_name%TYPE;
1262: x_auction_tp_name PON_AUCTION_HEADERS_ALL.trading_partner_name%TYPE;
1263: x_doc_number_dsp PON_AUCTION_HEADERS_ALL.document_number%TYPE;
1264: x_auction_title PON_AUCTION_HEADERS_ALL.auction_title%TYPE;
1265: CURSOR all_emdAdmins(p_auction_header_id NUMBER) IS

Line 1270: from pon_neg_team_members b, pon_auction_headers_all a, fnd_user u

1266: select u.user_name,
1267: a.trading_partner_name,
1268: a.auction_title,
1269: a.document_number, a.cancel_date, a.event_title, a.publish_date
1270: from pon_neg_team_members b, pon_auction_headers_all a, fnd_user u
1271: where b.menu_name = 'EMD_ADMIN'
1272: and b.approver_flag = 'Y'
1273: and a.auction_header_id = b.auction_header_id
1274: and u.user_id = b.user_id

Line 3361: l_origin_user_name fnd_user.user_name%TYPE;

3357: x_disqualify_date date;
3358: x_bid_name VARCHAR2(10);
3359: x_staggered_close_note VARCHAR2(1000);
3360:
3361: l_origin_user_name fnd_user.user_name%TYPE;
3362:
3363: begin
3364:
3365: if (p_action_code = 'CANCEL') then

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

3616: IS
3617: -- First pick all the invited suppliers from bidding parties table.
3618:
3619: --
3620: -- First sql of the cursor can have multiple fnd_user entries for a given trading
3621: -- partner contact id and thus it has virtually no way to remove the rows with
3622: -- duplicate TPC Ids. We are assuming that only one fnd_user will be alive after
3623: -- a party merge
3624: --

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

3618:
3619: --
3620: -- First sql of the cursor can have multiple fnd_user entries for a given trading
3621: -- partner contact id and thus it has virtually no way to remove the rows with
3622: -- duplicate TPC Ids. We are assuming that only one fnd_user will be alive after
3623: -- a party merge
3624: --
3625: SELECT fu.user_name user_name,
3626: trading_partner_id party_id,

Line 3631: fnd_user fu

3627: trading_partner_name party_name,
3628: DECODE(vendor_site_code, '-1', NULL, vendor_site_code) vendor_site_code,
3629: vendor_site_id
3630: FROM pon_bidding_parties pbp,
3631: fnd_user fu
3632: WHERE auction_header_id = x_doc_header_id_prev_round
3633: AND fu.person_party_id = pbp.trading_partner_contact_id
3634: AND nvl(fu.end_date, sysdate+1) > sysdate
3635: UNION

Line 3725: l_origin_user_name fnd_user.user_name%TYPE;

3721: x_timezone_disp VARCHAR2(240);
3722: x_staggered_closing_interval NUMBER;
3723: x_staggered_close_note VARCHAR2(1000);
3724:
3725: l_origin_user_name fnd_user.user_name%TYPE;
3726:
3727: -- bug 8613271
3728: x_supplier_sequence NUMBER;
3729: x_emd_received_flag VARCHAR2(1);

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

4025: if (x_bidder_name is null or x_bidder_name = '') then
4026: begin
4027: select party_name into x_bidder_name
4028: from hz_parties where
4029: party_id = (select person_party_id from fnd_user where user_name = prevBidder.user_name);
4030: exception
4031: when others then
4032: x_bidder_name := prevBidder.user_name;
4033: end;

Line 4359: from fnd_user where person_party_id = (select trading_partner_contact_id

4355: and pbp.requested_supplier_contact_id = pcr.contact_request_id (+);
4356:
4357: CURSOR c_user_name IS
4358: select user_name
4359: from fnd_user where person_party_id = (select trading_partner_contact_id
4360: from pon_auction_headers_all
4361: where auction_header_id = x_auction_header_id)
4362: and nvl(end_date,sysdate+1) > sysdate
4363: and rownum = 1;

Line 4410: from fnd_user where person_party_id = x_person_party_id

4406:
4407: BEGIN
4408: select user_name
4409: into x_user_name
4410: from fnd_user where person_party_id = x_person_party_id
4411: and nvl(end_date, sysdate+1) > sysdate;
4412: EXCEPTION
4413: when too_many_rows then
4414: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then

Line 4424: from fnd_user

4420: end if;
4421:
4422: select user_name
4423: into x_user_name
4424: from fnd_user
4425: where person_party_id = x_person_party_id
4426: and nvl(end_date, sysdate+1) > sysdate
4427: and rownum=1;
4428:

Line 4436: from fnd_user

4432: x_user_orig_system := 'FND_USR';
4433: begin
4434: select to_char(user_id)
4435: into x_user_orig_system_id
4436: from fnd_user
4437: where user_name = x_user_name;
4438: exception when others then
4439: x_user_orig_system_id := 0;
4440: end;

Line 4832: from fnd_user

4828:
4829: BEGIN
4830: select user_name
4831: into x_bidder_user_name
4832: from fnd_user
4833: where person_party_id= p_trading_partner_contact_id
4834: and nvl(end_date, sysdate+1) > sysdate;
4835: EXCEPTION
4836: when too_many_rows then

Line 4847: from fnd_user

4843: end if;
4844:
4845: select user_name
4846: into x_bidder_user_name
4847: from fnd_user
4848: where person_party_id = p_trading_partner_contact_id
4849: and nvl(end_date, sysdate+1) > sysdate
4850: and rownum=1;
4851:

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

5907: -------------------------------
5908:
5909: --select user_name, person_party_id
5910: -- into x_user_name, x_contact_id
5911: -- from fnd_user where person_party_id = x_auction_contact_id;
5912: --
5913:
5914: BEGIN
5915: --

Line 5927: from fnd_user

5923:
5924: BEGIN
5925: select user_name
5926: into x_user_name
5927: from fnd_user
5928: where person_party_id = x_contact_id
5929: and nvl(end_date, sysdate+1) > sysdate;
5930: EXCEPTION
5931: WHEN TOO_MANY_ROWS THEN

Line 5942: from fnd_user

5938: end if;
5939:
5940: select user_name
5941: into x_user_name
5942: from fnd_user
5943: where person_party_id = x_contact_id
5944: and nvl(end_date, sysdate+1) > sysdate
5945: and rownum=1;
5946:

Line 6040: from fnd_user

6036:
6037: BEGIN
6038: select user_name
6039: into x_user_name
6040: from fnd_user
6041: where person_party_id = x_contact_id
6042: and nvl(end_date, sysdate+1) > sysdate;
6043: EXCEPTION
6044: WHEN TOO_MANY_ROWS THEN

Line 6055: from fnd_user

6051: end if;
6052:
6053: select user_name
6054: into x_user_name
6055: from fnd_user
6056: where person_party_id = x_contact_id
6057: and nvl(end_date, sysdate+1) > sysdate
6058: and rownum=1;
6059:

Line 6658: from wf_user_roles wfu, fnd_user fnd

6654:
6655:
6656: CURSOR bidders IS
6657: select wfu.user_name user_name, person_party_id
6658: from wf_user_roles wfu, fnd_user fnd
6659: where role_name = x_wf_role_name
6660: and fnd.user_name (+) = wfu.user_name
6661: AND wfu.user_name NOT IN (SELECT wf_user_name FROM pon_bidding_parties
6662: WHERE auction_header_id = x_doc_number AND trading_partner_id IS NULL);

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

6656: CURSOR bidders IS
6657: select wfu.user_name user_name, person_party_id
6658: from wf_user_roles wfu, fnd_user fnd
6659: where role_name = x_wf_role_name
6660: and fnd.user_name (+) = wfu.user_name
6661: AND wfu.user_name NOT IN (SELECT wf_user_name FROM pon_bidding_parties
6662: WHERE auction_header_id = x_doc_number AND trading_partner_id IS NULL);
6663:
6664: CURSOR bidders_info IS

Line 7903: from fnd_user

7899: BEGIN
7900: begin
7901: select user_name
7902: into x_user_name
7903: from fnd_user
7904: where person_party_id = p_user_id
7905: and nvl(end_date,sysdate+1) > sysdate;
7906: exception
7907: when too_many_rows then

Line 7918: from fnd_user

7914: end if;
7915:
7916: select user_name
7917: into x_user_name
7918: from fnd_user
7919: where person_party_id = p_user_id
7920: and nvl(end_date, sysdate+1) > sysdate
7921: and rownum=1;
7922: end;

Line 7932: from fnd_user where user_name = p_user_name;

7928: IS
7929: x_count int := 0;
7930: BEGIN
7931: select count(*) into x_count
7932: from fnd_user where user_name = p_user_name;
7933:
7934: if (x_count > 0) then return true; else return false; end if;
7935: END;
7936:

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

7957:
7958: x_profile_user := GET_USER_NAME(x_user_id);
7959:
7960: if (x_profile_user is null) then -- this condition should not occur. It may
7961: -- occur if user is deleted from fnd_user table
7962: x_profile_user := p_preparer_tp_contact_name; -- Bug 3824928: changed from p_user_name to
7963: -- default to the auctioneer name
7964: end if;
7965: end if;

Line 8021: from fnd_user

8017:
8018: begin
8019: select user_id
8020: into x_user_id
8021: from fnd_user
8022: where person_party_id = contact_id
8023: and nvl(end_date, sysdate+1) > sysdate;
8024: x_timezone := fnd_profile.value_specific('CLIENT_TIMEZONE_ID',x_user_id);
8025: exception

Line 8037: from fnd_user

8033: end if;
8034:
8035: select user_id
8036: into x_user_id
8037: from fnd_user
8038: where person_party_id = contact_id
8039: and nvl(end_date, sysdate+1) > sysdate
8040: and rownum=1;
8041:

Line 8055: from fnd_user

8051: end if;
8052:
8053: select user_id
8054: into x_user_id
8055: from fnd_user
8056: where person_party_id = contact_id
8057: and rownum=1;
8058:
8059: x_timezone := fnd_profile.value_specific('CLIENT_TIMEZONE_ID',x_user_id);

Line 8087: FROM fnd_user

8083: begin
8084: begin
8085: SELECT person_party_id
8086: INTO x_contact_id
8087: FROM fnd_user
8088: WHERE user_name = contact_name;
8089: exception
8090: when others then
8091: x_contact_id := null;

Line 9041: fnd_user fu

9037: pbd.registration_id,
9038: pbd.trading_partner_contact_id, -- Bug 3824928 added
9039: pbd.vendor_site_id
9040: from pon_bidding_parties pbd,
9041: fnd_user fu
9042: WHERE pbd.trading_partner_contact_id=fu.person_party_id (+) AND -- Bug 3824928: added outer join
9043: nvl(fu.end_date, sysdate+1) > sysdate AND -- Added for TCA project
9044: pbd.auction_header_id=x_doc_number AND
9045: nvl(pbd.supp_acknowledgement,'havenot')= 'havenot'

Line 9096: l_origin_user_name fnd_user.user_name%TYPE;

9092: x_tp_id NUMBER;
9093:
9094: x_registration_key VARCHAR2(100);
9095:
9096: l_origin_user_name fnd_user.user_name%TYPE;
9097:
9098: BEGIN
9099:
9100: x_doc_number := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 9205: FROM fnd_user

9201:
9202: BEGIN
9203: SELECT person_party_id
9204: INTO x_person_party_id
9205: FROM fnd_user
9206: WHERE user_name = bidder.my_user_name;
9207: EXCEPTION
9208: WHEN TOO_MANY_ROWS THEN
9209: null; -- This can never throw too many row exception

Line 10733: fnd_user fu,

10729:
10730: from pon_auction_headers_all auh,
10731: hz_parties hz,
10732: pon_neg_team_members pntm,
10733: fnd_user fu,
10734: pon_auc_doctypes pad
10735: where auh.auction_header_id = p_auction_header_id
10736: AND hz.party_id = auh.trading_partner_id
10737: AND pntm.auction_header_id = auh.auction_header_id

Line 11049: fnd_user fu

11045: l_open_auction_now_flag,
11046: l_publish_auction_now_flag
11047: from pon_auction_headers_all auh,
11048: pon_auc_doctypes pad,
11049: fnd_user fu
11050: where auh.auction_header_id = p_auction_header_id
11051: AND pad.doctype_id = auh.doctype_id
11052: AND fu.person_party_id = auh.TRADING_PARTNER_CONTACT_ID
11053: AND nvl(fu.end_date,sysdate+1) > sysdate;

Line 11091: fnd_user fu

11087: l_open_auction_now_flag,
11088: l_publish_auction_now_flag
11089: from pon_auction_headers_all auh,
11090: pon_auc_doctypes pad,
11091: fnd_user fu
11092: where auh.auction_header_id = p_auction_header_id
11093: AND pad.doctype_id = auh.doctype_id
11094: AND fu.person_party_id = auh.TRADING_PARTNER_CONTACT_ID
11095: AND nvl(fu.end_date,sysdate+1) > sysdate

Line 11145: fnd_user fu

11141: l_task_completion_date,
11142: l_user_name
11143: from hz_parties hz,
11144: pon_neg_team_members pntm,
11145: fnd_user fu
11146: where pntm.auction_header_id = p_auction_header_id
11147: AND hz.party_id = l_trading_partner_id
11148: AND pntm.user_id = p_user_id
11149: AND fu.user_id = pntm.user_id;

Line 11382: l_tp_contact_usr_id FND_USER.USER_ID%TYPE;

11378: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
11379: l_response_number PON_BID_HEADERS.BID_NUMBER%TYPE;
11380: l_bidder_tpc_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
11381: l_bidder_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
11382: l_tp_contact_usr_id FND_USER.USER_ID%TYPE;
11383: l_timezone_disp VARCHAR2(240);
11384: l_bid_contact_dp_name VARCHAR2(350);
11385: l_bidder_dp_name VARCHAR2(350);
11386: l_response_type_name VARCHAR2(2000);

Line 11447: fnd_user fu

11443: l_auction_header_id
11444: from pon_auction_headers_all auh,
11445: pon_auc_doctypes pad,
11446: pon_bid_headers pbh,
11447: fnd_user fu
11448: where pbh.bid_number = p_bid_number
11449: AND pad.doctype_id = auh.doctype_id
11450: AND auh.auction_header_id = pbh.auction_header_id
11451: AND fu.person_party_id = pbh.trading_partner_contact_id

Line 11498: fnd_user fu

11494: l_auction_header_id
11495: from pon_auction_headers_all auh,
11496: pon_auc_doctypes pad,
11497: pon_bid_headers pbh,
11498: fnd_user fu
11499: where pbh.bid_number = p_bid_number
11500: AND pad.doctype_id = auh.doctype_id
11501: AND auh.auction_header_id = pbh.auction_header_id
11502: AND fu.person_party_id = pbh.trading_partner_contact_id

Line 11852: l_user_name FND_USER.USER_NAME%TYPE;

11848: l_sequence NUMBER;
11849: l_itemtype VARCHAR2(7);
11850: l_itemkey VARCHAR2(50);
11851: l_user_id NUMBER;
11852: l_user_name FND_USER.USER_NAME%TYPE;
11853: l_sender_user FND_USER.USER_NAME%TYPE;
11854: l_from_id NUMBER;
11855: l_from_company_id NUMBER;
11856: l_page_url VARCHAR2(500);

Line 11853: l_sender_user FND_USER.USER_NAME%TYPE;

11849: l_itemtype VARCHAR2(7);
11850: l_itemkey VARCHAR2(50);
11851: l_user_id NUMBER;
11852: l_user_name FND_USER.USER_NAME%TYPE;
11853: l_sender_user FND_USER.USER_NAME%TYPE;
11854: l_from_id NUMBER;
11855: l_from_company_id NUMBER;
11856: l_page_url VARCHAR2(500);
11857: l_discussion_id NUMBER;

Line 11876: fnd_user fu

11872: hz.person_first_name FIRST_NAME,
11873: hz.person_last_name LAST_NAME
11874: FROM pon_neg_team_members pntm,
11875: HZ_PARTIES hz,
11876: fnd_user fu
11877: WHERE hz.party_id=fu.person_party_id
11878: AND nvl(fu.end_date,sysdate+1) > sysdate
11879: AND fu.user_id=pntm.user_id
11880: AND fu.person_party_id <> p_sender_id

Line 11957: fnd_user fu

11953: hz.person_first_name FIRST_NAME,
11954: hz.person_last_name LAST_NAME
11955: FROM pon_scoring_team_members pntm,
11956: HZ_PARTIES hz,
11957: fnd_user fu
11958: WHERE hz.party_id=fu.person_party_id
11959: AND fu.user_id=pntm.user_id
11960: AND nvl(fu.end_date,sysdate+1) > sysdate
11961: AND fu.person_party_id <> p_sender_id

Line 11975: fnd_user fu

11971: hz.person_first_name FIRST_NAME,
11972: hz.person_last_name LAST_NAME
11973: FROM pon_scoring_team_members pntm,
11974: HZ_PARTIES hz,
11975: fnd_user fu
11976: WHERE hz.party_id=fu.person_party_id
11977: AND fu.user_id=pntm.user_id
11978: AND nvl(fu.end_date,sysdate+1) > sysdate
11979: AND fu.person_party_id <> p_sender_id

Line 12614: l_user_name FND_USER.USER_NAME%TYPE;

12610:
12611: l_itemtype VARCHAR2(7);
12612: l_itemkey VARCHAR2(50);
12613: l_user_id NUMBER;
12614: l_user_name FND_USER.USER_NAME%TYPE;
12615: l_sender_user FND_USER.USER_NAME%TYPE;
12616: l_page_url VARCHAR2(500);
12617: l_wfm_htmlagent VARCHAR2(500);
12618: l_discussion_id NUMBER;

Line 12615: l_sender_user FND_USER.USER_NAME%TYPE;

12611: l_itemtype VARCHAR2(7);
12612: l_itemkey VARCHAR2(50);
12613: l_user_id NUMBER;
12614: l_user_name FND_USER.USER_NAME%TYPE;
12615: l_sender_user FND_USER.USER_NAME%TYPE;
12616: l_page_url VARCHAR2(500);
12617: l_wfm_htmlagent VARCHAR2(500);
12618: l_discussion_id NUMBER;
12619: l_auction_start_date DATE;

Line 12647: FROM FND_USER

12643: USER_NAME
12644: INTO
12645: l_user_id,
12646: l_user_name
12647: FROM FND_USER
12648: WHERE PERSON_PARTY_ID = p_userPartyId
12649: AND NVL(END_DATE, SYSDATE+1) > SYSDATE;
12650:
12651: EXCEPTION

Line 12667: FROM FND_USER

12663: USER_NAME
12664: INTO
12665: l_user_id,
12666: l_user_name
12667: FROM FND_USER
12668: WHERE PERSON_PARTY_ID = p_userPartyId
12669: AND NVL(END_DATE, SYSDATE+1) > SYSDATE
12670: AND ROWNUM=1;
12671:

Line 12680: FROM FND_USER

12676: SELECT
12677: USER_NAME
12678: INTO
12679: l_sender_user
12680: FROM FND_USER
12681: WHERE PERSON_PARTY_ID = p_from_id
12682: AND NVL(END_DATE, SYSDATE+1) > SYSDATE;
12683:
12684: EXCEPTION

Line 12698: FROM FND_USER

12694: SELECT
12695: USER_NAME
12696: INTO
12697: l_sender_user
12698: FROM FND_USER
12699: WHERE PERSON_PARTY_ID = p_from_id
12700: AND NVL(END_DATE, SYSDATE+1) > SYSDATE
12701: AND ROWNUM=1;
12702: