PACKAGE: APPS.QA_AUDIT_PKG_W

Source

1 package qa_audit_pkg_w as
2   /* $Header: qaaudwrs.pls 120.0 2005/06/09 09:41 srhariha noship $ */
3   procedure rosetta_table_copy_in_p2(t out nocopy qa_audit_pkg.summaryparamarray, a0 JTF_VARCHAR2_TABLE_200
4     );
5   procedure rosetta_table_copy_out_p2(t qa_audit_pkg.summaryparamarray, a0 out nocopy JTF_VARCHAR2_TABLE_200
6     );
7 
8   procedure rosetta_table_copy_in_p3(t out nocopy qa_audit_pkg.catsummaryparamarray, a0 JTF_VARCHAR2_TABLE_200
9     , a1 JTF_VARCHAR2_TABLE_200
10     , a2 JTF_VARCHAR2_TABLE_200
11     , a3 JTF_VARCHAR2_TABLE_200
12     );
13   procedure rosetta_table_copy_out_p3(t qa_audit_pkg.catsummaryparamarray, a0 out nocopy JTF_VARCHAR2_TABLE_200
14     , a1 out nocopy JTF_VARCHAR2_TABLE_200
15     , a2 out nocopy JTF_VARCHAR2_TABLE_200
16     , a3 out nocopy JTF_VARCHAR2_TABLE_200
17     );
18 
19   procedure copy_questions(p_audit_bank_plan_id  NUMBER
20     , p_audit_bank_org_id  NUMBER
21     , p2_a0 JTF_VARCHAR2_TABLE_200
22     , p3_a0 JTF_VARCHAR2_TABLE_200
23     , p3_a1 JTF_VARCHAR2_TABLE_200
24     , p3_a2 JTF_VARCHAR2_TABLE_200
25     , p3_a3 JTF_VARCHAR2_TABLE_200
26     , p_audit_question_plan_id  NUMBER
27     , p_audit_question_org_id  NUMBER
28     , p_audit_num  VARCHAR2
29     , x_count out nocopy  NUMBER
30     , x_msg_count out nocopy  NUMBER
31     , x_msg_data out nocopy  VARCHAR2
32     , x_return_status out nocopy  VARCHAR2
33   );
34 end qa_audit_pkg_w;