APPS.INV_SQL_BINDING_PVT dependencies on DBMS_SQL

Line 145: -- Pre-reqs : refer to dbms_sql package spec

141: -- API name : BindVars
142: -- Type : Private
143: -- Function : Binds all variables stored in the internal bind variable
144: -- tables to the given dynamic SQL cursor.
145: -- Pre-reqs : refer to dbms_sql package spec
146: -- Parameters :
147: -- p_cursor in integer required
148: -- Version : not tracked
149: -- Notes :

Line 156: dbms_sql.bind_variable( p_cursor

152: BEGIN
153: -- Bind all numeric variables
154: IF g_num_counter > 0 THEN
155: FOR n_i IN 1..g_num_counter LOOP
156: dbms_sql.bind_variable( p_cursor
157: ,g_num_tbl(n_i).identifier
158: ,g_num_tbl(n_i).value );
159: END LOOP;
160: END IF;

Line 164: dbms_sql.bind_variable( p_cursor

160: END IF;
161: -- Bind all character variables
162: IF g_char_counter > 0 THEN
163: FOR n_i IN 1..g_char_counter LOOP
164: dbms_sql.bind_variable( p_cursor
165: ,g_char_tbl(n_i).identifier
166: ,g_char_tbl(n_i).value );
167: END LOOP;
168: END IF;

Line 172: dbms_sql.bind_variable( p_cursor

168: END IF;
169: -- Bind all date variables
170: IF g_date_counter > 0 THEN
171: FOR n_i IN 1..g_date_counter LOOP
172: dbms_sql.bind_variable( p_cursor
173: ,g_date_tbl(n_i).identifier
174: ,g_date_tbl(n_i).value );
175: END LOOP;
176: END IF;