DBA Data[Home] [Help]

APPS.MSC_ATP_PVT dependencies on MSC_SHIP_SET_TEMP

Line 1171: DELETE MSC_SHIP_SET_TEMP;

1167: l_sources.instance_id(1) := p_instance_id;
1168:
1169: --load data in temp table if line > 1
1170: IF l_atp_table.inventory_item_id.count > 1 THEN
1171: DELETE MSC_SHIP_SET_TEMP;
1172: FORALL l_count in 1..p_atp_table.inventory_item_id.count
1173: INSERT INTO MSC_SHIP_SET_TEMP(inventory_item_id,
1174: line_id)
1175: VALUES

Line 1173: INSERT INTO MSC_SHIP_SET_TEMP(inventory_item_id,

1169: --load data in temp table if line > 1
1170: IF l_atp_table.inventory_item_id.count > 1 THEN
1171: DELETE MSC_SHIP_SET_TEMP;
1172: FORALL l_count in 1..p_atp_table.inventory_item_id.count
1173: INSERT INTO MSC_SHIP_SET_TEMP(inventory_item_id,
1174: line_id)
1175: VALUES
1176: (p_atp_table.inventory_item_id(l_count),
1177: p_atp_table.identifier(l_count));

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

1175: VALUES
1176: (p_atp_table.inventory_item_id(l_count),
1177: p_atp_table.identifier(l_count));
1178: IF PG_DEBUG in ('Y', 'C') THEN
1179: msc_sch_wb.atp_debug('Rows inserted in MSC_SHIP_SET_TEMP := ' || SQL%ROWCOUNT);
1180: END IF;
1181: END IF;
1182:
1183: