APPS.MRP_SELECT_ALL_FOR_RELEASE_PUB dependencies on FND_PROFILE

Line 170: l_user_id := FND_PROFILE.VALUE('USER_ID');

166: BEGIN
167:
168: l_no_rep_rows := p_no_rep_rows;
169: l_no_rec_rows := p_no_rec_rows;
170: l_user_id := FND_PROFILE.VALUE('USER_ID');
171: begin
172: select nvl(ORDERS_RELEASE_CONFIGS,'N')
173: into release_configs
174: from mrp_workbench_display_options

Line 573: l_wip_job_prefix := FND_PROFILE.VALUE('WIP_JOB_PREFIX');

569:
570: BEGIN
571:
572:
573: l_wip_job_prefix := FND_PROFILE.VALUE('WIP_JOB_PREFIX');
574: l_user_id := FND_PROFILE.VALUE('USER_ID');
575: --l_wip_seq := 'to_char(wip_job_number_s.nextval)';
576:
577: l_employee_id := p_employee_id;

Line 574: l_user_id := FND_PROFILE.VALUE('USER_ID');

570: BEGIN
571:
572:
573: l_wip_job_prefix := FND_PROFILE.VALUE('WIP_JOB_PREFIX');
574: l_user_id := FND_PROFILE.VALUE('USER_ID');
575: --l_wip_seq := 'to_char(wip_job_number_s.nextval)';
576:
577: l_employee_id := p_employee_id;
578: l_demand_class := p_demand_class;

Line 1259: temp_Char := FND_PROFILE.VALUE('MRP_RETAIN_DATES_WTIN_CAL_BOUNDARY');

1255: END IF;
1256:
1257: IF MRP_CALENDAR_RET_DATES = 0 THEN
1258: --dbms_output.put_line('Getting value of profile');
1259: temp_Char := FND_PROFILE.VALUE('MRP_RETAIN_DATES_WTIN_CAL_BOUNDARY');
1260: IF temp_Char = 'Y' THEN
1261: MRP_CALENDAR_RET_DATES := 1;
1262: ELSE
1263: MRP_CALENDAR_RET_DATES := 2;

Line 1657: l_wip_job_prefix := FND_PROFILE.VALUE('WIP_JOB_PREFIX');

1653: l_session_id NUMBER;
1654: count1 NUMBER;
1655: BEGIN
1656:
1657: l_wip_job_prefix := FND_PROFILE.VALUE('WIP_JOB_PREFIX');
1658:
1659: select userenv('SESSIONID') into l_session_id from dual;
1660:
1661: update mrp_recommendations mr set

Line 1687: l_wip_job_prefix := FND_PROFILE.VALUE('WIP_JOB_PREFIX');

1683: l_wip_job_prefix VARCHAR2(240);
1684:
1685: BEGIN
1686:
1687: l_wip_job_prefix := FND_PROFILE.VALUE('WIP_JOB_PREFIX');
1688:
1689: update mrp_recommendations mru set implement_job_name = l_wip_job_prefix||to_char(wip_job_number_s.nextval)
1690: where 1 < (select count(*)
1691: FROM mrp_recommendations mr