APPS.PAY_GB_P11D_PDF_CONTROL dependencies on DBMS_SQL

Line 143: l_sql_cursor := dbms_sql.open_cursor;

139: hr_utility.trace(l_where);
140: hr_utility.trace(l_group);
141: l_sql := l_select || l_from || l_where || l_group;
142:
143: l_sql_cursor := dbms_sql.open_cursor;
144: dbms_sql.parse(l_sql_cursor, l_sql, dbms_sql.v7);
145: dbms_sql.define_column (l_sql_cursor, 1, l_asg_count);
146: l_rows := dbms_sql.execute_and_fetch (l_sql_cursor, false);
147: dbms_sql.column_value (l_sql_cursor, 1, l_asg_count);

Line 144: dbms_sql.parse(l_sql_cursor, l_sql, dbms_sql.v7);

140: hr_utility.trace(l_group);
141: l_sql := l_select || l_from || l_where || l_group;
142:
143: l_sql_cursor := dbms_sql.open_cursor;
144: dbms_sql.parse(l_sql_cursor, l_sql, dbms_sql.v7);
145: dbms_sql.define_column (l_sql_cursor, 1, l_asg_count);
146: l_rows := dbms_sql.execute_and_fetch (l_sql_cursor, false);
147: dbms_sql.column_value (l_sql_cursor, 1, l_asg_count);
148: dbms_sql.close_cursor(l_sql_cursor);

Line 145: dbms_sql.define_column (l_sql_cursor, 1, l_asg_count);

141: l_sql := l_select || l_from || l_where || l_group;
142:
143: l_sql_cursor := dbms_sql.open_cursor;
144: dbms_sql.parse(l_sql_cursor, l_sql, dbms_sql.v7);
145: dbms_sql.define_column (l_sql_cursor, 1, l_asg_count);
146: l_rows := dbms_sql.execute_and_fetch (l_sql_cursor, false);
147: dbms_sql.column_value (l_sql_cursor, 1, l_asg_count);
148: dbms_sql.close_cursor(l_sql_cursor);
149:

Line 146: l_rows := dbms_sql.execute_and_fetch (l_sql_cursor, false);

142:
143: l_sql_cursor := dbms_sql.open_cursor;
144: dbms_sql.parse(l_sql_cursor, l_sql, dbms_sql.v7);
145: dbms_sql.define_column (l_sql_cursor, 1, l_asg_count);
146: l_rows := dbms_sql.execute_and_fetch (l_sql_cursor, false);
147: dbms_sql.column_value (l_sql_cursor, 1, l_asg_count);
148: dbms_sql.close_cursor(l_sql_cursor);
149:
150: if (l_rows = 1) then

Line 147: dbms_sql.column_value (l_sql_cursor, 1, l_asg_count);

143: l_sql_cursor := dbms_sql.open_cursor;
144: dbms_sql.parse(l_sql_cursor, l_sql, dbms_sql.v7);
145: dbms_sql.define_column (l_sql_cursor, 1, l_asg_count);
146: l_rows := dbms_sql.execute_and_fetch (l_sql_cursor, false);
147: dbms_sql.column_value (l_sql_cursor, 1, l_asg_count);
148: dbms_sql.close_cursor(l_sql_cursor);
149:
150: if (l_rows = 1) then
151: l_ret := l_asg_count;

Line 148: dbms_sql.close_cursor(l_sql_cursor);

144: dbms_sql.parse(l_sql_cursor, l_sql, dbms_sql.v7);
145: dbms_sql.define_column (l_sql_cursor, 1, l_asg_count);
146: l_rows := dbms_sql.execute_and_fetch (l_sql_cursor, false);
147: dbms_sql.column_value (l_sql_cursor, 1, l_asg_count);
148: dbms_sql.close_cursor(l_sql_cursor);
149:
150: if (l_rows = 1) then
151: l_ret := l_asg_count;
152: else