DBA Data[Home] [Help]

APPS.MSC_ATP_PUB dependencies on MSC_CALENDAR

Line 1478: x_atp_rec.receiving_cal_code(j) := MSC_CALENDAR.FOC;

1474: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Setting the delivery lead time to 0');
1475: END IF;
1476: l_delivery_lead_time := 0;
1477: --bug 3979115:
1478: x_atp_rec.receiving_cal_code(j) := MSC_CALENDAR.FOC;
1479: x_atp_rec.shipping_cal_code(j) := MSC_CALENDAR.FOC;
1480: x_atp_rec.intransit_cal_code(j) := MSC_CALENDAR.FOC;
1481: end if;
1482: -- end 2748041

Line 1479: x_atp_rec.shipping_cal_code(j) := MSC_CALENDAR.FOC;

1475: END IF;
1476: l_delivery_lead_time := 0;
1477: --bug 3979115:
1478: x_atp_rec.receiving_cal_code(j) := MSC_CALENDAR.FOC;
1479: x_atp_rec.shipping_cal_code(j) := MSC_CALENDAR.FOC;
1480: x_atp_rec.intransit_cal_code(j) := MSC_CALENDAR.FOC;
1481: end if;
1482: -- end 2748041
1483:

Line 1480: x_atp_rec.intransit_cal_code(j) := MSC_CALENDAR.FOC;

1476: l_delivery_lead_time := 0;
1477: --bug 3979115:
1478: x_atp_rec.receiving_cal_code(j) := MSC_CALENDAR.FOC;
1479: x_atp_rec.shipping_cal_code(j) := MSC_CALENDAR.FOC;
1480: x_atp_rec.intransit_cal_code(j) := MSC_CALENDAR.FOC;
1481: end if;
1482: -- end 2748041
1483:
1484: /* Bug 3335268 - Moved the assignments out of the "IF" block as these variables

Line 1710: x_atp_rec.ship_method(j), MSC_CALENDAR.VIC);

1706: --as we do not calculate these values for line marked for unscheduling
1707: OR (x_atp_rec.quantity_ordered(j-1) = 0)
1708: OR (x_atp_rec.ship_method(j)<>x_atp_rec.ship_method(j-1)) THEN
1709: x_atp_rec.intransit_cal_code(j) := MSC_SATP_FUNC.src_get_calendar_code(null, null, null,
1710: x_atp_rec.ship_method(j), MSC_CALENDAR.VIC);
1711: ELSE
1712: x_atp_rec.intransit_cal_code(j) := x_atp_rec.intransit_cal_code(j-1);
1713: IF PG_DEBUG in ('Y', 'C') THEN
1714: msc_sch_wb.atp_debug('Call_ATP_NO_Commit: ' || 'Parameters have not changed for VIC');

Line 1719: x_atp_rec.intransit_cal_code(j) := MSC_CALENDAR.FOC;

1715: END IF;
1716: END IF;
1717: ELSE
1718: -- Bug 3647208
1719: x_atp_rec.intransit_cal_code(j) := MSC_CALENDAR.FOC;
1720: END IF;
1721:
1722:
1723: -- Bug 3449812 - base receiving calendar on internal_org_id if available

Line 1746: x_atp_rec.ship_method(j), MSC_CALENDAR.ORC);

1742: ELSIF (x_atp_rec.internal_org_id(j) IS NOT NULL) OR
1743: (l_to_organization_id IS NOT NULL AND l_customer_id IS NULL AND l_customer_site_id IS NULL) THEN
1744: x_atp_rec.receiving_cal_code(j) := MSC_SATP_FUNC.src_get_calendar_code(null, null,
1745: Nvl(x_atp_rec.internal_org_id(j),l_to_organization_id),
1746: x_atp_rec.ship_method(j), MSC_CALENDAR.ORC);
1747: -- Bug 3449812 - handle case where both org and customer are null
1748: ELSIF l_customer_site_id IS NOT NULL AND MSC_ATP_PVT.G_USE_SHIP_REC_CAL='Y' THEN
1749: -- Bug 3647208 - Call CRC only if using ship/rec cal
1750: x_atp_rec.receiving_cal_code(j) := MSC_SATP_FUNC.src_get_calendar_code(l_customer_id, l_customer_site_id, null,

Line 1751: x_atp_rec.ship_method(j), MSC_CALENDAR.CRC);

1747: -- Bug 3449812 - handle case where both org and customer are null
1748: ELSIF l_customer_site_id IS NOT NULL AND MSC_ATP_PVT.G_USE_SHIP_REC_CAL='Y' THEN
1749: -- Bug 3647208 - Call CRC only if using ship/rec cal
1750: x_atp_rec.receiving_cal_code(j) := MSC_SATP_FUNC.src_get_calendar_code(l_customer_id, l_customer_site_id, null,
1751: x_atp_rec.ship_method(j), MSC_CALENDAR.CRC);
1752: ELSE
1753: x_atp_rec.receiving_cal_code(j) := MSC_CALENDAR.FOC;
1754: END IF;
1755:

Line 1753: x_atp_rec.receiving_cal_code(j) := MSC_CALENDAR.FOC;

1749: -- Bug 3647208 - Call CRC only if using ship/rec cal
1750: x_atp_rec.receiving_cal_code(j) := MSC_SATP_FUNC.src_get_calendar_code(l_customer_id, l_customer_site_id, null,
1751: x_atp_rec.ship_method(j), MSC_CALENDAR.CRC);
1752: ELSE
1753: x_atp_rec.receiving_cal_code(j) := MSC_CALENDAR.FOC;
1754: END IF;
1755:
1756: -- Bug3593394 - Calculate only if parameters have changed
1757: -- Bug 4000425 Added NVL

Line 1765: x_atp_rec.ship_method(j), MSC_CALENDAR.OSC);

1761: OR (x_atp_rec.quantity_ordered(j-1) = 0)
1762: OR NVL(x_atp_rec.ship_method(j),'@@@')<>NVL(x_atp_rec.ship_method(j-1),'@@@')
1763: OR x_atp_rec.source_organization_id(j) <> x_atp_rec.source_organization_id(j-1) THEN
1764: x_atp_rec.shipping_cal_code(j) := MSC_SATP_FUNC.src_get_calendar_code(null, null, l_source_organization_id,
1765: x_atp_rec.ship_method(j), MSC_CALENDAR.OSC);
1766: ELSE
1767: x_atp_rec.shipping_cal_code(j) := x_atp_rec.shipping_cal_code(j-1);
1768: IF PG_DEBUG in ('Y', 'C') THEN
1769: msc_sch_wb.atp_debug('Call_ATP_NO_Commit: ' || 'Parameters have not changed for OSC');