APPS.PAY_GB_P11D_PDF_CONTROL dependencies on DBMS_SQL

Line 147: l_sql_cursor := dbms_sql.open_cursor;

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

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

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

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

145: l_sql := l_select || l_from || l_where || l_group;
146:
147: l_sql_cursor := dbms_sql.open_cursor;
148: dbms_sql.parse(l_sql_cursor, l_sql, dbms_sql.v7);
149: dbms_sql.define_column (l_sql_cursor, 1, l_asg_count);
150: l_rows := dbms_sql.execute_and_fetch (l_sql_cursor, false);
151: dbms_sql.column_value (l_sql_cursor, 1, l_asg_count);
152: dbms_sql.close_cursor(l_sql_cursor);
153:

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

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

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

147: l_sql_cursor := dbms_sql.open_cursor;
148: dbms_sql.parse(l_sql_cursor, l_sql, dbms_sql.v7);
149: dbms_sql.define_column (l_sql_cursor, 1, l_asg_count);
150: l_rows := dbms_sql.execute_and_fetch (l_sql_cursor, false);
151: dbms_sql.column_value (l_sql_cursor, 1, l_asg_count);
152: dbms_sql.close_cursor(l_sql_cursor);
153:
154: if (l_rows = 1) then
155: l_ret := l_asg_count;

Line 152: dbms_sql.close_cursor(l_sql_cursor);

148: dbms_sql.parse(l_sql_cursor, l_sql, dbms_sql.v7);
149: dbms_sql.define_column (l_sql_cursor, 1, l_asg_count);
150: l_rows := dbms_sql.execute_and_fetch (l_sql_cursor, false);
151: dbms_sql.column_value (l_sql_cursor, 1, l_asg_count);
152: dbms_sql.close_cursor(l_sql_cursor);
153:
154: if (l_rows = 1) then
155: l_ret := l_asg_count;
156: else