APPS.PQP_CANDM_UPG dependencies on DBMS_SQL

Line 164: l_cursor := dbms_sql.open_cursor;

160: 'SELECT formula_text FROM ff_formulas_f WHERE formula_name= :x AND sysdate BETWEEN
161: effective_start_date and effective_end_date';
162:
163: BEGIN
164: l_cursor := dbms_sql.open_cursor;
165: dbms_sql.parse( l_cursor, l_query, dbms_sql.native );
166: dbms_sql.bind_variable( l_cursor, ':x', l_formula_name );
167:
168: dbms_sql.define_column_long(l_cursor, 1);

Line 165: dbms_sql.parse( l_cursor, l_query, dbms_sql.native );

161: effective_start_date and effective_end_date';
162:
163: BEGIN
164: l_cursor := dbms_sql.open_cursor;
165: dbms_sql.parse( l_cursor, l_query, dbms_sql.native );
166: dbms_sql.bind_variable( l_cursor, ':x', l_formula_name );
167:
168: dbms_sql.define_column_long(l_cursor, 1);
169: l_n := dbms_sql.execute(l_cursor);

Line 166: dbms_sql.bind_variable( l_cursor, ':x', l_formula_name );

162:
163: BEGIN
164: l_cursor := dbms_sql.open_cursor;
165: dbms_sql.parse( l_cursor, l_query, dbms_sql.native );
166: dbms_sql.bind_variable( l_cursor, ':x', l_formula_name );
167:
168: dbms_sql.define_column_long(l_cursor, 1);
169: l_n := dbms_sql.execute(l_cursor);
170: IF (dbms_sql.fetch_rows(l_cursor)>0)

Line 168: dbms_sql.define_column_long(l_cursor, 1);

164: l_cursor := dbms_sql.open_cursor;
165: dbms_sql.parse( l_cursor, l_query, dbms_sql.native );
166: dbms_sql.bind_variable( l_cursor, ':x', l_formula_name );
167:
168: dbms_sql.define_column_long(l_cursor, 1);
169: l_n := dbms_sql.execute(l_cursor);
170: IF (dbms_sql.fetch_rows(l_cursor)>0)
171: THEN
172:

Line 169: l_n := dbms_sql.execute(l_cursor);

165: dbms_sql.parse( l_cursor, l_query, dbms_sql.native );
166: dbms_sql.bind_variable( l_cursor, ':x', l_formula_name );
167:
168: dbms_sql.define_column_long(l_cursor, 1);
169: l_n := dbms_sql.execute(l_cursor);
170: IF (dbms_sql.fetch_rows(l_cursor)>0)
171: THEN
172:
173: dbms_sql.column_value_long(l_cursor, 1, l_buflen,

Line 170: IF (dbms_sql.fetch_rows(l_cursor)>0)

166: dbms_sql.bind_variable( l_cursor, ':x', l_formula_name );
167:
168: dbms_sql.define_column_long(l_cursor, 1);
169: l_n := dbms_sql.execute(l_cursor);
170: IF (dbms_sql.fetch_rows(l_cursor)>0)
171: THEN
172:
173: dbms_sql.column_value_long(l_cursor, 1, l_buflen,
174: l_curpos , l_long_val,

Line 173: dbms_sql.column_value_long(l_cursor, 1, l_buflen,

169: l_n := dbms_sql.execute(l_cursor);
170: IF (dbms_sql.fetch_rows(l_cursor)>0)
171: THEN
172:
173: dbms_sql.column_value_long(l_cursor, 1, l_buflen,
174: l_curpos , l_long_val,
175: l_long_len );
176: END IF;
177:

Line 191: dbms_sql.close_cursor(l_cursor);

187:
188: END;
189:
190:
191: dbms_sql.close_cursor(l_cursor);
192:
193: end;
194: IF l_chk_version < l_template_version_pvt THEN
195: l_temp_text:=l_pvt_formula;