DBA Data[Home] [Help]

APPS.PO_INQ_SV dependencies on FND_USER

Line 1992: ( l_user_name IN fnd_user.user_name%TYPE,

1988: * Effects: Get vendor real name based on log on name
1989: * Returns: x_vendor_name
1990: */
1991: PROCEDURE get_vendor_name
1992: ( l_user_name IN fnd_user.user_name%TYPE,
1993: x_vendor_name OUT NOCOPY hz_parties.party_name%TYPE
1994: )
1995: IS
1996:

Line 2001: -- from fnd_user.user_name

1997: BEGIN
1998:
1999: --SQL What: Query vendor name based on log on name
2000: --SQL Why: Get vendor_name from hz_parties via hz_relationships starting
2001: -- from fnd_user.user_name
2002: /* Patch 12345138 Modified the query because the query based on old
2003: datamodel was not fetching any records*/
2004: SELECT ap.vendor_name
2005: INTO x_vendor_name

Line 2008: fnd_user fu,

2004: SELECT ap.vendor_name
2005: INTO x_vendor_name
2006: FROM hz_relationships hzr,
2007: hz_parties hp,
2008: fnd_user fu,
2009: ap_suppliers ap,
2010: hz_party_usg_assignments hpua
2011: WHERE
2012: hzr.object_id = ap.party_id

Line 2107: l_user_name FND_USER.USER_NAME%TYPE;

2103: ---------------------------------------------------------------------------
2104: FUNCTION get_party_vendor_name (p_user_id IN NUMBER)
2105: RETURN VARCHAR2
2106: IS
2107: l_user_name FND_USER.USER_NAME%TYPE;
2108: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;
2109: l_vendor_name HZ_PARTIES.PARTY_NAME%TYPE;
2110: l_result VARCHAR2(800); --approx. length to hold "party name(vendor name)"
2111: l_progress VARCHAR2(3) := '000';

Line 2120: FROM fnd_user fu,hz_parties hp

2116: -- SQL What: Retrieve user_name and party_name based on user_id
2117: -- SQL Why: Need to construct output and to further retrieve vendor_name
2118: SELECT fu.user_name, hp.party_name
2119: INTO l_user_name, l_party_name
2120: FROM fnd_user fu,hz_parties hp
2121: WHERE hp.party_id = fu.customer_id
2122: AND fu.user_id = p_user_id;
2123:
2124: l_progress := '020';

Line 2188: -- email address stored in FND_USER

2184: --IN:
2185: -- p_user_id: user_id of the supplier party
2186: --Returns:
2187: -- email address stored in HZ_PARTIES; if that is not available, return
2188: -- email address stored in FND_USER
2189: --Testing:
2190: --End of Comments
2191: ---------------------------------------------------------------------------
2192: FUNCTION get_vendor_email (p_user_id IN NUMBER)

Line 2195: l_fu_email_address FND_USER.EMAIL_ADDRESS%TYPE; -- Varchar2(240)

2191: ---------------------------------------------------------------------------
2192: FUNCTION get_vendor_email (p_user_id IN NUMBER)
2193: RETURN VARCHAR2
2194: IS
2195: l_fu_email_address FND_USER.EMAIL_ADDRESS%TYPE; -- Varchar2(240)
2196: l_hp_email_address HZ_PARTIES.EMAIL_ADDRESS%TYPE; -- Varchar2(2000)
2197: l_result HZ_PARTIES.EMAIL_ADDRESS%TYPE;
2198: l_progress VARCHAR2(3) := '000';
2199: l_log_head VARCHAR2(100) := g_log_head||'get_vendor_email';

Line 2207: FROM fnd_user fu,hz_parties hp

2203: -- SQL What: Retrieve email_address based on user_id
2204: -- SQL Why: Need to return email_address
2205: SELECT fu.email_address, hp.email_address
2206: INTO l_fu_email_address, l_hp_email_address
2207: FROM fnd_user fu,hz_parties hp
2208: WHERE hp.party_id = fu.customer_id
2209: AND fu.user_id = p_user_id;
2210:
2211: l_progress := '020';