DBA Data[Home] [Help]

APPS.WMA_CFM dependencies on FND_PROFILE

Line 141: defaultPrefix := substr(fnd_profile.value('WIP_JOB_PREFIX'), 1, 200);

137: -- default schedule number, it is the value read from profile option 'WIP_JOB_PREFIX'
138: -- appended by a sequence number. We only default it for non flow schedule.
139: -- 3 means unscheduled, 1 means scheduled
140: if ( param.scheduleNumber is null ) then
141: defaultPrefix := substr(fnd_profile.value('WIP_JOB_PREFIX'), 1, 200);
142: scheduleNumber := defaultPrefix || wma_derive.getNextVal('WIP_JOB_NUMBER_S');
143: else
144: scheduleNumber := param.scheduleNumber;
145: end if;

Line 365: -- defaultPrefix := substr(fnd_profile.value('WIP_JOB_PREFIX'), 1, 200);

361: -- default schedule number, it is the value read from profile option 'WIP_JOB_PREFIX'
362: -- appended by a sequence number. We only default it for non flow schedule.
363: -- 3 means unscheduled, 1 means scheduled
364: --if ( lpnParam.scheduledFlag = 3 and lpnParam.scheduleNumber is null ) then
365: -- defaultPrefix := substr(fnd_profile.value('WIP_JOB_PREFIX'), 1, 200);
366: -- scheduleNumber := defaultPrefix || wma_derive.getNextVal('WIP_JOB_NUMBER_S');
367: --else
368: -- scheduleNumber := lpnParam.scheduleNumber;
369: --end if;