APPS.FUN_WF_COMMON dependencies on FND_USER

Line 957: p_user_id - fnd_user.userid of the person navigating

953: whether or not the user the notification is going to be sent to
954: is a valid user or not.
955: Parameters:
956: IN : p_transaction_id - fun_trx_headers.trx_id
957: p_user_id - fnd_user.userid of the person navigating
958: to the Inbound Trx UI.
959: p_role_name - wf_roles.name of the person the notification
960: is being sent to or forwarded to.
961: p_org_type = 'I' Initiating, 'R' Recipient.

Line 978: FROM fnd_user usr,

974: RETURN VARCHAR2 IS
975:
976: CURSOR c_chk_user IS
977: SELECT 'X'
978: FROM fnd_user usr,
979: wf_local_user_roles role
980: WHERE usr.user_id = p_user_id
981: AND usr.user_name = role.user_name
982: AND role.role_name = 'FUN_ADHOC_RECI_'||p_transaction_id;

Line 987: fnd_user fu,

983: -- Bug No: 5897122
984: CURSOR c_chk_web IS
985: SELECT 'X'
986: FROM hz_parties p,
987: fnd_user fu,
988: fun_trx_headers ftrx,
989: hz_relationships hzr,
990: hz_org_contacts hc,
991: hz_org_contact_roles hcr

Line 1014: fnd_user wf,

1010: CURSOR c_chk_role IS
1011: SELECT 'X'
1012: FROM fun_trx_headers trx,
1013: hz_relationships rel,
1014: fnd_user wf,
1015: hz_org_contacts c,
1016: hz_org_contact_roles cr
1017: WHERE wf.user_name = p_role_name
1018: AND wf.person_party_id = rel.subject_id

Line 1034: l_user_name fnd_user.user_name%TYPE;

1030: AND c.party_relationship_id = rel.relationship_id
1031: AND cr.org_contact_id = c.org_contact_id
1032: AND cr.role_type = 'INTERCOMPANY_CONTACT_FOR';
1033:
1034: l_user_name fnd_user.user_name%TYPE;
1035:
1036: BEGIN
1037: IF p_mode = 'UI'
1038: THEN