340: IF l_above > 0 THEN
341: l_notification_id := null;
342: csp_notifications_pkg.insert_row(
343: px_notification_id => l_notification_id,
344: p_created_by => fnd_global.user_id,
345: p_creation_date => sysdate,
346: p_last_updated_by => fnd_global.user_id,
347: p_last_update_date => sysdate,
348: p_last_update_login => null,
342: csp_notifications_pkg.insert_row(
343: px_notification_id => l_notification_id,
344: p_created_by => fnd_global.user_id,
345: p_creation_date => sysdate,
346: p_last_updated_by => fnd_global.user_id,
347: p_last_update_date => sysdate,
348: p_last_update_login => null,
349: p_planner_code => l_planner_code,
350: p_parts_loop_id => cr.parts_loop_id,
374: IF l_below > 0 THEN
375: l_notification_id := null;
376: csp_notifications_pkg.insert_row(
377: px_notification_id => l_notification_id,
378: p_created_by => fnd_global.user_id,
379: p_creation_date => sysdate,
380: p_last_updated_by => fnd_global.user_id,
381: p_last_update_date => sysdate,
382: p_last_update_login => null,
376: csp_notifications_pkg.insert_row(
377: px_notification_id => l_notification_id,
378: p_created_by => fnd_global.user_id,
379: p_creation_date => sysdate,
380: p_last_updated_by => fnd_global.user_id,
381: p_last_update_date => sysdate,
382: p_last_update_login => null,
383: p_planner_code => l_planner_code,
384: p_parts_loop_id => cr.parts_loop_id,
408: IF l_not_enough_good_parts > 0 THEN
409: l_notification_id := null;
410: csp_notifications_pkg.insert_row(
411: px_notification_id => l_notification_id,
412: p_created_by => fnd_global.user_id,
413: p_creation_date => sysdate,
414: p_last_updated_by => fnd_global.user_id,
415: p_last_update_date => sysdate,
416: p_last_update_login => null,
410: csp_notifications_pkg.insert_row(
411: px_notification_id => l_notification_id,
412: p_created_by => fnd_global.user_id,
413: p_creation_date => sysdate,
414: p_last_updated_by => fnd_global.user_id,
415: p_last_update_date => sysdate,
416: p_last_update_login => null,
417: p_planner_code => l_planner_code,
418: p_parts_loop_id => cr.parts_loop_id,