DBA Data[Home] [Help]

APPS.QA_PERFORMANCE_TEMP_PKG dependencies on QA_PERFORMANCE_TEMP

Line 1: PACKAGE BODY qa_performance_temp_pkg AS

1: PACKAGE BODY qa_performance_temp_pkg AS
2: /* $Header: qatempb.pls 120.1 2005/06/09 07:58:38 appldev $ */
3:
4:
5: --

Line 69: INSERT INTO qa_performance_temp (key, id)

65: BEGIN
66:
67: IF parse_integers(p_id_list, l_ids) > 0 THEN
68: FORALL i IN l_ids.FIRST .. l_ids.LAST
69: INSERT INTO qa_performance_temp (key, id)
70: VALUES (p_key, l_ids(i));
71: END IF;
72:
73: END add_ids;

Line 90: DELETE FROM qa_performance_temp

86: -- a temp table and there is not more than
87: -- a few dozen rows maximum at any time.
88: -- bso Sat Apr 16 14:31:23 PDT 2005
89: --
90: DELETE FROM qa_performance_temp
91: WHERE key = p_key;
92: END purge;
93:
94:

Line 122: INSERT INTO qa_performance_temp (key, name)

118: BEGIN
119:
120: IF p_names IS NOT NULL THEN
121: FORALL i IN p_names.FIRST .. p_names.LAST
122: INSERT INTO qa_performance_temp (key, name)
123: VALUES (p_key, p_names(i));
124: END IF;
125:
126: END add_names;

Line 140: END qa_performance_temp_pkg;

136: END purge_and_add_names;
137:
138: -- End 4345779.
139:
140: END qa_performance_temp_pkg;