DBA Data[Home] [Help]

APPS.QA_AUDIT_PKG dependencies on DBMS_SQL

Line 5: g_qb_result_columns DBMS_SQL.VARCHAR2_TABLE;

1: PACKAGE BODY qa_audit_pkg AS
2: /* $Header: qaauditb.pls 120.1 2005/07/14 03:41 srhariha noship $ */
3:
4: -- Globals
5: g_qb_result_columns DBMS_SQL.VARCHAR2_TABLE;
6: g_que_result_columns DBMS_SQL.VARCHAR2_TABLE;
7: g_master_result_columns DBMS_SQL.VARCHAR2_TABLE;
8: g_pkg_name CONSTANT VARCHAR2(30) := 'QA_AUDIT_PKG';
9:

Line 6: g_que_result_columns DBMS_SQL.VARCHAR2_TABLE;

2: /* $Header: qaauditb.pls 120.1 2005/07/14 03:41 srhariha noship $ */
3:
4: -- Globals
5: g_qb_result_columns DBMS_SQL.VARCHAR2_TABLE;
6: g_que_result_columns DBMS_SQL.VARCHAR2_TABLE;
7: g_master_result_columns DBMS_SQL.VARCHAR2_TABLE;
8: g_pkg_name CONSTANT VARCHAR2(30) := 'QA_AUDIT_PKG';
9:
10:

Line 7: g_master_result_columns DBMS_SQL.VARCHAR2_TABLE;

3:
4: -- Globals
5: g_qb_result_columns DBMS_SQL.VARCHAR2_TABLE;
6: g_que_result_columns DBMS_SQL.VARCHAR2_TABLE;
7: g_master_result_columns DBMS_SQL.VARCHAR2_TABLE;
8: g_pkg_name CONSTANT VARCHAR2(30) := 'QA_AUDIT_PKG';
9:
10:
11: PROCEDURE init_globals(p_audit_bank_plan_id NUMBER,

Line 151: l_summ_params DBMS_SQL.VARCHAR2_TABLE;

147: p_audit_question_org_id NUMBER,
148: p_collection_id NUMBER,
149: p_txn_header_id NUMBER) IS
150:
151: l_summ_params DBMS_SQL.VARCHAR2_TABLE;
152: l_sql_string VARCHAR2(1000);
153: l_perf_key VARCHAR2(20);
154:
155: -- Bug 4345779. Audits Copy UI project.

Line 223: l_summ_param DBMS_SQL.VARCHAR2_TABLE;

219: p_audit_question_org_id NUMBER,
220: p_collection_id NUMBER,
221: p_txn_header_id NUMBER) IS
222:
223: l_summ_param DBMS_SQL.VARCHAR2_TABLE;
224: l_sql_string VARCHAR2(1000);
225:
226: -- Bug 4345779. Audits Copy UI project.
227: -- Code Review feedback incorporation. CR Ref 4.9.1