[Home] [Help]
1607: instead of the employee id. The requester username is set to the buyer's
1608: username if the requester is not a user. Otherwise, it is set to the requester's
1609: username.
1610: */
1611: SELECT FND.user_id
1612: INTO x_user_id
1613: FROM FND_USER FND
1614: WHERE FND.USER_NAME = x_requester_username
1615: AND FND.START_DATE < sysdate
1609: username.
1610: */
1611: SELECT FND.user_id
1612: INTO x_user_id
1613: FROM FND_USER FND
1614: WHERE FND.USER_NAME = x_requester_username
1615: AND FND.START_DATE < sysdate
1616: AND nvl(FND.END_DATE, sysdate + 1) >= sysdate
1617: AND ROWNUM = 1;
1610: */
1611: SELECT FND.user_id
1612: INTO x_user_id
1613: FROM FND_USER FND
1614: WHERE FND.USER_NAME = x_requester_username
1615: AND FND.START_DATE < sysdate
1616: AND nvl(FND.END_DATE, sysdate + 1) >= sysdate
1617: AND ROWNUM = 1;
1618: EXCEPTION
1622:
1623: BEGIN
1624: select MIN(fr.responsibility_id)
1625: into x_resp_id
1626: from fnd_user_resp_groups fur,
1627: fnd_responsibility_vl fr,
1628: financials_system_parameters fsp
1629: where fur.user_id = x_user_id
1630: and fur.responsibility_application_id in (x_ip_resp_appl_id, x_po_resp_appl_id)
1648: if ((x_resp_id = -1) or (x_resp_id is null)) THEN
1649: BEGIN
1650: select MIN(fr.responsibility_id)
1651: into x_resp_id
1652: from fnd_user_resp_groups fur,
1653: fnd_responsibility_vl fr,
1654: financials_system_parameters fsp
1655: where fur.user_id = x_user_id
1656: and fur.responsibility_id = fr.responsibility_id
1673: if(x_resp_id <> -1) then
1674: BEGIN
1675: SELECT MIN(responsibility_application_id)
1676: INTO x_resp_appl_id
1677: FROM fnd_user_resp_groups fur,
1678: fnd_responsibility_vl fr,
1679: financials_system_parameters fsp
1680: WHERE
1681: fur.responsibility_id = fr.responsibility_id and