DBA Data[Home] [Help]

APPS.CSP_NOTIFICATIONS_ORDER_PKG dependencies on CSP_NOTIFICATION_DETAILS_PKG

Line 168: CSP_Notification_Details_PKG.Insert_Row(

164: WHEN no_data_found THEN
165: l_order_number := null;
166: END;
167:
168: CSP_Notification_Details_PKG.Insert_Row(
169: px_NOTIFICATION_DETAIL_ID => l_notif_detail_id
170: ,p_NOTIFICATION_ID => p_notification_id
171: ,p_INVENTORY_ITEM_ID => p_item_id
172: ,p_AVAILABLE_QUANTITY => p_qty

Line 304: CSP_Notification_Details_PKG.Insert_Row(

300: 'P',
301: l_po_org_id,
302: l_item_attr_rec.unit_price);
303:
304: CSP_Notification_Details_PKG.Insert_Row(
305: px_NOTIFICATION_DETAIL_ID => l_notif_detail_id
306: ,p_NOTIFICATION_ID => p_notification_id
307: ,p_INVENTORY_ITEM_ID => p_item_id
308: ,p_AVAILABLE_QUANTITY => p_qty

Line 378: CSP_Notification_Details_PKG.Insert_Row(

374: p_item_id,
375: p_qty,
376: 3); -- Approved
377:
378: CSP_Notification_Details_PKG.Insert_Row(
379: px_NOTIFICATION_DETAIL_ID => l_notif_detail_id
380: ,p_NOTIFICATION_ID => p_notification_id
381: ,p_INVENTORY_ITEM_ID => p_item_id
382: ,p_AVAILABLE_QUANTITY => p_qty

Line 464: CSP_Notification_Details_PKG.Insert_Row(

460: OPEN repair_to_item_cur;
461: FETCH repair_to_item_cur INTO l_repair_to_item;
462: CLOSE repair_to_item_cur;
463:
464: CSP_Notification_Details_PKG.Insert_Row(
465: px_NOTIFICATION_DETAIL_ID => l_notif_detail_id
466: ,p_NOTIFICATION_ID => p_notification_id
467: ,p_INVENTORY_ITEM_ID => nvl(l_repair_to_item, p_item_id)
468: ,p_AVAILABLE_QUANTITY => p_qty