APPS.CSP_PLANNER_NOTIFICATIONS dependencies on CSP_NOTIFICATIONS

Line 234: FROM csp_notifications

230: inventory_item_id,
231: notification_type,
232: quantity,
233: need_date
234: FROM csp_notifications
235: WHERE organization_id = p_organization_id;
236:
237: CURSOR supercess_items_cur(p_item_id NUMBER) IS
238: SELECT inventory_item_id

Line 463: FROM csp_notifications

459: -- check if item is on a suppressed notification
460: begin
461: SELECT count(inventory_item_id)
462: INTO l_count
463: FROM csp_notifications
464: WHERE organization_id = p_organization_id
465: AND inventory_item_id = l_item_attr_rec.item_id
466: AND nvl(suppress_end_date, sysdate) >= sysdate;
467: exception

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 854: FROM csp_notifications

850: l_count := 0;
851: begin
852: SELECT count(inventory_item_id)
853: INTO l_count
854: FROM csp_notifications
855: WHERE organization_id = p_organization_id
856: AND inventory_item_id = l_item_id
857: AND nvl(suppress_end_date, sysdate) >= sysdate;
858: exception

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,

Line 1264: update csp_notifications

1260:
1261: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1262: RAISE FND_API.G_EXC_ERROR;
1263: ELSE
1264: update csp_notifications
1265: set status = 5
1266: where notification_id = onc.notification_id;
1267:
1268: IF ((l_total_excess > 0) OR (l_total_repair > 0)) THEN

Line 1332: update csp_notifications

1328:
1329: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1330: RAISE FND_API.G_EXC_ERROR;
1331: ELSE
1332: update csp_notifications
1333: set status = 5
1334: where notification_id = onc.notification_id;
1335:
1336: IF ((l_total_excess > 0) OR (l_total_repair > 0)) THEN

Line 1381: update csp_notifications

1377: , x_ret_mesg => l_msg_data);
1378: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1379: RAISE FND_API.G_EXC_ERROR;
1380: ELSE
1381: update csp_notifications
1382: set status = 5
1383: where notification_id = onc.notification_id;
1384:
1385: IF ((l_total_excess > 0) OR (l_total_repair > 0)) THEN

Line 2631: FROM csp_notifications

2627: BEGIN
2628: DELETE FROM csp_notification_Details
2629: WHERE notification_id in
2630: (SELECT notification_id
2631: FROM csp_notifications
2632: WHERE trunc(nvl(suppress_end_date, sysdate)) <= trunc(sysdate)
2633: AND organization_id = p_organization_id);
2634:
2635: DELETE FROM csp_notifications

Line 2635: DELETE FROM csp_notifications

2631: FROM csp_notifications
2632: WHERE trunc(nvl(suppress_end_date, sysdate)) <= trunc(sysdate)
2633: AND organization_id = p_organization_id);
2634:
2635: DELETE FROM csp_notifications
2636: WHERE trunc(nvl(suppress_end_date, sysdate)) <= trunc(sysdate)
2637: AND organization_id = p_organization_id;
2638: END;
2639: