APPS.QA_SS_PARENT_CHILD_PKG dependencies on DBMS_SQL

Line 117: c1 := dbms_sql.open_cursor;

113: l_where_clause := l_where_clause || ' AND ROWNUM = 1';
114: l_query_clause := l_select_clause || l_from_clause || l_where_clause;
115:
116: --PREPARE the query for execution
117: c1 := dbms_sql.open_cursor;
118: dbms_sql.parse(c1, l_query_clause, dbms_sql.native);
119:
120: --go through the bind var values array and do the bindings
121: i := l_bind_vars.FIRST;

Line 118: dbms_sql.parse(c1, l_query_clause, dbms_sql.native);

114: l_query_clause := l_select_clause || l_from_clause || l_where_clause;
115:
116: --PREPARE the query for execution
117: c1 := dbms_sql.open_cursor;
118: dbms_sql.parse(c1, l_query_clause, dbms_sql.native);
119:
120: --go through the bind var values array and do the bindings
121: i := l_bind_vars.FIRST;
122: WHILE (i IS NOT NULL) LOOP

Line 123: dbms_sql.bind_variable(c1, ':'||to_char(i), l_bind_vars(i));

119:
120: --go through the bind var values array and do the bindings
121: i := l_bind_vars.FIRST;
122: WHILE (i IS NOT NULL) LOOP
123: dbms_sql.bind_variable(c1, ':'||to_char(i), l_bind_vars(i));
124: i := l_bind_vars.NEXT(i);
125: END LOOP;
126:
127: --dummy return value

Line 128: dbms_sql.define_column(c1, 1, i);

124: i := l_bind_vars.NEXT(i);
125: END LOOP;
126:
127: --dummy return value
128: dbms_sql.define_column(c1, 1, i);
129:
130: --EXECUTE the result check query
131: l_ignore := dbms_sql.execute(c1);
132:

Line 131: l_ignore := dbms_sql.execute(c1);

127: --dummy return value
128: dbms_sql.define_column(c1, 1, i);
129:
130: --EXECUTE the result check query
131: l_ignore := dbms_sql.execute(c1);
132:
133: --if it returned a row, return success
134: IF dbms_sql.fetch_rows(c1) > 0 THEN
135: dbms_sql.close_cursor(c1);

Line 134: IF dbms_sql.fetch_rows(c1) > 0 THEN

130: --EXECUTE the result check query
131: l_ignore := dbms_sql.execute(c1);
132:
133: --if it returned a row, return success
134: IF dbms_sql.fetch_rows(c1) > 0 THEN
135: dbms_sql.close_cursor(c1);
136: return 'Y';
137: ELSE
138: dbms_sql.close_cursor(c1);

Line 135: dbms_sql.close_cursor(c1);

131: l_ignore := dbms_sql.execute(c1);
132:
133: --if it returned a row, return success
134: IF dbms_sql.fetch_rows(c1) > 0 THEN
135: dbms_sql.close_cursor(c1);
136: return 'Y';
137: ELSE
138: dbms_sql.close_cursor(c1);
139: return 'N';

Line 138: dbms_sql.close_cursor(c1);

134: IF dbms_sql.fetch_rows(c1) > 0 THEN
135: dbms_sql.close_cursor(c1);
136: return 'Y';
137: ELSE
138: dbms_sql.close_cursor(c1);
139: return 'N';
140: END IF;
141:
142: EXCEPTION