DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MSC_SHIP_SET_TEMP

Line 1127: DELETE MSC_SHIP_SET_TEMP;

1123: l_sources.instance_id(1) := p_instance_id;
1124:
1125: --load data in temp table if line > 1
1126: IF l_atp_table.inventory_item_id.count > 1 THEN
1127: DELETE MSC_SHIP_SET_TEMP;
1128: FORALL l_count in 1..p_atp_table.inventory_item_id.count
1129: INSERT INTO MSC_SHIP_SET_TEMP(inventory_item_id,
1130: line_id)
1131: VALUES

Line 1129: INSERT INTO MSC_SHIP_SET_TEMP(inventory_item_id,

1125: --load data in temp table if line > 1
1126: IF l_atp_table.inventory_item_id.count > 1 THEN
1127: DELETE MSC_SHIP_SET_TEMP;
1128: FORALL l_count in 1..p_atp_table.inventory_item_id.count
1129: INSERT INTO MSC_SHIP_SET_TEMP(inventory_item_id,
1130: line_id)
1131: VALUES
1132: (p_atp_table.inventory_item_id(l_count),
1133: p_atp_table.identifier(l_count));

Line 1135: msc_sch_wb.atp_debug('Rows inserted in MSC_SHIP_SET_TEMP := ' || SQL%ROWCOUNT);

1131: VALUES
1132: (p_atp_table.inventory_item_id(l_count),
1133: p_atp_table.identifier(l_count));
1134: IF PG_DEBUG in ('Y', 'C') THEN
1135: msc_sch_wb.atp_debug('Rows inserted in MSC_SHIP_SET_TEMP := ' || SQL%ROWCOUNT);
1136: END IF;
1137: END IF;
1138:
1139: