APPS.CSF_RESOURCE_PUB dependencies on FND_GLOBAL

Line 1574: * (FND_GLOBAL.USER_ID).

1570: /**
1571: * Returns the ID of the Resource tied to the given User (FND User).
1572: *
1573: * If no User is passed in, then it will take the User who has logged in
1574: * (FND_GLOBAL.USER_ID).
1575: *
1576: * @param p_user_id Identifier to the User desired (Optional)
1577: * @returns Resource ID (NUMBER)
1578: */

Line 1584: WHERE user_id = NVL(p_user_id, fnd_global.user_id);

1580: RETURN NUMBER IS
1581: CURSOR c_resource IS
1582: SELECT resource_id
1583: FROM jtf_rs_resource_extns
1584: WHERE user_id = NVL(p_user_id, fnd_global.user_id);
1585: l_id NUMBER := NULL;
1586: BEGIN
1587: OPEN c_resource;
1588: FETCH c_resource INTO l_id;

Line 1598: * (FND_GLOBAL.USER_ID).

1594: /**
1595: * Returns the Resource Type of the Resource tied to the given user. (FND User)
1596: *
1597: * If no User is passed in, then it will take the User who has logged in
1598: * (FND_GLOBAL.USER_ID).
1599: *
1600: * @param p_user_id Identifier to the User desired (Optional)
1601: * @returns Resource Type (VARCHAR2)
1602: */

Line 1608: WHERE user_id = NVL(p_user_id, fnd_global.user_id);

1604: RETURN VARCHAR2 IS
1605: CURSOR c_resource_type IS
1606: SELECT category
1607: FROM jtf_rs_resource_extns
1608: WHERE user_id = NVL(p_user_id, fnd_global.user_id);
1609: l_type jtf_rs_resource_extns.category%TYPE;
1610: BEGIN
1611: OPEN c_resource_type;
1612: FETCH c_resource_type INTO l_type;