DBA Data[Home] [Help]

PACKAGE: APPS.AHL_QA_RESULTS_PVT_W

Source


1 package ahl_qa_results_pvt_w AUTHID CURRENT_USER as
2   /* $Header: AHLWQARS.pls 115.2 2002/11/14 23:06:50 shkalyan noship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy ahl_qa_results_pvt.qa_results_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_VARCHAR2_TABLE_2000
5     , a2 JTF_NUMBER_TABLE
6     );
7   procedure rosetta_table_copy_out_p1(t ahl_qa_results_pvt.qa_results_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
8     , a1 out nocopy JTF_VARCHAR2_TABLE_2000
9     , a2 out nocopy JTF_NUMBER_TABLE
10     );
11 
12   procedure rosetta_table_copy_in_p3(t out nocopy ahl_qa_results_pvt.occurrence_tbl_type, a0 JTF_NUMBER_TABLE
13     , a1 JTF_NUMBER_TABLE
14     );
15   procedure rosetta_table_copy_out_p3(t ahl_qa_results_pvt.occurrence_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16     , a1 out nocopy JTF_NUMBER_TABLE
17     );
18 
19   procedure rosetta_table_copy_in_p5(t out nocopy ahl_qa_results_pvt.qa_context_tbl_type, a0 JTF_VARCHAR2_TABLE_100
20     , a1 JTF_VARCHAR2_TABLE_2000
21     );
22   procedure rosetta_table_copy_out_p5(t ahl_qa_results_pvt.qa_context_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
23     , a1 out nocopy JTF_VARCHAR2_TABLE_2000
24     );
25 
26   procedure submit_qa_results(p_api_version  NUMBER
27     , p_init_msg_list  VARCHAR2
28     , p_commit  VARCHAR2
29     , p_validation_level  NUMBER
30     , p_default  VARCHAR2
31     , p_module_type  VARCHAR2
32     , x_return_status out nocopy  VARCHAR2
33     , x_msg_count out nocopy  NUMBER
34     , x_msg_data out nocopy  VARCHAR2
35     , p_plan_id  NUMBER
36     , p_organization_id  NUMBER
37     , p_transaction_no  NUMBER
38     , p_specification_id  NUMBER
39     , p13_a0 JTF_NUMBER_TABLE
40     , p13_a1 JTF_VARCHAR2_TABLE_2000
41     , p13_a2 JTF_NUMBER_TABLE
42     , p14_a0 JTF_NUMBER_TABLE
43     , p14_a1 JTF_VARCHAR2_TABLE_2000
44     , p14_a2 JTF_NUMBER_TABLE
45     , p15_a0 JTF_VARCHAR2_TABLE_100
46     , p15_a1 JTF_VARCHAR2_TABLE_2000
47     , p_result_commit_flag  NUMBER
48     , p_id_or_value  VARCHAR2
49     , p_x_collection_id in out nocopy  NUMBER
50     , p19_a0 in out nocopy JTF_NUMBER_TABLE
51     , p19_a1 in out nocopy JTF_NUMBER_TABLE
52   );
53 end ahl_qa_results_pvt_w;