APPS.MSC_ATP_DB_UTILS dependencies on MSC_DEMANDS_S

Line 160: VALUES( msc_demands_s.nextval,

156: --which now holds the value of Intransit Lead Time
157: INTRANSIT_LEAD_TIME,
158: SHIP_SET_NAME, --bug3263368
159: ARRIVAL_SET_NAME) --bug3263368
160: VALUES( msc_demands_s.nextval,
161: p_atp_rec.instance_id,
162: p_atp_rec.inventory_item_id,
163: p_atp_rec.organization_id,
164: p_atp_rec.demand_source_type,

Line 228: ||' VALUES( msc_demands_s.nextval,'

224: ||' ARRIVAL_SET_NAME,' --bug3263368
225: ||' SR_DEMAND_ID,' --bug6647536
226: ||' ROW_TYPE,' --bug6647536
227: ||' SR_SO_LINEID)' --bug6647536
228: ||' VALUES( msc_demands_s.nextval,'
229: ||' :instance_id,'
230: ||' :inventory_item_id,'
231: ||' :organization_id,'
232: ||' :demand_source_type,'

Line 539: msc_demands_s.nextval,

535: SHIP_SET_NAME, --bug3263368
536: ARRIVAL_SET_NAME --bug3263368
537: )
538: VALUES(
539: msc_demands_s.nextval,
540: MSC_ATP_UTILS.Truncate_Demand(p_atp_rec.quantity_ordered), -- 5598066
541: -- start changes for plan by request date
542: decode(p_atp_rec.origination_type,
543: 6, TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,

Line 623: msc_demands_s.nextval,

619: -- 24x7
620: 0,
621: -- bug 2795053-reopen (ssurendr) insert the demand_satisfied_date in msc_demands
622: TRUNC(p_atp_rec.requested_ship_date) + MSC_ATP_PVT.G_END_OF_DAY,
623: msc_demands_s.nextval,
624: --s_cto_rearch
625: p_atp_rec.parent_line_id,
626: p_atp_rec.ato_model_line_id,
627: p_atp_rec.top_model_line_id,

Line 1783: SELECT msc_demands_s.nextval

1779: l_ins_refresh_number_tab(l_ins_refresh_number_tab.COUNT) := l_refresh_number_tab(i);
1780: l_ins_qty_tab(l_ins_qty_tab.COUNT) := l_qty_tab(i);
1781: l_ins_date_tab(l_ins_date_tab.COUNT) := l_old_demand_date(i);
1782:
1783: SELECT msc_demands_s.nextval
1784: INTO l_copy_demand_id(l_copy_demand_id.COUNT)
1785: FROM dual;
1786: END IF;
1787: END LOOP;

Line 2020: SELECT msc_demands_s.nextval

2016: l_ins_qty_tab(l_ins_qty_tab.COUNT) := l_qty_tab(i);
2017: l_ins_date_tab(l_ins_date_tab.COUNT) := l_old_demand_date(i);
2018: l_ins_demand_class_tab(l_ins_demand_class_tab.COUNT) := l_demand_class_tab(i);
2019:
2020: SELECT msc_demands_s.nextval
2021: INTO l_copy_demand_id(l_copy_demand_id.COUNT)
2022: FROM dual;
2023:
2024: END IF;

Line 2124: SELECT msc_demands_s.nextval

2120: l_ins_qty_tab(l_ins_qty_tab.COUNT) := l_qty_tab(i);
2121: l_ins_date_tab(l_ins_date_tab.COUNT) := l_old_demand_date(i);
2122: l_ins_demand_class_tab(l_ins_demand_class_tab.COUNT) := l_demand_class_tab(i);
2123:
2124: SELECT msc_demands_s.nextval
2125: INTO l_copy_demand_id(l_copy_demand_id.COUNT)
2126: FROM dual;
2127: END IF;
2128: END LOOP;