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_INTERFACE_PKG dependencies on FND_USER

Line 32: P_BUYER_ID IN FND_USER_ID of creator

28: P_DOCUMENT_TYPE IN 'BUYER_AUCTION' or 'REQUEST_FOR_QUOTE'
29: P_CONTRACT_TYPE IN 'STANDARD' or 'BLANKET'
30: P_ORIGINATION_CODE IN 'REQUISITION' or caller product name
31: P_ORG_ID IN Organization id of creator
32: P_BUYER_ID IN FND_USER_ID of creator
33: P_NEG_STYLE_ID IN negotiation style id
34: P_PO_STYLE_ID IN po style id
35: P_FAIR_OPP_NOTICE_FLAG IN VARCHAR2 DEFAULT NULL
36: P_DOCUMENT_NUMBER IN OUT Created Document number

Line 202: FROM fnd_user,

198: SELECT user_parties.party_id user_party_id,
199: company_parties.party_id company_party_id
200: INTO i_draft_locked_by,
201: i_draft_locked_by_contact_id
202: FROM fnd_user,
203: hz_parties user_parties,
204: hz_parties company_parties,
205: hz_relationships,
206: hz_code_assignments

Line 207: WHERE fnd_user.person_party_id = user_parties.party_id

203: hz_parties user_parties,
204: hz_parties company_parties,
205: hz_relationships,
206: hz_code_assignments
207: WHERE fnd_user.person_party_id = user_parties.party_id
208: AND fnd_user.user_id = p_buyer_id
209: AND hz_relationships.object_id = company_parties.party_id
210: AND hz_relationships.subject_id = user_parties.party_id
211: AND hz_relationships.relationship_type = 'POS_EMPLOYMENT'

Line 208: AND fnd_user.user_id = p_buyer_id

204: hz_parties company_parties,
205: hz_relationships,
206: hz_code_assignments
207: WHERE fnd_user.person_party_id = user_parties.party_id
208: AND fnd_user.user_id = p_buyer_id
209: AND hz_relationships.object_id = company_parties.party_id
210: AND hz_relationships.subject_id = user_parties.party_id
211: AND hz_relationships.relationship_type = 'POS_EMPLOYMENT'
212: AND hz_relationships.relationship_code = 'EMPLOYEE_OF'

Line 709: P_BUYER_ID IN FND_USER_ID of creator

705: P_DOCUMENT_NUMBER IN Document number to add line
706: P_CONTRACT_TYPE IN 'STANDARD' or 'BLANKET'
707: P_ORIGINATION_CODE IN 'REQUISITION' or caller product name
708: P_ORG_ID IN Organization id of creator
709: P_BUYER_ID IN FND_USER_ID of creator
710: P_GROUPING_TYPE IN 'DEFAULT' or 'NONE' grouping
711: P_REQUISITION_HEADER_ID IN Requisition header
712: P_REQUISITION_NUMBER IN Requisition header formatted for display
713: P_REQUISITION_LINE_ID IN Requisition line

Line 805: P_BUYER_ID IN FND_USER_ID of creator

801: P_DOCUMENT_NUMBER IN Document number to add line
802: P_CONTRACT_TYPE IN 'STANDARD' or 'BLANKET'
803: P_ORIGINATION_CODE IN 'REQUISITION' or caller product name
804: P_ORG_ID IN Organization id of creator
805: P_BUYER_ID IN FND_USER_ID of creator
806: P_GROUPING_TYPE IN 'DEFAULT' or 'NONE' grouping
807: P_REQUISITION_HEADER_ID IN Requisition header
808: P_REQUISITION_NUMBER IN Requisition header formatted for display
809: P_REQUISITION_LINE_ID IN Requisition line

Line 2224: P_BUYER_ID IN FND_USER_ID of the creator

2220: P_LINE_NUMBER IN Line number
2221: P_SHIPMENT_NUMBER IN Shipment number
2222: P_PRICE_TYPE IN Price Type
2223: P_MULTIPLIER IN Multiplier
2224: P_BUYER_ID IN FND_USER_ID of the creator
2225: P_PRICE_DIFFERENTIAL_NUMBER OUT Price Differential Number
2226: P_RESULT OUT One of (error, success)
2227: P_ERROR_CODE OUT Internal Error Code
2228: P_ERROR_MESSAGE OUT Displayable error

Line 2333: P_OWNER_NAME OUT FND_USER.USER_NAME of document owner

2329: /*========================================================================
2330: PROCEDURE : Get_Negotiation_Owner
2331: PARAMETERS:
2332: P_DOCUMENT_NUMBER IN Document Id
2333: P_OWNER_NAME OUT FND_USER.USER_NAME of document owner
2334: P_RESULT OUT One of (error, success)
2335: P_ERROR_CODE OUT Internal Error Code
2336: P_ERROR_MESSAGE OUT Displayable error
2337: COMMENT : Returns the owner name for a negotiation document

Line 2348: v_buyer_name fnd_user.user_name%TYPE := NULL;

2344: P_ERROR_CODE OUT NOCOPY VARCHAR2,
2345: P_ERROR_MESSAGE OUT NOCOPY VARCHAR2
2346: )
2347: IS
2348: v_buyer_name fnd_user.user_name%TYPE := NULL;
2349: BEGIN
2350: BEGIN
2351: SELECT u1.user_name,
2352: u2.user_name

Line 2355: FROM fnd_user u1,

2351: SELECT u1.user_name,
2352: u2.user_name
2353: INTO P_OWNER_NAME,
2354: v_buyer_name
2355: FROM fnd_user u1,
2356: fnd_user u2,
2357: pon_auction_headers_all ah
2358: WHERE ah.auction_header_id = P_DOCUMENT_NUMBER
2359: AND ah.trading_partner_contact_id = u1.person_party_id(+)

Line 2356: fnd_user u2,

2352: u2.user_name
2353: INTO P_OWNER_NAME,
2354: v_buyer_name
2355: FROM fnd_user u1,
2356: fnd_user u2,
2357: pon_auction_headers_all ah
2358: WHERE ah.auction_header_id = P_DOCUMENT_NUMBER
2359: AND ah.trading_partner_contact_id = u1.person_party_id(+)
2360: AND ah.buyer_id = u2.user_id(+);

Line 2458: P_BUYER_ID IN FND_USER_ID of the creator

2454: x_return_status OUT FND_API.G_RET_STS_SUCCESS or FND_API.G_RET_STS_ERROR
2455: x_msg_count OUT Internal code for error
2456: x_msg_data OUT Displayable error message
2457: P_DOCUMENT_NUMBER IN Negotiation Document number
2458: P_BUYER_ID IN FND_USER_ID of the creator
2459: COMMENT: Gets distinct vendor_ids and vendor sites
2460: across all the requisition lines that are part of the
2461: negotiation and adds (bulk inserts ) them as invitees. We do not check
2462: for inactive suppliers/ sites in the autocreate process; these