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_SCH_WB dependencies on DBMS_SQL

Line 633: l_cursor := dbms_sql.open_cursor;

629: x_assignment_set_id, x_plan_id, x_calling_inst,
630: OUT x_ret_status, OUT x_error_mesg,l_node_id;
631:
632: IF x_dblink IS NOT NULL then
633: l_cursor := dbms_sql.open_cursor;
634: -- mark distributed transaction boundary
635: -- will need to do a manual clean up (commit) of the distributed
636: -- operation, else subsequent operations fail w/ ora-02080 (bug 2218999)
637: commit;

Line 638: DBMS_SQL.PARSE ( l_cursor,

634: -- mark distributed transaction boundary
635: -- will need to do a manual clean up (commit) of the distributed
636: -- operation, else subsequent operations fail w/ ora-02080 (bug 2218999)
637: commit;
638: DBMS_SQL.PARSE ( l_cursor,
639: 'alter session close database link ' ||x_dblink,
640: dbms_sql.native
641: );
642: BEGIN

Line 640: dbms_sql.native

636: -- operation, else subsequent operations fail w/ ora-02080 (bug 2218999)
637: commit;
638: DBMS_SQL.PARSE ( l_cursor,
639: 'alter session close database link ' ||x_dblink,
640: dbms_sql.native
641: );
642: BEGIN
643: rows_processed := dbms_sql.execute(l_cursor);
644: EXCEPTION

Line 643: rows_processed := dbms_sql.execute(l_cursor);

639: 'alter session close database link ' ||x_dblink,
640: dbms_sql.native
641: );
642: BEGIN
643: rows_processed := dbms_sql.execute(l_cursor);
644: EXCEPTION
645: WHEN DBLINK_NOT_OPEN THEN
646: IF PG_DEBUG in ('Y', 'C') THEN
647: msc_sch_wb.atp_debug('get_supply_sources_local: ' || 'inside DBLINK_NOT_OPEN');

Line 699: l_cursor := dbms_sql.open_cursor;

695: EXECUTE IMMEDIATE sqlstring INTO atp_rule_name
696: using sr_instance_id, org_id, item_id;
697:
698: IF l_dblink IS NOT NULL then
699: l_cursor := dbms_sql.open_cursor;
700: -- mark distributed transaction boundary
701: -- will need to do a manual clean up (commit) of the distributed
702: -- operation, else subsequent operations fail w/ ora-02080 (bug 2218999)
703: commit;

Line 704: DBMS_SQL.PARSE ( l_cursor,

700: -- mark distributed transaction boundary
701: -- will need to do a manual clean up (commit) of the distributed
702: -- operation, else subsequent operations fail w/ ora-02080 (bug 2218999)
703: commit;
704: DBMS_SQL.PARSE ( l_cursor,
705: 'alter session close database link ' ||l_dblink,
706: dbms_sql.native
707: );
708: BEGIN

Line 706: dbms_sql.native

702: -- operation, else subsequent operations fail w/ ora-02080 (bug 2218999)
703: commit;
704: DBMS_SQL.PARSE ( l_cursor,
705: 'alter session close database link ' ||l_dblink,
706: dbms_sql.native
707: );
708: BEGIN
709: rows_processed := dbms_sql.execute(l_cursor);
710: EXCEPTION

Line 709: rows_processed := dbms_sql.execute(l_cursor);

705: 'alter session close database link ' ||l_dblink,
706: dbms_sql.native
707: );
708: BEGIN
709: rows_processed := dbms_sql.execute(l_cursor);
710: EXCEPTION
711: WHEN DBLINK_NOT_OPEN THEN
712: IF PG_DEBUG in ('Y', 'C') THEN
713: msc_sch_wb.atp_debug('get_atp_rule_name: ' || 'inside DBLINK_NOT_OPEN');

Line 818: l_cursor := dbms_sql.open_cursor;

814: ' msc assignment_set_id = '||l_msc_assign_set_id);
815: END IF;
816:
817: IF l_dblink IS NOT NULL then
818: l_cursor := dbms_sql.open_cursor;
819:
820: -- mark distributed transaction boundary
821: -- will need to do a manual clean up (commit) of the distributed
822: -- operation, else subsequent operations fail w/ ora-02080 (bug 2218999)

Line 824: DBMS_SQL.PARSE ( l_cursor,

820: -- mark distributed transaction boundary
821: -- will need to do a manual clean up (commit) of the distributed
822: -- operation, else subsequent operations fail w/ ora-02080 (bug 2218999)
823: commit;
824: DBMS_SQL.PARSE ( l_cursor,
825: 'alter session close database link ' ||l_dblink,
826: dbms_sql.native
827: );
828: BEGIN

Line 826: dbms_sql.native

822: -- operation, else subsequent operations fail w/ ora-02080 (bug 2218999)
823: commit;
824: DBMS_SQL.PARSE ( l_cursor,
825: 'alter session close database link ' ||l_dblink,
826: dbms_sql.native
827: );
828: BEGIN
829: rows_processed := dbms_sql.execute(l_cursor);
830: EXCEPTION

Line 829: rows_processed := dbms_sql.execute(l_cursor);

825: 'alter session close database link ' ||l_dblink,
826: dbms_sql.native
827: );
828: BEGIN
829: rows_processed := dbms_sql.execute(l_cursor);
830: EXCEPTION
831: WHEN DBLINK_NOT_OPEN THEN
832: IF PG_DEBUG in ('Y', 'C') THEN
833: atp_debug('get_assignment_set: ' || 'inside DBLINK_NOT_OPEN');

