APPS.JTF_RS_GRP_SUM_PUB dependencies on FND_PROFILE

Line 149: l_user_id NUMBER := nvl(FND_PROFILE.VALUE('USER_ID'),-1);

145: r_get_child_group get_child_group%rowtype;
146:
147: l_date_format varchar2(15) := p_date_format ;
148: l_index NUMBER := 0;
149: l_user_id NUMBER := nvl(FND_PROFILE.VALUE('USER_ID'),-1);
150: l_group_name VARCHAR2(70) := UPPER(p_group_name)||'%';
151: l_group_number VARCHAR2(40) := p_group_number ||'%';
152: l_group_id NUMBER := p_group_id;
153: l_group_desc VARCHAR2(250) := UPPER(p_group_desc) || '%';

Line 178: l_user_id := nvl(FND_PROFILE.VALUE('USER_ID'),-1);

174: l_range_high := p_range_high + 1;
175:
176: IF (p_called_from = 'DEFAULT' )THEN
177: IF p_user_id is null THEN
178: l_user_id := nvl(FND_PROFILE.VALUE('USER_ID'),-1);
179: ELSE l_user_id := p_user_id;
180: END IF;
181: END IF;
182: IF (p_called_from = 'AS') THEN