eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_BAL_UTILS dependencies on DBMS_SQL

Line 26: -- between ATP and OM. This fix (using DBMS_SQL) removes this dependency. We check

22: l_ship_set_id NUMBER;
23: l_arrival_set_id NUMBER;
24: a NUMBER;
25: -- From patchset G+, new columns in OE/MRP introduced compile-time dependency
26: -- between ATP and OM. This fix (using DBMS_SQL) removes this dependency. We check
27: -- ALL_TAB_COLUMNS for these columns and then frame the SQL. Bug 2727595.
28:
29: bind1 DBMS_SQL.number_table;
30: bind2 DBMS_SQL.number_table;

Line 29: bind1 DBMS_SQL.number_table;

25: -- From patchset G+, new columns in OE/MRP introduced compile-time dependency
26: -- between ATP and OM. This fix (using DBMS_SQL) removes this dependency. We check
27: -- ALL_TAB_COLUMNS for these columns and then frame the SQL. Bug 2727595.
28:
29: bind1 DBMS_SQL.number_table;
30: bind2 DBMS_SQL.number_table;
31:
32: cursor check_oe (p_column_name varchar2) is
33: select 1

Line 30: bind2 DBMS_SQL.number_table;

26: -- between ATP and OM. This fix (using DBMS_SQL) removes this dependency. We check
27: -- ALL_TAB_COLUMNS for these columns and then frame the SQL. Bug 2727595.
28:
29: bind1 DBMS_SQL.number_table;
30: bind2 DBMS_SQL.number_table;
31:
32: cursor check_oe (p_column_name varchar2) is
33: select 1
34: from user_tab_columns

Line 591: cur_hdl := dbms_sql.open_cursor;

587: END LOOP;
588:
589:
590: -- open cursor
591: cur_hdl := dbms_sql.open_cursor;
592:
593: -- parse cursor
594: dbms_sql.parse(cur_hdl, l_sql_stmt, dbms_sql.native);
595:

Line 594: dbms_sql.parse(cur_hdl, l_sql_stmt, dbms_sql.native);

590: -- open cursor
591: cur_hdl := dbms_sql.open_cursor;
592:
593: -- parse cursor
594: dbms_sql.parse(cur_hdl, l_sql_stmt, dbms_sql.native);
595:
596: -- supply binds
597: dbms_sql.bind_array (cur_hdl, ':l_seq_num', bind1);
598: dbms_sql.bind_array (cur_hdl, ':l_line_id', bind2);

Line 597: dbms_sql.bind_array (cur_hdl, ':l_seq_num', bind1);

593: -- parse cursor
594: dbms_sql.parse(cur_hdl, l_sql_stmt, dbms_sql.native);
595:
596: -- supply binds
597: dbms_sql.bind_array (cur_hdl, ':l_seq_num', bind1);
598: dbms_sql.bind_array (cur_hdl, ':l_line_id', bind2);
599: dbms_sql.bind_variable (cur_hdl, ':p_session_id', p_session_id);
600: dbms_sql.bind_variable (cur_hdl, ':l_profile_value', l_profile_value);
601: dbms_sql.bind_variable (cur_hdl, ':p_overwrite', p_overwrite);

Line 598: dbms_sql.bind_array (cur_hdl, ':l_line_id', bind2);

594: dbms_sql.parse(cur_hdl, l_sql_stmt, dbms_sql.native);
595:
596: -- supply binds
597: dbms_sql.bind_array (cur_hdl, ':l_seq_num', bind1);
598: dbms_sql.bind_array (cur_hdl, ':l_line_id', bind2);
599: dbms_sql.bind_variable (cur_hdl, ':p_session_id', p_session_id);
600: dbms_sql.bind_variable (cur_hdl, ':l_profile_value', l_profile_value);
601: dbms_sql.bind_variable (cur_hdl, ':p_overwrite', p_overwrite);
602: dbms_sql.bind_variable (cur_hdl, ':p_overwrite', p_overwrite);

