DBA Data[Home] [Help]

APPS.WSMPLBJI dependencies on FND_PROFILE

Line 4399: select FND_Profile.value('WIP_JOB_PREFIX') || wip_job_number_s.nextval

4395:
4396: if (v_wlji_job_name(v_index) is null) then
4397:
4398: -- Derive JOB_NAME.
4399: select FND_Profile.value('WIP_JOB_PREFIX') || wip_job_number_s.nextval
4400: into v_wlji_job_name(v_index)
4401: from dual ;
4402:
4403: else

Line 7704: l_del_int_prof_value := fnd_profile.value('WSM_INTERFACE_HISTORY_DAYS');

7700:
7701: -- *** delete marked rows (without error rows) from wlji ***
7702: Begin
7703: -- bug 3126758
7704: l_del_int_prof_value := fnd_profile.value('WSM_INTERFACE_HISTORY_DAYS');
7705:
7706: if l_atleast_one_row_in_mmtt <> 0 then
7707: delete from wsm_starting_lots_interface
7708: where header_id IN