APPS.PON_EVAL_TEAM_UTIL_PVT dependencies on FND_USER

Line 21: FROM fnd_user

17: BEGIN
18:
19: SELECT person_party_id
20: INTO l_party_id
21: FROM fnd_user
22: WHERE user_id = p_user_id;
23:
24: RETURN pon_locale_pkg.get_party_display_name(l_party_id);
25:

Line 110: fnd_user fu

106: pmets.section_id
107: FROM pon_mng_eval_team_members pmetm,
108: pon_mng_eval_team_sections pmets,
109: pon_bid_headers pbh,
110: fnd_user fu
111: WHERE pmetm.auction_header_id = p_auction_header_id
112: AND pmets.auction_header_id = p_auction_header_id
113: AND pmetm.team_id = pmets.team_id
114: AND (pmetm.user_id, pmets.section_id) NOT IN

Line 167: fnd_user fu

163: pets.section_id
164: FROM pon_evaluation_team_members petm,
165: pon_evaluation_team_sections pets,
166: pon_bid_headers pbh,
167: fnd_user fu
168: WHERE petm.auction_header_id = p_auction_header_id
169: AND pets.auction_header_id = p_auction_header_id
170: AND petm.team_id = pets.team_id
171: AND (petm.user_id, pets.section_id) NOT IN

Line 412: l_member_user_name fnd_user.user_name%TYPE;

408: l_auction_title pon_auction_headers_all.auction_title%TYPE;
409: l_preparer_tp_name hz_parties.party_name%TYPE;
410: l_msg_suffix pon_auc_doctypes.message_suffix%TYPE;
411: l_doc_type VARCHAR2(50);
412: l_member_user_name fnd_user.user_name%TYPE;
413: l_et_update_subject VARCHAR2(2000);
414: l_neg_summary_url VARCHAR2(2000);
415:
416: l_sequence NUMBER;

Line 435: FROM fnd_user

431: l_doc_type := pon_auction_pkg.getMessage('PON_AUCTION', '_' || l_msg_suffix);
432:
433: SELECT user_name
434: INTO l_member_user_name
435: FROM fnd_user
436: WHERE user_id = p_member_user_id;
437:
438: fnd_message.set_name('PON', 'PON_SM_ET_UPDATE_SUB');
439: fnd_message.set_token('DOC_TYPE', l_doc_type);

Line 652: l_member_user_id fnd_user.user_id%TYPE;

648: l_itemtype VARCHAR2(8);
649: l_itemkey VARCHAR2(240);
650:
651: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
652: l_member_user_id fnd_user.user_id%TYPE;
653: l_doc_type VARCHAR2(50);
654: l_doc_number pon_auction_headers_all.document_number%TYPE;
655: l_neg_summary_url VARCHAR2(2000);
656: l_notification_id NUMBER;

Line 925: fnd_user fue,

921: fus.user_name scorer_user_name,
922: pon_locale_pkg.get_party_display_name(pbh.evaluator_id)
923: AS evaluator_name
924: FROM pon_bid_headers pbh,
925: fnd_user fue,
926: pon_evaluation_team_members petm,
927: pon_evaluation_team_sections pets,
928: pon_scoring_team_members pstm,
929: pon_scoring_team_sections psts,

Line 930: fnd_user fus

926: pon_evaluation_team_members petm,
927: pon_evaluation_team_sections pets,
928: pon_scoring_team_members pstm,
929: pon_scoring_team_sections psts,
930: fnd_user fus
931: WHERE pbh.bid_number = p_bid_number
932: AND pbh.evaluation_flag = 'Y'
933: AND pbh.evaluator_id = fue.person_party_id
934: AND petm.user_id = fue.user_id

Line 1122: l_scorer_user_name fnd_user.user_name%TYPE;

1118: l_neg_summary_url VARCHAR2(2000);
1119: l_doc_type VARCHAR2(50);
1120: l_doc_number pon_auction_headers_all.document_number%TYPE;
1121: l_auction_title pon_auction_headers_all.auction_title%TYPE;
1122: l_scorer_user_name fnd_user.user_name%TYPE;
1123: l_notification_id NUMBER;
1124:
1125: l_language_code VARCHAR2(3);
1126: l_document VARCHAR2(32000);