APPS.CSP_PLANNER_NOTIFICATIONS dependencies on CSP_NOTIFICATIONS_PKG

Line 516: csp_notifications_pkg.insert_row(

512: -- if source type is 1-Inventory, internal purchase req
513: IF (p_notif_for_io = 1) THEN
514: -- create notifications for IO
515: l_notification_id := null;
516: csp_notifications_pkg.insert_row(
517: px_notification_id => l_notification_id,
518: p_created_by => l_user_id,
519: p_creation_date => sysdate,
520: p_last_updated_by => l_user_id,

Line 590: csp_notifications_pkg.insert_row(

586: -- if source type is 2-Supplier, external purchase req.
587: IF (p_notif_for_po = 1) THEN
588: -- create notifications for PO
589: l_notification_id := null;
590: csp_notifications_pkg.insert_row(
591: px_notification_id => l_notification_id,
592: p_created_by => l_user_id,
593: p_creation_date => sysdate,
594: p_last_updated_by => l_user_id,

Line 665: csp_notifications_pkg.insert_row(

661: END IF;
662: ELSE
663: -- no source type defined, create a notification with source missing.
664: l_notification_id := null;
665: csp_notifications_pkg.insert_row(
666: px_notification_id => l_notification_id,
667: p_created_by => l_user_id,
668: p_creation_date => sysdate,
669: p_last_updated_by => l_user_id,

Line 724: csp_notifications_pkg.insert_row(

720:
721: IF (p_notif_for_wip = 1) THEN
722: -- create notifications for make items
723: l_notification_id := null;
724: csp_notifications_pkg.insert_row(
725: px_notification_id => l_notification_id,
726: p_created_by => l_user_id,
727: p_creation_date => sysdate,
728: p_last_updated_by => l_user_id,

Line 917: csp_notifications_pkg.insert_row(

913: END;
914:
915: IF ((nvl(l_item_cost,0) * l_EOO_qty) > nvl(l_min_Value, 0)) THEN
916: l_notification_id := null;
917: csp_notifications_pkg.insert_row(
918: px_notification_id => l_notification_id,
919: p_created_by => l_user_id,
920: p_creation_date => sysdate,
921: p_last_updated_by => l_user_id,