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.PO_UDA_IMPORT_PKG dependencies on DBMS_SQL

Line 801: v_query_hdl := DBMS_SQL.open_cursor;

797: -- Not using binds as it would be complicated to put all the checks
798: d_progress := 250;
799: PO_UDA_DEFAULTING_PKG.DEBUG('l_sql_query : ' || l_sql_query, d_progress);
800: PO_UDA_DEFAULTING_PKG.DEBUG('Before executing', d_progress);
801: v_query_hdl := DBMS_SQL.open_cursor;
802: DBMS_SQL.parse(v_query_hdl, l_sql_query, DBMS_SQL.native);
803: DBMS_SQL.define_column(v_query_hdl, 1, l_check);
804: l_rows_processed := DBMS_SQL.EXECUTE(v_query_hdl);
805: PO_UDA_DEFAULTING_PKG.DEBUG('After executing l_rows_processed :' || l_rows_processed, d_progress);

Line 802: DBMS_SQL.parse(v_query_hdl, l_sql_query, DBMS_SQL.native);

798: d_progress := 250;
799: PO_UDA_DEFAULTING_PKG.DEBUG('l_sql_query : ' || l_sql_query, d_progress);
800: PO_UDA_DEFAULTING_PKG.DEBUG('Before executing', d_progress);
801: v_query_hdl := DBMS_SQL.open_cursor;
802: DBMS_SQL.parse(v_query_hdl, l_sql_query, DBMS_SQL.native);
803: DBMS_SQL.define_column(v_query_hdl, 1, l_check);
804: l_rows_processed := DBMS_SQL.EXECUTE(v_query_hdl);
805: PO_UDA_DEFAULTING_PKG.DEBUG('After executing l_rows_processed :' || l_rows_processed, d_progress);
806:

Line 803: DBMS_SQL.define_column(v_query_hdl, 1, l_check);

799: PO_UDA_DEFAULTING_PKG.DEBUG('l_sql_query : ' || l_sql_query, d_progress);
800: PO_UDA_DEFAULTING_PKG.DEBUG('Before executing', d_progress);
801: v_query_hdl := DBMS_SQL.open_cursor;
802: DBMS_SQL.parse(v_query_hdl, l_sql_query, DBMS_SQL.native);
803: DBMS_SQL.define_column(v_query_hdl, 1, l_check);
804: l_rows_processed := DBMS_SQL.EXECUTE(v_query_hdl);
805: PO_UDA_DEFAULTING_PKG.DEBUG('After executing l_rows_processed :' || l_rows_processed, d_progress);
806:
807: d_progress := 260;

Line 804: l_rows_processed := DBMS_SQL.EXECUTE(v_query_hdl);

800: PO_UDA_DEFAULTING_PKG.DEBUG('Before executing', d_progress);
801: v_query_hdl := DBMS_SQL.open_cursor;
802: DBMS_SQL.parse(v_query_hdl, l_sql_query, DBMS_SQL.native);
803: DBMS_SQL.define_column(v_query_hdl, 1, l_check);
804: l_rows_processed := DBMS_SQL.EXECUTE(v_query_hdl);
805: PO_UDA_DEFAULTING_PKG.DEBUG('After executing l_rows_processed :' || l_rows_processed, d_progress);
806:
807: d_progress := 260;
808: IF DBMS_SQL.fetch_rows(v_query_hdl) <= 0 THEN

Line 808: IF DBMS_SQL.fetch_rows(v_query_hdl) <= 0 THEN

804: l_rows_processed := DBMS_SQL.EXECUTE(v_query_hdl);
805: PO_UDA_DEFAULTING_PKG.DEBUG('After executing l_rows_processed :' || l_rows_processed, d_progress);
806:
807: d_progress := 260;
808: IF DBMS_SQL.fetch_rows(v_query_hdl) <= 0 THEN
809: l_attr_grp_loc_index := x_attributes_row_table.FIRST;
810: l_present := 0;
811: WHILE (l_attr_grp_loc_index IS NOT NULL AND l_attr_grp_loc_index <= x_attributes_row_table.LAST)
812: LOOP

Line 1045: IF DBMS_SQL.is_open(v_query_hdl) THEN

1041: d_progress := 720;
1042: END IF;
1043: END IF;
1044:
1045: IF DBMS_SQL.is_open(v_query_hdl) THEN
1046: DBMS_SQL.close_cursor(v_query_hdl);
1047: END IF ;
1048:
1049: END IF;

Line 1046: DBMS_SQL.close_cursor(v_query_hdl);

1042: END IF;
1043: END IF;
1044:
1045: IF DBMS_SQL.is_open(v_query_hdl) THEN
1046: DBMS_SQL.close_cursor(v_query_hdl);
1047: END IF ;
1048:
1049: END IF;
1050: d_progress := 730;

Line 1071: IF DBMS_SQL.is_open(v_query_hdl) THEN

1067: WHEN OTHERS THEN
1068: l_err_txt := 'Exception in POPULATE_EMPTY_AGS with ERROR : ' || SQLERRM;
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070:
1071: IF DBMS_SQL.is_open(v_query_hdl) THEN
1072: DBMS_SQL.close_cursor(v_query_hdl);
1073: END IF ;
1074:
1075: PO_UDA_IMPORT_PKG.HANDLE_ERROR

Line 1072: DBMS_SQL.close_cursor(v_query_hdl);

1068: l_err_txt := 'Exception in POPULATE_EMPTY_AGS with ERROR : ' || SQLERRM;
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070:
1071: IF DBMS_SQL.is_open(v_query_hdl) THEN
1072: DBMS_SQL.close_cursor(v_query_hdl);
1073: END IF ;
1074:
1075: PO_UDA_IMPORT_PKG.HANDLE_ERROR
1076: (