APPS.PON_AUCTION_INTERFACE_PKG dependencies on FND_USER

Line 23: P_BUYER_ID IN FND_USER_ID of creator

19: P_DOCUMENT_TYPE IN 'BUYER_AUCTION' or 'REQUEST_FOR_QUOTE'
20: P_CONTRACT_TYPE IN 'STANDARD' or 'BLANKET'
21: P_ORIGINATION_CODE IN 'REQUISITION' or caller product name
22: P_ORG_ID IN Organization id of creator
23: P_BUYER_ID IN FND_USER_ID of creator
24: P_NEG_STYLE_ID IN negotiation style id
25: P_PO_STYLE_ID IN po style id
26: P_DOCUMENT_NUMBER OUT Created Document number
27: P_DOCUMENT_URL OUT Additional parameters to PON_AUC_EDIT_DRAFT_B

Line 424: P_BUYER_ID IN FND_USER_ID of creator

420: P_DOCUMENT_NUMBER IN Document number to add line
421: P_CONTRACT_TYPE IN 'STANDARD' or 'BLANKET'
422: P_ORIGINATION_CODE IN 'REQUISITION' or caller product name
423: P_ORG_ID IN Organization id of creator
424: P_BUYER_ID IN FND_USER_ID of creator
425: P_GROUPING_TYPE IN 'DEFAULT' or 'NONE' grouping
426: P_REQUISITION_HEADER_ID IN Requisition header
427: P_REQUISITION_NUMBER IN Requisition header formatted for display
428: P_REQUISITION_LINE_ID IN Requisition line

Line 1403: P_BUYER_ID IN FND_USER_ID of the creator

1399: P_LINE_NUMBER IN Line number
1400: P_SHIPMENT_NUMBER IN Shipment number
1401: P_PRICE_TYPE IN Price Type
1402: P_MULTIPLIER IN Multiplier
1403: P_BUYER_ID IN FND_USER_ID of the creator
1404: P_PRICE_DIFFERENTIAL_NUMBER OUT Price Differential Number
1405:
1406: P_RESULT OUT One of (error, success)
1407: P_ERROR_CODE OUT Internal Error Code

Line 1508: P_OWNER_NAME OUT FND_USER.USER_NAME of document owner

1504: /*========================================================================
1505: PROCEDURE : Get_Negotiation_Owner
1506: PARAMETERS:
1507: P_DOCUMENT_NUMBER IN Document Id
1508: P_OWNER_NAME OUT FND_USER.USER_NAME of document owner
1509: P_RESULT OUT One of (error, success)
1510: P_ERROR_CODE OUT Internal Error Code
1511: P_ERROR_MESSAGE OUT Displayable error
1512: COMMENT : Returns the owner name for a negotiation document

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

1517: P_RESULT OUT NOCOPY NUMBER,
1518: P_ERROR_CODE OUT NOCOPY VARCHAR2,
1519: P_ERROR_MESSAGE OUT NOCOPY VARCHAR2) IS
1520:
1521: v_buyer_name fnd_user.user_name%TYPE := NULL;
1522:
1523: BEGIN
1524: BEGIN
1525: SELECT u1.user_name, u2.user_name

Line 1527: FROM fnd_user u1, fnd_user u2, pon_auction_headers_all ah

1523: BEGIN
1524: BEGIN
1525: SELECT u1.user_name, u2.user_name
1526: INTO P_OWNER_NAME, v_buyer_name
1527: FROM fnd_user u1, fnd_user u2, pon_auction_headers_all ah
1528: WHERE ah.auction_header_id = P_DOCUMENT_NUMBER
1529: AND ah.trading_partner_contact_id = u1.person_party_id(+)
1530: AND ah.buyer_id = u2.user_id(+);
1531: EXCEPTION

Line 1629: P_BUYER_ID IN FND_USER_ID of the creator

1625: x_return_status OUT FND_API.G_RET_STS_SUCCESS or FND_API.G_RET_STS_ERROR
1626: x_msg_count OUT Internal code for error
1627: x_msg_data OUT Displayable error message
1628: P_DOCUMENT_NUMBER IN Negotiation Document number
1629: P_BUYER_ID IN FND_USER_ID of the creator
1630: COMMENT: Gets distinct vendor_ids and vendor sites
1631: across all the requisition lines that are part of the
1632: negotiation and adds (bulk inserts ) them as invitees. We do not check
1633: for inactive suppliers/ sites in the autocreate process; these