APPS.CSP_PLANNER_NOTIFICATIONS dependencies on CSP_NOTIFICATION_DETAILS

Line 1211: FROM csp_notification_details cnd

1207:
1208: SELECT nvl(SUM(DECODE(cnd.source_type, 'EXCESS', cnd.available_quantity, null)), 0) AS Excess_Qty,
1209: nvl(SUM(DECODE(cnd.source_type, 'REPAIR', cnd.available_quantity, null)), 0) AS Repair_Qty
1210: INTO l_total_excess, l_total_repair
1211: FROM csp_notification_details cnd
1212: WHERE notification_id = onc.notification_id;
1213:
1214: IF (onc.notification_type = 'IO') THEN
1215: IF (((l_total_excess * nvl(l_item_cost,0)) <= nvl(l_business_rule_rec.IO_Excess_Value,0)) AND

Line 1269: DELETE FROM csp_notification_Details

1265: set status = 5
1266: where notification_id = onc.notification_id;
1267:
1268: IF ((l_total_excess > 0) OR (l_total_repair > 0)) THEN
1269: DELETE FROM csp_notification_Details
1270: WHERE notification_id = onc.notification_id;
1271: END IF;
1272: END IF;
1273: ELSE

Line 1337: DELETE FROM csp_notification_Details

1333: set status = 5
1334: where notification_id = onc.notification_id;
1335:
1336: IF ((l_total_excess > 0) OR (l_total_repair > 0)) THEN
1337: DELETE FROM csp_notification_Details
1338: WHERE notification_id = onc.notification_id;
1339: END IF;
1340: END IF;
1341: ELSE

Line 1386: DELETE FROM csp_notification_Details

1382: set status = 5
1383: where notification_id = onc.notification_id;
1384:
1385: IF ((l_total_excess > 0) OR (l_total_repair > 0)) THEN
1386: DELETE FROM csp_notification_Details
1387: WHERE notification_id = onc.notification_id;
1388: END IF;
1389: END IF;
1390: ELSE

Line 2628: DELETE FROM csp_notification_Details

2624: END;
2625:
2626: PROCEDURE Cleanup_Notifications(p_organization_id NUMBER) IS
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)

Line 2649: CSP_Notification_Details_PKG.Insert_Row(

2645: l_notif_detail_id NUMBER;
2646: BEGIN
2647:
2648: l_notif_detail_id := NULL;
2649: CSP_Notification_Details_PKG.Insert_Row(
2650: px_NOTIFICATION_DETAIL_ID => l_notif_detail_id
2651: ,p_NOTIFICATION_ID => p_notification_id
2652: ,p_INVENTORY_ITEM_ID => p_parts_rec.inventory_item_id
2653: ,p_AVAILABLE_QUANTITY => p_parts_rec.quantity