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:
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
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: );
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
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
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
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: );
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:
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
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
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
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
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
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
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