DBA Data[Home] [Help]

APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on FND_USER

Line 151: -- Get sysdate, fnd user AND login

147: 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';
148:
149:
150: --
151: -- Get sysdate, fnd user AND login
152: --
153: PROCEDURE Get_Who(
154: x_sysdate OUT NOCOPY DATE,
155: x_user_id OUT NOCOPY NUMBER,

Line 3357: FROM FND_USER fu

3353: AS
3354:
3355: Cursor Get_Emp_User IS
3356: SELECT P.FULL_NAME
3357: FROM FND_USER fu
3358: ,PER_ALL_PEOPLE_F P
3359: WHERE sysdate BETWEEN nvl(fu.start_date, sysdate-1)
3360: AND nvl(fu.end_date, sysdate+1)
3361: AND fu.employee_id = P.person_id

Line 3369: ,fnd_user fu

3365:
3366: Cursor Get_B2C_User IS
3367: SELECT hp.party_name
3368: FROM hz_parties hp
3369: ,fnd_user fu
3370: WHERE hp.party_type = 'PERSON'
3371: AND sysdate BETWEEN nvl(fu.start_date, sysdate-1)
3372: AND nvl(fu.end_date, sysdate+1)
3373: AND fu.customer_id = hp.party_id

Line 3382: ,fnd_user fu

3378: Cursor Get_B2B_User IS
3379: SELECT hp.party_name
3380: from hz_parties hp
3381: ,hz_relationships hr
3382: ,fnd_user fu
3383: WHERE hr.party_id = fu.customer_id
3384: AND hr.subject_id = hp.party_id
3385: AND hr.relationship_code in ('EMPLOYEE_OF', 'CONTACT_OF')
3386: AND hp.party_type = 'PERSON'

Line 3395: CURSOR GET_FND_USER IS

3391: AND fu.customer_id is not null
3392: AND fu.employee_id is null
3393: AND fu.User_id = V_USER_ID;
3394:
3395: CURSOR GET_FND_USER IS
3396: SELECT fu.user_name
3397: FROM FND_USER fu
3398: WHERE fu.User_id = V_USER_ID;
3399:

Line 3397: FROM FND_USER fu

3393: AND fu.User_id = V_USER_ID;
3394:
3395: CURSOR GET_FND_USER IS
3396: SELECT fu.user_name
3397: FROM FND_USER fu
3398: WHERE fu.User_id = V_USER_ID;
3399:
3400: l_full_name VARCHAR2(200) := null;
3401: BEGIN

Line 3417: OPEN GET_FND_USER;

3413: FETCH GET_B2B_USER INTO l_full_name;
3414: CLOSE GET_B2B_USER;
3415:
3416: IF l_full_name IS NULL THEN
3417: OPEN GET_FND_USER;
3418: FETCH GET_FND_USER INTO l_full_name;
3419: CLOSE GET_FND_USER;
3420: END IF;
3421: END IF;

Line 3418: FETCH GET_FND_USER INTO l_full_name;

3414: CLOSE GET_B2B_USER;
3415:
3416: IF l_full_name IS NULL THEN
3417: OPEN GET_FND_USER;
3418: FETCH GET_FND_USER INTO l_full_name;
3419: CLOSE GET_FND_USER;
3420: END IF;
3421: END IF;
3422:

Line 3419: CLOSE GET_FND_USER;

3415:
3416: IF l_full_name IS NULL THEN
3417: OPEN GET_FND_USER;
3418: FETCH GET_FND_USER INTO l_full_name;
3419: CLOSE GET_FND_USER;
3420: END IF;
3421: END IF;
3422:
3423: END IF;