APPS.QA_AUDIT_PKG dependencies on QA_AUDIT_PKG

Line 1: PACKAGE BODY qa_audit_pkg AS

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;

Line 8: g_pkg_name CONSTANT VARCHAR2(30) := 'QA_AUDIT_PKG';

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,
12: p_audit_master_plan_id NUMBER,

Line 145: p_summary_params qa_audit_pkg.SummaryParamArray ,

141:
142: PROCEDURE copy_question_rows(
143: p_audit_bank_plan_id NUMBER,
144: p_audit_bank_org_id NUMBER,
145: p_summary_params qa_audit_pkg.SummaryParamArray ,
146: p_audit_question_plan_id NUMBER,
147: p_audit_question_org_id NUMBER,
148: p_collection_id NUMBER,
149: p_txn_header_id NUMBER) IS

Line 217: p_cat_summary_params qa_audit_pkg.CatSummaryParamArray ,

213:
214: PROCEDURE copy_question_rows(
215: p_audit_bank_plan_id NUMBER,
216: p_audit_bank_org_id NUMBER,
217: p_cat_summary_params qa_audit_pkg.CatSummaryParamArray ,
218: p_audit_question_plan_id NUMBER,
219: p_audit_question_org_id NUMBER,
220: p_collection_id NUMBER,
221: p_txn_header_id NUMBER) IS

Line 335: p_summary_params qa_audit_pkg.SummaryParamArray,

331:
332: PROCEDURE copy_questions(
333: p_audit_bank_plan_id NUMBER,
334: p_audit_bank_org_id NUMBER,
335: p_summary_params qa_audit_pkg.SummaryParamArray,
336: p_cat_summary_params qa_audit_pkg.CatSummaryParamArray,
337: p_audit_question_plan_id NUMBER,
338: p_audit_question_org_id NUMBER,
339: p_audit_num VARCHAR2,

Line 336: p_cat_summary_params qa_audit_pkg.CatSummaryParamArray,

332: PROCEDURE copy_questions(
333: p_audit_bank_plan_id NUMBER,
334: p_audit_bank_org_id NUMBER,
335: p_summary_params qa_audit_pkg.SummaryParamArray,
336: p_cat_summary_params qa_audit_pkg.CatSummaryParamArray,
337: p_audit_question_plan_id NUMBER,
338: p_audit_question_org_id NUMBER,
339: p_audit_num VARCHAR2,
340: x_count OUT NOCOPY NUMBER,

Line 509: END qa_audit_pkg;

505:
506: END copy_questions;
507:
508:
509: END qa_audit_pkg;