Line 895: l_cursor := dbms_sql.open_cursor;

891: using x_assignment_set_id, x_sr_instance_id;
892: x_assignment_set_name := l_assign_name;
893:
894: IF l_dblink IS NOT NULL then
895: l_cursor := dbms_sql.open_cursor;
896: -- mark distributed transaction boundary
897: -- will need to do a manual clean up (commit) of the distributed
898: -- operation, else subsequent operations fail w/ ora-02080 (bug 2218999)
899: commit;

Line 900: DBMS_SQL.PARSE ( l_cursor,

896: -- mark distributed transaction boundary
897: -- will need to do a manual clean up (commit) of the distributed
898: -- operation, else subsequent operations fail w/ ora-02080 (bug 2218999)
899: commit;
900: DBMS_SQL.PARSE ( l_cursor,
901: 'alter session close database link ' ||l_dblink,
902: dbms_sql.native
903: );
904: BEGIN

Line 902: dbms_sql.native

898: -- operation, else subsequent operations fail w/ ora-02080 (bug 2218999)
899: commit;
900: DBMS_SQL.PARSE ( l_cursor,
901: 'alter session close database link ' ||l_dblink,
902: dbms_sql.native
903: );
904: BEGIN
905: rows_processed := dbms_sql.execute(l_cursor);
906: EXCEPTION

Line 905: rows_processed := dbms_sql.execute(l_cursor);

901: 'alter session close database link ' ||l_dblink,
902: dbms_sql.native
903: );
904: BEGIN
905: rows_processed := dbms_sql.execute(l_cursor);
906: EXCEPTION
907: WHEN DBLINK_NOT_OPEN THEN
908: IF PG_DEBUG in ('Y', 'C') THEN
909: msc_sch_wb.atp_debug('get_assignment_set: ' || 'inside DBLINK_NOT_OPEN');

Line 1753: l_cursor := dbms_sql.open_cursor;

1749: -- mark distributed transaction boundary
1750: -- will need to do a manual clean up (commit) of the distributed
1751: -- operation, else subsequent operations fail w/ ora-02080 (bug 2218999)
1752: commit;
1753: l_cursor := dbms_sql.open_cursor;
1754: DBMS_SQL.PARSE ( l_cursor,
1755: 'alter session close database link ' ||l_atp_link,
1756: dbms_sql.native
1757: );

Line 1754: DBMS_SQL.PARSE ( l_cursor,

1750: -- will need to do a manual clean up (commit) of the distributed
1751: -- operation, else subsequent operations fail w/ ora-02080 (bug 2218999)
1752: commit;
1753: l_cursor := dbms_sql.open_cursor;
1754: DBMS_SQL.PARSE ( l_cursor,
1755: 'alter session close database link ' ||l_atp_link,
1756: dbms_sql.native
1757: );
1758: BEGIN

Line 1756: dbms_sql.native

1752: commit;
1753: l_cursor := dbms_sql.open_cursor;
1754: DBMS_SQL.PARSE ( l_cursor,
1755: 'alter session close database link ' ||l_atp_link,
1756: dbms_sql.native
1757: );
1758: BEGIN
1759: rows_processed := dbms_sql.execute(l_cursor);
1760: EXCEPTION

Line 1759: rows_processed := dbms_sql.execute(l_cursor);

1755: 'alter session close database link ' ||l_atp_link,
1756: dbms_sql.native
1757: );
1758: BEGIN
1759: rows_processed := dbms_sql.execute(l_cursor);
1760: EXCEPTION
1761: WHEN DBLINK_NOT_OPEN THEN
1762: IF PG_DEBUG in ('Y', 'C') THEN
1763: msc_sch_wb.atp_debug('get_profile: ' || 'inside DBLINK_NOT_OPEN');

Line 1792: l_cursor := dbms_sql.open_cursor;

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;
1793: commit;
1794: DBMS_SQL.PARSE ( l_cursor, 'alter session close database link ' ||p_db_link, dbms_sql.native);
1795: BEGIN
1796: rows_processed := dbms_sql.execute(l_cursor);

Line 1794: DBMS_SQL.PARSE ( l_cursor, 'alter session close database link ' ||p_db_link, dbms_sql.native);

1790: EXECUTE IMMEDIATE sql_stmt using l_null_db_link, out p_session_id;
1791:
1792: l_cursor := dbms_sql.open_cursor;
1793: commit;
1794: DBMS_SQL.PARSE ( l_cursor, 'alter session close database link ' ||p_db_link, dbms_sql.native);
1795: BEGIN
1796: rows_processed := dbms_sql.execute(l_cursor);
1797: EXCEPTION
1798: WHEN DBLINK_NOT_OPEN THEN

Line 1796: rows_processed := dbms_sql.execute(l_cursor);

1792: l_cursor := dbms_sql.open_cursor;
1793: commit;
1794: DBMS_SQL.PARSE ( l_cursor, 'alter session close database link ' ||p_db_link, dbms_sql.native);
1795: BEGIN
1796: rows_processed := dbms_sql.execute(l_cursor);
1797: EXCEPTION
1798: WHEN DBLINK_NOT_OPEN THEN
1799: IF PG_DEBUG in ('Y', 'C') THEN
1800: msc_sch_wb.atp_debug('get_session_id: ' || 'inside DBLINK_NOT_OPEN');