APPS.PER_PEOPLE_V14_PKG dependencies on DBMS_SQL

Line 151: l_sql_cursor := dbms_sql.open_cursor;

147: || 'from financials_system_parameters fsp';
148: --
149: -- Open Cursor for Processing Sql statment.
150: --
151: l_sql_cursor := dbms_sql.open_cursor;
152: --
153: -- Parse SQL statement.
154: --
155: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);

Line 155: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);

151: l_sql_cursor := dbms_sql.open_cursor;
152: --
153: -- Parse SQL statement.
154: --
155: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);
156: --
157: -- Map the local variables to each returned Column
158: --
159: dbms_sql.define_column(l_sql_cursor, 1, l_set_of_books_id);

Line 159: dbms_sql.define_column(l_sql_cursor, 1, l_set_of_books_id);

155: dbms_sql.parse(l_sql_cursor, l_sql_text, dbms_sql.v7);
156: --
157: -- Map the local variables to each returned Column
158: --
159: dbms_sql.define_column(l_sql_cursor, 1, l_set_of_books_id);
160: dbms_sql.define_column(l_sql_cursor,2, X_expense_check_to_address,30);
161: --
162: -- Execute the SQL statement.
163: --

Line 160: dbms_sql.define_column(l_sql_cursor,2, X_expense_check_to_address,30);

156: --
157: -- Map the local variables to each returned Column
158: --
159: dbms_sql.define_column(l_sql_cursor, 1, l_set_of_books_id);
160: dbms_sql.define_column(l_sql_cursor,2, X_expense_check_to_address,30);
161: --
162: -- Execute the SQL statement.
163: --
164: l_rows_fetched := dbms_sql.EXECUTE(l_sql_cursor);

Line 164: l_rows_fetched := dbms_sql.EXECUTE(l_sql_cursor);

160: dbms_sql.define_column(l_sql_cursor,2, X_expense_check_to_address,30);
161: --
162: -- Execute the SQL statement.
163: --
164: l_rows_fetched := dbms_sql.EXECUTE(l_sql_cursor);
165: --
166: --
167: l_rows := dbms_sql.fetch_rows(l_sql_cursor);
168: --

Line 167: l_rows := dbms_sql.fetch_rows(l_sql_cursor);

163: --
164: l_rows_fetched := dbms_sql.EXECUTE(l_sql_cursor);
165: --
166: --
167: l_rows := dbms_sql.fetch_rows(l_sql_cursor);
168: --
169: IF l_rows > 1
170: THEN
171: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');

Line 181: dbms_sql.column_value(l_sql_cursor, 1, l_set_of_books_id);

177: THEN
178: --
179: -- Extract the select list for the current row into local variables.
180: --
181: dbms_sql.column_value(l_sql_cursor, 1, l_set_of_books_id);
182: dbms_sql.column_value(l_sql_cursor, 2, X_expense_check_to_address);
183: END IF;
184: --
185: -- Close cursor used for processing SQL statement.

Line 182: dbms_sql.column_value(l_sql_cursor, 2, X_expense_check_to_address);

178: --
179: -- Extract the select list for the current row into local variables.
180: --
181: dbms_sql.column_value(l_sql_cursor, 1, l_set_of_books_id);
182: dbms_sql.column_value(l_sql_cursor, 2, X_expense_check_to_address);
183: END IF;
184: --
185: -- Close cursor used for processing SQL statement.
186: --

Line 187: dbms_sql.close_cursor(l_sql_cursor);

183: END IF;
184: --
185: -- Close cursor used for processing SQL statement.
186: --
187: dbms_sql.close_cursor(l_sql_cursor);
188: END;
189: END IF;
190: --
191: --