APPS.HXC_LOAD_PKG dependencies on DBMS_SQL

Line 997: t_bb_id dbms_sql.Number_Table;

993: PROCEDURE validate_time_category_sql ( p_sql_string IN LONG ) IS
994:
995: l_sql LONG := 'select distinct ta.bb_id from hxc_tmp_atts ta where '||p_sql_string;
996:
997: t_bb_id dbms_sql.Number_Table;
998:
999: l_csr INTEGER;
1000: l_rows_fetched INTEGER;
1001: l_dummy INTEGER;

Line 1085: l_csr := dbms_sql.open_cursor;

1081: BEGIN
1082:
1083: l_rows_fetched := 100;
1084:
1085: l_csr := dbms_sql.open_cursor;
1086:
1087: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
1088:
1089: dbms_sql.define_array (

Line 1087: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );

1083: l_rows_fetched := 100;
1084:
1085: l_csr := dbms_sql.open_cursor;
1086:
1087: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
1088:
1089: dbms_sql.define_array (
1090: c => l_csr
1091: , position => 1

Line 1089: dbms_sql.define_array (

1085: l_csr := dbms_sql.open_cursor;
1086:
1087: dbms_sql.parse ( l_csr, l_sql, dbms_sql.native );
1088:
1089: dbms_sql.define_array (
1090: c => l_csr
1091: , position => 1
1092: , n_tab => t_bb_id
1093: , cnt => l_rows_fetched

Line 1096: l_dummy := dbms_sql.execute ( l_csr );

1092: , n_tab => t_bb_id
1093: , cnt => l_rows_fetched
1094: , lower_bound => 1 );
1095:
1096: l_dummy := dbms_sql.execute ( l_csr );
1097:
1098: -- loop to ensure we fetch all the rows
1099:
1100: WHILE ( l_rows_fetched = 100 )

Line 1103: l_rows_fetched := dbms_sql.fetch_rows ( l_csr );

1099:
1100: WHILE ( l_rows_fetched = 100 )
1101: LOOP
1102:
1103: l_rows_fetched := dbms_sql.fetch_rows ( l_csr );
1104:
1105: IF ( l_rows_fetched > 0 )
1106: THEN
1107:

Line 1108: dbms_sql.column_value (

1104:
1105: IF ( l_rows_fetched > 0 )
1106: THEN
1107:
1108: dbms_sql.column_value (
1109: c => l_csr
1110: , position => 1
1111: , n_tab => t_bb_id );
1112:

Line 1119: dbms_sql.close_cursor ( l_csr );

1115: END IF;
1116:
1117: END LOOP;
1118:
1119: dbms_sql.close_cursor ( l_csr );
1120:
1121: -- execute immediate l_sql INTO l_dummy;
1122:
1123: EXCEPTION WHEN NO_DATA_FOUND THEN