Line 599: dbms_sql.bind_variable (cur_hdl, ':p_session_id', p_session_id);

595:
596: -- supply binds
597: dbms_sql.bind_array (cur_hdl, ':l_seq_num', bind1);
598: dbms_sql.bind_array (cur_hdl, ':l_line_id', bind2);
599: dbms_sql.bind_variable (cur_hdl, ':p_session_id', p_session_id);
600: dbms_sql.bind_variable (cur_hdl, ':l_profile_value', l_profile_value);
601: dbms_sql.bind_variable (cur_hdl, ':p_overwrite', p_overwrite);
602: dbms_sql.bind_variable (cur_hdl, ':p_overwrite', p_overwrite);
603:

Line 600: dbms_sql.bind_variable (cur_hdl, ':l_profile_value', l_profile_value);

596: -- supply binds
597: dbms_sql.bind_array (cur_hdl, ':l_seq_num', bind1);
598: dbms_sql.bind_array (cur_hdl, ':l_line_id', bind2);
599: dbms_sql.bind_variable (cur_hdl, ':p_session_id', p_session_id);
600: dbms_sql.bind_variable (cur_hdl, ':l_profile_value', l_profile_value);
601: dbms_sql.bind_variable (cur_hdl, ':p_overwrite', p_overwrite);
602: dbms_sql.bind_variable (cur_hdl, ':p_overwrite', p_overwrite);
603:
604: -- execute cursor

Line 601: dbms_sql.bind_variable (cur_hdl, ':p_overwrite', p_overwrite);

597: dbms_sql.bind_array (cur_hdl, ':l_seq_num', bind1);
598: dbms_sql.bind_array (cur_hdl, ':l_line_id', bind2);
599: dbms_sql.bind_variable (cur_hdl, ':p_session_id', p_session_id);
600: dbms_sql.bind_variable (cur_hdl, ':l_profile_value', l_profile_value);
601: dbms_sql.bind_variable (cur_hdl, ':p_overwrite', p_overwrite);
602: dbms_sql.bind_variable (cur_hdl, ':p_overwrite', p_overwrite);
603:
604: -- execute cursor
605: rows_processed := dbms_sql.execute(cur_hdl);

Line 602: dbms_sql.bind_variable (cur_hdl, ':p_overwrite', p_overwrite);

598: dbms_sql.bind_array (cur_hdl, ':l_line_id', bind2);
599: dbms_sql.bind_variable (cur_hdl, ':p_session_id', p_session_id);
600: dbms_sql.bind_variable (cur_hdl, ':l_profile_value', l_profile_value);
601: dbms_sql.bind_variable (cur_hdl, ':p_overwrite', p_overwrite);
602: dbms_sql.bind_variable (cur_hdl, ':p_overwrite', p_overwrite);
603:
604: -- execute cursor
605: rows_processed := dbms_sql.execute(cur_hdl);
606:

Line 605: rows_processed := dbms_sql.execute(cur_hdl);

601: dbms_sql.bind_variable (cur_hdl, ':p_overwrite', p_overwrite);
602: dbms_sql.bind_variable (cur_hdl, ':p_overwrite', p_overwrite);
603:
604: -- execute cursor
605: rows_processed := dbms_sql.execute(cur_hdl);
606:
607: -- close cursor
608: dbms_sql.close_cursor(cur_hdl);
609:

Line 608: dbms_sql.close_cursor(cur_hdl);

604: -- execute cursor
605: rows_processed := dbms_sql.execute(cur_hdl);
606:
607: -- close cursor
608: dbms_sql.close_cursor(cur_hdl);
609:
610: IF PG_DEBUG in ('Y', 'C') THEN
611: msc_sch_wb.atp_debug('MSC_BAL_UTILS.populate_temp_table ' );
612: select to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS')