APPS.MSC_ATP_UTILS dependencies on MSC_BOM_TEMP

Line 1275: -- Added on 10/16/00 by ngoel for inserting BOM data into MSC_BOM_TEMP

1271:
1272: -- Bug 2974324. Redundant test procedure removed from here
1273:
1274:
1275: -- Added on 10/16/00 by ngoel for inserting BOM data into MSC_BOM_TEMP
1276: -- table when ATP is called with CTO models from OM or Configurator.
1277:
1278: PROCEDURE put_into_bom_temp_table(
1279: p_session_id IN NUMBER,

Line 1303: -- Delete records from msc_bom_temp_table in case there are any records

1299: IF p_dblink IS NOT NULL THEN
1300: l_dynstring := '@'||p_dblink;
1301: END IF;
1302:
1303: -- Delete records from msc_bom_temp_table in case there are any records
1304: -- with similar session id.
1305:
1306: -- bug 2974324. Changed the dynamic SQL to static if db_link is null
1307: IF p_dblink IS NULL THEN

Line 1308: DELETE msc_bom_temp WHERE session_id = p_session_id;

1304: -- with similar session id.
1305:
1306: -- bug 2974324. Changed the dynamic SQL to static if db_link is null
1307: IF p_dblink IS NULL THEN
1308: DELETE msc_bom_temp WHERE session_id = p_session_id;
1309: ELSE
1310: sql_stmt := 'DELETE msc_bom_temp'||l_dynstring|| ' WHERE session_id = :session_id';
1311:
1312: IF PG_DEBUG in ('Y', 'C') THEN

Line 1310: sql_stmt := 'DELETE msc_bom_temp'||l_dynstring|| ' WHERE session_id = :session_id';

1306: -- bug 2974324. Changed the dynamic SQL to static if db_link is null
1307: IF p_dblink IS NULL THEN
1308: DELETE msc_bom_temp WHERE session_id = p_session_id;
1309: ELSE
1310: sql_stmt := 'DELETE msc_bom_temp'||l_dynstring|| ' WHERE session_id = :session_id';
1311:
1312: IF PG_DEBUG in ('Y', 'C') THEN
1313: msc_sch_wb.atp_debug('put_into_bom_temp_table: ' || 'sql_stmt : '||sql_stmt);
1314: END IF;

Line 1320: msc_sch_wb.atp_debug('put_into_bom_temp_table: ' || 'After deleting from msc_bom_temp table');

1316: EXECUTE IMMEDIATE sql_stmt using p_session_id;
1317: END IF;
1318:
1319: IF PG_DEBUG in ('Y', 'C') THEN
1320: msc_sch_wb.atp_debug('put_into_bom_temp_table: ' || 'After deleting from msc_bom_temp table');
1321: END IF;
1322:
1323: j := p_atp_bom_rec.assembly_identifier.FIRST;
1324: IF PG_DEBUG in ('Y', 'C') THEN

Line 1338: sql_stmt := 'INSERT INTO msc_bom_temp'||l_dynstring|| ' (

1334: p_atp_bom_rec.assembly_item_id(j) || ' : '||
1335: 'comp item_id : ' ||p_atp_bom_rec.component_item_id(j)||
1336: ' atp flag : ' || p_atp_bom_rec.atp_check(j));
1337: END IF;
1338: sql_stmt := 'INSERT INTO msc_bom_temp'||l_dynstring|| ' (
1339: session_id,
1340: assembly_identifier,
1341: assembly_item_id,
1342: component_identifier,

Line 1409: INSERT INTO msc_bom_temp (

1405:
1406: ELSE -- bug 2974324. Changed the dynamic SQL to static if db_link is null
1407:
1408: FORALL j in 1..p_atp_bom_rec.assembly_identifier.COUNT
1409: INSERT INTO msc_bom_temp (
1410: session_id,
1411: assembly_identifier,
1412: assembly_item_id,
1413: component_identifier,