APPS.QA_PERFORMANCE_TEMP_PKG dependencies on DBMS_SQL

Line 12: x_ids OUT NOCOPY dbms_sql.number_table)

8: -- elements parsed.
9: --
10: FUNCTION parse_integers(
11: p_ids VARCHAR2,
12: x_ids OUT NOCOPY dbms_sql.number_table)
13: RETURN NUMBER IS
14:
15: separator CONSTANT VARCHAR2(1) := ',';
16: n INTEGER;

Line 64: l_ids dbms_sql.number_table;

60: -- Then use bulk operation to insert all values
61: -- to the temp table. The order is immaterial
62: -- because an IN operation does not care.
63: --
64: l_ids dbms_sql.number_table;
65: BEGIN
66:
67: IF parse_integers(p_id_list, l_ids) > 0 THEN
68: FORALL i IN l_ids.FIRST .. l_ids.LAST

Line 116: PROCEDURE add_names(p_key VARCHAR2, p_names dbms_sql.VARCHAR2_TABLE) IS

112: -- Bug 4345779. Audits project.
113: -- Added the following methods.
114: -- srhariha. Wed Jun 1 12:13:02 PDT 2005.
115:
116: PROCEDURE add_names(p_key VARCHAR2, p_names dbms_sql.VARCHAR2_TABLE) IS
117:
118: BEGIN
119:
120: IF p_names IS NOT NULL THEN

Line 130: PROCEDURE purge_and_add_names(p_key VARCHAR2, p_names dbms_sql.VARCHAR2_TABLE) IS

126: END add_names;
127:
128:
129:
130: PROCEDURE purge_and_add_names(p_key VARCHAR2, p_names dbms_sql.VARCHAR2_TABLE) IS
131:
132: BEGIN
133: purge(p_key);
134: add_names(p_key,p_names);