APPS.MSC_SCH_WB dependencies on MRP_ATP_SCHEDULE_TEMP

Line 40: from mrp_atp_schedule_temp

36: IF PG_DEBUG in ('Y', 'C') THEN
37: atp_debug('GET_ATP_RESULT: ' || 'got here');
38: select count(*)
39: into l_count
40: from mrp_atp_schedule_temp
41: where session_id = x_session_id
42: and status_flag = 1;
43: atp_debug('GET_ATP_RESULT: sending that many records to ATP : ' || l_count);
44: END IF;

Line 213: from mrp_atp_schedule_temp a

209: x_atp_rec.Component_Sequence_ID,
210: x_atp_rec.Component_Code,
211: x_atp_rec.line_number,
212: x_atp_rec.included_item_flag
213: from mrp_atp_schedule_temp a
214: where a.session_id = x_session_id
215: and a.status_flag = 1
216: order by a.source_organization_code,
217: a.sequence_number,

Line 454: sqlstmt := 'DELETE FROM mrp_atp_schedule_temp mast '||

450:
451: IF PG_DEBUG in ('Y', 'C') THEN
452: atp_debug('delete_lines: ' || ' deleting all rows for session_id 1 '||p_session_id);
453: END IF;
454: sqlstmt := 'DELETE FROM mrp_atp_schedule_temp mast '||
455: 'WHERE '||p_where_clause||' and mast.session_id = :session_id';
456: execute immediate sqlstmt using p_session_id;
457:
458: IF PG_DEBUG in ('Y', 'C') THEN

Line 497: from mrp_atp_schedule_temp

493: l_rac_count NUMBER;
494:
495: cursor cto_related_case (p_session_id NUMBER) IS
496: select 1
497: from mrp_atp_schedule_temp
498: where session_id = p_session_id
499: and ato_model_line_id is NOT NULL
500: and status_flag = 4
501: and rownum = 1;

Line 585: FROM mrp_atp_schedule_temp mast

581: END IF;
582:
583: SELECT DISTINCT mast.customer_site_id
584: INTO l_customer_site_id
585: FROM mrp_atp_schedule_temp mast
586: WHERE mast.session_id = x_session_id
587: AND status_flag = 4;
588:
589: IF PG_DEBUG in ('Y', 'C') THEN

Line 1124: FROM mrp_atp_schedule_temp

1120: cursor get_item_name is
1121: SELECT DISTINCT
1122: inventory_item_name||order_sch_wb.delim||owb_tree.lookups(5) -- 'Item'
1123: ||order_sch_wb.delim||source_organization_code
1124: FROM mrp_atp_schedule_temp
1125: WHERE end_pegging_id = p_end_pegging_id;
1126:
1127: BEGIN
1128:

Line 1401: delete from mrp_atp_schedule_temp

1397: END get_period_atp_strings;
1398:
1399: PROCEDURE cleanup_data (p_session_id in number) IS
1400: begin
1401: delete from mrp_atp_schedule_temp
1402: where status_flag = 1
1403: and session_id = p_session_id;
1404:
1405: update mrp_atp_schedule_temp

Line 1405: update mrp_atp_schedule_temp

1401: delete from mrp_atp_schedule_temp
1402: where status_flag = 1
1403: and session_id = p_session_id;
1404:
1405: update mrp_atp_schedule_temp
1406: set status_flag = 1
1407: where session_id = p_session_id
1408: and status_flag = 2;
1409: end cleanup_data;

Line 1427: UPDATE mrp_atp_schedule_temp mast

1423: IF PG_DEBUG in ('Y', 'C') THEN
1424: msc_sch_wb.atp_debug(' Inside calc_exceptions '||p_session_id);
1425: END IF;
1426:
1427: UPDATE mrp_atp_schedule_temp mast
1428: set
1429: mast.exception1 = Decode(error_code,53,1,52,1,100,1,0),
1430: mast.exception2 = Decode(error_code,0,
1431: Decode(Sign(trunc(mast.scheduled_ship_date) -

Line 1783: select mrp_atp_schedule_temp_s.nextval

1779: DBLINK_NOT_OPEN EXCEPTION;
1780: PRAGMA EXCEPTION_INIT(DBLINK_NOT_OPEN, -2081);
1781: BEGIN
1782: if ( p_db_link is NULL) then
1783: select mrp_atp_schedule_temp_s.nextval
1784: into p_session_id
1785: from dual;
1786: else
1787: l_db_link := '@'||p_db_link;

Line 1788: --sql_stmt := ' select mrp_atp_schedule_temp_s.nextval from dual@'||p_db_link;

1784: into p_session_id
1785: from dual;
1786: else
1787: l_db_link := '@'||p_db_link;
1788: --sql_stmt := ' select mrp_atp_schedule_temp_s.nextval from dual@'||p_db_link;
1789: sql_stmt := 'begin msc_sch_wb.get_session_id'||l_db_link||'(:l_null_db_link,:p_session_id); end;';
1790: EXECUTE IMMEDIATE sql_stmt using l_null_db_link, out p_session_id;
1791:
1792: l_cursor := dbms_sql.open_cursor;