eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ATP_DB_UTILS dependencies on MSC_ATP_PVT

Line 125: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY , -- For bug 2259824

121: p_atp_rec.demand_source_delivery,
122: MSC_ATP_UTILS.Truncate_Demand(p_atp_rec.quantity_ordered), --5598066
123: 0,
124: 1,
125: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY , -- For bug 2259824
126: sysdate,
127: FND_GLOBAL.USER_ID,
128: sysdate,
129: FND_GLOBAL.USER_ID,

Line 137: p_atp_rec.requested_ship_date + MSC_ATP_PVT.G_END_OF_DAY,

133: p_atp_rec.ato_model_line_id,
134: l_record_source, -- bug 2810112
135: --start changes for plan by request date
136: p_atp_rec.original_request_ship_date,
137: p_atp_rec.requested_ship_date + MSC_ATP_PVT.G_END_OF_DAY,
138: --end changes for plan by request date
139: MSC_ATP_PVT.G_PARTNER_ID,
140: MSC_ATP_PVT.G_PARTNER_SITE_ID,
141: p_atp_rec.delivery_lead_time, --bug3263368

Line 139: MSC_ATP_PVT.G_PARTNER_ID,

135: --start changes for plan by request date
136: p_atp_rec.original_request_ship_date,
137: p_atp_rec.requested_ship_date + MSC_ATP_PVT.G_END_OF_DAY,
138: --end changes for plan by request date
139: MSC_ATP_PVT.G_PARTNER_ID,
140: MSC_ATP_PVT.G_PARTNER_SITE_ID,
141: p_atp_rec.delivery_lead_time, --bug3263368
142: p_atp_rec.ship_set_name, --bug3263368
143: p_atp_rec.arrival_set_name --bug3263368

Line 140: MSC_ATP_PVT.G_PARTNER_SITE_ID,

136: p_atp_rec.original_request_ship_date,
137: p_atp_rec.requested_ship_date + MSC_ATP_PVT.G_END_OF_DAY,
138: --end changes for plan by request date
139: MSC_ATP_PVT.G_PARTNER_ID,
140: MSC_ATP_PVT.G_PARTNER_SITE_ID,
141: p_atp_rec.delivery_lead_time, --bug3263368
142: p_atp_rec.ship_set_name, --bug3263368
143: p_atp_rec.arrival_set_name --bug3263368
144: )

Line 147: IF (MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y') THEN

143: p_atp_rec.arrival_set_name --bug3263368
144: )
145: RETURNING DEMAND_ID INTO x_demand_id;
146:
147: IF (MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y') THEN
148: IF PG_DEBUG in ('Y', 'C') THEN
149: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'Insert into summary table');
150: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || ' update msc_atp_summary_so');
151: END IF;

Line 247: decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,

243: -- For bug 2259824, move the demand to the end of day
244: UPDATE msc_demands
245: SET using_requirement_quantity = p_atp_rec.quantity_ordered,
246: USING_ASSEMBLY_DEMAND_DATE=
247: decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
248: MSC_ATP_PVT.G_SCHEDULE_DATE_LEGEND,
249: TRUNC(NVL(p_atp_rec.requested_ship_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
250: MSC_ATP_PVT.G_PROMISE_DATE_LEGEND,
251: TRUNC(NVL(p_atp_rec.requested_ship_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

Line 248: MSC_ATP_PVT.G_SCHEDULE_DATE_LEGEND,

244: UPDATE msc_demands
245: SET using_requirement_quantity = p_atp_rec.quantity_ordered,
246: USING_ASSEMBLY_DEMAND_DATE=
247: decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
248: MSC_ATP_PVT.G_SCHEDULE_DATE_LEGEND,
249: TRUNC(NVL(p_atp_rec.requested_ship_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
250: MSC_ATP_PVT.G_PROMISE_DATE_LEGEND,
251: TRUNC(NVL(p_atp_rec.requested_ship_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
252: MSC_ATP_PVT.G_REQUEST_DATE_LEGEND,

Line 249: TRUNC(NVL(p_atp_rec.requested_ship_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

245: SET using_requirement_quantity = p_atp_rec.quantity_ordered,
246: USING_ASSEMBLY_DEMAND_DATE=
247: decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
248: MSC_ATP_PVT.G_SCHEDULE_DATE_LEGEND,
249: TRUNC(NVL(p_atp_rec.requested_ship_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
250: MSC_ATP_PVT.G_PROMISE_DATE_LEGEND,
251: TRUNC(NVL(p_atp_rec.requested_ship_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
252: MSC_ATP_PVT.G_REQUEST_DATE_LEGEND,
253: p_atp_rec.requested_ship_date,

Line 250: MSC_ATP_PVT.G_PROMISE_DATE_LEGEND,

246: USING_ASSEMBLY_DEMAND_DATE=
247: decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
248: MSC_ATP_PVT.G_SCHEDULE_DATE_LEGEND,
249: TRUNC(NVL(p_atp_rec.requested_ship_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
250: MSC_ATP_PVT.G_PROMISE_DATE_LEGEND,
251: TRUNC(NVL(p_atp_rec.requested_ship_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
252: MSC_ATP_PVT.G_REQUEST_DATE_LEGEND,
253: p_atp_rec.requested_ship_date,
254: TRUNC(NVL(p_atp_rec.requested_ship_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),

Line 251: TRUNC(NVL(p_atp_rec.requested_ship_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

247: decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
248: MSC_ATP_PVT.G_SCHEDULE_DATE_LEGEND,
249: TRUNC(NVL(p_atp_rec.requested_ship_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
250: MSC_ATP_PVT.G_PROMISE_DATE_LEGEND,
251: TRUNC(NVL(p_atp_rec.requested_ship_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
252: MSC_ATP_PVT.G_REQUEST_DATE_LEGEND,
253: p_atp_rec.requested_ship_date,
254: TRUNC(NVL(p_atp_rec.requested_ship_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),
255: schedule_ship_date = TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,--added by avjain

Line 252: MSC_ATP_PVT.G_REQUEST_DATE_LEGEND,

248: MSC_ATP_PVT.G_SCHEDULE_DATE_LEGEND,
249: TRUNC(NVL(p_atp_rec.requested_ship_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
250: MSC_ATP_PVT.G_PROMISE_DATE_LEGEND,
251: TRUNC(NVL(p_atp_rec.requested_ship_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
252: MSC_ATP_PVT.G_REQUEST_DATE_LEGEND,
253: p_atp_rec.requested_ship_date,
254: TRUNC(NVL(p_atp_rec.requested_ship_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),
255: schedule_ship_date = TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,--added by avjain
256: promise_ship_date = TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,--added by avjain

Line 254: TRUNC(NVL(p_atp_rec.requested_ship_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),

250: MSC_ATP_PVT.G_PROMISE_DATE_LEGEND,
251: TRUNC(NVL(p_atp_rec.requested_ship_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
252: MSC_ATP_PVT.G_REQUEST_DATE_LEGEND,
253: p_atp_rec.requested_ship_date,
254: TRUNC(NVL(p_atp_rec.requested_ship_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),
255: schedule_ship_date = TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,--added by avjain
256: promise_ship_date = TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,--added by avjain
257: request_ship_date=TRUNC(p_atp_rec.original_request_ship_date),--added by avjain
258: --request_arrival_date=TRUNC(p_atp_rec.original_request_arrival_date),--added by avjain

Line 255: schedule_ship_date = TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,--added by avjain

251: TRUNC(NVL(p_atp_rec.requested_ship_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
252: MSC_ATP_PVT.G_REQUEST_DATE_LEGEND,
253: p_atp_rec.requested_ship_date,
254: TRUNC(NVL(p_atp_rec.requested_ship_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),
255: schedule_ship_date = TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,--added by avjain
256: promise_ship_date = TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,--added by avjain
257: request_ship_date=TRUNC(p_atp_rec.original_request_ship_date),--added by avjain
258: --request_arrival_date=TRUNC(p_atp_rec.original_request_arrival_date),--added by avjain
259: demand_type = 1,

Line 256: promise_ship_date = TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,--added by avjain

252: MSC_ATP_PVT.G_REQUEST_DATE_LEGEND,
253: p_atp_rec.requested_ship_date,
254: TRUNC(NVL(p_atp_rec.requested_ship_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),
255: schedule_ship_date = TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,--added by avjain
256: promise_ship_date = TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,--added by avjain
257: request_ship_date=TRUNC(p_atp_rec.original_request_ship_date),--added by avjain
258: --request_arrival_date=TRUNC(p_atp_rec.original_request_arrival_date),--added by avjain
259: demand_type = 1,
260: origination_type = p_atp_rec.origination_type,

Line 272: customer_id = MSC_ATP_PVT.G_PARTNER_ID,

268: 30, p_atp_rec.order_number,
269: null),
270: applied = decode(p_atp_rec.origination_type, 6, 2, 30, 2, null),
271: status = decode(p_atp_rec.origination_type, 6, 0, 30, 0, null),
272: customer_id = MSC_ATP_PVT.G_PARTNER_ID,
273: ship_to_site_id = MSC_ATP_PVT.G_PARTNER_SITE_ID,
274: inventory_item_id = p_atp_rec.inventory_item_id,
275: -- 24x7
276: atp_synchronization_flag = 0,

Line 273: ship_to_site_id = MSC_ATP_PVT.G_PARTNER_SITE_ID,

269: null),
270: applied = decode(p_atp_rec.origination_type, 6, 2, 30, 2, null),
271: status = decode(p_atp_rec.origination_type, 6, 0, 30, 0, null),
272: customer_id = MSC_ATP_PVT.G_PARTNER_ID,
273: ship_to_site_id = MSC_ATP_PVT.G_PARTNER_SITE_ID,
274: inventory_item_id = p_atp_rec.inventory_item_id,
275: -- 24x7
276: atp_synchronization_flag = 0,
277: -- bug 2795053-reopen (ssurendr) update the demand_satisfied_date in msc_demands

Line 278: dmd_satisfied_date = TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY

274: inventory_item_id = p_atp_rec.inventory_item_id,
275: -- 24x7
276: atp_synchronization_flag = 0,
277: -- bug 2795053-reopen (ssurendr) update the demand_satisfied_date in msc_demands
278: dmd_satisfied_date = TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY
279: WHERE sr_instance_id = p_atp_rec.instance_id
280: AND plan_id = p_plan_id
281: AND sales_order_line_id = p_atp_rec.demand_source_line
282: AND demand_id = p_atp_rec.old_demand_id

Line 293: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND

289: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'found demand and updated demand_id : ' || x_demand_id);
290: END IF;
291: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
292:
293: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
294: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
295: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
296: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
297:

Line 294: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

290: END IF;
291: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
292:
293: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
294: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
295: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
296: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
297:
298: IF PG_DEBUG in ('Y', 'C') THEN

Line 295: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

291: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
292:
293: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
294: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
295: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
296: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
297:
298: IF PG_DEBUG in ('Y', 'C') THEN
299: msc_sch_wb.atp_debug('Add_Mat_Demand: before update of msc_alloc_demands');

Line 296: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

292:
293: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
294: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
295: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
296: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
297:
298: IF PG_DEBUG in ('Y', 'C') THEN
299: msc_sch_wb.atp_debug('Add_Mat_Demand: before update of msc_alloc_demands');
300: END IF;

Line 399: 6, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

395: msc_demands_s.nextval,
396: MSC_ATP_UTILS.Truncate_Demand(p_atp_rec.quantity_ordered), -- 5598066
397: -- start changes for plan by request date
398: decode(p_atp_rec.origination_type,
399: 6, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
400: 30, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
401: null), --plan by request date
402: decode(p_atp_rec.origination_type,
403: 6, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,

Line 400: 30, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

396: MSC_ATP_UTILS.Truncate_Demand(p_atp_rec.quantity_ordered), -- 5598066
397: -- start changes for plan by request date
398: decode(p_atp_rec.origination_type,
399: 6, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
400: 30, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
401: null), --plan by request date
402: decode(p_atp_rec.origination_type,
403: 6, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
404: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,

Line 403: 6, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,

399: 6, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
400: 30, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
401: null), --plan by request date
402: decode(p_atp_rec.origination_type,
403: 6, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
404: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
405: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
406: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
407: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

Line 404: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,

400: 30, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
401: null), --plan by request date
402: decode(p_atp_rec.origination_type,
403: 6, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
404: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
405: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
406: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
407: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
408: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,

Line 405: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

401: null), --plan by request date
402: decode(p_atp_rec.origination_type,
403: 6, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
404: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
405: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
406: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
407: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
408: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
409: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

Line 406: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,

402: decode(p_atp_rec.origination_type,
403: 6, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
404: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
405: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
406: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
407: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
408: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
409: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
410: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,

Line 407: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

403: 6, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
404: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
405: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
406: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
407: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
408: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
409: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
410: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
411: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

Line 408: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,

404: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
405: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
406: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
407: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
408: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
409: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
410: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
411: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
412: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,

Line 409: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

405: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
406: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
407: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
408: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
409: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
410: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
411: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
412: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
413: p_atp_rec.original_request_ship_date,

Line 410: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,

406: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
407: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
408: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
409: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
410: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
411: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
412: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
413: p_atp_rec.original_request_ship_date,
414: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,

Line 411: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

407: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
408: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
409: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
410: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
411: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
412: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
413: p_atp_rec.original_request_ship_date,
414: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
415: p_atp_rec.original_request_ship_date,

Line 412: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,

408: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
409: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
410: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
411: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
412: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
413: p_atp_rec.original_request_ship_date,
414: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
415: p_atp_rec.original_request_ship_date,
416: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY),

Line 414: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,

410: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
411: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
412: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
413: p_atp_rec.original_request_ship_date,
414: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
415: p_atp_rec.original_request_ship_date,
416: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY),
417: 30, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
418: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,

Line 416: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY),

412: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
413: p_atp_rec.original_request_ship_date,
414: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
415: p_atp_rec.original_request_ship_date,
416: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY),
417: 30, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
418: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
419: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
420: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,

Line 417: 30, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,

413: p_atp_rec.original_request_ship_date,
414: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
415: p_atp_rec.original_request_ship_date,
416: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY),
417: 30, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
418: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
419: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
420: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
421: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

Line 418: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,

414: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
415: p_atp_rec.original_request_ship_date,
416: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY),
417: 30, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
418: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
419: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
420: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
421: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
422: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,

Line 419: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

415: p_atp_rec.original_request_ship_date,
416: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY),
417: 30, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
418: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
419: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
420: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
421: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
422: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
423: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

Line 420: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,

416: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY),
417: 30, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
418: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
419: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
420: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
421: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
422: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
423: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
424: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,

Line 421: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

417: 30, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
418: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
419: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
420: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
421: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
422: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
423: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
424: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
425: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

Line 422: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,

418: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
419: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
420: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
421: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
422: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
423: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
424: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
425: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
426: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,

Line 423: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

419: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
420: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
421: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
422: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
423: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
424: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
425: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
426: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
427: p_atp_rec.original_request_ship_date,

Line 424: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,

420: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
421: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
422: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
423: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
424: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
425: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
426: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
427: p_atp_rec.original_request_ship_date,
428: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,

Line 425: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

421: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
422: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
423: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
424: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
425: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
426: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
427: p_atp_rec.original_request_ship_date,
428: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
429: p_atp_rec.original_request_ship_date,

Line 426: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,

422: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
423: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
424: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
425: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
426: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
427: p_atp_rec.original_request_ship_date,
428: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
429: p_atp_rec.original_request_ship_date,
430: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY),

Line 428: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,

424: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
425: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
426: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
427: p_atp_rec.original_request_ship_date,
428: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
429: p_atp_rec.original_request_ship_date,
430: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY),
431: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY), --plan by request date
432: decode(p_atp_rec.origination_type,

Line 430: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY),

426: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
427: p_atp_rec.original_request_ship_date,
428: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
429: p_atp_rec.original_request_ship_date,
430: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY),
431: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY), --plan by request date
432: decode(p_atp_rec.origination_type,
433: 6, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
434: 30, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

Line 431: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY), --plan by request date

427: p_atp_rec.original_request_ship_date,
428: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
429: p_atp_rec.original_request_ship_date,
430: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY),
431: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY), --plan by request date
432: decode(p_atp_rec.origination_type,
433: 6, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
434: 30, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
435: null), -- plan by request date

Line 433: 6, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

429: p_atp_rec.original_request_ship_date,
430: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY),
431: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY), --plan by request date
432: decode(p_atp_rec.origination_type,
433: 6, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
434: 30, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
435: null), -- plan by request date
436: decode(p_atp_rec.origination_type,
437: 6, p_atp_rec.original_request_ship_date,

Line 434: 30, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

430: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY),
431: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY), --plan by request date
432: decode(p_atp_rec.origination_type,
433: 6, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
434: 30, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
435: null), -- plan by request date
436: decode(p_atp_rec.origination_type,
437: 6, p_atp_rec.original_request_ship_date,
438: 30, p_atp_rec.original_request_ship_date,

Line 457: DECODE(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 1, MSC_ATP_PVT.G_ATP_DEMAND_CLASS,

453: FND_GLOBAL.USER_ID,
454: --p_atp_rec.demand_class,
455: ---bug 2424357: we do not store the converted demand class
456: -- always store the actual demand class.
457: DECODE(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 1, MSC_ATP_PVT.G_ATP_DEMAND_CLASS,
458: 2, p_atp_rec.demand_class),
459: p_atp_rec.refresh_number,
460: /* s_cto_rearch
461: -- Modified by ngoel on 1/12/2001 for origination_type = 30

Line 470: --decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_ID, 30, MSC_ATP_PVT.G_PARTNER_ID, null),

466: --s_cto_rearch
467: p_atp_rec.order_number,
468: decode(p_atp_rec.origination_type, 6, 2, 30, 2, null),
469: decode(p_atp_rec.origination_type, 6, 0, 30, 0, null),
470: --decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_ID, 30, MSC_ATP_PVT.G_PARTNER_ID, null),
471: --decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_SITE_ID, 30, MSC_ATP_PVT.G_PARTNER_SITE_ID, null),
472: MSC_ATP_PVT.G_PARTNER_ID,
473: MSC_ATP_PVT.G_PARTNER_SITE_ID,
474: l_record_source, -- For plan order pegging

Line 471: --decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_SITE_ID, 30, MSC_ATP_PVT.G_PARTNER_SITE_ID, null),

467: p_atp_rec.order_number,
468: decode(p_atp_rec.origination_type, 6, 2, 30, 2, null),
469: decode(p_atp_rec.origination_type, 6, 0, 30, 0, null),
470: --decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_ID, 30, MSC_ATP_PVT.G_PARTNER_ID, null),
471: --decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_SITE_ID, 30, MSC_ATP_PVT.G_PARTNER_SITE_ID, null),
472: MSC_ATP_PVT.G_PARTNER_ID,
473: MSC_ATP_PVT.G_PARTNER_SITE_ID,
474: l_record_source, -- For plan order pegging
475: -- 24x7

Line 472: MSC_ATP_PVT.G_PARTNER_ID,

468: decode(p_atp_rec.origination_type, 6, 2, 30, 2, null),
469: decode(p_atp_rec.origination_type, 6, 0, 30, 0, null),
470: --decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_ID, 30, MSC_ATP_PVT.G_PARTNER_ID, null),
471: --decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_SITE_ID, 30, MSC_ATP_PVT.G_PARTNER_SITE_ID, null),
472: MSC_ATP_PVT.G_PARTNER_ID,
473: MSC_ATP_PVT.G_PARTNER_SITE_ID,
474: l_record_source, -- For plan order pegging
475: -- 24x7
476: 0,

Line 473: MSC_ATP_PVT.G_PARTNER_SITE_ID,

469: decode(p_atp_rec.origination_type, 6, 0, 30, 0, null),
470: --decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_ID, 30, MSC_ATP_PVT.G_PARTNER_ID, null),
471: --decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_SITE_ID, 30, MSC_ATP_PVT.G_PARTNER_SITE_ID, null),
472: MSC_ATP_PVT.G_PARTNER_ID,
473: MSC_ATP_PVT.G_PARTNER_SITE_ID,
474: l_record_source, -- For plan order pegging
475: -- 24x7
476: 0,
477: -- bug 2795053-reopen (ssurendr) insert the demand_satisfied_date in msc_demands

Line 478: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

474: l_record_source, -- For plan order pegging
475: -- 24x7
476: 0,
477: -- bug 2795053-reopen (ssurendr) insert the demand_satisfied_date in msc_demands
478: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
479: msc_demands_s.nextval,
480: --s_cto_rearch
481: p_atp_rec.parent_line_id,
482: p_atp_rec.ato_model_line_id,

Line 517: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND

513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515:
516: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
517: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
518: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
519: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
520: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
521:

Line 518: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

514: END IF;
515:
516: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
517: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
518: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
519: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
520: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
521:
522: IF PG_DEBUG in ('Y', 'C') THEN

Line 519: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

515:
516: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
517: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
518: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
519: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
520: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
521:
522: IF PG_DEBUG in ('Y', 'C') THEN
523: msc_sch_wb.atp_debug('Add_Mat_Demand: before insert into msc_alloc_demands');

Line 520: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

516: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
517: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
518: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
519: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
520: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
521:
522: IF PG_DEBUG in ('Y', 'C') THEN
523: msc_sch_wb.atp_debug('Add_Mat_Demand: before insert into msc_alloc_demands');
524: END IF;

Line 573: decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_ID,

569: FND_GLOBAL.USER_ID,
570: sysdate,
571: p_atp_rec.refresh_number,
572: --bug3684383
573: decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_ID,
574: 30, MSC_ATP_PVT.G_PARTNER_ID,
575: null),
576: decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_SITE_ID,
577: 30, MSC_ATP_PVT.G_PARTNER_SITE_ID,

Line 574: 30, MSC_ATP_PVT.G_PARTNER_ID,

570: sysdate,
571: p_atp_rec.refresh_number,
572: --bug3684383
573: decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_ID,
574: 30, MSC_ATP_PVT.G_PARTNER_ID,
575: null),
576: decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_SITE_ID,
577: 30, MSC_ATP_PVT.G_PARTNER_SITE_ID,
578: null));

Line 576: decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_SITE_ID,

572: --bug3684383
573: decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_ID,
574: 30, MSC_ATP_PVT.G_PARTNER_ID,
575: null),
576: decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_SITE_ID,
577: 30, MSC_ATP_PVT.G_PARTNER_SITE_ID,
578: null));
579: END IF;
580:

Line 577: 30, MSC_ATP_PVT.G_PARTNER_SITE_ID,

573: decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_ID,
574: 30, MSC_ATP_PVT.G_PARTNER_ID,
575: null),
576: decode(p_atp_rec.origination_type, 6, MSC_ATP_PVT.G_PARTNER_SITE_ID,
577: 30, MSC_ATP_PVT.G_PARTNER_SITE_ID,
578: null));
579: END IF;
580:
581: -- Allocated ATP Based on Planning Details -- Agilent changes End

Line 587: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' AND p_plan_id = -1 THEN

583: END IF; --(p_atp_rec.origination_type NOT IN (6, 30) OR SQL%ROWCOUNT = 0)
584:
585:
586: -- Update summary records only in ODS - for summary enhancement
587: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' AND p_plan_id = -1 THEN
588: IF PG_DEBUG in ('Y', 'C') THEN
589: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'add demands to summary tables');
590: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'First try to update');
591: END IF;

Line 641: IF (MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y') AND p_plan_id = -1 THEN

637: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'insert row: sqlcode = '|| to_char(my_sqlcode));
638: END IF;
639:
640: -- Commit chenges only in PDS - for summary enhancement
641: IF (MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y') AND p_plan_id = -1 THEN
642: -- in case of summmary mode we always commit after each change
643: IF PG_DEBUG in ('Y', 'C') THEN
644: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'Commit in summary mode');
645: END IF;

Line 825: NVL(MSC_ATP_PVT.G_DEMAND_PEGGING_ID, msc_full_pegging_s.currval),

821: p_pegging_rec.supply_demand_source_type,
822: p_pegging_rec.supply_demand_quantity,
823: p_pegging_rec.supply_demand_type,
824: p_pegging_rec.supply_demand_date,
825: NVL(MSC_ATP_PVT.G_DEMAND_PEGGING_ID, msc_full_pegging_s.currval),
826: p_pegging_rec.constraint_flag,
827: p_pegging_rec.allocated_quantity, -- 1527660
828: p_pegging_rec.number1,
829: p_pegging_rec.char1,

Line 861: 1, TRUNC(p_pegging_rec.REQUIRED_DATE) + MSC_ATP_PVT.G_END_OF_DAY,

857: -- p_pegging_rec.REQUIRED_DATE,
858: -- Bug 2748730. Move the required_date to day end only when the pegging is for demand line
859: -- This is applicable irrespective of whether the line is overridden or not
860: DECODE(p_pegging_rec.supply_demand_type,
861: 1, TRUNC(p_pegging_rec.REQUIRED_DATE) + MSC_ATP_PVT.G_END_OF_DAY,
862: p_pegging_rec.REQUIRED_DATE),
863: p_pegging_rec.OPERATION_SEQUENCE_ID,
864: p_pegging_rec.SOURCING_RULE_NAME,
865: p_pegging_rec.OFFSET,

Line 889: MSC_ATP_PVT.G_PARTNER_ID,

885: p_pegging_rec.base_model_id,
886: p_pegging_rec.base_model_name,
887: p_pegging_rec.nonatp_flag,
888: p_pegging_rec.demand_class,
889: MSC_ATP_PVT.G_PARTNER_ID,
890: MSC_ATP_PVT.G_PARTNER_SITE_ID,
891: p_pegging_rec.receiving_organization_id,
892: p_pegging_rec.actual_supply_demand_date,
893: --e_cto_rearch

Line 890: MSC_ATP_PVT.G_PARTNER_SITE_ID,

886: p_pegging_rec.base_model_name,
887: p_pegging_rec.nonatp_flag,
888: p_pegging_rec.demand_class,
889: MSC_ATP_PVT.G_PARTNER_ID,
890: MSC_ATP_PVT.G_PARTNER_SITE_ID,
891: p_pegging_rec.receiving_organization_id,
892: p_pegging_rec.actual_supply_demand_date,
893: --e_cto_rearch
894: p_pegging_rec.aggregate_time_fence_date, -- For time_phased_atp

Line 1114: TRUNC(p_start_date) + MSC_ATP_PVT.G_END_OF_DAY,

1110: p_op_seq_num, -- This field was not getting populated before. CTO ODR
1111: -- Bug 3348095
1112: -- Now both start and end dates will be stored for
1113: -- ATP created resource requirements.
1114: TRUNC(p_start_date) + MSC_ATP_PVT.G_END_OF_DAY,
1115: TRUNC(p_end_date) + MSC_ATP_PVT.G_END_OF_DAY, -- For bug 2259824
1116: -- End Bug 3348095
1117: p_resource_hours,
1118: p_unadj_resource_hours, --5093604

Line 1115: TRUNC(p_end_date) + MSC_ATP_PVT.G_END_OF_DAY, -- For bug 2259824

1111: -- Bug 3348095
1112: -- Now both start and end dates will be stored for
1113: -- ATP created resource requirements.
1114: TRUNC(p_start_date) + MSC_ATP_PVT.G_END_OF_DAY,
1115: TRUNC(p_end_date) + MSC_ATP_PVT.G_END_OF_DAY, -- For bug 2259824
1116: -- End Bug 3348095
1117: p_resource_hours,
1118: p_unadj_resource_hours, --5093604
1119: p_touch_time, --5093604

Line 1124: --MSC_ATP_PVT.G_OPTIMIZED_PLAN, Bug 3327819 Default parent_id to NULL.

1120: decode(p_resource_id,-1,p_resource_hours,to_number(null)),
1121: 0,
1122: 5,
1123: p_std_op_code,
1124: --MSC_ATP_PVT.G_OPTIMIZED_PLAN, Bug 3327819 Default parent_id to NULL.
1125: sysdate,
1126: FND_GLOBAL.USER_ID,
1127: sysdate,
1128: FND_GLOBAL.USER_ID,

Line 1136: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' THEN

1132: RETURNING transaction_id INTO x_transaction_id;
1133:
1134: -- Code to make summary updates and commit removed for summary enhancement
1135: /** code commented for time being. Will be removed after code review
1136: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' THEN
1137: IF PG_DEBUG in ('Y', 'C') THEN
1138: msc_sch_wb.atp_debug('Add_Resource_Demand: ' || ' In summary mode update resource req');
1139: msc_sch_wb.atp_debug('Add_Resource_Demand: ' || 'First update');
1140: END IF;

Line 1227: END IF; --- if MSC_ATP_PVT.SUMMARY_FLAG = 'Y'

1223: IF PG_DEBUG in ('Y', 'C') THEN
1224: msc_sch_wb.atp_debug('Add_Resource_Demand: ' || 'Summary mode commit, in resource_req');
1225: END IF;
1226: commit;
1227: END IF; --- if MSC_ATP_PVT.SUMMARY_FLAG = 'Y'
1228: ***/
1229:
1230: IF PG_DEBUG in ('Y', 'C') THEN
1231: msc_sch_wb.atp_debug('Add_Resource_Demand: ' || 'x_transaction_id = '||x_transaction_id);

Line 1250: AND session_id = MSC_ATP_PVT.G_SESSION_ID;

1246: END IF;
1247:
1248: DELETE FROM mrp_atp_details_temp
1249: WHERE pegging_id = p_pegging_id
1250: AND session_id = MSC_ATP_PVT.G_SESSION_ID;
1251:
1252: IF PG_DEBUG in ('Y', 'C') THEN
1253: msc_sch_wb.atp_debug('After delete_pegging,p_pegging_id='||p_pegging_id);
1254: END IF;

Line 1326: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' AND G_ORIG_INV_CTP = 5 THEN

1322: msc_sch_wb.atp_debug('p_source_organization id := ' || p_source_organization_Id);
1323: END IF;
1324: IF p_plan_id = -1 THEN
1325:
1326: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' AND G_ORIG_INV_CTP = 5 THEN
1327: -- Condition for INV_CTP added for bug 3295831 because summary
1328: -- is not supported in PDS-ODS switch.
1329: MSC_ATP_DB_UTILS.DELETE_SUMMARY_ROW(p_identifier, p_plan_id, p_instance_id,p_demand_source_type);--cmro
1330: END IF;

Line 1437: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' THEN

1433: msc_sch_wb.atp_debug('Delete_Row: ' || 'Deleting msc_demands with identifier = '||
1434: p_identifier ||' : plan id = '||p_plan_id);
1435: END IF;
1436:
1437: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' THEN
1438: IF PG_DEBUG in ('Y', 'C') THEN
1439: msc_sch_wb.atp_debug('Delete_Row: ' || 'Obtain the latest refresh number.');
1440: END IF;
1441:

Line 1452: IF (MSC_ATP_PVT.G_SUMMARY_FLAG = 'N') OR

1448: msc_sch_wb.atp_debug('Delete_Row: ' || 'l_current_refresh_number := ' || l_current_refresh_number);
1449: END IF;
1450: END IF;
1451:
1452: IF (MSC_ATP_PVT.G_SUMMARY_FLAG = 'N') OR
1453: (p_time_phased_atp = 'Y') OR
1454: ((MSC_ATP_PVT.G_INV_CTP = 4) AND
1455: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
1456: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

Line 1454: ((MSC_ATP_PVT.G_INV_CTP = 4) AND

1450: END IF;
1451:
1452: IF (MSC_ATP_PVT.G_SUMMARY_FLAG = 'N') OR
1453: (p_time_phased_atp = 'Y') OR
1454: ((MSC_ATP_PVT.G_INV_CTP = 4) AND
1455: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
1456: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
1457: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
1458: -- If condition added for summary enhancement

Line 1455: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

1451:
1452: IF (MSC_ATP_PVT.G_SUMMARY_FLAG = 'N') OR
1453: (p_time_phased_atp = 'Y') OR
1454: ((MSC_ATP_PVT.G_INV_CTP = 4) AND
1455: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
1456: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
1457: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
1458: -- If condition added for summary enhancement
1459: -- execute the old code non-summary cases and demand priority allocation cases

Line 1456: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

1452: IF (MSC_ATP_PVT.G_SUMMARY_FLAG = 'N') OR
1453: (p_time_phased_atp = 'Y') OR
1454: ((MSC_ATP_PVT.G_INV_CTP = 4) AND
1455: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
1456: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
1457: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
1458: -- If condition added for summary enhancement
1459: -- execute the old code non-summary cases and demand priority allocation cases
1460: IF PG_DEBUG in ('Y', 'C') THEN

Line 1457: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

1453: (p_time_phased_atp = 'Y') OR
1454: ((MSC_ATP_PVT.G_INV_CTP = 4) AND
1455: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
1456: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
1457: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
1458: -- If condition added for summary enhancement
1459: -- execute the old code non-summary cases and demand priority allocation cases
1460: IF PG_DEBUG in ('Y', 'C') THEN
1461: msc_sch_wb.atp_debug('Delete_Row: ' || 'Summary , PF or allocated.');

Line 1500: AND session_id = MSC_ATP_PVT.G_SESSION_ID

1496: AND sales_order_line_id IN (
1497: SELECT component_identifier
1498: FROM msc_bom_temp
1499: START WITH assembly_identifier = p_identifier
1500: AND session_id = MSC_ATP_PVT.G_SESSION_ID
1501: AND assembly_identifier <> component_identifier
1502: CONNECT BY PRIOR component_identifier = assembly_identifier
1503: AND assembly_identifier <> component_identifier
1504: AND session_id = MSC_ATP_PVT.G_SESSION_ID

Line 1504: AND session_id = MSC_ATP_PVT.G_SESSION_ID

1500: AND session_id = MSC_ATP_PVT.G_SESSION_ID
1501: AND assembly_identifier <> component_identifier
1502: CONNECT BY PRIOR component_identifier = assembly_identifier
1503: AND assembly_identifier <> component_identifier
1504: AND session_id = MSC_ATP_PVT.G_SESSION_ID
1505: UNION ALL
1506: SELECT p_identifier FROM dual
1507: -- rajjain 03/14/2003 Bug 2849749 End
1508: )

Line 1561: AND session_id = MSC_ATP_PVT.G_SESSION_ID

1557: AND sales_order_line_id IN (
1558: SELECT component_identifier
1559: FROM msc_bom_temp
1560: START WITH assembly_identifier = p_identifier
1561: AND session_id = MSC_ATP_PVT.G_SESSION_ID
1562: AND assembly_identifier <> component_identifier
1563: CONNECT BY PRIOR component_identifier = assembly_identifier
1564: AND assembly_identifier <> component_identifier
1565: AND session_id = MSC_ATP_PVT.G_SESSION_ID

Line 1565: AND session_id = MSC_ATP_PVT.G_SESSION_ID

1561: AND session_id = MSC_ATP_PVT.G_SESSION_ID
1562: AND assembly_identifier <> component_identifier
1563: CONNECT BY PRIOR component_identifier = assembly_identifier
1564: AND assembly_identifier <> component_identifier
1565: AND session_id = MSC_ATP_PVT.G_SESSION_ID
1566: UNION ALL
1567: SELECT p_identifier FROM dual
1568: )
1569: Comment out code refering msc_bom_temp

Line 1696: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' THEN

1692:
1693:
1694: -- Code to update summary records removed for summary enhancement
1695: /** code commented for time being. Will be removed after code review
1696: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' THEN
1697: IF PG_DEBUG in ('Y', 'C') THEN
1698: msc_sch_wb.atp_debug('Delete_Row: ' || 'update Demands in summary mode');
1699: END IF;
1700: -- Bug 2738280. Change the input parameters of procedure call.

Line 1711: ((MSC_ATP_PVT.G_INV_CTP = 4) AND

1707: /* time_phased_atp
1708: Delete bucketed demands and rollup supplies*/
1709: IF ((p_time_phased_atp = 'Y')
1710: OR
1711: ((MSC_ATP_PVT.G_INV_CTP = 4) AND
1712: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
1713: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
1714: --bug 3442528: We need to delete SO for model entities as well.
1715: --(MSC_ATP_PVT.G_ALLOCATION_METHOD = 1))) AND p_ato_model_line_id is null THEN

Line 1712: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

1708: Delete bucketed demands and rollup supplies*/
1709: IF ((p_time_phased_atp = 'Y')
1710: OR
1711: ((MSC_ATP_PVT.G_INV_CTP = 4) AND
1712: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
1713: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
1714: --bug 3442528: We need to delete SO for model entities as well.
1715: --(MSC_ATP_PVT.G_ALLOCATION_METHOD = 1))) AND p_ato_model_line_id is null THEN
1716: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1))) THEN

Line 1713: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

1709: IF ((p_time_phased_atp = 'Y')
1710: OR
1711: ((MSC_ATP_PVT.G_INV_CTP = 4) AND
1712: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
1713: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
1714: --bug 3442528: We need to delete SO for model entities as well.
1715: --(MSC_ATP_PVT.G_ALLOCATION_METHOD = 1))) AND p_ato_model_line_id is null THEN
1716: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1))) THEN
1717:

Line 1715: --(MSC_ATP_PVT.G_ALLOCATION_METHOD = 1))) AND p_ato_model_line_id is null THEN

1711: ((MSC_ATP_PVT.G_INV_CTP = 4) AND
1712: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
1713: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
1714: --bug 3442528: We need to delete SO for model entities as well.
1715: --(MSC_ATP_PVT.G_ALLOCATION_METHOD = 1))) AND p_ato_model_line_id is null THEN
1716: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1))) THEN
1717:
1718: IF PG_DEBUG in ('Y', 'C') THEN
1719: msc_sch_wb.atp_debug('Delete_Row: before update of msc_alloc_demands');

Line 1716: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1))) THEN

1712: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
1713: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
1714: --bug 3442528: We need to delete SO for model entities as well.
1715: --(MSC_ATP_PVT.G_ALLOCATION_METHOD = 1))) AND p_ato_model_line_id is null THEN
1716: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1))) THEN
1717:
1718: IF PG_DEBUG in ('Y', 'C') THEN
1719: msc_sch_wb.atp_debug('Delete_Row: before update of msc_alloc_demands');
1720: END IF;

Line 1722: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'N' THEN

1718: IF PG_DEBUG in ('Y', 'C') THEN
1719: msc_sch_wb.atp_debug('Delete_Row: before update of msc_alloc_demands');
1720: END IF;
1721:
1722: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'N' THEN
1723: -- If condition added for summary enhancement
1724: -- For non summary case since no returning is required hence direct bulk update is used
1725:
1726: IF l_identifier_tab IS NOT NULL and l_identifier_tab.COUNT > 0 THEN

Line 1772: ELSE -- IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'N' THEN

1768:
1769:
1770: END IF;
1771:
1772: ELSE -- IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'N' THEN
1773:
1774: SELECT sales_order_line_id,
1775: inventory_item_id,
1776: organization_id,

Line 1805: AND session_id = MSC_ATP_PVT.G_SESSION_ID

1801: AND sales_order_line_id IN (
1802: SELECT component_identifier
1803: FROM msc_bom_temp
1804: START WITH assembly_identifier = p_identifier
1805: AND session_id = MSC_ATP_PVT.G_SESSION_ID
1806: AND assembly_identifier <> component_identifier
1807: CONNECT BY PRIOR component_identifier = assembly_identifier
1808: AND assembly_identifier <> component_identifier
1809: AND session_id = MSC_ATP_PVT.G_SESSION_ID

Line 1809: AND session_id = MSC_ATP_PVT.G_SESSION_ID

1805: AND session_id = MSC_ATP_PVT.G_SESSION_ID
1806: AND assembly_identifier <> component_identifier
1807: CONNECT BY PRIOR component_identifier = assembly_identifier
1808: AND assembly_identifier <> component_identifier
1809: AND session_id = MSC_ATP_PVT.G_SESSION_ID
1810: UNION ALL
1811: SELECT p_identifier FROM dual)
1812: Comment out code refering msc_bom_temp
1813: */

Line 1908: AND session_id = MSC_ATP_PVT.G_SESSION_ID

1904: AND sales_order_line_id IN (
1905: SELECT component_identifier
1906: FROM msc_bom_temp
1907: START WITH assembly_identifier = p_identifier
1908: AND session_id = MSC_ATP_PVT.G_SESSION_ID
1909: AND assembly_identifier <> component_identifier
1910: CONNECT BY PRIOR component_identifier = assembly_identifier
1911: AND assembly_identifier <> component_identifier
1912: AND session_id = MSC_ATP_PVT.G_SESSION_ID

Line 1912: AND session_id = MSC_ATP_PVT.G_SESSION_ID

1908: AND session_id = MSC_ATP_PVT.G_SESSION_ID
1909: AND assembly_identifier <> component_identifier
1910: CONNECT BY PRIOR component_identifier = assembly_identifier
1911: AND assembly_identifier <> component_identifier
1912: AND session_id = MSC_ATP_PVT.G_SESSION_ID
1913: UNION ALL
1914: SELECT p_identifier FROM dual)
1915: Comment out code refering msc_bom_temp
1916: */

Line 2019: END IF; -- IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'N' THEN

2015: END IF; -- IF i_ins_item_id_tab IS NOT NULL and i_ins_item_id_tab.COUNT > 0 THEN
2016:
2017: x_copy_demand_id := l_copy_demand_id;
2018:
2019: END IF; -- IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'N' THEN
2020:
2021: END IF; -- IF THEN
2022: -- CTO ODR and Simplified Pegging
2023: MSC_ATP_PEG.Add_Offset_Data(p_identifier ,

Line 2042: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' AND p_plan_id = -1 AND G_ORIG_INV_CTP = 5 THEN

2038:
2039: END IF; -- IF p_plan_id = -1 THEN
2040:
2041: -- Commit removed for PDS cases - summary enhancement
2042: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' AND p_plan_id = -1 AND G_ORIG_INV_CTP = 5 THEN
2043: -- Condition for INV_CTP added for bug 3295831 because summary
2044: -- is not supported in PDS-ODS switch.
2045: IF PG_DEBUG in ('Y', 'C') THEN
2046: msc_sch_wb.atp_debug('Summary mode commit, in Delete_Row');

Line 2090: and session_id = MSC_ATP_PVT.G_SESSION_ID

2086: from mrp_atp_details_temp
2087: where ((pegging_id <> p_identifier and (p_mode = 2 or p_mode = 3)) or
2088: (p_mode = 1))
2089: and record_type in (3,4)
2090: and session_id = MSC_ATP_PVT.G_SESSION_ID
2091: start with pegging_id = p_identifier
2092: and session_id = MSC_ATP_PVT.G_SESSION_ID
2093: and record_type = 3
2094: connect by parent_pegging_id = prior pegging_id

Line 2092: and session_id = MSC_ATP_PVT.G_SESSION_ID

2088: (p_mode = 1))
2089: and record_type in (3,4)
2090: and session_id = MSC_ATP_PVT.G_SESSION_ID
2091: start with pegging_id = p_identifier
2092: and session_id = MSC_ATP_PVT.G_SESSION_ID
2093: and record_type = 3
2094: connect by parent_pegging_id = prior pegging_id
2095: AND session_id = prior session_id
2096: AND record_type in (3,4);

Line 2128: IF (NVL(MSC_ATP_PVT.G_PLAN_INFO_REC.plan_type, 1) = 5) THEN

2124:
2125: -- rajjain 05/19/2003 bug 2959840
2126: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'Reset all the global variables ');
2127: -- Begin ATP4drp Allocation not supported for DRP plans.
2128: IF (NVL(MSC_ATP_PVT.G_PLAN_INFO_REC.plan_type, 1) = 5) THEN
2129: MSC_ATP_PVT.G_ALLOCATED_ATP := 'N';
2130: MSC_ATP_PVT.G_ALLOCATION_METHOD := 2;
2131: IF PG_DEBUG in ('Y', 'C') THEN
2132: msc_sch_wb.atp_debug('----- ATP4drp Specific Debug Messages -----');

Line 2129: MSC_ATP_PVT.G_ALLOCATED_ATP := 'N';

2125: -- rajjain 05/19/2003 bug 2959840
2126: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'Reset all the global variables ');
2127: -- Begin ATP4drp Allocation not supported for DRP plans.
2128: IF (NVL(MSC_ATP_PVT.G_PLAN_INFO_REC.plan_type, 1) = 5) THEN
2129: MSC_ATP_PVT.G_ALLOCATED_ATP := 'N';
2130: MSC_ATP_PVT.G_ALLOCATION_METHOD := 2;
2131: IF PG_DEBUG in ('Y', 'C') THEN
2132: msc_sch_wb.atp_debug('----- ATP4drp Specific Debug Messages -----');
2133: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'PF and Allocated ATP not applicable for DRP plans');

Line 2130: MSC_ATP_PVT.G_ALLOCATION_METHOD := 2;

2126: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'Reset all the global variables ');
2127: -- Begin ATP4drp Allocation not supported for DRP plans.
2128: IF (NVL(MSC_ATP_PVT.G_PLAN_INFO_REC.plan_type, 1) = 5) THEN
2129: MSC_ATP_PVT.G_ALLOCATED_ATP := 'N';
2130: MSC_ATP_PVT.G_ALLOCATION_METHOD := 2;
2131: IF PG_DEBUG in ('Y', 'C') THEN
2132: msc_sch_wb.atp_debug('----- ATP4drp Specific Debug Messages -----');
2133: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'PF and Allocated ATP not applicable for DRP plans');
2134: msc_sch_wb.atp_debug('----- ATP4drp Specific Debug Messages -----');

Line 2138: MSC_ATP_PVT.G_ALLOCATED_ATP := MSC_ATP_PVT.G_ORIG_ALLOC_ATP;

2134: msc_sch_wb.atp_debug('----- ATP4drp Specific Debug Messages -----');
2135: END IF;
2136: ELSE
2137: -- ATP4drp set using the original value
2138: MSC_ATP_PVT.G_ALLOCATED_ATP := MSC_ATP_PVT.G_ORIG_ALLOC_ATP;
2139: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'),2);
2140: END IF;
2141: -- End ATP4drp
2142: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;

Line 2139: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'),2);

2135: END IF;
2136: ELSE
2137: -- ATP4drp set using the original value
2138: MSC_ATP_PVT.G_ALLOCATED_ATP := MSC_ATP_PVT.G_ORIG_ALLOC_ATP;
2139: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'),2);
2140: END IF;
2141: -- End ATP4drp
2142: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
2143:

Line 2142: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;

2138: MSC_ATP_PVT.G_ALLOCATED_ATP := MSC_ATP_PVT.G_ORIG_ALLOC_ATP;
2139: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'),2);
2140: END IF;
2141: -- End ATP4drp
2142: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
2143:
2144: IF PG_DEBUG in ('Y', 'C') THEN
2145: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'G_ALLOCATION_METHOD= ' || MSC_ATP_PVT.G_ALLOCATION_METHOD);
2146: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'G_ALLOCATED_ATP= ' || MSC_ATP_PVT.G_ALLOCATED_ATP);

Line 2145: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'G_ALLOCATION_METHOD= ' || MSC_ATP_PVT.G_ALLOCATION_METHOD);

2141: -- End ATP4drp
2142: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
2143:
2144: IF PG_DEBUG in ('Y', 'C') THEN
2145: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'G_ALLOCATION_METHOD= ' || MSC_ATP_PVT.G_ALLOCATION_METHOD);
2146: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'G_ALLOCATED_ATP= ' || MSC_ATP_PVT.G_ALLOCATED_ATP);
2147: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'INV_CTP= ' || MSC_ATP_PVT.G_INV_CTP);
2148: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'p_mode= ' || p_mode);
2149: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'p_identifier= ' || p_identifier);

Line 2146: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'G_ALLOCATED_ATP= ' || MSC_ATP_PVT.G_ALLOCATED_ATP);

2142: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
2143:
2144: IF PG_DEBUG in ('Y', 'C') THEN
2145: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'G_ALLOCATION_METHOD= ' || MSC_ATP_PVT.G_ALLOCATION_METHOD);
2146: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'G_ALLOCATED_ATP= ' || MSC_ATP_PVT.G_ALLOCATED_ATP);
2147: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'INV_CTP= ' || MSC_ATP_PVT.G_INV_CTP);
2148: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'p_mode= ' || p_mode);
2149: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'p_identifier= ' || p_identifier);
2150: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'p_instance_id = '||p_instance_id);

Line 2147: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'INV_CTP= ' || MSC_ATP_PVT.G_INV_CTP);

2143:
2144: IF PG_DEBUG in ('Y', 'C') THEN
2145: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'G_ALLOCATION_METHOD= ' || MSC_ATP_PVT.G_ALLOCATION_METHOD);
2146: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'G_ALLOCATED_ATP= ' || MSC_ATP_PVT.G_ALLOCATED_ATP);
2147: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'INV_CTP= ' || MSC_ATP_PVT.G_INV_CTP);
2148: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'p_mode= ' || p_mode);
2149: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'p_identifier= ' || p_identifier);
2150: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'p_instance_id = '||p_instance_id);
2151: END IF;

Line 2177: IF p_mode = MSC_ATP_PVT.INVALID or (p_mode=MSC_ATP_PVT.UNDO and p_instance_id is null) THEN

2173: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'Destination inv_item id := ' || c1.dest_inv_item_id);
2174: END IF;
2175: l_organization_id := null;
2176:
2177: IF p_mode = MSC_ATP_PVT.INVALID or (p_mode=MSC_ATP_PVT.UNDO and p_instance_id is null) THEN
2178:
2179: MSC_ATP_DB_UTILS.Delete_Pegging(c1.pegging_id);
2180:
2181: IF PG_DEBUG in ('Y', 'C') THEN

Line 2210: ((MSC_ATP_PVT.G_INV_CTP = 4) AND

2206:
2207: -- time_phased_atp
2208: IF (c1.aggregate_time_fence_date is not null)
2209: OR
2210: ((MSC_ATP_PVT.G_INV_CTP = 4) AND
2211: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
2212: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
2213: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
2214:

Line 2211: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

2207: -- time_phased_atp
2208: IF (c1.aggregate_time_fence_date is not null)
2209: OR
2210: ((MSC_ATP_PVT.G_INV_CTP = 4) AND
2211: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
2212: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
2213: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
2214:
2215: IF PG_DEBUG in ('Y', 'C') THEN

Line 2212: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

2208: IF (c1.aggregate_time_fence_date is not null)
2209: OR
2210: ((MSC_ATP_PVT.G_INV_CTP = 4) AND
2211: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
2212: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
2213: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
2214:
2215: IF PG_DEBUG in ('Y', 'C') THEN
2216: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: before delete of ' ||

Line 2213: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

2209: OR
2210: ((MSC_ATP_PVT.G_INV_CTP = 4) AND
2211: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
2212: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
2213: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
2214:
2215: IF PG_DEBUG in ('Y', 'C') THEN
2216: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: before delete of ' ||
2217: ' msc_alloc_supplies');

Line 2326: ((MSC_ATP_PVT.G_INV_CTP = 4) AND

2322:
2323: -- time_phased_atp
2324: IF (c1.aggregate_time_fence_date is not null)
2325: OR
2326: ((MSC_ATP_PVT.G_INV_CTP = 4) AND
2327: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
2328: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
2329: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
2330:

Line 2327: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

2323: -- time_phased_atp
2324: IF (c1.aggregate_time_fence_date is not null)
2325: OR
2326: ((MSC_ATP_PVT.G_INV_CTP = 4) AND
2327: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
2328: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
2329: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
2330:
2331: IF PG_DEBUG in ('Y', 'C') THEN

Line 2328: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

2324: IF (c1.aggregate_time_fence_date is not null)
2325: OR
2326: ((MSC_ATP_PVT.G_INV_CTP = 4) AND
2327: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
2328: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
2329: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
2330:
2331: IF PG_DEBUG in ('Y', 'C') THEN
2332: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: before delete of' ||

Line 2329: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

2325: OR
2326: ((MSC_ATP_PVT.G_INV_CTP = 4) AND
2327: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
2328: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
2329: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
2330:
2331: IF PG_DEBUG in ('Y', 'C') THEN
2332: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: before delete of' ||
2333: ' msc_alloc_demands');

Line 2457: IF (MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y') AND G_ORIG_INV_CTP = 5 THEN

2453: IF PG_DEBUG in ('Y', 'C') THEN
2454: msc_sch_wb.atp_debug('Rows deleted := ' || SQL%ROWCOUNT);
2455: END IF;
2456:
2457: IF (MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y') AND G_ORIG_INV_CTP = 5 THEN
2458: -- Condition for INV_CTP added for bug 3295831 because summary
2459: -- is not supported in PDS-ODS switch.
2460: IF PG_DEBUG in ('Y', 'C') THEN
2461: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'Update summary sales order tbale');

Line 2633: AND session_id = MSC_ATP_PVT.G_SESSION_ID

2629: , last_update_date = sysdate
2630: , last_updated_by = FND_GLOBAL.USER_ID
2631: , last_update_login = FND_GLOBAL.USER_ID
2632: WHERE pegging_id = p_pegging_id
2633: AND session_id = MSC_ATP_PVT.G_SESSION_ID
2634: AND record_type = 3;
2635:
2636: IF PG_DEBUG in ('Y', 'C') THEN
2637: msc_sch_wb.atp_debug('End Update_Pegging');

Line 2659: p_mode IN NUMBER := MSC_ATP_PVT.UNDO,

2655: p_start_date IN DATE, -- Bug 3241766
2656: p_order_date IN DATE, -- Bug 3241766
2657: p_mem_item_id IN NUMBER, -- Bug 3293163
2658: p_pf_item_id IN NUMBER,
2659: p_mode IN NUMBER := MSC_ATP_PVT.UNDO,
2660: p_uom_conv_rate IN NUMBER := NULL
2661: )
2662: IS
2663:

Line 2715: AND session_id = MSC_ATP_PVT.G_SESSION_ID ;

2711: , l_receive_org_id, l_organization_id, l_instance_id -- ATP4drp
2712: FROM mrp_atp_details_temp
2713: WHERE pegging_id = p_pegging_id
2714: AND record_type = 3
2715: AND session_id = MSC_ATP_PVT.G_SESSION_ID ;
2716:
2717: IF PG_DEBUG in ('Y', 'C') THEN
2718: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'after select');
2719: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'l_sd_date := ' || l_sd_date);

Line 2732: IF NVL(p_quantity, -1) = 0 AND (MSC_ATP_PVT.G_DIAGNOSTIC_ATP <> 1 or p_mode = MSC_ATP_PVT.INVALID) THEN

2728: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'l_transaction_id := ' || l_transaction_id);
2729: -- ATP4drp print out organizations
2730: END IF;
2731: --diag_ATP: Do not remove the planned order in diagnostic mode even if the quantity is zero
2732: IF NVL(p_quantity, -1) = 0 AND (MSC_ATP_PVT.G_DIAGNOSTIC_ATP <> 1 or p_mode = MSC_ATP_PVT.INVALID) THEN
2733:
2734: MSC_ATP_DB_UTILS.Remove_Invalid_SD_Rec(
2735: p_pegging_id,
2736: null,

Line 2738: MSC_ATP_PVT.UNDO,

2734: MSC_ATP_DB_UTILS.Remove_Invalid_SD_Rec(
2735: p_pegging_id,
2736: null,
2737: p_plan_id,
2738: MSC_ATP_PVT.UNDO,
2739: 0,
2740: l_return_status);
2741:
2742: IF PG_DEBUG in ('Y', 'C') THEN

Line 2747: IF MSC_ATP_PVT.G_INV_CTP = 4 THEN

2743: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'after delete mrp_atp_details_temp by calling remove');
2744: END IF;
2745:
2746: --s_cto_rearch
2747: IF MSC_ATP_PVT.G_INV_CTP = 4 THEN
2748: DELETE from msc_supplies
2749: WHERE plan_id = p_plan_id
2750: AND transaction_id = l_transaction_id;
2751: END IF;

Line 2770: IF MSC_ATP_PVT.G_INV_CTP = 4 THEN

2766: END IF;
2767:
2768: -- For bug 2259824, move the supply to the end of day
2769: --s_cto_rearch:
2770: IF MSC_ATP_PVT.G_INV_CTP = 4 THEN
2771: UPDATE msc_supplies
2772: SET new_schedule_date = TRUNC(NVL(p_date, new_schedule_date)) + MSC_ATP_PVT.G_END_OF_DAY ,
2773: new_order_quantity = NVL(p_quantity, new_order_quantity),
2774: -- rajjain 02/19/2003 Bug 2788302 Begin

Line 2772: SET new_schedule_date = TRUNC(NVL(p_date, new_schedule_date)) + MSC_ATP_PVT.G_END_OF_DAY ,

2768: -- For bug 2259824, move the supply to the end of day
2769: --s_cto_rearch:
2770: IF MSC_ATP_PVT.G_INV_CTP = 4 THEN
2771: UPDATE msc_supplies
2772: SET new_schedule_date = TRUNC(NVL(p_date, new_schedule_date)) + MSC_ATP_PVT.G_END_OF_DAY ,
2773: new_order_quantity = NVL(p_quantity, new_order_quantity),
2774: -- rajjain 02/19/2003 Bug 2788302 Begin
2775: supplier_id = Decode(p_supplier_id,
2776: -1,null,

Line 2783: new_dock_date = TRUNC(NVL(p_dock_date, new_dock_date)) + MSC_ATP_PVT.G_END_OF_DAY,

2779: -1,null,
2780: p_supplier_site_id),
2781: -- rajjain 02/19/2003 Bug 2788302 End
2782: -- Bug 3821358, Making the dates at the end of the day
2783: new_dock_date = TRUNC(NVL(p_dock_date, new_dock_date)) + MSC_ATP_PVT.G_END_OF_DAY,
2784: -- rajjain 02/19/2003 Bug 2788302 Begin
2785: source_supplier_id = decode(p_supplier_id,
2786: -1,null,
2787: p_supplier_id),

Line 2798: new_ship_date = TRUNC(NVL(p_ship_date,new_ship_date)) + MSC_ATP_PVT.G_END_OF_DAY, -- Bug 3241766

2794: source_organization_id = Decode(NVL(p_supplier_id,-1), -1, l_organization_id, NULL), --4767922
2795: source_sr_instance_id = DEcode(NVL(p_supplier_id,-1), -1, l_instance_id, NULL), --4767922
2796: -- End ATP4drp
2797: -- Bug 3821358, Making the dates at the end of the day
2798: new_ship_date = TRUNC(NVL(p_ship_date,new_ship_date)) + MSC_ATP_PVT.G_END_OF_DAY, -- Bug 3241766
2799: new_wip_start_date = TRUNC(NVL(p_start_date,new_wip_start_date)) + MSC_ATP_PVT.G_END_OF_DAY, -- Bug 3241766
2800: new_order_placement_date = TRUNC(NVL(p_order_date,new_order_placement_date)) + MSC_ATP_PVT.G_END_OF_DAY -- Bug 3241766
2801:
2802: WHERE plan_id = p_plan_id

Line 2799: new_wip_start_date = TRUNC(NVL(p_start_date,new_wip_start_date)) + MSC_ATP_PVT.G_END_OF_DAY, -- Bug 3241766

2795: source_sr_instance_id = DEcode(NVL(p_supplier_id,-1), -1, l_instance_id, NULL), --4767922
2796: -- End ATP4drp
2797: -- Bug 3821358, Making the dates at the end of the day
2798: new_ship_date = TRUNC(NVL(p_ship_date,new_ship_date)) + MSC_ATP_PVT.G_END_OF_DAY, -- Bug 3241766
2799: new_wip_start_date = TRUNC(NVL(p_start_date,new_wip_start_date)) + MSC_ATP_PVT.G_END_OF_DAY, -- Bug 3241766
2800: new_order_placement_date = TRUNC(NVL(p_order_date,new_order_placement_date)) + MSC_ATP_PVT.G_END_OF_DAY -- Bug 3241766
2801:
2802: WHERE plan_id = p_plan_id
2803: AND transaction_id = l_transaction_id

Line 2800: new_order_placement_date = TRUNC(NVL(p_order_date,new_order_placement_date)) + MSC_ATP_PVT.G_END_OF_DAY -- Bug 3241766

2796: -- End ATP4drp
2797: -- Bug 3821358, Making the dates at the end of the day
2798: new_ship_date = TRUNC(NVL(p_ship_date,new_ship_date)) + MSC_ATP_PVT.G_END_OF_DAY, -- Bug 3241766
2799: new_wip_start_date = TRUNC(NVL(p_start_date,new_wip_start_date)) + MSC_ATP_PVT.G_END_OF_DAY, -- Bug 3241766
2800: new_order_placement_date = TRUNC(NVL(p_order_date,new_order_placement_date)) + MSC_ATP_PVT.G_END_OF_DAY -- Bug 3241766
2801:
2802: WHERE plan_id = p_plan_id
2803: AND transaction_id = l_transaction_id
2804: returning inventory_item_id, sr_instance_id, organization_id

Line 2835: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND

2831: RAISE FND_API.G_EXC_ERROR;
2832: END IF;
2833:
2834: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
2835: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
2836: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
2837: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
2838: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
2839:

Line 2836: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

2832: END IF;
2833:
2834: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
2835: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
2836: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
2837: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
2838: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
2839:
2840: IF PG_DEBUG in ('Y', 'C') THEN

Line 2837: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

2833:
2834: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
2835: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
2836: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
2837: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
2838: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
2839:
2840: IF PG_DEBUG in ('Y', 'C') THEN
2841: msc_sch_wb.atp_debug('Update_Planned_Order: before update of' ||

Line 2838: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

2834: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
2835: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
2836: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
2837: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
2838: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
2839:
2840: IF PG_DEBUG in ('Y', 'C') THEN
2841: msc_sch_wb.atp_debug('Update_Planned_Order: before update of' ||
2842: ' msc_alloc_supplies');

Line 3009: AND session_id = MSC_ATP_PVT.G_SESSION_ID;

3005: l_supplier_atp_date, l_summary_flag
3006: FROM mrp_atp_details_temp
3007: WHERE parent_pegging_id = p_pegging_id
3008: AND record_type = 3
3009: AND session_id = MSC_ATP_PVT.G_SESSION_ID;
3010:
3011: EXCEPTION
3012: WHEN others THEN
3013: l_demand_id := NULL;

Line 3038: IF MSC_ATP_PVT.G_DIAGNOSTIC_ATP <> 1 THEN

3034: END IF;
3035: l_inventory_item_id := null;
3036:
3037: -- dsting diag_atp do not adjust demands
3038: IF MSC_ATP_PVT.G_DIAGNOSTIC_ATP <> 1 THEN
3039:
3040: l_prim_uom_dmd_qty := p_quantity * nvl(p_uom_conv_rate, 1);
3041:
3042: UPDATE msc_demands

Line 3080: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND

3076: RAISE FND_API.G_EXC_ERROR;
3077: END IF;
3078:
3079: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
3080: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
3081: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
3082: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
3083: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
3084:

Line 3081: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

3077: END IF;
3078:
3079: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
3080: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
3081: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
3082: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
3083: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
3084:
3085: IF PG_DEBUG in ('Y', 'C') THEN

Line 3082: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

3078:
3079: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
3080: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
3081: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
3082: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
3083: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
3084:
3085: IF PG_DEBUG in ('Y', 'C') THEN
3086: msc_sch_wb.atp_debug('Update_Planned_Order: before update of' ||

Line 3083: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

3079: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
3080: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
3081: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
3082: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
3083: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
3084:
3085: IF PG_DEBUG in ('Y', 'C') THEN
3086: msc_sch_wb.atp_debug('Update_Planned_Order: before update of' ||
3087: ' msc_alloc_demands');

Line 3136: ELSIF p_quantity IS NOT NULL and NVL(MSC_ATP_PVT.G_PLAN_INFO_REC.plan_type, 1) = 5 THEN

3132: END IF;
3133: **/
3134: END IF; -- if not DIAGNOSTIC ATP then update demands
3135: --5239441
3136: ELSIF p_quantity IS NOT NULL and NVL(MSC_ATP_PVT.G_PLAN_INFO_REC.plan_type, 1) = 5 THEN
3137: IF PG_DEBUG in ('Y', 'C') THEN
3138: msc_sch_wb.atp_debug('Update_Planned_Order: ' || 'l_demand_id := '|| l_demand_id);
3139: END IF;
3140: l_prim_uom_dmd_qty := p_quantity * nvl(p_uom_conv_rate, 1);

Line 3216: --SET required_date = TRUNC(NVL(p_supply_demand_date, required_date)) + MSC_ATP_PVT.G_END_OF_DAY

3212: -- dsting ATO 2465370
3213: BEGIN
3214: UPDATE mrp_atp_details_temp
3215: --bug 3328421
3216: --SET required_date = TRUNC(NVL(p_supply_demand_date, required_date)) + MSC_ATP_PVT.G_END_OF_DAY
3217: SET actual_supply_demand_date = TRUNC(NVL(p_supply_demand_date, actual_supply_demand_date)) + MSC_ATP_PVT.G_END_OF_DAY
3218: WHERE pegging_id = MSC_ATP_PVT.G_DEMAND_PEGGING_ID
3219: AND session_id = MSC_ATP_PVT.G_SESSION_ID
3220: AND record_type = 3

Line 3217: SET actual_supply_demand_date = TRUNC(NVL(p_supply_demand_date, actual_supply_demand_date)) + MSC_ATP_PVT.G_END_OF_DAY

3213: BEGIN
3214: UPDATE mrp_atp_details_temp
3215: --bug 3328421
3216: --SET required_date = TRUNC(NVL(p_supply_demand_date, required_date)) + MSC_ATP_PVT.G_END_OF_DAY
3217: SET actual_supply_demand_date = TRUNC(NVL(p_supply_demand_date, actual_supply_demand_date)) + MSC_ATP_PVT.G_END_OF_DAY
3218: WHERE pegging_id = MSC_ATP_PVT.G_DEMAND_PEGGING_ID
3219: AND session_id = MSC_ATP_PVT.G_SESSION_ID
3220: AND record_type = 3
3221: RETURNING identifier3, summary_flag INTO l_demand_id, l_summary_flag;

Line 3218: WHERE pegging_id = MSC_ATP_PVT.G_DEMAND_PEGGING_ID

3214: UPDATE mrp_atp_details_temp
3215: --bug 3328421
3216: --SET required_date = TRUNC(NVL(p_supply_demand_date, required_date)) + MSC_ATP_PVT.G_END_OF_DAY
3217: SET actual_supply_demand_date = TRUNC(NVL(p_supply_demand_date, actual_supply_demand_date)) + MSC_ATP_PVT.G_END_OF_DAY
3218: WHERE pegging_id = MSC_ATP_PVT.G_DEMAND_PEGGING_ID
3219: AND session_id = MSC_ATP_PVT.G_SESSION_ID
3220: AND record_type = 3
3221: RETURNING identifier3, summary_flag INTO l_demand_id, l_summary_flag;
3222: EXCEPTION

Line 3219: AND session_id = MSC_ATP_PVT.G_SESSION_ID

3215: --bug 3328421
3216: --SET required_date = TRUNC(NVL(p_supply_demand_date, required_date)) + MSC_ATP_PVT.G_END_OF_DAY
3217: SET actual_supply_demand_date = TRUNC(NVL(p_supply_demand_date, actual_supply_demand_date)) + MSC_ATP_PVT.G_END_OF_DAY
3218: WHERE pegging_id = MSC_ATP_PVT.G_DEMAND_PEGGING_ID
3219: AND session_id = MSC_ATP_PVT.G_SESSION_ID
3220: AND record_type = 3
3221: RETURNING identifier3, summary_flag INTO l_demand_id, l_summary_flag;
3222: EXCEPTION
3223: WHEN OTHERS THEN

Line 3230: msc_sch_wb.atp_debug('ATO update pegging id ' || MSC_ATP_PVT.G_DEMAND_PEGGING_ID);

3226: RETURN;
3227: END;
3228:
3229: IF PG_DEBUG in ('Y','C') THEN
3230: msc_sch_wb.atp_debug('ATO update pegging id ' || MSC_ATP_PVT.G_DEMAND_PEGGING_ID);
3231: END IF;
3232:
3233: IF p_plan_id = -1 THEN
3234: -- ngoel, changed for performance reason, don't

Line 3239: SET REQUIREMENT_DATE = TRUNC(p_supply_demand_date) + MSC_ATP_PVT.G_END_OF_DAY,

3235: -- do anything in case p_supply_demand_date is NULL.
3236: IF p_supply_demand_date IS NOT NULL THEN
3237: -- For bug 2259824, move the demand to the end of day
3238: UPDATE MSC_SALES_ORDERS
3239: SET REQUIREMENT_DATE = TRUNC(p_supply_demand_date) + MSC_ATP_PVT.G_END_OF_DAY,
3240: REQUEST_DATE = TRUNC(p_request_arrival_date),--plan by request date
3241: SCHEDULE_ARRIVAL_DATE = TRUNC(p_sch_arrival_date) + MSC_ATP_PVT.G_END_OF_DAY, --plan by request date
3242: LATEST_ACCEPTABLE_DATE = p_lat_date,
3243: ORDER_DATE_TYPE_CODE = p_order_date_type,

Line 3241: SCHEDULE_ARRIVAL_DATE = TRUNC(p_sch_arrival_date) + MSC_ATP_PVT.G_END_OF_DAY, --plan by request date

3237: -- For bug 2259824, move the demand to the end of day
3238: UPDATE MSC_SALES_ORDERS
3239: SET REQUIREMENT_DATE = TRUNC(p_supply_demand_date) + MSC_ATP_PVT.G_END_OF_DAY,
3240: REQUEST_DATE = TRUNC(p_request_arrival_date),--plan by request date
3241: SCHEDULE_ARRIVAL_DATE = TRUNC(p_sch_arrival_date) + MSC_ATP_PVT.G_END_OF_DAY, --plan by request date
3242: LATEST_ACCEPTABLE_DATE = p_lat_date,
3243: ORDER_DATE_TYPE_CODE = p_order_date_type,
3244: SHIP_SET_NAME = p_ship_set_name, --plan by request date
3245: ARRIVAL_SET_NAME = p_arrival_set_name, --plan by request date

Line 3254: IF (MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y') AND NVL(l_inventory_item_id, 0) > 0

3250: -- dsting ATO 2465370 I already selected l_demand_id
3251: AND DEMAND_ID = l_demand_id
3252: returning demand_class, inventory_item_id into l_demand_class, l_inventory_item_id;
3253:
3254: IF (MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y') AND NVL(l_inventory_item_id, 0) > 0
3255: AND G_ORIG_INV_CTP = 5 THEN -- Condition added for bug 3295831 because summary
3256: -- is not supported in PDS-ODS switch.
3257: IF PG_DEBUG in ('Y', 'C') THEN
3258: msc_sch_wb.atp_debug('Update_SD_Date: ' || 'Summary Flag is on');

Line 3266: where pegging_id = MSC_ATP_PVT.G_DEMAND_PEGGING_ID

3262: --- G_DEMAND_PEGGING_ID wil be null for non atpbale items
3263: select supply_demand_quantity, supply_demand_date, organization_id
3264: into l_sd_qty, l_sd_date, l_org_id
3265: from mrp_atp_details_temp
3266: where pegging_id = MSC_ATP_PVT.G_DEMAND_PEGGING_ID
3267: and session_id = MSC_ATP_PVT.G_SESSION_ID
3268: and record_type = 3;
3269: EXCEPTION
3270: WHEN OTHERS THEN

Line 3267: and session_id = MSC_ATP_PVT.G_SESSION_ID

3263: select supply_demand_quantity, supply_demand_date, organization_id
3264: into l_sd_qty, l_sd_date, l_org_id
3265: from mrp_atp_details_temp
3266: where pegging_id = MSC_ATP_PVT.G_DEMAND_PEGGING_ID
3267: and session_id = MSC_ATP_PVT.G_SESSION_ID
3268: and record_type = 3;
3269: EXCEPTION
3270: WHEN OTHERS THEN
3271: l_sd_qty := null;

Line 3424: SCHEDULE_SHIP_DATE = TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

3420:
3421: UPDATE MSC_DEMANDS
3422: SET
3423: --start changes for plan by request date
3424: SCHEDULE_SHIP_DATE = TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3425: USING_ASSEMBLY_DEMAND_DATE =
3426: decode(ORIGINATION_TYPE,
3427: 6, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
3428: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,

Line 3427: 6, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,

3423: --start changes for plan by request date
3424: SCHEDULE_SHIP_DATE = TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3425: USING_ASSEMBLY_DEMAND_DATE =
3426: decode(ORIGINATION_TYPE,
3427: 6, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
3428: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
3429: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3430: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
3431: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

Line 3428: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,

3424: SCHEDULE_SHIP_DATE = TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3425: USING_ASSEMBLY_DEMAND_DATE =
3426: decode(ORIGINATION_TYPE,
3427: 6, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
3428: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
3429: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3430: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
3431: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3432: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,

Line 3429: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

3425: USING_ASSEMBLY_DEMAND_DATE =
3426: decode(ORIGINATION_TYPE,
3427: 6, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
3428: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
3429: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3430: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
3431: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3432: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
3433: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

Line 3430: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,

3426: decode(ORIGINATION_TYPE,
3427: 6, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
3428: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
3429: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3430: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
3431: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3432: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
3433: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3434: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,

Line 3431: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

3427: 6, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
3428: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
3429: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3430: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
3431: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3432: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
3433: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3434: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
3435: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

Line 3432: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,

3428: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
3429: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3430: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
3431: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3432: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
3433: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3434: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
3435: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3436: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,

Line 3433: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

3429: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3430: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
3431: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3432: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
3433: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3434: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
3435: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3436: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
3437: REQUEST_SHIP_DATE,

Line 3434: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,

3430: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
3431: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3432: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
3433: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3434: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
3435: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3436: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
3437: REQUEST_SHIP_DATE,
3438: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,

Line 3435: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

3431: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3432: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
3433: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3434: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
3435: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3436: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
3437: REQUEST_SHIP_DATE,
3438: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
3439: REQUEST_SHIP_DATE,

Line 3436: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,

3432: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
3433: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3434: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
3435: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3436: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
3437: REQUEST_SHIP_DATE,
3438: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
3439: REQUEST_SHIP_DATE,
3440: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),

Line 3438: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,

3434: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
3435: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3436: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
3437: REQUEST_SHIP_DATE,
3438: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
3439: REQUEST_SHIP_DATE,
3440: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),
3441: 30, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
3442: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,

Line 3440: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),

3436: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
3437: REQUEST_SHIP_DATE,
3438: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
3439: REQUEST_SHIP_DATE,
3440: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),
3441: 30, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
3442: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
3443: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3444: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,

Line 3441: 30, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,

3437: REQUEST_SHIP_DATE,
3438: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
3439: REQUEST_SHIP_DATE,
3440: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),
3441: 30, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
3442: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
3443: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3444: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
3445: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

Line 3442: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,

3438: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
3439: REQUEST_SHIP_DATE,
3440: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),
3441: 30, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
3442: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
3443: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3444: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
3445: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3446: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,

Line 3443: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

3439: REQUEST_SHIP_DATE,
3440: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),
3441: 30, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
3442: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
3443: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3444: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
3445: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3446: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
3447: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

Line 3444: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,

3440: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),
3441: 30, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
3442: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
3443: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3444: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
3445: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3446: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
3447: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3448: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,

Line 3445: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

3441: 30, decode(MSC_ATP_PVT.G_PLAN_INFO_REC.schedule_by_date_type,
3442: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
3443: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3444: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
3445: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3446: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
3447: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3448: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
3449: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

Line 3446: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,

3442: MSC_ATP_PVT.G_SCHEDULE_SHIP_DATE_LEGEND,
3443: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3444: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
3445: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3446: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
3447: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3448: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
3449: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3450: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,

Line 3447: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

3443: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3444: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
3445: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3446: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
3447: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3448: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
3449: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3450: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
3451: REQUEST_SHIP_DATE,

Line 3448: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,

3444: MSC_ATP_PVT.G_SCHEDULE_ARRIVAL_DATE_LEGEND,
3445: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3446: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
3447: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3448: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
3449: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3450: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
3451: REQUEST_SHIP_DATE,
3452: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,

Line 3449: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

3445: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3446: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
3447: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3448: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
3449: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3450: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
3451: REQUEST_SHIP_DATE,
3452: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
3453: REQUEST_SHIP_DATE,

Line 3450: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,

3446: MSC_ATP_PVT.G_PROMISE_SHIP_DATE_LEGEND,
3447: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3448: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
3449: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3450: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
3451: REQUEST_SHIP_DATE,
3452: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
3453: REQUEST_SHIP_DATE,
3454: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),

Line 3452: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,

3448: MSC_ATP_PVT.G_PROMISE_ARRIVAL_DATE_LEGEND,
3449: TRUNC(NVL(p_supply_demand_date,PROMISE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3450: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
3451: REQUEST_SHIP_DATE,
3452: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
3453: REQUEST_SHIP_DATE,
3454: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),
3455: TRUNC(NVL(p_supply_demand_date,USING_ASSEMBLY_DEMAND_DATE)) + MSC_ATP_PVT.G_END_OF_DAY), --plan by request date
3456: promise_ship_date = TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY, --plan by request date

Line 3454: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),

3450: MSC_ATP_PVT.G_REQUEST_SHIP_DATE_LEGEND,
3451: REQUEST_SHIP_DATE,
3452: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
3453: REQUEST_SHIP_DATE,
3454: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),
3455: TRUNC(NVL(p_supply_demand_date,USING_ASSEMBLY_DEMAND_DATE)) + MSC_ATP_PVT.G_END_OF_DAY), --plan by request date
3456: promise_ship_date = TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY, --plan by request date
3457: request_date = p_request_arrival_date, --plan by request date
3458: promise_date = p_sch_arrival_date, --plan by request date

Line 3455: TRUNC(NVL(p_supply_demand_date,USING_ASSEMBLY_DEMAND_DATE)) + MSC_ATP_PVT.G_END_OF_DAY), --plan by request date

3451: REQUEST_SHIP_DATE,
3452: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
3453: REQUEST_SHIP_DATE,
3454: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),
3455: TRUNC(NVL(p_supply_demand_date,USING_ASSEMBLY_DEMAND_DATE)) + MSC_ATP_PVT.G_END_OF_DAY), --plan by request date
3456: promise_ship_date = TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY, --plan by request date
3457: request_date = p_request_arrival_date, --plan by request date
3458: promise_date = p_sch_arrival_date, --plan by request date
3459: ship_set_name = p_ship_set_name, --plan by request date

Line 3456: promise_ship_date = TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY, --plan by request date

3452: MSC_ATP_PVT.G_REQUEST_ARRIVAL_DATE_LEGEND,
3453: REQUEST_SHIP_DATE,
3454: TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY),
3455: TRUNC(NVL(p_supply_demand_date,USING_ASSEMBLY_DEMAND_DATE)) + MSC_ATP_PVT.G_END_OF_DAY), --plan by request date
3456: promise_ship_date = TRUNC(NVL(p_supply_demand_date,SCHEDULE_SHIP_DATE)) + MSC_ATP_PVT.G_END_OF_DAY, --plan by request date
3457: request_date = p_request_arrival_date, --plan by request date
3458: promise_date = p_sch_arrival_date, --plan by request date
3459: ship_set_name = p_ship_set_name, --plan by request date
3460: arrival_set_name = p_arrival_set_name, --plan by request date

Line 3467: DMD_SATISFIED_DATE = TRUNC(GREATEST(p_dmd_satisfied_date,DMD_SATISFIED_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,

3463: USING_REQUIREMENT_QUANTITY = MSC_ATP_UTILS.Truncate_Demand(NVL(p_supply_demand_qty,USING_REQUIREMENT_QUANTITY)), -- Bug 1501787
3464: -- 24x7 -- 5598066
3465: ATP_SYNCHRONIZATION_FLAG = 0,
3466: -- bug 2795053-reopen (ssurendr) update the demand_satisfied_date in msc_demands
3467: DMD_SATISFIED_DATE = TRUNC(GREATEST(p_dmd_satisfied_date,DMD_SATISFIED_DATE)) + MSC_ATP_PVT.G_END_OF_DAY,
3468: -- ship_rec_cal changes begin
3469: SCHEDULE_ARRIVAL_DATE = NVL(p_sch_arrival_date, SCHEDULE_ARRIVAL_DATE),
3470: ORDER_DATE_TYPE_CODE = NVL(p_order_date_type, ORDER_DATE_TYPE_CODE),
3471: LATEST_ACCEPTABLE_DATE = NVL(p_lat_date, LATEST_ACCEPTABLE_DATE)

Line 3501: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND

3497: END IF;
3498: -- time_phased_atp changes end
3499:
3500: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
3501: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
3502: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
3503: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
3504: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
3505:

Line 3502: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

3498: -- time_phased_atp changes end
3499:
3500: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
3501: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
3502: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
3503: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
3504: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
3505:
3506: IF PG_DEBUG in ('Y', 'C') THEN

Line 3503: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

3499:
3500: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
3501: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
3502: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
3503: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
3504: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
3505:
3506: IF PG_DEBUG in ('Y', 'C') THEN
3507: msc_sch_wb.atp_debug('Update_SD_Date: before update of ' ||

Line 3504: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

3500: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
3501: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
3502: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
3503: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
3504: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
3505:
3506: IF PG_DEBUG in ('Y', 'C') THEN
3507: msc_sch_wb.atp_debug('Update_SD_Date: before update of ' ||
3508: ' msc_alloc_demands');

Line 3635: IF (MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y') and p_plan_id = -1 AND G_ORIG_INV_CTP = 5 THEN

3631: END IF; -- if p_summly_demand_qty is not null or....
3632: END IF ; -- if plan_id = -1
3633:
3634: -- commit removed for PDS cases - summary enhancement
3635: IF (MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y') and p_plan_id = -1 AND G_ORIG_INV_CTP = 5 THEN
3636: -- Condition for INV_CTP added for bug 3295831 because summary
3637: -- is not supported in PDS-ODS switch.
3638: commit;
3639: END IF;

Line 3731: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' THEN

3727: IF PG_DEBUG in ('Y', 'C') THEN
3728: msc_sch_wb.atp_debug('Number of SO lines updated := ' || SQL%ROWCOUNT);
3729: END IF;
3730: --5357370
3731: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' THEN
3732: IF PG_DEBUG in ('Y', 'C') THEN
3733: msc_sch_wb.atp_debug('Inside summary mode set to yes');
3734: msc_sch_wb.atp_debug('p_identifiers.count := ' || p_identifiers.count);
3735: END IF;

Line 3814: IF (MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y') and (p_copy_demand_ids IS NOT NULL) and (p_copy_demand_ids.COUNT > 0) THEN

3810: SQL%BULK_ROWCOUNT(m)||' records');
3811: END LOOP;
3812: END IF;
3813:
3814: IF (MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y') and (p_copy_demand_ids IS NOT NULL) and (p_copy_demand_ids.COUNT > 0) THEN
3815: -- Code to update summary records removed for summary enhancement
3816: /** code commented for time being. Will be removed after code review
3817: IF PG_DEBUG in ('Y', 'C') THEN
3818: msc_sch_wb.atp_debug('Undo_Delete_Row: ' || 'update Demands in summary mode');

Line 3834: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND

3830: p_instance_id);
3831: **/
3832:
3833: -- Delete the copy SOs and copy stealing records for summary enhancement
3834: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
3835: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
3836: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
3837: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) OR
3838: (p_time_phased_set = 'Y') THEN

Line 3835: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

3831: **/
3832:
3833: -- Delete the copy SOs and copy stealing records for summary enhancement
3834: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
3835: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
3836: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
3837: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) OR
3838: (p_time_phased_set = 'Y') THEN
3839:

Line 3836: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

3832:
3833: -- Delete the copy SOs and copy stealing records for summary enhancement
3834: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
3835: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
3836: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
3837: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) OR
3838: (p_time_phased_set = 'Y') THEN
3839:
3840: -- Delete from MSC_ALLOC_DEMANDS

Line 3837: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) OR

3833: -- Delete the copy SOs and copy stealing records for summary enhancement
3834: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
3835: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
3836: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
3837: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) OR
3838: (p_time_phased_set = 'Y') THEN
3839:
3840: -- Delete from MSC_ALLOC_DEMANDS
3841: FORALL i IN 1..p_copy_demand_ids.COUNT

Line 3867: OR ((MSC_ATP_PVT.G_INV_CTP = 4) AND

3863:
3864: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
3865:
3866: IF (p_time_phased_set = 'Y')
3867: OR ((MSC_ATP_PVT.G_INV_CTP = 4) AND
3868: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
3869: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
3870: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
3871:

Line 3868: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

3864: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
3865:
3866: IF (p_time_phased_set = 'Y')
3867: OR ((MSC_ATP_PVT.G_INV_CTP = 4) AND
3868: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
3869: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
3870: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
3871:
3872: IF PG_DEBUG in ('Y', 'C') THEN

Line 3869: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

3865:
3866: IF (p_time_phased_set = 'Y')
3867: OR ((MSC_ATP_PVT.G_INV_CTP = 4) AND
3868: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
3869: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
3870: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
3871:
3872: IF PG_DEBUG in ('Y', 'C') THEN
3873: msc_sch_wb.atp_debug('Undo_Delete_Row: before update of ' ||

Line 3870: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

3866: IF (p_time_phased_set = 'Y')
3867: OR ((MSC_ATP_PVT.G_INV_CTP = 4) AND
3868: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
3869: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
3870: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
3871:
3872: IF PG_DEBUG in ('Y', 'C') THEN
3873: msc_sch_wb.atp_debug('Undo_Delete_Row: before update of ' ||
3874: ' msc_alloc_demands');

Line 4407: p_order_number,MSC_ATP_PVT.G_PARTNER_ID,MSC_ATP_PVT.G_PARTNER_SITE_ID);

4403: p_transaction_id, p_stealing_quantity, 46, p_identifier,p_demand_source_type, 1, ---cmro
4404: FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.USER_ID, sysdate, p_stolen_demand_class,
4405: p_ato_model_line_id, p_refresh_number, -- For summary enhancement
4406: --bug3684383
4407: p_order_number,MSC_ATP_PVT.G_PARTNER_ID,MSC_ATP_PVT.G_PARTNER_SITE_ID);
4408:
4409: l_rows_proc := SQL%ROWCOUNT;
4410:
4411: -- Next add the Stolen Data.

Line 4432: p_order_number,MSC_ATP_PVT.G_PARTNER_ID,MSC_ATP_PVT.G_PARTNER_SITE_ID);

4428: p_transaction_id, -1 * p_stealing_quantity, 47, p_identifier,p_demand_source_type,1, --cmro
4429: FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.USER_ID, sysdate, p_stealing_demand_class,
4430: p_ato_model_line_id, p_refresh_number, -- For summary enhancement
4431: --bug3684383
4432: p_order_number,MSC_ATP_PVT.G_PARTNER_ID,MSC_ATP_PVT.G_PARTNER_SITE_ID);
4433:
4434: l_rows_proc := l_rows_proc + SQL%ROWCOUNT;
4435:
4436: IF PG_DEBUG in ('Y', 'C') THEN

Line 4454: AND session_id = MSC_ATP_PVT.G_SESSION_ID

4450: SELECT pegging_id, identifier1, identifier2, identifier3
4451: FROM mrp_atp_details_temp
4452: WHERE pegging_id = p_pegging_id
4453: AND record_type in (3,4)
4454: AND session_id = MSC_ATP_PVT.G_SESSION_ID
4455: START WITH pegging_id = p_pegging_id
4456: AND session_id = MSC_ATP_PVT.G_SESSION_ID
4457: AND record_type = 3
4458: CONNECT BY parent_pegging_id = PRIOR pegging_id

Line 4456: AND session_id = MSC_ATP_PVT.G_SESSION_ID

4452: WHERE pegging_id = p_pegging_id
4453: AND record_type in (3,4)
4454: AND session_id = MSC_ATP_PVT.G_SESSION_ID
4455: START WITH pegging_id = p_pegging_id
4456: AND session_id = MSC_ATP_PVT.G_SESSION_ID
4457: AND record_type = 3
4458: CONNECT BY parent_pegging_id = PRIOR pegging_id
4459: AND session_id = prior session_id
4460: AND record_type in (3,4);

Line 4527: msc_sch_wb.atp_debug('move_SD_temp_into_mrp_details: ' || ' session_id: ' || MSC_ATP_PVT.G_SESSION_ID);

4523: IF PG_DEBUG in ('Y', 'C') THEN
4524: msc_sch_wb.atp_debug('PROCEDURE move_SD_temp_into_mrp_details');
4525: msc_sch_wb.atp_debug('move_SD_temp_into_mrp_details: ' || ' p_pegging_id: ' || p_pegging_id);
4526: msc_sch_wb.atp_debug('move_SD_temp_into_mrp_details: ' || ' p_end_pegging_id: ' || p_end_pegging_id);
4527: msc_sch_wb.atp_debug('move_SD_temp_into_mrp_details: ' || ' session_id: ' || MSC_ATP_PVT.G_SESSION_ID);
4528: END IF;
4529:
4530: INSERT INTO mrp_atp_details_temp (
4531: session_id,

Line 4581: MSC_ATP_PVT.G_SESSION_ID,

4577: ORIG_REQUEST_DATE, --bug3263368
4578: INVENTORY_ITEM_NAME --bug3579625
4579: )
4580: SELECT
4581: MSC_ATP_PVT.G_SESSION_ID,
4582: scenario_id,
4583: order_line_id,
4584: ATP_Level,
4585: Inventory_Item_Id,

Line 4671: IF ((MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

4667:
4668: msc_sch_wb.atp_debug('Delete_Copy_Demand : ' || 'p_copy_demand_ids.COUNT : ' || p_copy_demand_ids.COUNT);
4669:
4670: IF p_copy_demand_ids.COUNT > 0 THEN
4671: IF ((MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4672: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4673: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) OR
4674: (p_time_phased_set = 'Y') THEN
4675:

Line 4672: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

4668: msc_sch_wb.atp_debug('Delete_Copy_Demand : ' || 'p_copy_demand_ids.COUNT : ' || p_copy_demand_ids.COUNT);
4669:
4670: IF p_copy_demand_ids.COUNT > 0 THEN
4671: IF ((MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4672: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4673: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) OR
4674: (p_time_phased_set = 'Y') THEN
4675:
4676: msc_sch_wb.atp_debug('Delete_Copy_Demand : ' || 'allocated ATP or time phased PF');

Line 4673: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) OR

4669:
4670: IF p_copy_demand_ids.COUNT > 0 THEN
4671: IF ((MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4672: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4673: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) OR
4674: (p_time_phased_set = 'Y') THEN
4675:
4676: msc_sch_wb.atp_debug('Delete_Copy_Demand : ' || 'allocated ATP or time phased PF');
4677:

Line 4688: IF NOT ((MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

4684: WHERE plan_id = p_copy_plan_ids(i));
4685:
4686: END IF;
4687:
4688: IF NOT ((MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4689: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4690: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4691:
4692: msc_sch_wb.atp_debug('Delete_Copy_Demand : ' || 'unallocated ATP');

Line 4689: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

4685:
4686: END IF;
4687:
4688: IF NOT ((MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4689: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4690: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4691:
4692: msc_sch_wb.atp_debug('Delete_Copy_Demand : ' || 'unallocated ATP');
4693:

Line 4690: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

4686: END IF;
4687:
4688: IF NOT ((MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4689: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4690: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4691:
4692: msc_sch_wb.atp_debug('Delete_Copy_Demand : ' || 'unallocated ATP');
4693:
4694: FORALL i IN 1..p_copy_demand_ids.COUNT

Line 4716: p_ship_arrival_date_rec IN MSC_ATP_PVT.ship_arrival_date_rec_typ,

4712: END Delete_Copy_Demand;
4713:
4714: -- New procedure added for ship_rec_cal project
4715: PROCEDURE Flush_Data_In_Pds(
4716: p_ship_arrival_date_rec IN MSC_ATP_PVT.ship_arrival_date_rec_typ,
4717: x_return_status OUT NOCOPY VARCHAR2
4718: )
4719: IS
4720:

Line 4761: p_ship_arrival_date_rec IN MSC_ATP_PVT.ship_arrival_date_rec_typ,

4757: END Flush_Data_In_Pds;
4758:
4759: -- New procedure added for plan by request date project
4760: PROCEDURE Flush_Data_In_Ods(
4761: p_ship_arrival_date_rec IN MSC_ATP_PVT.ship_arrival_date_rec_typ,
4762: x_return_status OUT NOCOPY VARCHAR2
4763: )
4764: IS
4765:

Line 4905: TRUNC(p_supply_rec_type.schedule_date) + MSC_ATP_PVT.G_END_OF_DAY,

4901: FND_GLOBAL.USER_ID,
4902: sysdate,
4903: FND_GLOBAL.USER_ID,
4904: -- For bug 2259824, move the supply to the end of day
4905: TRUNC(p_supply_rec_type.schedule_date) + MSC_ATP_PVT.G_END_OF_DAY,
4906: p_supply_rec_type.disposition_status_type, -- 1512366: open
4907: p_supply_rec_type.supply_type,
4908: p_supply_rec_type.order_quantity,
4909: p_supply_rec_type.supplier_id,

Line 4919: --decode(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 1, p_demand_class, null),

4915: p_supply_rec_type.source_organization_id,
4916: p_supply_rec_type.process_seq_id,
4917: -- rajjain 02/19/2003 Bug 2788302 End
4918: p_supply_rec_type.firm_planned_type,
4919: --decode(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 1, p_demand_class, null),
4920: ---2424357: after demand priority p_demand_class contains converted demand calss
4921: --- we always store the actual demand class passes as a part of the query.
4922: -- Bug 3558125 - Populate '-1' if G_ATP_DEMAND_CLASS is NULL
4923: decode(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 1,NVL(MSC_ATP_PVT.G_ATP_DEMAND_CLASS,'-1'), null),

Line 4923: decode(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 1,NVL(MSC_ATP_PVT.G_ATP_DEMAND_CLASS,'-1'), null),

4919: --decode(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 1, p_demand_class, null),
4920: ---2424357: after demand priority p_demand_class contains converted demand calss
4921: --- we always store the actual demand class passes as a part of the query.
4922: -- Bug 3558125 - Populate '-1' if G_ATP_DEMAND_CLASS is NULL
4923: decode(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 1,NVL(MSC_ATP_PVT.G_ATP_DEMAND_CLASS,'-1'), null),
4924: -- decode(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 1,MSC_ATP_PVT.G_ATP_DEMAND_CLASS, null),
4925: NVL(MSC_ATP_PVT.G_PARTNER_ID,-1), -- Bug 3558125
4926: NVL(MSC_ATP_PVT.G_PARTNER_SITE_ID,-1), -- Bug 3558125
4927: p_supply_rec_type.record_source, -- for plan order pegging

Line 4924: -- decode(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 1,MSC_ATP_PVT.G_ATP_DEMAND_CLASS, null),

4920: ---2424357: after demand priority p_demand_class contains converted demand calss
4921: --- we always store the actual demand class passes as a part of the query.
4922: -- Bug 3558125 - Populate '-1' if G_ATP_DEMAND_CLASS is NULL
4923: decode(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 1,NVL(MSC_ATP_PVT.G_ATP_DEMAND_CLASS,'-1'), null),
4924: -- decode(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 1,MSC_ATP_PVT.G_ATP_DEMAND_CLASS, null),
4925: NVL(MSC_ATP_PVT.G_PARTNER_ID,-1), -- Bug 3558125
4926: NVL(MSC_ATP_PVT.G_PARTNER_SITE_ID,-1), -- Bug 3558125
4927: p_supply_rec_type.record_source, -- for plan order pegging
4928: p_supply_rec_type.refresh_number, -- for summary enhancement

Line 4925: NVL(MSC_ATP_PVT.G_PARTNER_ID,-1), -- Bug 3558125

4921: --- we always store the actual demand class passes as a part of the query.
4922: -- Bug 3558125 - Populate '-1' if G_ATP_DEMAND_CLASS is NULL
4923: decode(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 1,NVL(MSC_ATP_PVT.G_ATP_DEMAND_CLASS,'-1'), null),
4924: -- decode(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 1,MSC_ATP_PVT.G_ATP_DEMAND_CLASS, null),
4925: NVL(MSC_ATP_PVT.G_PARTNER_ID,-1), -- Bug 3558125
4926: NVL(MSC_ATP_PVT.G_PARTNER_SITE_ID,-1), -- Bug 3558125
4927: p_supply_rec_type.record_source, -- for plan order pegging
4928: p_supply_rec_type.refresh_number, -- for summary enhancement
4929: -- ship_rec_cal changes begin

Line 4926: NVL(MSC_ATP_PVT.G_PARTNER_SITE_ID,-1), -- Bug 3558125

4922: -- Bug 3558125 - Populate '-1' if G_ATP_DEMAND_CLASS is NULL
4923: decode(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 1,NVL(MSC_ATP_PVT.G_ATP_DEMAND_CLASS,'-1'), null),
4924: -- decode(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 1,MSC_ATP_PVT.G_ATP_DEMAND_CLASS, null),
4925: NVL(MSC_ATP_PVT.G_PARTNER_ID,-1), -- Bug 3558125
4926: NVL(MSC_ATP_PVT.G_PARTNER_SITE_ID,-1), -- Bug 3558125
4927: p_supply_rec_type.record_source, -- for plan order pegging
4928: p_supply_rec_type.refresh_number, -- for summary enhancement
4929: -- ship_rec_cal changes begin
4930: -- Bug 3821358, Making the dates at the end of the day.

Line 4931: TRUNC(p_supply_rec_type.new_dock_date) + MSC_ATP_PVT.G_END_OF_DAY,

4927: p_supply_rec_type.record_source, -- for plan order pegging
4928: p_supply_rec_type.refresh_number, -- for summary enhancement
4929: -- ship_rec_cal changes begin
4930: -- Bug 3821358, Making the dates at the end of the day.
4931: TRUNC(p_supply_rec_type.new_dock_date) + MSC_ATP_PVT.G_END_OF_DAY,
4932: TRUNC(p_supply_rec_type.new_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
4933: TRUNC(p_supply_rec_type.start_date) + MSC_ATP_PVT.G_END_OF_DAY, -- Bug 3241766
4934: TRUNC(p_supply_rec_type.order_date) + MSC_ATP_PVT.G_END_OF_DAY, -- Bug 3241766
4935: p_supply_rec_type.shipping_cal_code,

Line 4932: TRUNC(p_supply_rec_type.new_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

4928: p_supply_rec_type.refresh_number, -- for summary enhancement
4929: -- ship_rec_cal changes begin
4930: -- Bug 3821358, Making the dates at the end of the day.
4931: TRUNC(p_supply_rec_type.new_dock_date) + MSC_ATP_PVT.G_END_OF_DAY,
4932: TRUNC(p_supply_rec_type.new_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
4933: TRUNC(p_supply_rec_type.start_date) + MSC_ATP_PVT.G_END_OF_DAY, -- Bug 3241766
4934: TRUNC(p_supply_rec_type.order_date) + MSC_ATP_PVT.G_END_OF_DAY, -- Bug 3241766
4935: p_supply_rec_type.shipping_cal_code,
4936: p_supply_rec_type.receiving_cal_code,

Line 4933: TRUNC(p_supply_rec_type.start_date) + MSC_ATP_PVT.G_END_OF_DAY, -- Bug 3241766

4929: -- ship_rec_cal changes begin
4930: -- Bug 3821358, Making the dates at the end of the day.
4931: TRUNC(p_supply_rec_type.new_dock_date) + MSC_ATP_PVT.G_END_OF_DAY,
4932: TRUNC(p_supply_rec_type.new_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
4933: TRUNC(p_supply_rec_type.start_date) + MSC_ATP_PVT.G_END_OF_DAY, -- Bug 3241766
4934: TRUNC(p_supply_rec_type.order_date) + MSC_ATP_PVT.G_END_OF_DAY, -- Bug 3241766
4935: p_supply_rec_type.shipping_cal_code,
4936: p_supply_rec_type.receiving_cal_code,
4937: p_supply_rec_type.intransit_cal_code,

Line 4934: TRUNC(p_supply_rec_type.order_date) + MSC_ATP_PVT.G_END_OF_DAY, -- Bug 3241766

4930: -- Bug 3821358, Making the dates at the end of the day.
4931: TRUNC(p_supply_rec_type.new_dock_date) + MSC_ATP_PVT.G_END_OF_DAY,
4932: TRUNC(p_supply_rec_type.new_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
4933: TRUNC(p_supply_rec_type.start_date) + MSC_ATP_PVT.G_END_OF_DAY, -- Bug 3241766
4934: TRUNC(p_supply_rec_type.order_date) + MSC_ATP_PVT.G_END_OF_DAY, -- Bug 3241766
4935: p_supply_rec_type.shipping_cal_code,
4936: p_supply_rec_type.receiving_cal_code,
4937: p_supply_rec_type.intransit_cal_code,
4938: p_supply_rec_type.ship_method,

Line 4971: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND

4967: RAISE FND_API.G_EXC_ERROR;
4968: END IF;
4969:
4970: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
4971: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
4972: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4973: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4974: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4975:

Line 4972: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

4968: END IF;
4969:
4970: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
4971: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
4972: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4973: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4974: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4975:
4976: IF PG_DEBUG in ('Y', 'C') THEN

Line 4973: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

4969:
4970: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
4971: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
4972: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4973: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4974: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4975:
4976: IF PG_DEBUG in ('Y', 'C') THEN
4977: msc_sch_wb.atp_debug('Add_Supplies: ' || ' before insert into' ||

Line 4974: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

4970: -- Allocated ATP Based on Planning Details -- Agilent changes Begin
4971: ELSIF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
4972: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4973: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4974: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4975:
4976: IF PG_DEBUG in ('Y', 'C') THEN
4977: msc_sch_wb.atp_debug('Add_Supplies: ' || ' before insert into' ||
4978: ' msc_alloc_supplies');

Line 5018: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' THEN

5014: -- Allocated ATP Based on Planning Details -- Agilent changes End
5015:
5016: -- Code to make summary updates and commit removed for summary enhancement
5017: /** code commented for time being. Will be removed after code review
5018: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' THEN
5019: IF PG_DEBUG in ('Y', 'C') THEN
5020: msc_sch_wb.atp_debug('Add_Planned_Order: ' || 'Create planned orders for summary mode');
5021: msc_sch_wb.atp_debug('Add_Planned_Order: ' || 'First try to update ');
5022: END IF;

Line 5082: x_delete_atp_rec OUT NoCopy MSC_ATP_PVT.DELETE_ATP_REC,

5078: Procedure call_delete_row (
5079: p_instance_id IN NUMBER,
5080: p_atp_table IN MRP_ATP_PUB.ATP_Rec_Typ,
5081: p_refresh_number IN NUMBER,
5082: x_delete_atp_rec OUT NoCopy MSC_ATP_PVT.DELETE_ATP_REC,
5083: x_return_status OUT NoCopy VARCHAR2
5084: ) IS
5085: i PLS_INTEGER := 1;
5086: m PLS_INTEGER := 1;

Line 5102: l_plan_info_rec MSC_ATP_PVT.plan_info_rec;

5098: l_time_phased_atp VARCHAR2(1) := 'N';
5099: l_time_phased_set VARCHAR2(1) := 'N';
5100: l_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5101: l_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5102: l_plan_info_rec MSC_ATP_PVT.plan_info_rec;
5103: l_del_demand_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5104: l_del_inv_item_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5105: l_del_plan_ids MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();
5106: l_del_identifiers MRP_ATP_PUB.number_arr:=MRP_ATP_PUB.number_arr();

Line 5141: l_delete_atp_rec MSC_ATP_PVT.DELETE_ATP_REC;

5137: l_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5138: l_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5139: l_del_ods_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5140: l_del_ods_cto_atp_refresh_no MRP_ATP_PUB.Number_Arr := MRP_ATP_PUB.Number_Arr();
5141: l_delete_atp_rec MSC_ATP_PVT.DELETE_ATP_REC;
5142: l_attribute_07 MRP_ATP_PUB.char30_Arr := MRP_ATP_PUB.char30_Arr();
5143:
5144: BEGIN
5145: IF PG_DEBUG in ('Y', 'C') THEN

Line 5171: x_delete_atp_rec.error_code(1) := MSC_ATP_PVT.TRY_ATP_LATER;

5167: -- not available for atp
5168: IF PG_DEBUG in ('Y', 'C') THEN
5169: msc_sch_wb.atp_debug('Call_delete_row: ' || 'ATP not available');
5170: END IF;
5171: x_delete_atp_rec.error_code(1) := MSC_ATP_PVT.TRY_ATP_LATER;
5172: RETURN;
5173:
5174: ELSIF l_summary_flag = 1 THEN
5175: ---- summary table is not ready. Switch to detail tables

Line 5179: MSC_ATP_PVT.G_SUMMARY_FLAG := 'N';

5175: ---- summary table is not ready. Switch to detail tables
5176: IF PG_DEBUG in ('Y', 'C') THEN
5177: msc_sch_wb.atp_debug('Call_delete_row: ' || ' summary table is not ready. Switch to detail tables');
5178: END IF;
5179: MSC_ATP_PVT.G_SUMMARY_FLAG := 'N';
5180:
5181: ELSIF l_summary_flag = 2 THEN
5182: IF PG_DEBUG in ('Y', 'C') THEN
5183: msc_sch_wb.atp_debug('Call_delete_row: ' || 'Summary Concurrent program is running');

Line 5185: x_delete_atp_rec.error_code(1) := MSC_ATP_PVT.SUMM_CONC_PROG_RUNNING;

5181: ELSIF l_summary_flag = 2 THEN
5182: IF PG_DEBUG in ('Y', 'C') THEN
5183: msc_sch_wb.atp_debug('Call_delete_row: ' || 'Summary Concurrent program is running');
5184: END IF;
5185: x_delete_atp_rec.error_code(1) := MSC_ATP_PVT.SUMM_CONC_PROG_RUNNING;
5186: RETURN;
5187: END IF;
5188:
5189: IF (p_atp_table.Action.COUNT > 0 ) THEN

Line 5199: --IF MSC_ATP_PVT.G_INV_CTP = 4 THEN --anuarg

5195: FOR m in 1.. p_atp_table.Action.COUNT LOOP
5196: ---l_old_plan_id.Extend;
5197: -- we need to get the plan_id based on old org and old demand
5198: -- class
5199: --IF MSC_ATP_PVT.G_INV_CTP = 4 THEN --anuarg
5200: IF p_atp_table.old_source_organization_id(m) IS NOT NULL THEN -- we want to find plan only in case
5201: -- of reschedulling
5202: ----Subst: Get pf id for old inv item if
5203: IF NVL(p_atp_table.old_inventory_item_id(m), p_atp_table.inventory_item_id(m))

Line 5219: IF MSC_ATP_PVT.G_INV_CTP = 4 THEN --3720018, moved from above

5215: IF PG_DEBUG in ('Y', 'C') THEN
5216: msc_sch_wb.atp_debug('Call_delete_row: ' || 'l_old_pf_item_id := ' || l_old_pf_item_id);
5217: END IF;
5218: END IF;
5219: IF MSC_ATP_PVT.G_INV_CTP = 4 THEN --3720018, moved from above
5220: /* time_phased_atp changes begin
5221: Call new procedure Get_PF_Plan_Info*/
5222: IF p_atp_table.old_source_organization_id(m) IS NOT NULL THEN
5223: MSC_ATP_PF.Get_PF_Plan_Info(

Line 5251: l_plan_info_rec := MSC_ATP_PVT.G_PLAN_INFO_REC;

5247: IF PG_DEBUG in ('Y', 'C') THEN
5248: msc_sch_wb.atp_debug('Call_delete_row: ' || 'reached here2');
5249: END IF;
5250:
5251: l_plan_info_rec := MSC_ATP_PVT.G_PLAN_INFO_REC;
5252:
5253: IF PG_DEBUG in ('Y', 'C') THEN
5254: msc_sch_wb.atp_debug('Call_delete_row: ' || 'l_plan_info_rec.plan_id = '||l_plan_info_rec.plan_id);
5255: END IF;

Line 5285: --IF MSC_ATP_PVT.G_INV_CTP = 4 THEN --3720018, removed this condition

5281: IF l_old_plan_id(m) IS NOT NULL THEN
5282: ---subst: add demand field
5283: ---bug 2384224: delete demand only if it has not been deleted
5284: l_delete_demand_flag := 1;
5285: --IF MSC_ATP_PVT.G_INV_CTP = 4 THEN --3720018, removed this condition
5286: -- Chagned the following loop
5287: --FOR i in 1..l_del_demand_ids.count LOOP
5288: -- IF p_atp_table.Identifier(m) = l_del_identifiers(i) and l_old_plan_id(m) = l_del_plan_ids(i) THEN
5289: -- IF PG_DEBUG in ('Y', 'C') THEN

Line 5315: IF (MSC_ATP_PVT.G_INV_CTP = 5) or (MSC_ATP_PVT.G_INV_CTP = 4 and l_delete_demand_flag = 1) THEN

5311: END IF;
5312: END IF;
5313: END LOOP;
5314: --END IF; --3720018
5315: IF (MSC_ATP_PVT.G_INV_CTP = 5) or (MSC_ATP_PVT.G_INV_CTP = 4 and l_delete_demand_flag = 1) THEN
5316: /* time_phased_atp */
5317: IF l_atf_dates(m) is not null THEN
5318: l_time_phased_atp := 'Y';
5319: END IF;

Line 5361: --IF MSC_ATP_PVT.G_INV_CTP = 4 and l_old_plan_id(m) <> -1 THEN --3720018

5357: IF PG_DEBUG in ('Y', 'C') THEN
5358: msc_sch_wb.atp_debug('Call_delete_row: After call to Delete_Row' );
5359: END IF;
5360:
5361: --IF MSC_ATP_PVT.G_INV_CTP = 4 and l_old_plan_id(m) <> -1 THEN --3720018
5362: IF (l_old_plan_id(m) = -1) THEN
5363: IF l_demand_ids IS NOT NULL and l_demand_ids.count > 0 THEN
5364: l_count := l_del_ods_demand_ids.count;
5365: l_del_ods_demand_ids.extend(l_demand_ids.count);

Line 5391: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' THEN

5387: l_del_ods_cto_atp_refresh_no(l_count + i) := l_ods_cto_atp_refresh_no(i);
5388: END LOOP;
5389: END IF;
5390: --5357370
5391: IF MSC_ATP_PVT.G_SUMMARY_FLAG = 'Y' THEN
5392: l_del_identifiers.extend(p_atp_table.Identifier.count);
5393: l_del_identifiers := p_atp_table.Identifier;
5394: END IF;
5395:

Line 5496: END IF; --- IF (MSC_ATP_PVT.G_INV_CTP = 5) or (MSC_ATP_PVT.G_INV_CTP = 4 and l_delete_demand_flag = 1)

5492: END LOOP;
5493: END IF;
5494: -- END CTO ODR and Simplified Pegging
5495: END IF; --3720018
5496: END IF; --- IF (MSC_ATP_PVT.G_INV_CTP = 5) or (MSC_ATP_PVT.G_INV_CTP = 4 and l_delete_demand_flag = 1)
5497: END IF;
5498: IF PG_DEBUG in ('Y', 'C') THEN
5499: msc_sch_wb.atp_debug('Call_delete_row: ' || 'Count of records := ' || l_del_demand_ids.count);
5500: END IF;