DBA Data[Home] [Help]

APPS.WSMPLBJI dependencies on FND_PROFILE

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

4401:
4402: if (v_wlji_job_name(v_index) is null) then
4403:
4404: -- Derive JOB_NAME.
4405: select FND_Profile.value('WIP_JOB_PREFIX') || wip_job_number_s.nextval
4406: into v_wlji_job_name(v_index)
4407: from dual ;
4408:
4409: else

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

7706:
7707: -- *** delete marked rows (without error rows) from wlji ***
7708: Begin
7709: -- bug 3126758
7710: l_del_int_prof_value := fnd_profile.value('WSM_INTERFACE_HISTORY_DAYS');
7711:
7712: if l_atleast_one_row_in_mmtt <> 0 then
7713: delete from wsm_starting_lots_interface
7714: where header_id IN