APPS.MSC_ATP_DB_UTILS dependencies on MSC_DEMANDS_S

Line 114: VALUES( msc_demands_s.nextval,

110: --which now holds the value of Intransit Lead Time
111: INTRANSIT_LEAD_TIME,
112: SHIP_SET_NAME, --bug3263368
113: ARRIVAL_SET_NAME) --bug3263368
114: VALUES( msc_demands_s.nextval,
115: p_atp_rec.instance_id,
116: p_atp_rec.inventory_item_id,
117: p_atp_rec.organization_id,
118: p_atp_rec.demand_source_type,

Line 395: msc_demands_s.nextval,

391: SHIP_SET_NAME, --bug3263368
392: ARRIVAL_SET_NAME --bug3263368
393: )
394: VALUES(
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,

Line 479: msc_demands_s.nextval,

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,
483: p_atp_rec.top_model_line_id,

Line 1630: SELECT msc_demands_s.nextval

1626: l_ins_refresh_number_tab(l_ins_refresh_number_tab.COUNT) := l_refresh_number_tab(i);
1627: l_ins_qty_tab(l_ins_qty_tab.COUNT) := l_qty_tab(i);
1628: l_ins_date_tab(l_ins_date_tab.COUNT) := l_old_demand_date(i);
1629:
1630: SELECT msc_demands_s.nextval
1631: INTO l_copy_demand_id(l_copy_demand_id.COUNT)
1632: FROM dual;
1633: END IF;
1634: END LOOP;

Line 1867: SELECT msc_demands_s.nextval

1863: l_ins_qty_tab(l_ins_qty_tab.COUNT) := l_qty_tab(i);
1864: l_ins_date_tab(l_ins_date_tab.COUNT) := l_old_demand_date(i);
1865: l_ins_demand_class_tab(l_ins_demand_class_tab.COUNT) := l_demand_class_tab(i);
1866:
1867: SELECT msc_demands_s.nextval
1868: INTO l_copy_demand_id(l_copy_demand_id.COUNT)
1869: FROM dual;
1870:
1871: END IF;

Line 1971: SELECT msc_demands_s.nextval

1967: l_ins_qty_tab(l_ins_qty_tab.COUNT) := l_qty_tab(i);
1968: l_ins_date_tab(l_ins_date_tab.COUNT) := l_old_demand_date(i);
1969: l_ins_demand_class_tab(l_ins_demand_class_tab.COUNT) := l_demand_class_tab(i);
1970:
1971: SELECT msc_demands_s.nextval
1972: INTO l_copy_demand_id(l_copy_demand_id.COUNT)
1973: FROM dual;
1974: END IF;
1975: END LOOP;