[Home] [Help]
41: G_SESSION_LANG := USERENV('LANG');
42: BEGIN
43: SELECT party_id
44: INTO G_PARTY_ID
45: FROM ego_user_v
46: WHERE USER_ID = G_USER_ID;
47: EXCEPTION
48: WHEN NO_DATA_FOUND THEN
49: SELECT party_id, user_id
47: EXCEPTION
48: WHEN NO_DATA_FOUND THEN
49: SELECT party_id, user_id
50: INTO G_PARTY_ID, G_USER_ID
51: FROM ego_user_v
52: WHERE USER_NAME = FND_GLOBAL.USER_NAME;
53: END;
54: END set_globals;
55: