Line 401: p_profile_id IN NUMBER := fnd_profile.VALUE('AMF_DEFAULT_MAIL_PROFILE'),
397:
398: x_request_history_id OUT NOCOPY NUMBER,
399: p_schedule_id IN NUMBER,
400: 401: p_profile_id IN NUMBER := fnd_profile.VALUE('AMF_DEFAULT_MAIL_PROFILE'), 402: p_user_id IN NUMBER := FND_GLOBAL.user_id )
403: IS
404:
405: l_api_name CONSTANT VARCHAR2(30) := 'AMS_FulFill';
Line 520: l_fulfilment := FND_PROFILE.Value('AMS_FULFILL_ENABLE_FLAG');
516: --
517: -- API body
518: --
519: 520: l_fulfilment := FND_PROFILE.Value('AMS_FULFILL_ENABLE_FLAG'); 521: IF( l_fulfilment <> 'N' )
522: THEN
523: -- get all needed data of the schedule
524: OPEN c_csch_det;