APPS.MRP_SELECT_ALL_FOR_RELEASE_PUB dependencies on WIP_JOB_NUMBER_S

Line 575: --l_wip_seq := 'to_char(wip_job_number_s.nextval)';

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;
579: l_def_job_class := p_def_job_class;

Line 1662: implement_job_name = l_wip_job_prefix||to_char(wip_job_number_s.nextval)

1658:
1659: select userenv('SESSIONID') into l_session_id from dual;
1660:
1661: update mrp_recommendations mr set
1662: implement_job_name = l_wip_job_prefix||to_char(wip_job_number_s.nextval)
1663: where implement_job_name=to_char(l_session_id)
1664: and mr.implement_as =3
1665: --and mr.organization_id=arg_org_id /*5735558*/
1666: and mr.compile_designator=arg_compile_designator;

Line 1672: job names with the wip job number sequence.

1668: END;
1669:
1670: /***============= Bug 4990499 chg begins ===========
1671: This procedure updates the records with duplicate
1672: job names with the wip job number sequence.
1673: ******/
1674: /* Bug 5735558. This procedure will no longer be called. It is replaced
1675: by call to Update_Job_Name which will take care of the duplicate job name.
1676: */

Line 1689: update mrp_recommendations mru set implement_job_name = l_wip_job_prefix||to_char(wip_job_number_s.nextval)

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
1692: WHERE mr.release_errors is NULL
1693: AND mr.implement_quantity > 0